contig_metadata
7 rows where bioproject = "PRJNA980585", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27626630 | 27626630 | PRJNA980585_P_NODE_47444_length_248_cov_0.880000_g47190_i0 | PRJNA980585 | 47444 | 248 | 0.88 | 2.1824 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 73.2 | 6.26e-15 | NR | RPI68211.1 | 2026749 | g47190 | i0 | 81.6 | 1.05241935483871 | 38 | 7 | 46 | 0 | 135 | 248 | 1 | 38 | RPI68211.1 MAG: hypothetical protein EHM43_05560 [Ignavibacteriota bacterium] | diamond | 261 | 73.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 27822228 | 27822228 | PRJNA980585_P_NODE_11984_length_393_cov_1.437500_g11730_i0 | PRJNA980585 | 11984 | 393 | 1.4375 | 5.649375 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 146 | 1.49e-42 | NR | MBI1803810.1 | 2053306 | g11730 | i0 | 56.9 | 2.67175572519084 | 116 | 50 | 88.5 | 0 | 45 | 392 | 6 | 121 | MBI1803810.1 glycine cleavage system protein GcvH [Ignavibacteria bacterium] | diamond | 1050 | 146 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28289358 | 28289358 | PRJNA980585_P_NODE_52186_length_245_cov_0.895349_g51932_i0 | PRJNA980585 | 52186 | 245 | 0.895349 | 2.19360505 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 45.8 | 0.00303 | NR | MEP7234622.1 | 2026749 | g51932 | i0 | 33.7 | 1.01632653061224 | 83 | 52 | 99.2 | 2 | 1 | 243 | 246 | 327 | MEP7234622.1 kelch repeat-containing protein [Ignavibacteriota bacterium] | diamond | 249 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 29369172 | 29369172 | PRJNA980585_P_NODE_52589_length_245_cov_0.895349_g52335_i0 | PRJNA980585 | 52589 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 103 | 3.4e-24 | NR | MCB0701341.1 | 2026749 | g52335 | i0 | 60.5 | 4.92244897959184 | 81 | 32 | 99.2 | 0 | 244 | 2 | 100 | 180 | MCB0701341.1 rhodanese-related sulfurtransferase [Ignavibacteriota bacterium] | diamond | 1206 | 104 | 0.990384615384615 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 29811039 | 29811039 | PRJNA980585_P_NODE_32031_length_274_cov_1.328358_g31777_i0 | PRJNA980585 | 32031 | 274 | 1.328358 | 3.63970092 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 121 | 9.92e-32 | NR | MDP3150510.1 | 2053306 | g31777 | i0 | 67.5 | 2.73722627737226 | 83 | 27 | 90.9 | 0 | 24 | 272 | 123 | 205 | MDP3150510.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Ignavibacteria bacterium] | diamond | 750 | 122 | 0.991803278688525 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30342682 | 30342682 | PRJNA980585_P_NODE_6772_length_497_cov_1.797170_g6518_i0 | PRJNA980585 | 6772 | 497 | 1.79717 | 8.9319349 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 46.2 | 0.0274 | NR | HEY3249713.1 | 2053306 | g6518 | i0 | 29 | 0.832997987927565 | 138 | 79 | 82.7 | 5 | 9 | 419 | 412 | 531 | HEY3249713.1 M14 family zinc carboxypeptidase [Ignavibacteria bacterium] | diamond | 414 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31416625 | 31416625 | PRJNA980585_P_NODE_48336_length_247_cov_1.327586_g48082_i0 | PRJNA980585 | 48336 | 247 | 1.327586 | 3.27913742 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 42.7 | 0.0358 | NR | MBN8585752.1 | 2053306 | g48082 | i0 | 30.7 | 0.910931174089069 | 75 | 47 | 91.1 | 3 | 15 | 239 | 207 | 276 | MBN8585752.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 225 | 42.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);;