contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJEB55250" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15424140 | 15424140 | PRJEB55250_P_NODE_15873_length_242_cov_1.473373_g15749_i0 | PRJEB55250 | 15873 | 242 | 1.473373 | 3.56556266 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 125 | 2.26e-33 | NR | MCU0682396.1 | 2268199 | g15749 | i0 | 79 | 1.00413223140496 | 81 | 16 | 99.2 | 1 | 242 | 3 | 31 | 111 | MCU0682396.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 243 | 125 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 24347505 | 24347505 | PRJEB55250_P_NODE_11500_length_251_cov_1.443820_g11376_i0 | PRJEB55250 | 11500 | 251 | 1.44382 | 3.6239882 | Myxococcaceae | 31 | Bacteria | Bacteria | 132 | 4.18e-37 | NR | WP_301540719.1 | 83462 | g11376 | i0 | 78.3 | 14.8804780876494 | 83 | 18 | 99.2 | 0 | 2 | 250 | 46 | 128 | WP_301540719.1 glycoside hydrolase family 19 protein, partial [Corallococcus exiguus] | diamond | 3735 | 132 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus exiguus | ||
| 26685253 | 26685253 | PRJEB55250_P_NODE_4141_length_338_cov_2.116981_g4017_i0 | PRJEB55250 | 4141 | 338 | 2.116981 | 7.15539578 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 129 | 1.85e-32 | NR | MBM3298794.1 | 2026735 | g4017 | i0 | 84.4 | 0.683431952662722 | 77 | 12 | 68.3 | 0 | 336 | 106 | 504 | 580 | MBM3298794.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 231 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27159707 | 27159707 | PRJEB55250_P_NODE_16462_length_241_cov_0.916667_g16338_i0 | PRJEB55250 | 16462 | 241 | 0.916667 | 2.20916747 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 111 | 1.8e-26 | NR | MFT3924803.1 | 2026763 | g16338 | i0 | 71.6 | 1.00829875518672 | 81 | 22 | 99.6 | 1 | 241 | 2 | 468 | 548 | MFT3924803.1 AMP-dependent synthetase/ligase [Myxococcales bacterium] | diamond | 243 | 111 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27627267 | 27627267 | PRJEB55250_P_NODE_9304_length_266_cov_2.129534_g9180_i0 | PRJEB55250 | 9304 | 266 | 2.129534 | 5.66456044 | Bacteria | 2 | Bacteria | Bacteria | 147 | 6.279999999999998e-43 | NR | MDP3501937.1 | 2026763 | g9180 | i0 | 76.1 | 6.91353383458647 | 88 | 21 | 99.2 | 0 | 264 | 1 | 44 | 131 | MDP3501937.1 glycoside hydrolase family 19 protein [Myxococcales bacterium] | diamond | 1839 | 148 | 0.993243243243243 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28675928 | 28675928 | PRJEB55250_P_NODE_8407_length_273_cov_1.540000_g8283_i0 | PRJEB55250 | 8407 | 273 | 1.54 | 4.2042 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 109 | 8.57e-27 | NR | MFO0639718.1 | 2268199 | g8283 | i0 | 61.1 | 0.989010989010989 | 90 | 35 | 98.9 | 0 | 270 | 1 | 137 | 226 | MFO0639718.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 270 | 109 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30128084 | 30128084 | PRJEB55250_P_NODE_8772_length_270_cov_1.862944_g8648_i0 | PRJEB55250 | 8772 | 270 | 1.862944 | 5.0299488 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.5 | 0.0277 | NR | MCD6297440.1 | 2026735 | g8648 | i0 | 36.6 | 0.788888888888889 | 71 | 40 | 74.4 | 3 | 10 | 210 | 356 | 425 | MCD6297440.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 213 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30981638 | 30981638 | PRJEB55250_P_NODE_2194_length_440_cov_2.098093_g2071_i0 | PRJEB55250 | 2194 | 440 | 2.098093 | 9.2316092 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 133 | 2.67e-33 | NR | MBM3298794.1 | 2026735 | g2071 | i0 | 47.9 | 0.995454545454545 | 146 | 76 | 99.5 | 0 | 438 | 1 | 59 | 204 | MBM3298794.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 438 | 133 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31582305 | 31582305 | PRJEB55250_P_NODE_9916_length_262_cov_1.465608_g9792_i0 | PRJEB55250 | 9916 | 262 | 1.465608 | 3.83989296 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 129 | 3.0599999999999993e-34 | NR | MBL8605782.1 | 2026763 | g9792 | i0 | 73.8 | 0.961832061068702 | 84 | 22 | 96.2 | 0 | 261 | 10 | 61 | 144 | MBL8605782.1 hypothetical protein [Myxococcales bacterium] | diamond | 252 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31930028 | 31930028 | PRJEB55250_P_NODE_13337_length_247_cov_1.770115_g13213_i0 | PRJEB55250 | 13337 | 247 | 1.770115 | 4.37218405 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 72.4 | 3.73e-13 | NR | MCA9708461.1 | 2026763 | g13213 | i0 | 49.3 | 0.838056680161943 | 69 | 35 | 83.8 | 0 | 243 | 37 | 21 | 89 | MCA9708461.1 hypothetical protein [Myxococcales bacterium] | diamond | 207 | 72.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32056651 | 32056651 | PRJEB55250_P_NODE_9858_length_262_cov_1.629630_g9734_i0 | PRJEB55250 | 9858 | 262 | 1.62963 | 4.2696306 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42.4 | 0.031 | NR | MBW1839473.1 | 2026735 | g9734 | i0 | 31.7 | 0.687022900763359 | 60 | 40 | 67.6 | 1 | 59 | 235 | 35 | 94 | MBW1839473.1 DUF3473 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 180 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32214975 | 32214975 | PRJEB55250_P_NODE_17318_length_209_cov_4.257353_g17194_i0 | PRJEB55250 | 17318 | 209 | 4.257353 | 8.89786777 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 62.4 | 2.78e-9 | NR | HEY3499757.1 | 2268199 | g17194 | i0 | 38.2 | 0.976076555023923 | 68 | 42 | 97.6 | 0 | 3 | 206 | 70 | 137 | HEY3499757.1 BNR-4 repeat-containing protein [Polyangiaceae bacterium] | diamond | 204 | 62.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32461361 | 32461361 | PRJEB55250_P_NODE_8859_length_270_cov_1.172589_g8735_i0 | PRJEB55250 | 8859 | 270 | 1.172589 | 3.1659903 | Bacteria | 2 | Bacteria | Bacteria | 43.5 | 0.0271 | NR | RYZ06166.1 | 2026763 | g8735 | i0 | 55 | 1 | 40 | 15 | 44.4 | 1 | 194 | 75 | 4 | 40 | RYZ06166.1 MAG: hypothetical protein EOO73_17320 [Myxococcales bacterium] | diamond | 270 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32468284 | 32468284 | PRJEB55250_P_NODE_3579_length_357_cov_1.901408_g3455_i0 | PRJEB55250 | 3579 | 357 | 1.901408 | 6.78802656 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.1 | 0.0209 | NR | MBK8234610.1 | 2026735 | g3455 | i0 | 30.1 | 0.865546218487395 | 103 | 68 | 86.6 | 1 | 322 | 14 | 490 | 588 | MBK8234610.1 HEAT repeat domain-containing protein [Deltaproteobacteria bacterium] | diamond | 309 | 45.1 | 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);;