contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA1233465" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26230084 | 26230084 | PRJNA1233465e_S_NODE_55054_length_247_cov_2.333333_g53744_i0 | PRJNA1233465 | 55054 | 247 | 2.333333 | 5.76333251 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 103 | 9.44e-26 | NR | MEN9353122.1 | 2052160 | g53744 | i0 | 65 | 0.97165991902834 | 80 | 28 | 97.2 | 0 | 242 | 3 | 71 | 150 | MEN9353122.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 240 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 32916053 | 32916053 | PRJNA1233465e_S_NODE_119905_length_179_cov_1.176923_g118595_i0 | PRJNA1233465 | 119905 | 179 | 1.176923 | 2.10669217 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 117 | 3.18e-30 | NR | HQF55948.1 | 2725311 | g118595 | i0 | 100 | 0.988826815642458 | 59 | 0 | 98.9 | 0 | 177 | 1 | 31 | 89 | HQF55948.1 TIGR02147 family protein [Fibrobacteria bacterium] | diamond | 177 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 32916971 | 32916971 | PRJNA1233465f_S_NODE_248089_length_164_cov_1.773913_g245809_i0 | PRJNA1233465 | 248089 | 164 | 1.773913 | 2.90921732 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 80.9 | 2.35e-17 | NR | MEN9353122.1 | 2052160 | g245809 | i0 | 72.2 | 0.98780487804878 | 54 | 15 | 98.8 | 0 | 162 | 1 | 76 | 129 | MEN9353122.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 162 | 80.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 32934406 | 32934406 | PRJNA1233465f_S_NODE_77713_length_266_cov_1.175115_g75433_i0 | PRJNA1233465 | 77713 | 266 | 1.175115 | 3.1258059 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 176 | 1.4e-53 | NR | HQF53669.1 | 2725311 | g75433 | i0 | 92 | 0.992481203007519 | 88 | 7 | 99.2 | 0 | 266 | 3 | 112 | 199 | HQF53669.1 DUF413 domain-containing protein [Fibrobacteria bacterium] | diamond | 264 | 176 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 32950467 | 32950467 | PRJNA1233465e_S_NODE_140338_length_168_cov_1.260504_g139028_i0 | PRJNA1233465 | 140338 | 168 | 1.260504 | 2.11764672 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 75.1 | 1.39e-14 | NR | HQF55467.1 | 2725311 | g139028 | i0 | 66.1 | 5.44642857142857 | 56 | 18 | 98.2 | 1 | 2 | 166 | 45 | 100 | HQF55467.1 TetR/AcrR family transcriptional regulator [Fibrobacteria bacterium] | diamond | 915 | 75.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 32951119 | 32951119 | PRJNA1233465f_S_NODE_163402_length_193_cov_2.513889_g161122_i0 | PRJNA1233465 | 163402 | 193 | 2.513889 | 4.85180577 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 136 | 2.21e-35 | NR | HQF55950.1 | 2725311 | g161122 | i0 | 100 | 0.994818652849741 | 64 | 0 | 99.5 | 0 | 2 | 193 | 102 | 165 | HQF55950.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 192 | 136 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 32968526 | 32968526 | PRJNA1233465f_S_NODE_228866_length_168_cov_1.285714_g226586_i0 | PRJNA1233465 | 228866 | 168 | 1.285714 | 2.15999952 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 113 | 7.74e-28 | NR | HQF53608.1 | 2725311 | g226586 | i0 | 94.5 | 0.982142857142857 | 55 | 3 | 98.2 | 0 | 2 | 166 | 302 | 356 | HQF53608.1 carboxypeptidase M32 [Fibrobacteria bacterium] | diamond | 165 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 32984957 | 32984957 | PRJNA1233465e_S_NODE_70003_length_223_cov_2.850575_g68693_i0 | PRJNA1233465 | 70003 | 223 | 2.850575 | 6.35678225 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 131 | 4.22e-34 | NR | MEN9354910.1 | 2052160 | g68693 | i0 | 84.7 | 0.968609865470852 | 72 | 11 | 96.9 | 0 | 217 | 2 | 386 | 457 | MEN9354910.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 216 | 131 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 33002347 | 33002347 | PRJNA1233465f_S_NODE_177459_length_187_cov_1.108696_g175179_i0 | PRJNA1233465 | 177459 | 187 | 1.108696 | 2.07326152 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 125 | 8.789999999999999e-32 | NR | MEN9307030.1 | 2052160 | g175179 | i0 | 88.5 | 1.9572192513369 | 61 | 7 | 97.9 | 0 | 185 | 3 | 435 | 495 | MEN9307030.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 366 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 33002472 | 33002472 | PRJNA1233465f_S_NODE_236739_length_166_cov_1.940171_g234459_i0 | PRJNA1233465 | 236739 | 166 | 1.940171 | 3.22068386 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 101 | 1.8399999999999998e-23 | NR | MEN9354910.1 | 2052160 | g234459 | i0 | 83.6 | 0.993975903614458 | 55 | 9 | 99.4 | 0 | 165 | 1 | 374 | 428 | MEN9354910.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 165 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 33002774 | 33002774 | PRJNA1233465f_S_NODE_76259_length_268_cov_1.374429_g73979_i0 | PRJNA1233465 | 76259 | 268 | 1.374429 | 3.68346972 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 162 | 3.53e-44 | NR | HQF55217.1 | 2725311 | g73979 | i0 | 91 | 0.996268656716418 | 89 | 8 | 99.6 | 0 | 267 | 1 | 271 | 359 | HQF55217.1 Calx-beta domain-containing protein [Fibrobacteria bacterium] | diamond | 267 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 33036140 | 33036140 | PRJNA1233465e_S_NODE_97060_length_195_cov_1.438356_g95750_i0 | PRJNA1233465 | 97060 | 195 | 1.438356 | 2.8047942 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 47 | 6.24e-4 | NR | HNY32412.1 | 2725311 | g95750 | i0 | 44.4 | 1.66153846153846 | 54 | 30 | 83.1 | 0 | 179 | 18 | 1 | 54 | HNY32412.1 transglycosylase SLT domain-containing protein [Fibrobacteria bacterium] | diamond | 324 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 33051979 | 33051979 | PRJNA1233465b_S_NODE_388069_length_151_cov_4.725490_g386384_i0 | PRJNA1233465 | 388069 | 151 | 4.72549 | 7.1354899 | Chitinispirillaceae bacterium | 2813024 | Bacteria | Bacteria | 43.1 | 0.00788 | NR | MBN1758209.1 | 2813024 | g386384 | i0 | 50 | 0.874172185430464 | 44 | 21 | 87.4 | 1 | 148 | 17 | 332 | 374 | MBN1758209.1 hypothetical protein [Chitinispirillaceae bacterium] | diamond | 132 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Chitinispirillia | Chitinispirillales | Chitinispirillaceae | Chitinispirillaceae bacterium | ||
| 33069765 | 33069765 | PRJNA1233465e_S_NODE_133677_length_171_cov_1.713115_g132367_i0 | PRJNA1233465 | 133677 | 171 | 1.713115 | 2.92942665 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 77.4 | 8.28e-15 | NR | MDB5047255.1 | 2052160 | g132367 | i0 | 77.1 | 2.59649122807018 | 48 | 11 | 84.2 | 0 | 145 | 2 | 585 | 632 | MDB5047255.1 hypothetical protein [Fibrobacterota bacterium] | diamond | 444 | 77.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 33070074 | 33070074 | PRJNA1233465e_S_NODE_67549_length_227_cov_0.977528_g66239_i0 | PRJNA1233465 | 67549 | 227 | 0.977528 | 2.21898856 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 48.1 | 3.69e-4 | NR | HQF55200.1 | 2725311 | g66239 | i0 | 68.8 | 0.422907488986784 | 32 | 10 | 42.3 | 0 | 1 | 96 | 385 | 416 | HQF55200.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Fibrobacteria bacterium] | diamond | 96 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 33103954 | 33103954 | PRJNA1233465e_S_NODE_122558_length_177_cov_2.968750_g121248_i0 | PRJNA1233465 | 122558 | 177 | 2.96875 | 5.2546875 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 123 | 5.239999999999999e-31 | NR | HQF55950.1 | 2725311 | g121248 | i0 | 100 | 0.983050847457627 | 58 | 0 | 98.3 | 0 | 176 | 3 | 107 | 164 | HQF55950.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 174 | 123 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 33104443 | 33104443 | PRJNA1233465e_S_NODE_93238_length_198_cov_1.711409_g91928_i0 | PRJNA1233465 | 93238 | 198 | 1.711409 | 3.38858982 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 135 | 4.519999999999999e-35 | NR | HQF55950.1 | 2725311 | g91928 | i0 | 93.9 | 1 | 66 | 4 | 100 | 0 | 198 | 1 | 276 | 341 | HQF55950.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 198 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 33156170 | 33156170 | PRJNA1233465f_S_NODE_69408_length_279_cov_1.160870_g67128_i0 | PRJNA1233465 | 69408 | 279 | 1.16087 | 3.2388273 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 151 | 2.68e-40 | NR | HQF53638.1 | 2725311 | g67128 | i0 | 83.7 | 0.989247311827957 | 92 | 15 | 98.9 | 0 | 3 | 278 | 665 | 756 | HQF53638.1 S49 family peptidase [Fibrobacteria bacterium] | diamond | 276 | 151 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 33172243 | 33172243 | PRJNA1233465e_S_NODE_113552_length_183_cov_1.305970_g112242_i0 | PRJNA1233465 | 113552 | 183 | 1.30597 | 2.3899251 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 108 | 1.55e-25 | NR | HQF53638.1 | 2725311 | g112242 | i0 | 88.5 | 1 | 61 | 7 | 100 | 0 | 1 | 183 | 660 | 720 | HQF53638.1 S49 family peptidase [Fibrobacteria bacterium] | diamond | 183 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 33172790 | 33172790 | PRJNA1233465f_S_NODE_113592_length_226_cov_1.887006_g111312_i0 | PRJNA1233465 | 113592 | 226 | 1.887006 | 4.26463356 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 70.9 | 2.2e-12 | NR | HQF54651.1 | 2725311 | g111312 | i0 | 94.7 | 0.504424778761062 | 38 | 2 | 50.4 | 0 | 112 | 225 | 1 | 38 | HQF54651.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 114 | 70.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria 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);;