contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA642647" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26796469 | 26796469 | PRJNA642647_P_NODE_5921_length_157_cov_0.916667_g5871_i0 | PRJNA642647 | 5921 | 157 | 0.916667 | 1.43916719 | Corallococcus exiguus | 83462 | Bacteria | Bacteria | 42.7 | 0.0112 | NR | WP_206884372.1 | 83462 | g5871 | i0 | 51.5 | 1.31847133757962 | 33 | 16 | 63.1 | 0 | 149 | 51 | 227 | 259 | WP_206884372.1 HNH endonuclease [Corallococcus exiguus] | diamond | 207 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus exiguus | ||
| 27460620 | 27460620 | PRJNA642647_P_NODE_2483_length_219_cov_2.510989_g2433_i0 | PRJNA642647 | 2483 | 219 | 2.510989 | 5.49906591 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 40 | 0.0499 | NR | HQP34498.1 | 2268199 | g2433 | i0 | 66.7 | 0.328767123287671 | 24 | 8 | 32.9 | 0 | 128 | 57 | 46 | 69 | HQP34498.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 72 | 40 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27492121 | 27492121 | PRJNA642647_P_NODE_1323_length_304_cov_2.063670_g1273_i0 | PRJNA642647 | 1323 | 304 | 2.06367 | 6.2735568 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 69.3 | 2.1e-12 | NR | MBK9260809.1 | 2268199 | g1273 | i0 | 38.8 | 1.14473684210526 | 116 | 29 | 73 | 2 | 5 | 226 | 26 | 141 | MBK9260809.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 348 | 69.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27902315 | 27902315 | PRJNA642647_P_NODE_2885_length_205_cov_4.672619_g2835_i0 | PRJNA642647 | 2885 | 205 | 4.672619 | 9.57886895 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 63.2 | 8.68e-10 | NR | MBK9263032.1 | 2268199 | g2835 | i0 | 61 | 0.6 | 41 | 13 | 55.6 | 1 | 200 | 87 | 229 | 269 | MBK9263032.1 PD-(D/E)XK nuclease-like domain-containing protein [Polyangiaceae bacterium] | diamond | 123 | 63.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28028933 | 28028933 | PRJNA642647_P_NODE_5685_length_160_cov_1.186992_g5635_i0 | PRJNA642647 | 5685 | 160 | 1.186992 | 1.8991872 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 41.2 | 0.0149 | NR | HHD11908.1 | 2026735 | g5635 | i0 | 40.5 | 0.69375 | 37 | 22 | 69.4 | 0 | 4 | 114 | 71 | 107 | HHD11908.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 111 | 41.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28091909 | 28091909 | PRJNA642647_P_NODE_4185_length_176_cov_3.597122_g4135_i0 | PRJNA642647 | 4185 | 176 | 3.597122 | 6.33093472 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 56.2 | 7.47e-8 | NR | MCU0689773.1 | 2268199 | g4135 | i0 | 82.1 | 0.477272727272727 | 28 | 5 | 47.7 | 0 | 6 | 89 | 24 | 51 | MCU0689773.1 HNH endonuclease [Polyangiaceae bacterium] | diamond | 84 | 56.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28407770 | 28407770 | PRJNA642647_P_NODE_866_length_380_cov_1.930029_g816_i0 | PRJNA642647 | 866 | 380 | 1.930029 | 7.3341102 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 124 | 1.89e-30 | NR | MCL2724853.1 | 2268199 | g816 | i0 | 70.5 | 0.694736842105263 | 88 | 26 | 69.5 | 0 | 265 | 2 | 336 | 423 | MCL2724853.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 264 | 124 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28660401 | 28660401 | PRJNA642647_P_NODE_2547_length_216_cov_3.921788_g2497_i0 | PRJNA642647 | 2547 | 216 | 3.921788 | 8.47106208 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 48.5 | 1.43e-4 | NR | AKU93339.1 | 1391654 | g2497 | i0 | 56.9 | 0.708333333333333 | 51 | 16 | 69.4 | 2 | 57 | 206 | 116 | 161 | AKU93339.1 hypothetical protein AKJ09_00003 [Labilithrix luteola] | diamond | 153 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 28692067 | 28692067 | PRJNA642647_P_NODE_5887_length_157_cov_1.800000_g5837_i0 | PRJNA642647 | 5887 | 157 | 1.8 | 2.826 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 87.4 | 4.67e-20 | NR | MBL0197634.1 | 2026763 | g5837 | i0 | 95.3 | 0.821656050955414 | 43 | 2 | 82.2 | 0 | 28 | 156 | 1 | 43 | MBL0197634.1 hypothetical protein [Myxococcales bacterium] | diamond | 129 | 87.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28912621 | 28912621 | PRJNA642647_P_NODE_3228_length_196_cov_1.509434_g3178_i0 | PRJNA642647 | 3228 | 196 | 1.509434 | 2.95849064 | Polyangium sp. | 3409587 | Bacteria | Bacteria | 67 | 8.49e-12 | NR | HMY20343.1 | 57 | g3178 | i0 | 84.6 | 0.596938775510204 | 39 | 6 | 59.7 | 0 | 195 | 79 | 138 | 176 | HMY20343.1 hypothetical protein [Polyangium sp.] | diamond | 117 | 67 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 29134078 | 29134078 | PRJNA642647_P_NODE_3829_length_183_cov_1.760274_g3779_i0 | PRJNA642647 | 3829 | 183 | 1.760274 | 3.22130142 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 56.6 | 2.2e-8 | NR | MDP3937728.1 | 2026735 | g3779 | i0 | 48.3 | 0.950819672131147 | 58 | 28 | 91.8 | 1 | 183 | 16 | 55 | 112 | MDP3937728.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 174 | 56.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29260002 | 29260002 | PRJNA642647_P_NODE_3969_length_180_cov_3.671329_g3919_i0 | PRJNA642647 | 3969 | 180 | 3.671329 | 6.6083922 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 77.4 | 7.73e-15 | NR | MBX3218891.1 | 1971228 | g3919 | i0 | 66.1 | 2.98333333333333 | 59 | 20 | 98.3 | 0 | 2 | 178 | 92 | 150 | MBX3218891.1 hypothetical protein [Labilithrix sp.] | diamond | 537 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 30555003 | 30555003 | PRJNA642647_P_NODE_5073_length_166_cov_2.891473_g5023_i0 | PRJNA642647 | 5073 | 166 | 2.891473 | 4.79984518 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 45.4 | 5.73e-4 | NR | MBL0197454.1 | 2026763 | g5023 | i0 | 76 | 0.451807228915663 | 25 | 6 | 45.2 | 0 | 165 | 91 | 68 | 92 | MBL0197454.1 DUF2190 family protein [Myxococcales bacterium] | diamond | 75 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31123555 | 31123555 | PRJNA642647_P_NODE_4055_length_179_cov_1.563380_g4005_i0 | PRJNA642647 | 4055 | 179 | 1.56338 | 2.7984502 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 42 | 0.0299 | NR | MEZ4219428.1 | 2268199 | g4005 | i0 | 40.8 | 0.82122905027933 | 49 | 29 | 82.1 | 0 | 27 | 173 | 270 | 318 | MEZ4219428.1 CxxxxCH/CxxCH domain-containing protein [Polyangiaceae bacterium] | diamond | 147 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31926843 | 31926843 | PRJNA642647_P_NODE_4277_length_175_cov_1.463768_g4227_i0 | PRJNA642647 | 4277 | 175 | 1.463768 | 2.561594 | Myxococcia | 32015 | Bacteria | Bacteria | 58.9 | 1.07e-8 | NR | MFO0712413.1 | 2024858 | g4227 | i0 | 57.1 | 17.7257142857143 | 56 | 24 | 96 | 0 | 171 | 4 | 136 | 191 | MFO0712413.1 sigma factor-like helix-turn-helix DNA-binding protein [Sandaracinus sp.] | diamond | 3102 | 59.3 | 0.993254637436762 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus sp. | |||
| 32104393 | 32104393 | PRJNA642647_P_NODE_2558_length_216_cov_2.849162_g2508_i0 | PRJNA642647 | 2558 | 216 | 2.849162 | 6.15418992 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 57 | 2.34e-7 | NR | MCL2777727.1 | 2268199 | g2508 | i0 | 60.5 | 0.527777777777778 | 38 | 15 | 52.8 | 0 | 118 | 5 | 23 | 60 | MCL2777727.1 phage protease [Polyangiaceae bacterium] | diamond | 114 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32673265 | 32673265 | PRJNA642647_P_NODE_5360_length_164_cov_2.055118_g5310_i0 | PRJNA642647 | 5360 | 164 | 2.0551179999999998 | 3.37039352 | Pyxidicoccus xibeiensis | 2906759 | Bacteria | Bacteria | 41.6 | 0.0327 | NR | WP_253982249.1 | 2906759 | g5310 | i0 | 32 | 0.914634146341463 | 50 | 34 | 91.5 | 0 | 158 | 9 | 175 | 224 | WP_253982249.1 hypothetical protein [Pyxidicoccus xibeiensis] | diamond | 150 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pyxidicoccus | Pyxidicoccus xibeiensis | ||
| 32767815 | 32767815 | PRJNA642647_P_NODE_1320_length_304_cov_2.883895_g1270_i0 | PRJNA642647 | 1320 | 304 | 2.883895 | 8.7670408 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 65.5 | 6.21e-11 | NR | MBK9260806.1 | 2268199 | g1270 | i0 | 66.7 | 0.384868421052632 | 39 | 13 | 38.5 | 0 | 290 | 174 | 1 | 39 | MBK9260806.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 117 | 65.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae 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);;