contig_metadata
6 rows where bioproject = "PRJEB11748" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26652739 | 26652739 | PRJEB11748_P_NODE_274041_length_233_cov_1.122093_g271858_i0 | PRJEB11748 | 274041 | 233 | 1.122093 | 2.61447669 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 58.5 | 8.51e-8 | NR | MDQ3002693.1 | 2052160 | g271858 | i0 | 57.4 | 0.695278969957081 | 54 | 23 | 69.5 | 0 | 6 | 167 | 19 | 72 | MDQ3002693.1 fatty acid desaturase [Fibrobacterota bacterium] | diamond | 162 | 58.5 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 26741332 | 26741332 | PRJEB11748_P_NODE_104821_length_407_cov_11.520231_g102649_i0 | PRJEB11748 | 104821 | 407 | 11.520231 | 46.88734017 | Bacteria | 2 | Bacteria | Bacteria | 143 | 1.3e-40 | NR | MCQ2106865.1 | 35828 | g102649 | i0 | 73.6 | 1.34152334152334 | 91 | 24 | 67.1 | 0 | 113 | 385 | 66 | 156 | MCQ2106865.1 hypothetical protein [Fibrobacter sp.] | diamond | 546 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 27380651 | 27380651 | PRJEB11748_P_NODE_16503_length_1151_cov_3.920183_g15161_i0 | PRJEB11748 | 16503 | 1151 | 3.920183 | 45.12130633 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 377 | 1.73e-125 | NR | MEO7955195.1 | 2725311 | g15161 | i0 | 72 | 1.28236316246742 | 246 | 67 | 63.6 | 1 | 1149 | 418 | 163 | 408 | MEO7955195.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 1476 | 377 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 30601349 | 30601349 | PRJEB11748_P_NODE_105173_length_407_cov_1.667630_g103001_i0 | PRJEB11748 | 105173 | 407 | 1.66763 | 6.7872541 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 67.4 | 1.23e-10 | NR | MBR4006307.1 | 35828 | g103001 | i0 | 40.5 | 0.582309582309582 | 79 | 46 | 58.2 | 1 | 384 | 148 | 33 | 110 | MBR4006307.1 hypothetical protein [Fibrobacter sp.] | diamond | 237 | 67.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 30727967 | 30727967 | PRJEB11748_P_NODE_315794_length_212_cov_3.079470_g313611_i0 | PRJEB11748 | 315794 | 212 | 3.07947 | 6.5284764 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 64.3 | 6.13e-10 | NR | MEN9308860.1 | 2052160 | g313611 | i0 | 50 | 0.877358490566038 | 62 | 29 | 84.9 | 1 | 31 | 210 | 221 | 282 | MEN9308860.1 teichoic acid export ATP-binding protein TagH [Fibrobacterota bacterium] | diamond | 186 | 64.3 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 32619013 | 32619013 | PRJEB11748_P_NODE_242180_length_252_cov_1.785340_g239997_i0 | PRJEB11748 | 242180 | 252 | 1.78534 | 4.4990568 | FCB group | 1783270 | Bacteria | Bacteria | 73.6 | 1.91e-14 | NR | WP_295860758.1 | 261512 | g239997 | i0 | 60.7 | 5.30952380952381 | 56 | 21 | 65.5 | 1 | 170 | 6 | 54 | 109 | WP_295860758.1 hypothetical protein [uncultured Fibrobacter sp.] | diamond | 1338 | 73.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | uncultured Fibrobacter sp. |
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);;