contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJDB4470" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10212236 | 10212236 | PRJDB4470_P_NODE_32149_length_401_cov_1.465909_g31001_i0 | PRJDB4470 | 32149 | 401 | 1.465909 | 5.87829509 | candidate division CPR1 bacterium ADurb.Bin16 | 1618338 | Bacteria | Bacteria | 131 | 6.249999999999999e-34 | NR | OQB40762.1 | 1852826 | g31001 | i0 | 84 | 1.12219451371571 | 75 | 12 | 56.1 | 0 | 175 | 399 | 90 | 164 | OQB40762.1 MAG: putative transposase [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 450 | 131 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 27285349 | 27285349 | PRJDB4470_P_NODE_97923_length_172_cov_1.292683_g96768_i0 | PRJDB4470 | 97923 | 172 | 1.292683 | 2.22341476 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 104 | 9.31e-26 | NR | MDB5159905.1 | 2026720 | g96768 | i0 | 94.7 | 1.98837209302326 | 57 | 3 | 99.4 | 0 | 1 | 171 | 8 | 64 | MDB5159905.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 342 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27317125 | 27317125 | PRJDB4470_P_NODE_121543_length_162_cov_1.805310_g120388_i0 | PRJDB4470 | 121543 | 162 | 1.80531 | 2.9246022 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 84.3 | 1.9e-17 | NR | HVB33634.1 | 2052139 | g120388 | i0 | 73.6 | 0.981481481481482 | 53 | 14 | 98.1 | 0 | 3 | 161 | 328 | 380 | HVB33634.1 cytochrome P450 [Patescibacteria group bacterium] | diamond | 159 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27538127 | 27538127 | PRJDB4470_P_NODE_68084_length_225_cov_2.625000_g66929_i0 | PRJDB4470 | 68084 | 225 | 2.625 | 5.90625 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 42 | 0.0191 | NR | MEK7498903.1 | 2052139 | g66929 | i0 | 53.6 | 0.373333333333333 | 28 | 13 | 37.3 | 0 | 25 | 108 | 82 | 109 | MEK7498903.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 84 | 42 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28390501 | 28390501 | PRJDB4470_P_NODE_62426_length_242_cov_1.373057_g61271_i0 | PRJDB4470 | 62426 | 242 | 1.373057 | 3.32279794 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 44.3 | 0.00997 | NR | HUY25280.1 | 2973664 | g61271 | i0 | 57.6 | 0.409090909090909 | 33 | 14 | 40.9 | 0 | 41 | 139 | 271 | 303 | HUY25280.1 IS3 family transposase [Candidatus Saccharimonadales bacterium] | diamond | 99 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28453860 | 28453860 | PRJDB4470_P_NODE_87486_length_186_cov_2.211679_g86331_i0 | PRJDB4470 | 87486 | 186 | 2.211679 | 4.11372294 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 112 | 1.48e-27 | NR | MBF0981099.1 | 2044595 | g86331 | i0 | 100 | 0.983870967741935 | 61 | 0 | 98.4 | 0 | 3 | 185 | 93 | 153 | MBF0981099.1 exopolysaccharide biosynthesis polyprenyl glycosylphosphotransferase [Candidatus Altimarinota bacterium] | diamond | 183 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28611576 | 28611576 | PRJDB4470_P_NODE_100007_length_169_cov_2.341667_g98852_i0 | PRJDB4470 | 100007 | 169 | 2.341667 | 3.95741723 | Candidatus Saccharimonadaceae bacterium | 2830836 | Bacteria | Bacteria | 53.9 | 1.53e-6 | NR | HJM04591.1 | 2830836 | g98852 | i0 | 68.8 | 0.568047337278107 | 32 | 10 | 56.8 | 0 | 168 | 73 | 321 | 352 | HJM04591.1 type IV pilus assembly protein PilM [Candidatus Saccharimonadaceae bacterium] | diamond | 96 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonadaceae bacterium | |||
| 28737861 | 28737861 | PRJDB4470_P_NODE_111247_length_165_cov_0.896552_g110092_i0 | PRJDB4470 | 111247 | 165 | 0.896552 | 1.4793108 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 114 | 5.47e-31 | NR | WP_260762453.1 | 2665156 | g110092 | i0 | 90.7 | 0.981818181818182 | 54 | 5 | 98.2 | 0 | 164 | 3 | 77 | 130 | WP_260762453.1 hypothetical protein [Candidatus Mycosynbacter amalyticus] | diamond | 162 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 28769322 | 28769322 | PRJDB4470_P_NODE_113087_length_165_cov_0.870690_g111932_i0 | PRJDB4470 | 113087 | 165 | 0.87069 | 1.4366385 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 98.2 | 3.91e-22 | NR | HRY49428.1 | 2053589 | g111932 | i0 | 92.7 | 3 | 55 | 4 | 100 | 0 | 1 | 165 | 311 | 365 | HRY49428.1 multidrug efflux RND transporter permease subunit [Candidatus Paceibacterota bacterium] | diamond | 495 | 98.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29874620 | 29874620 | PRJDB4470_P_NODE_91671_length_180_cov_2.320611_g90516_i0 | PRJDB4470 | 91671 | 180 | 2.320611 | 4.1770998 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 41.6 | 0.0403 | NR | HKQ18883.1 | 2212470 | g90516 | i0 | 32.7 | 0.916666666666667 | 55 | 37 | 91.7 | 0 | 178 | 14 | 46 | 100 | HKQ18883.1 radical SAM protein [Candidatus Eiseniibacteriota bacterium] | diamond | 165 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 31163697 | 31163697 | PRJDB4470_P_NODE_90675_length_182_cov_1.157895_g89520_i0 | PRJDB4470 | 90675 | 182 | 1.157895 | 2.1073689 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 3.5e-6 | NR | MBR3236515.1 | 2026720 | g89520 | i0 | 47.9 | 4.3021978021978 | 48 | 25 | 79.1 | 0 | 1 | 144 | 662 | 709 | MBR3236515.1 DEAD/DEAH box helicase [Candidatus Saccharibacteria bacterium] | diamond | 783 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31422886 | 31422886 | PRJDB4470_P_NODE_109036_length_166_cov_0.871795_g107881_i0 | PRJDB4470 | 109036 | 166 | 0.871795 | 1.4471797 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 99.8 | 1.11e-22 | NR | MCX5924498.1 | 2030827 | g107881 | i0 | 83.6 | 0.993975903614458 | 55 | 9 | 99.4 | 0 | 1 | 165 | 282 | 336 | MCX5924498.1 primosomal protein N' [Candidatus Dependentiae bacterium] | diamond | 165 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 31707547 | 31707547 | PRJDB4470_P_NODE_60297_length_249_cov_1.505000_g59142_i0 | PRJDB4470 | 60297 | 249 | 1.505 | 3.74745 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 155 | 3.52e-45 | NR | HTR62709.1 | 2785449 | g59142 | i0 | 87.7 | 0.975903614457831 | 81 | 10 | 97.6 | 0 | 2 | 244 | 79 | 159 | HTR62709.1 alpha/beta hydrolase [Candidatus Binataceae bacterium] | diamond | 243 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 32087239 | 32087239 | PRJDB4470_P_NODE_70498_length_219_cov_2.323529_g69343_i0 | PRJDB4470 | 70498 | 219 | 2.323529 | 5.08852851 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 94.4 | 1.83e-20 | NR | MDD4804026.1 | 2053589 | g69343 | i0 | 59.7 | 1.97260273972603 | 72 | 29 | 98.6 | 0 | 217 | 2 | 799 | 870 | MDD4804026.1 anaerobic ribonucleoside-triphosphate reductase [Candidatus Paceibacterota bacterium] | diamond | 432 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32624686 | 32624686 | PRJDB4470_P_NODE_107440_length_166_cov_0.888889_g106285_i0 | PRJDB4470 | 107440 | 166 | 0.888889 | 1.47555574 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 46.2 | 7.94e-4 | NR | MBS1986725.1 | 2030827 | g106285 | i0 | 55.3 | 0.849397590361446 | 47 | 18 | 79.5 | 2 | 165 | 34 | 445 | 491 | MBS1986725.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Candidatus Dependentiae bacterium] | diamond | 141 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota 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);;