contig_metadata
7 rows where bioproject = "PRJNA752278", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2475910 | 2475910 | PRJNA752278_P_NODE_101962_length_242_cov_0.911243_g101759_i0 | PRJNA752278 | 101962 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 248 | 2.59e-61 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g101759 | i0 | 99.27 | 30.0619834710744 | 137 | 1 | 57 | 0 | 106 | 242 | 805812 | 805948 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 7275 | 248 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 12206998 | 12206998 | PRJNA752278_P_NODE_45610_length_281_cov_1.985577_g45407_i0 | PRJNA752278 | 45610 | 281 | 1.985577 | 5.57947137 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 342 | 1.3699999999999997e-89 | NTclustered | gi|1858604176|gb|CP054675.1| | 2053306 | g45407 | i0 | 88.652 | 635.597864768683 | 282 | 30 | 100 | 2 | 1 | 281 | 873281 | 873561 | Ignavibacteria bacterium isolate Ch128a chromosome, complete genome | blastn | 178603 | 342 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28284329 | 28284329 | PRJNA752278_P_NODE_17046_length_376_cov_1.762376_g16843_i0 | PRJNA752278 | 17046 | 376 | 1.762376 | 6.62653376 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 81.6 | 1.61e-15 | NR | MCF6270679.1 | 2614255 | g16843 | i0 | 68.4 | 2.3218085106383 | 57 | 18 | 45.5 | 0 | 173 | 3 | 3 | 59 | MCF6270679.1 cysteine synthase family protein [Melioribacteraceae bacterium] | diamond | 873 | 81.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 28505548 | 28505548 | PRJNA752278_P_NODE_53127_length_274_cov_1.671642_g52924_i0 | PRJNA752278 | 53127 | 274 | 1.671642 | 4.58029908 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 65.1 | 1.22e-10 | NR | HEX2869324.1 | 2049428 | g52924 | i0 | 54 | 2.81386861313869 | 63 | 27 | 69 | 1 | 200 | 12 | 116 | 176 | HEX2869324.1 NADP-dependent oxidoreductase [Ignavibacteriales bacterium] | diamond | 771 | 65.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 29021001 | 29021001 | PRJNA752278_P_NODE_688_length_1231_cov_2.089810_g563_i0 | PRJNA752278 | 688 | 1231 | 2.08981 | 25.7255611 | Bacteria | 2 | Bacteria | Bacteria | 184 | 8.55e-51 | NR | MAT57736.1 | 2026749 | g563 | i0 | 35 | 1.55483346872461 | 317 | 171 | 76.3 | 5 | 983 | 45 | 17 | 302 | MAT57736.1 fatty acid desaturase [Ignavibacteriota bacterium] | diamond | 1914 | 184 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31664521 | 31664521 | PRJNA752278_P_NODE_106217_length_239_cov_2.295181_g106014_i0 | PRJNA752278 | 106217 | 239 | 2.295181 | 5.48548259 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 108 | 8.280000000000001e-26 | NR | MCK5456842.1 | 2614255 | g106014 | i0 | 59.5 | 0.99163179916318 | 79 | 32 | 99.2 | 0 | 238 | 2 | 294 | 372 | MCK5456842.1 Glu/Leu/Phe/Val dehydrogenase [Melioribacteraceae bacterium] | diamond | 237 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 32044288 | 32044288 | PRJNA752278_P_NODE_106078_length_239_cov_2.638554_g105875_i0 | PRJNA752278 | 106078 | 239 | 2.638554 | 6.30614406 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 87 | 9.12e-18 | NR | MCX6168873.1 | 2049428 | g105875 | i0 | 78 | 3.76569037656904 | 50 | 11 | 62.8 | 0 | 239 | 90 | 1178 | 1227 | MCX6168873.1 methionine synthase [Ignavibacteriales bacterium] | diamond | 900 | 87 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales 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);;