contig_metadata
8 rows where bioproject = "PRJNA1034994", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6546256 | 6546256 | PRJNA1034994_P_NODE_10546_length_231_cov_2.550633_g10462_i0 | PRJNA1034994 | 10546 | 231 | 2.550633 | 5.89196223 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 353 | 5.05e-93 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g10462 | i0 | 94.397 | 165.051948051948 | 232 | 10 | 100 | 3 | 1 | 231 | 9037596 | 9037367 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 38127 | 353 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 7385293 | 7385293 | PRJNA1034994_P_NODE_2126_length_351_cov_0.953237_g2042_i0 | PRJNA1034994 | 2126 | 351 | 0.953237 | 3.34586187 | Pendulispora | 3375062 | Bacteria | Bacteria | 479 | 1.2799999999999996e-130 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g2042 | i0 | 91.243 | 137.34188034188 | 354 | 28 | 100 | 2 | 1 | 351 | 7289331 | 7289684 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 48207 | 479 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 10371455 | 10371455 | PRJNA1034994_P_NODE_10309_length_241_cov_0.916667_g10225_i0 | PRJNA1034994 | 10309 | 241 | 0.916667 | 2.20916747 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 158 | 4.47e-34 | NTclustered | gi|1243034522|gb|CP022098.1| | 43 | g10225 | i0 | 85.161 | 0.643153526970954 | 155 | 21 | 64 | 2 | 86 | 239 | 5286735 | 5286888 | Cystobacter fuscus strain DSM 52655 chromosome, complete genome | blastn | 155 | 158 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 28140869 | 28140869 | PRJNA1034994_P_NODE_5765_length_260_cov_1.647059_g5681_i0 | PRJNA1034994 | 5765 | 260 | 1.647059 | 4.2823534 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 84.7 | 1.3e-18 | NR | MEZ0310588.1 | 2818507 | g5681 | i0 | 91.1 | 1.03846153846154 | 45 | 4 | 51.9 | 0 | 124 | 258 | 1 | 45 | MEZ0310588.1 PilZ domain-containing protein [Myxococcota bacterium] | diamond | 270 | 84.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29877331 | 29877331 | PRJNA1034994_P_NODE_5691_length_261_cov_1.393617_g5607_i0 | PRJNA1034994 | 5691 | 261 | 1.393617 | 3.63734037 | Myxococcus sp. | 1929279 | Bacteria | Bacteria | 40.4 | 0.0418 | NR | MBE2251368.1 | 1929279 | g5607 | i0 | 33.9 | 0.64367816091954 | 56 | 36 | 64.4 | 1 | 215 | 48 | 1 | 55 | MBE2251368.1 hypothetical protein [Myxococcus sp.] | diamond | 168 | 40.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus sp. | ||
| 30224663 | 30224663 | PRJNA1034994_P_NODE_5832_length_259_cov_2.252688_g5748_i0 | PRJNA1034994 | 5832 | 259 | 2.252688 | 5.83446192 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.9 | 0.0147 | NR | MBN1662851.1 | 2026735 | g5748 | i0 | 32.9 | 0.94980694980695 | 82 | 49 | 92.7 | 3 | 257 | 18 | 3 | 80 | MBN1662851.1 class I SAM-dependent methyltransferase [Deltaproteobacteria bacterium] | diamond | 246 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30730227 | 30730227 | PRJNA1034994_P_NODE_9394_length_243_cov_0.905882_g9310_i0 | PRJNA1034994 | 9394 | 243 | 0.905882 | 2.20129326 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 50.4 | 7.19e-5 | NR | MCA9518135.1 | 2026763 | g9310 | i0 | 44.6 | 0.691358024691358 | 56 | 31 | 69.1 | 0 | 202 | 35 | 512 | 567 | MCA9518135.1 cation:proton antiporter [Myxococcales bacterium] | diamond | 168 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31267467 | 31267467 | PRJNA1034994_P_NODE_8855_length_245_cov_0.895349_g8771_i0 | PRJNA1034994 | 8855 | 245 | 0.895349 | 2.19360505 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 53.5 | 5.91e-6 | NR | MBK7395401.1 | 2026763 | g8771 | i0 | 41.6 | 0.942857142857143 | 77 | 45 | 94.3 | 0 | 4 | 234 | 325 | 401 | MBK7395401.1 hypothetical protein [Myxococcales bacterium] | diamond | 231 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales 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);;