RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1013345", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermomicrobiota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA1013345 · 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
20559272 20559272 PRJNA1013345_P_NODE_11657_length_194_cov_2.965986_g11527_i0 PRJNA1013345 11657 194 2.965986 5.75401284 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 62 1.23e-9   NR HWV24757.1 2482790 g11527 i0 100 0.989690721649485 32 0 49.5 0 98 3 134 165 HWV24757.1 ABC transporter permease [Thermomicrobiales bacterium] diamond 192 62 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
27066360 27066360 PRJNA1013345_P_NODE_13262_length_186_cov_2.374101_g13132_i0 PRJNA1013345 13262 186 2.374101 4.41582786 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 75.9 1.04e-15   NR HYI14876.1 2482790 g13132 i0 78.6 1.35483870967742 42 9 67.7 0 127 2 1 42 HYI14876.1 DUF2089 domain-containing protein [Thermomicrobiales bacterium] diamond 252 75.9 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30319778 30319778 PRJNA1013345_P_NODE_30132_length_159_cov_0.910714_g30002_i0 PRJNA1013345 30132 159 0.910714 1.44803526 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 69.7 3.07e-12   NR MCA9834932.1 2482790 g30002 i0 76 1.86792452830189 50 12 94.3 0 155 6 84 133 MCA9834932.1 hypothetical protein [Thermomicrobiales bacterium] diamond 297 69.7 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
32248150 32248150 PRJNA1013345_P_NODE_21698_length_168_cov_1.314050_g21568_i0 PRJNA1013345 21698 168 1.31405 2.207604 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 89.7 1.25e-19   NR HWK81038.1 2482790 g21568 i0 98.2 0.982142857142857 55 1 98.2 0 167 3 152 206 HWK81038.1 ABC transporter ATP-binding protein [Thermomicrobiales bacterium] diamond 165 89.7 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales 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);;