Difference between revisions of "Sandbox/Publication pages"

AntWiki: The Ants --- Online
Jump to navigation Jump to search
(3 intermediate revisions by the same user not shown)
Line 208: Line 208:
 
|order by = Karyotype.Diploid
 
|order by = Karyotype.Diploid
 
}}
 
}}
 +
 +
<pScatter size=700x550 textsize=10 angle=90 axiscolor=#000000 titlesize=12 titlecolor=#000000 title='Antennal Count vs. Diploid Karyotype Number' xtitle='Diploid Number' ytitle='Antennal Count'>
 +
10,12
 +
10,8
 +
10,11
 +
12,12
 +
12,12
 +
12,12
 +
14,12
 +
14,10
 +
14,12
 +
14,12
 +
14,11
 +
16,12
 +
16,9
 +
16,12
 +
16,11
 +
16,10
 +
18,9
 +
18,12
 +
18,12
 +
18,11
 +
18,12
 +
18,12
 +
18,9
 +
18,11
 +
18,12
 +
18,11
 +
18,11
 +
18,12
 +
18,10
 +
18,11
 +
18,12
 +
18,9
 +
18,10
 +
18,11
 +
18,11
 +
18,12
 +
18,11
 +
18,10
 +
18,11
 +
18,11
 +
18,12
 +
18,12
 +
18,12
 +
18,10
 +
18,11
 +
18,12
 +
18,10
 +
18,11
 +
18,12
 +
18,12
 +
18,9
 +
18,10
 +
18,12
 +
18,9
 +
18,10
 +
18,10
 +
18,10
 +
18,12
 +
18,9
 +
18,12
 +
18,11
 +
18,12
 +
18,11
 +
18,9
 +
18,10
 +
18,11
 +
18,12
 +
18,9
 +
18,12
 +
20,9
 +
20,11
 +
20,12
 +
20,9
 +
20,11
 +
20,10
 +
20,10
 +
20,11
 +
20,12
 +
20,10
 +
20,11
 +
20,11
 +
20,11
 +
20,12
 +
20,12
 +
20,10
 +
20,11
 +
20,11
 +
20,12
 +
20,10
 +
20,12
 +
20,10
 +
20,12
 +
20,10
 +
20,12
 +
20,9
 +
20,10
 +
20,10
 +
20,11
 +
20,9
 +
20,10
 +
20,12
 +
20,11
 +
20,10
 +
20,12
 +
20,9
 +
20,10
 +
20,12
 +
20,10
 +
20,12
 +
20,12
 +
20,12
 +
20,9
 +
20,11
 +
20,12
 +
20,9
 +
20,11
 +
20,12
 +
20,11
 +
20,9
 +
20,12
 +
20,11
 +
20,9
 +
20,11
 +
20,12
 +
21,9
 +
21,11
 +
21,10
 +
21,12
 +
22,11
 +
22,11
 +
22,11
 +
22,12
 +
22,12
 +
22,11
 +
22,10
 +
22,12
 +
22,11
 +
22,11
 +
22,11
 +
22,9
 +
22,12
 +
22,9
 +
22,12
 +
22,10
 +
22,12
 +
22,10
 +
22,12
 +
22,9
 +
22,10
 +
22,12
 +
22,10
 +
22,12
 +
22,10
 +
22,10
 +
22,11
 +
23,12
 +
24,12
 +
24,12
 +
24,12
 +
24,12
 +
24,11
 +
24,11
 +
24,10
 +
26,12
 +
26,11
 +
26,10
 +
28,11
 +
28,12
 +
28,12
 +
28,10
 +
28,12
 +
28,9
 +
28,12
 +
30,12
 +
30,8
 +
30,12
 +
30,12
 +
30,12
 +
30,9
 +
30,12
 +
30,10
 +
30,9
 +
30,12
 +
30,12
 +
30,12
 +
30,7
 +
30,11
 +
30,8
 +
30,12
 +
30,11
 +
30,11
 +
30,9
 +
30,11
 +
30,11
 +
30,10
 +
30,10
 +
30,11
 +
30,12
 +
30,11
 +
30,12
 +
32,11
 +
32,10
 +
32,12
 +
32,12
 +
32,12
 +
32,9
 +
32,7
 +
32,8
 +
32,11
 +
32,9
 +
32,11
 +
32,10
 +
33,11
 +
33,12
 +
34,11
 +
34,12
 +
34,12
 +
34,11
 +
34,12
 +
34,12
 +
34,12
 +
34,12
 +
34,10
 +
35,12
 +
35,12
 +
