RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA222400", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 2 ✖

tax_kingdom 1

  • Bacillati · 2 ✖

bioproject 1

  • PRJNA222400 · 2 ✖

analysis 1

tax_clade 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
27010578 27010578 PRJNA222400_P_NODE_3182_length_261_cov_0.981132_g3149_i0 PRJNA222400 3182 261 0.981132 2.56075452 Armatimonadota bacterium 2033014 Bacteria Bacteria 52 1.99e-5   NR MEI7986390.1 2033014 g3149 i0 32.5 2.72413793103448 83 53 94.3 3 4 249 116 196 MEI7986390.1 glycosyltransferase [Armatimonadota bacterium] diamond 711 52 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
29965457 29965457 PRJNA222400_P_NODE_9191_length_162_cov_1.415929_g9158_i0 PRJNA222400 9191 162 1.415929 2.29380498 Bacteria 2 Bacteria Bacteria 42 0.0227   NR MCH8979119.1 2033014 g9158 i0 43.6 7.51851851851852 39 21 70.4 1 161 48 211 249 MCH8979119.1 diacylglycerol kinase family lipid kinase [Armatimonadota bacterium] diamond 1218 42.4 0.990566037735849 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium

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