contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA493632" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 466232 | 466232 | PRJNA493632_P_NODE_570381_length_247_cov_0.885057_g566942_i0 | PRJNA493632 | 570381 | 247 | 0.885057 | 2.18609079 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 175 | 1.84e-49 | NR | HMN23174.1 | 2651163 | g566942 | i0 | 100 | 2.98785425101215 | 82 | 0 | 99.6 | 0 | 247 | 2 | 249 | 330 | HMN23174.1 type IX secretion system sortase PorU [Ignavibacteriaceae bacterium] | diamond | 738 | 175 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 3010796 | 3010796 | PRJNA493632_P_NODE_224843_length_329_cov_1.203125_g221408_i0 | PRJNA493632 | 224843 | 329 | 1.203125 | 3.95828125 | Bacteria | 2 | Bacteria | Bacteria | 199 | 2.9e-59 | NR | MBK7267417.1 | 2049428 | g221408 | i0 | 95.4 | 2.98176291793313 | 109 | 5 | 99.4 | 0 | 3 | 329 | 360 | 468 | MBK7267417.1 T9SS type A sorting domain-containing protein [Ignavibacteriales bacterium] | diamond | 981 | 199 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 26601594 | 26601594 | PRJNA493632_P_NODE_653821_length_241_cov_0.916667_g650380_i0 | PRJNA493632 | 653821 | 241 | 0.916667 | 2.20916747 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 162 | 1.6699999999999998e-45 | NR | MBK7267164.1 | 2049428 | g650380 | i0 | 96.2 | 0.983402489626556 | 79 | 3 | 98.3 | 0 | 2 | 238 | 25 | 103 | MBK7267164.1 Do family serine endopeptidase [Ignavibacteriales bacterium] | diamond | 237 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 26696685 | 26696685 | PRJNA493632_P_NODE_524521_length_250_cov_0.870056_g521082_i0 | PRJNA493632 | 524521 | 250 | 0.870056 | 2.17514 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 163 | 3.789999999999999e-48 | NR | MCC6254091.1 | 2651163 | g521082 | i0 | 100 | 0.996 | 83 | 0 | 99.6 | 0 | 2 | 250 | 14 | 96 | MCC6254091.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 249 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 27139530 | 27139530 | PRJNA493632_P_NODE_687682_length_232_cov_2.188679_g684241_i0 | PRJNA493632 | 687682 | 232 | 2.188679 | 5.07773528 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 63.2 | 1.79e-9 | NR | MDP3444116.1 | 2053306 | g684241 | i0 | 49.3 | 0.918103448275862 | 71 | 36 | 91.8 | 0 | 215 | 3 | 85 | 155 | MDP3444116.1 IPT/TIG domain-containing protein [Ignavibacteria bacterium] | diamond | 213 | 63.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28134870 | 28134870 | PRJNA493632_P_NODE_625705_length_243_cov_0.905882_g622264_i0 | PRJNA493632 | 625705 | 243 | 0.905882 | 2.20129326 | Ignavibacterium | 795750 | Bacteria | Bacteria | 152 | 1.0499999999999999e-40 | NR | MCC6256503.1 | 2651163 | g622264 | i0 | 100 | 1.97530864197531 | 80 | 0 | 98.8 | 0 | 241 | 2 | 798 | 877 | MCC6256503.1 multifunctional oxoglutarate decarboxylase/oxoglutarate dehydrogenase thiamine pyrophosphate-binding subunit/dihydrolipoyllysine-residue succinyltransferase subunit [Ignavibacteriaceae bacterium] | diamond | 480 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28434645 | 28434645 | PRJNA493632_P_NODE_417906_length_268_cov_2.574359_g414467_i0 | PRJNA493632 | 417906 | 268 | 2.574359 | 6.89928212 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 60.5 | 1.84e-9 | NR | MBV6418847.1 | 2651163 | g414467 | i0 | 51.6 | 0.694029850746269 | 62 | 27 | 69.4 | 1 | 192 | 7 | 9 | 67 | MBV6418847.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 186 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28497837 | 28497837 | PRJNA493632_P_NODE_245327_length_317_cov_1.262295_g241891_i0 | PRJNA493632 | 245327 | 317 | 1.262295 | 4.00147515 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 87.8 | 4.25e-19 | NR | MDP2362723.1 | 2053306 | g241891 | i0 | 58 | 0.766561514195584 | 81 | 30 | 73.8 | 2 | 84 | 317 | 1 | 80 | MDP2362723.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 243 | 87.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29571194 | 29571194 | PRJNA493632_P_NODE_510050_length_251_cov_0.865169_g506611_i0 | PRJNA493632 | 510050 | 251 | 0.865169 | 2.17157419 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 82.8 | 1.25e-17 | NR | MEJ2103308.1 | 2651163 | g506611 | i0 | 50 | 0.932270916334661 | 78 | 39 | 93.2 | 0 | 16 | 249 | 39 | 116 | MEJ2103308.1 DUF6141 family protein [Ignavibacteriaceae bacterium] | diamond | 234 | 82.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 30771907 | 30771907 | PRJNA493632_P_NODE_547934_length_248_cov_1.748571_g544495_i0 | PRJNA493632 | 547934 | 248 | 1.748571 | 4.33645608 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 49.7 | 1.38e-4 | NR | HOP50313.1 | 2049428 | g544495 | i0 | 80.6 | 0.375 | 31 | 3 | 37.5 | 1 | 243 | 151 | 431 | 458 | HOP50313.1 MFS transporter [Ignavibacteriales bacterium] | diamond | 93 | 49.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 31308948 | 31308948 | PRJNA493632_P_NODE_646055_length_242_cov_0.911243_g642614_i0 | PRJNA493632 | 646055 | 242 | 0.911243 | 2.20520806 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 152 | 1.4099999999999998e-45 | NR | MBK7866568.1 | 2049428 | g642614 | i0 | 97.5 | 0.991735537190083 | 80 | 2 | 99.2 | 0 | 240 | 1 | 1 | 80 | MBK7866568.1 Hsp20/alpha crystallin family protein [Ignavibacteriales bacterium] | diamond | 240 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 32068053 | 32068053 | PRJNA493632_P_NODE_613678_length_244_cov_0.900585_g610237_i0 | PRJNA493632 | 613678 | 244 | 0.900585 | 2.1974274 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 79.7 | 3.18e-15 | NR | MDR3611556.1 | 2651163 | g610237 | i0 | 45.8 | 4.64754098360656 | 72 | 39 | 88.5 | 0 | 2 | 217 | 233 | 304 | MDR3611556.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 1134 | 79.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 32810498 | 32810498 | PRJNA493632_P_NODE_608060_length_244_cov_1.350877_g604619_i0 | PRJNA493632 | 608060 | 244 | 1.350877 | 3.29613988 | Bacteria | 2 | Bacteria | Bacteria | 56.2 | 7.27e-8 | NR | OQY77479.1 | 1961106 | g604619 | i0 | 90 | 1.46311475409836 | 30 | 3 | 36.9 | 0 | 1 | 90 | 57 | 86 | OQY77479.1 MAG: hypothetical protein B6D45_02840 [Ignavibacteriales bacterium UTCHB3] | diamond | 357 | 56.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium UTCHB3 |
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);;