RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJNA293022 · 3 ✖

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
6162452 6162452 PRJNA293022_P_NODE_1965_length_942_cov_4.817469_g1549_i0 PRJNA293022 1965 942 4.817469 45.38055798 Cercomonadida 188941 SAR_Eukaryotes SAR_Eukaryotes 161 1.5199999999999996e-34   NTclustered gi|88792583|gb|DQ386164.1| 372086 g1549 i0 92.241 12.312101910828 116 6 12 3 192 306 2030 1917 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 11598 161 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
8026497 8026497 PRJNA293022_P_NODE_17467_length_341_cov_3.893836_g16730_i0 PRJNA293022 17467 341 3.893836 13.27798076 Chlorarachniophyceae sp. P329 467061 SAR_Eukaryotes SAR_Eukaryotes 60.2 1.93e-4   NTclustered gi|220983374|dbj|AB453010.1| 467061 g16730 i0 100 8.6217008797654 32 0 9 0 276 307 1593 1624 Chlorarachniophyceae sp. P329 gene for nuclear large subunit ribosomal RNA, partial sequence blastn 2940 60.2 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae       Chlorarachniophyceae sp. P329
28274228 28274228 PRJNA293022_P_NODE_67326_length_169_cov_1.033333_g66589_i0 PRJNA293022 67326 169 1.033333 1.74633277 Amorphochlora amoebiformis 1561963 SAR_Eukaryotes SAR_Eukaryotes 80.9 5.01e-16   NR BAS01792.1 1561963 g66589 i0 74.1 0.958579881656805 54 14 95.9 0 4 165 31 84 BAS01792.1 translation elongation factor EF2 [Amorphochlora amoebiformis] diamond 162 80.9 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Amorphochlora Amorphochlora amoebiformis

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