contig_metadata
9 rows where bioproject = "PRJNA177642", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4192605 | 4192605 | PRJNA177642_P_NODE_17604_length_166_cov_1.051095_g16379_i0 | PRJNA177642 | 17604 | 166 | 1.051095 | 1.7448177 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 161 | 2.21e-35 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g16379 | i0 | 85.093 | 0.969879518072289 | 161 | 20 | 96 | 4 | 5 | 163 | 8019866 | 8020024 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 161 | 161 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 5468705 | 5468705 | PRJNA177642_P_NODE_10685_length_341_cov_1.551282_g9461_i0 | PRJNA177642 | 10685 | 341 | 1.551282 | 5.28987162 | Myxococcus sp. SDU36 | 2831967 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2513984958|gb|CP077414.1| | 2831967 | g9461 | i0 | 100 | 0.0879765395894428 | 30 | 0 | 9 | 0 | 3 | 32 | 6741051 | 6741022 | Myxococcus sp. SDU36 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus sp. SDU36 | ||
| 15082694 | 15082694 | PRJNA177642_P_NODE_5512_length_605_cov_10.072917_g4435_i0 | PRJNA177642 | 5512 | 605 | 10.072917 | 60.94114785 | Myxococcia | 32015 | Bacteria | Bacteria | 610 | 7.879999999999996e-170 | NTclustered | gi|1566495190|gb|CP012670.1| | 56 | g4435 | i0 | 85.082 | 117.170247933884 | 610 | 78 | 99 | 11 | 4 | 603 | 4848785 | 4848179 | Sorangium cellulosum strain So ceGT47 chromosome, complete genome | blastn | 70888 | 614 | 0.993485342019544 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 22731917 | 22731917 | PRJNA177642_P_NODE_4598_length_683_cov_17.058104_g3589_i0 | PRJNA177642 | 4598 | 683 | 17.058104 | 116.50685032 | Myxococcia | 32015 | Bacteria | Bacteria | 924 | 0 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g3589 | i0 | 91.014 | 190.617862371889 | 690 | 54 | 99 | 5 | 1 | 682 | 3942887 | 3942198 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 130192 | 924 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 26978988 | 26978988 | PRJNA177642_P_NODE_17642_length_166_cov_1.051095_g16417_i0 | PRJNA177642 | 17642 | 166 | 1.051095 | 1.7448177 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 84.3 | 2.74e-17 | NR | NLY95282.1 | 2026763 | g16417 | i0 | 76.4 | 0.993975903614458 | 55 | 13 | 99.4 | 0 | 165 | 1 | 39 | 93 | NLY95282.1 MCE family protein [Myxococcales bacterium] | diamond | 165 | 84.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27105356 | 27105356 | PRJNA177642_P_NODE_13102_length_276_cov_3.230769_g11877_i0 | PRJNA177642 | 13102 | 276 | 3.230769 | 8.91692244 | Hyalangium sp. | 2028555 | Bacteria | Bacteria | 44.3 | 0.0122 | NR | HVG59815.1 | 2028555 | g11877 | i0 | 36.3 | 0.869565217391304 | 80 | 50 | 85.9 | 1 | 242 | 6 | 95 | 174 | HVG59815.1 class I SAM-dependent methyltransferase [Hyalangium sp.] | diamond | 240 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Hyalangium | Hyalangium sp. | ||
| 29396966 | 29396966 | PRJNA177642_P_NODE_17229_length_168_cov_1.014388_g16004_i0 | PRJNA177642 | 17229 | 168 | 1.014388 | 1.70417184 | Polyangium | 55 | Bacteria | Bacteria | 66.2 | 6.77e-11 | NR | WP_136930181.1 | 889272 | g16004 | i0 | 61.1 | 2.91071428571429 | 54 | 20 | 96.4 | 1 | 166 | 5 | 483 | 535 | WP_136930181.1 cytochrome C peroxidase [Polyangium fumosum] | diamond | 489 | 66.6 | 0.993993993993994 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium fumosum | |||
| 30168532 | 30168532 | PRJNA177642_P_NODE_9812_length_362_cov_82.777778_g8591_i0 | PRJNA177642 | 9812 | 362 | 82.777778 | 299.65555636 | Corallococcus sp. AB | 1898750 | Bacteria | Bacteria | 65.9 | 1.18e-11 | NR | WP_147477341.1 | 2316718 | g8591 | i0 | 68.9 | 0.37292817679558 | 45 | 14 | 37.3 | 0 | 353 | 219 | 15 | 59 | WP_147477341.1 hypothetical protein [Corallococcus sp. AB038B] | diamond | 135 | 65.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus sp. AB038B | ||
| 31829938 | 31829938 | PRJNA177642_P_NODE_16457_length_172_cov_1.006993_g15232_i0 | PRJNA177642 | 16457 | 172 | 1.006993 | 1.73202796 | Pyxidicoccus | 224458 | Bacteria | Bacteria | 68.6 | 8.7e-12 | NR | MDQ3265555.1 | 2818507 | g15232 | i0 | 71.9 | 2.96511627906977 | 57 | 15 | 99.4 | 1 | 2 | 172 | 104 | 159 | MDQ3265555.1 NAD(P)H-quinone oxidoreductase [Myxococcota bacterium] | diamond | 510 | 68.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);;