contig_metadata
16 rows where bioproject = "PRJNA312615" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3614393 | 3614393 | PRJNA312615_P_NODE_27143_length_235_cov_0.978495_g26992_i0 | PRJNA312615 | 27143 | 235 | 0.978495 | 2.29946325 | Polyangiales | 3031712 | Bacteria | Bacteria | 123 | 8.22e-33 | NR | HRI66518.1 | 57 | g26992 | i0 | 76 | 41.1446808510638 | 75 | 18 | 95.7 | 0 | 2 | 226 | 57 | 131 | HRI66518.1 CoA transferase subunit A [Polyangium sp.] | diamond | 9669 | 124 | 0.991935483870968 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 14407028 | 14407028 | PRJNA312615_P_NODE_27892_length_231_cov_2.467033_g27741_i0 | PRJNA312615 | 27892 | 231 | 2.467033 | 5.69884623 | root | 1 | Root_unresolved | Root_unresolved | 97.1 | 6.76e-23 | NR | WP_050430790.1 | 52 | g27741 | i0 | 71.9 | 4.18181818181818 | 64 | 18 | 83.1 | 0 | 11 | 202 | 150 | 213 | WP_050430790.1 maleylacetoacetate isomerase [Chondromyces crocatus] | diamond | 966 | 97.4 | 0.996919917864476 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 26725668 | 26725668 | PRJNA312615_P_NODE_26381_length_238_cov_1.079365_g26230_i0 | PRJNA312615 | 26381 | 238 | 1.079365 | 2.5688887 | Polyangium sp. | 3409587 | Bacteria | Bacteria | 58.5 | 9.25e-8 | NR | HRI69950.1 | 57 | g26230 | i0 | 50.7 | 3.3781512605042 | 67 | 27 | 84.5 | 1 | 35 | 235 | 218 | 278 | HRI69950.1 dihydrolipoamide acetyltransferase family protein [Polyangium sp.] | diamond | 804 | 58.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 27548157 | 27548157 | PRJNA312615_P_NODE_17024_length_297_cov_1.572581_g16873_i0 | PRJNA312615 | 17024 | 297 | 1.572581 | 4.67056557 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 73.9 | 1.67e-13 | NR | MCA9619831.1 | 2026763 | g16873 | i0 | 43.8 | 1.7979797979798 | 89 | 48 | 87.9 | 1 | 296 | 36 | 60 | 148 | MCA9619831.1 endonuclease/exonuclease/phosphatase family protein [Myxococcales bacterium] | diamond | 534 | 73.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27674714 | 27674714 | PRJNA312615_P_NODE_17104_length_296_cov_2.064777_g16953_i0 | PRJNA312615 | 17104 | 296 | 2.064777 | 6.11173992 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 85.5 | 6.15e-17 | NR | MCK6510237.1 | 2818507 | g16953 | i0 | 46.4 | 3.9222972972973 | 97 | 51 | 98.3 | 1 | 292 | 2 | 392 | 487 | MCK6510237.1 leucyl aminopeptidase [Myxococcota bacterium] | diamond | 1161 | 85.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27895436 | 27895436 | PRJNA312615_P_NODE_5805_length_504_cov_1.547253_g5657_i0 | PRJNA312615 | 5805 | 504 | 1.547253 | 7.79815512 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 101 | 1.69e-21 | NR | MBL8606644.1 | 2026763 | g5657 | i0 | 49 | 1.24404761904762 | 102 | 48 | 58.3 | 2 | 455 | 162 | 328 | 429 | MBL8606644.1 hypothetical protein [Myxococcales bacterium] | diamond | 627 | 101 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28021982 | 28021982 | PRJNA312615_P_NODE_37685_length_200_cov_1.284768_g37534_i0 | PRJNA312615 | 37685 | 200 | 1.284768 | 2.569536 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42.4 | 0.0113 | NR | MEK7841985.1 | 2026735 | g37534 | i0 | 38.5 | 0.585 | 39 | 24 | 58.5 | 0 | 19 | 135 | 8 | 46 | MEK7841985.1 two-component regulator propeller domain-containing protein [Deltaproteobacteria bacterium] | diamond | 117 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28779448 | 28779448 | PRJNA312615_P_NODE_22787_length_255_cov_2.019417_g22636_i0 | PRJNA312615 | 22787 | 255 | 2.019417 | 5.14951335 | Vulgatibacter sp. | 1971226 | Bacteria | Bacteria | 87 | 6.79e-19 | NR | HWV37543.1 | 1971226 | g22636 | i0 | 55.4 | 0.976470588235294 | 83 | 34 | 97.6 | 2 | 5 | 253 | 29 | 108 | HWV37543.1 maleylacetoacetate isomerase [Vulgatibacter sp.] | diamond | 249 | 87 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Vulgatibacteraceae | Vulgatibacter | Vulgatibacter sp. | ||
| 28969134 | 28969134 | PRJNA312615_P_NODE_23848_length_250_cov_1.363184_g23697_i0 | PRJNA312615 | 23848 | 250 | 1.363184 | 3.40796 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.1 | 0.0297 | NR | MBI5611083.1 | 2026735 | g23697 | i0 | 39.3 | 0.732 | 61 | 35 | 73.2 | 1 | 47 | 229 | 261 | 319 | MBI5611083.1 bacillithiol biosynthesis cysteine-adding enzyme BshC [Deltaproteobacteria bacterium] | diamond | 183 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29505704 | 29505704 | PRJNA312615_P_NODE_41090_length_191_cov_1.422535_g40939_i0 | PRJNA312615 | 41090 | 191 | 1.422535 | 2.71704185 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 76.3 | 2.86e-14 | NR | MFO0694287.1 | 3034171 | g40939 | i0 | 60 | 1.47643979057592 | 50 | 19 | 77 | 1 | 1 | 147 | 51 | 100 | MFO0694287.1 thrombospondin type 3 repeat-containing protein [Polyangiales bacterium] | diamond | 282 | 76.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 30168838 | 30168838 | PRJNA312615_P_NODE_24672_length_246_cov_1.477157_g24521_i0 | PRJNA312615 | 24672 | 246 | 1.477157 | 3.63380622 | Stigmatella aurantiaca DW4/3-1 | 378806 | Bacteria | Bacteria | 44.7 | 0.00844 | NR | EAU62172.1 | 378806 | g24521 | i0 | 42.9 | 1.32926829268293 | 49 | 24 | 57.3 | 2 | 213 | 73 | 6 | 52 | EAU62172.1 conserved hypothetical protein, partial [Stigmatella aurantiaca DW4/3-1] | diamond | 327 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 30674468 | 30674468 | PRJNA312615_P_NODE_41873_length_189_cov_1.457143_g41722_i0 | PRJNA312615 | 41873 | 189 | 1.457143 | 2.75400027 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 129 | 2.8e-36 | NR | MEZ0314212.1 | 2818507 | g41722 | i0 | 100 | 1 | 63 | 0 | 100 | 0 | 1 | 189 | 56 | 118 | MEZ0314212.1 hypothetical protein [Myxococcota bacterium] | diamond | 189 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30706051 | 30706051 | PRJNA312615_P_NODE_41134_length_191_cov_1.211268_g40983_i0 | PRJNA312615 | 41134 | 191 | 1.211268 | 2.31352188 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 86.7 | 1.71e-19 | NR | MCK6502336.1 | 2818507 | g40983 | i0 | 69.5 | 0.926701570680628 | 59 | 16 | 92.7 | 1 | 3 | 179 | 116 | 172 | MCK6502336.1 peptidylprolyl isomerase [Myxococcota bacterium] | diamond | 177 | 86.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30706052 | 30706052 | PRJNA312615_P_NODE_42614_length_187_cov_2.188406_g42463_i0 | PRJNA312615 | 42614 | 187 | 2.188406 | 4.09231922 | Bradymonadia bacterium | 3121696 | Bacteria | Bacteria | 81.3 | 2.23e-16 | NR | MFT6396027.1 | 3121696 | g42463 | i0 | 81.4 | 1.37967914438503 | 43 | 8 | 69 | 0 | 57 | 185 | 3 | 45 | MFT6396027.1 malate dehydrogenase [Bradymonadia bacterium] | diamond | 258 | 81.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Bradymonadia | Bradymonadia bacterium | |||||
| 32855302 | 32855302 | PRJNA312615_P_NODE_9020_length_411_cov_1.635359_g8870_i0 | PRJNA312615 | 9020 | 411 | 1.635359 | 6.72132549 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 45.4 | 0.0233 | NR | HRH00199.1 | 2268199 | g8870 | i0 | 40.5 | 0.613138686131387 | 84 | 41 | 61.3 | 2 | 25 | 276 | 302 | 376 | HRH00199.1 polysaccharide deacetylase family protein [Polyangiaceae bacterium] | diamond | 252 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32904270 | 32904270 | PRJNA312615_P_NODE_38620_length_197_cov_2.175676_g38469_i0 | PRJNA312615 | 38620 | 197 | 2.175676 | 4.28608172 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 68.2 | 2.19e-11 | NR | MEE2961094.1 | 2818507 | g38469 | i0 | 90 | 7.15736040609137 | 30 | 3 | 45.7 | 0 | 197 | 108 | 931 | 960 | MEE2961094.1 aminomethyl-transferring glycine dehydrogenase [Myxococcota bacterium] | diamond | 1410 | 68.6 | 0.994169096209913 | 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);;