contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1073183" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5290248 | 5290248 | PRJNA1073183_P_NODE_4265_length_611_cov_2.934944_g4173_i0 | PRJNA1073183 | 4265 | 611 | 2.934944 | 17.93250784 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 319 | 1.12e-105 | NR | MCL4419852.1 | 2052139 | g4173 | i0 | 83.2 | 0.967266775777414 | 197 | 32 | 96.7 | 1 | 609 | 19 | 206 | 401 | MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium] | diamond | 591 | 319 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27003981 | 27003981 | PRJNA1073183_P_NODE_29682_length_247_cov_0.885057_g29587_i0 | PRJNA1073183 | 29682 | 247 | 0.885057 | 2.18609079 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 141 | 3.039999999999999e-38 | NR | MCL4419852.1 | 2052139 | g29587 | i0 | 87.7 | 0.983805668016194 | 81 | 10 | 98.4 | 0 | 246 | 4 | 305 | 385 | MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium] | diamond | 243 | 141 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28480126 | 28480126 | PRJNA1073183_P_NODE_26466_length_251_cov_0.865169_g26371_i0 | PRJNA1073183 | 26466 | 251 | 0.865169 | 2.17157419 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47.8 | 6.84e-4 | NR | OGD09954.1 | 1797269 | g26371 | i0 | 45.5 | 3.95617529880478 | 55 | 28 | 64.5 | 2 | 187 | 26 | 354 | 407 | OGD09954.1 MAG: hypothetical protein A2Y86_03130 [Candidatus Aminicenantes bacterium RBG_13_62_12] | diamond | 993 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium RBG_13_62_12 | ||||||
| 30383763 | 30383763 | PRJNA1073183_P_NODE_2073_length_855_cov_1.956522_g1999_i0 | PRJNA1073183 | 2073 | 855 | 1.956522 | 16.7282631 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 58.2 | 1.94e-5 | NR | MFT4569778.1 | 2838779 | g1999 | i0 | 44.4 | 0.221052631578947 | 63 | 30 | 20.4 | 1 | 179 | 6 | 294 | 356 | MFT4569778.1 cysteine-rich repeat protein [Candidatus Binatia bacterium] | diamond | 189 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30415295 | 30415295 | PRJNA1073183_P_NODE_12253_length_369_cov_1.297297_g12158_i0 | PRJNA1073183 | 12253 | 369 | 1.297297 | 4.78702593 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 90.1 | 1.76e-18 | NR | RKW21079.1 | 2044595 | g12158 | i0 | 51.1 | 0.764227642276423 | 94 | 35 | 67.5 | 1 | 94 | 342 | 3 | 96 | RKW21079.1 MAG: molecular chaperone DnaJ [Candidatus Altimarinota bacterium] | diamond | 282 | 90.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31584563 | 31584563 | PRJNA1073183_P_NODE_23576_length_269_cov_1.178571_g23481_i0 | PRJNA1073183 | 23576 | 269 | 1.178571 | 3.17035599 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 82.8 | 2.76e-16 | NR | MBU6323319.1 | 2052139 | g23481 | i0 | 45.3 | 1.9182156133829 | 86 | 45 | 95.9 | 1 | 11 | 268 | 132 | 215 | MBU6323319.1 diaminopimelate decarboxylase [Patescibacteria group bacterium] | diamond | 516 | 82.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32153866 | 32153866 | PRJNA1073183_P_NODE_22278_length_277_cov_2.176471_g22183_i0 | PRJNA1073183 | 22278 | 277 | 2.176471 | 6.02882467 | Candidatus Babeliales bacterium | 2803731 | Bacteria | Bacteria | 51.2 | 5.57e-5 | NR | HZW61089.1 | 2803731 | g22183 | i0 | 37.3 | 0.812274368231047 | 75 | 47 | 81.2 | 0 | 9 | 233 | 244 | 318 | HZW61089.1 SulP family inorganic anion transporter [Candidatus Babeliales bacterium] | diamond | 225 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliales 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);;