contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA690124" and tax_kingdom = "Fusobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19796065 | 19796065 | PRJNA690124_P_NODE_28836_length_308_cov_0.995745_g28470_i0 | PRJNA690124 | 28836 | 308 | 0.995745 | 3.0668946 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 183 | 3.389999999999999e-55 | NR | MBN1467623.1 | 2053555 | g28470 | i0 | 87.3 | 1.98701298701299 | 102 | 13 | 99.4 | 0 | 1 | 306 | 90 | 191 | MBN1467623.1 acetyl-CoA carboxylase carboxyltransferase subunit alpha [Fusobacteriaceae bacterium] | diamond | 612 | 183 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium | |||
| 26797539 | 26797539 | PRJNA690124_P_NODE_48961_length_248_cov_0.891429_g48595_i0 | PRJNA690124 | 48961 | 248 | 0.891429 | 2.21074392 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 158 | 2.07e-45 | NR | MBU9917578.1 | 2053555 | g48595 | i0 | 100 | 0.991935483870968 | 82 | 0 | 99.2 | 0 | 247 | 2 | 11 | 92 | MBU9917578.1 flagellar hook-associated protein FlgL [Fusobacteriaceae bacterium] | diamond | 246 | 158 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium | |||
| 28124675 | 28124675 | PRJNA690124_P_NODE_36745_length_274_cov_2.044776_g36379_i0 | PRJNA690124 | 36745 | 274 | 2.044776 | 5.60268624 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 141 | 2.59e-38 | NR | MBP9596619.1 | 2053555 | g36379 | i0 | 72.5 | 0.996350364963504 | 91 | 25 | 99.6 | 0 | 274 | 2 | 54 | 144 | MBP9596619.1 SAM-dependent methyltransferase [Fusobacteriaceae bacterium] | diamond | 273 | 141 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium | |||
| 29734606 | 29734606 | PRJNA690124_P_NODE_47990_length_249_cov_0.886364_g47624_i0 | PRJNA690124 | 47990 | 249 | 0.886364 | 2.20704636 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 80.1 | 2.78e-15 | NR | MBP6468074.1 | 2053555 | g47624 | i0 | 47.5 | 0.963855421686747 | 80 | 42 | 96.4 | 0 | 241 | 2 | 263 | 342 | MBP6468074.1 Hpt domain-containing protein [Fusobacteriaceae bacterium] | diamond | 240 | 80.1 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium | |||
| 30019361 | 30019361 | PRJNA690124_P_NODE_32231_length_292_cov_1.068493_g31865_i0 | PRJNA690124 | 32231 | 292 | 1.068493 | 3.11999956 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 191 | 9.949999999999996e-55 | NR | MBN1467362.1 | 2053555 | g31865 | i0 | 88.7 | 0.996575342465753 | 97 | 11 | 99.7 | 0 | 2 | 292 | 560 | 656 | MBN1467362.1 anaerobic ribonucleoside triphosphate reductase [Fusobacteriaceae bacterium] | diamond | 291 | 191 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium | |||
| 30682484 | 30682484 | PRJNA690124_P_NODE_44373_length_252_cov_0.871508_g44007_i0 | PRJNA690124 | 44373 | 252 | 0.871508 | 2.19620016 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 138 | 3.0699999999999997e-37 | NR | MBP9595288.1 | 2053555 | g44007 | i0 | 79.8 | 1 | 84 | 17 | 100 | 0 | 1 | 252 | 53 | 136 | MBP9595288.1 class I SAM-dependent rRNA methyltransferase [Fusobacteriaceae bacterium] | diamond | 252 | 138 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium | |||
| 30967190 | 30967190 | PRJNA690124_P_NODE_54834_length_243_cov_0.917647_g54468_i0 | PRJNA690124 | 54834 | 243 | 0.917647 | 2.22988221 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 144 | 1.61e-39 | NR | MBU9919105.1 | 2053555 | g54468 | i0 | 85 | 1.97530864197531 | 80 | 12 | 98.8 | 0 | 3 | 242 | 99 | 178 | MBU9919105.1 nitrogenase cofactor biosynthesis protein NifB [Fusobacteriaceae bacterium] | diamond | 480 | 144 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium | |||
| 31282964 | 31282964 | PRJNA690124_P_NODE_32135_length_292_cov_1.392694_g31769_i0 | PRJNA690124 | 32135 | 292 | 1.392694 | 4.06666648 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 187 | 1.6199999999999995e-55 | NR | MBP6407726.1 | 2053555 | g31769 | i0 | 97.9 | 0.986301369863014 | 96 | 2 | 98.6 | 0 | 290 | 3 | 285 | 380 | MBP6407726.1 FAD-dependent oxidoreductase [Fusobacteriaceae bacterium] | diamond | 288 | 187 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium | |||
| 31378072 | 31378072 | PRJNA690124_P_NODE_43276_length_253_cov_0.866667_g42910_i0 | PRJNA690124 | 43276 | 253 | 0.866667 | 2.19266751 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 161 | 3.55e-46 | NR | MBU9917419.1 | 2053555 | g42910 | i0 | 100 | 0.99604743083004 | 84 | 0 | 99.6 | 0 | 253 | 2 | 63 | 146 | MBU9917419.1 ABC transporter substrate-binding protein [Fusobacteriaceae bacterium] | diamond | 252 | 161 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium | |||
| 31567996 | 31567996 | PRJNA690124_P_NODE_50416_length_247_cov_0.896552_g50050_i0 | PRJNA690124 | 50416 | 247 | 0.896552 | 2.21448344 | Fusobacteriota bacterium | 2060921 | Bacteria | Bacteria | 165 | 1.19e-49 | NR | KAF0092346.1 | 2060921 | g50050 | i0 | 95.1 | 0.995951417004049 | 82 | 4 | 99.6 | 0 | 246 | 1 | 64 | 145 | KAF0092346.1 MAG: L-fuculose-phosphate aldolase [Fusobacteriota bacterium] | diamond | 246 | 165 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriota bacterium | ||||||
| 32642776 | 32642776 | PRJNA690124_P_NODE_48880_length_248_cov_0.891429_g48514_i0 | PRJNA690124 | 48880 | 248 | 0.891429 | 2.21074392 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 58.9 | 4.78e-8 | NR | MBP6468242.1 | 2053555 | g48514 | i0 | 68.2 | 1.06451612903226 | 44 | 14 | 53.2 | 0 | 117 | 248 | 6 | 49 | MBP6468242.1 GTPase HflX [Fusobacteriaceae bacterium] | diamond | 264 | 58.9 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae 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);;