RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA627467" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA627467 · 6 ✖

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
599168 599168 PRJNA627467_P_NODE_20701_length_155_cov_3.452830_g20632_i0 PRJNA627467 20701 155 3.45283 5.3518865 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 278 1.93e-70   NTclustered gi|238617602|gb|FJ973377.1| 188950 g20632 i0 99.351 0.993548387096774 154 0 99 1 3 155 554 401 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 154 278 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
3149996 3149996 PRJNA627467_P_NODE_13183_length_177_cov_1.562500_g13114_i0 PRJNA627467 13183 177 1.5625 2.765625 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 113 6.7600000000000005e-21   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g13114 i0 83.077 22.7401129943503 130 16 73 5 5 134 3793 3916 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 4025 113 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
6977543 6977543 PRJNA627467_P_NODE_10146_length_187_cov_2.369565_g10077_i0 PRJNA627467 10146 187 2.369565 4.43108655 Thaumatomonas sp. TMT002 407209 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|116222178|gb|DQ980465.1| 407209 g10077 i0 100 0.160427807486631 30 0 16 0 154 183 681 652 Thaumatomonas sp. TMT002 Hsp90 mRNA, partial cds blastn 30 56.5 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. TMT002
8252255 8252255 PRJNA627467_P_NODE_1127_length_350_cov_2.109635_g1060_i0 PRJNA627467 1127 350 2.109635 7.3837225 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 198 4.01e-46   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g1060 i0 97.414 12.98 116 3 50 0 232 347 3820 3705 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 4543 198 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
10079350 10079350 PRJNA627467_P_NODE_2848_length_316_cov_2.329588_g2780_i0 PRJNA627467 2848 316 2.329588 7.36149808 root 1 Root_unresolved Root_unresolved 180 1.3e-40   NTclustered gi|194476495|ref|NC_011087.1| 39717 g2780 i0 99 102.072784810127 100 1 62 0 217 316 307535 307436 Paulinella chromatophora chromatophore, complete genome blastn 32255 180 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
23551643 23551643 PRJNA627467_P_NODE_10699_length_185_cov_2.242647_g10630_i0 PRJNA627467 10699 185 2.242647 4.14889695 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 268 1.44e-67   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g10630 i0 93.011 69.5945945945946 186 9 100 4 1 185 2413 2595 Rosculus vulgaris isolate CCA sequence blastn 12875 268 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris

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