contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA951810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26993741 | 26993741 | PRJNA951810_P_NODE_13182_length_526_cov_5.571744_g12855_i0 | PRJNA951810 | 13182 | 526 | 5.571744 | 29.30737344 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 62.8 | 4.44e-8 | NR | RJP60438.1 | 2049428 | g12855 | i0 | 52.4 | 0.359315589353612 | 63 | 24 | 33.7 | 3 | 166 | 342 | 219 | 279 | RJP60438.1 MAG: methionyl-tRNA formyltransferase [Ignavibacteriales bacterium] | diamond | 189 | 62.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 27373579 | 27373579 | PRJNA951810_P_NODE_109183_length_287_cov_4.439252_g108839_i0 | PRJNA951810 | 109183 | 287 | 4.439252 | 12.74065324 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 82.4 | 1.71e-17 | NR | MBL0322143.1 | 2053306 | g108839 | i0 | 49.4 | 1.69337979094077 | 81 | 41 | 84.7 | 0 | 243 | 1 | 1 | 81 | MBL0322143.1 GyrI-like domain-containing protein [Ignavibacteria bacterium] | diamond | 486 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27689430 | 27689430 | PRJNA951810_P_NODE_107704_length_288_cov_4.306977_g107360_i0 | PRJNA951810 | 107704 | 288 | 4.306977 | 12.40409376 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 43.1 | 0.0463 | NR | MCX6120642.1 | 2049428 | g107360 | i0 | 29.6 | 0.84375 | 81 | 49 | 81.3 | 2 | 23 | 256 | 106 | 181 | MCX6120642.1 alpha-amylase family glycosyl hydrolase [Ignavibacteriales bacterium] | diamond | 243 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 28257260 | 28257260 | PRJNA951810_P_NODE_136526_length_268_cov_4.107692_g136181_i0 | PRJNA951810 | 136526 | 268 | 4.107692 | 11.00861456 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 63.9 | 1.72e-9 | NR | MDP2886580.1 | 2053306 | g136181 | i0 | 59.2 | 1.08582089552239 | 49 | 20 | 54.9 | 0 | 158 | 12 | 182 | 230 | MDP2886580.1 PAS domain S-box protein [Ignavibacteria bacterium] | diamond | 291 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28800476 | 28800476 | PRJNA951810_P_NODE_181387_length_230_cov_5.566879_g181042_i0 | PRJNA951810 | 181387 | 230 | 5.566879 | 12.8038217 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 87.8 | 3.38e-18 | NR | MEI9973267.1 | 2026749 | g181042 | i0 | 56.6 | 4.95652173913043 | 76 | 33 | 99.1 | 0 | 1 | 228 | 340 | 415 | MEI9973267.1 alkaline phosphatase family protein [Ignavibacteriota bacterium] | diamond | 1140 | 88.6 | 0.99097065462754 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 28832144 | 28832144 | PRJNA951810_P_NODE_119368_length_280_cov_5.608696_g119023_i0 | PRJNA951810 | 119368 | 280 | 5.608696 | 15.7043488 | Bacteria | 2 | Bacteria | Bacteria | 120 | 1.74e-30 | NR | MBI1807933.1 | 2053306 | g119023 | i0 | 58.1 | 3.98571428571429 | 93 | 39 | 99.6 | 0 | 1 | 279 | 36 | 128 | MBI1807933.1 IS110 family transposase [Ignavibacteria bacterium] | diamond | 1116 | 121 | 0.991735537190083 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29179760 | 29179760 | PRJNA951810_P_NODE_13449_length_522_cov_4.345212_g13122_i0 | PRJNA951810 | 13449 | 522 | 4.345212 | 22.68200664 | Bacteria | 2 | Bacteria | Bacteria | 107 | 2.1e-23 | NR | MCK9210229.1 | 2651163 | g13122 | i0 | 52.9 | 6.72413793103448 | 85 | 40 | 48.9 | 0 | 5 | 259 | 440 | 524 | MCK9210229.1 tetratricopeptide repeat protein [Ignavibacteriaceae bacterium] | diamond | 3510 | 108 | 0.990740740740741 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 30878664 | 30878664 | PRJNA951810_P_NODE_122474_length_278_cov_4.424390_g122129_i0 | PRJNA951810 | 122474 | 278 | 4.42439 | 12.2998042 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 58.2 | 1.62e-7 | NR | HWQ81535.1 | 2053306 | g122129 | i0 | 40.9 | 0.712230215827338 | 66 | 39 | 71.2 | 0 | 207 | 10 | 59 | 124 | HWQ81535.1 tetratricopeptide repeat protein [Ignavibacteria bacterium] | diamond | 198 | 58.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31131271 | 31131271 | PRJNA951810_P_NODE_192815_length_209_cov_6.911765_g192470_i0 | PRJNA951810 | 192815 | 209 | 6.911765 | 14.44558885 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 104 | 1.2999999999999998e-24 | NR | HMS65037.1 | 2053306 | g192470 | i0 | 71 | 3.94736842105263 | 69 | 20 | 99 | 0 | 209 | 3 | 268 | 336 | HMS65037.1 cryptochrome/photolyase family protein [Ignavibacteria bacterium] | diamond | 825 | 104 | 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);;