RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA741997" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA741997 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
3273085 3273085 PRJNA741997_P_NODE_87463_length_242_cov_0.911243_g86343_i0 PRJNA741997 87463 242 0.911243 2.20520806 Thaumatomonas sp. TMT002 407209 SAR_Eukaryotes SAR_Eukaryotes 204 5.69e-48   NTclustered gi|193875699|gb|EU812202.1| 407209 g86343 i0 83.482 67.6157024793388 224 31 91 5 17 237 3 223 Thaumatomonas sp. TMT002 clone tshsp70-1 70 kDa heat shock protein mRNA, partial cds blastn 16363 204 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. TMT002
7576015 7576015 PRJNA741997_P_NODE_13186_length_673_cov_1.368333_g12111_i0 PRJNA741997 13186 673 1.368333 9.20888109 Thaumatomonas 45099 SAR_Eukaryotes SAR_Eukaryotes 573 1.1599999999999998e-158   NTclustered gi|31982985|gb|AY236717.1| 188940 g12111 i0 82.047 96.7741456166419 674 119 100 2 1 673 970 1642 Thaumatomonas sp. (SA) heat shock protein 90 (Hsp90) gene, partial cds blastn 65129 573 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
9649776 9649776 PRJNA741997_P_NODE_18088_length_547_cov_2.109705_g16977_i0 PRJNA741997 18088 547 2.109705 11.54008635 Thaumatomonas sp. TMT002 407209 SAR_Eukaryotes SAR_Eukaryotes 370 1.3100000000000002e-97   NTclustered gi|193875699|gb|EU812202.1| 407209 g16977 i0 80.493 90.0786106032907 487 91 89 4 1 485 490 6 Thaumatomonas sp. TMT002 clone tshsp70-1 70 kDa heat shock protein mRNA, partial cds blastn 49273 370 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. TMT002
12200894 12200894 PRJNA741997_P_NODE_48310_length_311_cov_1.390756_g47190_i0 PRJNA741997 48310 311 1.390756 4.32525116 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 333 9.27e-87   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g47190 i0 86.645 42.3890675241158 307 34 98 6 7 311 4020 3719 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 13183 333 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
13475127 13475127 PRJNA741997_P_NODE_16991_length_570_cov_1.193159_g15884_i0 PRJNA741997 16991 570 1.193159 6.8010063 Cercomonas sp. ATCC PRA-21 439943 SAR_Eukaryotes SAR_Eukaryotes 592 2.679999999999999e-164   NTclustered gi|160337396|gb|EF455796.1| 439943 g15884 i0 85.512 99.4526315789474 566 82 99 0 2 567 177 742 Cercomonas sp. ATCC PRA-21 beta-tubulin (btub) gene, partial cds blastn 56688 592 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. ATCC PRA-21
13475227 13475227 PRJNA741997_P_NODE_29851_length_401_cov_1.408537_g28731_i0 PRJNA741997 29851 401 1.408537 5.64823337 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 169 3.66e-37   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g28731 i0 79.835 6.29925187032419 243 39 60 9 1 239 2600 2836 Rosculus vulgaris isolate CCA sequence blastn 2526 169 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
13475283 13475283 PRJNA741997_P_NODE_38431_length_350_cov_1.664260_g37311_i0 PRJNA741997 38431 350 1.66426 5.82491 Gymnophrys sp. ATCC 50923 646463 SAR_Eukaryotes SAR_Eukaryotes 448 3.61e-121   NTclustered gi|302026152|gb|GQ377656.1| 646463 g37311 i0 89.714 100.137142857143 350 36 100 0 1 350 208 557 Gymnophrys sp. ATCC 50923 beta-tubulin (Btub) gene, partial cds blastn 35048 448 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923
18573330 18573330 PRJNA741997_P_NODE_66735_length_262_cov_1.629630_g65615_i0 PRJNA741997 66735 262 1.62963 4.2696306 Thaumatomonas seravini 188939 SAR_Eukaryotes SAR_Eukaryotes 250 7.899999999999999e-62   NTclustered gi|160337392|gb|EF455794.1| 188939 g65615 i0 84.231 80.2442748091603 260 37 98 4 1 258 585 842 Thaumatomonas seravini alpha-tubulin (atub) gene, partial cds blastn 21024 250 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas seravini
19049853 19049853 PRJNA741997_P_NODE_2395_length_1727_cov_2.483071_g2064_i0 PRJNA741997 2395 1727 2.483071 42.88263617 Thaumatomonas 45099 SAR_Eukaryotes SAR_Eukaryotes 917 0   NTclustered gi|31982985|gb|AY236717.1| 188940 g2064 i0 83.921 69.9033005211349 964 149 56 6 144 1104 862 1822 Thaumatomonas sp. (SA) heat shock protein 90 (Hsp90) gene, partial cds blastn 120723 917 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
19848472 19848472 PRJNA741997_P_NODE_45216_length_322_cov_3.437751_g44096_i0 PRJNA741997 45216 322 3.437751 11.06955822 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 305 2.1e-78   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g44096 i0 84.308 47.3229813664596 325 37 100 10 1 322 4004 3691 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 15238 305 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
22398751 22398751 PRJNA741997_P_NODE_18218_length_545_cov_1.307203_g17107_i0 PRJNA741997 18218 545 1.307203 7.12425635 Lecythium sp. 3678_261K 238773 SAR_Eukaryotes SAR_Eukaryotes 891 0   NTclustered gi|33089893|gb|AY283756.1| 238773 g17107 i0 96.147 99.1339449541284 545 21 100 0 1 545 668 124 Lecythium sp. 3678_261K actin gene, partial cds blastn 54028 891 1 Eukaryota Sar   Cercozoa Thecofilosea Tectofilosida Chlamydophryidae Lecythium Lecythium sp. 3678_261K
22398778 22398778 PRJNA741997_P_NODE_22158_length_480_cov_3.773956_g21040_i0 PRJNA741997 22158 480 3.773956 18.1149888 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 335 4.149999999999999e-87   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g21040 i0 83.038 44.7979166666667 395 42 81 18 1 390 3665 4039 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 21503 335 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
23674594 23674594 PRJNA741997_P_NODE_62759_length_271_cov_2.565657_g61639_i0 PRJNA741997 62759 271 2.565657 6.95293047 Gymnophrys sp. ATCC 50923 646463 SAR_Eukaryotes SAR_Eukaryotes 346 1.02e-90   NTclustered gi|238617604|gb|FJ973379.1| 646463 g61639 i0 90.146 101.014760147601 274 16 98 5 1 266 2594 2864 Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence blastn 27375 346 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923
24947804 24947804 PRJNA741997_P_NODE_23300_length_466_cov_1.692112_g22181_i0 PRJNA741997 23300 466 1.692112 7.88524192 Gymnophrys sp. ATCC 50923 646463 SAR_Eukaryotes SAR_Eukaryotes 392 2.3499999999999994e-104   NTclustered gi|238617638|gb|FJ973398.1| 646463 g22181 i0 81.974 101.489270386266 466 80 99 4 1 464 674 211 Gymnophrys sp. ATCC 50923 actin (act) gene, partial cds blastn 47294 392 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923

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