RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA876641", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 20 ✖

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA876641 · 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
2128404 2128404 PRJNA876641_P_NODE_1302_length_582_cov_1.622790_g1229_i0 PRJNA876641 1302 582 1.62279 9.4446378 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 211 1.83e-65   NR MES1912193.1 1215613 g1229 i0 58.9 3.60824742268041 175 72 90.2 0 525 1 31 205 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 2100 211 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
8506190 8506190 PRJNA876641_P_NODE_2447_length_453_cov_1.181579_g2373_i0 PRJNA876641 2447 453 1.181579 5.35255287 Thaumatomastix sp. NIES-2378 717846 SAR_Eukaryotes SAR_Eukaryotes 388 2.95e-103   NTclustered gi|302563030|dbj|AB546338.1| 717846 g2373 i0 82.34 52.6887417218543 453 66 98 11 8 453 277 722 Thaumatomastix sp. NIES-2378 EFL mRNA for elongation factor like, partial cds blastn 23868 388 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomastix Thaumatomastix sp. NIES-2378
8506279 8506279 PRJNA876641_P_NODE_8227_length_294_cov_2.090498_g8153_i0 PRJNA876641 8227 294 2.090498 6.14606412 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 252 2.51e-62   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g8153 i0 82.886 48.4761904761905 298 34 100 12 1 294 3701 3985 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 14252 252 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
9781034 9781034 PRJNA876641_P_NODE_1788_length_514_cov_1.882086_g1714_i0 PRJNA876641 1788 514 1.882086 9.67392204 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 254 6.41e-82   NR MES1911029.1 1215613 g1714 i0 75 8.91828793774319 168 42 98.1 0 506 3 1 168 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 4584 254 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
12332284 12332284 PRJNA876641_P_NODE_20210_length_245_cov_0.895349_g20136_i0 PRJNA876641 20210 245 0.895349 2.19360505 Thaumatomonas sp. TMT002 407209 SAR_Eukaryotes SAR_Eukaryotes 292 1.2e-74   NTclustered gi|193875699|gb|EU812202.1| 407209 g20136 i0 88.163 70.5183673469388 245 29 100 0 1 245 267 23 Thaumatomonas sp. TMT002 clone tshsp70-1 70 kDa heat shock protein mRNA, partial cds blastn 17277 292 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. TMT002
13992331 13992331 PRJNA876641_P_NODE_12231_length_269_cov_1.571429_g12157_i0 PRJNA876641 12231 269 1.571429 4.22714401 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 57 4.95e-7   NR MES1912041.1 1215613 g12157 i0 44.3 2.25278810408922 70 36 78.1 1 214 5 143 209 MES1912041.1 hypothetical protein [Cercozoa sp. M6MM] diamond 606 57 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19979850 19979850 PRJNA876641_P_NODE_18856_length_247_cov_0.885057_g18782_i0 PRJNA876641 18856 247 0.885057 2.18609079 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 425 1.14e-114   NTclustered gi|512134091|gb|KC575315.1| 175275 g18782 i0 97.59 100.611336032389 249 4 100 2 1 247 49 297 Uncultured cercozoan clone A.3.2 18S ribosomal RNA gene, partial sequence blastn 24851 425 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
22530057 22530057 PRJNA876641_P_NODE_7738_length_302_cov_1.772926_g7664_i0 PRJNA876641 7738 302 1.772926 5.35423652 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 289 1.97e-73   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g7664 i0 84.868 12.0695364238411 304 26 99 11 3 302 4009 3722 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 3645 289 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
23805416 23805416 PRJNA876641_P_NODE_22679_length_242_cov_0.911243_g22605_i0 PRJNA876641 22679 242 0.911243 2.20520806 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 195 3.42e-45   NTclustered gi|300676720|gb|GQ377713.1| 323453 g22605 i0 87.952 15.4132231404959 166 18 68 2 2 166 158 322 Heteromita sp. PRA-74 gcr5-like mRNA, partial sequence blastn 3730 195 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
25079413 25079413 PRJNA876641_P_NODE_840_length_694_cov_1.383253_g770_i0 PRJNA876641 840 694 1.383253 9.59977582 Cercomonas sp. ATCC 50316 45110 SAR_Eukaryotes SAR_Eukaryotes 311 1.04e-79   NTclustered gi|27734378|gb|AY099144.1| 45110 g770 i0 92.237 166.276657060519 219 17 32 0 412 630 427 209 Cercomonas ATCC50316 isolate pub6 polyubiquitin gene, partial cds blastn 115396 311 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. ATCC 50316
25465166 25465166 PRJNA876641_P_NODE_21920_length_243_cov_0.905882_g21846_i0 PRJNA876641 21920 243 0.905882 2.20129326 Thaumatomonas 45099 SAR_Eukaryotes SAR_Eukaryotes 444 3.09e-120   NTclustered gi|33309605|gb|AF411259.1| 188939 g21846 i0 99.588 99.4979423868313 243 1 100 0 1 243 1614 1372 Thaumatomonas seravini 18S ribosomal RNA gene, complete sequence blastn 24178 444 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas seravini
27244849 27244849 PRJNA876641_P_NODE_22763_length_242_cov_0.911243_g22689_i0 PRJNA876641 22763 242 0.911243 2.20520806 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.29e-13   NR MES1916397.1 1215613 g22689 i0 70.3 0.793388429752066 64 17 79.3 1 51 242 316 377 MES1916397.1 hypothetical protein [Cercozoa sp. M6MM] diamond 192 75.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27750447 27750447 PRJNA876641_P_NODE_15424_length_252_cov_1.357542_g15350_i0 PRJNA876641 15424 252 1.357542 3.42100584 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 101 5.48e-24   NR MES1912414.1 1215613 g15350 i0 57.6 2 85 34 98.8 1 250 2 76 160 MES1912414.1 hypothetical protein [Cercozoa sp. M6MM] diamond 504 101 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27971193 27971193 PRJNA876641_P_NODE_13785_length_261_cov_1.127660_g13711_i0 PRJNA876641 13785 261 1.12766 2.9431926 Thaumatomastix sp. NIES-2378 717846 SAR_Eukaryotes SAR_Eukaryotes 144 2.01e-39   NR BAJ14652.1 717846 g13711 i0 78.2 1 87 19 100 0 1 261 250 336 BAJ14652.1 elongation factor like, partial [Thaumatomastix sp. NIES-2378] diamond 261 144 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomastix Thaumatomastix sp. NIES-2378
27971210 27971210 PRJNA876641_P_NODE_2685_length_439_cov_1.262295_g2611_i0 PRJNA876641 2685 439 1.262295 5.54147505 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.35e-9   NR MES1910790.1 1215613 g2611 i0 46.8 1.6879271070615 79 34 54 2 10 246 80 150 MES1910790.1 hypothetical protein [Cercozoa sp. M6MM] diamond 741 66.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28729084 28729084 PRJNA876641_P_NODE_5007_length_352_cov_0.949821_g4933_i0 PRJNA876641 5007 352 0.949821 3.34336992 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 167 4.8999999999999995e-49   NR ADK26624.1 323453 g4933 i0 70.1 0.997159090909091 117 35 99.7 0 351 1 154 270 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 351 167 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
28981817 28981817 PRJNA876641_P_NODE_11608_length_273_cov_1.350000_g11534_i0 PRJNA876641 11608 273 1.35 3.6855 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 83.2 3.12e-17   NR MES1908571.1 1215613 g11534 i0 55.8 0.945054945054945 86 37 94.5 1 4 261 64 148 MES1908571.1 hypothetical protein [Cercozoa sp. M6MM] diamond 258 83.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29494840 29494840 PRJNA876641_P_NODE_16090_length_251_cov_0.865169_g16016_i0 PRJNA876641 16090 251 0.865169 2.17157419 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 50.8 5.65e-5   NR MES1907382.1 1215613 g16016 i0 43.6 1.70916334661355 55 31 65.7 0 5 169 431 485 MES1907382.1 hypothetical protein [Cercozoa sp. M6MM] diamond 429 51.2 0.9921875 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31477502 31477502 PRJNA876641_P_NODE_7356_length_308_cov_1.310638_g7282_i0 PRJNA876641 7356 308 1.310638 4.03676504 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 53.9 3.22e-6   NR MES1913617.1 1215613 g7282 i0 40 0.681818181818182 70 31 63.3 2 68 262 111 174 MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] diamond 210 53.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31920207 31920207 PRJNA876641_P_NODE_6037_length_329_cov_1.503906_g5963_i0 PRJNA876641 6037 329 1.503906 4.94785074 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 152 1.9e-43   NR ADK26624.1 323453 g5963 i0 67.9 0.993920972644377 109 35 99.4 0 1 327 86 194 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 327 152 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74

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