RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA358009 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
18249836 18249836 PRJNA358009_P_NODE_1415_length_346_cov_1.683502_g1354_i0 PRJNA358009 1415 346 1.683502 5.82491692 Acidobacteriota bacterium 1978231 Bacteria Bacteria 58.9 2.56e-7   NR MBX3267106.1 1978231 g1354 i0 75.8 0.286127167630058 33 8 28.6 0 322 224 173 205 MBX3267106.1 hypothetical protein [Acidobacteriota bacterium] diamond 99 58.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
19524103 19524103 PRJNA358009_P_NODE_18556_length_151_cov_2.676471_g18487_i0 PRJNA358009 18556 151 2.676471 4.04147121 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 77.4 6.33e-15   NR MET0167417.1 2910147 g18487 i0 78 6.95364238410596 50 11 99.3 0 1 150 462 511 MET0167417.1 GMC family oxidoreductase N-terminal domain-containing protein [Vicinamibacterales bacterium] diamond 1050 77.4 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
26885181 26885181 PRJNA358009_P_NODE_4361_length_327_cov_2.161871_g4298_i0 PRJNA358009 4361 327 2.161871 7.06931817 Acidobacteriota bacterium 1978231 Bacteria Bacteria 44.7 0.0206   NR MBP7571851.1 1978231 g4298 i0 67.7 0.559633027522936 31 10 28.4 0 322 230 621 651 MBP7571851.1 response regulator [Acidobacteriota bacterium] diamond 183 44.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28306586 28306586 PRJNA358009_P_NODE_16926_length_158_cov_7.862385_g16857_i0 PRJNA358009 16926 158 7.862385 12.4225683 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 87.4 2.04e-20   NR HRH41801.1 2283092 g16857 i0 71.4 1.86075949367089 49 14 93 0 151 5 43 91 HRH41801.1 alcohol dehydrogenase catalytic domain-containing protein [Pyrinomonadaceae bacterium] diamond 294 87.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28685637 28685637 PRJNA358009_P_NODE_10167_length_181_cov_5.166667_g10098_i0 PRJNA358009 10167 181 5.166667 9.35166727 Chloracidobacterium sp. 2099375 Bacteria Bacteria 77 1.28e-14   NR MBK9154662.1 2099375 g10098 i0 81.1 1.77348066298343 53 8 84.5 1 15 167 456 508 MBK9154662.1 glutamate--tRNA ligase [Chloracidobacterium sp.] diamond 321 77 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Chloracidobacterium Chloracidobacterium sp.
29442979 29442979 PRJNA358009_P_NODE_10470_length_179_cov_5.653846_g10401_i0 PRJNA358009 10470 179 5.653846 10.12038434 Acidobacteriota bacterium 1978231 Bacteria Bacteria 49.7 5.6e-5   NR PYS61943.1 1978231 g10401 i0 45.1 3.45251396648045 51 28 85.5 0 19 171 258 308 PYS61943.1 MAG: hypothetical protein DMF74_14885 [Acidobacteriota bacterium] diamond 618 49.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29681053 29681053 PRJNA358009_P_NODE_18090_length_153_cov_4.221154_g18021_i0 PRJNA358009 18090 153 4.221154 6.45836562 Pseudomonadati 3379134 Bacteria Bacteria 83.2 9.13e-18   NR MBA2356477.1 1978231 g18021 i0 77.1 3.76470588235294 48 11 94.1 0 4 147 34 81 MBA2356477.1 DUF72 domain-containing protein [Acidobacteriota bacterium] diamond 576 84 0.990476190476191 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29744273 29744273 PRJNA358009_P_NODE_4710_length_327_cov_2.017986_g4647_i0 PRJNA358009 4710 327 2.017986 6.59881422 Bryobacter 911113 Bacteria Bacteria 58.2 3.63e-7   NR MBM3787259.1 1978231 g4647 i0 90.3 1.67889908256881 31 3 28.4 0 320 228 170 200 MBM3787259.1 DUF1501 domain-containing protein [Acidobacteriota bacterium] diamond 549 58.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30011819 30011819 PRJNA358009_P_NODE_10211_length_181_cov_3.196970_g10142_i0 PRJNA358009 10211 181 3.19697 5.7865157 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 67.8 2.08e-11   NR HSE26238.1 2283092 g10142 i0 94.3 0.580110497237569 35 2 58 0 75 179 1 35 HSE26238.1 TRAM domain-containing protein [Pyrinomonadaceae bacterium] diamond 105 67.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31988503 31988503 PRJNA358009_P_NODE_2658_length_327_cov_3.435252_g2595_i0 PRJNA358009 2658 327 3.435252 11.23327404 Bacteria 2 Bacteria Bacteria 64.7 1.58e-9   NR MDI9629497.1 1978231 g2595 i0 37.5 2.87155963302752 104 59 95.4 1 319 8 140 237 MDI9629497.1 LLM class flavin-dependent oxidoreductase [Acidobacteriota bacterium] diamond 939 64.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32210101 32210101 PRJNA358009_P_NODE_3478_length_327_cov_2.629496_g3415_i0 PRJNA358009 3478 327 2.629496 8.59845192 Edaphobacter 388463 Bacteria Bacteria 77 9.36e-14   NR WP_260703163.1 1933044 g3415 i0 44.4 1.98165137614679 108 25 99.1 1 3 326 311 383 WP_260703163.1 TonB-dependent receptor [Edaphobacter flagellatus] diamond 648 77 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter flagellatus
32256586 32256586 PRJNA358009_P_NODE_9218_length_187_cov_4.405797_g9149_i0 PRJNA358009 9218 187 4.405797 8.23884039 Acidobacteriota bacterium 1978231 Bacteria Bacteria 100 3.6e-23   NR MEP7076450.1 1978231 g9149 i0 79.7 1.89304812834225 59 12 94.7 0 180 4 24 82 MEP7076450.1 serine hydrolase [Acidobacteriota bacterium] diamond 354 100 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);;