contig_metadata
7 rows where bioproject = "PRJNA1050291", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2726760 | 2726760 | PRJNA1050291_P_NODE_8283_length_449_cov_1.492021_g7392_i0 | PRJNA1050291 | 8283 | 449 | 1.492021 | 6.69917429 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 52.8 | 0.043 | NTclustered | gi|816953346|gb|CP011125.1| | 927083 | g7392 | i0 | 100 | 0.0623608017817372 | 28 | 0 | 6 | 0 | 414 | 441 | 1830902 | 1830875 | Sandaracinus amylolyticus strain DSM 53668, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 10379324 | 10379324 | PRJNA1050291_P_NODE_21249_length_241_cov_2.672619_g20358_i0 | PRJNA1050291 | 21249 | 241 | 2.672619 | 6.44101179 | Bacteria | 2 | Bacteria | Bacteria | 126 | 1.3e-32 | NR | MFK7931048.1 | 2818507 | g20358 | i0 | 72.2 | 5.87551867219917 | 79 | 22 | 98.3 | 0 | 3 | 239 | 313 | 391 | MFK7931048.1 hypothetical protein [Myxococcota bacterium] | diamond | 1416 | 127 | 0.992125984251969 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 17588913 | 17588913 | PRJNA1050291_P_NODE_6354_length_565_cov_1.083333_g5463_i0 | PRJNA1050291 | 6354 | 565 | 1.083333 | 6.12083145 | Myxococcus | 32 | Bacteria | Bacteria | 56.5 | 0.004 | NTclustered | gi|2869653495|gb|CP175551.1| | 33 | g5463 | i0 | 100 | 0.106194690265487 | 30 | 0 | 5 | 0 | 328 | 357 | 6439638 | 6439667 | Myxococcus fulvus strain KYC1117 chromosome, complete genome | blastn | 60 | 56.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 26837449 | 26837449 | PRJNA1050291_P_NODE_11501_length_346_cov_2.146520_g10610_i0 | PRJNA1050291 | 11501 | 346 | 2.14652 | 7.4269592 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 184 | 5.18e-57 | NR | NOJ99365.1 | 184914 | g10610 | i0 | 77.4 | 2.99132947976879 | 115 | 26 | 99.7 | 0 | 346 | 2 | 31 | 145 | NOJ99365.1 glycosyltransferase [Corallococcus coralloides] | diamond | 1035 | 185 | 0.994594594594595 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus coralloides | ||
| 27058826 | 27058826 | PRJNA1050291_P_NODE_4482_length_775_cov_3.649573_g3597_i0 | PRJNA1050291 | 4482 | 775 | 3.649573 | 28.28419075 | Archangium | 47 | Bacteria | Bacteria | 152 | 1.11e-40 | NR | MCC7384637.1 | 2026735 | g3597 | i0 | 39.1 | 1.95096774193548 | 258 | 136 | 96.4 | 7 | 28 | 774 | 56 | 301 | MCC7384637.1 DNA/RNA non-specific endonuclease [Deltaproteobacteria bacterium] | diamond | 1512 | 152 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32461723 | 32461723 | PRJNA1050291_P_NODE_9019_length_419_cov_2.624277_g8128_i0 | PRJNA1050291 | 9019 | 419 | 2.624277 | 10.99572063 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 2.85e-5 | NR | MCB9476354.1 | 2026735 | g8128 | i0 | 52.2 | 0.658711217183771 | 46 | 22 | 32.9 | 0 | 15 | 152 | 257 | 302 | MCB9476354.1 ankyrin repeat domain-containing protein [Deltaproteobacteria bacterium] | diamond | 276 | 53.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32588285 | 32588285 | PRJNA1050291_P_NODE_10419_length_374_cov_1.677741_g9528_i0 | PRJNA1050291 | 10419 | 374 | 1.677741 | 6.27475134 | Bacteria | 2 | Bacteria | Bacteria | 155 | 2.5499999999999994e-42 | NR | MCH8889566.1 | 2026763 | g9528 | i0 | 54.8 | 4.94919786096257 | 124 | 56 | 99.5 | 0 | 372 | 1 | 220 | 343 | MCH8889566.1 phage terminase large subunit [Myxococcales bacterium] | diamond | 1851 | 155 | 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);;