contig_metadata
6 rows where bioproject = "PRJNA615351", tax_clade = "FCB group" and tax_phylum = "Candidatus Hydrogenedentota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27174947 | 27174947 | PRJNA615351_P_NODE_104362_length_300_cov_1.992453_g90263_i0 | PRJNA615351 | 104362 | 300 | 1.992453 | 5.977359 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 87.8 | 5.37e-19 | NR | MBI2432841.1 | 2030809 | g90263 | i0 | 50 | 6.9 | 82 | 40 | 82 | 1 | 284 | 39 | 71 | 151 | MBI2432841.1 superoxide dismutase family protein [Candidatus Hydrogenedentota bacterium] | diamond | 2070 | 87.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 28122822 | 28122822 | PRJNA615351_P_NODE_82585_length_409_cov_1.553476_g68531_i0 | PRJNA615351 | 82585 | 409 | 1.553476 | 6.35371684 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 45.8 | 0.0173 | NR | MBX7257789.1 | 2030809 | g68531 | i0 | 41.7 | 0.440097799511002 | 60 | 31 | 41.1 | 2 | 390 | 223 | 180 | 239 | MBX7257789.1 O-antigen ligase family protein [Candidatus Hydrogenedentota bacterium] | diamond | 180 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 28501775 | 28501775 | PRJNA615351_P_NODE_89587_length_368_cov_1.372372_g75509_i0 | PRJNA615351 | 89587 | 368 | 1.372372 | 5.05032896 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 66.2 | 7.98e-10 | NR | MFP6581223.1 | 2030809 | g75509 | i0 | 34.3 | 3.26902173913043 | 108 | 65 | 84.8 | 2 | 339 | 28 | 4 | 109 | MFP6581223.1 NADP-dependent malic enzyme [Candidatus Hydrogenedentota bacterium] | diamond | 1203 | 66.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 30302161 | 30302161 | PRJNA615351_P_NODE_80872_length_420_cov_1.540260_g66830_i0 | PRJNA615351 | 80872 | 420 | 1.54026 | 6.469092 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 47.4 | 0.00587 | NR | MEK8023911.1 | 2030809 | g66830 | i0 | 34.2 | 1.56428571428571 | 76 | 46 | 54.3 | 1 | 175 | 402 | 599 | 670 | MEK8023911.1 tetratricopeptide repeat protein [Candidatus Hydrogenedentota bacterium] | diamond | 657 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 30522613 | 30522613 | PRJNA615351_P_NODE_108113_length_286_cov_2.633466_g94014_i0 | PRJNA615351 | 108113 | 286 | 2.633466 | 7.53171276 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 59.3 | 9.19e-8 | NR | MFP6583619.1 | 2030809 | g94014 | i0 | 47.1 | 0.713286713286713 | 68 | 33 | 68.2 | 2 | 88 | 282 | 37 | 104 | MFP6583619.1 immunoglobulin-like domain-containing protein [Candidatus Hydrogenedentota bacterium] | diamond | 204 | 59.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 31692418 | 31692418 | PRJNA615351_P_NODE_94257_length_344_cov_1.792880_g80169_i0 | PRJNA615351 | 94257 | 344 | 1.79288 | 6.1675072 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 45.4 | 0.0137 | NR | MFM1921694.1 | 2030809 | g80169 | i0 | 46.9 | 0.427325581395349 | 49 | 25 | 41.9 | 1 | 277 | 134 | 635 | 683 | MFM1921694.1 hypothetical protein [Candidatus Hydrogenedentota bacterium] | diamond | 147 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota 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);;