contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJEB48872" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81693 | 81693 | PRJEB48872_P_NODE_506701_length_192_cov_1.071895_g490889_i0 | PRJEB48872 | 506701 | 192 | 1.071895 | 2.0580384 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 110 | 5.41e-29 | NR | MBX3230404.1 | 1971228 | g490889 | i0 | 85.9 | 3 | 64 | 9 | 100 | 0 | 192 | 1 | 69 | 132 | MBX3230404.1 response regulator [Labilithrix sp.] | diamond | 576 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 3915378 | 3915378 | PRJEB48872_P_NODE_663784_length_156_cov_1.222222_g647972_i0 | PRJEB48872 | 663784 | 156 | 1.222222 | 1.90666632 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 110 | 1.18e-26 | NR | MBV8137665.1 | 2026735 | g647972 | i0 | 90.4 | 1 | 52 | 5 | 100 | 0 | 1 | 156 | 158 | 209 | MBV8137665.1 FdhF/YdeP family oxidoreductase [Deltaproteobacteria bacterium] | diamond | 156 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 5190090 | 5190090 | PRJEB48872_P_NODE_631025_length_162_cov_1.333333_g615213_i0 | PRJEB48872 | 631025 | 162 | 1.333333 | 2.15999946 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 78.6 | 2.85e-15 | NR | MBI5558573.1 | 2026735 | g615213 | i0 | 67.9 | 2.87037037037037 | 53 | 17 | 98.1 | 0 | 160 | 2 | 322 | 374 | MBI5558573.1 acyltransferase [Deltaproteobacteria bacterium] | diamond | 465 | 79.3 | 0.991172761664565 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26621895 | 26621895 | PRJEB48872_P_NODE_384341_length_238_cov_1.030151_g368529_i0 | PRJEB48872 | 384341 | 238 | 1.030151 | 2.45175938 | Byssovorax sp. | 2927945 | Bacteria | Bacteria | 66.2 | 1.06e-11 | NR | MFS8064965.1 | 2927945 | g368529 | i0 | 59.6 | 0.592436974789916 | 47 | 19 | 59.2 | 0 | 2 | 142 | 80 | 126 | MFS8064965.1 hypothetical protein [Byssovorax sp.] | diamond | 141 | 66.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Byssovorax | Byssovorax sp. | |||
| 26931896 | 26931896 | PRJEB48872_P_NODE_641642_length_160_cov_1.355372_g625830_i0 | PRJEB48872 | 641642 | 160 | 1.355372 | 2.1685952 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 52 | 6.62e-6 | NR | WP_136931005.1 | 889272 | g625830 | i0 | 60 | 5.325 | 45 | 18 | 84.4 | 0 | 148 | 14 | 266 | 310 | WP_136931005.1 alpha/beta hydrolase family protein [Polyangium fumosum] | diamond | 852 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium fumosum | |||
| 26970083 | 26970083 | PRJEB48872_P_NODE_606122_length_167_cov_1.351562_g590310_i0 | PRJEB48872 | 606122 | 167 | 1.351562 | 2.25710854 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 75.1 | 5.14e-14 | NR | HYO97616.1 | 2268199 | g590310 | i0 | 61.1 | 2.01197604790419 | 54 | 21 | 97 | 0 | 163 | 2 | 354 | 407 | HYO97616.1 IS66 family transposase [Polyangiaceae bacterium] | diamond | 336 | 75.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27096666 | 27096666 | PRJEB48872_P_NODE_508022_length_191_cov_2.157895_g492210_i0 | PRJEB48872 | 508022 | 191 | 2.157895 | 4.12157945 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 63.9 | 6.03e-11 | NR | HKC58682.1 | 2026763 | g492210 | i0 | 49.2 | 0.989528795811518 | 63 | 32 | 99 | 0 | 189 | 1 | 26 | 88 | HKC58682.1 hypothetical protein [Myxococcales bacterium] | diamond | 189 | 63.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27539147 | 27539147 | PRJEB48872_P_NODE_696344_length_150_cov_1.477477_g680532_i0 | PRJEB48872 | 696344 | 150 | 1.477477 | 2.2162155 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 94.7 | 9.15e-22 | NR | HEY8076409.1 | 1971228 | g680532 | i0 | 83.7 | 0.98 | 49 | 8 | 98 | 0 | 149 | 3 | 105 | 153 | HEY8076409.1 mechanosensitive ion channel domain-containing protein [Labilithrix sp.] | diamond | 147 | 94.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 28991793 | 28991793 | PRJEB48872_P_NODE_696048_length_150_cov_1.612613_g680236_i0 | PRJEB48872 | 696048 | 150 | 1.612613 | 2.4189195 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 66.6 | 2.42e-11 | NR | MBI2371209.1 | 2026735 | g680236 | i0 | 59.6 | 2.78 | 47 | 19 | 94 | 0 | 141 | 1 | 1 | 47 | MBI2371209.1 AAA family ATPase [Deltaproteobacteria bacterium] | diamond | 417 | 66.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29054773 | 29054773 | PRJEB48872_P_NODE_306108_length_283_cov_1.680328_g290296_i0 | PRJEB48872 | 306108 | 283 | 1.680328 | 4.75532824 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 69.7 | 1.37e-11 | NR | WP_075097699.1 | 927083 | g290296 | i0 | 56.7 | 1.47349823321555 | 67 | 25 | 71 | 1 | 211 | 11 | 201 | 263 | WP_075097699.1 reverse transcriptase domain-containing protein [Sandaracinus amylolyticus] | diamond | 417 | 69.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 29995364 | 29995364 | PRJEB48872_P_NODE_559731_length_177_cov_3.362319_g543919_i0 | PRJEB48872 | 559731 | 177 | 3.362319 | 5.95130463 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 94.4 | 1.25e-21 | NR | TNF24063.1 | 2026735 | g543919 | i0 | 72.9 | 2 | 59 | 16 | 100 | 0 | 177 | 1 | 109 | 167 | TNF24063.1 MAG: hypothetical protein EP329_25745 [Deltaproteobacteria bacterium] | diamond | 354 | 94.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30152938 | 30152938 | PRJEB48872_P_NODE_365192_length_247_cov_1.956731_g349380_i0 | PRJEB48872 | 365192 | 247 | 1.956731 | 4.83312557 | Myxococcia | 32015 | Bacteria | Bacteria | 102 | 2.1699999999999998e-23 | NR | MBK6462605.1 | 2026763 | g349380 | i0 | 79.7 | 3.54655870445344 | 59 | 12 | 71.7 | 0 | 245 | 69 | 458 | 516 | MBK6462605.1 fucose isomerase [Myxococcales bacterium] | diamond | 876 | 103 | 0.990291262135922 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30254965 | 30254965 | PRJEB48872_P_NODE_641332_length_160_cov_1.355372_g625520_i0 | PRJEB48872 | 641332 | 160 | 1.355372 | 2.1685952 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 58.5 | 3.19e-8 | NR | HWL88486.1 | 2268199 | g625520 | i0 | 52.8 | 1.96875 | 53 | 24 | 97.5 | 1 | 2 | 157 | 282 | 334 | HWL88486.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 315 | 58.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30444400 | 30444400 | PRJEB48872_P_NODE_550793_length_180_cov_1.163121_g534981_i0 | PRJEB48872 | 550793 | 180 | 1.163121 | 2.0936178 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 78.6 | 4.59e-16 | NR | MCL2450048.1 | 2268199 | g534981 | i0 | 72.9 | 1.96666666666667 | 59 | 16 | 98.3 | 0 | 178 | 2 | 30 | 88 | MCL2450048.1 NAD(P)H-binding protein [Polyangiaceae bacterium] | diamond | 354 | 78.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31487420 | 31487420 | PRJEB48872_P_NODE_571896_length_175_cov_0.904412_g556084_i0 | PRJEB48872 | 571896 | 175 | 0.904412 | 1.582721 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 108 | 7.96e-26 | NR | HEX7603728.1 | 2268199 | g556084 | i0 | 79.3 | 4.95428571428571 | 58 | 12 | 99.4 | 0 | 2 | 175 | 428 | 485 | HEX7603728.1 coniferyl aldehyde dehydrogenase [Polyangiaceae bacterium] | diamond | 867 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31607040 | 31607040 | PRJEB48872_P_NODE_636656_length_161_cov_1.344262_g620844_i0 | PRJEB48872 | 636656 | 161 | 1.344262 | 2.16426182 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 41.6 | 0.0314 | NR | RLB28831.1 | 2026735 | g620844 | i0 | 40.8 | 1.77018633540373 | 49 | 29 | 91.3 | 0 | 147 | 1 | 223 | 271 | RLB28831.1 MAG: hypothetical protein DRH11_16765 [Deltaproteobacteria bacterium] | diamond | 285 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32120041 | 32120041 | PRJEB48872_P_NODE_561698_length_177_cov_1.507246_g545886_i0 | PRJEB48872 | 561698 | 177 | 1.507246 | 2.66782542 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 70.1 | 3.43e-12 | NR | WP_394849972.1 | 2905690 | g545886 | i0 | 61.8 | 10.3220338983051 | 55 | 21 | 93.2 | 0 | 11 | 175 | 1891 | 1945 | WP_394849972.1 non-ribosomal peptide synthase/polyketide synthase [Pendulispora brunnea] | diamond | 1827 | 70.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 32183279 | 32183279 | PRJEB48872_P_NODE_661738_length_156_cov_1.752137_g645926_i0 | PRJEB48872 | 661738 | 156 | 1.752137 | 2.73333372 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 70.9 | 7.87e-14 | NR | MFL5250045.1 | 2026763 | g645926 | i0 | 62.5 | 0.923076923076923 | 48 | 18 | 92.3 | 0 | 2 | 145 | 84 | 131 | MFL5250045.1 type II toxin-antitoxin system VapC family toxin [Myxococcales bacterium] | diamond | 144 | 70.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32404742 | 32404742 | PRJEB48872_P_NODE_505819_length_192_cov_1.549020_g490007_i0 | PRJEB48872 | 505819 | 192 | 1.54902 | 2.9741184 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 71.6 | 3.21e-13 | NR | MDD5307038.1 | 2026735 | g490007 | i0 | 53.2 | 1.953125 | 62 | 29 | 96.9 | 0 | 3 | 188 | 165 | 226 | MDD5307038.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 375 | 71.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32745219 | 32745219 | PRJEB48872_P_NODE_644700_length_159_cov_2.041667_g628888_i0 | PRJEB48872 | 644700 | 159 | 2.041667 | 3.24625053 | Myxococcia | 32015 | Bacteria | Bacteria | 86.3 | 5.35e-18 | NR | MCC6334261.1 | 2026763 | g628888 | i0 | 72.5 | 2.90566037735849 | 51 | 14 | 96.2 | 0 | 155 | 3 | 46 | 96 | MCC6334261.1 hypothetical protein [Myxococcales bacterium] | diamond | 462 | 86.3 | 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);;