RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA642647", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 5 ✖

tax_kingdom 1

  • Bacillati · 5 ✖

bioproject 1

  • PRJNA642647 · 5 ✖

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
27586870 27586870 PRJNA642647_P_NODE_5464_length_163_cov_0.841270_g5414_i0 PRJNA642647 5464 163 0.84127 1.3712701 Armatimonadia bacterium 2663015 Bacteria Bacteria 68.2 7.55e-13   NR MEN6402264.1 2663015 g5414 i0 58 0.920245398773006 50 21 92 0 150 1 37 86 MEN6402264.1 hypothetical protein [Armatimonadia bacterium] diamond 150 68.2 1 Bacteria   Bacillati Armatimonadota Armatimonadia       Armatimonadia bacterium
27965602 27965602 PRJNA642647_P_NODE_3465_length_190_cov_2.261438_g3415_i0 PRJNA642647 3465 190 2.261438 4.2967322 Armatimonadota bacterium 2033014 Bacteria Bacteria 43.1 0.0137   NR NPV48071.1 2033014 g3415 i0 45.5 2.35263157894737 55 24 78.9 2 160 11 375 428 NPV48071.1 chaperonin GroEL [Armatimonadota bacterium] diamond 447 43.1 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
29197195 29197195 PRJNA642647_P_NODE_2789_length_208_cov_1.976608_g2739_i0 PRJNA642647 2789 208 1.976608 4.11134464 Armatimonadota bacterium 2033014 Bacteria Bacteria 95.5 2.73e-24   NR HOK53550.1 2033014 g2739 i0 91.8 0.706730769230769 49 4 70.7 0 160 14 1 49 HOK53550.1 hypothetical protein [Armatimonadota bacterium] diamond 147 95.5 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32262903 32262903 PRJNA642647_P_NODE_4058_length_179_cov_1.176056_g4008_i0 PRJNA642647 4058 179 1.176056 2.10514024 Armatimonadota bacterium 2033014 Bacteria Bacteria 51.2 1.35e-6   NR MBM3460762.1 2033014 g4008 i0 59.5 0.620111731843575 37 14 62 1 115 5 1 36 MBM3460762.1 hypothetical protein [Armatimonadota bacterium] diamond 111 51.2 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32610466 32610466 PRJNA642647_P_NODE_6580_length_151_cov_1.201754_g6530_i0 PRJNA642647 6580 151 1.201754 1.81464854 Armatimonadia bacterium 2663015 Bacteria Bacteria 41.2 0.0348   NR MEN6549144.1 2663015 g6530 i0 41 0.774834437086093 39 22 77.5 1 145 29 101 138 MEN6549144.1 transcription termination/antitermination NusG family protein [Armatimonadia bacterium] diamond 117 41.2 1 Bacteria   Bacillati Armatimonadota Armatimonadia       Armatimonadia 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);;