RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA358009 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_phylum 0

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
26885177 26885177 PRJNA358009_P_NODE_10461_length_179_cov_6.446154_g10392_i0 PRJNA358009 10461 179 6.446154 11.53861566 Pfiesteria piscicida 71001 SAR_Eukaryotes SAR_Eukaryotes 71.6 1.15e-13   NR ABI14300.1 71001 g10392 i0 64.3 0.93854748603352 56 20 93.9 0 169 2 27 82 ABI14300.1 unknown [Pfiesteria piscicida] diamond 168 71.6 1 Eukaryota Sar     Dinophyceae Peridiniales Pfiesteriaceae Pfiesteria Pfiesteria piscicida
26885182 26885182 PRJNA358009_P_NODE_6041_length_327_cov_1.564748_g5978_i0 PRJNA358009 6041 327 1.564748 5.11672596 Nannochloropsis gaditana 72520 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.23e-5   NR EWM25518.1 72520 g5978 i0 78.1 0.293577981651376 32 7 29.4 0 100 5 728 759 EWM25518.1 helicase sen1 [Nannochloropsis gaditana] diamond 96 53.9 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis gaditana
31592027 31592027 PRJNA358009_P_NODE_12736_length_168_cov_1.436975_g12667_i0 PRJNA358009 12736 168 1.436975 2.414118 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 58.2 5.07e-8   NR KAJ1440231.1 483371 g12667 i0 52.9 0.910714285714286 51 24 91.1 0 165 13 471 521 KAJ1440231.1 hypothetical protein B484DRAFT_323123, partial [Ochromonadaceae sp. CCMP2298] diamond 153 58.2 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31830191 31830191 PRJNA358009_P_NODE_9737_length_184_cov_2.888889_g9668_i0 PRJNA358009 9737 184 2.888889 5.31555576 Symbiodinium 2949 SAR_Eukaryotes SAR_Eukaryotes 51.2 1.78e-5   NR OLP82127.1 2951 g9668 i0 55.8 4.30434782608696 52 23 84.8 0 22 177 1400 1451 OLP82127.1 ABC transporter B family member 2 [Symbiodinium microadriaticum] diamond 792 51.6 0.992248062015504 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum

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