contig_metadata
22 rows where bioproject = "PRJNA235310" and tax_phylum = "Acidobacteriota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2917945 | 2917945 | PRJNA235310_P_NODE_1983_length_280_cov_1.523810_g1957_i0 | PRJNA235310 | 1983 | 280 | 1.52381 | 4.266668 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 190 | 5.71e-60 | NR | NLV31801.1 | 1978231 | g1957 | i0 | 91.3 | 19.7142857142857 | 92 | 8 | 98.6 | 0 | 278 | 3 | 49 | 140 | NLV31801.1 peptidylprolyl isomerase [Acidobacteriota bacterium] | diamond | 5520 | 190 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 11259844 | 11259844 | PRJNA235310_P_NODE_5889_length_164_cov_1.330435_g5863_i0 | PRJNA235310 | 5889 | 164 | 1.330435 | 2.1819134 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 82 | 9.07e-17 | NR | HEX6737292.1 | 2793154 | g5863 | i0 | 72.2 | 5.92682926829268 | 54 | 15 | 98.8 | 0 | 162 | 1 | 140 | 193 | HEX6737292.1 isocitrate dehydrogenase (NAD(+)) [Vicinamibacteria bacterium] | diamond | 972 | 82 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 15670160 | 15670160 | PRJNA235310_P_NODE_3353_length_207_cov_1.291139_g3327_i0 | PRJNA235310 | 3353 | 207 | 1.291139 | 2.67265773 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 126 | 1.05e-24 | NTclustered | gi|2874253950|emb|OY970275.1| | 171953 | g3327 | i0 | 82.979 | 0.681159420289855 | 141 | 22 | 68 | 2 | 3 | 142 | 3122473 | 3122612 | MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1 | blastn | 141 | 126 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 18219056 | 18219056 | PRJNA235310_P_NODE_4295_length_181_cov_1.159091_g4269_i0 | PRJNA235310 | 4295 | 181 | 1.159091 | 2.09795471 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 79.7 | 2.38e-17 | NR | MFN7929081.1 | 2052146 | g4269 | i0 | 62.7 | 0.977900552486188 | 59 | 22 | 97.8 | 0 | 180 | 4 | 23 | 81 | MFN7929081.1 RidA family protein [Blastocatellia bacterium] | diamond | 177 | 79.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 20768922 | 20768922 | PRJNA235310_P_NODE_57_length_1066_cov_2.645034_g45_i0 | PRJNA235310 | 57 | 1066 | 2.645034 | 28.19606244 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 304 | 6.19e-94 | NR | MCB1054384.1 | 1978231 | g45 | i0 | 48.6 | 0.973733583489681 | 346 | 171 | 96 | 5 | 1066 | 44 | 104 | 447 | MCB1054384.1 M4 family metallopeptidase [Acidobacteriota bacterium] | diamond | 1038 | 304 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26694074 | 26694074 | PRJNA235310_P_NODE_4061_length_187_cov_1.130435_g4035_i0 | PRJNA235310 | 4061 | 187 | 1.130435 | 2.11391345 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 51.2 | 1.68e-5 | NR | HEX9001753.1 | 2052146 | g4035 | i0 | 38.7 | 8.72727272727273 | 62 | 38 | 99.5 | 0 | 187 | 2 | 213 | 274 | HEX9001753.1 EamA family transporter [Blastocatellia bacterium] | diamond | 1632 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 27263765 | 27263765 | PRJNA235310_P_NODE_263_length_668_cov_1.848142_g242_i0 | PRJNA235310 | 263 | 668 | 1.848142 | 12.34558856 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 93.6 | 6.35e-18 | NR | MBI4907469.1 | 1978231 | g242 | i0 | 35.2 | 2.02994011976048 | 227 | 128 | 98.8 | 8 | 662 | 3 | 420 | 634 | MBI4907469.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 1356 | 93.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28147988 | 28147988 | PRJNA235310_P_NODE_445_length_554_cov_1.974257_g421_i0 | PRJNA235310 | 445 | 554 | 1.974257 | 10.93738378 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 162 | 1.46e-42 | NR | HMV46425.1 | 2052146 | g421 | i0 | 55.1 | 2.89169675090253 | 178 | 67 | 91.5 | 4 | 46 | 552 | 336 | 509 | HMV46425.1 DUF4394 domain-containing protein [Blastocatellia bacterium] | diamond | 1602 | 162 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28242397 | 28242397 | PRJNA235310_P_NODE_3126_length_214_cov_2.024242_g3100_i0 | PRJNA235310 | 3126 | 214 | 2.024242 | 4.33187788 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 75.9 | 3.09e-14 | NR | HEX6183801.1 | 2283092 | g3100 | i0 | 65.4 | 5.87383177570093 | 52 | 18 | 72.9 | 0 | 159 | 4 | 1 | 52 | HEX6183801.1 NADPH:quinone reductase [Pyrinomonadaceae bacterium] | diamond | 1257 | 75.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29459822 | 29459822 | PRJNA235310_P_NODE_3790_length_194_cov_1.075862_g3764_i0 | PRJNA235310 | 3790 | 194 | 1.075862 | 2.08717228 | Bacteria | 2 | Bacteria | Bacteria | 53.5 | 3e-6 | NR | MSO35190.1 | 1978231 | g3764 | i0 | 91.7 | 8.8298969072165 | 24 | 2 | 37.1 | 0 | 4 | 75 | 489 | 512 | MSO35190.1 adenosylhomocysteinase [Acidobacteriota bacterium] | diamond | 1713 | 53.9 | 0.992578849721707 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29505408 | 29505408 | PRJNA235310_P_NODE_3830_length_193_cov_1.430556_g3804_i0 | PRJNA235310 | 3830 | 193 | 1.430556 | 2.76097308 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 67 | 2.28e-11 | NR | HJW13735.1 | 2651171 | g3804 | i0 | 86.5 | 3.37305699481865 | 37 | 5 | 57.5 | 0 | 192 | 82 | 157 | 193 | HJW13735.1 SDR family oxidoreductase [Thermoanaerobaculia bacterium] | diamond | 651 | 67 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29947676 | 29947676 | PRJNA235310_P_NODE_3451_length_203_cov_1.603896_g3425_i0 | PRJNA235310 | 3451 | 203 | 1.603896 | 3.25590888 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 60.5 | 1.24e-8 | NR | MCB1057370.1 | 1978231 | g3425 | i0 | 43.8 | 0.945812807881773 | 64 | 36 | 94.6 | 0 | 193 | 2 | 828 | 891 | MCB1057370.1 choice-of-anchor A family protein [Acidobacteriota bacterium] | diamond | 192 | 60.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30737371 | 30737371 | PRJNA235310_P_NODE_5494_length_166_cov_0.888889_g5468_i0 | PRJNA235310 | 5494 | 166 | 0.888889 | 1.47555574 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 53.9 | 1.5e-6 | NR | MEZ5353166.1 | 2212468 | g5468 | i0 | 70.6 | 2.27710843373494 | 34 | 10 | 61.4 | 0 | 141 | 40 | 291 | 324 | MEZ5353166.1 sulfatase-like hydrolase/transferase [Bryobacteraceae bacterium] | diamond | 378 | 53.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30895631 | 30895631 | PRJNA235310_P_NODE_4674_length_172_cov_0.926829_g4648_i0 | PRJNA235310 | 4674 | 172 | 0.926829 | 1.59414588 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 43.1 | 0.0103 | NR | HKH47652.1 | 2651171 | g4648 | i0 | 59.1 | 1.5 | 44 | 17 | 76.7 | 1 | 39 | 170 | 305 | 347 | HKH47652.1 alpha/beta hydrolase fold domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 258 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 30927275 | 30927275 | PRJNA235310_P_NODE_3214_length_212_cov_0.957055_g3188_i0 | PRJNA235310 | 3214 | 212 | 0.957055 | 2.0289566 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 78.6 | 9.37e-16 | NR | MFC2168428.1 | 1978231 | g3188 | i0 | 54.3 | 0.990566037735849 | 70 | 32 | 99.1 | 0 | 2 | 211 | 80 | 149 | MFC2168428.1 DUF4197 domain-containing protein [Acidobacteriota bacterium] | diamond | 210 | 78.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31337865 | 31337865 | PRJNA235310_P_NODE_816_length_439_cov_1.669231_g790_i0 | PRJNA235310 | 816 | 439 | 1.669231 | 7.32792409 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 58.9 | 7.36e-7 | NR | HET8549934.1 | 2212468 | g790 | i0 | 34.4 | 3.78587699316629 | 131 | 79 | 88.2 | 4 | 52 | 438 | 1089 | 1214 | HET8549934.1 PKD domain-containing protein [Bryobacteraceae bacterium] | diamond | 1662 | 58.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31591178 | 31591178 | PRJNA235310_P_NODE_4076_length_186_cov_2.708029_g4050_i0 | PRJNA235310 | 4076 | 186 | 2.708029 | 5.03693394 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 65.1 | 1.07e-10 | NR | MEQ1870704.1 | 2910147 | g4050 | i0 | 51.7 | 2.90322580645161 | 60 | 27 | 96.8 | 1 | 3 | 182 | 190 | 247 | MEQ1870704.1 NADPH:quinone reductase [Vicinamibacterales bacterium] | diamond | 540 | 65.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31749001 | 31749001 | PRJNA235310_P_NODE_1357_length_346_cov_1.609428_g1331_i0 | PRJNA235310 | 1357 | 346 | 1.609428 | 5.56862088 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 58.9 | 1.05e-7 | NR | HJU55860.1 | 2283092 | g1331 | i0 | 38.6 | 0.763005780346821 | 88 | 48 | 71.1 | 1 | 12 | 257 | 106 | 193 | HJU55860.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 264 | 58.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31843901 | 31843901 | PRJNA235310_P_NODE_4297_length_181_cov_1.121212_g4271_i0 | PRJNA235310 | 4297 | 181 | 1.121212 | 2.02939372 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 55.1 | 5.88e-7 | NR | PYQ53839.1 | 1978231 | g4271 | i0 | 58.7 | 1.52486187845304 | 46 | 19 | 76.2 | 0 | 181 | 44 | 73 | 118 | PYQ53839.1 MAG: short chain dehydrogenase [Acidobacteriota bacterium] | diamond | 276 | 55.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32083209 | 32083209 | PRJNA235310_P_NODE_98_length_900_cov_2.377203_g82_i0 | PRJNA235310 | 98 | 900 | 2.377203 | 21.394827 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 390 | 1.28e-131 | NR | MBX3297142.1 | 1978231 | g82 | i0 | 65.5 | 20.9366666666667 | 304 | 95 | 99.7 | 2 | 3 | 899 | 113 | 411 | MBX3297142.1 acetyl-CoA hydrolase/transferase family protein [Acidobacteriota bacterium] | diamond | 18843 | 390 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32697540 | 32697540 | PRJNA235310_P_NODE_1380_length_344_cov_1.762712_g1354_i0 | PRJNA235310 | 1380 | 344 | 1.762712 | 6.0637292800000004 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 62 | 2.14e-8 | NR | PYP99840.1 | 1978231 | g1354 | i0 | 38.7 | 2.72093023255814 | 111 | 53 | 96.8 | 3 | 2 | 334 | 209 | 304 | PYP99840.1 MAG: hypothetical protein DMF83_29675, partial [Acidobacteriota bacterium] | diamond | 936 | 62 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32886408 | 32886408 | PRJNA235310_P_NODE_5060_length_168_cov_0.873950_g5034_i0 | PRJNA235310 | 5060 | 168 | 0.87395 | 1.468236 | Acidobacteria bacterium Mor1 | 1660251 | Bacteria | Bacteria | 67 | 1.46e-11 | NR | ANM30664.1 | 1660251 | g5034 | i0 | 68.6 | 3.85714285714286 | 51 | 16 | 91.1 | 0 | 168 | 16 | 86 | 136 | ANM30664.1 hypothetical protein ABI59_15425 [Acidobacteria bacterium Mor1] | diamond | 648 | 67 | 1 | Bacteria | Acidobacteriota subdivision 22 | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium Mor1 |
Advanced export
JSON shape: default, array, newline-delimited
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);;