contig_metadata
9 rows where bioproject = "PRJNA1144090", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27027771 | 27027771 | PRJNA1144090_P_NODE_12242_length_803_cov_2.227397_g11786_i0 | PRJNA1144090 | 12242 | 803 | 2.227397 | 17.88599791 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 361 | 1.91e-117 | NR | MCB0714184.1 | 2026749 | g11786 | i0 | 66.5 | 8.49564134495641 | 251 | 84 | 93.8 | 0 | 2 | 754 | 432 | 682 | MCB0714184.1 S9 family peptidase [Ignavibacteriota bacterium] | diamond | 6822 | 363 | 0.994490358126722 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 27355118 | 27355118 | PRJNA1144090_P_NODE_37903_length_420_cov_3.337176_g37368_i0 | PRJNA1144090 | 37903 | 420 | 3.337176 | 14.0161392 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 122 | 6.819999999999999e-31 | NR | HMQ69205.1 | 2053306 | g37368 | i0 | 40.6 | 0.985714285714286 | 138 | 81 | 98.6 | 1 | 5 | 418 | 101 | 237 | HMQ69205.1 NmrA/HSCARG family protein [Ignavibacteria bacterium] | diamond | 414 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27386799 | 27386799 | PRJNA1144090_P_NODE_92243_length_261_cov_1.638298_g91708_i0 | PRJNA1144090 | 92243 | 261 | 1.638298 | 4.27595778 | Melioribacter sp. | 2052167 | Bacteria | Bacteria | 95.1 | 1.71e-20 | NR | MCX7798691.1 | 2052167 | g91708 | i0 | 54.7 | 0.988505747126437 | 86 | 39 | 98.9 | 0 | 260 | 3 | 173 | 258 | MCX7798691.1 dipeptidyl peptidase 3 [Melioribacter sp.] | diamond | 258 | 95.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacter | Melioribacter sp. | |
| 28070154 | 28070154 | PRJNA1144090_P_NODE_49165_length_364_cov_1.979381_g48630_i0 | PRJNA1144090 | 49165 | 364 | 1.979381 | 7.20494684 | FCB group | 1783270 | Bacteria | Bacteria | 159 | 2.1199999999999998e-42 | NR | MBK8943880.1 | 2026749 | g48630 | i0 | 66.1 | 4.98626373626374 | 121 | 41 | 99.7 | 0 | 2 | 364 | 587 | 707 | MBK8943880.1 methionine synthase [Ignavibacteriota bacterium] | diamond | 1815 | 159 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 28385871 | 28385871 | PRJNA1144090_P_NODE_13346_length_766_cov_2.414141_g12881_i0 | PRJNA1144090 | 13346 | 766 | 2.414141 | 18.49232006 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 223 | 2.96e-63 | NR | PIU45107.1 | 1974045 | g12881 | i0 | 47.2 | 5.87859007832898 | 254 | 113 | 97.9 | 5 | 12 | 761 | 45 | 281 | PIU45107.1 MAG: alpha-glucosidase [Ignavibacteriales bacterium CG07_land_8_20_14_0_80_59_12] | diamond | 4503 | 224 | 0.995535714285714 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium CG07_land_8_20_14_0_80_59_12 | |||
| 28775725 | 28775725 | PRJNA1144090_P_NODE_26427_length_517_cov_1.889640_g25894_i0 | PRJNA1144090 | 26427 | 517 | 1.88964 | 9.7694388 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 135 | 1.97e-35 | NR | HMQ69205.1 | 2053306 | g25894 | i0 | 45.9 | 0.858800773694391 | 148 | 79 | 85.9 | 1 | 5 | 448 | 117 | 263 | HMQ69205.1 NmrA/HSCARG family protein [Ignavibacteria bacterium] | diamond | 444 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29186507 | 29186507 | PRJNA1144090_P_NODE_56509_length_338_cov_1.652830_g55974_i0 | PRJNA1144090 | 56509 | 338 | 1.65283 | 5.5865654 | Rosettibacter primus | 3111523 | Bacteria | Bacteria | 77 | 1.08e-13 | NR | WP_353677462.1 | 3111523 | g55974 | i0 | 36.2 | 1.02958579881657 | 116 | 62 | 95.9 | 4 | 327 | 4 | 677 | 788 | WP_353677462.1 CotH kinase family protein [Rosettibacter primus] | diamond | 348 | 77 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Rosettibacter | Rosettibacter primus | |
| 29249245 | 29249245 | PRJNA1144090_P_NODE_104249_length_248_cov_0.880000_g103714_i0 | PRJNA1144090 | 104249 | 248 | 0.88 | 2.1824 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 79.3 | 5.08e-15 | NR | MBK6914723.1 | 2049428 | g103714 | i0 | 45.7 | 0.979838709677419 | 81 | 44 | 98 | 0 | 3 | 245 | 260 | 340 | MBK6914723.1 cation:proton antiporter [Ignavibacteriales bacterium] | diamond | 243 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 29501904 | 29501904 | PRJNA1144090_P_NODE_42270_length_396_cov_1.724458_g41735_i0 | PRJNA1144090 | 42270 | 396 | 1.724458 | 6.82885368 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 132 | 6.37e-33 | NR | HEX9253845.1 | 2651163 | g41735 | i0 | 56.8 | 3 | 132 | 55 | 98.5 | 1 | 394 | 5 | 186 | 317 | HEX9253845.1 vitamin B12 dependent-methionine synthase activation domain-containing protein [Ignavibacteriaceae bacterium] | diamond | 1188 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae 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);;