contig_metadata
10 rows where bioproject = "PRJNA557436", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26889217 | 26889217 | PRJNA557436_S_NODE_7901_length_158_cov_1.666667_g7853_i0 | PRJNA557436 | 7901 | 158 | 1.666667 | 2.63333386 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 96.7 | 1.1699999999999997e-23 | NR | HNY31751.1 | 2725311 | g7853 | i0 | 96.1 | 0.968354430379747 | 51 | 2 | 96.8 | 0 | 2 | 154 | 84 | 134 | HNY31751.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 153 | 96.7 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 27205020 | 27205020 | PRJNA557436_S_NODE_2422_length_244_cov_1.985646_g2374_i0 | PRJNA557436 | 2422 | 244 | 1.985646 | 4.84497624 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 144 | 5.02e-42 | NR | HQF54192.1 | 2725311 | g2374 | i0 | 86.1 | 0.971311475409836 | 79 | 11 | 97.1 | 0 | 7 | 243 | 1 | 79 | HQF54192.1 single-stranded DNA-binding protein [Fibrobacteria bacterium] | diamond | 237 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 27363602 | 27363602 | PRJNA557436_S_NODE_8003_length_158_cov_0.975610_g7955_i0 | PRJNA557436 | 8003 | 158 | 0.97561 | 1.5414638 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 43.9 | 0.00463 | NR | MBK9580296.1 | 2052160 | g7955 | i0 | 34.6 | 0.987341772151899 | 52 | 34 | 98.7 | 0 | 1 | 156 | 711 | 762 | MBK9580296.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 156 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 28910140 | 28910140 | PRJNA557436_S_NODE_4528_length_191_cov_1.032051_g4480_i0 | PRJNA557436 | 4528 | 191 | 1.032051 | 1.97121741 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 82 | 2.67e-16 | NR | HNY31768.1 | 2725311 | g4480 | i0 | 70.6 | 0.801047120418848 | 51 | 15 | 80.1 | 0 | 190 | 38 | 339 | 389 | HNY31768.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 153 | 82 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 28942284 | 28942284 | PRJNA557436_S_NODE_648_length_439_cov_2.740099_g600_i0 | PRJNA557436 | 648 | 439 | 2.740099 | 12.02903461 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 85.5 | 3.65e-16 | NR | MBK9580269.1 | 2052160 | g600 | i0 | 47.5 | 0.806378132118451 | 118 | 56 | 79.3 | 4 | 357 | 10 | 338 | 451 | MBK9580269.1 laminin G domain-containing protein [Fibrobacterota bacterium] | diamond | 354 | 85.5 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 29068492 | 29068492 | PRJNA557436_S_NODE_7508_length_161_cov_1.134921_g7460_i0 | PRJNA557436 | 7508 | 161 | 1.134921 | 1.82722281 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 66.2 | 6.22e-11 | NR | HNY31767.1 | 2725311 | g7460 | i0 | 67.4 | 0.857142857142857 | 46 | 15 | 85.7 | 0 | 9 | 146 | 14 | 59 | HNY31767.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 138 | 66.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 29194801 | 29194801 | PRJNA557436_S_NODE_6289_length_170_cov_1.577778_g6241_i0 | PRJNA557436 | 6289 | 170 | 1.577778 | 2.6822226 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 53.1 | 2.95e-6 | NR | HNY31724.1 | 2725311 | g6241 | i0 | 56.8 | 0.776470588235294 | 44 | 19 | 77.6 | 0 | 132 | 1 | 1 | 44 | HNY31724.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 132 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 29320851 | 29320851 | PRJNA557436_S_NODE_6769_length_166_cov_1.610687_g6721_i0 | PRJNA557436 | 6769 | 166 | 1.610687 | 2.67374042 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 70.1 | 5.36e-13 | NR | HNY31728.1 | 2725311 | g6721 | i0 | 59.3 | 0.975903614457831 | 54 | 22 | 97.6 | 0 | 3 | 164 | 81 | 134 | HNY31728.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 162 | 70.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 30047051 | 30047051 | PRJNA557436_S_NODE_3331_length_214_cov_1.564246_g3283_i0 | PRJNA557436 | 3331 | 214 | 1.564246 | 3.34748644 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 102 | 8.51e-26 | NR | MBK9580280.1 | 2052160 | g3283 | i0 | 100 | 0.686915887850467 | 49 | 0 | 68.7 | 0 | 68 | 214 | 1 | 49 | MBK9580280.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 147 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 30078708 | 30078708 | PRJNA557436_S_NODE_9352_length_151_cov_1.353448_g9304_i0 | PRJNA557436 | 9352 | 151 | 1.353448 | 2.04370648 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 81.3 | 1.16e-16 | NR | MBK9580316.1 | 2052160 | g9304 | i0 | 79.6 | 1.82781456953642 | 49 | 9 | 97.4 | 1 | 3 | 149 | 126 | 173 | MBK9580316.1 DNA adenine methylase [Fibrobacterota bacterium] | diamond | 276 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota 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);;