contig_metadata
20 rows where bioproject = "PRJNA839281" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8482609 | 8482609 | PRJNA839281_S_NODE_31607_length_164_cov_0.886957_g31338_i0 | PRJNA839281 | 31607 | 164 | 0.886957 | 1.45460948 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 83.6 | 5.16e-17 | NR | HEY7510184.1 | 2793154 | g31338 | i0 | 73.6 | 10.7012195121951 | 53 | 14 | 97 | 0 | 4 | 162 | 48 | 100 | HEY7510184.1 transketolase [Vicinamibacteria bacterium] | diamond | 1755 | 83.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 18681111 | 18681111 | PRJNA839281_S_NODE_37255_length_161_cov_0.910714_g36986_i0 | PRJNA839281 | 37255 | 161 | 0.910714 | 1.46624954 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 82.4 | 1.24e-16 | NR | HVL68922.1 | 2910147 | g36986 | i0 | 69.8 | 0.987577639751553 | 53 | 16 | 98.8 | 0 | 160 | 2 | 183 | 235 | HVL68922.1 bifunctional phosphoribosylaminoimidazolecarboxamide formyltransferase/IMP cyclohydrolase [Vicinamibacterales bacterium] | diamond | 159 | 82.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 20356792 | 20356792 | PRJNA839281_S_NODE_37996_length_161_cov_0.910714_g37727_i0 | PRJNA839281 | 37996 | 161 | 0.910714 | 1.46624954 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 109 | 1.1e-27 | NR | MEJ7609445.1 | 2212468 | g37727 | i0 | 96.2 | 2.96273291925466 | 53 | 2 | 98.8 | 0 | 160 | 2 | 192 | 244 | MEJ7609445.1 isoprenyl transferase [Bryobacteraceae bacterium] | diamond | 477 | 109 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 21231822 | 21231822 | PRJNA839281_S_NODE_28677_length_166_cov_0.871795_g28408_i0 | PRJNA839281 | 28677 | 166 | 0.871795 | 1.4471797 | Luteitalea sp. TBR-22 | 2802971 | Bacteria | Bacteria | 99.8 | 1.07e-22 | NR | WP_239491175.1 | 2802971 | g28408 | i0 | 81.5 | 0.975903614457831 | 54 | 10 | 97.6 | 0 | 3 | 164 | 467 | 520 | WP_239491175.1 PQQ-binding-like beta-propeller repeat protein [Luteitalea sp. TBR-22] | diamond | 162 | 99.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea sp. TBR-22 | ||
| 23782065 | 23782065 | PRJNA839281_S_NODE_29059_length_166_cov_0.871795_g28790_i0 | PRJNA839281 | 29059 | 166 | 0.871795 | 1.4471797 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 58.4 | 2.99e-4 | NTclustered | gi|2874253709|emb|OY969474.1| | 171953 | g28790 | i0 | 97.059 | 1.63855421686747 | 34 | 1 | 22 | 0 | 50 | 83 | 4870901 | 4870868 | MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1 | blastn | 272 | 58.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 26651407 | 26651407 | PRJNA839281_S_NODE_8041_length_282_cov_1.231760_g7772_i0 | PRJNA839281 | 8041 | 282 | 1.23176 | 3.4735632 | Bacteria | 2 | Bacteria | Bacteria | 143 | 2.05e-39 | NR | PYX17974.1 | 1978231 | g7772 | i0 | 70.2 | 14 | 94 | 28 | 100 | 0 | 282 | 1 | 58 | 151 | PYX17974.1 MAG: aspartate aminotransferase family protein, partial [Acidobacteriota bacterium] | diamond | 3948 | 143 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27371061 | 27371061 | PRJNA839281_S_NODE_35083_length_162_cov_0.902655_g34814_i0 | PRJNA839281 | 35083 | 162 | 0.902655 | 1.4623011 | Luteitalea sp. | 2004800 | Bacteria | Bacteria | 103 | 4.579999999999999e-24 | NR | HTV00074.1 | 2004800 | g34814 | i0 | 98.1 | 0.981481481481482 | 53 | 1 | 98.1 | 0 | 160 | 2 | 1056 | 1108 | HTV00074.1 translocation/assembly module TamB domain-containing protein [Luteitalea sp.] | diamond | 159 | 103 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea sp. | ||
| 27718505 | 27718505 | PRJNA839281_S_NODE_37204_length_161_cov_0.910714_g36935_i0 | PRJNA839281 | 37204 | 161 | 0.910714 | 1.46624954 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 95.5 | 1.07e-22 | NR | HVE57717.1 | 2283092 | g36935 | i0 | 82.7 | 0.968944099378882 | 52 | 9 | 96.9 | 0 | 157 | 2 | 99 | 150 | HVE57717.1 sigma-70 family RNA polymerase sigma factor [Pyrinomonadaceae bacterium] | diamond | 156 | 95.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28602259 | 28602259 | PRJNA839281_S_NODE_34247_length_163_cov_0.894737_g33978_i0 | PRJNA839281 | 34247 | 163 | 0.894737 | 1.45842131 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 64.3 | 1.39e-10 | NR | MBA4121543.1 | 1978231 | g33978 | i0 | 64.6 | 0.883435582822086 | 48 | 17 | 88.3 | 0 | 159 | 16 | 3 | 50 | MBA4121543.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 144 | 64.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29021439 | 29021439 | PRJNA839281_S_NODE_29608_length_165_cov_1.137931_g29339_i0 | PRJNA839281 | 29608 | 165 | 1.137931 | 1.87758615 | Bacteria | 2 | Bacteria | Bacteria | 97.1 | 2.78e-22 | NR | MBK6587133.1 | 1978231 | g29339 | i0 | 81.5 | 8.83636363636364 | 54 | 10 | 98.2 | 0 | 1 | 162 | 249 | 302 | MBK6587133.1 gluconolaconase [Acidobacteriota bacterium] | diamond | 1458 | 97.8 | 0.992842535787321 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29706812 | 29706812 | PRJNA839281_S_NODE_35950_length_162_cov_0.902655_g35681_i0 | PRJNA839281 | 35950 | 162 | 0.902655 | 1.4623011 | Kocuria sp. cx-455 | 2771377 | Bacteria | Bacteria | 106 | 6.6e-26 | NR | WP_190806841.1 | 2771377 | g35681 | i0 | 90.6 | 0.981481481481482 | 53 | 5 | 98.1 | 0 | 3 | 161 | 174 | 226 | WP_190806841.1 iron-containing redox enzyme family protein [Kocuria sp. cx-455] | diamond | 159 | 106 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Candidatus Korobacteraceae | Candidatus Sulfotelmatobacter | Kocuria sp. cx-455 | ||
| 29770239 | 29770239 | PRJNA839281_S_NODE_22291_length_178_cov_1.651163_g22022_i0 | PRJNA839281 | 22291 | 178 | 1.651163 | 2.93907014 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 109 | 2.25e-27 | NR | MEO8663627.1 | 2212468 | g22022 | i0 | 84.5 | 2.93258426966292 | 58 | 9 | 97.8 | 0 | 1 | 174 | 91 | 148 | MEO8663627.1 aldolase/citrate lyase family protein [Bryobacteraceae bacterium] | diamond | 522 | 109 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30789816 | 30789816 | PRJNA839281_S_NODE_26454_length_167_cov_1.033898_g26185_i0 | PRJNA839281 | 26454 | 167 | 1.033898 | 1.72660966 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 84.3 | 2.72e-17 | NR | HXB59345.1 | 2952895 | g26185 | i0 | 67.3 | 9.88023952095808 | 55 | 18 | 98.8 | 0 | 1 | 165 | 339 | 393 | HXB59345.1 glycoside hydrolase family 130 protein [Candidatus Acidiferrales bacterium] | diamond | 1650 | 84.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 30844644 | 30844644 | PRJNA839281_S_NODE_5634_length_357_cov_12.493506_g5365_i0 | PRJNA839281 | 5634 | 357 | 12.493506 | 44.60181642 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 118 | 7.739999999999999e-32 | NR | MDQ7008654.1 | 1978231 | g5365 | i0 | 83.3 | 0.65546218487395 | 78 | 12 | 65.5 | 1 | 353 | 120 | 35 | 111 | MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 234 | 118 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30907921 | 30907921 | PRJNA839281_S_NODE_34494_length_163_cov_0.868421_g34225_i0 | PRJNA839281 | 34494 | 163 | 0.868421 | 1.41552623 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 72.8 | 1.11e-13 | NR | MEO6213433.1 | 2910147 | g34225 | i0 | 57.4 | 4.96932515337423 | 54 | 23 | 99.4 | 0 | 1 | 162 | 150 | 203 | MEO6213433.1 SGNH/GDSL hydrolase family protein [Vicinamibacterales bacterium] | diamond | 810 | 72.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30971079 | 30971079 | PRJNA839281_S_NODE_6574_length_320_cov_2.328413_g6305_i0 | PRJNA839281 | 6574 | 320 | 2.328413 | 7.4509216 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 52.8 | 2.54e-5 | NR | HEV2618838.1 | 2052142 | g6305 | i0 | 67.6 | 1.06875 | 34 | 11 | 31.9 | 0 | 1 | 102 | 210 | 243 | HEV2618838.1 C1 family peptidase [Acidobacteriaceae bacterium] | diamond | 342 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 31042970 | 31042970 | PRJNA839281_S_NODE_38575_length_158_cov_2.073394_g38306_i0 | PRJNA839281 | 38575 | 158 | 2.073394 | 3.27596252 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 54.3 | 8.81e-7 | NR | HKP12968.1 | 2052146 | g38306 | i0 | 47.9 | 9.13291139240506 | 48 | 25 | 91.1 | 0 | 11 | 154 | 206 | 253 | HKP12968.1 cation diffusion facilitator family transporter [Blastocatellia bacterium] | diamond | 1443 | 54.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 31991269 | 31991269 | PRJNA839281_S_NODE_34198_length_163_cov_0.894737_g33929_i0 | PRJNA839281 | 34198 | 163 | 0.894737 | 1.45842131 | Bacteria | 2 | Bacteria | Bacteria | 107 | 2.12e-25 | NR | PWU04330.1 | 2081523 | g33929 | i0 | 90.6 | 7.89570552147239 | 53 | 5 | 97.5 | 0 | 160 | 2 | 408 | 460 | PWU04330.1 MAG: phosphoribosylformylglycinamidine synthase subunit PurL [Terriglobia bacterium] | diamond | 1287 | 107 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 32077799 | 32077799 | PRJNA839281_S_NODE_28218_length_166_cov_0.871795_g27949_i0 | PRJNA839281 | 28218 | 166 | 0.871795 | 1.4471797 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 84.3 | 1.15e-17 | NR | HEX6278881.1 | 2283092 | g27949 | i0 | 77.4 | 2.90963855421687 | 53 | 12 | 95.8 | 0 | 161 | 3 | 61 | 113 | HEX6278881.1 ROK family protein [Pyrinomonadaceae bacterium] | diamond | 483 | 84.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32331328 | 32331328 | PRJNA839281_S_NODE_4479_length_443_cov_3.017766_g4210_i0 | PRJNA839281 | 4479 | 443 | 3.017766 | 13.36870338 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 131 | 2.14e-36 | NR | MDQ7008653.1 | 1978231 | g4210 | i0 | 80.5 | 0.589164785553047 | 87 | 17 | 58.9 | 0 | 438 | 178 | 24 | 110 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 261 | 131 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium |
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);;