contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJEB6584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25661261 | 25661261 | PRJEB6584o_S_NODE_6682_length_324_cov_8.647059_g6574_i0 | PRJEB6584 | 6682 | 324 | 8.647059 | 28.01647116 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 67 | 6.21e-12 | NR | MEZ4264423.1 | 2268199 | g6574 | i0 | 43 | 0.796296296296296 | 86 | 46 | 77.8 | 2 | 289 | 38 | 4 | 88 | MEZ4264423.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 258 | 67 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 26340057 | 26340057 | PRJEB6584e_S_NODE_1311_length_234_cov_3.492462_g1296_i0 | PRJEB6584 | 1311 | 234 | 3.492462 | 8.17236108 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 57 | 3.05e-7 | NR | MEM9729816.1 | 2818507 | g1296 | i0 | 40.3 | 3.71794871794872 | 72 | 43 | 92.3 | 0 | 223 | 8 | 461 | 532 | MEM9729816.1 long-chain fatty acid--CoA ligase [Myxococcota bacterium] | diamond | 870 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32957466 | 32957466 | PRJEB6584o_S_NODE_14842_length_229_cov_3.860825_g14734_i0 | PRJEB6584 | 14842 | 229 | 3.860825 | 8.84128925 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 84 | 2.74e-17 | NR | MCL5126502.1 | 2026735 | g14734 | i0 | 72.4 | 7.96506550218341 | 58 | 15 | 74.7 | 1 | 227 | 57 | 235 | 292 | MCL5126502.1 acetyl-CoA C-acyltransferase [Deltaproteobacteria bacterium] | diamond | 1824 | 84 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32980551 | 32980551 | PRJEB6584j_S_NODE_8971_length_181_cov_1.917808_g8942_i0 | PRJEB6584 | 8971 | 181 | 1.917808 | 3.47123248 | Anaeromyxobacter sp. | 1872521 | Bacteria | Bacteria | 42 | 0.0314 | NR | HET6413085.1 | 1872521 | g8942 | i0 | 52.6 | 0.629834254143646 | 38 | 18 | 63 | 0 | 11 | 124 | 438 | 475 | HET6413085.1 heterodisulfide reductase-related iron-sulfur binding cluster [Anaeromyxobacter sp.] | diamond | 114 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. | ||
| 32980746 | 32980746 | PRJEB6584o_S_NODE_17219_length_215_cov_1.077778_g17111_i0 | PRJEB6584 | 17219 | 215 | 1.077778 | 2.3172227 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 42 | 0.0275 | NR | MBL8944255.1 | 2026763 | g17111 | i0 | 40.4 | 0.795348837209302 | 57 | 28 | 79.5 | 2 | 33 | 203 | 50 | 100 | MBL8944255.1 DUF1566 domain-containing protein [Myxococcales bacterium] | diamond | 171 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32991634 | 32991634 | PRJEB6584o_S_NODE_11483_length_259_cov_2.816964_g11375_i0 | PRJEB6584 | 11483 | 259 | 2.816964 | 7.29593676 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 79.3 | 9.87e-16 | NR | RJO65884.1 | 2026763 | g11375 | i0 | 74 | 2.38610038610039 | 50 | 13 | 57.9 | 0 | 2 | 151 | 177 | 226 | RJO65884.1 MAG: ABC transporter ATP-binding protein [Myxococcales bacterium] | diamond | 618 | 80.1 | 0.990012484394507 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 33014475 | 33014475 | PRJEB6584e_S_NODE_1996_length_203_cov_1.904762_g1981_i0 | PRJEB6584 | 1996 | 203 | 1.904762 | 3.86666686 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 48.1 | 2.76e-4 | NR | MDX2170269.1 | 2026735 | g1981 | i0 | 47.3 | 1.56650246305419 | 55 | 24 | 78.3 | 3 | 2 | 160 | 140 | 191 | MDX2170269.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 318 | 48.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 33065613 | 33065613 | PRJEB6584d_S_NODE_16797_length_156_cov_1.644628_g16729_i0 | PRJEB6584 | 16797 | 156 | 1.644628 | 2.56561968 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 57.8 | 7.09e-9 | NR | KAB2892992.1 | 2212474 | g16729 | i0 | 63.3 | 0.942307692307692 | 49 | 18 | 94.2 | 0 | 153 | 7 | 1 | 49 | KAB2892992.1 MAG: hypothetical protein F9K40_17510 [Kofleriaceae bacterium] | diamond | 147 | 57.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 33065635 | 33065635 | PRJEB6584h_S_NODE_20949_length_178_cov_1.118881_g20887_i0 | PRJEB6584 | 20949 | 178 | 1.118881 | 1.99160818 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 57 | 5.27e-9 | NR | MBL8631691.1 | 2026763 | g20887 | i0 | 100 | 0.556179775280899 | 33 | 0 | 55.6 | 0 | 101 | 3 | 1 | 33 | MBL8631691.1 hypothetical protein [Myxococcales bacterium] | diamond | 99 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 33066169 | 33066169 | PRJEB6584o_S_NODE_66781_length_159_cov_2.137097_g66673_i0 | PRJEB6584 | 66781 | 159 | 2.137097 | 3.39798423 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 96.3 | 1.7e-23 | NR | MBP48215.1 | 2026763 | g66673 | i0 | 84.3 | 2.84905660377358 | 51 | 8 | 96.2 | 0 | 2 | 154 | 96 | 146 | MBP48215.1 peptidylprolyl isomerase [Myxococcales bacterium] | diamond | 453 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 33093927 | 33093927 | PRJEB6584o_S_NODE_23622_length_192_cov_4.127389_g23514_i0 | PRJEB6584 | 23622 | 192 | 4.127389 | 7.92458688 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47.4 | 4.43e-4 | NR | WP_207050442.1 | 35 | g23514 | i0 | 46.4 | 6.0625 | 56 | 19 | 70.3 | 1 | 137 | 3 | 310 | 365 | WP_207050442.1 RHS repeat-associated core domain-containing protein [Corallococcus macrosporus] | diamond | 1164 | 47.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus macrosporus | ||
| 33099766 | 33099766 | PRJEB6584e_S_NODE_4006_length_156_cov_1.322314_g3991_i0 | PRJEB6584 | 4006 | 156 | 1.322314 | 2.06280984 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 54.7 | 6.79e-7 | NR | NUN13439.1 | 2026763 | g3991 | i0 | 63.9 | 0.692307692307692 | 36 | 13 | 69.2 | 0 | 130 | 23 | 1356 | 1391 | NUN13439.1 lamin tail domain-containing protein [Myxococcales bacterium] | diamond | 108 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 33100339 | 33100339 | PRJEB6584o_S_NODE_73086_length_156_cov_1.851240_g72978_i0 | PRJEB6584 | 73086 | 156 | 1.85124 | 2.8879344 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 53.5 | 1.82e-6 | NR | MBK7192166.1 | 2026763 | g72978 | i0 | 65.7 | 2.26923076923077 | 35 | 12 | 67.3 | 0 | 156 | 52 | 118 | 152 | MBK7192166.1 esterase-like activity of phytase family protein [Myxococcales bacterium] | diamond | 354 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 33127961 | 33127961 | PRJEB6584o_S_NODE_10215_length_273_cov_3.050420_g10107_i0 | PRJEB6584 | 10215 | 273 | 3.05042 | 8.3276466 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.9 | 3.93e-10 | NR | HSD19843.1 | 1872521 | g10107 | i0 | 71.1 | 1.34065934065934 | 45 | 13 | 49.5 | 0 | 273 | 139 | 435 | 479 | HSD19843.1 S41 family peptidase [Anaeromyxobacter sp.] | diamond | 366 | 66.2 | 0.995468277945619 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. | ||
| 33134089 | 33134089 | PRJEB6584l_S_NODE_9039_length_214_cov_12.949721_g8887_i0 | PRJEB6584 | 9039 | 214 | 12.949721 | 27.71240294 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 63.2 | 2.99e-10 | NR | HEX5655833.1 | 3034171 | g8887 | i0 | 70.6 | 1.34579439252336 | 34 | 10 | 47.7 | 0 | 212 | 111 | 140 | 173 | HEX5655833.1 peptide-methionine (S)-S-oxide reductase MsrA [Polyangiales bacterium] | diamond | 288 | 63.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 33134507 | 33134507 | PRJEB6584o_S_NODE_64607_length_160_cov_2.184000_g64499_i0 | PRJEB6584 | 64607 | 160 | 2.184 | 3.4944 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 61.2 | 3.61e-9 | NR | MBK8692178.1 | 2026735 | g64499 | i0 | 64.4 | 0.84375 | 45 | 16 | 84.4 | 0 | 14 | 148 | 40 | 84 | MBK8692178.1 S9 family peptidase [Deltaproteobacteria bacterium] | diamond | 135 | 61.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 33151175 | 33151175 | PRJEB6584o_S_NODE_14488_length_232_cov_2.238579_g14380_i0 | PRJEB6584 | 14488 | 232 | 2.238579 | 5.19350328 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 47 | 0.00105 | NR | HEX6767519.1 | 2268199 | g14380 | i0 | 68.4 | 1.33189655172414 | 38 | 12 | 49.1 | 0 | 112 | 225 | 233 | 270 | HEX6767519.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 309 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 33151635 | 33151635 | PRJEB6584o_S_NODE_9304_length_284_cov_3.297189_g9196_i0 | PRJEB6584 | 9304 | 284 | 3.297189 | 9.36401676 | Minicystis sp. | 1971901 | Bacteria | Bacteria | 51.6 | 3.74e-5 | NR | MFT3775282.1 | 1971901 | g9196 | i0 | 57.1 | 0.443661971830986 | 42 | 14 | 44.4 | 2 | 275 | 150 | 79 | 116 | MFT3775282.1 hypothetical protein [Minicystis sp.] | diamond | 126 | 51.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis sp. | |||
| 33168317 | 33168317 | PRJEB6584o_S_NODE_24656_length_190_cov_2.258065_g24548_i0 | PRJEB6584 | 24656 | 190 | 2.258065 | 4.2903235 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 96.3 | 1.94e-21 | NR | MEW5848822.1 | 2818507 | g24548 | i0 | 81.5 | 3.52105263157895 | 54 | 10 | 85.3 | 0 | 28 | 189 | 404 | 457 | MEW5848822.1 M20 family metallopeptidase [Myxococcota bacterium] | diamond | 669 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota 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);;