contig_metadata
19 rows where bioproject = "PRJDB3785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10211571 | 10211571 | PRJDB3785_S_NODE_11949_length_221_cov_1.453488_g11796_i0 | PRJDB3785 | 11949 | 221 | 1.453488 | 3.21220848 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 128 | 5.96e-33 | NR | MBW1808557.1 | 2026735 | g11796 | i0 | 82.2 | 20.8099547511312 | 73 | 13 | 99.1 | 0 | 1 | 219 | 18 | 90 | MBW1808557.1 adenosylhomocysteinase [Deltaproteobacteria bacterium] | diamond | 4599 | 129 | 0.992248062015504 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26620883 | 26620883 | PRJDB3785_S_NODE_7701_length_270_cov_2.307692_g7548_i0 | PRJDB3785 | 7701 | 270 | 2.307692 | 6.2307684 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 59.3 | 5.33e-8 | NR | MBT6434336.1 | 2026735 | g7548 | i0 | 44.6 | 0.722222222222222 | 65 | 27 | 62.2 | 2 | 179 | 12 | 32 | 96 | MBT6434336.1 lipocalin family protein [Deltaproteobacteria bacterium] | diamond | 195 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27089856 | 27089856 | PRJDB3785_S_NODE_1442_length_670_cov_2.668277_g1316_i0 | PRJDB3785 | 1442 | 670 | 2.668277 | 17.8774559 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 208 | 2.01e-64 | NR | MDO8426395.1 | 2026735 | g1316 | i0 | 53.3 | 8.93731343283582 | 197 | 91 | 87.8 | 1 | 7 | 594 | 1 | 197 | MDO8426395.1 NAD(P)H:quinone oxidoreductase [Deltaproteobacteria bacterium] | diamond | 5988 | 209 | 0.995215311004785 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27380318 | 27380318 | PRJDB3785_S_NODE_19923_length_178_cov_1.186047_g19770_i0 | PRJDB3785 | 19923 | 178 | 1.186047 | 2.11116366 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 41.2 | 0.039 | NR | MCL4755588.1 | 2026763 | g19770 | i0 | 43.8 | 0.808988764044944 | 48 | 18 | 72.5 | 2 | 2 | 130 | 88 | 131 | MCL4755588.1 hypothetical protein [Myxococcales bacterium] | diamond | 144 | 41.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27437634 | 27437634 | PRJDB3785_S_NODE_26683_length_162_cov_0.893805_g26530_i0 | PRJDB3785 | 26683 | 162 | 0.893805 | 1.4479641 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 51.2 | 3.93e-6 | NR | HSD87571.1 | 2212474 | g26530 | i0 | 46.3 | 3 | 54 | 29 | 100 | 0 | 162 | 1 | 57 | 110 | HSD87571.1 EF-hand domain-containing protein [Kofleriaceae bacterium] | diamond | 486 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 27885287 | 27885287 | PRJDB3785_S_NODE_24725_length_165_cov_0.862069_g24572_i0 | PRJDB3785 | 24725 | 165 | 0.862069 | 1.42241385 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 41.6 | 0.035 | NR | HOO45880.1 | 2026735 | g24572 | i0 | 32.7 | 1 | 55 | 35 | 96.4 | 1 | 165 | 7 | 1167 | 1221 | HOO45880.1 DUF6531 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 165 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28706353 | 28706353 | PRJDB3785_S_NODE_22607_length_168_cov_1.924370_g22454_i0 | PRJDB3785 | 22607 | 168 | 1.92437 | 3.2329416 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 47 | 4.31e-4 | NR | HEY3354648.1 | 3058050 | g22454 | i0 | 40.7 | 1.76785714285714 | 54 | 32 | 96.4 | 0 | 6 | 167 | 212 | 265 | HEY3354648.1 kelch repeat-containing protein [Polyangia bacterium] | diamond | 297 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 28769313 | 28769313 | PRJDB3785_S_NODE_7287_length_278_cov_2.048035_g7134_i0 | PRJDB3785 | 7287 | 278 | 2.048035 | 5.6935373 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 85.1 | 9.59e-18 | NR | MEM9066982.1 | 2818507 | g7134 | i0 | 46.8 | 0.852517985611511 | 79 | 42 | 85.3 | 0 | 37 | 273 | 38 | 116 | MEM9066982.1 transglutaminase-like domain-containing protein [Myxococcota bacterium] | diamond | 237 | 85.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28800793 | 28800793 | PRJDB3785_S_NODE_6028_length_307_cov_1.511628_g5875_i0 | PRJDB3785 | 6028 | 307 | 1.511628 | 4.64069796 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 85.5 | 7.15e-17 | NR | MCK6510237.1 | 2818507 | g5875 | i0 | 44.6 | 1.97394136807818 | 101 | 55 | 98.7 | 1 | 306 | 4 | 395 | 494 | MCK6510237.1 leucyl aminopeptidase [Myxococcota bacterium] | diamond | 606 | 85.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29463596 | 29463596 | PRJDB3785_S_NODE_13010_length_213_cov_1.115854_g12857_i0 | PRJDB3785 | 13010 | 213 | 1.115854 | 2.37676902 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 96.3 | 2.36e-21 | NR | MBP9205654.1 | 2212474 | g12857 | i0 | 60.9 | 0.971830985915493 | 69 | 27 | 97.2 | 0 | 2 | 208 | 179 | 247 | MBP9205654.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 207 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 29747899 | 29747899 | PRJDB3785_S_NODE_25371_length_164_cov_0.878261_g25218_i0 | PRJDB3785 | 25371 | 164 | 0.878261 | 1.44034804 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 41.6 | 0.0327 | NR | HTJ45526.1 | 2212474 | g25218 | i0 | 45.5 | 0.804878048780488 | 44 | 23 | 80.5 | 1 | 136 | 5 | 145 | 187 | HTJ45526.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 132 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 29874578 | 29874578 | PRJDB3785_S_NODE_27251_length_161_cov_0.910714_g27098_i0 | PRJDB3785 | 27251 | 161 | 0.910714 | 1.46624954 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 49.3 | 5.14e-5 | NR | HSS02155.1 | 2212474 | g27098 | i0 | 50 | 0.745341614906832 | 40 | 20 | 74.5 | 0 | 132 | 13 | 89 | 128 | HSS02155.1 lysyl oxidase family protein [Kofleriaceae bacterium] | diamond | 120 | 49.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 30317346 | 30317346 | PRJDB3785_S_NODE_7052_length_283_cov_1.089744_g6899_i0 | PRJDB3785 | 7052 | 283 | 1.089744 | 3.08397552 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 75.9 | 1.38e-13 | NR | MFO0694287.1 | 3034171 | g6899 | i0 | 60 | 1.50530035335689 | 50 | 19 | 51.9 | 1 | 14 | 160 | 51 | 100 | MFO0694287.1 thrombospondin type 3 repeat-containing protein [Polyangiales bacterium] | diamond | 426 | 75.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 30790714 | 30790714 | PRJDB3785_S_NODE_21554_length_172_cov_1.243902_g21401_i0 | PRJDB3785 | 21554 | 172 | 1.243902 | 2.13951144 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 54.7 | 8.4e-7 | NR | MEO7092848.1 | 3034171 | g21401 | i0 | 46.4 | 3.90697674418605 | 56 | 30 | 97.7 | 0 | 170 | 3 | 367 | 422 | MEO7092848.1 hypothetical protein [Polyangiales bacterium] | diamond | 672 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 31486363 | 31486363 | PRJDB3785_S_NODE_25396_length_164_cov_0.860870_g25243_i0 | PRJDB3785 | 25396 | 164 | 0.86087 | 1.4118268 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 50.8 | 1.73e-5 | NR | MEM6959678.1 | 2818507 | g25243 | i0 | 45.1 | 1.86585365853659 | 51 | 27 | 93.3 | 1 | 162 | 10 | 131 | 180 | MEM6959678.1 AMP-binding protein [Myxococcota bacterium] | diamond | 306 | 50.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31707526 | 31707526 | PRJDB3785_S_NODE_7097_length_282_cov_1.313305_g6944_i0 | PRJDB3785 | 7097 | 282 | 1.313305 | 3.7035201 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 77.4 | 5.09e-15 | NR | MCA9634375.1 | 2026763 | g6944 | i0 | 63 | 2.23404255319149 | 54 | 20 | 57.4 | 0 | 121 | 282 | 75 | 128 | MCA9634375.1 hypothetical protein [Myxococcales bacterium] | diamond | 630 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32372138 | 32372138 | PRJDB3785_S_NODE_27139_length_161_cov_0.910714_g26986_i0 | PRJDB3785 | 27139 | 161 | 0.910714 | 1.46624954 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 68.2 | 1.3e-11 | NR | MBS1256511.1 | 2026735 | g26986 | i0 | 57.7 | 4.84472049689441 | 52 | 22 | 96.9 | 0 | 156 | 1 | 288 | 339 | MBS1256511.1 Dihydrolipoyl dehydrogenase [Deltaproteobacteria bacterium] | diamond | 780 | 68.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32624674 | 32624674 | PRJDB3785_S_NODE_25620_length_163_cov_1.342105_g25467_i0 | PRJDB3785 | 25620 | 163 | 1.342105 | 2.18763115 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 41.2 | 0.0455 | NR | MFO0694193.1 | 3034171 | g25467 | i0 | 76.9 | 0.478527607361963 | 26 | 6 | 47.9 | 0 | 2 | 79 | 654 | 679 | MFO0694193.1 DUF4215 domain-containing protein [Polyangiales bacterium] | diamond | 78 | 41.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 32902162 | 32902162 | PRJDB3785_S_NODE_24560_length_165_cov_0.879310_g24407_i0 | PRJDB3785 | 24560 | 165 | 0.87931 | 1.4508615 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 57 | 7.92e-8 | NR | MFT3842621.1 | 2484252 | g24407 | i0 | 58.1 | 1.6 | 43 | 18 | 78.2 | 0 | 163 | 35 | 142 | 184 | MFT3842621.1 hypothetical protein [Myxococcaceae bacterium] | diamond | 264 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae 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);;