contig_metadata
6 rows where bioproject = "PRJNA1182301", tax_clade = "FCB group" and tax_phylum = "Fibrobacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1041900 | 1041900 | PRJNA1182301_P_NODE_68901_length_196_cov_4.585366_g68776_i0 | PRJNA1182301 | 68901 | 196 | 4.585366 | 8.98731736 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 82.4 | 1.97e-17 | NR | MEN9354344.1 | 2052160 | g68776 | i0 | 58.5 | 0.994897959183674 | 65 | 27 | 99.5 | 0 | 2 | 196 | 136 | 200 | MEN9354344.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 195 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 26913960 | 26913960 | PRJNA1182301_P_NODE_52322_length_248_cov_3.194286_g52197_i0 | PRJNA1182301 | 52322 | 248 | 3.194286 | 7.92182928 | Fibrobacter sp. UWB13 | 1896204 | Bacteria | Bacteria | 45.1 | 0.00602 | NR | WP_085490532.1 | 1896204 | g52197 | i0 | 70.4 | 0.326612903225806 | 27 | 8 | 32.7 | 0 | 247 | 167 | 64 | 90 | WP_085490532.1 BspA family leucine-rich repeat surface protein [Fibrobacter sp. UWB13] | diamond | 81 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. UWB13 | |
| 29080922 | 29080922 | PRJNA1182301_P_NODE_12608_length_321_cov_1.479839_g12483_i0 | PRJNA1182301 | 12608 | 321 | 1.479839 | 4.75028319 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 58.2 | 2.88e-7 | NR | WP_139829305.1 | 1896204 | g12483 | i0 | 64.9 | 1.41121495327103 | 37 | 13 | 34.6 | 0 | 314 | 204 | 244 | 280 | WP_139829305.1 BspA family leucine-rich repeat surface protein [Fibrobacter sp. UWB13] | diamond | 453 | 58.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. UWB13 | |
| 29535327 | 29535327 | PRJNA1182301_P_NODE_40610_length_261_cov_1.638298_g40485_i0 | PRJNA1182301 | 40610 | 261 | 1.638298 | 4.27595778 | Fibrobacter sp. UWT2 | 1896224 | Bacteria | Bacteria | 66.6 | 1.58e-10 | NR | WP_083585378.1 | 1896224 | g40485 | i0 | 66 | 1.60919540229885 | 47 | 16 | 54 | 0 | 2 | 142 | 241 | 287 | WP_083585378.1 BspA family leucine-rich repeat surface protein [Fibrobacter sp. UWT2] | diamond | 420 | 66.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. UWT2 | |
| 30767347 | 30767347 | PRJNA1182301_P_NODE_3514_length_481_cov_1.982843_g3390_i0 | PRJNA1182301 | 3514 | 481 | 1.982843 | 9.53747483 | Fibrobacter sp. UWB7 | 1896206 | Bacteria | Bacteria | 62 | 9.43e-8 | NR | WP_073442723.1 | 1896206 | g3390 | i0 | 81.8 | 0.205821205821206 | 33 | 6 | 20.6 | 0 | 319 | 221 | 637 | 669 | WP_073442723.1 BspA family leucine-rich repeat surface protein [Fibrobacter sp. UWB7] | diamond | 99 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. UWB7 | |
| 32884711 | 32884711 | PRJNA1182301_P_NODE_19700_length_289_cov_1.976852_g19575_i0 | PRJNA1182301 | 19700 | 289 | 1.976852 | 5.71310228 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 169 | 1.22e-49 | NR | MBO5950800.1 | 2652288 | g19575 | i0 | 99 | 0.996539792387543 | 96 | 1 | 99.7 | 0 | 1 | 288 | 112 | 207 | MBO5950800.1 flippase-like domain-containing protein [Fibrobacteraceae bacterium] | diamond | 288 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae 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);;