contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161553 | 161553 | PRJNA1022139_P_NODE_17181_length_333_cov_2.688462_g17076_i0 | PRJNA1022139 | 17181 | 333 | 2.688462 | 8.95257846 | Myxococcus stipitatus | 83455 | Bacteria | Bacteria | 300 | 1.02e-76 | NTclustered | gi|2722781719|gb|CP102770.1| | 83455 | g17076 | i0 | 83.082 | 39.987987987988 | 331 | 54 | 99 | 2 | 4 | 333 | 4593907 | 4593578 | Myxococcus stipitatus strain YRE12 chromosome, complete genome | blastn | 13316 | 300 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus stipitatus | ||
| 1003635 | 1003635 | PRJNA1022139_P_NODE_41281_length_243_cov_0.905882_g41176_i0 | PRJNA1022139 | 41281 | 243 | 0.905882 | 2.20129326 | Myxococcaceae | 31 | Bacteria | Bacteria | 246 | 9.36e-61 | NTclustered | gi|89142973|emb|AM183518.1| | 35 | g41176 | i0 | 85.532 | 120.80658436214 | 235 | 34 | 97 | 0 | 1 | 235 | 75 | 309 | Myxococcus macrosporus partial fusA gene for translation elongation factor G, strain DSM 14697T | blastn | 29356 | 246 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus macrosporus | ||
| 2712174 | 2712174 | PRJNA1022139_P_NODE_43023_length_241_cov_0.916667_g42918_i0 | PRJNA1022139 | 43023 | 241 | 0.916667 | 2.20916747 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|1566495190|gb|CP012670.1| | 56 | g42918 | i0 | 88 | 0.20746887966805 | 50 | 3 | 21 | 2 | 95 | 144 | 6958259 | 6958213 | Sorangium cellulosum strain So ceGT47 chromosome, complete genome | blastn | 50 | 56.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 3988265 | 3988265 | PRJNA1022139_P_NODE_32024_length_259_cov_1.408602_g31919_i0 | PRJNA1022139 | 32024 | 259 | 1.408602 | 3.64827918 | Phaselicystis flava | 525924 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|1493633220|gb|MH908922.1| | 525924 | g31919 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 140 | 167 | 76647 | 76620 | Phaselicystis flava strain MSr9315 t3pks biosynthetic gene cluster, complete sequence | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Phaselicystidaceae | Phaselicystis | Phaselicystis flava | |||
| 5264664 | 5264664 | PRJNA1022139_P_NODE_4625_length_597_cov_3.919847_g4521_i0 | PRJNA1022139 | 4625 | 597 | 3.919847 | 23.40148659 | Nannocystis punicea | 2995304 | Bacteria | Bacteria | 357 | 1.12e-93 | NTclustered | gi|2415023655|gb|CP114040.1| | 2995304 | g4521 | i0 | 82.367 | 70.2445561139028 | 431 | 56 | 71 | 14 | 13 | 438 | 5377565 | 5377150 | Nannocystis poenicansa strain FL3 chromosome, complete genome | blastn | 41936 | 357 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis punicea | |||
| 11640109 | 11640109 | PRJNA1022139_P_NODE_13210_length_373_cov_1.016667_g13105_i0 | PRJNA1022139 | 13210 | 373 | 1.016667 | 3.79216791 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 52.8 | 0.035 | NTclustered | gi|2579665545|gb|CP043492.1| | 43 | g13105 | i0 | 100 | 0.0750670241286863 | 28 | 0 | 8 | 0 | 6 | 33 | 5390363 | 5390336 | Cystobacter fuscus strain Cbf 8 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 20562829 | 20562829 | PRJNA1022139_P_NODE_29917_length_267_cov_1.587629_g29812_i0 | PRJNA1022139 | 29917 | 267 | 1.587629 | 4.23896943 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g29812 | i0 | 100 | 0.108614232209738 | 29 | 0 | 11 | 0 | 211 | 239 | 12840856 | 12840884 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 23113848 | 23113848 | PRJNA1022139_P_NODE_16939_length_335_cov_2.278626_g16834_i0 | PRJNA1022139 | 16939 | 335 | 2.278626 | 7.6333971 | Chondromyces crocatus | 52 | Bacteria | Bacteria | 52.8 | 0.032 | NTclustered | gi|908353314|gb|CP012159.1| | 52 | g16834 | i0 | 100 | 0.0835820895522388 | 28 | 0 | 8 | 0 | 279 | 306 | 6477854 | 6477881 | Chondromyces crocatus strain Cm c5, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 23955908 | 23955908 | PRJNA1022139_P_NODE_3379_length_683_cov_4.300000_g3279_i0 | PRJNA1022139 | 3379 | 683 | 4.3 | 29.369 | Myxococcaceae | 31 | Bacteria | Bacteria | 75 | 1.45e-8 | NTclustered | gi|2318731907|gb|CP104804.1| | 34 | g3279 | i0 | 93.878 | 1.59590043923865 | 49 | 3 | 7 | 0 | 579 | 627 | 3114435 | 3114483 | Myxococcus xanthus strain DK1050 chromosome | blastn | 1090 | 75 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus |
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);;