contig_metadata
12 rows where bioproject = "PRJNA493632", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26633454 | 26633454 | PRJNA493632_P_NODE_556641_length_248_cov_0.880000_g553202_i0 | PRJNA493632 | 556641 | 248 | 0.88 | 2.1824 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 120 | 4.05e-30 | NR | NLL13246.1 | 35828 | g553202 | i0 | 72.2 | 0.955645161290323 | 79 | 22 | 95.6 | 0 | 1 | 237 | 165 | 243 | NLL13246.1 carboxypeptidase regulatory-like domain-containing protein [Fibrobacter sp.] | diamond | 237 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 26791944 | 26791944 | PRJNA493632_P_NODE_653981_length_241_cov_0.916667_g650540_i0 | PRJNA493632 | 653981 | 241 | 0.916667 | 2.20916747 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 152 | 1.43e-40 | NR | NLL12832.1 | 35828 | g650540 | i0 | 91.3 | 0.995850622406639 | 80 | 7 | 99.6 | 0 | 241 | 2 | 369 | 448 | NLL12832.1 PAS domain S-box protein [Fibrobacter sp.] | diamond | 240 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 26887048 | 26887048 | PRJNA493632_P_NODE_629841_length_243_cov_0.905882_g626400_i0 | PRJNA493632 | 629841 | 243 | 0.905882 | 2.20129326 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 75.5 | 6.7e-14 | NR | NLL14622.1 | 35828 | g626400 | i0 | 76.5 | 1.8641975308642 | 51 | 12 | 63 | 0 | 243 | 91 | 276 | 326 | NLL14622.1 hypothetical protein [Fibrobacter sp.] | diamond | 453 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 28403092 | 28403092 | PRJNA493632_P_NODE_526266_length_250_cov_0.870056_g522827_i0 | PRJNA493632 | 526266 | 250 | 0.870056 | 2.17514 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 177 | 1.04e-50 | NR | NLL14932.1 | 35828 | g522827 | i0 | 98.8 | 0.996 | 83 | 1 | 99.6 | 0 | 2 | 250 | 364 | 446 | NLL14932.1 hypothetical protein [Fibrobacter sp.] | diamond | 249 | 177 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 28434735 | 28434735 | PRJNA493632_P_NODE_615566_length_244_cov_0.900585_g612125_i0 | PRJNA493632 | 615566 | 244 | 0.900585 | 2.1974274 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 64.3 | 6.33e-11 | NR | MEN9353772.1 | 2052160 | g612125 | i0 | 72.5 | 0.491803278688525 | 40 | 11 | 49.2 | 0 | 124 | 243 | 4 | 43 | MEN9353772.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 120 | 64.3 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 29760662 | 29760662 | PRJNA493632_P_NODE_610791_length_244_cov_0.900585_g607350_i0 | PRJNA493632 | 610791 | 244 | 0.900585 | 2.1974274 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 143 | 2.4699999999999993e-40 | NR | NLP02369.1 | 35828 | g607350 | i0 | 83.8 | 1.9672131147541 | 80 | 13 | 98.4 | 0 | 242 | 3 | 56 | 135 | NLP02369.1 hypothetical protein [Fibrobacter sp.] | diamond | 480 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 31340633 | 31340633 | PRJNA493632_P_NODE_640776_length_242_cov_0.911243_g637335_i0 | PRJNA493632 | 640776 | 242 | 0.911243 | 2.20520806 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 67.8 | 5.69e-11 | NR | NLL15097.1 | 35828 | g637335 | i0 | 70.2 | 1.16528925619835 | 47 | 14 | 58.3 | 0 | 239 | 99 | 1759 | 1805 | NLL15097.1 tetratricopeptide repeat protein [Fibrobacter sp.] | diamond | 282 | 67.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 31403996 | 31403996 | PRJNA493632_P_NODE_571436_length_247_cov_0.885057_g567997_i0 | PRJNA493632 | 571436 | 247 | 0.885057 | 2.18609079 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 110 | 6.82e-27 | NR | MEK7394105.1 | 2052160 | g567997 | i0 | 72.8 | 0.983805668016194 | 81 | 22 | 98.4 | 0 | 247 | 5 | 86 | 166 | MEK7394105.1 STAS domain-containing protein [Fibrobacterota bacterium] | diamond | 243 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 31498885 | 31498885 | PRJNA493632_P_NODE_517496_length_250_cov_2.451977_g514057_i0 | PRJNA493632 | 517496 | 250 | 2.451977 | 6.1299425 | Chitinispirillum alkaliphilum | 1008392 | Bacteria | Bacteria | 43.9 | 0.0153 | NR | KMQ50187.1 | 1008392 | g514057 | i0 | 25.3 | 0.948 | 79 | 58 | 93.6 | 1 | 249 | 16 | 77 | 155 | KMQ50187.1 group 1 glycosyl transferase [Chitinispirillum alkaliphilum] | diamond | 237 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Chitinispirillia | Chitinispirillales | Chitinispirillaceae | Chitinispirillum | Chitinispirillum alkaliphilum | |
| 31562239 | 31562239 | PRJNA493632_P_NODE_630056_length_243_cov_0.905882_g626615_i0 | PRJNA493632 | 630056 | 243 | 0.905882 | 2.20129326 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 159 | 4e-43 | NR | NLL14699.1 | 35828 | g626615 | i0 | 98.8 | 0.987654320987654 | 80 | 1 | 98.8 | 0 | 242 | 3 | 57 | 136 | NLL14699.1 glycogen/starch/alpha-glucan phosphorylase [Fibrobacter sp.] | diamond | 240 | 159 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 32163276 | 32163276 | PRJNA493632_P_NODE_641658_length_242_cov_0.911243_g638217_i0 | PRJNA493632 | 641658 | 242 | 0.911243 | 2.20520806 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 88.6 | 1.13e-18 | NR | NLG38581.1 | 35828 | g638217 | i0 | 92.2 | 0.632231404958678 | 51 | 4 | 63.2 | 0 | 8 | 160 | 285 | 335 | NLG38581.1 hypothetical protein [Fibrobacter sp.] | diamond | 153 | 88.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 32684416 | 32684416 | PRJNA493632_P_NODE_432660_length_265_cov_2.312500_g429221_i0 | PRJNA493632 | 432660 | 265 | 2.3125 | 6.128125 | Bacteria | 2 | Bacteria | Bacteria | 48.9 | 1.45e-4 | NR | KMQ51331.1 | 1008392 | g429221 | i0 | 37.3 | 1.26792452830189 | 59 | 37 | 66.8 | 0 | 182 | 6 | 22 | 80 | KMQ51331.1 hypothetical protein CHISP_1814 [Chitinispirillum alkaliphilum] | diamond | 336 | 49.3 | 0.991886409736308 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Chitinispirillia | Chitinispirillales | Chitinispirillaceae | Chitinispirillum | Chitinispirillum alkaliphilum |
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);;