contig_metadata
7 rows where bioproject = "PRJNA1240804", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6152941 | 6152941 | PRJNA1240804_P_NODE_42845_length_231_cov_4.087912_g42479_i0 | PRJNA1240804 | 42845 | 231 | 4.087912 | 9.44307672 | Fibrobacter | 832 | Bacteria | Bacteria | 353 | 5.05e-93 | NTclustered | gi|470485271|ref|NR_076693.1| | 834 | g42479 | i0 | 95.872 | 383.017316017316 | 218 | 9 | 94 | 0 | 1 | 218 | 2883 | 2666 | Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence | blastn | 88477 | 353 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter succinogenes | |
| 15651578 | 15651578 | PRJNA1240804_P_NODE_58633_length_207_cov_0.987342_g58267_i0 | PRJNA1240804 | 58633 | 207 | 0.987342 | 2.04379794 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 143 | 1.04e-29 | NTclustered | gi|1958056460|gb|CP064986.1| | 2052160 | g58267 | i0 | 80.829 | 620.526570048309 | 193 | 27 | 92 | 10 | 12 | 201 | 2062506 | 2062691 | Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome | blastn | 128449 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 16352555 | 16352555 | PRJNA1240804_P_NODE_273_length_1591_cov_5.618029_g142_i0 | PRJNA1240804 | 273 | 1591 | 5.618029 | 89.38284139 | Fibrobacter | 832 | Bacteria | Bacteria | 2049 | 0 | NTclustered | gi|470485271|ref|NR_076693.1| | 834 | g142 | i0 | 90.087 | 149.591451917033 | 1614 | 111 | 99 | 36 | 11 | 1586 | 55 | 1657 | Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence | blastn | 238000 | 2061 | 0.994177583697234 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter succinogenes | |
| 17628227 | 17628227 | PRJNA1240804_P_NODE_9934_length_409_cov_3.177778_g9572_i0 | PRJNA1240804 | 9934 | 409 | 3.177778 | 12.99711202 | Fibrobacter | 832 | Bacteria | Bacteria | 671 | 0 | NTclustered | gi|470485271|ref|NR_076693.1| | 834 | g9572 | i0 | 96.992 | 202.40097799511 | 399 | 12 | 98 | 0 | 11 | 409 | 2047 | 2445 | Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence | blastn | 82782 | 671 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter succinogenes | |
| 20176455 | 20176455 | PRJNA1240804_P_NODE_58496_length_207_cov_1.208861_g58130_i0 | PRJNA1240804 | 58496 | 207 | 1.208861 | 2.50234227 | Fibrobacter | 832 | Bacteria | Bacteria | 292 | 9.8e-75 | NTclustered | gi|1328372416|emb|LT975083.1| | 833 | g58130 | i0 | 93.401 | 96.0676328502416 | 197 | 13 | 95 | 0 | 1 | 197 | 46 | 242 | Fibrobacter succinogenes partial 16S rRNA gene, isolate Igm-sheep | blastn | 19886 | 292 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter succinogenes | |
| 27263186 | 27263186 | PRJNA1240804_P_NODE_115323_length_168_cov_0.873950_g114957_i0 | PRJNA1240804 | 115323 | 168 | 0.87395 | 1.468236 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 42.4 | 0.0184 | NR | MFH0920131.1 | 2052160 | g114957 | i0 | 54.3 | 0.625 | 35 | 16 | 62.5 | 0 | 50 | 154 | 494 | 528 | MFH0920131.1 aldo/keto reductase [Fibrobacterota bacterium] | diamond | 105 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 31590648 | 31590648 | PRJNA1240804_P_NODE_135816_length_164_cov_1.026087_g135450_i0 | PRJNA1240804 | 135816 | 164 | 1.026087 | 1.68278268 | Chitinivibrionales bacterium | 2663014 | Bacteria | Bacteria | 80.5 | 6.27e-16 | NR | MBN1982710.1 | 2663014 | g135450 | i0 | 85.7 | 3.60365853658537 | 49 | 7 | 89.6 | 0 | 17 | 163 | 420 | 468 | MBN1982710.1 ATP-dependent RecD-like DNA helicase [Chitinivibrionales bacterium] | diamond | 591 | 80.5 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Chitinivibrionia | Chitinivibrionales | Chitinivibrionales 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);;