contig_metadata
4 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Delongiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12512438 | 12512438 | PRJNA1148190_P_NODE_112830_length_499_cov_1.462441_g101668_i0 | PRJNA1148190 | 112830 | 499 | 1.462441 | 7.29758059 | Candidatus Delongbacteria bacterium | 2044594 | Bacteria | Bacteria | 124 | 1.37e-32 | NR | MBN1968505.1 | 2044594 | g101668 | i0 | 68.8 | 0.480961923847695 | 80 | 25 | 48.1 | 0 | 257 | 496 | 5 | 84 | MBN1968505.1 GTP cyclohydrolase I FolE [Candidatus Delongbacteria bacterium] | diamond | 240 | 124 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Delongiibacteriota | Candidatus Delongbacteria bacterium | ||||||
| 29648650 | 29648650 | PRJNA1148190_P_NODE_590250_length_251_cov_0.865169_g579077_i0 | PRJNA1148190 | 590250 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 82 | 6.03e-16 | NR | MFA6652879.1 | 2044594 | g579077 | i0 | 44.6 | 1.9840637450199201 | 83 | 45 | 98 | 1 | 246 | 1 | 113 | 195 | MFA6652879.1 hypothetical protein [Candidatus Delongbacteria bacterium] | diamond | 498 | 82 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Delongiibacteriota | Candidatus Delongbacteria bacterium | ||||||
| 30039505 | 30039505 | PRJNA1148190_P_NODE_389611_length_288_cov_1.595349_g378438_i0 | PRJNA1148190 | 389611 | 288 | 1.595349 | 4.59460512 | Candidatus Delongbacteria bacterium | 2044594 | Bacteria | Bacteria | 111 | 3.8e-29 | NR | MBN1970164.1 | 2044594 | g378438 | i0 | 74.2 | 0.6875 | 66 | 17 | 68.8 | 0 | 284 | 87 | 62 | 127 | MBN1970164.1 type II toxin-antitoxin system VapC family toxin [Candidatus Delongbacteria bacterium] | diamond | 198 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Delongiibacteriota | Candidatus Delongbacteria bacterium | ||||||
| 31892861 | 31892861 | PRJNA1148190_P_NODE_543017_length_258_cov_1.643243_g531844_i0 | PRJNA1148190 | 543017 | 258 | 1.643243 | 4.23956694 | Bacteria | 2 | Bacteria | Bacteria | 142 | 2.1e-39 | NR | MDD4205411.1 | 2044594 | g531844 | i0 | 71.8 | 7.90697674418605 | 85 | 24 | 98.8 | 0 | 257 | 3 | 132 | 216 | MDD4205411.1 glycosyltransferase family 2 protein [Candidatus Delongbacteria bacterium] | diamond | 2040 | 143 | 0.993006993006993 | Bacteria | Bacteria candidate phyla | Candidatus Delongiibacteriota | Candidatus Delongbacteria 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);;