contig_metadata
9 rows where bioproject = "PRJNA1132896", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11762256 | 11762256 | PRJNA1132896_P_NODE_7170_length_250_cov_0.870056_g7079_i0 | PRJNA1132896 | 7170 | 250 | 0.870056 | 2.17514 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 154 | 5.269999999999999e-42 | NR | MCU0332065.1 | 2651163 | g7079 | i0 | 81.9 | 2.976 | 83 | 15 | 99.6 | 0 | 2 | 250 | 407 | 489 | MCU0332065.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 744 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 14312560 | 14312560 | PRJNA1132896_P_NODE_5552_length_267_cov_1.211340_g5461_i0 | PRJNA1132896 | 5552 | 267 | 1.21134 | 3.2342778 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 195 | 3.84e-45 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g5461 | i0 | 85.946 | 1.35205992509363 | 185 | 22 | 69 | 4 | 56 | 238 | 3705410 | 3705592 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 361 | 195 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 23235972 | 23235972 | PRJNA1132896_P_NODE_7919_length_248_cov_0.880000_g7828_i0 | PRJNA1132896 | 7919 | 248 | 0.88 | 2.1824 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 72 | 1.63e-12 | NR | HRB00589.1 | 2053306 | g7828 | i0 | 81 | 0.508064516129032 | 42 | 8 | 50.8 | 0 | 135 | 10 | 337 | 378 | HRB00589.1 site-specific integrase [Ignavibacteria bacterium] | diamond | 126 | 72 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28681118 | 28681118 | PRJNA1132896_P_NODE_4847_length_277_cov_1.495098_g4756_i0 | PRJNA1132896 | 4847 | 277 | 1.495098 | 4.14142146 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 139 | 6.8e-37 | NR | HET56687.1 | 2053306 | g4756 | i0 | 81.8 | 0.833935018050541 | 77 | 14 | 83.4 | 0 | 231 | 1 | 54 | 130 | HET56687.1 ABC transporter substrate-binding protein [Ignavibacteria bacterium] | diamond | 231 | 139 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29564970 | 29564970 | PRJNA1132896_P_NODE_3810_length_292_cov_1.159817_g3719_i0 | PRJNA1132896 | 3810 | 292 | 1.159817 | 3.38666564 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 48.9 | 4.47e-4 | NR | MEJ5261861.1 | 2651167 | g3719 | i0 | 31.8 | 1.64383561643836 | 85 | 53 | 82.2 | 1 | 292 | 53 | 302 | 386 | MEJ5261861.1 T9SS type A sorting domain-containing protein [Ignavibacterium sp.] | diamond | 480 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 30038732 | 30038732 | PRJNA1132896_P_NODE_9071_length_244_cov_0.900585_g8980_i0 | PRJNA1132896 | 9071 | 244 | 0.900585 | 2.1974274 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 155 | 2.59e-43 | NR | MBK8553051.1 | 2053306 | g8980 | i0 | 93.8 | 4.91803278688525 | 80 | 5 | 98.4 | 0 | 3 | 242 | 381 | 460 | MBK8553051.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 1200 | 155 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30607353 | 30607353 | PRJNA1132896_P_NODE_7293_length_250_cov_0.870056_g7202_i0 | PRJNA1132896 | 7293 | 250 | 0.870056 | 2.17514 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 118 | 8.87e-29 | NR | MCB0728760.1 | 2026749 | g7202 | i0 | 67.5 | 0.996 | 83 | 27 | 99.6 | 0 | 2 | 250 | 239 | 321 | MCB0728760.1 hypothetical protein [Ignavibacteriota bacterium] | diamond | 249 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31366112 | 31366112 | PRJNA1132896_P_NODE_6076_length_259_cov_3.102151_g5985_i0 | PRJNA1132896 | 6076 | 259 | 3.102151 | 8.03457109 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 82.4 | 1.45e-16 | NR | HSW53463.1 | 2651163 | g5985 | i0 | 46.8 | 0.891891891891892 | 77 | 39 | 86.9 | 1 | 258 | 34 | 208 | 284 | HSW53463.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 231 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 32568337 | 32568337 | PRJNA1132896_P_NODE_6559_length_253_cov_1.283333_g6468_i0 | PRJNA1132896 | 6559 | 253 | 1.283333 | 3.24683249 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 60.5 | 2.5e-8 | NR | MFH1206129.1 | 2026749 | g6468 | i0 | 56.9 | 1.90909090909091 | 51 | 22 | 60.5 | 0 | 153 | 1 | 1001 | 1051 | MFH1206129.1 SdrD B-like domain-containing protein [Ignavibacteriota bacterium] | diamond | 483 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota 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);;