contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_phylum = "Candidatus Daviesiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26684609 | 26684609 | PRJEB11748_P_NODE_358601_length_193_cov_6.068182_g356418_i0 | PRJEB11748 | 358601 | 193 | 6.068182 | 11.71159126 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 64.7 | 2.15e-10 | NR | MBI2596870.1 | 2053542 | g356418 | i0 | 64.6 | 0.746113989637306 | 48 | 17 | 74.6 | 0 | 170 | 27 | 5 | 52 | MBI2596870.1 glycosyltransferase [Candidatus Daviesbacteria bacterium] | diamond | 144 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium | ||||||
| 27032891 | 27032891 | PRJEB11748_P_NODE_55242_length_574_cov_7.775828_g53121_i0 | PRJEB11748 | 55242 | 574 | 7.775828 | 44.63325272 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 177 | 1.2299999999999999e-47 | NR | MBI2018248.1 | 2053542 | g53121 | i0 | 75 | 1.18118466898955 | 112 | 28 | 58.5 | 0 | 358 | 23 | 511 | 622 | MBI2018248.1 DUF4012 domain-containing protein [Candidatus Daviesbacteria bacterium] | diamond | 678 | 177 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium | ||||||
| 28927742 | 28927742 | PRJEB11748_P_NODE_370608_length_187_cov_5.039683_g368425_i0 | PRJEB11748 | 370608 | 187 | 5.039683 | 9.42420721 | Candidatus Daviesbacteria bacterium GW2 | 2053542 | Bacteria | Bacteria | 68.6 | 1.39e-11 | NR | KKQ59638.1 | 1618421 | g368425 | i0 | 60 | 0.962566844919786 | 60 | 15 | 81.8 | 1 | 165 | 13 | 290 | 349 | KKQ59638.1 MAG: Phosphoenolpyruvate synthase [Candidatus Daviesbacteria bacterium GW2011_GWA2_38_17] | diamond | 180 | 68.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium GW2011_GWA2_38_17 | ||||||
| 30032886 | 30032886 | PRJEB11748_P_NODE_172771_length_309_cov_4.495968_g170588_i0 | PRJEB11748 | 172771 | 309 | 4.495968 | 13.89254112 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 123 | 4.529999999999999e-31 | NR | MBI4038830.1 | 2053542 | g170588 | i0 | 82.4 | 3.96116504854369 | 68 | 12 | 66 | 0 | 289 | 86 | 87 | 154 | MBI4038830.1 LCP family protein [Candidatus Daviesbacteria bacterium] | diamond | 1224 | 123 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium | ||||||
| 30033093 | 30033093 | PRJEB11748_P_NODE_80371_length_468_cov_30.125307_g78207_i0 | PRJEB11748 | 80371 | 468 | 30.125307 | 140.98643676 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 75.1 | 2.26e-12 | NR | MBI2334617.1 | 2053542 | g78207 | i0 | 34.4 | 1.78846153846154 | 151 | 86 | 95.5 | 6 | 465 | 19 | 500 | 639 | MBI2334617.1 hypothetical protein [Candidatus Daviesbacteria bacterium] | diamond | 837 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium | ||||||
| 32056004 | 32056004 | PRJEB11748_P_NODE_369878_length_187_cov_14.325397_g367695_i0 | PRJEB11748 | 369878 | 187 | 14.325397 | 26.78849239 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 57 | 5.36e-9 | NR | MBI4036096.1 | 2053542 | g367695 | i0 | 78.1 | 2.05347593582888 | 32 | 7 | 51.3 | 0 | 97 | 2 | 1 | 32 | MBI4036096.1 50S ribosomal protein L35 [Candidatus Daviesbacteria bacterium] | diamond | 384 | 57 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria 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);;