RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA1087264", 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 · 12 ✖

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA1087264 · 12 ✖

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
194048 194048 PRJNA1087264_P_NODE_19181_length_163_cov_0.894737_g19099_i0 PRJNA1087264 19181 163 0.894737 1.45842131 Thaumatomonas seravini 188939 SAR_Eukaryotes SAR_Eukaryotes 176 7.73e-40   NTclustered gi|160337323|gb|EF455755.1| 188939 g19099 i0 87.919 74.4233128834356 149 18 91 0 3 151 714 566 Thaumatomonas seravini actin gene, partial cds blastn 12131 176 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas seravini
194132 194132 PRJNA1087264_P_NODE_741_length_774_cov_2.579310_g672_i0 PRJNA1087264 741 774 2.57931 19.9638594 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 998 0   NTclustered gi|300676732|gb|GQ377662.1| 188950 g672 i0 91.46 85.7351421188631 726 62 94 0 1 726 121 846 Bodomorpha minima alpha-tubulin (Atub) gene, partial cds blastn 66359 998 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
2292805 2292805 PRJNA1087264_P_NODE_502_length_922_cov_2.009164_g447_i0 PRJNA1087264 502 922 2.009164 18.52449208 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 384 2.08e-131   NR ADK26624.1 323453 g447 i0 68.7 1.85466377440347 275 84 88.8 1 859 41 2 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 1710 387 0.992248062015504 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
16770929 16770929 PRJNA1087264_P_NODE_10054_length_199_cov_1.020000_g9972_i0 PRJNA1087264 10054 199 1.02 2.0298 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 119 5.72e-33   NR ADK26622.1 323453 g9972 i0 81.8 0.994974874371859 66 12 99.5 0 198 1 37 102 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 198 119 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
18045732 18045732 PRJNA1087264_P_NODE_1495_length_549_cov_2.700000_g1418_i0 PRJNA1087264 1495 549 2.7 14.823 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 241 7.680000000000001e-79   NR ADK47156.1 323453 g1418 i0 82.8 0.792349726775956 145 25 79.2 0 22 456 1 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 435 241 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
20595112 20595112 PRJNA1087264_P_NODE_20017_length_162_cov_1.353982_g19935_i0 PRJNA1087264 20017 162 1.353982 2.19345084 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 185 1.2699999999999999e-42   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g19935 i0 88.272 41.9691358024691 162 9 100 4 1 162 3914 3763 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 6799 185 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
23146251 23146251 PRJNA1087264_P_NODE_219_length_1317_cov_1.686120_g183_i0 PRJNA1087264 219 1317 1.68612 22.2062004 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 1090 0   NTclustered gi|302026154|gb|GQ377660.1| 188950 g183 i0 88.69 77.3310554290053 893 101 68 0 325 1217 893 1 Bodomorpha minima beta-tubulin (Btub) gene, partial cds blastn 101845 1090 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
24419905 24419905 PRJNA1087264_P_NODE_480_length_938_cov_3.188976_g425_i0 PRJNA1087264 480 938 3.188976 29.91259488 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 317 2.7e-105   NR MES1912193.1 1215613 g425 i0 67.5 6.76439232409382 234 76 74.8 0 68 769 6 239 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 6345 317 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24419906 24419906 PRJNA1087264_P_NODE_4820_length_294_cov_1.457143_g4738_i0 PRJNA1087264 4820 294 1.457143 4.28400042 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 427 3.88e-115   NTclustered gi|238617605|gb|FJ973380.1| 45107 g4738 i0 92.905 78.0986394557823 296 18 100 3 1 294 2507 2213 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 22961 427 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
27193834 27193834 PRJNA1087264_P_NODE_882_length_709_cov_1.696970_g813_i0 PRJNA1087264 882 709 1.69697 12.0315173 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 214 6.349999999999999e-66   NR MES1915483.1 1215613 g813 i0 48.9 2.71227080394922 221 108 93.1 2 660 1 2 218 MES1915483.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1923 214 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30289071 30289071 PRJNA1087264_P_NODE_9952_length_200_cov_1.013245_g9870_i0 PRJNA1087264 9952 200 1.013245 2.02649 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 97.8 1.06e-23   NR MES1909697.1 1215613 g9870 i0 73.4 3.87 64 17 96 0 195 4 6 69 MES1909697.1 40S ribosomal protein S9 [Cercozoa sp. M6MM] diamond 774 97.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32090693 32090693 PRJNA1087264_P_NODE_1558_length_537_cov_2.155738_g1479_i0 PRJNA1087264 1558 537 2.155738 11.57631306 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 133 1.61e-34   NR MES1911029.1 1215613 g1479 i0 49.3 0.804469273743017 144 67 78.2 2 3 422 164 305 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 432 133 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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