35,11
 +
35,10
 +
36,12
 +
36,11
 +
36,9
 +
36,12
 +
36,11
 +
36,12
 +
36,12
 +
36,12
 +
36,11
 +
36,10
 +
36,10
 +
36,12
 +
36,12
 +
38,10
 +
38,11
 +
38,12
 +
38,12
 +
38,12
 +
38,12
 +
38,9
 +
38,10
 +
38,12
 +
38,12
 +
38,11
 +
38,12
 +
38,12
 +
38,11
 +
38,12
 +
38,12
 +
38,9
 +
38,12
 +
39,12
 +
39,12
 +
40,12
 +
40,12
 +
40,12
 +
40,12
 +
40,11
 +
40,11
 +
40,12
 +
40,12
 +
40,12
 +
42,11
 +
42,12
 +
42,10
 +
42,12
 +
42,12
 +
42,10
 +
42,9
 +
42,12
 +
42,11
 +
43,12
 +
44,12
 +
44,12
 +
44,7
 +
44,7
 +
44,12
 +
44,7
 +
44,12
 +
44,12
 +
44,12
 +
46,12
 +
46,12
 +
46,7
 +
46,12
 +
46,12
 +
48,12
 +
48,12
 +
49,12
 +
49,12
 +
49,11
 +
50,11
 +
50,12
 +
50,12
 +
50,12
 +
52,12
 +
52,12
 +
52,12
 +
58,12
 +
66,11
 +
66,12
 +
66,12
 +
68,12
 +
</pScatter>
 +
 +
<!--{{#cargo_query:
 +
tables=TaxonName, Karyotype, WorkerMorphology, WorkerMorphology__AntennalSegmentCount
 +
|join on=Karyotype._pageName=TaxonName._pageName, Karyotype._pageName=WorkerMorphology._pageName, WorkerMorphology._ID=WorkerMorphology__AntennalSegmentCount._rowID
 +
|fields= Karyotype.Diploid = Diploid, WorkerMorphology__AntennalSegmentCount._value = AntennalCount
 +
|where= Karyotype.Diploid HOLDS NOT "" and WorkerMorphology.AntennalSegmentCount HOLDS NOT ""
 +
|order by = Karyotype.Diploid
 +
|format=template
 +
|template=CargoQueryToScatterPlot
 +
}}.-->

Revision as of 22:45, 13 January 2020

Potential formatting idea for the header of a publication source page. This is sourced from wikisource: [1]

original has this format:

header

| title      = 
| author     = 
| translator = 
| section    = 
| previous   = 
| next       = 
| year       = 
| notes      = 


can potentially make a new set: header

| title      = 
| author     = 
| year       = 
| pages      = 
| journal    = 
| book       = 
| report     = 
| ?          =

Current Taxobox

Temnothorax affinis
Scientific classification
Kingdom: Animalia
Phylum: Arthropoda
Class: Insecta
Order: Hymenoptera
Family: Formicidae
Subfamily: Myrmicinae
Tribe: Crematogastrini
Genus: Temnothorax
Species: T. affinis
Binomial name
Temnothorax affinis
(Mayr, 1855)

Temnothorax affinis casent0173201 profile 1.jpg

Temnothorax affinis casent0173201 dorsal 1.jpg

Specimen labels

Synonyms
Leptothorax tirolensis
Scientific classification (junior synonym of Temnothorax affinis)
Kingdom: Animalia
Phylum: Arthropoda
Class: Insecta
Order: Hymenoptera
Family: Formicidae
Subfamily: Myrmicinae
Tribe: Crematogastrini
Genus: Temnothorax
Species: Leptothorax tirolensis
Gredler, 1858

New Taxobox

Sandbox/Publication pages
Temnothorax affinis casent0173201 head 1.jpg
Temnothorax affinis casent0173201 profile 1.jpg
Temnothorax affinis casent0173201 dorsal 1.jpg
Specimen labels
Classification
Subfamily: Myrmicinae
Tribe: Crematogastrini
Genus: Temnothorax
Species
Temnothorax affinis
(Mayr, 1855)
Synonyms
Additional Details
Name Gender:
DOI:
Page:
Figures:
Type Material:
ZooBank ID:
Changed Comb.: yes
Original Genus: Leptothorax
Original Spelling: affinis
Sandbox/Publication pages
Scientific Classification
Junior synonym, see Temnothorax affinis
Classification
Genus: Temnothorax
Species
Leptothorax tirolensis
Gredler, 1858
Additional Details
Name Gender:
DOI:
Page:
Figures:
Type Material:
ZooBank ID:
Changed Comb.:
Original Genus: Leptothorax
Original Spelling: tirolensis

