RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA942359", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA942359 · 5 ✖

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
923156 923156 PRJNA942359_P_NODE_9341_length_287_cov_1.649533_g9226_i0 PRJNA942359 9341 287 1.649533 4.73415971 Uronema sp. WS-2012 1198319 SAR_Eukaryotes SAR_Eukaryotes 475 1.3299999999999996e-129   NTclustered gi|390988015|gb|JN885083.1| 1198319 g9226 i0 96.516 100.512195121951 287 10 100 0 1 287 380 94 Uronema sp. WS-2012 isolate PXM2010100401 small subunit ribosomal RNA gene, partial sequence blastn 28847 475 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Uronematidae Uronema Uronema sp. WS-2012
8911676 8911676 PRJNA942359_P_NODE_2287_length_518_cov_1.516854_g2173_i0 PRJNA942359 2287 518 1.516854 7.85730372 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 654 0   NTclustered gi|325156266|gb|JF304163.1| 5886 g2173 i0 98.138 72.5791505791506 376 6 72 1 144 518 882 507 Paramecium primaurelia strain 90 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence; macronuclear blastn 37596 654 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
13676835 13676835 PRJNA942359_P_NODE_7691_length_310_cov_3.582278_g7576_i0 PRJNA942359 7691 310 3.582278 11.1050618 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 302 2.6e-77   NTclustered gi|49616744|gb|AY643504.1| 282688 g7576 i0 86.525 59.8741935483871 282 28 89 9 1 277 277 1 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 18561 302 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
18774667 18774667 PRJNA942359_P_NODE_1475_length_638_cov_2.122124_g1365_i0 PRJNA942359 1475 638 2.122124 13.53915112 Philasterida sp. 2006707 SAR_Eukaryotes SAR_Eukaryotes 832 0   NTclustered gi|2354193480|gb|OP896969.1| 2006707 g1365 i0 96.429 68.9404388714733 504 18 85 0 135 638 1264 761 Philasterida sp. strain tDaCF9_52 large subunit ribosomal RNA gene, partial sequence blastn 43984 832 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida     Philasterida sp.
31130832 31130832 PRJNA942359_P_NODE_11315_length_267_cov_1.742268_g11200_i0 PRJNA942359 11315 267 1.742268 4.6518555599999996 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 108 3.98e-26   NR CDW82305.1 5949 g11200 i0 59.1 0.98876404494382 88 34 98.9 1 266 3 104 189 CDW82305.1 UNKNOWN [Stylonychia lemnae] diamond 264 108 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

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