contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1067370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9108541 | 9108541 | PRJNA1067370_P_NODE_5848_length_732_cov_1.185129_g5349_i0 | PRJNA1067370 | 5848 | 732 | 1.185129 | 8.67514428 | Melioribacter | 1134403 | Bacteria | Bacteria | 311 | 1.9799999999999995e-101 | NR | MBS3944701.1 | 2052167 | g5349 | i0 | 74.1 | 14.0737704918033 | 205 | 53 | 84 | 0 | 116 | 730 | 7 | 211 | MBS3944701.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Melioribacter sp.] | diamond | 10302 | 313 | 0.993610223642173 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacter | Melioribacter sp. | |
| 16757627 | 16757627 | PRJNA1067370_P_NODE_21414_length_408_cov_1.200000_g20866_i0 | PRJNA1067370 | 21414 | 408 | 1.2 | 4.896 | Bacteria | 2 | Bacteria | Bacteria | 236 | 3.8e-72 | NR | MCB0725576.1 | 2026749 | g20866 | i0 | 80 | 20.8823529411765 | 135 | 26 | 99.3 | 1 | 406 | 2 | 149 | 282 | MCB0725576.1 phosphoenolpyruvate carboxykinase (GTP) [Ignavibacteriota bacterium] | diamond | 8520 | 236 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 27572679 | 27572679 | PRJNA1067370_P_NODE_16384_length_459_cov_1.000000_g15836_i0 | PRJNA1067370 | 16384 | 459 | 1 | 4.59 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 50.1 | 3.62e-4 | NR | MBK7631751.1 | 2049428 | g15836 | i0 | 30.4 | 1.43790849673203 | 102 | 66 | 65.4 | 2 | 431 | 132 | 76 | 174 | MBK7631751.1 GrpB family protein [Ignavibacteriales bacterium] | diamond | 660 | 50.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 28204043 | 28204043 | PRJNA1067370_P_NODE_71866_length_262_cov_1.153439_g71317_i0 | PRJNA1067370 | 71866 | 262 | 1.153439 | 3.02201018 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 128 | 3.5800000000000004e-33 | NR | RPI17999.1 | 2026749 | g71317 | i0 | 68.6 | 1.96946564885496 | 86 | 27 | 98.5 | 0 | 1 | 258 | 122 | 207 | RPI17999.1 MAG: kynureninase [Ignavibacteriota bacterium] | diamond | 516 | 128 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 29742759 | 29742759 | PRJNA1067370_P_NODE_114150_length_241_cov_0.916667_g113601_i0 | PRJNA1067370 | 114150 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 78.6 | 8.8e-15 | NR | OIP63676.1 | 1805221 | g113601 | i0 | 50.6 | 4.92946058091286 | 79 | 38 | 98.3 | 1 | 1 | 237 | 301 | 378 | OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16] | diamond | 1188 | 78.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium CG2_30_36_16 | ||||
| 31742153 | 31742153 | PRJNA1067370_P_NODE_100337_length_245_cov_0.895349_g99788_i0 | PRJNA1067370 | 100337 | 245 | 0.895349 | 2.19360505 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 73.2 | 1.35e-13 | NR | HMN49018.1 | 2651163 | g99788 | i0 | 47 | 0.808163265306122 | 66 | 34 | 80.8 | 1 | 9 | 206 | 146 | 210 | HMN49018.1 SGNH/GDSL hydrolase family protein [Ignavibacteriaceae bacterium] | diamond | 198 | 73.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 31742226 | 31742226 | PRJNA1067370_P_NODE_47457_length_303_cov_0.830435_g46909_i0 | PRJNA1067370 | 47457 | 303 | 0.830435 | 2.51621805 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 61.2 | 2.87e-9 | NR | HLT24110.1 | 2053306 | g46909 | i0 | 36.1 | 1.87128712871287 | 83 | 50 | 79.2 | 2 | 288 | 49 | 9 | 91 | HLT24110.1 SRPBCC domain-containing protein [Ignavibacteria bacterium] | diamond | 567 | 61.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32753841 | 32753841 | PRJNA1067370_P_NODE_19300_length_426_cov_2.334278_g18752_i0 | PRJNA1067370 | 19300 | 426 | 2.334278 | 9.94402428 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 57.4 | 1.92e-6 | NR | MCX7876842.1 | 2614255 | g18752 | i0 | 59.1 | 0.309859154929577 | 44 | 18 | 31 | 0 | 5 | 136 | 369 | 412 | MCX7876842.1 sel1 repeat family protein [Melioribacteraceae bacterium] | diamond | 132 | 57.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae 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);;