RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB10140", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 4 ✖

tax_kingdom 1

  • Bacillati · 4 ✖

bioproject 1

  • PRJEB10140 · 4 ✖

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
20412984 20412984 PRJEB10140_P_NODE_245217_length_169_cov_0.866667_g227908_i0 PRJEB10140 245217 169 0.866667 1.46466723 Armatimonadota bacterium 2033014 Bacteria Bacteria 105 2.26e-25   NR MCL6532322.1 2033014 g227908 i0 100 0.994082840236686 56 0 99.4 0 168 1 326 381 MCL6532322.1 phosphoglycerate kinase [Armatimonadota bacterium] diamond 168 105 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31770955 31770955 PRJEB10140_P_NODE_235137_length_174_cov_1.328000_g217828_i0 PRJEB10140 235137 174 1.328 2.31072 Armatimonadetes bacterium Uphvl-Ar1 2004467 Bacteria Bacteria 41.2 0.0262   NR ARU40587.1 2004467 g217828 i0 35.7 0.724137931034483 42 27 72.4 0 19 144 38 79 ARU40587.1 hypothetical protein CCB80_05305 [Armatimonadetes bacterium Uphvl-Ar1] diamond 126 41.2 1 Bacteria   Bacillati Armatimonadota         Armatimonadetes bacterium Uphvl-Ar1
31897466 31897466 PRJEB10140_P_NODE_142977_length_258_cov_1.497608_g125669_i0 PRJEB10140 142977 258 1.497608 3.86382864 Armatimonadota bacterium 2033014 Bacteria Bacteria 58.5 1.21e-7   NR HET6455837.1 2033014 g125669 i0 50.9 1.83720930232558 55 26 64 1 220 56 847 900 HET6455837.1 family 10 glycosylhydrolase [Armatimonadota bacterium] diamond 474 58.5 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32055669 32055669 PRJEB10140_P_NODE_265098_length_166_cov_0.880342_g247789_i0 PRJEB10140 265098 166 0.880342 1.46136772 Armatimonadota bacterium 2033014 Bacteria Bacteria 78.2 1.21e-16   NR MBS1722369.1 2033014 g247789 i0 63 0.975903614457831 54 20 97.6 0 162 1 58 111 MBS1722369.1 hypothetical protein [Armatimonadota bacterium] diamond 162 78.2 1 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);;