contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA661142" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27049906 | 27049906 | PRJNA661142_P_NODE_11922_length_165_cov_0.879310_g11857_i0 | PRJNA661142 | 11922 | 165 | 0.87931 | 1.4508615 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 82.8 | 9.66e-17 | NR | MBM4288065.1 | 2026735 | g11857 | i0 | 83 | 0.963636363636364 | 53 | 9 | 96.4 | 0 | 3 | 161 | 114 | 166 | MBM4288065.1 PAS domain S-box protein [Deltaproteobacteria bacterium] | diamond | 159 | 82.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27176011 | 27176011 | PRJNA661142_P_NODE_11442_length_167_cov_0.864407_g11377_i0 | PRJNA661142 | 11442 | 167 | 0.864407 | 1.44355969 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 55.8 | 1.72e-7 | NR | NTV32037.1 | 2026735 | g11377 | i0 | 84.4 | 0.574850299401198 | 32 | 5 | 57.5 | 0 | 71 | 166 | 1 | 32 | NTV32037.1 DUF3786 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 96 | 55.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27207608 | 27207608 | PRJNA661142_P_NODE_12702_length_161_cov_0.910714_g12637_i0 | PRJNA661142 | 12702 | 161 | 0.910714 | 1.46624954 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 59.3 | 1.72e-8 | NR | MBW2182437.1 | 2026735 | g12637 | i0 | 52.8 | 1.97515527950311 | 53 | 25 | 98.8 | 0 | 2 | 160 | 413 | 465 | MBW2182437.1 M48 family metalloprotease [Deltaproteobacteria bacterium] | diamond | 318 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27650182 | 27650182 | PRJNA661142_P_NODE_11464_length_167_cov_0.864407_g11399_i0 | PRJNA661142 | 11464 | 167 | 0.864407 | 1.44355969 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 61.6 | 1.83e-10 | NR | MBM4305146.1 | 2026735 | g11399 | i0 | 49.1 | 1.97604790419162 | 55 | 28 | 98.8 | 0 | 1 | 165 | 19 | 73 | MBM4305146.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 330 | 61.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27839323 | 27839323 | PRJNA661142_P_NODE_12144_length_164_cov_0.886957_g12079_i0 | PRJNA661142 | 12144 | 164 | 0.886957 | 1.45460948 | Haliangiales bacterium | 3069304 | Bacteria | Bacteria | 59.3 | 1.81e-8 | NR | HKA89931.1 | 3069304 | g12079 | i0 | 56.6 | 0.969512195121951 | 53 | 23 | 97 | 0 | 2 | 160 | 1393 | 1445 | HKA89931.1 tetratricopeptide repeat protein [Haliangiales bacterium] | diamond | 159 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Haliangiales bacterium | |||||
| 27902461 | 27902461 | PRJNA661142_P_NODE_2565_length_492_cov_68.115124_g2502_i0 | PRJNA661142 | 2565 | 492 | 68.115124 | 335.12641008 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 137 | 1.2599999999999999e-34 | NR | MDF3066060.1 | 2268199 | g2502 | i0 | 49.7 | 0.981707317073171 | 161 | 66 | 98.2 | 5 | 490 | 8 | 301 | 446 | MDF3066060.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 483 | 137 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28944883 | 28944883 | PRJNA661142_P_NODE_12728_length_161_cov_0.910714_g12663_i0 | PRJNA661142 | 12728 | 161 | 0.910714 | 1.46624954 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 92.4 | 1.33e-21 | NR | MCX5878045.1 | 2026735 | g12663 | i0 | 81.1 | 0.987577639751553 | 53 | 10 | 98.8 | 0 | 161 | 3 | 23 | 75 | MCX5878045.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 159 | 92.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28976276 | 28976276 | PRJNA661142_P_NODE_11668_length_166_cov_0.871795_g11603_i0 | PRJNA661142 | 11668 | 166 | 0.871795 | 1.4471797 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 116 | 3.4399999999999995e-31 | NR | NTV33772.1 | 2026735 | g11603 | i0 | 94.5 | 0.993975903614458 | 55 | 3 | 99.4 | 0 | 166 | 2 | 65 | 119 | NTV33772.1 HAD hydrolase family protein [Deltaproteobacteria bacterium] | diamond | 165 | 116 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29165822 | 29165822 | PRJNA661142_P_NODE_12349_length_163_cov_0.894737_g12284_i0 | PRJNA661142 | 12349 | 163 | 0.894737 | 1.45842131 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 62.4 | 1.41e-9 | NR | MEO8549637.1 | 2212474 | g12284 | i0 | 57.1 | 3.0920245398773 | 56 | 21 | 97.5 | 1 | 161 | 3 | 270 | 325 | MEO8549637.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 504 | 62.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 29986626 | 29986626 | PRJNA661142_P_NODE_12331_length_163_cov_0.894737_g12266_i0 | PRJNA661142 | 12331 | 163 | 0.894737 | 1.45842131 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 117 | 1.7599999999999998e-32 | NR | MBI2183162.1 | 2026735 | g12266 | i0 | 94.4 | 1.98773006134969 | 54 | 3 | 99.4 | 0 | 2 | 163 | 12 | 65 | MBI2183162.1 (2Fe-2S) ferredoxin domain-containing protein [Deltaproteobacteria bacterium] | diamond | 324 | 117 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29998948 | 29998948 | PRJNA661142_P_NODE_11451_length_167_cov_0.864407_g11386_i0 | PRJNA661142 | 11451 | 167 | 0.864407 | 1.44355969 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 96.3 | 3.62e-22 | NR | MBI5545021.1 | 2026735 | g11386 | i0 | 72.7 | 6.84431137724551 | 55 | 15 | 98.8 | 0 | 166 | 2 | 135 | 189 | MBI5545021.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 1143 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30207486 | 30207486 | PRJNA661142_P_NODE_12092_length_164_cov_0.886957_g12027_i0 | PRJNA661142 | 12092 | 164 | 0.886957 | 1.45460948 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 52.4 | 5.03e-6 | NR | NTV59124.1 | 2026735 | g12027 | i0 | 83.3 | 1.09756097560976 | 30 | 5 | 54.9 | 0 | 1 | 90 | 458 | 487 | NTV59124.1 30S ribosomal protein S1 [Deltaproteobacteria bacterium] | diamond | 180 | 52.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30492197 | 30492197 | PRJNA661142_P_NODE_11733_length_166_cov_0.871795_g11668_i0 | PRJNA661142 | 11733 | 166 | 0.871795 | 1.4471797 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 56.2 | 3.33e-8 | NR | MBP1699999.1 | 2026735 | g11668 | i0 | 51.9 | 0.975903614457831 | 54 | 25 | 97.6 | 1 | 164 | 3 | 66 | 118 | MBP1699999.1 AhpC/TSA family [Deltaproteobacteria bacterium] | diamond | 162 | 56.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30681486 | 30681486 | PRJNA661142_P_NODE_11933_length_165_cov_0.879310_g11868_i0 | PRJNA661142 | 11933 | 165 | 0.87931 | 1.4508615 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 70.1 | 3.09e-13 | NR | HOI07158.1 | 2026735 | g11868 | i0 | 75.5 | 1.92727272727273 | 53 | 13 | 96.4 | 0 | 163 | 5 | 10 | 62 | HOI07158.1 VTT domain-containing protein [Deltaproteobacteria bacterium] | diamond | 318 | 70.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31135908 | 31135908 | PRJNA661142_P_NODE_11875_length_165_cov_0.879310_g11810_i0 | PRJNA661142 | 11875 | 165 | 0.87931 | 1.4508615 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 75.9 | 3.39e-15 | NR | MBN1615156.1 | 2026735 | g11810 | i0 | 92.3 | 5.83636363636364 | 39 | 3 | 70.9 | 0 | 119 | 3 | 33 | 71 | MBN1615156.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Deltaproteobacteria bacterium] | diamond | 963 | 75.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31186944 | 31186944 | PRJNA661142_P_NODE_11615_length_166_cov_0.871795_g11550_i0 | PRJNA661142 | 11615 | 166 | 0.871795 | 1.4471797 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 94 | 1.4e-21 | NR | MBW2653316.1 | 2026735 | g11550 | i0 | 90.7 | 2.92771084337349 | 54 | 5 | 97.6 | 0 | 164 | 3 | 204 | 257 | MBW2653316.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 486 | 94 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31281996 | 31281996 | PRJNA661142_P_NODE_11675_length_166_cov_0.871795_g11610_i0 | PRJNA661142 | 11675 | 166 | 0.871795 | 1.4471797 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 111 | 2.9100000000000003e-27 | NR | MCX5877851.1 | 2026735 | g11610 | i0 | 96.4 | 0.993975903614458 | 55 | 2 | 99.4 | 0 | 1 | 165 | 36 | 90 | MCX5877851.1 AsmA family protein [Deltaproteobacteria bacterium] | diamond | 165 | 111 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31535328 | 31535328 | PRJNA661142_P_NODE_12016_length_164_cov_0.886957_g11951_i0 | PRJNA661142 | 12016 | 164 | 0.886957 | 1.45460948 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 116 | 8.62e-29 | NR | MBN2576475.1 | 2026735 | g11951 | i0 | 96.3 | 0.98780487804878 | 54 | 2 | 98.8 | 0 | 163 | 2 | 172 | 225 | MBN2576475.1 phytoene desaturase [Deltaproteobacteria bacterium] | diamond | 162 | 116 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31768687 | 31768687 | PRJNA661142_P_NODE_12697_length_161_cov_0.910714_g12632_i0 | PRJNA661142 | 12697 | 161 | 0.910714 | 1.46624954 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 80.9 | 4.4e-16 | NR | MCX5908289.1 | 2026735 | g12632 | i0 | 77.4 | 11.8509316770186 | 53 | 12 | 98.8 | 0 | 1 | 159 | 693 | 745 | MCX5908289.1 response regulator [Deltaproteobacteria bacterium] | diamond | 1908 | 80.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31977930 | 31977930 | PRJNA661142_P_NODE_11878_length_165_cov_0.879310_g11813_i0 | PRJNA661142 | 11878 | 165 | 0.87931 | 1.4508615 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 70.5 | 8.8e-13 | NR | MBN1381707.1 | 2026735 | g11813 | i0 | 61.8 | 1 | 55 | 21 | 100 | 0 | 1 | 165 | 110 | 164 | MBN1381707.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 165 | 70.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32294780 | 32294780 | PRJNA661142_P_NODE_10079_length_213_cov_0.932927_g10014_i0 | PRJNA661142 | 10079 | 213 | 0.932927 | 1.98713451 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 42.4 | 0.0338 | NR | MDB4979583.1 | 2026763 | g10014 | i0 | 43.9 | 0.929577464788732 | 66 | 28 | 93 | 3 | 208 | 11 | 3 | 59 | MDB4979583.1 synthase [Myxococcales bacterium] | diamond | 198 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales 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);;