contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJEB39269" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57138 | 57138 | PRJEB39269_P_NODE_81481_length_158_cov_1.033613_g81076_i0 | PRJEB39269 | 81481 | 158 | 1.033613 | 1.63310854 | Myxococcales | 29 | Bacteria | Bacteria | 60.8 | 2.82e-9 | NR | HEY0881086.1 | 1872627 | g81076 | i0 | 64.7 | 3.81645569620253 | 51 | 18 | 96.8 | 0 | 156 | 4 | 190 | 240 | HEY0881086.1 3-oxoacyl-[acyl-carrier-protein] reductase [Archangium sp.] | diamond | 603 | 60.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 26716398 | 26716398 | PRJEB39269_P_NODE_29441_length_256_cov_1.502304_g29036_i0 | PRJEB39269 | 29441 | 256 | 1.502304 | 3.84589824 | Polyangium fumosum | 889272 | Bacteria | Bacteria | 72.4 | 1.13e-13 | NR | WP_136935045.1 | 889272 | g29036 | i0 | 61.5 | 1.21875 | 52 | 20 | 60.9 | 0 | 254 | 99 | 111 | 162 | WP_136935045.1 hypothetical protein [Polyangium fumosum] | diamond | 312 | 72.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium fumosum | |||
| 26875430 | 26875430 | PRJEB39269_P_NODE_5501_length_573_cov_5.741573_g5138_i0 | PRJEB39269 | 5501 | 573 | 5.741573 | 32.89921329 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 48.5 | 0.00223 | NR | HTO98605.1 | 2026763 | g5138 | i0 | 31.1 | 0.554973821989529 | 106 | 51 | 48.7 | 4 | 552 | 274 | 33 | 129 | HTO98605.1 Hsp20/alpha crystallin family protein [Myxococcales bacterium] | diamond | 318 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27317983 | 27317983 | PRJEB39269_P_NODE_66783_length_170_cov_3.091603_g66378_i0 | PRJEB39269 | 66783 | 170 | 3.091603 | 5.2557251 | Myxococcales bacterium 68-2 | 2026763 | Bacteria | Bacteria | 45.8 | 1.07e-4 | NR | OJY30211.1 | 1895795 | g66378 | i0 | 52.9 | 0.9 | 51 | 22 | 90 | 1 | 169 | 17 | 2 | 50 | OJY30211.1 MAG: hypothetical protein BGO98_26080 [Myxococcales bacterium 68-20] | diamond | 153 | 45.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium 68-20 | ||||
| 27602230 | 27602230 | PRJEB39269_P_NODE_70564_length_167_cov_2.351562_g70159_i0 | PRJEB39269 | 70564 | 167 | 2.351562 | 3.92710854 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 55.5 | 1.64e-8 | NR | HVZ31771.1 | 2268199 | g70159 | i0 | 52.2 | 0.826347305389222 | 46 | 22 | 82.6 | 0 | 30 | 167 | 5 | 50 | HVZ31771.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 138 | 55.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27602232 | 27602232 | PRJEB39269_P_NODE_79024_length_159_cov_2.916667_g78619_i0 | PRJEB39269 | 79024 | 159 | 2.916667 | 4.63750053 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 45.4 | 7.33e-4 | NR | MDB5217040.1 | 2484252 | g78619 | i0 | 62.5 | 0.452830188679245 | 24 | 9 | 45.3 | 0 | 151 | 80 | 137 | 160 | MDB5217040.1 hypothetical protein [Myxococcaceae bacterium] | diamond | 72 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 27690565 | 27690565 | PRJEB39269_P_NODE_59544_length_179_cov_1.171429_g59139_i0 | PRJEB39269 | 59544 | 179 | 1.171429 | 2.09685791 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 60.5 | 2.13e-10 | NR | HXS18576.1 | 2268199 | g59139 | i0 | 100 | 5.16201117318436 | 28 | 0 | 46.9 | 0 | 3 | 86 | 40 | 67 | HXS18576.1 DUF3612 domain-containing protein [Polyangiaceae bacterium] | diamond | 924 | 60.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27753551 | 27753551 | PRJEB39269_P_NODE_51764_length_191_cov_1.335526_g51359_i0 | PRJEB39269 | 51764 | 191 | 1.335526 | 2.55085466 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 86.7 | 2.52e-19 | NR | MBI1997099.1 | 2026735 | g51359 | i0 | 57.1 | 9.95811518324607 | 63 | 27 | 99 | 0 | 1 | 189 | 109 | 171 | MBI1997099.1 archaemetzincin family Zn-dependent metalloprotease [Deltaproteobacteria bacterium] | diamond | 1902 | 87.4 | 0.991990846681922 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28012695 | 28012695 | PRJEB39269_P_NODE_32085_length_244_cov_1.800000_g31680_i0 | PRJEB39269 | 32085 | 244 | 1.8 | 4.392 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 65.9 | 2.46e-10 | NR | MEN8183890.1 | 2818507 | g31680 | i0 | 43.9 | 3.87295081967213 | 66 | 37 | 81.1 | 0 | 202 | 5 | 1 | 66 | MEN8183890.1 aromatic ring-hydroxylating dioxygenase subunit alpha [Myxococcota bacterium] | diamond | 945 | 65.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28107126 | 28107126 | PRJEB39269_P_NODE_89265_length_151_cov_3.321429_g88860_i0 | PRJEB39269 | 89265 | 151 | 3.321429 | 5.01535779 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 87 | 2.4e-18 | NR | MDB5214851.1 | 2484252 | g88860 | i0 | 85.7 | 0.973509933774834 | 49 | 7 | 97.4 | 0 | 1 | 147 | 382 | 430 | MDB5214851.1 hypothetical protein [Myxococcaceae bacterium] | diamond | 147 | 87 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 28201759 | 28201759 | PRJEB39269_P_NODE_46026_length_202_cov_1.668712_g45621_i0 | PRJEB39269 | 46026 | 202 | 1.668712 | 3.37079824 | Byssovorax sp. | 2927945 | Bacteria | Bacteria | 77.4 | 2.77e-16 | NR | MFS8064965.1 | 2927945 | g45621 | i0 | 57.9 | 0.846534653465347 | 57 | 24 | 84.7 | 0 | 31 | 201 | 62 | 118 | MFS8064965.1 hypothetical protein [Byssovorax sp.] | diamond | 171 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Byssovorax | Byssovorax sp. | |||
| 28264931 | 28264931 | PRJEB39269_P_NODE_8526_length_474_cov_1.494253_g8128_i0 | PRJEB39269 | 8526 | 474 | 1.494253 | 7.08275922 | Archangium sp. | 1872627 | Bacteria | Bacteria | 63.9 | 1.46e-8 | NR | MDP2270461.1 | 1872627 | g8128 | i0 | 37.6 | 0.740506329113924 | 117 | 61 | 72.8 | 3 | 458 | 114 | 271 | 377 | MDP2270461.1 serine protease [Archangium sp.] | diamond | 351 | 63.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28612461 | 28612461 | PRJEB39269_P_NODE_64427_length_172_cov_2.240602_g64022_i0 | PRJEB39269 | 64427 | 172 | 2.240602 | 3.85383544 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 94 | 8.709999999999999e-23 | NR | MEO1482256.1 | 2818507 | g64022 | i0 | 79.6 | 1.67441860465116 | 49 | 10 | 85.5 | 0 | 148 | 2 | 3 | 51 | MEO1482256.1 GCN5 family acetyltransferase [Myxococcota bacterium] | diamond | 288 | 94 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28770239 | 28770239 | PRJEB39269_P_NODE_89327_length_151_cov_2.866071_g88922_i0 | PRJEB39269 | 89327 | 151 | 2.866071 | 4.32776721 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 75.9 | 7.97e-15 | NR | HEY8079817.1 | 1971228 | g88922 | i0 | 52.7 | 2.94039735099338 | 74 | 11 | 99.3 | 1 | 150 | 1 | 12 | 85 | HEY8079817.1 uracil phosphoribosyltransferase [Labilithrix sp.] | diamond | 444 | 75.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 29054606 | 29054606 | PRJEB39269_P_NODE_40108_length_217_cov_1.449438_g39703_i0 | PRJEB39269 | 40108 | 217 | 1.449438 | 3.14528046 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 44.3 | 0.00707 | NR | HEY5147220.1 | 2268199 | g39703 | i0 | 38.7 | 0.857142857142857 | 62 | 37 | 84.3 | 1 | 188 | 6 | 85 | 146 | HEY5147220.1 LD-carboxypeptidase [Polyangiaceae bacterium] | diamond | 186 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30001914 | 30001914 | PRJEB39269_P_NODE_14711_length_366_cov_1.697248_g14306_i0 | PRJEB39269 | 14711 | 366 | 1.697248 | 6.21192768 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 119 | 1.11e-29 | NR | WNG16887.1 | 43 | g14306 | i0 | 57.3 | 1.45901639344262 | 89 | 38 | 73 | 0 | 2 | 268 | 259 | 347 | WNG16887.1 alpha/beta hydrolase [Cystobacter fuscus] | diamond | 534 | 119 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 30191205 | 30191205 | PRJEB39269_P_NODE_67612_length_170_cov_2.419847_g67207_i0 | PRJEB39269 | 67612 | 170 | 2.419847 | 4.1137399 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 47 | 4.41e-4 | NR | MDB4933499.1 | 1971228 | g67207 | i0 | 80.8 | 0.458823529411765 | 26 | 5 | 45.9 | 0 | 2 | 79 | 386 | 411 | MDB4933499.1 peroxidase [Labilithrix sp.] | diamond | 78 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 30222841 | 30222841 | PRJEB39269_P_NODE_29032_length_258_cov_1.123288_g28627_i0 | PRJEB39269 | 29032 | 258 | 1.123288 | 2.89808304 | Anaeromyxobacteraceae bacterium | 2510643 | Bacteria | Bacteria | 72.4 | 1.6e-12 | NR | HVP66227.1 | 2510643 | g28627 | i0 | 50 | 1.7906976744186 | 82 | 37 | 95.3 | 1 | 3 | 248 | 464 | 541 | HVP66227.1 PKD domain-containing protein [Anaeromyxobacteraceae bacterium] | diamond | 462 | 72.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 30254812 | 30254812 | PRJEB39269_P_NODE_67092_length_170_cov_2.770992_g66687_i0 | PRJEB39269 | 67092 | 170 | 2.770992 | 4.7106864 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 43.5 | 0.00747 | NR | MDB5218906.1 | 2484252 | g66687 | i0 | 76.9 | 0.458823529411765 | 26 | 6 | 45.9 | 0 | 93 | 170 | 126 | 151 | MDB5218906.1 hypothetical protein [Myxococcaceae bacterium] | diamond | 78 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 30412793 | 30412793 | PRJEB39269_P_NODE_88393_length_152_cov_1.548673_g87988_i0 | PRJEB39269 | 88393 | 152 | 1.548673 | 2.35398296 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 77.4 | 4.16e-16 | NR | MBI3758952.1 | 2026735 | g87988 | i0 | 68 | 0.986842105263158 | 50 | 16 | 98.7 | 0 | 3 | 152 | 34 | 83 | MBI3758952.1 TolC family protein [Deltaproteobacteria bacterium] | diamond | 150 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30943174 | 30943174 | PRJEB39269_P_NODE_67314_length_170_cov_2.625954_g66909_i0 | PRJEB39269 | 67314 | 170 | 2.625954 | 4.4641218 | Bacteria | 2 | Bacteria | Bacteria | 54.3 | 1.13e-6 | NR | MEA2750805.1 | 2026763 | g66909 | i0 | 100 | 1.83529411764706 | 26 | 0 | 45.9 | 0 | 169 | 92 | 62 | 87 | MEA2750805.1 PmbA protein [Myxococcales bacterium] | diamond | 312 | 54.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31201939 | 31201939 | PRJEB39269_P_NODE_60015_length_178_cov_1.525180_g59610_i0 | PRJEB39269 | 60015 | 178 | 1.52518 | 2.7148204 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 73.9 | 1.58e-13 | NR | HLK39604.1 | 2268199 | g59610 | i0 | 64.3 | 1.90449438202247 | 56 | 20 | 94.4 | 0 | 178 | 11 | 6 | 61 | HLK39604.1 MupA/Atu3671 family FMN-dependent luciferase-like monooxygenase [Polyangiaceae bacterium] | diamond | 339 | 73.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31265644 | 31265644 | PRJEB39269_P_NODE_41455_length_213_cov_2.252874_g41050_i0 | PRJEB39269 | 41455 | 213 | 2.252874 | 4.79862162 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 70.5 | 2.22e-13 | NR | HKC58682.1 | 2026763 | g41050 | i0 | 50 | 0.985915492957746 | 70 | 35 | 98.6 | 0 | 211 | 2 | 20 | 89 | HKC58682.1 hypothetical protein [Myxococcales bacterium] | diamond | 210 | 70.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31328876 | 31328876 | PRJEB39269_P_NODE_52496_length_190_cov_0.894040_g52091_i0 | PRJEB39269 | 52496 | 190 | 0.89404 | 1.698676 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42 | 0.0351 | NR | MBA2320376.1 | 2026735 | g52091 | i0 | 51.4 | 0.58421052631579 | 37 | 17 | 56.8 | 1 | 49 | 156 | 205 | 241 | MBA2320376.1 IMP dehydrogenase [Deltaproteobacteria bacterium] | diamond | 111 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31708438 | 31708438 | PRJEB39269_P_NODE_90837_length_150_cov_2.270270_g90432_i0 | PRJEB39269 | 90837 | 150 | 2.27027 | 3.405405 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 44.3 | 0.00307 | NR | MDB5212839.1 | 2484252 | g90432 | i0 | 87.5 | 0.48 | 24 | 3 | 48 | 0 | 79 | 150 | 21 | 44 | MDB5212839.1 Serine/threonine kinase [Myxococcaceae bacterium] | diamond | 72 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 31828201 | 31828201 | PRJEB39269_P_NODE_80457_length_158_cov_3.151261_g80052_i0 | PRJEB39269 | 80457 | 158 | 3.151261 | 4.97899238 | Bacteria | 2 | Bacteria | Bacteria | 46.2 | 6.98e-4 | NR | MEA2750603.1 | 2026763 | g80052 | i0 | 88 | 0.949367088607595 | 25 | 3 | 47.5 | 0 | 76 | 2 | 502 | 526 | MEA2750603.1 uncharacterized protein [Myxococcales bacterium] | diamond | 150 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32088084 | 32088084 | PRJEB39269_P_NODE_66638_length_170_cov_3.267176_g66233_i0 | PRJEB39269 | 66638 | 170 | 3.267176 | 5.5541992 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 49.7 | 4.8e-5 | NR | MBI2605272.1 | 2026735 | g66233 | i0 | 80.8 | 0.917647058823529 | 26 | 5 | 45.9 | 0 | 79 | 2 | 21 | 46 | MBI2605272.1 tetratricopeptide repeat protein [Deltaproteobacteria bacterium] | diamond | 156 | 49.7 | 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);;