contig_metadata
9 rows where bioproject = "PRJNA1145997" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3583859 | 3583859 | PRJNA1145997_P_NODE_27223_length_449_cov_4.893617_g24606_i0 | PRJNA1145997 | 27223 | 449 | 4.893617 | 21.97234033 | Myxococcus | 32 | Bacteria | Bacteria | 52.8 | 0.043 | NTclustered | gi|2869653495|gb|CP175551.1| | 33 | g24606 | i0 | 92.308 | 0.173719376391982 | 39 | 0 | 8 | 2 | 286 | 321 | 754130 | 754092 | Myxococcus fulvus strain KYC1117 chromosome, complete genome | blastn | 78 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 9217691 | 9217691 | PRJNA1145997_P_NODE_48568_length_243_cov_0.917647_g45949_i0 | PRJNA1145997 | 48568 | 243 | 0.917647 | 2.22988221 | Pyxidicoccus parkwayensis | 2813578 | Bacteria | Bacteria | 239 | 1.57e-58 | NTclustered | gi|1998505907|gb|CP071090.1| | 2813578 | g45949 | i0 | 84.426 | 178.094650205761 | 244 | 36 | 100 | 2 | 1 | 243 | 9485973 | 9485731 | Pyxidicoccus parkwaysis strain SCPEA02 chromosome | blastn | 43277 | 239 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pyxidicoccus | Pyxidicoccus parkwayensis | ||
| 18141263 | 18141263 | PRJNA1145997_P_NODE_40955_length_260_cov_2.807487_g38336_i0 | PRJNA1145997 | 40955 | 260 | 2.807487 | 7.2994662 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 241 | 4.71e-59 | NTclustered | gi|816953346|gb|CP011125.1| | 927083 | g38336 | i0 | 89.894 | 2.67307692307692 | 188 | 17 | 72 | 2 | 47 | 233 | 5810363 | 5810549 | Sandaracinus amylolyticus strain DSM 53668, complete genome | blastn | 695 | 241 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 21966563 | 21966563 | PRJNA1145997_P_NODE_50758_length_225_cov_5.605263_g48139_i0 | PRJNA1145997 | 50758 | 225 | 5.605263 | 12.61184175 | Polyangium aurulentum | 2567896 | Bacteria | Bacteria | 161 | 3.1899999999999996e-35 | NTclustered | gi|2235996827|gb|CP079217.1| | 2567896 | g48139 | i0 | 93.519 | 56.1333333333333 | 108 | 7 | 48 | 0 | 96 | 203 | 10603721 | 10603828 | Polyangium aurulentum strain SDU3-1 chromosome, complete genome | blastn | 12630 | 161 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum | |||
| 28523427 | 28523427 | PRJNA1145997_P_NODE_47867_length_244_cov_0.912281_g45248_i0 | PRJNA1145997 | 47867 | 244 | 0.912281 | 2.22596564 | Nannocystis sp. | 1962667 | Bacteria | Bacteria | 94.7 | 5.46e-21 | NR | HEY0137940.1 | 1962667 | g45248 | i0 | 59.5 | 1.85655737704918 | 79 | 32 | 97.1 | 0 | 5 | 241 | 89 | 167 | HEY0137940.1 ADYC domain-containing protein [Nannocystis sp.] | diamond | 453 | 94.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis sp. | |||
| 28544033 | 28544033 | PRJNA1145997_P_NODE_27947_length_430_cov_4.294118_g25330_i0 | PRJNA1145997 | 27947 | 430 | 4.294118 | 18.464707400000002 | Myxococcia | 32015 | Bacteria | Bacteria | 91.7 | 6.41e-19 | NR | MCL4225871.1 | 2026763 | g25330 | i0 | 50 | 2.16279069767442 | 102 | 50 | 71.2 | 1 | 21 | 326 | 218 | 318 | MCL4225871.1 polysaccharide deacetylase family protein [Myxococcales bacterium] | diamond | 930 | 91.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28901998 | 28901998 | PRJNA1145997_P_NODE_37928_length_281_cov_5.649038_g35309_i0 | PRJNA1145997 | 37928 | 281 | 5.649038 | 15.87379678 | Stigmatella aurantiaca | 41 | Bacteria | Bacteria | 43.5 | 0.0238 | NR | WP_002611826.1 | 41 | g35309 | i0 | 34 | 0.565836298932384 | 53 | 35 | 56.6 | 0 | 272 | 114 | 91 | 143 | WP_002611826.1 cupin domain-containing protein [Stigmatella aurantiaca] | diamond | 159 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 30797176 | 30797176 | PRJNA1145997_P_NODE_45834_length_247_cov_0.896552_g43215_i0 | PRJNA1145997 | 45834 | 247 | 0.896552 | 2.21448344 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 59.7 | 3.99e-8 | NR | MDB5214991.1 | 2484252 | g43215 | i0 | 86.2 | 0.692307692307692 | 29 | 4 | 35.2 | 0 | 2 | 88 | 357 | 385 | MDB5214991.1 Radical domain heme biosynthesis protein [Myxococcaceae bacterium] | diamond | 171 | 59.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 31734405 | 31734405 | PRJNA1145997_P_NODE_44217_length_250_cov_0.881356_g41598_i0 | PRJNA1145997 | 44217 | 250 | 0.881356 | 2.20339 | Bacteria | 2 | Bacteria | Bacteria | 49.3 | 1.98e-4 | NR | MCB9646749.1 | 2026735 | g41598 | i0 | 48 | 1.656 | 50 | 26 | 60 | 0 | 99 | 248 | 354 | 403 | MCB9646749.1 protein kinase [Deltaproteobacteria bacterium] | diamond | 414 | 49.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria 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);;