contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26822351 | 26822351 | PRJNA395690_P_NODE_28701_length_167_cov_0.864407_g28549_i0 | PRJNA395690 | 28701 | 167 | 0.864407 | 1.44355969 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 49.7 | 1.46e-5 | NR | TMB16698.1 | 2026735 | g28549 | i0 | 46.3 | 0.970059880239521 | 54 | 29 | 97 | 0 | 162 | 1 | 7 | 60 | TMB16698.1 MAG: hypothetical protein E6J59_18480 [Deltaproteobacteria bacterium] | diamond | 162 | 49.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27976471 | 27976471 | PRJNA395690_P_NODE_25705_length_173_cov_1.362903_g25553_i0 | PRJNA395690 | 25705 | 173 | 1.362903 | 2.35782219 | Polyangiaceae | 49 | Bacteria | Bacteria | 116 | 1.9000000000000003e-28 | NR | APR75102.1 | 888845 | g25553 | i0 | 94.7 | 1.97687861271676 | 57 | 3 | 98.8 | 0 | 1 | 171 | 35 | 91 | APR75102.1 Serine/threonine protein kinase PrkC, regulator of stationary phase [Minicystis rosea] | diamond | 342 | 116 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 28528271 | 28528271 | PRJNA395690_P_NODE_15767_length_205_cov_0.967949_g15615_i0 | PRJNA395690 | 15767 | 205 | 0.967949 | 1.98429545 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 44.3 | 0.00425 | NR | MCA9561757.1 | 2026763 | g15615 | i0 | 40.3 | 0.980487804878049 | 67 | 38 | 95.1 | 1 | 198 | 4 | 62 | 128 | MCA9561757.1 hypothetical protein [Myxococcales bacterium] | diamond | 201 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28686189 | 28686189 | PRJNA395690_P_NODE_14007_length_217_cov_1.898810_g13855_i0 | PRJNA395690 | 14007 | 217 | 1.89881 | 4.1204177 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 78.2 | 6.28e-16 | NR | MEM9456219.1 | 2818507 | g13855 | i0 | 50 | 0.884792626728111 | 64 | 31 | 88.5 | 1 | 197 | 6 | 71 | 133 | MEM9456219.1 hypothetical protein [Myxococcota bacterium] | diamond | 192 | 78.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28906779 | 28906779 | PRJNA395690_P_NODE_4088_length_390_cov_2.563050_g3939_i0 | PRJNA395690 | 4088 | 390 | 2.56305 | 9.995895 | Plesiocystis pacifica | 191768 | Bacteria | Bacteria | 48.9 | 0.00117 | NR | WP_006969482.1 | 191768 | g3939 | i0 | 41.3 | 0.484615384615385 | 63 | 37 | 48.5 | 0 | 7 | 195 | 303 | 365 | WP_006969482.1 type IV pilus twitching motility protein PilT [Plesiocystis pacifica] | diamond | 189 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Plesiocystis | Plesiocystis pacifica | |||
| 29460182 | 29460182 | PRJNA395690_P_NODE_34330_length_162_cov_1.327434_g34178_i0 | PRJNA395690 | 34330 | 162 | 1.327434 | 2.15044308 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62.4 | 1.48e-9 | NR | MCA9711197.1 | 2026763 | g34178 | i0 | 50.9 | 9.75925925925926 | 53 | 26 | 98.1 | 0 | 159 | 1 | 129 | 181 | MCA9711197.1 serine/threonine-protein kinase PknK [Myxococcales bacterium] | diamond | 1581 | 62.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29649505 | 29649505 | PRJNA395690_P_NODE_9230_length_268_cov_0.785388_g9078_i0 | PRJNA395690 | 9230 | 268 | 0.785388 | 2.10483984 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.5 | 8.05e-6 | NR | MBN2496246.1 | 2026735 | g9078 | i0 | 39.8 | 3.64925373134328 | 83 | 47 | 89.6 | 2 | 13 | 252 | 97 | 179 | MBN2496246.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 978 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29997487 | 29997487 | PRJNA395690_P_NODE_37391_length_151_cov_2.470588_g37238_i0 | PRJNA395690 | 37391 | 151 | 2.470588 | 3.73058788 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 73.2 | 8.92e-14 | NR | TMA55994.1 | 2026735 | g37238 | i0 | 68 | 8.94039735099338 | 50 | 16 | 99.3 | 0 | 1 | 150 | 72 | 121 | TMA55994.1 MAG: SDR family oxidoreductase [Deltaproteobacteria bacterium] | diamond | 1350 | 73.6 | 0.994565217391304 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30770615 | 30770615 | PRJNA395690_P_NODE_29894_length_166_cov_0.871795_g29742_i0 | PRJNA395690 | 29894 | 166 | 0.871795 | 1.4471797 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 88.6 | 1.2e-20 | NR | HZF48946.1 | 2268199 | g29742 | i0 | 81.1 | 0.957831325301205 | 53 | 10 | 95.8 | 0 | 4 | 162 | 92 | 144 | HZF48946.1 phage tail protein [Polyangiaceae bacterium] | diamond | 159 | 88.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31687135 | 31687135 | PRJNA395690_P_NODE_11637_length_238_cov_2.137566_g11485_i0 | PRJNA395690 | 11637 | 238 | 2.137566 | 5.08740708 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.1 | 0.0254 | NR | HEX2881709.1 | 2268199 | g11485 | i0 | 33.8 | 0.932773109243697 | 74 | 48 | 92 | 1 | 238 | 20 | 81 | 154 | HEX2881709.1 CFI-box-CTERM domain-containing protein [Polyangiaceae bacterium] | diamond | 222 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31703976 | 31703976 | PRJNA395690_P_NODE_24537_length_176_cov_1.204724_g24385_i0 | PRJNA395690 | 24537 | 176 | 1.204724 | 2.12031424 | Bacteria | 2 | Bacteria | Bacteria | 64.7 | 2.69e-10 | NR | HOD72399.1 | 2026735 | g24385 | i0 | 57.8 | 3.83522727272727 | 45 | 19 | 76.7 | 0 | 136 | 2 | 75 | 119 | HOD72399.1 DUF3987 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 675 | 64.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31813721 | 31813721 | PRJNA395690_P_NODE_10037_length_257_cov_0.966346_g9885_i0 | PRJNA395690 | 10037 | 257 | 0.966346 | 2.48350922 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 48.1 | 5.23e-5 | NR | MBI1948490.1 | 2026735 | g9885 | i0 | 44.2 | 0.607003891050584 | 52 | 25 | 56 | 1 | 256 | 113 | 27 | 78 | MBI1948490.1 DUF1419 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 156 | 48.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31971899 | 31971899 | PRJNA395690_P_NODE_8558_length_276_cov_2.066079_g8406_i0 | PRJNA395690 | 8558 | 276 | 2.066079 | 5.70237804 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 49.3 | 1.13e-4 | NR | MDP3940643.1 | 2026735 | g8406 | i0 | 66.7 | 0.358695652173913 | 33 | 10 | 35.9 | 1 | 4 | 102 | 24 | 55 | MDP3940643.1 HNH endonuclease [Deltaproteobacteria bacterium] | diamond | 99 | 49.3 | 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);;