contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJEB81327" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3547706 | 3547706 | PRJEB81327_P_NODE_50903_length_249_cov_0.875000_g50295_i0 | PRJEB81327 | 50903 | 249 | 0.875 | 2.17875 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 132 | 1.97e-34 | NR | HLT29146.1 | 2484252 | g50295 | i0 | 80.5 | 12.7349397590361 | 82 | 16 | 98.8 | 0 | 247 | 2 | 301 | 382 | HLT29146.1 hydroxymethylglutaryl-CoA reductase, degradative [Myxococcaceae bacterium] | diamond | 3171 | 132 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 12893694 | 12893694 | PRJEB81327_P_NODE_61911_length_243_cov_0.905882_g61303_i0 | PRJEB81327 | 61911 | 243 | 0.905882 | 2.20129326 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 131 | 2.02e-33 | NR | WP_153822974.1 | 889282 | g61303 | i0 | 79.7 | 4.92592592592593 | 79 | 16 | 97.5 | 0 | 6 | 242 | 31 | 109 | WP_153822974.1 amino acid adenylation domain-containing protein [Polyangium spumosum] | diamond | 1197 | 131 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium spumosum | |||
| 27666306 | 27666306 | PRJEB81327_P_NODE_52784_length_248_cov_0.880000_g52176_i0 | PRJEB81327 | 52784 | 248 | 0.88 | 2.1824 | Corallococcus sp. AS-1-12 | 2874598 | Bacteria | Bacteria | 69.7 | 1.29e-12 | NR | WP_223743574.1 | 2874598 | g52176 | i0 | 39.5 | 0.979838709677419 | 81 | 47 | 98 | 1 | 248 | 6 | 44 | 122 | WP_223743574.1 hypothetical protein [Corallococcus sp. AS-1-12] | diamond | 243 | 69.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus sp. AS-1-12 | ||
| 27698083 | 27698083 | PRJEB81327_P_NODE_51844_length_248_cov_0.880000_g51236_i0 | PRJEB81327 | 51844 | 248 | 0.88 | 2.1824 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 73.9 | 2.41e-14 | NR | MBX3263321.1 | 1971228 | g51236 | i0 | 51.2 | 5.93951612903226 | 82 | 32 | 96.8 | 4 | 8 | 247 | 52 | 127 | MBX3263321.1 hypothetical protein [Labilithrix sp.] | diamond | 1473 | 73.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 28044961 | 28044961 | PRJEB81327_P_NODE_41065_length_259_cov_2.096774_g40457_i0 | PRJEB81327 | 41065 | 259 | 2.096774 | 5.43064466 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 144 | 3.0499999999999993e-40 | NR | MBS2018161.1 | 2026735 | g40457 | i0 | 91.9 | 0.996138996138996 | 86 | 7 | 99.6 | 0 | 258 | 1 | 196 | 281 | MBS2018161.1 NAD(P)-binding domain-containing protein [Deltaproteobacteria bacterium] | diamond | 258 | 144 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28108016 | 28108016 | PRJEB81327_P_NODE_56385_length_246_cov_0.890173_g55777_i0 | PRJEB81327 | 56385 | 246 | 0.890173 | 2.18982558 | Haliangiales bacterium | 3069304 | Bacteria | Bacteria | 63.2 | 2.49e-9 | NR | HKA90051.1 | 3069304 | g55777 | i0 | 48.4 | 0.780487804878049 | 64 | 27 | 72 | 2 | 49 | 225 | 189 | 251 | HKA90051.1 hypothetical protein [Haliangiales bacterium] | diamond | 192 | 63.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Haliangiales bacterium | |||||
| 28834345 | 28834345 | PRJEB81327_P_NODE_51588_length_248_cov_1.371429_g50980_i0 | PRJEB81327 | 51588 | 248 | 1.371429 | 3.40114392 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 142 | 1.41e-38 | NR | MSQ47172.1 | 2026735 | g50980 | i0 | 87.7 | 0.979838709677419 | 81 | 10 | 98 | 0 | 4 | 246 | 267 | 347 | MSQ47172.1 type II secretion system protein GspF [Deltaproteobacteria bacterium] | diamond | 243 | 142 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28890111 | 28890111 | PRJEB81327_P_NODE_38588_length_263_cov_2.373684_g37980_i0 | PRJEB81327 | 38588 | 263 | 2.373684 | 6.24278892 | Bacteria | 2 | Bacteria | Bacteria | 109 | 3.72e-28 | NR | MBK7951763.1 | 2026735 | g37980 | i0 | 75 | 1.57414448669202 | 68 | 17 | 77.6 | 0 | 1 | 204 | 102 | 169 | MBK7951763.1 DUF4019 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 414 | 109 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28929116 | 28929116 | PRJEB81327_P_NODE_62328_length_242_cov_1.822485_g61720_i0 | PRJEB81327 | 62328 | 242 | 1.822485 | 4.4104137 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 116 | 4.35e-30 | NR | HEY3447903.1 | 2026763 | g61720 | i0 | 73.8 | 1.97107438016529 | 80 | 21 | 99.2 | 0 | 2 | 241 | 65 | 144 | HEY3447903.1 hypothetical protein [Myxococcales bacterium] | diamond | 477 | 116 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29268894 | 29268894 | PRJEB81327_P_NODE_63429_length_242_cov_0.911243_g62821_i0 | PRJEB81327 | 63429 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 52.4 | 1.47e-5 | NR | KYF91466.1 | 56 | g62821 | i0 | 47.1 | 3.39669421487603 | 51 | 26 | 63.2 | 1 | 70 | 222 | 349 | 398 | KYF91466.1 hypothetical protein BE17_44695 [Sorangium cellulosum] | diamond | 822 | 52.8 | 0.992424242424242 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 29276265 | 29276265 | PRJEB81327_P_NODE_64789_length_241_cov_0.916667_g64181_i0 | PRJEB81327 | 64789 | 241 | 0.916667 | 2.20916747 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 140 | 3.2e-37 | NR | MBN8610625.1 | 2026735 | g64181 | i0 | 91.3 | 1.99170124481328 | 80 | 7 | 99.6 | 0 | 2 | 241 | 59 | 138 | MBN8610625.1 protein kinase [Deltaproteobacteria bacterium] | diamond | 480 | 140 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29402666 | 29402666 | PRJEB81327_P_NODE_43129_length_256_cov_1.278689_g42521_i0 | PRJEB81327 | 43129 | 256 | 1.278689 | 3.27344384 | Chondromyces apiculatus | 51 | Bacteria | Bacteria | 105 | 3.46e-24 | NR | WP_081865414.1 | 51 | g42521 | i0 | 61 | 2.90625 | 82 | 32 | 96.1 | 0 | 248 | 3 | 18 | 99 | WP_081865414.1 phosphoenolpyruvate carboxykinase (GTP) [Chondromyces apiculatus] | diamond | 744 | 105 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces apiculatus | |||
| 29939678 | 29939678 | PRJEB81327_P_NODE_44171_length_254_cov_1.685083_g43563_i0 | PRJEB81327 | 44171 | 254 | 1.685083 | 4.28011082 | Sandaracinus sp. | 2024858 | Bacteria | Bacteria | 60.1 | 2.07e-8 | NR | MFO0683994.1 | 2024858 | g43563 | i0 | 41.9 | 1.01574803149606 | 86 | 44 | 94.5 | 2 | 248 | 9 | 76 | 161 | MFO0683994.1 DUF695 domain-containing protein [Sandaracinus sp.] | diamond | 258 | 60.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus sp. | |||
| 30027103 | 30027103 | PRJEB81327_P_NODE_51211_length_248_cov_1.937143_g50603_i0 | PRJEB81327 | 51211 | 248 | 1.937143 | 4.80411464 | Myxococcia | 32015 | Bacteria | Bacteria | 73.2 | 4.61e-14 | NR | MCA9679617.1 | 2026763 | g50603 | i0 | 46.9 | 3.97983870967742 | 81 | 35 | 94.4 | 3 | 235 | 2 | 74 | 149 | MCA9679617.1 Fis family transcriptional regulator [Myxococcales bacterium] | diamond | 987 | 73.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30539759 | 30539759 | PRJEB81327_P_NODE_39173_length_262_cov_2.439153_g38565_i0 | PRJEB81327 | 39173 | 262 | 2.439153 | 6.39058086 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 152 | 1.4099999999999999e-40 | NR | MFT3925664.1 | 2026763 | g38565 | i0 | 83.9 | 0.99618320610687 | 87 | 14 | 99.6 | 0 | 1 | 261 | 208 | 294 | MFT3925664.1 AAA family ATPase [Myxococcales bacterium] | diamond | 261 | 152 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30666115 | 30666115 | PRJEB81327_P_NODE_29753_length_279_cov_1.145631_g29145_i0 | PRJEB81327 | 29753 | 279 | 1.145631 | 3.19631049 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 45.4 | 0.00387 | NR | MCA9507754.1 | 2026763 | g29145 | i0 | 31.8 | 0.946236559139785 | 88 | 44 | 77.4 | 3 | 229 | 14 | 28 | 115 | MCA9507754.1 hypothetical protein [Myxococcales bacterium] | diamond | 264 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30697666 | 30697666 | PRJEB81327_P_NODE_36194_length_267_cov_3.608247_g35586_i0 | PRJEB81327 | 36194 | 267 | 3.608247 | 9.63401949 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 179 | 5.33e-50 | NR | MCB9541477.1 | 2026763 | g35586 | i0 | 100 | 0.98876404494382 | 88 | 0 | 98.9 | 0 | 2 | 265 | 453 | 540 | MCB9541477.1 AAA family ATPase [Myxococcales bacterium] | diamond | 264 | 179 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31045668 | 31045668 | PRJEB81327_P_NODE_43415_length_255_cov_2.005495_g42807_i0 | PRJEB81327 | 43415 | 255 | 2.005495 | 5.11401225 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 160 | 1.3399999999999996e-43 | NR | MBN8610287.1 | 2026735 | g42807 | i0 | 97.6 | 0.988235294117647 | 84 | 2 | 98.8 | 0 | 254 | 3 | 50 | 133 | MBN8610287.1 PAAR domain-containing protein [Deltaproteobacteria bacterium] | diamond | 252 | 160 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31108366 | 31108366 | PRJEB81327_P_NODE_62835_length_242_cov_0.911243_g62227_i0 | PRJEB81327 | 62835 | 242 | 0.911243 | 2.20520806 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 95.1 | 1.38e-20 | NR | MFT3694333.1 | 2212474 | g62227 | i0 | 63.8 | 0.991735537190083 | 80 | 29 | 99.2 | 0 | 1 | 240 | 1382 | 1461 | MFT3694333.1 ATP-binding protein [Kofleriaceae bacterium] | diamond | 240 | 95.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31266622 | 31266622 | PRJEB81327_P_NODE_63275_length_242_cov_0.911243_g62667_i0 | PRJEB81327 | 63275 | 242 | 0.911243 | 2.20520806 | Archangium sp. | 1872627 | Bacteria | Bacteria | 42 | 0.0437 | NR | MBL8909639.1 | 1872627 | g62667 | i0 | 44.9 | 0.607438016528926 | 49 | 27 | 60.7 | 0 | 148 | 2 | 52 | 100 | MBL8909639.1 hypothetical protein [Archangium sp.] | diamond | 147 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 31298133 | 31298133 | PRJEB81327_P_NODE_38635_length_263_cov_2.184211_g38027_i0 | PRJEB81327 | 38635 | 263 | 2.184211 | 5.74447493 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 47.8 | 7.3e-4 | NR | GMU59394.1 | 2484252 | g38027 | i0 | 34.5 | 0.958174904942966 | 84 | 46 | 92.4 | 2 | 255 | 13 | 170 | 247 | GMU59394.1 MAG: hypothetical protein AMXMBFR34_11570 [Myxococcaceae bacterium] | diamond | 252 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 31393245 | 31393245 | PRJEB81327_P_NODE_23816_length_290_cov_1.059908_g23208_i0 | PRJEB81327 | 23816 | 290 | 1.059908 | 3.0737332 | Vitiosangium sp. GDMCC 1.1324 | 2138576 | Bacteria | Bacteria | 112 | 2.22e-26 | NR | WP_108069405.1 | 2138576 | g23208 | i0 | 58.8 | 1.00344827586207 | 97 | 39 | 99.3 | 1 | 290 | 3 | 932 | 1028 | WP_108069405.1 translocation/assembly module TamB domain-containing protein [Vitiosangium sp. GDMCC 1.1324] | diamond | 291 | 112 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Vitiosangium | Vitiosangium sp. GDMCC 1.1324 | ||
| 31962402 | 31962402 | PRJEB81327_P_NODE_31478_length_276_cov_0.916256_g30870_i0 | PRJEB81327 | 31478 | 276 | 0.916256 | 2.52886656 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 59.3 | 7.85e-8 | NR | HSC87028.1 | 2268199 | g30870 | i0 | 53.9 | 0.826086956521739 | 76 | 35 | 82.6 | 0 | 272 | 45 | 91 | 166 | HSC87028.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 228 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32184041 | 32184041 | PRJEB81327_P_NODE_26078_length_285_cov_2.438679_g25470_i0 | PRJEB81327 | 26078 | 285 | 2.438679 | 6.95023515 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 173 | 1.18e-50 | NR | MDF2693806.1 | 1971228 | g25470 | i0 | 88.2 | 1.96842105263158 | 93 | 11 | 97.9 | 0 | 3 | 281 | 183 | 275 | MDF2693806.1 hypothetical protein [Labilithrix sp.] | diamond | 561 | 173 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 32500550 | 32500550 | PRJEB81327_P_NODE_24619_length_288_cov_1.432558_g24011_i0 | PRJEB81327 | 24619 | 288 | 1.432558 | 4.12576704 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 65.1 | 2.05e-10 | NR | MEO8530726.1 | 2026735 | g24011 | i0 | 55.4 | 2.6875 | 56 | 23 | 58.3 | 2 | 1 | 168 | 34 | 87 | MEO8530726.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 774 | 65.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32500556 | 32500556 | PRJEB81327_P_NODE_46439_length_251_cov_0.865169_g45831_i0 | PRJEB81327 | 46439 | 251 | 0.865169 | 2.17157419 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 145 | 2.23e-38 | NR | MCU0656837.1 | 2268199 | g45831 | i0 | 88 | 0.99203187250996006 | 83 | 9 | 99.2 | 1 | 2 | 250 | 309 | 390 | MCU0656837.1 glutamine amidotransferase [Polyangiaceae bacterium] | diamond | 249 | 145 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32657765 | 32657765 | PRJEB81327_P_NODE_25220_length_287_cov_1.439252_g24612_i0 | PRJEB81327 | 25220 | 287 | 1.439252 | 4.13065324 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 161 | 5.81e-45 | NR | MBS2015326.1 | 2026735 | g24612 | i0 | 81.1 | 0.993031358885017 | 95 | 18 | 99.3 | 0 | 2 | 286 | 196 | 290 | MBS2015326.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 285 | 161 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32878468 | 32878468 | PRJEB81327_P_NODE_27960_length_282_cov_1.440191_g27352_i0 | PRJEB81327 | 27960 | 282 | 1.440191 | 4.06133862 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 97.4 | 6.229999999999999e-23 | NR | MBX3189672.1 | 1971228 | g27352 | i0 | 92.6 | 0.574468085106383 | 54 | 4 | 57.4 | 0 | 2 | 163 | 143 | 196 | MBX3189672.1 RNA polymerase sigma factor [Labilithrix sp.] | diamond | 162 | 97.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. |
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);;