contig_metadata
6 rows where bioproject = "PRJNA1028258", tax_clade = "FCB group" and tax_phylum = "Fidelibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27477434 | 27477434 | PRJNA1028258_P_NODE_155243_length_230_cov_0.881988_g154680_i0 | PRJNA1028258 | 155243 | 230 | 0.881988 | 2.0285724 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 42 | 0.043 | NR | MEE9189272.1 | 2026760 | g154680 | i0 | 28.2 | 0.926086956521739 | 71 | 51 | 92.6 | 0 | 228 | 16 | 77 | 147 | MEE9189272.1 class II aldolase/adducin family protein [Fidelibacterota bacterium] | diamond | 213 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30383013 | 30383013 | PRJNA1028258_P_NODE_150673_length_231_cov_0.876543_g150110_i0 | PRJNA1028258 | 150673 | 231 | 0.876543 | 2.02481433 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 53.1 | 1.41e-6 | NR | MBT7378009.1 | 2026760 | g150110 | i0 | 61.1 | 1.4025974025974 | 36 | 14 | 46.8 | 0 | 108 | 1 | 76 | 111 | MBT7378009.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 324 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31259466 | 31259466 | PRJNA1028258_P_NODE_151775_length_231_cov_0.876543_g151212_i0 | PRJNA1028258 | 151775 | 231 | 0.876543 | 2.02481433 | Bacteria | 2 | Bacteria | Bacteria | 69.3 | 1.33e-11 | NR | MCF7797650.1 | 2026760 | g151212 | i0 | 41.1 | 2.76623376623377 | 73 | 43 | 94.8 | 0 | 226 | 8 | 288 | 360 | MCF7797650.1 gamma-glutamyltransferase [Fidelibacterota bacterium] | diamond | 639 | 69.3 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31765443 | 31765443 | PRJNA1028258_P_NODE_172097_length_226_cov_0.904459_g171534_i0 | PRJNA1028258 | 172097 | 226 | 0.904459 | 2.04407734 | FCB group | 1783270 | Bacteria | Bacteria | 73.6 | 4.23e-13 | NR | MAS39957.1 | 2026760 | g171534 | i0 | 55.1 | 5.92035398230088 | 78 | 17 | 98.2 | 3 | 1 | 222 | 498 | 561 | MAS39957.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 1338 | 73.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31773361 | 31773361 | PRJNA1028258_P_NODE_86077_length_278_cov_1.325359_g85514_i0 | PRJNA1028258 | 86077 | 278 | 1.325359 | 3.68449802 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 43.5 | 0.015 | NR | RTZ95416.1 | 2026760 | g85514 | i0 | 35.1 | 0.830935251798561 | 77 | 35 | 66.9 | 1 | 195 | 10 | 59 | 135 | RTZ95416.1 MAG: hypothetical protein DSY36_01980 [Fidelibacterota bacterium] | diamond | 231 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32776857 | 32776857 | PRJNA1028258_P_NODE_59780_length_330_cov_0.923372_g59217_i0 | PRJNA1028258 | 59780 | 330 | 0.923372 | 3.0471276 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 163 | 4.74e-49 | NR | MCH2445442.1 | 2026760 | g59217 | i0 | 68.2 | 6.88181818181818 | 107 | 31 | 97.3 | 1 | 1 | 321 | 9 | 112 | MCH2445442.1 asparagine synthase-related protein [Fidelibacterota bacterium] | diamond | 2271 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota 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);;