contig_metadata
12 rows where bioproject = "PRJNA631796" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2427304 | 2427304 | PRJNA631796_P_NODE_9842_length_219_cov_2.626582_g9564_i0 | PRJNA631796 | 9842 | 219 | 2.626582 | 5.75221458 | Sorangium | 39643 | Bacteria | Bacteria | 322 | 1.34e-83 | NTclustered | gi|1566478966|gb|CP012672.1| | 56 | g9564 | i0 | 94.712 | 129.913242009132 | 208 | 10 | 95 | 1 | 8 | 215 | 3690717 | 3690923 | Sorangium cellulosum strain So ce836 chromosome, complete genome | blastn | 28451 | 322 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 8256578 | 8256578 | PRJNA631796_P_NODE_7127_length_255_cov_2.242268_g6849_i0 | PRJNA631796 | 7127 | 255 | 2.242268 | 5.7177834 | Myxococcus stipitatus | 83455 | Bacteria | Bacteria | 438 | 1.52e-118 | NTclustered | gi|545790943|gb|KF270706.1| | 83455 | g6849 | i0 | 97.647 | 224.294117647059 | 255 | 6 | 100 | 0 | 1 | 255 | 131 | 385 | Myxococcus stipitatus strain Mxs33 23S ribosomal RNA gene, partial sequence | blastn | 57195 | 438 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus stipitatus | ||
| 8804961 | 8804961 | PRJNA631796_P_NODE_14127_length_182_cov_4.942149_g13849_i0 | PRJNA631796 | 14127 | 182 | 4.942149 | 8.99471118 | Pendulispora | 3375062 | Bacteria | Bacteria | 287 | 3.9e-73 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g13849 | i0 | 95.055 | 291.818681318681 | 182 | 9 | 100 | 0 | 1 | 182 | 7287298 | 7287117 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 53111 | 287 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 11355471 | 11355471 | PRJNA631796_S_NODE_134769_length_183_cov_7.647541_g134602_i0 | PRJNA631796 | 134769 | 183 | 7.647541 | 13.99500003 | root | 1 | Root_unresolved | Root_unresolved | 231 | 1.87e-56 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g134602 | i0 | 89.73 | 190.55737704918 | 185 | 14 | 100 | 5 | 1 | 183 | 3450655 | 3450836 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 34872 | 233 | 0.991416309012876 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 13905932 | 13905932 | PRJNA631796_P_NODE_14231_length_176_cov_7.982609_g13953_i0 | PRJNA631796 | 14231 | 176 | 7.982609 | 14.04939184 | Polyangiales | 3031712 | Bacteria | Bacteria | 224 | 2.9699999999999996e-54 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g13953 | i0 | 89.773 | 193.772727272727 | 176 | 17 | 100 | 1 | 1 | 176 | 3943682 | 3943508 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 34104 | 226 | 0.991150442477876 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 15180406 | 15180406 | PRJNA631796_P_NODE_152_length_1714_cov_32.822142_g82_i0 | PRJNA631796 | 152 | 1714 | 32.822142 | 562.57151388 | Pendulispora | 3375062 | Bacteria | Bacteria | 2268 | 0 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g82 | i0 | 90.598 | 178.389148191365 | 1723 | 145 | 99 | 14 | 1 | 1712 | 9852419 | 9854135 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 305759 | 2268 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 17729910 | 17729910 | PRJNA631796_P_NODE_5714_length_288_cov_1.621145_g5436_i0 | PRJNA631796 | 5714 | 288 | 1.621145 | 4.6688976 | Myxococcaceae | 31 | Bacteria | Bacteria | 237 | 6.85e-58 | NTclustered | gi|545790947|gb|KF270710.1| | 34 | g5436 | i0 | 81.944 | 215.913194444444 | 288 | 45 | 99 | 6 | 3 | 287 | 51 | 334 | Myxococcus xanthus strain Mxx132 23S ribosomal RNA gene, partial sequence | blastn | 62183 | 237 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus | ||
| 18455522 | 18455522 | PRJNA631796_S_NODE_215_length_1126_cov_11.692019_g137_i0 | PRJNA631796 | 215 | 1126 | 11.692019 | 131.65213394 | Chondromyces crocatus | 52 | Bacteria | Bacteria | 1465 | 0 | NTclustered | gi|169977285|emb|AM946600.1| | 52 | g137 | i0 | 90.115 | 145.888987566607 | 1133 | 104 | 100 | 7 | 1 | 1126 | 1418 | 2549 | Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 | blastn | 164271 | 1465 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 21005823 | 21005823 | PRJNA631796_P_NODE_8237_length_237_cov_1.568182_g7959_i0 | PRJNA631796 | 8237 | 237 | 1.568182 | 3.71659134 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 263 | 9.03e-66 | NTclustered | gi|816953346|gb|CP011125.1| | 927083 | g7959 | i0 | 91.979 | 23.949367088607602 | 187 | 15 | 79 | 0 | 1 | 187 | 8616168 | 8616354 | Sandaracinus amylolyticus strain DSM 53668, complete genome | blastn | 5676 | 263 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 27080883 | 27080883 | PRJNA631796_P_NODE_12662_length_203_cov_0.901408_g12384_i0 | PRJNA631796 | 12662 | 203 | 0.901408 | 1.82985824 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42 | 0.041 | NR | NJK31080.1 | 2026735 | g12384 | i0 | 34.8 | 1.01970443349754 | 69 | 37 | 90.1 | 1 | 2 | 184 | 173 | 241 | NJK31080.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 207 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28533817 | 28533817 | PRJNA631796_P_NODE_6267_length_274_cov_1.201878_g5989_i0 | PRJNA631796 | 6267 | 274 | 1.201878 | 3.29314572 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 67.8 | 8.19e-11 | NR | HEY0715797.1 | 3058050 | g5989 | i0 | 38.7 | 1.82846715328467 | 93 | 45 | 99.6 | 2 | 273 | 1 | 290 | 372 | HEY0715797.1 fibro-slime domain-containing protein [Polyangia bacterium] | diamond | 501 | 67.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 30617918 | 30617918 | PRJNA631796_P_NODE_10013_length_218_cov_0.815287_g9735_i0 | PRJNA631796 | 10013 | 218 | 0.815287 | 1.77732566 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 42 | 0.0456 | NR | MEM6955040.1 | 2818507 | g9735 | i0 | 41.4 | 1.59633027522936 | 58 | 29 | 74.3 | 2 | 184 | 23 | 6 | 62 | MEM6955040.1 UMP kinase [Myxococcota bacterium] | diamond | 348 | 42 | 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);;