QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '-1450' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '-1450' AND is_custom_child_node = 1)
Pancrustacea (NCBI:197562, mID:-1450)
There are 2 calibrations directly attached to Pancrustacea:
Calibrations within clade members
QUERY:
SELECT DISTINCT TRIM(C.NodeName) AS NodeName, TRIM(C.ShortName) AS ShortName, C.*, img.image, img.caption AS image_caption, ht.DisplayOrder AS ht_display_order
FROM (
SELECT CF.CalibrationID, V . *
FROM View_Fossils V
JOIN Link_CalibrationFossil CF ON CF.FossilID = V.FossilID
) AS J
JOIN View_Calibrations C ON J.CalibrationID = C.CalibrationID
AND C.CalibrationID IN (418) AND C.CalibrationID IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
LEFT JOIN publication_images img ON img.PublicationID = C.PublicationID
LEFT JOIN L_HigherTaxa ht ON ht.HigherTaxon = C.HigherTaxon
ORDER BY ht_display_order, NodeName, ShortName
-
Allotriocarida
— (1)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '6657' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '6657' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
… Crustacea
— (17)
show as search results
show all
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE clade_root_multitree_id = '-1483' AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
QUERY:
SELECT DISTINCT calibration_id FROM calibrations_by_NCBI_clade WHERE (clade_root_multitree_id = '-1483' AND is_direct_relationship = 1 AND is_custom_child_node != 1) AND calibration_id IN (SELECT CalibrationID FROM calibrations WHERE PublicationStatus = 4)
-
… Hexapoda
— (35)
show as search results
Notoptera – Wolfe et al. 2016
Aeshnidae – Kohli et al., 2016
Amphiesmenoptera – Wolfe et al. 2016
Anisoptera – Kohli et al., 2016
Antliophora – Wolfe et al. 2016
Aparaglossata – Wolfe et al. 2016
Blaberidae – Evangelista et al. 2017
Cariblattoides + Cariblatta – Evangelista et al. 2017
Cavilabiata – Kohli et al., 2016
Corduliidae – Kohli et al., 2016
Ectobius – Evangelista et al. 2017
Epiprocta – Kohli et al., 2016
Eukinolabia – Wolfe et al. 2016
Gomphidae – Kohli et al., 2016
Libellulidae – Kohli et al., 2016
Macromiidae – Kohli et al., 2016
Mecoptera – Wolfe et al. 2016
Megaloptera – Wolfe et al. 2016
Microcoryphia – Wolfe et al. 2016
Neoptera – Wolfe et al. 2016
Neuroptera – Wolfe et al. 2016
Neuropterida – Wolfe et al. 2016
Odonata – Kohli et al., 2016
Odonata – Wolfe et al. 2016
Orthoptera – Wolfe et al. 2016
Palaeoptera – Wolfe et al. 2016
Phasmatodea – Wolfe et al. 2016
Plecoptera – Wolfe et al. 2016
Polyneoptera – Wolfe et al. 2016
Psocodea – Wolfe et al. 2016
Pterygota – Wolfe et al. 2016
Thysanoptera – Wolfe et al. 2016
Trichoptera – Wolfe et al. 2016
Zygentoma – Wolfe et al. 2016
Zygoptera – Kohli et al., 2016
show all