contig_metadata
12 rows where bioproject = "PRJNA540466", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8161008 | 8161008 | PRJNA540466_S_NODE_56627_length_251_cov_2.185393_g56078_i0 | PRJNA540466 | 56627 | 251 | 2.185393 | 5.48533643 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 69.3 | 1.82e-11 | NR | MBE2256785.1 | 2053306 | g56078 | i0 | 52.5 | 0.705179282868526 | 59 | 27 | 70.5 | 1 | 199 | 23 | 1 | 58 | MBE2256785.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium] | diamond | 177 | 69.3 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 10712391 | 10712391 | PRJNA540466_S_NODE_66829_length_232_cov_2.647799_g66280_i0 | PRJNA540466 | 66829 | 232 | 2.647799 | 6.14289368 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 150 | 5.0599999999999985e-43 | NR | MBN8568963.1 | 2053306 | g66280 | i0 | 100 | 1.78448275862069 | 69 | 0 | 89.2 | 0 | 209 | 3 | 16 | 84 | MBN8568963.1 pantoate--beta-alanine ligase [Ignavibacteria bacterium] | diamond | 414 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 26729242 | 26729242 | PRJNA540466_S_NODE_50421_length_263_cov_2.389474_g49872_i0 | PRJNA540466 | 50421 | 263 | 2.389474 | 6.28431662 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 106 | 1.76e-25 | NR | HWA07532.1 | 2053306 | g49872 | i0 | 78.8 | 2.25855513307985 | 66 | 13 | 75.3 | 1 | 14 | 211 | 120 | 184 | HWA07532.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Ignavibacteria bacterium] | diamond | 594 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27898922 | 27898922 | PRJNA540466_S_NODE_47425_length_270_cov_1.467005_g46876_i0 | PRJNA540466 | 47425 | 270 | 1.467005 | 3.9609135 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 80.5 | 1.73e-15 | NR | MBK8946091.1 | 2026749 | g46876 | i0 | 52.9 | 0.755555555555556 | 68 | 32 | 75.6 | 0 | 256 | 53 | 298 | 365 | MBK8946091.1 2-aminoethylphosphonate--pyruvate transaminase [Ignavibacteriota bacterium] | diamond | 204 | 80.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 29130635 | 29130635 | PRJNA540466_S_NODE_35909_length_304_cov_1.316017_g35360_i0 | PRJNA540466 | 35909 | 304 | 1.316017 | 4.00069168 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 198 | 1.27e-59 | NR | MBN8571197.1 | 2053306 | g35360 | i0 | 97 | 1.99342105263158 | 101 | 3 | 99.7 | 0 | 2 | 304 | 116 | 216 | MBN8571197.1 oligosaccharide flippase family protein [Ignavibacteria bacterium] | diamond | 606 | 198 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29288230 | 29288230 | PRJNA540466_S_NODE_38689_length_294_cov_2.457014_g38140_i0 | PRJNA540466 | 38689 | 294 | 2.457014 | 7.22362116 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 166 | 1.15e-48 | NR | MBE2225703.1 | 2053306 | g38140 | i0 | 87.5 | 0.979591836734694 | 96 | 12 | 98 | 0 | 2 | 289 | 144 | 239 | MBE2225703.1 alpha/beta fold hydrolase [Ignavibacteria bacterium] | diamond | 288 | 166 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30109387 | 30109387 | PRJNA540466_S_NODE_32532_length_317_cov_2.102459_g31983_i0 | PRJNA540466 | 32532 | 317 | 2.102459 | 6.66479503 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 87.8 | 5.42e-18 | NR | MBE2227555.1 | 2053306 | g31983 | i0 | 93.2 | 0.416403785488959 | 44 | 3 | 41.6 | 0 | 20 | 151 | 300 | 343 | MBE2227555.1 DUF1028 domain-containing protein [Ignavibacteria bacterium] | diamond | 132 | 87.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30362631 | 30362631 | PRJNA540466_S_NODE_59232_length_247_cov_4.482759_g58683_i0 | PRJNA540466 | 59232 | 247 | 4.482759 | 11.07241473 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 123 | 1.3e-33 | NR | MBE2228188.1 | 2053306 | g58683 | i0 | 93.5 | 0.753036437246964 | 62 | 4 | 75.3 | 0 | 194 | 9 | 105 | 166 | MBE2228188.1 DUF1579 domain-containing protein [Ignavibacteria bacterium] | diamond | 186 | 123 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30930983 | 30930983 | PRJNA540466_S_NODE_58094_length_249_cov_1.596591_g57545_i0 | PRJNA540466 | 58094 | 249 | 1.596591 | 3.97551159 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 155 | 9.37e-45 | NR | MBE2228691.1 | 2053306 | g57545 | i0 | 98.8 | 0.987951807228916 | 82 | 1 | 98.8 | 0 | 2 | 247 | 147 | 228 | MBE2228691.1 ParB/RepB/Spo0J family partition protein [Ignavibacteria bacterium] | diamond | 246 | 155 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31088862 | 31088862 | PRJNA540466_S_NODE_35535_length_305_cov_2.250000_g34986_i0 | PRJNA540466 | 35535 | 305 | 2.25 | 6.8625 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 45.4 | 0.00903 | NR | MBK8983927.1 | 2053306 | g34986 | i0 | 33.3 | 0.708196721311475 | 72 | 47 | 69.8 | 1 | 68 | 280 | 1334 | 1405 | MBK8983927.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 216 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31341812 | 31341812 | PRJNA540466_S_NODE_11776_length_499_cov_5.659624_g11235_i0 | PRJNA540466 | 11776 | 499 | 5.659624 | 28.24152376 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 63.2 | 1.33e-8 | NR | MBT8378653.1 | 2053306 | g11235 | i0 | 40 | 0.541082164328657 | 90 | 50 | 51.7 | 2 | 483 | 226 | 133 | 222 | MBT8378653.1 ankyrin repeat domain-containing protein [Ignavibacteria bacterium] | diamond | 270 | 63.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31752878 | 31752878 | PRJNA540466_S_NODE_13857_length_466_cov_9.796438_g13311_i0 | PRJNA540466 | 13857 | 466 | 9.796438 | 45.65140108 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 67.4 | 1.05e-9 | NR | MBL8007704.1 | 2053306 | g13311 | i0 | 45.3 | 1.39699570815451 | 75 | 40 | 47.6 | 1 | 276 | 55 | 1 | 75 | MBL8007704.1 aminomethyl-transferring glycine dehydrogenase [Ignavibacteria bacterium] | diamond | 651 | 67.4 | 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);;