contig_metadata
9 rows where bioproject = "PRJNA1098727" and tax_phylum = "Myxococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 211094 | 211094 | PRJNA1098727_P_NODE_13901_length_166_cov_0.888889_g13660_i0 | PRJNA1098727 | 13901 | 166 | 0.888889 | 1.47555574 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 85.1 | 1.71e-18 | NR | MEZ4439341.1 | 2268199 | g13660 | i0 | 70.4 | 3.86746987951807 | 54 | 16 | 97.6 | 0 | 3 | 164 | 51 | 104 | MEZ4439341.1 response regulator transcription factor [Polyangiaceae bacterium] | diamond | 642 | 85.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 11689823 | 11689823 | PRJNA1098727_P_NODE_13990_length_166_cov_0.888889_g13749_i0 | PRJNA1098727 | 13990 | 166 | 0.888889 | 1.47555574 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 239 | 9.94e-59 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g13749 | i0 | 92.771 | 126.903614457831 | 166 | 10 | 99 | 2 | 2 | 165 | 3449385 | 3449220 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 21066 | 239 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 27130444 | 27130444 | PRJNA1098727_P_NODE_14742_length_164_cov_0.904348_g14501_i0 | PRJNA1098727 | 14742 | 164 | 0.904348 | 1.48313072 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 101 | 1.2499999999999999e-23 | NR | RPH69899.1 | 2484252 | g14501 | i0 | 80.8 | 1.9390243902439 | 52 | 10 | 95.1 | 0 | 163 | 8 | 146 | 197 | RPH69899.1 MAG: aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Myxococcaceae bacterium] | diamond | 318 | 101 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 28330860 | 28330860 | PRJNA1098727_P_NODE_12466_length_170_cov_2.074380_g12225_i0 | PRJNA1098727 | 12466 | 170 | 2.07438 | 3.526446 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 75.1 | 5.31e-14 | NR | MEZ4395120.1 | 3034171 | g12225 | i0 | 100 | 0.635294117647059 | 36 | 0 | 63.5 | 0 | 155 | 48 | 463 | 498 | MEZ4395120.1 helix-turn-helix domain-containing protein [Polyangiales bacterium] | diamond | 108 | 75.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 30636162 | 30636162 | PRJNA1098727_P_NODE_12833_length_169_cov_0.866667_g12592_i0 | PRJNA1098727 | 12833 | 169 | 0.866667 | 1.46466723 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 119 | 1.44e-29 | NR | MEZ4280991.1 | 2818507 | g12592 | i0 | 98.2 | 1.98816568047337 | 56 | 1 | 99.4 | 0 | 168 | 1 | 214 | 269 | MEZ4280991.1 D-aminoacylase [Myxococcota bacterium] | diamond | 336 | 119 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30731117 | 30731117 | PRJNA1098727_P_NODE_9754_length_194_cov_2.427586_g9513_i0 | PRJNA1098727 | 9754 | 194 | 2.427586 | 4.70951684 | Chondromyces sp. | 3069217 | Bacteria | Bacteria | 78.6 | 4.53e-15 | NR | HSO21770.1 | 3069217 | g9513 | i0 | 97.6 | 0.649484536082474 | 42 | 1 | 64.9 | 0 | 3 | 128 | 500 | 541 | HSO21770.1 nucleoside transporter C-terminal domain-containing protein [Chondromyces sp.] | diamond | 126 | 78.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces sp. | |||
| 31173167 | 31173167 | PRJNA1098727_P_NODE_13135_length_168_cov_0.873950_g12894_i0 | PRJNA1098727 | 13135 | 168 | 0.87395 | 1.468236 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 57.4 | 2.71e-9 | NR | HMR76826.1 | 2268199 | g12894 | i0 | 92.6 | 0.482142857142857 | 27 | 2 | 48.2 | 0 | 2 | 82 | 37 | 63 | HMR76826.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 81 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31837485 | 31837485 | PRJNA1098727_P_NODE_6797_length_239_cov_1.347368_g6556_i0 | PRJNA1098727 | 6797 | 239 | 1.347368 | 3.22020952 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 77 | 2.95e-14 | NR | MAW05289.1 | 2026735 | g6556 | i0 | 54.2 | 0.903765690376569 | 72 | 33 | 90.4 | 0 | 4 | 219 | 310 | 381 | MAW05289.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 216 | 77 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32659606 | 32659606 | PRJNA1098727_P_NODE_13140_length_168_cov_0.873950_g12899_i0 | PRJNA1098727 | 13140 | 168 | 0.87395 | 1.468236 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 52.8 | 1.82e-6 | NR | MDO8527081.1 | 2026735 | g12899 | i0 | 47.2 | 0.946428571428571 | 53 | 28 | 94.6 | 0 | 164 | 6 | 40 | 92 | MDO8527081.1 DUF366 family protein [Deltaproteobacteria bacterium] | diamond | 159 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria 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);;