This taxon is not in use as it is currently considered to be a junior synonym of Temnothorax affinis.

Karyotype Data

Known Haploid Counts:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `wiki_cargo__Karyotype__Haploid`.`_value` AS `Haploid` FROM `wiki_cargo__Karyotype` LEFT OUTER JOIN `wiki_cargo__TaxonName` ON ((`wiki_cargo__Karyotype`.`_pageName`=`wiki_cargo__TaxonName`.`_pageName`)) LEFT OUTER JOIN `wiki_cargo__Karyotype__Haploid` ON ((`wiki_cargo__Karyotype`.`_ID`=`wiki_cargo__Karyotype__Haploid`.`_rowID`)) WHERE `wiki_cargo__Karyotype`.`_ID` NOT IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Haploid` WHERE _value = "" AND `wiki_cargo__TaxonName`.`Subfamily` = ") Myrmeciinae" GROUP BY `wiki_cargo__Karyotype__Haploid`.`_value` ORDER BY `wiki_cargo__Karyotype__Haploid`.`_value` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 (localhost)

.

Haploid Count Details:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `Haploid__full` AS `Haploid`,CONCAT ("", `wiki_cargo__Karyotype`.`_pageName`, "") AS `Taxon` FROM `wiki_cargo__Karyotype` LEFT OUTER JOIN `wiki_cargo__TaxonName` ON ((`wiki_cargo__Karyotype`.`_pageName`=`wiki_cargo__TaxonName`.`_pageName`)) WHERE `wiki_cargo__Karyotype`.`_ID` NOT IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Haploid` WHERE _value = "" AND `wiki_cargo__TaxonName`.`Subfamily` = ") Myrmeciinae" ORDER BY `wiki_cargo__Karyotype`.`Haploid__full` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 (localhost)

.

Known Diploid Counts:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `wiki_cargo__Karyotype__Diploid`.`_value` AS `Diploid` FROM `wiki_cargo__Karyotype` LEFT OUTER JOIN `wiki_cargo__TaxonName` ON ((`wiki_cargo__Karyotype`.`_pageName`=`wiki_cargo__TaxonName`.`_pageName`)) LEFT OUTER JOIN `wiki_cargo__Karyotype__Diploid` ON ((`wiki_cargo__Karyotype`.`_ID`=`wiki_cargo__Karyotype__Diploid`.`_rowID`)) WHERE `wiki_cargo__Karyotype`.`_ID` NOT IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Diploid` WHERE _value = "" AND `wiki_cargo__TaxonName`.`Subfamily` = ") Myrmeciinae" GROUP BY `wiki_cargo__Karyotype__Diploid`.`_value` ORDER BY `wiki_cargo__Karyotype__Diploid`.`_value` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 (localhost)

.

Diploid Count Details:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `Diploid__full` AS `Diploid`,CONCAT ("", `wiki_cargo__Karyotype`.`_pageName`, "") AS `Taxon` FROM `wiki_cargo__Karyotype` LEFT OUTER JOIN `wiki_cargo__TaxonName` ON ((`wiki_cargo__Karyotype`.`_pageName`=`wiki_cargo__TaxonName`.`_pageName`)) WHERE `wiki_cargo__Karyotype`.`_ID` NOT IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Diploid` WHERE _value = "" AND `wiki_cargo__TaxonName`.`Subfamily` = ") Myrmeciinae" ORDER BY `wiki_cargo__Karyotype`.`Diploid__full` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 (localhost)

.

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `Diploid__full` AS `Diploid`,`AntennalSegmentCount__full` AS `AntennalCount`,`wiki_cargo__WorkerMorphology`.`_pageName` AS `Taxon` FROM `wiki_cargo__WorkerMorphology` LEFT OUTER JOIN `wiki_cargo__Karyotype` ON ((`wiki_cargo__WorkerMorphology`.`_pageName`=`wiki_cargo__Karyotype`.`_pageName`)) WHERE `wiki_cargo__Karyotype`.`_ID` IN (SELECT _rowID FROM `wiki_cargo__Karyotype__Diploid` WHERE _value = NOT ) "" GROUP BY `wiki_cargo__WorkerMorphology`.`_pageName` ORDER BY `wiki_cargo__Karyotype`.`Diploid__full` LIMIT 5000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT ) "" GROUP BY `wiki_cargo__WorkerMorphology`.`_pageName` ORDER BY `wiki_car' at line 1 (localhost)

pChart