contig_metadata
9 rows where bioproject = "PRJNA399133", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5517001 | 5517001 | PRJNA399133_P_NODE_4385_length_242_cov_1.821256_g4297_i0 | PRJNA399133 | 4385 | 242 | 1.821256 | 4.40743952 | Pendulispora rubella | 2741070 | Bacteria | Bacteria | 147 | 9.72e-31 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g4297 | i0 | 96.591 | 11.2851239669421 | 88 | 3 | 67 | 0 | 1 | 88 | 7289172 | 7289259 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 2731 | 147 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 7458741 | 7458741 | PRJNA399133_P_NODE_12366_length_150_cov_3.426087_g12278_i0 | PRJNA399133 | 12366 | 150 | 3.426087 | 5.1391305 | Pendulispora | 3375062 | Bacteria | Bacteria | 150 | 4.2099999999999997e-32 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g12278 | i0 | 84.667 | 52.1866666666667 | 150 | 23 | 100 | 0 | 1 | 150 | 9852998 | 9852849 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 7828 | 150 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 12559523 | 12559523 | PRJNA399133_P_NODE_2710_length_303_cov_2.470149_g2622_i0 | PRJNA399133 | 2710 | 303 | 2.470149 | 7.48455147 | Myxococcia | 32015 | Bacteria | Bacteria | 381 | 3.169999999999999e-101 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g2622 | i0 | 89.439 | 124.415841584158 | 303 | 31 | 100 | 1 | 1 | 303 | 7090163 | 7090464 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 37698 | 383 | 0.994778067885117 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 19539024 | 19539024 | PRJNA399133_P_NODE_1636_length_392_cov_3.176471_g1550_i0 | PRJNA399133 | 1636 | 392 | 3.176471 | 12.45176632 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 355 | 2.55e-93 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g1550 | i0 | 85.387 | 267.913265306122 | 349 | 44 | 88 | 6 | 46 | 391 | 7409356 | 7409012 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 105022 | 355 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 24032569 | 24032569 | PRJNA399133_P_NODE_11759_length_154_cov_2.016807_g11671_i0 | PRJNA399133 | 11759 | 154 | 2.016807 | 3.10588278 | Myxococcia | 32015 | Bacteria | Bacteria | 224 | 2.5299999999999994e-54 | NTclustered | gi|1127377833|gb|CP016908.1| | 1882918 | g11671 | i0 | 92.857 | 136.467532467532 | 154 | 11 | 100 | 0 | 1 | 154 | 1551548 | 1551395 | Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome | blastn | 21016 | 224 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Pajaroellobacter | Pajaroellobacter abortibovis | |||
| 27534527 | 27534527 | PRJNA399133_P_NODE_5243_length_229_cov_1.773196_g5155_i0 | PRJNA399133 | 5243 | 229 | 1.773196 | 4.06061884 | Bacteria | 2 | Bacteria | Bacteria | 52 | 1.7e-5 | NR | MCA9503384.1 | 2026763 | g5155 | i0 | 95.8 | 1.25764192139738 | 24 | 1 | 31.4 | 0 | 73 | 2 | 357 | 380 | MCA9503384.1 NAD(P)/FAD-dependent oxidoreductase [Myxococcales bacterium] | diamond | 288 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28717693 | 28717693 | PRJNA399133_P_NODE_7087_length_197_cov_1.666667_g6999_i0 | PRJNA399133 | 7087 | 197 | 1.666667 | 3.28333399 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 67.8 | 1.5e-11 | NR | MDO9016594.1 | 2026763 | g6999 | i0 | 79.5 | 1.79695431472081 | 39 | 8 | 59.4 | 0 | 192 | 76 | 167 | 205 | MDO9016594.1 hypothetical protein [Myxococcales bacterium] | diamond | 354 | 67.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31040268 | 31040268 | PRJNA399133_P_NODE_8455_length_180_cov_2.193103_g8367_i0 | PRJNA399133 | 8455 | 180 | 2.193103 | 3.9475854 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 45.4 | 0.00187 | NR | MFT3707833.1 | 1872627 | g8367 | i0 | 55.6 | 2.46666666666667 | 54 | 22 | 90 | 1 | 162 | 1 | 847 | 898 | MFT3707833.1 putative Ig domain-containing protein [Archangium sp.] | diamond | 444 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 32510159 | 32510159 | PRJNA399133_P_NODE_2699_length_304_cov_1.732342_g2611_i0 | PRJNA399133 | 2699 | 304 | 1.732342 | 5.26631968 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 88.6 | 5.98e-18 | NR | MDQ2644660.1 | 2818507 | g2611 | i0 | 58.8 | 0.671052631578947 | 68 | 28 | 67.1 | 0 | 12 | 215 | 709 | 776 | MDQ2644660.1 S8 family peptidase [Myxococcota bacterium] | diamond | 204 | 88.6 | 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);;