contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA753704" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18582944 | 18582944 | PRJNA753704_P_NODE_24555_length_250_cov_2.514124_g24194_i0 | PRJNA753704 | 24555 | 250 | 2.514124 | 6.28531 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 165 | 9.54e-46 | NR | MCL4419562.1 | 2052139 | g24194 | i0 | 97.6 | 0.996 | 83 | 2 | 99.6 | 0 | 249 | 1 | 227 | 309 | MCL4419562.1 AAA family ATPase [Patescibacteria group bacterium] | diamond | 249 | 165 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 22408519 | 22408519 | PRJNA753704_P_NODE_27938_length_243_cov_0.917647_g27577_i0 | PRJNA753704 | 27938 | 243 | 0.917647 | 2.22988221 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 140 | 1.6e-37 | NR | HUD03719.1 | 2052139 | g27577 | i0 | 82.5 | 2.96296296296296 | 80 | 14 | 98.8 | 0 | 2 | 241 | 178 | 257 | HUD03719.1 chromosomal replication initiator protein DnaA [Patescibacteria group bacterium] | diamond | 720 | 140 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 26714229 | 26714229 | PRJNA753704_P_NODE_23881_length_252_cov_0.871508_g23520_i0 | PRJNA753704 | 23881 | 252 | 0.871508 | 2.19620016 | Bacteria | 2 | Bacteria | Bacteria | 141 | 6.189999999999999e-40 | NR | QQR64468.1 | 2030810 | g23520 | i0 | 78.6 | 2 | 84 | 18 | 100 | 0 | 1 | 252 | 131 | 214 | QQR64468.1 MAG: HAD family phosphatase [Candidatus Kaiserbacteria bacterium] | diamond | 504 | 142 | 0.992957746478873 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 26989390 | 26989390 | PRJNA753704_P_NODE_5262_length_497_cov_1.655660_g4901_i0 | PRJNA753704 | 5262 | 497 | 1.65566 | 8.2286302 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 182 | 1.08e-52 | NR | MCL4419852.1 | 2052139 | g4901 | i0 | 83.3 | 0.651911468812877 | 108 | 18 | 65.2 | 0 | 2 | 325 | 294 | 401 | MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium] | diamond | 324 | 182 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27432398 | 27432398 | PRJNA753704_P_NODE_26503_length_246_cov_0.901734_g26142_i0 | PRJNA753704 | 26503 | 246 | 0.901734 | 2.21826564 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 101 | 3.27e-26 | NR | MFO0719078.1 | 2053589 | g26142 | i0 | 75.4 | 0.792682926829268 | 65 | 16 | 79.3 | 0 | 195 | 1 | 1 | 65 | MFO0719078.1 DUF167 domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 195 | 101 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27621732 | 27621732 | PRJNA753704_P_NODE_25264_length_249_cov_0.886364_g24903_i0 | PRJNA753704 | 25264 | 249 | 0.886364 | 2.20704636 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 78.2 | 5.19e-15 | NR | NQS88386.1 | 2052139 | g24903 | i0 | 59.6 | 1.46987951807229 | 57 | 23 | 68.7 | 0 | 177 | 7 | 23 | 79 | NQS88386.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 366 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28032152 | 28032152 | PRJNA753704_P_NODE_27545_length_244_cov_0.912281_g27184_i0 | PRJNA753704 | 27545 | 244 | 0.912281 | 2.22596564 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 59.7 | 1.98e-8 | NR | RMD52393.1 | 2762014 | g27184 | i0 | 38.2 | 0.934426229508197 | 76 | 46 | 92.2 | 1 | 236 | 12 | 41 | 116 | RMD52393.1 MAG: hypothetical protein D6827_00065 [Candidatus Parcubacteria bacterium] | diamond | 228 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 28095177 | 28095177 | PRJNA753704_P_NODE_23425_length_253_cov_0.866667_g23064_i0 | PRJNA753704 | 23425 | 253 | 0.866667 | 2.19266751 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 74.3 | 3.25e-13 | NR | MCL4419262.1 | 2052139 | g23064 | i0 | 50 | 0.972332015810277 | 82 | 32 | 86.6 | 2 | 2 | 220 | 672 | 753 | MCL4419262.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 246 | 74.3 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28189677 | 28189677 | PRJNA753704_P_NODE_17506_length_288_cov_2.516279_g17145_i0 | PRJNA753704 | 17506 | 288 | 2.516279 | 7.24688352 | Candidatus Aerophobetes bacterium | 2030807 | Bacteria | Bacteria | 75.1 | 2.75e-13 | NR | PCI94273.1 | 2030807 | g17145 | i0 | 55.4 | 1.32291666666667 | 65 | 29 | 67.7 | 0 | 195 | 1 | 286 | 350 | PCI94273.1 MAG: polyribonucleotide nucleotidyltransferase [Candidatus Aerophobetes bacterium] | diamond | 381 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 28252996 | 28252996 | PRJNA753704_P_NODE_20446_length_269_cov_1.632653_g20085_i0 | PRJNA753704 | 20446 | 269 | 1.632653 | 4.39183657 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 53.9 | 5.68e-6 | NR | MBP9750954.1 | 2735830 | g20085 | i0 | 40.8 | 0.847583643122677 | 76 | 41 | 84.8 | 1 | 233 | 6 | 4 | 75 | MBP9750954.1 S41 family peptidase [Candidatus Peribacteraceae bacterium] | diamond | 228 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 28632173 | 28632173 | PRJNA753704_P_NODE_26467_length_246_cov_0.901734_g26106_i0 | PRJNA753704 | 26467 | 246 | 0.901734 | 2.21826564 | Candidatus Wolfebacteria bacterium GW2 | 2030812 | Bacteria | Bacteria | 90.1 | 3.23e-19 | NR | KKR12165.1 | 1619013 | g26106 | i0 | 55.6 | 2.9390243902439 | 81 | 36 | 98.8 | 0 | 4 | 246 | 224 | 304 | KKR12165.1 MAG: hypothetical protein UT41_C0003G0092 [Candidatus Wolfebacteria bacterium GW2011_GWC2_39_22] | diamond | 723 | 90.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWC2_39_22 | ||||||
| 28821100 | 28821100 | PRJNA753704_P_NODE_27468_length_244_cov_0.912281_g27107_i0 | PRJNA753704 | 27468 | 244 | 0.912281 | 2.22596564 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 42.7 | 0.0375 | NR | MDD3862194.1 | 2044595 | g27107 | i0 | 30.1 | 1.02049180327869 | 83 | 44 | 88.5 | 2 | 16 | 231 | 305 | 384 | MDD3862194.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 249 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29200476 | 29200476 | PRJNA753704_P_NODE_28209_length_242_cov_1.840237_g27848_i0 | PRJNA753704 | 28209 | 242 | 1.840237 | 4.45337354 | Candidatus Collierbacteria bacterium GW2 | 2053540 | Bacteria | Bacteria | 64.7 | 1.91e-10 | NR | KKS94594.1 | 1618390 | g27848 | i0 | 71.1 | 0.471074380165289 | 38 | 11 | 47.1 | 0 | 127 | 240 | 3 | 40 | KKS94594.1 MAG: Metallo-beta-lactamase family protein [Candidatus Collierbacteria bacterium GW2011_GWC2_43_12] | diamond | 114 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Collieribacteriota | Candidatus Collierbacteria bacterium GW2011_GWC2_43_12 | ||||||
| 29484202 | 29484202 | PRJNA753704_P_NODE_21910_length_261_cov_1.537234_g21549_i0 | PRJNA753704 | 21910 | 261 | 1.537234 | 4.01218074 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 110 | 4.99e-26 | NR | MFA5387552.1 | 2053589 | g21549 | i0 | 60 | 1.94252873563218 | 85 | 34 | 97.7 | 0 | 5 | 259 | 355 | 439 | MFA5387552.1 DUF5906 domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 507 | 110 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29673585 | 29673585 | PRJNA753704_P_NODE_21370_length_264_cov_1.225131_g21009_i0 | PRJNA753704 | 21370 | 264 | 1.225131 | 3.23434584 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 111 | 3.51e-28 | NR | MBI3629924.1 | 2053607 | g21009 | i0 | 65.1 | 1.88636363636364 | 83 | 28 | 93.2 | 1 | 260 | 15 | 140 | 222 | MBI3629924.1 hypothetical protein [Candidatus Rokuibacteriota bacterium] | diamond | 498 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 30716294 | 30716294 | PRJNA753704_P_NODE_16894_length_293_cov_1.413636_g16533_i0 | PRJNA753704 | 16894 | 293 | 1.413636 | 4.14195348 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.9 | 0.0279 | NR | MCK9352242.1 | 2053589 | g16533 | i0 | 29.9 | 1.09556313993174 | 107 | 56 | 98.3 | 4 | 292 | 5 | 1013 | 1111 | MCK9352242.1 DUF2341 domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 321 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31411789 | 31411789 | PRJNA753704_P_NODE_28396_length_242_cov_0.923077_g28035_i0 | PRJNA753704 | 28396 | 242 | 0.923077 | 2.23384634 | Candidatus Saccharibacteria bacterium 32-49-12 | 1970479 | Bacteria | Bacteria | 72.8 | 9.29e-13 | NR | OYX41104.1 | 1970479 | g28035 | i0 | 43.8 | 0.793388429752066 | 64 | 36 | 79.3 | 0 | 193 | 2 | 164 | 227 | OYX41104.1 MAG: hypothetical protein B7Y94_05565 [Candidatus Saccharibacteria bacterium 32-49-12] | diamond | 192 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-49-12 | ||||||
| 31601679 | 31601679 | PRJNA753704_P_NODE_25116_length_249_cov_1.267045_g24755_i0 | PRJNA753704 | 25116 | 249 | 1.267045 | 3.15494205 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 95.5 | 1.08e-20 | NR | MCL4419262.1 | 2052139 | g24755 | i0 | 55.6 | 0.975903614457831 | 81 | 30 | 97.6 | 1 | 6 | 248 | 69 | 143 | MCL4419262.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 243 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31791101 | 31791101 | PRJNA753704_P_NODE_27417_length_244_cov_0.912281_g27056_i0 | PRJNA753704 | 27417 | 244 | 0.912281 | 2.22596564 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 73.2 | 7.04e-13 | NR | MBP7654848.1 | 2030827 | g27056 | i0 | 57.9 | 0.700819672131147 | 57 | 24 | 70.1 | 0 | 2 | 172 | 86 | 142 | MBP7654848.1 hypothetical protein [Candidatus Dependentiae bacterium] | diamond | 171 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 31822759 | 31822759 | PRJNA753704_P_NODE_24757_length_250_cov_0.881356_g24396_i0 | PRJNA753704 | 24757 | 250 | 0.881356 | 2.20339 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 130 | 3.77e-34 | NR | MBP9750653.1 | 2735830 | g24396 | i0 | 77.1 | 0.996 | 83 | 18 | 99.6 | 1 | 249 | 1 | 3 | 84 | MBP9750653.1 S-layer homology domain-containing protein [Candidatus Peribacteraceae bacterium] | diamond | 249 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 32487549 | 32487549 | PRJNA753704_P_NODE_28899_length_239_cov_2.144578_g28538_i0 | PRJNA753704 | 28899 | 239 | 2.144578 | 5.12554142 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 110 | 5.98e-26 | NR | MCL4419431.1 | 2052139 | g28538 | i0 | 88.1 | 0.740585774058577 | 59 | 6 | 72.8 | 1 | 2 | 175 | 529 | 587 | MCL4419431.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 177 | 110 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32519271 | 32519271 | PRJNA753704_P_NODE_24279_length_251_cov_0.876404_g23918_i0 | PRJNA753704 | 24279 | 251 | 0.876404 | 2.19977404 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 42.7 | 0.0428 | NR | MFA5128081.1 | 2052139 | g23918 | i0 | 36.7 | 0.717131474103586 | 60 | 38 | 71.7 | 0 | 39 | 218 | 1105 | 1164 | MFA5128081.1 tail fiber domain-containing protein [Patescibacteria group bacterium] | diamond | 180 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;