contig_metadata
6 rows where bioproject = "PRJNA883229", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8512811 | 8512811 | PRJNA883229_P_NODE_13047_length_247_cov_0.896552_g13001_i0 | PRJNA883229 | 13047 | 247 | 0.896552 | 2.21448344 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 160 | 2.55e-46 | NR | MBR6298841.1 | 2137880 | g13001 | i0 | 98.8 | 0.995951417004049 | 82 | 1 | 99.6 | 0 | 247 | 2 | 34 | 115 | MBR6298841.1 virulence RhuM family protein [Candidatus Gastranaerophilales bacterium] | diamond | 246 | 160 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 27939893 | 27939893 | PRJNA883229_P_NODE_13025_length_247_cov_0.896552_g12979_i0 | PRJNA883229 | 13025 | 247 | 0.896552 | 2.21448344 | Candidatus Gastranaerophilaceae bacterium | 3022870 | Bacteria | Bacteria | 165 | 2.73e-45 | NR | MEE3349352.1 | 3022870 | g12979 | i0 | 90.2 | 2.98785425101215 | 82 | 8 | 99.6 | 0 | 246 | 1 | 16 | 97 | MEE3349352.1 beta-galactosidase [Candidatus Gastranaerophilaceae bacterium] | diamond | 738 | 165 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilaceae | Candidatus Gastranaerophilaceae bacterium | |||
| 29171301 | 29171301 | PRJNA883229_P_NODE_14969_length_244_cov_0.912281_g14923_i0 | PRJNA883229 | 14969 | 244 | 0.912281 | 2.22596564 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 137 | 7.279999999999999e-37 | NR | MBR2068349.1 | 2137880 | g14923 | i0 | 84 | 0.995901639344262 | 81 | 13 | 99.6 | 0 | 243 | 1 | 255 | 335 | MBR2068349.1 metallophosphoesterase [Candidatus Gastranaerophilales bacterium] | diamond | 243 | 137 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 29676015 | 29676015 | PRJNA883229_P_NODE_12750_length_247_cov_0.896552_g12704_i0 | PRJNA883229 | 12750 | 247 | 0.896552 | 2.21448344 | Candidatus Gastranaerophilales bacterium HUM_2 | 1916214 | Bacteria | Bacteria | 89 | 2.22e-19 | NR | DAA87526.1 | 1916214 | g12704 | i0 | 67.7 | 0.789473684210526 | 65 | 21 | 78.9 | 0 | 1 | 195 | 183 | 247 | DAA87526.1 MAG TPA: hypothetical protein CPT82_00095 [Candidatus Gastranaerophilales bacterium HUM_2] | diamond | 195 | 89 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_2 | ||||
| 30149927 | 30149927 | PRJNA883229_P_NODE_6112_length_287_cov_1.420561_g6066_i0 | PRJNA883229 | 6112 | 287 | 1.420561 | 4.07701007 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 97.8 | 9.12e-22 | NR | MBQ4647057.1 | 2137880 | g6066 | i0 | 90.7 | 1.69337979094077 | 54 | 5 | 56.4 | 0 | 124 | 285 | 243 | 296 | MBQ4647057.1 flagellar basal body P-ring protein FlgI [Candidatus Gastranaerophilales bacterium] | diamond | 486 | 97.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 31856920 | 31856920 | PRJNA883229_P_NODE_15517_length_243_cov_0.917647_g15471_i0 | PRJNA883229 | 15517 | 243 | 0.917647 | 2.22988221 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 99 | 6.35e-23 | NR | MCX4275918.1 | 2137880 | g15471 | i0 | 58.2 | 1.98765432098765 | 79 | 31 | 95.1 | 1 | 8 | 238 | 167 | 245 | MCX4275918.1 glycosyltransferase family 2 protein [Candidatus Gastranaerophilales bacterium] | diamond | 483 | 99 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales 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);;