contig_metadata
4 rows where bioproject = "PRJNA1086823" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26687627 | 26687627 | PRJNA1086823_P_NODE_9501_length_277_cov_1.627451_g9384_i0 | PRJNA1086823 | 9501 | 277 | 1.627451 | 4.50803927 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 48.5 | 9.4e-5 | NR | HED37464.1 | 2053306 | g9384 | i0 | 75 | 0.259927797833935 | 24 | 6 | 26 | 0 | 2 | 73 | 13 | 36 | HED37464.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 72 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28804174 | 28804174 | PRJNA1086823_P_NODE_18568_length_243_cov_0.917647_g18451_i0 | PRJNA1086823 | 18568 | 243 | 0.917647 | 2.22988221 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 130 | 4.26e-33 | NR | MFA5404473.1 | 2053306 | g18451 | i0 | 81 | 1.93827160493827 | 79 | 15 | 97.5 | 0 | 3 | 239 | 367 | 445 | MFA5404473.1 DUF4153 domain-containing protein [Ignavibacteria bacterium] | diamond | 471 | 130 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28835947 | 28835947 | PRJNA1086823_P_NODE_7368_length_303_cov_2.000000_g7251_i0 | PRJNA1086823 | 7368 | 303 | 2 | 6.06 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 97.4 | 1.2699999999999999e-23 | NR | MCK9280319.1 | 2614255 | g7251 | i0 | 55.6 | 1.6039603960396 | 81 | 36 | 80.2 | 0 | 18 | 260 | 27 | 107 | MCK9280319.1 HNH endonuclease [Melioribacteraceae bacterium] | diamond | 486 | 97.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 32027414 | 32027414 | PRJNA1086823_P_NODE_15378_length_248_cov_0.891429_g15261_i0 | PRJNA1086823 | 15378 | 248 | 0.891429 | 2.21074392 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 59.7 | 5.24e-9 | NR | MBM4168621.1 | 2053306 | g15261 | i0 | 47.3 | 0.895161290322581 | 74 | 39 | 89.5 | 0 | 25 | 246 | 3 | 76 | MBM4168621.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 222 | 59.7 | 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);;