contig_metadata
13 rows where bioproject = "PRJEB75227" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5238162 | 5238162 | PRJEB75227_P_NODE_11185_length_244_cov_0.912281_g11014_i0 | PRJEB75227 | 11185 | 244 | 0.912281 | 2.22596564 | Pyxidicoccus parkwayensis | 2813578 | Bacteria | Bacteria | 281 | 2.58e-71 | NTclustered | gi|1998505907|gb|CP071090.1| | 2813578 | g11014 | i0 | 87.866 | 3.71311475409836 | 239 | 29 | 98 | 0 | 6 | 244 | 13133763 | 13134001 | Pyxidicoccus parkwaysis strain SCPEA02 chromosome | blastn | 906 | 281 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pyxidicoccus | Pyxidicoccus parkwayensis | ||
| 14164017 | 14164017 | PRJEB75227_P_NODE_5352_length_302_cov_1.362445_g5181_i0 | PRJEB75227 | 5352 | 302 | 1.362445 | 4.1145839 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 88.2 | 1.71e-18 | NR | MEM7437925.1 | 2818507 | g5181 | i0 | 60.9 | 0.635761589403974 | 64 | 25 | 63.6 | 0 | 301 | 110 | 99 | 162 | MEM7437925.1 alpha/beta fold hydrolase [Myxococcota bacterium] | diamond | 192 | 88.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 16712300 | 16712300 | PRJEB75227_P_NODE_10634_length_245_cov_1.000000_g10463_i0 | PRJEB75227 | 10634 | 245 | 1 | 2.45 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 104 | 2.6599999999999998e-24 | NR | MBW1839446.1 | 2026735 | g10463 | i0 | 73 | 17.9020408163265 | 63 | 17 | 77.1 | 0 | 230 | 42 | 201 | 263 | MBW1839446.1 elongation factor Tu [Deltaproteobacteria bacterium] | diamond | 4386 | 104 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27065709 | 27065709 | PRJEB75227_P_NODE_8542_length_252_cov_0.871508_g8371_i0 | PRJEB75227 | 8542 | 252 | 0.871508 | 2.19620016 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 44.7 | 0.00111 | NR | HKE12440.1 | 2818507 | g8371 | i0 | 76.2 | 0.25 | 21 | 5 | 25 | 0 | 250 | 188 | 47 | 67 | HKE12440.1 hypothetical protein [Myxococcota bacterium] | diamond | 63 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28044875 | 28044875 | PRJEB75227_P_NODE_7345_length_266_cov_1.554404_g7174_i0 | PRJEB75227 | 7345 | 266 | 1.554404 | 4.13471464 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 139 | 1.14e-37 | NR | HET6344165.1 | 2818507 | g7174 | i0 | 75.9 | 0.981203007518797 | 87 | 21 | 98.1 | 0 | 5 | 265 | 6 | 92 | HET6344165.1 serine/threonine-protein kinase [Myxococcota bacterium] | diamond | 261 | 139 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29055447 | 29055447 | PRJEB75227_P_NODE_9768_length_248_cov_0.891429_g9597_i0 | PRJEB75227 | 9768 | 248 | 0.891429 | 2.21074392 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 63.9 | 1.61e-10 | NR | MBP7160936.1 | 2818507 | g9597 | i0 | 100 | 0.375 | 31 | 0 | 37.5 | 0 | 1 | 93 | 122 | 152 | MBP7160936.1 biopolymer transporter ExbD [Myxococcota bacterium] | diamond | 93 | 63.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29433880 | 29433880 | PRJEB75227_P_NODE_7730_length_260_cov_1.117647_g7559_i0 | PRJEB75227 | 7730 | 260 | 1.117647 | 2.9058822 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 58.2 | 4.18e-8 | NR | HET9954091.1 | 2268199 | g7559 | i0 | 61 | 0.473076923076923 | 41 | 16 | 47.3 | 0 | 2 | 124 | 77 | 117 | HET9954091.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 123 | 58.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30445093 | 30445093 | PRJEB75227_P_NODE_3813_length_367_cov_1.520408_g3642_i0 | PRJEB75227 | 3813 | 367 | 1.520408 | 5.57989736 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 88.6 | 6.23e-20 | NR | MCA9640749.1 | 2026763 | g3642 | i0 | 82.1 | 0.457765667574932 | 56 | 10 | 45.8 | 0 | 1 | 168 | 57 | 112 | MCA9640749.1 hypothetical protein [Myxococcales bacterium] | diamond | 168 | 88.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31045592 | 31045592 | PRJEB75227_P_NODE_9835_length_248_cov_0.891429_g9664_i0 | PRJEB75227 | 9835 | 248 | 0.891429 | 2.21074392 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 58.2 | 1.42e-7 | NR | MBN8536338.1 | 2026735 | g9664 | i0 | 48.3 | 1.35483870967742 | 60 | 24 | 72.6 | 1 | 2 | 181 | 397 | 449 | MBN8536338.1 methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [Deltaproteobacteria bacterium] | diamond | 336 | 58.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31171383 | 31171383 | PRJEB75227_P_NODE_8155_length_253_cov_1.100000_g7984_i0 | PRJEB75227 | 8155 | 253 | 1.1 | 2.783 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 42.4 | 0.0472 | NR | KYF73472.1 | 56 | g7984 | i0 | 48.4 | 0.735177865612648 | 62 | 31 | 73.5 | 1 | 45 | 230 | 134 | 194 | KYF73472.1 hypothetical protein BE17_24905 [Sorangium cellulosum] | diamond | 186 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 31804040 | 31804040 | PRJEB75227_P_NODE_3117_length_416_cov_0.909621_g2946_i0 | PRJEB75227 | 3117 | 416 | 0.909621 | 3.78402336 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 46.6 | 0.0103 | NR | MBK9263173.1 | 2268199 | g2946 | i0 | 37.5 | 0.461538461538462 | 64 | 27 | 46.2 | 2 | 24 | 215 | 219 | 269 | MBK9263173.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 192 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31962327 | 31962327 | PRJEB75227_P_NODE_6238_length_284_cov_0.985782_g6067_i0 | PRJEB75227 | 6238 | 284 | 0.985782 | 2.79962088 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 53.1 | 6.99e-6 | NR | MBK8215412.1 | 2026763 | g6067 | i0 | 42.2 | 0.676056338028169 | 64 | 31 | 67.6 | 1 | 26 | 217 | 145 | 202 | MBK8215412.1 glutathione S-transferase family protein [Myxococcales bacterium] | diamond | 192 | 53.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32721028 | 32721028 | PRJEB75227_P_NODE_7240_length_268_cov_1.200000_g7069_i0 | PRJEB75227 | 7240 | 268 | 1.2 | 3.216 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 64.3 | 1.26e-9 | NR | MDP6944889.1 | 2818507 | g7069 | i0 | 43 | 0.962686567164179 | 86 | 49 | 96.3 | 0 | 1 | 258 | 215 | 300 | MDP6944889.1 serine/threonine-protein kinase [Myxococcota bacterium] | diamond | 258 | 64.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);;