RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJEB12982" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 20 ✖

tax_clade 1

bioproject 1

  • PRJEB12982 · 20 ✖

analysis 1

  • blastn · 20 ✖

tax_kingdom 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
20928 20928 PRJEB12982_P_NODE_15921_length_172_cov_1.983740_g15758_i0 PRJEB12982 15921 172 1.98374 3.4120328 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 180 6.34e-41   NTclustered gi|300521444|gb|GQ377690.1| 151077 g15758 i0 85.549 26.2732558139535 173 23 100 2 1 172 748 577 Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence blastn 4519 180 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
1295249 1295249 PRJEB12982_P_NODE_6742_length_281_cov_1.487069_g6579_i0 PRJEB12982 6742 281 1.487069 4.17866389 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 278 3.9300000000000005e-70   NTclustered gi|300676719|gb|GQ377693.1| 151077 g6579 i0 84.588 4.06049822064057 279 43 99 0 1 279 18 296 Chilodonella uncinata gcr5-like mRNA, partial sequence blastn 1141 278 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
2570822 2570822 PRJEB12982_P_NODE_1783_length_585_cov_1.921642_g1627_i0 PRJEB12982 1783 585 1.921642 11.2416057 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 769 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g1627 i0 90.525 59.782905982906 591 43 100 12 1 585 1751 2334 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 34973 769 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
3847041 3847041 PRJEB12982_P_NODE_10064_length_223_cov_0.862069_g9901_i0 PRJEB12982 10064 223 0.862069 1.92241387 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 135 1.9100000000000003e-27   NTclustered gi|118360339|ref|XM_001013407.1| 312017 g9901 i0 80.328 2.60089686098655 183 32 81 4 1 181 211 391 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 580 135 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
5123476 5123476 PRJEB12982_P_NODE_9545_length_229_cov_1.700000_g9382_i0 PRJEB12982 9545 229 1.7 3.893 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 267 6.7e-67   NTclustered gi|300521444|gb|GQ377690.1| 151077 g9382 i0 88.584 2.5109170305676898 219 25 96 0 10 228 178 396 Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence blastn 575 267 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
7363372 7363372 PRJEB12982_P_NODE_18426_length_165_cov_0.879310_g18263_i0 PRJEB12982 18426 165 0.87931 1.4508615 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 217 4.619999999999999e-52   NTclustered gi|21215206|gb|AF510205.1| 5947 g18263 i0 90.303 53.630303030303 165 16 100 0 1 165 991 1155 Oxytricha granulifera beta-tubulin gene, complete cds blastn 8849 217 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha granulifera
7673195 7673195 PRJEB12982_P_NODE_20327_length_162_cov_0.902655_g20164_i0 PRJEB12982 20327 162 0.902655 1.4623011 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 128 2.18e-25   NTclustered gi|47176309|gb|AY617889.1| 94289 g20164 i0 81.761 2.94444444444444 159 23 96 6 1 156 355 510 Sterkiella histriomuscorum clone UGC1O0006_D09_R genomic sequence blastn 477 128 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
8947869 8947869 PRJEB12982_P_NODE_14688_length_181_cov_1.545455_g14525_i0 PRJEB12982 14688 181 1.545455 2.79727355 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 209 8.62e-50   NTclustered gi|2070286681|gb|MT506240.1| 5909 g14525 i0 87.709 35.2541436464088 179 22 99 0 3 181 1383 1205 Tetrahymena rostrata strain TR01 histone H3 (H3II) and Histone H4 (H4II) genes, complete cds blastn 6381 209 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
11189035 11189035 PRJEB12982_P_NODE_5049_length_333_cov_1.623239_g4886_i0 PRJEB12982 5049 333 1.623239 5.40538587 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 163 1.39e-35   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g4886 i0 94.34 3.53153153153153 106 6 32 0 1 106 2977 3082 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 1176 163 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
11499109 11499109 PRJEB12982_P_NODE_9170_length_235_cov_1.096774_g9007_i0 PRJEB12982 9170 235 1.096774 2.5774189 Trithigmostoma cucullulus 1346499 SAR_Eukaryotes SAR_Eukaryotes 412 8.39e-111   NTclustered gi|759083539|gb|KM222156.1| 1346499 g9007 i0 98.298 99.8595744680851 235 4 100 0 1 235 1142 1376 Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence blastn 23467 412 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Trithigmostoma Trithigmostoma cucullulus
12464839 12464839 PRJEB12982_P_NODE_4890_length_339_cov_1.634483_g4727_i0 PRJEB12982 4890 339 1.634483 5.54089737 Stylonychia 5948 SAR_Eukaryotes SAR_Eukaryotes 270 8.119999999999999e-68   NTclustered gi|10160|emb|X06874.1| 5949 g4727 i0 82.867 81.6961651917404 286 46 84 3 52 336 188 471 Stylonychia macronuclear beta-2 tubulin gene blastn 27695 272 0.992647058823529 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
16597784 16597784 PRJEB12982_P_NODE_18934_length_164_cov_0.886957_g18771_i0 PRJEB12982 18934 164 0.886957 1.45460948 Opisthonecta henneguyi 6026 SAR_Eukaryotes SAR_Eukaryotes 191 2.78e-44   NTclustered gi|21898543|gb|AY101354.1| 6026 g18771 i0 87.73 0.99390243902439 163 20 99 0 1 163 1450 1288 Opisthonecta henneguyi actin I gene, complete cds blastn 163 191 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta henneguyi
16597814 16597814 PRJEB12982_P_NODE_2094_length_537_cov_19.391393_g1935_i0 PRJEB12982 2094 537 19.391393 104.13178041 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 688 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g1935 i0 97.512 72.7169459962756 402 10 75 0 1 402 1001 1402 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 39049 688 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
17872641 17872641 PRJEB12982_P_NODE_3615_length_403_cov_1.689266_g3452_i0 PRJEB12982 3615 403 1.689266 6.80774198 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 501 3.19e-137   NTclustered gi|110645063|gb|DQ665311.1| 151077 g3452 i0 89.163 55.4168734491315 406 38 100 4 1 403 240 642 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 22333 501 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
19146357 19146357 PRJEB12982_P_NODE_116_length_1913_cov_3.699571_g95_i0 PRJEB12982 116 1913 3.699571 70.77279323 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 128 3.1899999999999998e-24   NTclustered gi|2026161419|ref|NC_054370.1| 5974 g95 i0 73.385 5.18400418191323 387 85 20 17 1 379 48513 48137 Halteria grandinella mitochondrion, complete genome blastn 9917 128 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
19146404 19146404 PRJEB12982_P_NODE_15496_length_175_cov_1.769841_g15333_i0 PRJEB12982 15496 175 1.769841 3.09722175 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 252 1.3499999999999999e-62   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g15333 i0 92.614 6.39428571428571 176 11 100 2 1 175 345 171 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 1119 252 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
22662619 22662619 PRJEB12982_P_NODE_17218_length_167_cov_0.864407_g17055_i0 PRJEB12982 17218 167 0.864407 1.44355969 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 303 3.5e-78   NTclustered gi|1171734672|gb|KY855540.1| 63134 g17055 i0 99.401 100.059880239521 167 1 100 0 1 167 1587 1421 Colpoda maupasi isolate KWBLF1 small subunit ribosomal RNA gene, partial sequence blastn 16710 303 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda maupasi
22972848 22972848 PRJEB12982_P_NODE_12979_length_194_cov_1.758621_g12816_i0 PRJEB12982 12979 194 1.758621 3.41172474 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 158 3.45e-34   NTclustered gi|118596715|dbj|AB275856.1| 153251 g12816 i0 82.011 43.8247422680412 189 30 96 3 1 187 583 397 Cryptocaryon irritans EF-1 alpha mRNA for elongation factor-1 alpha isoform-2, partial cds, lab strain 1 blastn 8502 158 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
22973017 22973017 PRJEB12982_P_NODE_5939_length_304_cov_1.000000_g5776_i0 PRJEB12982 5939 304 1 3.04 Pseudomicrothorax dubius 39564 SAR_Eukaryotes SAR_Eukaryotes 60.2 1.69e-4   NTclustered gi|1204322226|gb|AF039086.2| 39564 g5776 i0 100 0.105263157894737 32 0 11 0 209 240 869 900 Pseudomicrothorax dubius articulin 1 mRNA, complete cds blastn 32 60.2 1 Eukaryota Sar   Ciliophora Nassophorea Microthoracida Pseudomicrothoracidae Pseudomicrothorax Pseudomicrothorax dubius
24246899 24246899 PRJEB12982_P_NODE_9240_length_234_cov_1.102703_g9077_i0 PRJEB12982 9240 234 1.102703 2.58032502 Epistylis sp. 1 JI2016080701 2042498 SAR_Eukaryotes SAR_Eukaryotes 433 6.41e-117   NTclustered gi|1251948965|gb|KY675198.1| 2042498 g9077 i0 100 98.6111111111111 234 0 100 0 1 234 1406 1639 Epistylis sp. 1 JI2016080701 large subunit ribosomal RNA gene, partial sequence blastn 23075 433 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis sp. 1 JI2016080701

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;