contig_metadata
22 rows where bioproject = "PRJNA395690", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4238616 | 4238616 | PRJNA395690_P_NODE_17224_length_195_cov_2.095890_g17072_i0 | PRJNA395690 | 17224 | 195 | 2.09589 | 4.0869855 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 272 | 1.19e-68 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g17072 | i0 | 91.837 | 211.85641025641 | 196 | 14 | 100 | 2 | 1 | 195 | 3942281 | 3942087 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 41312 | 272 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 6789343 | 6789343 | PRJNA395690_P_NODE_19846_length_187_cov_1.376812_g19694_i0 | PRJNA395690 | 19846 | 187 | 1.376812 | 2.57463844 | Polyangium aurulentum | 2567896 | Bacteria | Bacteria | 180 | 7.04e-41 | NTclustered | gi|2235996827|gb|CP079217.1| | 2567896 | g19694 | i0 | 85.227 | 0.941176470588235 | 176 | 24 | 94 | 2 | 1 | 175 | 11485869 | 11485695 | Polyangium aurulentum strain SDU3-1 chromosome, complete genome | blastn | 176 | 180 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum | |||
| 8064834 | 8064834 | PRJNA395690_P_NODE_1527_length_631_cov_33.216495_g1384_i0 | PRJNA395690 | 1527 | 631 | 33.216495 | 209.59608345 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 887 | 0 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g1384 | i0 | 92.089 | 137.408874801902 | 632 | 46 | 99 | 4 | 1 | 630 | 7090688 | 7090059 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 86705 | 887 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 10007098 | 10007098 | PRJNA395690_P_NODE_27008_length_170_cov_1.264463_g26856_i0 | PRJNA395690 | 27008 | 170 | 1.264463 | 2.1495871 | Stigmatella | 40 | Bacteria | Bacteria | 257 | 2.81e-64 | NTclustered | gi|507148216|ref|NR_103023.1| | 41 | g26856 | i0 | 94.118 | 188.988235294118 | 170 | 9 | 100 | 1 | 1 | 170 | 740 | 572 | Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence | blastn | 32128 | 257 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 13165434 | 13165434 | PRJNA395690_P_NODE_28051_length_167_cov_1.703390_g27899_i0 | PRJNA395690 | 28051 | 167 | 1.70339 | 2.8446613 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 224 | 2.81e-54 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g27899 | i0 | 91.411 | 99.8562874251497 | 163 | 14 | 99 | 0 | 4 | 166 | 7408347 | 7408185 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 16676 | 224 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 14440594 | 14440594 | PRJNA395690_P_NODE_30532_length_165_cov_1.724138_g30380_i0 | PRJNA395690 | 30532 | 165 | 1.724138 | 2.8448277 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 233 | 4.5899999999999994e-57 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g30380 | i0 | 92.593 | 293.042424242424 | 162 | 12 | 98 | 0 | 4 | 165 | 11179297 | 11179136 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 48352 | 233 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 14440723 | 14440723 | PRJNA395690_P_NODE_6512_length_315_cov_2.864662_g6360_i0 | PRJNA395690 | 6512 | 315 | 2.864662 | 9.0236853 | Corallococcus exercitus | 2316736 | Bacteria | Bacteria | 167 | 1.01e-36 | NTclustered | gi|2809270164|gb|CP102577.1| | 2316736 | g6360 | i0 | 80.617 | 41.7619047619048 | 227 | 35 | 71 | 9 | 45 | 267 | 88212 | 88433 | Corallococcus exercitus strain SDU142 chromosome, complete genome | blastn | 13155 | 167 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus exercitus | ||
| 19537657 | 19537657 | PRJNA395690_P_NODE_35456_length_161_cov_1.419643_g35304_i0 | PRJNA395690 | 35456 | 161 | 1.419643 | 2.28562523 | Corallococcus exercitus | 2316736 | Bacteria | Bacteria | 292 | 7.24e-75 | NTclustered | gi|2809270164|gb|CP102577.1| | 2316736 | g35304 | i0 | 99.379 | 92.1863354037267 | 161 | 1 | 100 | 0 | 1 | 161 | 87301 | 87461 | Corallococcus exercitus strain SDU142 chromosome, complete genome | blastn | 14842 | 292 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus exercitus | ||
| 24638184 | 24638184 | PRJNA395690_P_NODE_480_length_1109_cov_5.869811_g403_i0 | PRJNA395690 | 480 | 1109 | 5.869811 | 65.09620399 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 1596 | 0 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g403 | i0 | 92.646 | 159.011722272317 | 1115 | 73 | 100 | 5 | 1 | 1109 | 3941792 | 3942903 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 176344 | 1596 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 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);;