contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB82358" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26781219 | 26781219 | PRJEB82358_P_NODE_12341_length_286_cov_1.652582_g12330_i0 | PRJEB82358 | 12341 | 286 | 1.652582 | 4.72638452 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 86.3 | 1.6e-19 | NR | MCG5054052.1 | 2026763 | g12330 | i0 | 71.4 | 0.996503496503496 | 49 | 14 | 51.4 | 0 | 13 | 159 | 43 | 91 | MCG5054052.1 membrane protein insertion efficiency factor YidD [Myxococcales bacterium] | diamond | 285 | 86.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29339694 | 29339694 | PRJEB82358_P_NODE_16069_length_255_cov_2.406593_g16058_i0 | PRJEB82358 | 16069 | 255 | 2.406593 | 6.13681215 | Hyalangium versicolor | 2861190 | Bacteria | Bacteria | 53.9 | 4.92e-6 | NR | WP_224363922.1 | 2861190 | g16058 | i0 | 80 | 0.941176470588235 | 30 | 6 | 35.3 | 0 | 255 | 166 | 394 | 423 | WP_224363922.1 phenylacetate--CoA ligase family protein [Hyalangium versicolor] | diamond | 240 | 53.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Hyalangium | Hyalangium versicolor | ||
| 29395432 | 29395432 | PRJEB82358_P_NODE_12129_length_288_cov_1.283721_g12118_i0 | PRJEB82358 | 12129 | 288 | 1.283721 | 3.69711648 | Byssovorax | 224459 | Bacteria | Bacteria | 126 | 2.2299999999999996e-31 | NR | HWA70733.1 | 2268199 | g12118 | i0 | 82.4 | 3.125 | 74 | 13 | 77.1 | 0 | 279 | 58 | 1063 | 1136 | HWA70733.1 CusA/CzcA family heavy metal efflux RND transporter [Polyangiaceae bacterium] | diamond | 900 | 126 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29876464 | 29876464 | PRJEB82358_P_NODE_18371_length_243_cov_1.800000_g18360_i0 | PRJEB82358 | 18371 | 243 | 1.8 | 4.374 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 53.1 | 7.41e-6 | NR | MBI5488346.1 | 2026735 | g18360 | i0 | 57.8 | 1.11111111111111 | 45 | 18 | 54.3 | 1 | 2 | 133 | 297 | 341 | MBI5488346.1 C1 family peptidase [Deltaproteobacteria bacterium] | diamond | 270 | 53.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30002876 | 30002876 | PRJEB82358_P_NODE_17331_length_248_cov_0.880000_g17320_i0 | PRJEB82358 | 17331 | 248 | 0.88 | 2.1824 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 57.4 | 2.8e-7 | NR | HSQ68102.1 | 2268199 | g17320 | i0 | 39.6 | 2.18951612903226 | 91 | 43 | 95.6 | 1 | 2 | 238 | 428 | 518 | HSQ68102.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 543 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30595525 | 30595525 | PRJEB82358_P_NODE_20453_length_230_cov_2.936306_g20442_i0 | PRJEB82358 | 20453 | 230 | 2.936306 | 6.7535038 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 88.6 | 3.72e-19 | NR | MCC6999916.1 | 2026735 | g20442 | i0 | 46.1 | 1.89130434782609 | 76 | 41 | 99.1 | 0 | 3 | 230 | 155 | 230 | MCC6999916.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 435 | 88.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30761089 | 30761089 | PRJEB82358_P_NODE_11014_length_300_cov_3.916300_g11003_i0 | PRJEB82358 | 11014 | 300 | 3.9163 | 11.7489 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 48.5 | 3.76e-4 | NR | MCG6909387.1 | 2026735 | g11003 | i0 | 60 | 0.45 | 45 | 12 | 43 | 2 | 162 | 290 | 106 | 146 | MCG6909387.1 rhodanese-like domain-containing protein [Deltaproteobacteria bacterium] | diamond | 135 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31202887 | 31202887 | PRJEB82358_P_NODE_17955_length_245_cov_1.325581_g17944_i0 | PRJEB82358 | 17955 | 245 | 1.325581 | 3.24767345 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 54.7 | 1.91e-7 | NR | MBI3557754.1 | 2026735 | g17944 | i0 | 56.4 | 0.673469387755102 | 55 | 22 | 66.1 | 2 | 72 | 233 | 3 | 56 | MBI3557754.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 165 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32461517 | 32461517 | PRJEB82358_P_NODE_15839_length_257_cov_1.467391_g15828_i0 | PRJEB82358 | 15839 | 257 | 1.467391 | 3.77119487 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 114 | 1.5400000000000002e-27 | NR | MCC6334520.1 | 2026763 | g15828 | i0 | 63.1 | 4.90272373540856 | 84 | 31 | 98.1 | 0 | 254 | 3 | 215 | 298 | MCC6334520.1 AAA family ATPase [Myxococcales bacterium] | diamond | 1260 | 115 | 0.991304347826087 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales 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);;