RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA217180", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 13 ✖

tax_phylum 1

  • Acidobacteriota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA217180 · 13 ✖

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
26933556 26933556 PRJNA217180_P_NODE_13322_length_165_cov_0.879310_g13222_i0 PRJNA217180 13322 165 0.87931 1.4508615 Terriglobia 204432 Bacteria Bacteria 52.4 4.93e-6   NR MCZ2079319.1 2026791 g13222 i0 58 2.56363636363636 50 16 89.1 3 163 17 290 335 MCZ2079319.1 radical SAM protein [Bryobacterales bacterium] diamond 423 52.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
27010571 27010571 PRJNA217180_P_NODE_10742_length_181_cov_1.212121_g10642_i0 PRJNA217180 10742 181 1.212121 2.19393901 Acidobacteriota bacterium 1978231 Bacteria Bacteria 51.6 1.17e-5   NR MEY4093795.1 1978231 g10642 i0 41.1 0.92817679558011 56 33 92.8 0 6 173 247 302 MEY4093795.1 hypothetical protein [Acidobacteriota bacterium] diamond 168 51.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27358629 27358629 PRJNA217180_P_NODE_6343_length_233_cov_1.108696_g6243_i0 PRJNA217180 6343 233 1.108696 2.58326168 Chloracidobacterium sp. 2099375 Bacteria Bacteria 140 8.46e-41   NR MBK7804429.1 2099375 g6243 i0 89.6 0.991416309012876 77 8 99.1 0 231 1 58 134 MBK7804429.1 phage portal protein [Chloracidobacterium sp.] diamond 231 140 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Chloracidobacterium Chloracidobacterium sp.
27692262 27692262 PRJNA217180_P_NODE_13144_length_166_cov_0.871795_g13044_i0 PRJNA217180 13144 166 0.871795 1.4471797 Terriglobia 204432 Bacteria Bacteria 48.5 6.45e-5   NR HTF69825.1 1934404 g13044 i0 52.9 1.26506024096386 34 16 61.4 0 119 18 106 139 HTF69825.1 glycosyltransferase family A protein [Edaphobacter sp.] diamond 210 48.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter sp.
28273994 28273994 PRJNA217180_P_NODE_13526_length_165_cov_0.879310_g13426_i0 PRJNA217180 13526 165 0.87931 1.4508615 Acidobacteriota bacterium 1978231 Bacteria Bacteria 42.4 0.0156   NR HJZ13814.1 1978231 g13426 i0 62.1 0.527272727272727 29 11 52.7 0 1 87 178 206 HJZ13814.1 recombination protein NinG [Acidobacteriota bacterium] diamond 87 42.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28937275 28937275 PRJNA217180_P_NODE_12868_length_166_cov_0.871795_g12768_i0 PRJNA217180 12868 166 0.871795 1.4471797 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 61.2 3.8e-9   NR HEX8398340.1 2283092 g12768 i0 51.8 2.00602409638554 56 24 95.8 1 6 164 479 534 HEX8398340.1 M36 family metallopeptidase [Pyrinomonadaceae bacterium] diamond 333 61.2 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29189925 29189925 PRJNA217180_P_NODE_12489_length_167_cov_0.864407_g12389_i0 PRJNA217180 12489 167 0.864407 1.44355969 Acidobacteriota bacterium 1978231 Bacteria Bacteria 57 2.41e-8   NR MBF84565.1 1978231 g12389 i0 52.7 0.988023952095808 55 24 98.8 1 165 1 38 90 MBF84565.1 hypothetical protein [Acidobacteriota bacterium] diamond 165 57 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30516287 30516287 PRJNA217180_P_NODE_13933_length_164_cov_0.886957_g13833_i0 PRJNA217180 13933 164 0.886957 1.45460948 Blastocatellia bacterium 2052146 Bacteria Bacteria 62 2.92e-10   NR HMV87192.1 2052146 g13833 i0 63.8 1.71951219512195 47 17 86 0 162 22 103 149 HMV87192.1 hypothetical protein [Blastocatellia bacterium] diamond 282 62 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30642536 30642536 PRJNA217180_P_NODE_10633_length_182_cov_0.932331_g10533_i0 PRJNA217180 10633 182 0.932331 1.69684242 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 103 2.27e-26   NR HQZ40675.1 2910147 g10533 i0 88.3 0.989010989010989 60 7 98.9 0 182 3 1 60 HQZ40675.1 phage tail tube protein [Vicinamibacterales bacterium] diamond 180 103 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
31179497 31179497 PRJNA217180_P_NODE_8735_length_199_cov_1.040000_g8635_i0 PRJNA217180 8735 199 1.04 2.0696 Chloracidobacterium sp. 2099375 Bacteria Bacteria 100 2.38e-26   NR MBK7804430.1 2099375 g8635 i0 100 0.814070351758794 54 0 81.4 0 197 36 5 58 MBK7804430.1 hypothetical protein [Chloracidobacterium sp.] diamond 162 100 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Chloracidobacterium Chloracidobacterium sp.
31401396 31401396 PRJNA217180_P_NODE_13836_length_164_cov_0.886957_g13736_i0 PRJNA217180 13836 164 0.886957 1.45460948 Acidobacteriota bacterium 1978231 Bacteria Bacteria 62.8 1.08e-9   NR MBW4026336.1 1978231 g13736 i0 55.6 0.98780487804878 54 24 98.8 0 1 162 148 201 MBW4026336.1 DUF3987 domain-containing protein [Acidobacteriota bacterium] diamond 162 62.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31685696 31685696 PRJNA217180_P_NODE_11737_length_172_cov_1.585366_g11637_i0 PRJNA217180 11737 172 1.585366 2.72682952 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 42 0.0275   NR HVL65717.1 2910147 g11637 i0 45.3 1.84883720930233 53 19 92.4 3 13 171 233 275 HVL65717.1 hypothetical protein [Vicinamibacterales bacterium] diamond 318 42 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
32791902 32791902 PRJNA217180_P_NODE_14860_length_162_cov_0.902655_g14760_i0 PRJNA217180 14860 162 0.902655 1.4623011 Terriglobales bacterium 2282142 Bacteria Bacteria 58.9 1.92e-8   NR HEX7962208.1 2282142 g14760 i0 52 0.925925925925926 50 24 92.6 0 162 13 219 268 HEX7962208.1 nucleotide kinase domain-containing protein [Terriglobales bacterium] diamond 150 58.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales 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);;