contig_metadata
8 rows where bioproject = "PRJNA559720", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5647339 | 5647339 | PRJNA559720_P_NODE_13785_length_250_cov_0.870056_g13646_i0 | PRJNA559720 | 13785 | 250 | 0.870056 | 2.17514 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 140 | 9.31e-38 | NR | MFO0670556.1 | 2268199 | g13646 | i0 | 80.7 | 6.948 | 83 | 16 | 99.6 | 0 | 250 | 2 | 110 | 192 | MFO0670556.1 sigma 54-interacting transcriptional regulator [Polyangiaceae bacterium] | diamond | 1737 | 140 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 15846364 | 15846364 | PRJNA559720_P_NODE_2673_length_626_cov_2.220615_g2553_i0 | PRJNA559720 | 2673 | 626 | 2.220615 | 13.9010499 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 186 | 5.589999999999998e-55 | NR | MBI2609126.1 | 2026735 | g2553 | i0 | 59.7 | 16.4568690095847 | 154 | 60 | 73.3 | 2 | 626 | 168 | 120 | 272 | MBI2609126.1 NAD(P)-dependent oxidoreductase [Deltaproteobacteria bacterium] | diamond | 10302 | 186 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26889344 | 26889344 | PRJNA559720_P_NODE_12801_length_261_cov_1.234043_g12662_i0 | PRJNA559720 | 12801 | 261 | 1.234043 | 3.22085223 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 65.5 | 4.03e-10 | NR | MCB9584402.1 | 2268199 | g12662 | i0 | 52.9 | 0.804597701149425 | 70 | 29 | 75.9 | 2 | 48 | 245 | 298 | 367 | MCB9584402.1 response regulator [Polyangiaceae bacterium] | diamond | 210 | 65.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27598657 | 27598657 | PRJNA559720_P_NODE_10264_length_303_cov_1.004348_g10125_i0 | PRJNA559720 | 10264 | 303 | 1.004348 | 3.04317444 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 140 | 1.16e-36 | NR | MCP4498739.1 | 2026735 | g10125 | i0 | 62.2 | 9.84158415841584 | 98 | 37 | 97 | 0 | 9 | 302 | 430 | 527 | MCP4498739.1 thiamine pyrophosphate-binding protein [Deltaproteobacteria bacterium] | diamond | 2982 | 140 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27616174 | 27616174 | PRJNA559720_P_NODE_11684_length_279_cov_1.218447_g11545_i0 | PRJNA559720 | 11684 | 279 | 1.218447 | 3.39946713 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 43.1 | 0.0395 | NR | MCA9527729.1 | 2026763 | g11545 | i0 | 46.9 | 0.526881720430108 | 49 | 23 | 49.5 | 1 | 275 | 138 | 24 | 72 | MCA9527729.1 TraB/GumN family protein [Myxococcales bacterium] | diamond | 147 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28103512 | 28103512 | PRJNA559720_P_NODE_6585_length_398_cov_3.341538_g6446_i0 | PRJNA559720 | 6585 | 398 | 3.341538 | 13.29932124 | Bacteria | 2 | Bacteria | Bacteria | 81.3 | 4.11e-15 | NR | MCA9519868.1 | 2026763 | g6446 | i0 | 35.2 | 1.8391959798995 | 122 | 76 | 92 | 2 | 33 | 398 | 227 | 345 | MCA9519868.1 metallophosphoesterase [Myxococcales bacterium] | diamond | 732 | 81.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29713572 | 29713572 | PRJNA559720_P_NODE_15570_length_244_cov_0.900585_g15431_i0 | PRJNA559720 | 15570 | 244 | 0.900585 | 2.1974274 | Myxococcia | 32015 | Bacteria | Bacteria | 146 | 1.6199999999999996e-40 | NR | HEY8072454.1 | 1971228 | g15431 | i0 | 88.9 | 10.9549180327869 | 81 | 9 | 99.6 | 0 | 2 | 244 | 64 | 144 | HEY8072454.1 LON peptidase substrate-binding domain-containing protein [Labilithrix sp.] | diamond | 2673 | 147 | 0.993197278911565 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 32355484 | 32355484 | PRJNA559720_P_NODE_16039_length_242_cov_0.911243_g15900_i0 | PRJNA559720 | 16039 | 242 | 0.911243 | 2.20520806 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 72.4 | 1.29e-12 | NR | HRG98537.1 | 2268199 | g15900 | i0 | 46.3 | 0.991735537190083 | 80 | 43 | 99.2 | 0 | 242 | 3 | 474 | 553 | HRG98537.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 240 | 72.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae 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);;