contig_metadata
7 rows where bioproject = "PRJNA508758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5588314 | 5588314 | PRJNA508758_P_NODE_35165_length_347_cov_1.120438_g34117_i0 | PRJNA508758 | 35165 | 347 | 1.120438 | 3.88791986 | Candidatus Saccharibacteria genomosp. TM7-H1 | 2080739 | Bacteria | Bacteria | 403 | 7.87e-108 | NTclustered | gi|1566427536|gb|CP026537.1| | 2080739 | g34117 | i0 | 87.679 | 326.510086455331 | 349 | 40 | 100 | 3 | 1 | 347 | 543967 | 544314 | Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome | blastn | 113299 | 403 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria genomosp. TM7-H1 | ||||||
| 29003952 | 29003952 | PRJNA508758_P_NODE_60668_length_276_cov_1.901478_g59620_i0 | PRJNA508758 | 60668 | 276 | 1.901478 | 5.24807928 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 70.1 | 1.05e-11 | NR | MCE2412708.1 | 2026781 | g59620 | i0 | 42.2 | 0.978260869565217 | 90 | 46 | 91.3 | 1 | 20 | 271 | 125 | 214 | MCE2412708.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 270 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 29035258 | 29035258 | PRJNA508758_P_NODE_26608_length_391_cov_0.921384_g25560_i0 | PRJNA508758 | 26608 | 391 | 0.921384 | 3.60261144 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 45.1 | 0.0258 | NR | HJU62362.1 | 2838779 | g25560 | i0 | 32.9 | 0.560102301790281 | 73 | 49 | 56 | 0 | 335 | 117 | 251 | 323 | HJU62362.1 MFS transporter [Candidatus Binatia bacterium] | diamond | 219 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29919334 | 29919334 | PRJNA508758_P_NODE_88211_length_241_cov_0.916667_g87163_i0 | PRJNA508758 | 88211 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 144 | 2.8299999999999993e-40 | NR | HRJ06181.1 | 2026720 | g87163 | i0 | 83.5 | 1.96680497925311 | 79 | 13 | 98.3 | 0 | 3 | 239 | 33 | 111 | HRJ06181.1 rhodanese-related sulfurtransferase [Candidatus Saccharibacteria bacterium] | diamond | 474 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30582465 | 30582465 | PRJNA508758_P_NODE_87773_length_241_cov_1.488095_g86725_i0 | PRJNA508758 | 87773 | 241 | 1.488095 | 3.58630895 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 41.2 | 0.0236 | NR | MEK7839327.1 | 2072417 | g86725 | i0 | 40 | 0.684647302904564 | 55 | 33 | 68.5 | 0 | 7 | 171 | 8 | 62 | MEK7839327.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 165 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31056944 | 31056944 | PRJNA508758_P_NODE_85195_length_243_cov_0.905882_g84147_i0 | PRJNA508758 | 85195 | 243 | 0.905882 | 2.20129326 | Candidatus Aerophobetes bacterium | 2030807 | Bacteria | Bacteria | 42.7 | 0.0369 | NR | TET12792.1 | 2030807 | g84147 | i0 | 36.8 | 0.938271604938272 | 76 | 39 | 87.7 | 3 | 13 | 225 | 284 | 355 | TET12792.1 MAG: hypothetical protein E3J84_01000 [Candidatus Aerophobetes bacterium] | diamond | 228 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 32037025 | 32037025 | PRJNA508758_P_NODE_55598_length_287_cov_1.369159_g54550_i0 | PRJNA508758 | 55598 | 287 | 1.369159 | 3.92948633 | Sumerlaeia bacterium | 3066091 | Bacteria | Bacteria | 73.6 | 8.59e-13 | NR | HUT24884.1 | 3066091 | g54550 | i0 | 42.3 | 1.01393728222997 | 97 | 53 | 98.3 | 1 | 5 | 286 | 56 | 152 | HUT24884.1 alpha-L-fucosidase [Sumerlaeia bacterium] | diamond | 291 | 73.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Sumerlaeia 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);;