contig_metadata
7 rows where bioproject = "PRJNA980839", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8609459 | 8609459 | PRJNA980839_P_NODE_108447_length_344_cov_3.140221_g104663_i0 | PRJNA980839 | 108447 | 344 | 3.140221 | 10.80236024 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 63.9 | 1.5e-5 | NTclustered | gi|2108406931|gb|CP070637.1| | 2651167 | g104663 | i0 | 100 | 1.46220930232558 | 34 | 0 | 10 | 0 | 136 | 169 | 1477381 | 1477348 | MAG: Ignavibacterium sp. isolate bin94 chromosome | blastn | 503 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 27506500 | 27506500 | PRJNA980839_P_NODE_243083_length_233_cov_3.268750_g239299_i0 | PRJNA980839 | 243083 | 233 | 3.26875 | 7.6161875 | Bacteria | 2 | Bacteria | Bacteria | 45.8 | 0.00261 | NR | MCB0722430.1 | 2026749 | g239299 | i0 | 32.8 | 5.3175965665236 | 67 | 45 | 86.3 | 0 | 10 | 210 | 325 | 391 | MCB0722430.1 ABC transporter ATP-binding protein [Ignavibacteriota bacterium] | diamond | 1239 | 46.2 | 0.991341991341991 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 27690090 | 27690090 | PRJNA980839_P_NODE_234464_length_242_cov_0.911243_g230680_i0 | PRJNA980839 | 234464 | 242 | 0.911243 | 2.20520806 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 163 | 1.28e-44 | NR | HOP50712.1 | 2049428 | g230680 | i0 | 98.8 | 0.991735537190083 | 80 | 1 | 99.2 | 0 | 3 | 242 | 855 | 934 | HOP50712.1 hypothetical protein [Ignavibacteriales bacterium] | diamond | 240 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 27879127 | 27879127 | PRJNA980839_P_NODE_179305_length_263_cov_1.621053_g175521_i0 | PRJNA980839 | 179305 | 263 | 1.621053 | 4.26336939 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 156 | 6.289999999999998e-42 | NR | MBI2794146.1 | 2053306 | g175521 | i0 | 98.9 | 0.992395437262357 | 87 | 1 | 99.2 | 0 | 3 | 263 | 994 | 1080 | MBI2794146.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 261 | 156 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29805106 | 29805106 | PRJNA980839_P_NODE_239631_length_241_cov_0.916667_g235847_i0 | PRJNA980839 | 239631 | 241 | 0.916667 | 2.20916747 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 144 | 3.579999999999999e-38 | NR | MEI9975212.1 | 2026749 | g235847 | i0 | 95 | 0.995850622406639 | 80 | 4 | 99.6 | 0 | 240 | 1 | 238 | 317 | MEI9975212.1 YjhG/YagF family D-xylonate dehydratase [Ignavibacteriota bacterium] | diamond | 240 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 30089381 | 30089381 | PRJNA980839_P_NODE_180772_length_262_cov_1.629630_g176988_i0 | PRJNA980839 | 180772 | 262 | 1.62963 | 4.2696306 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 80.9 | 1.17e-17 | NR | MBK7985850.1 | 2053306 | g176988 | i0 | 100 | 0.458015267175573 | 40 | 0 | 45.8 | 0 | 2 | 121 | 57 | 96 | MBK7985850.1 RNA-binding protein [Ignavibacteria bacterium] | diamond | 120 | 80.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31448378 | 31448378 | PRJNA980839_P_NODE_181676_length_261_cov_2.436170_g177892_i0 | PRJNA980839 | 181676 | 261 | 2.43617 | 6.3584037 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 60.5 | 1.32e-8 | NR | MBK6760985.1 | 2053306 | g177892 | i0 | 68.3 | 0.942528735632184 | 41 | 13 | 47.1 | 0 | 4 | 126 | 57 | 97 | MBK6760985.1 tetratricopeptide repeat protein [Ignavibacteria bacterium] | diamond | 246 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria 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);;