RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJEB14664 · 16 ✖

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
3847338 3847338 PRJEB14664_P_NODE_1064_length_898_cov_3.396292_g274_i2 PRJEB14664 1064 898 3.396292 30.49870216 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 926 0   NTclustered gi|238617630|gb|FJ973394.1| 188950 g274 i2 98.659 63.511135857461 522 7 58 0 377 898 837 316 Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds blastn 57033 926 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
8948246 8948246 PRJEB14664_P_NODE_5328_length_365_cov_9.390909_g5198_i0 PRJEB14664 5328 365 9.390909 34.27681785 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 592 1.6499999999999996e-164   NTclustered gi|238617602|gb|FJ973377.1| 188950 g5198 i0 95.89 77.1808219178082 365 15 100 0 1 365 3100 2736 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 28171 592 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
14049258 14049258 PRJEB14664_P_NODE_10712_length_230_cov_2.051282_g10582_i0 PRJEB14664 10712 230 2.051282 4.7179486 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 409 1.0600000000000001e-109   NTclustered gi|302026154|gb|GQ377660.1| 188950 g10582 i0 98.707 19.8260869565217 232 0 99 1 1 229 171 402 Bodomorpha minima beta-tubulin (Btub) gene, partial cds blastn 4560 409 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
14049390 14049390 PRJEB14664_P_NODE_3792_length_454_cov_4.002387_g3666_i0 PRJEB14664 3792 454 4.002387 18.17083698 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 350 1.39e-91   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g3666 i0 83.5 46.2334801762115 400 41 87 17 58 454 4039 3662 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 20990 350 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
15323403 15323403 PRJEB14664_P_NODE_2473_length_582_cov_3.585009_g2359_i0 PRJEB14664 2473 582 3.585009 20.86475238 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 660 0   NTclustered gi|302026154|gb|GQ377660.1| 188950 g2359 i0 99.449 79.5257731958763 363 2 62 0 1 363 531 893 Bodomorpha minima beta-tubulin (Btub) gene, partial cds blastn 46284 660 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
16597992 16597992 PRJEB14664_P_NODE_14494_length_187_cov_4.473684_g14364_i0 PRJEB14664 14494 187 4.473684 8.36578908 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 346 6.56e-91   NTclustered gi|238617602|gb|FJ973377.1| 188950 g14364 i0 100 59.5294117647059 187 0 100 0 1 187 1659 1473 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 11132 346 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
17872806 17872806 PRJEB14664_P_NODE_1695_length_710_cov_26.438519_g1593_i0 PRJEB14664 1695 710 26.438519 187.7134849 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 1284 0   NTclustered gi|238617602|gb|FJ973377.1| 188950 g1593 i0 99.296 72.5323943661972 710 5 100 0 1 710 1698 2407 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 51498 1284 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
19146681 19146681 PRJEB14664_P_NODE_1476_length_758_cov_2.964039_g1378_i0 PRJEB14664 1476 758 2.964039 22.46741562 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 240 4.08e-75   NR MES1911029.1 1215613 g1378 i0 62.9 2.56860158311346 197 68 76 3 3 578 79 275 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1947 240 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19146737 19146737 PRJEB14664_P_NODE_236_length_1686_cov_13.820715_g212_i0 PRJEB14664 236 1686 13.820715 233.0172549 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 695 2.159999999999999e-247   NR MES1909605.1 1215613 g212 i0 77.1 4.71708185053381 433 99 77 0 1664 366 1 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 7953 701 0.991440798858773 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
20421850 20421850 PRJEB14664_P_NODE_14017_length_191_cov_2.750000_g13887_i0 PRJEB14664 14017 191 2.75 5.2525 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 353 4.02e-93   NTclustered gi|238617602|gb|FJ973377.1| 188950 g13887 i0 100 100.397905759162 191 0 100 0 1 191 1019 829 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 19176 353 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
21697859 21697859 PRJEB14664_P_NODE_1218_length_843_cov_2.857673_g1130_i0 PRJEB14664 1218 843 2.857673 24.09018339 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 332 3.51e-111   NR ADK26624.1 323453 g1130 i0 65 0.925266903914591 260 69 84.7 2 842 129 17 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 780 332 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
21697926 21697926 PRJEB14664_P_NODE_19818_length_152_cov_1.735043_g19688_i0 PRJEB14664 19818 152 1.735043 2.63726536 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 193 7.02e-45   NTclustered gi|238617602|gb|FJ973377.1| 188950 g19688 i0 89.474 100.875 152 16 100 0 1 152 1176 1327 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 15333 193 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
24247077 24247077 PRJEB14664_P_NODE_4800_length_392_cov_2.535014_g4670_i0 PRJEB14664 4800 392 2.535014 9.93725488 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 475 1.88e-129   NTclustered gi|238617666|gb|FJ973412.1| 188950 g4670 i0 99.615 40.8877551020408 260 1 66 0 133 392 1 260 Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds blastn 16028 475 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
24247105 24247105 PRJEB14664_P_NODE_7080_length_305_cov_2.711111_g6950_i0 PRJEB14664 7080 305 2.711111 8.26888855 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 553 6.39e-153   NTclustered gi|238617602|gb|FJ973377.1| 188950 g6950 i0 99.344 1 305 2 100 0 1 305 717 413 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 305 553 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
27696833 27696833 PRJEB14664_P_NODE_17424_length_165_cov_1.230769_g17294_i0 PRJEB14664 17424 165 1.230769 2.03076885 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.17e-4   NR MES1911260.1 1215613 g17294 i0 38.5 0.945454545454545 52 32 94.5 0 158 3 521 572 MES1911260.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 47.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31897956 31897956 PRJEB14664_P_NODE_9337_length_254_cov_0.913242_g9207_i0 PRJEB14664 9337 254 0.913242 2.31963468 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 53.5 6.5e-6   NR MES1909771.1 1215613 g9207 i0 65.7 0.413385826771654 35 12 41.3 0 109 5 74 108 MES1909771.1 hypothetical protein [Cercozoa sp. M6MM] diamond 105 53.5 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);;