contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA1204310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28146652 | 28146652 | PRJNA1204310_P_NODE_47185_length_267_cov_1.273196_g46888_i0 | PRJNA1204310 | 47185 | 267 | 1.273196 | 3.39943332 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 43.1 | 0.0376 | NR | MBE0570665.1 | 2651163 | g46888 | i0 | 33.3 | 0.876404494382023 | 78 | 42 | 83.1 | 4 | 37 | 258 | 503 | 574 | MBE0570665.1 T9SS type A sorting domain-containing protein [Ignavibacteriaceae bacterium] | diamond | 234 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 29472300 | 29472300 | PRJNA1204310_P_NODE_60110_length_244_cov_1.368421_g59813_i0 | PRJNA1204310 | 60110 | 244 | 1.368421 | 3.33894724 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 65.5 | 2.32e-10 | NR | MDR3668602.1 | 2651163 | g59813 | i0 | 50.8 | 0.725409836065574 | 59 | 29 | 72.5 | 0 | 3 | 179 | 230 | 288 | MDR3668602.1 histidine kinase dimerization/phospho-acceptor domain-containing protein [Ignavibacteriaceae bacterium] | diamond | 177 | 65.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 29902044 | 29902044 | PRJNA1204310_P_NODE_56771_length_248_cov_0.891429_g56474_i0 | PRJNA1204310 | 56771 | 248 | 0.891429 | 2.21074392 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 0.00168 | NR | MBE2227544.1 | 2053306 | g56474 | i0 | 42.2 | 1.54838709677419 | 64 | 33 | 72.6 | 1 | 208 | 29 | 70 | 133 | MBE2227544.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium] | diamond | 384 | 47 | 0.991489361702128 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30483387 | 30483387 | PRJNA1204310_P_NODE_25413_length_365_cov_1.517123_g25116_i0 | PRJNA1204310 | 25413 | 365 | 1.517123 | 5.53749895 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 122 | 1.3e-29 | NR | HKI77849.1 | 2651163 | g25116 | i0 | 56.7 | 4.8 | 97 | 42 | 79.7 | 0 | 293 | 3 | 8 | 104 | HKI77849.1 L-glutamate gamma-semialdehyde dehydrogenase [Ignavibacteriaceae bacterium] | diamond | 1752 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 30989006 | 30989006 | PRJNA1204310_P_NODE_43434_length_281_cov_1.471154_g43137_i0 | PRJNA1204310 | 43434 | 281 | 1.471154 | 4.13394274 | Ignavibacteriae bacterium HGW-Ignavibacteriae-4 | 2013811 | Bacteria | Bacteria | 75.5 | 1.84e-13 | NR | PKL79541.1 | 2013811 | g43137 | i0 | 43.4 | 2.64768683274021 | 83 | 40 | 88.6 | 2 | 13 | 261 | 1085 | 1160 | PKL79541.1 MAG: hypothetical protein CVV25_07710 [Ignavibacteriae bacterium HGW-Ignavibacteriae-4] | diamond | 744 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriae bacterium HGW-Ignavibacteriae-4 | |||||
| 31874196 | 31874196 | PRJNA1204310_P_NODE_22677_length_383_cov_1.509677_g22380_i0 | PRJNA1204310 | 22677 | 383 | 1.509677 | 5.78206291 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 57 | 1.8e-6 | NR | HEX2788371.1 | 2053306 | g22380 | i0 | 30.7 | 2.68668407310705 | 114 | 78 | 89.3 | 1 | 29 | 370 | 7 | 119 | HEX2788371.1 tetratricopeptide repeat protein [Ignavibacteria bacterium] | diamond | 1029 | 57 | 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);;