RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA734348", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA734348 · 15 ✖

analysis 1

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
717966 717966 PRJNA734348_P_NODE_28401_length_365_cov_3.037671_g27706_i0 PRJNA734348 28401 365 3.037671 11.08749915 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 422 2.29e-113   NTclustered gi|238617605|gb|FJ973380.1| 45107 g27706 i0 87.671 100.424657534247 365 42 100 3 1 365 1606 1245 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 36655 422 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
1994320 1994320 PRJNA734348_P_NODE_45942_length_297_cov_3.357143_g45245_i0 PRJNA734348 45942 297 3.357143 9.97071471 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 222 1.99e-53   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g45245 i0 93.878 37.2424242424242 147 9 49 0 151 297 3839 3693 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 11061 222 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
3269269 3269269 PRJNA734348_P_NODE_28883_length_362_cov_2.131488_g28188_i0 PRJNA734348 28883 362 2.131488 7.71598656 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 446 1.35e-120   NTclustered gi|238617605|gb|FJ973380.1| 45107 g28188 i0 88.95 98.5524861878453 362 38 99 2 1 361 1221 1581 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 35676 446 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
4545725 4545725 PRJNA734348_P_NODE_130744_length_241_cov_2.255952_g130046_i0 PRJNA734348 130744 241 2.255952 5.43684432 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 446 8.519999999999999e-121   NTclustered gi|512134091|gb|KC575315.1| 175275 g130046 i0 100 101.008298755187 241 0 100 0 1 241 152 392 Uncultured cercozoan clone A.3.2 18S ribosomal RNA gene, partial sequence blastn 24343 446 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
4547725 4547725 PRJNA734348_P_NODE_96424_length_250_cov_0.870056_g95726_i0 PRJNA734348 96424 250 0.870056 2.17514 Gymnophrys sp. ATCC 50923 646463 SAR_Eukaryotes SAR_Eukaryotes 401 1.9499999999999994e-107   NTclustered gi|238617604|gb|FJ973379.1| 646463 g95726 i0 95.6 100.548 250 11 100 0 1 250 1774 2023 Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence blastn 25137 401 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923
7097910 7097910 PRJNA734348_P_NODE_95886_length_250_cov_0.870056_g95188_i0 PRJNA734348 95886 250 0.870056 2.17514 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 254 5.78e-63   NTclustered gi|88792583|gb|DQ386164.1| 372086 g95188 i0 85 102.784 260 27 100 11 1 250 2486 2743 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 25696 254 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
9645918 9645918 PRJNA734348_P_NODE_140348_length_232_cov_2.119497_g139650_i0 PRJNA734348 140348 232 2.119497 4.91723304 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 163 9.19e-36   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g139650 i0 79.915 25.8405172413793 234 38 100 8 1 232 3766 3992 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 5995 163 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
9646567 9646567 PRJNA734348_P_NODE_35908_length_325_cov_4.123016_g35212_i0 PRJNA734348 35908 325 4.123016 13.399802 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 350 9.67e-92   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g35212 i0 86.364 66.0861538461538 330 34 99 11 2 325 3988 3664 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 21478 350 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
10921881 10921881 PRJNA734348_P_NODE_28569_length_364_cov_2.288660_g27874_i0 PRJNA734348 28569 364 2.28866 8.3307224 Cercomonas sp. HFCC53 458867 SAR_Eukaryotes SAR_Eukaryotes 651 0   NTclustered gi|161015705|gb|EF681939.1| 458867 g27874 i0 98.901 20.1346153846154 364 4 100 0 1 364 609 246 Cercomonas sp. HFCC53 28S ribosomal RNA gene, partial sequence blastn 7329 651 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. HFCC53
12197883 12197883 PRJNA734348_P_NODE_58370_length_281_cov_1.836538_g57673_i0 PRJNA734348 58370 281 1.836538 5.16067178 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 503 5.95e-138   NTclustered gi|88792583|gb|DQ386164.1| 372086 g57673 i0 98.932 88.2775800711744 281 3 100 0 1 281 1908 1628 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 24806 503 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
13472110 13472110 PRJNA734348_P_NODE_45331_length_299_cov_2.579646_g44634_i0 PRJNA734348 45331 299 2.579646 7.71314154 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 189 2.0299999999999993e-43   NTclustered gi|290760485|gb|GQ144688.1| 741089 g44634 i0 90.845 45.4280936454849 142 11 47 2 155 295 2153 2013 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 13583 189 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
14747808 14747808 PRJNA734348_P_NODE_77032_length_263_cov_1.621053_g76334_i0 PRJNA734348 77032 263 1.621053 4.26336939 Bodomorpha sp. HFCC 92 458884 SAR_Eukaryotes SAR_Eukaryotes 464 2.5999999999999993e-126   NTclustered gi|197723521|gb|EF681900.2| 458884 g76334 i0 98.479 16.4942965779468 263 4 100 0 1 263 297 559 Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence blastn 4338 464 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 92
22395571 22395571 PRJNA734348_P_NODE_35258_length_328_cov_3.141176_g34562_i0 PRJNA734348 35258 328 3.141176 10.30305728 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 331 3.54e-86   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g34562 i0 85.758 35.7530487804878 330 27 99 11 1 326 3696 4009 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 11727 331 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
24944275 24944275 PRJNA734348_P_NODE_22700_length_414_cov_2.346041_g22005_i0 PRJNA734348 22700 414 2.346041 9.71260974 Helkesimastix marina 645121 SAR_Eukaryotes SAR_Eukaryotes 625 1.8699999999999995e-174   NTclustered gi|237687967|gb|FJ410915.1| 645121 g22005 i0 96.834 51.7367149758454 379 2 89 2 45 414 1 378 Helkesimastix sp. ATCC 50328 18S ribosomal RNA gene, partial sequence blastn 21419 625 1 Eukaryota Sar   Cercozoa     Helkesimastigidae Helkesimastix Helkesimastix marina
24945524 24945524 PRJNA734348_P_NODE_88660_length_253_cov_2.066667_g87962_i0 PRJNA734348 88660 253 2.066667 5.22866751 Protaspis grandis 361427 SAR_Eukaryotes SAR_Eukaryotes 244 3.53e-60   NTclustered gi|290760486|gb|GQ144689.1| 361427 g87962 i0 85.062 93.1897233201581 241 35 95 1 1 240 1666 1906 Protaspis grandis large subunit ribosomal RNA gene, partial sequence blastn 23577 244 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Protaspis Protaspis grandis

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);;