RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA485080", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

  • Pseudomonadati · 7 ✖

bioproject 1

  • PRJNA485080 · 7 ✖

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
27076301 27076301 PRJNA485080_P_NODE_41422_length_242_cov_0.911243_g41328_i0 PRJNA485080 41422 242 0.911243 2.20520806 Acidobacteriota bacterium 1978231 Bacteria Bacteria 146 1.14e-38   NR MEW6361132.1 1978231 g41328 i0 96.3 0.991735537190083 80 3 99.2 0 241 2 17 96 MEW6361132.1 ATP-binding protein [Acidobacteriota bacterium] diamond 240 146 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27992403 27992403 PRJNA485080_P_NODE_32745_length_246_cov_0.890173_g32651_i0 PRJNA485080 32745 246 0.890173 2.18982558 Acidobacteriota bacterium 1978231 Bacteria Bacteria 42.4 0.0484   NR MDH3814519.1 1978231 g32651 i0 32.9 0.853658536585366 70 47 85.4 0 29 238 191 260 MDH3814519.1 ABC transporter permease [Acidobacteriota bacterium] diamond 210 42.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30613301 30613301 PRJNA485080_P_NODE_14073_length_300_cov_0.863436_g13979_i0 PRJNA485080 14073 300 0.863436 2.590308 Paludibaculum fermentans 1473598 Bacteria Bacteria 45.4 0.00563   NR WP_194453302.1 1473598 g13979 i0 31.9 0.91 91 46 84 2 5 256 105 186 WP_194453302.1 alpha/beta hydrolase [Paludibaculum fermentans] diamond 273 45.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
30897921 30897921 PRJNA485080_P_NODE_29234_length_248_cov_0.880000_g29140_i0 PRJNA485080 29234 248 0.88 2.1824 Acidobacteriota bacterium 1978231 Bacteria Bacteria 44.3 0.0101   NR MCA1564969.1 1978231 g29140 i0 33.8 1.8508064516129 80 44 85.9 3 243 31 72 151 MCA1564969.1 SDR family oxidoreductase [Acidobacteriota bacterium] diamond 459 44.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31688131 31688131 PRJNA485080_P_NODE_28697_length_248_cov_0.880000_g28603_i0 PRJNA485080 28697 248 0.88 2.1824 Edaphobacter flagellatus 1933044 Bacteria Bacteria 43.1 0.0296   NR WP_260703562.1 1933044 g28603 i0 36.7 0.725806451612903 60 38 72.6 0 63 242 1078 1137 WP_260703562.1 TonB-dependent receptor [Edaphobacter flagellatus] diamond 180 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter flagellatus
32194448 32194448 PRJNA485080_P_NODE_15838_length_287_cov_1.303738_g15744_i0 PRJNA485080 15838 287 1.303738 3.74172806 Terriglobales bacterium 2282142 Bacteria Bacteria 62.8 5.71e-9   NR HEY5176931.1 2282142 g15744 i0 51.1 0.470383275261324 45 22 47 0 1 135 754 798 HEY5176931.1 glycoside hydrolase family 15 protein [Terriglobales bacterium] diamond 135 62.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
32731558 32731558 PRJNA485080_P_NODE_25100_length_250_cov_0.870056_g25006_i0 PRJNA485080 25100 250 0.870056 2.17514 Acidobacteriota bacterium 1978231 Bacteria Bacteria 43.1 0.0309   NR MBI4917342.1 1978231 g25006 i0 42 0.6 50 26 60 1 38 187 1193 1239 MBI4917342.1 right-handed parallel beta-helix repeat-containing protein [Acidobacteriota bacterium] diamond 150 43.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota 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);;