contig_metadata
16 rows where bioproject = "PRJNA382558", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405042 | 405042 | PRJNA382558_S_NODE_9081_length_178_cov_4.219858_g9077_i0 | PRJNA382558 | 9081 | 178 | 4.219858 | 7.51134724 | Archangium gephyra | 48 | Bacteria | Bacteria | 82.4 | 1.92e-11 | NTclustered | gi|827418478|gb|CP011509.1| | 48 | g9077 | i0 | 94.34 | 0.297752808988764 | 53 | 3 | 30 | 0 | 79 | 131 | 8935760 | 8935708 | Archangium gephyra strain DSM 2261, complete genome | blastn | 53 | 82.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 1679667 | 1679667 | PRJNA382558_S_NODE_14202_length_155_cov_7.618644_g14198_i0 | PRJNA382558 | 14202 | 155 | 7.618644 | 11.8088982 | Stigmatella aurantiaca | 41 | Bacteria | Bacteria | 95.3 | 2.09e-15 | NTclustered | gi|309390350|gb|CP002271.1| | 378806 | g14198 | i0 | 91.304 | 17.3161290322581 | 69 | 6 | 45 | 0 | 1 | 69 | 6723805 | 6723873 | Stigmatella aurantiaca DW4/3-1, complete genome | blastn | 2684 | 95.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 9332990 | 9332990 | PRJNA382558_S_NODE_3888_length_226_cov_7.835979_g3884_i0 | PRJNA382558 | 3888 | 226 | 7.835979 | 17.70931254 | Corallococcus coralloides | 184914 | Bacteria | Bacteria | 139 | 1.5e-28 | NTclustered | gi|2851136330|gb|CP172866.1| | 184914 | g3884 | i0 | 78.319 | 69.9247787610619 | 226 | 41 | 98 | 7 | 4 | 225 | 9279107 | 9278886 | Corallococcus coralloides strain KYC2213 chromosome, complete genome | blastn | 15803 | 139 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus coralloides | ||
| 10003806 | 10003806 | PRJNA382558_S_NODE_13968_length_156_cov_6.210084_g13964_i0 | PRJNA382558 | 13968 | 156 | 6.210084 | 9.68773104 | Myxococcus | 32 | Bacteria | Bacteria | 171 | 3.399999999999999e-38 | NTclustered | gi|2318731907|gb|CP104804.1| | 34 | g13964 | i0 | 86.928 | 79.9871794871795 | 153 | 18 | 97 | 2 | 1 | 152 | 8538102 | 8537951 | Myxococcus xanthus strain DK1050 chromosome | blastn | 12478 | 171 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus | ||
| 10003865 | 10003865 | PRJNA382558_S_NODE_8488_length_181_cov_8.666667_g8484_i0 | PRJNA382558 | 8488 | 181 | 8.666667 | 15.68666727 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 89.8 | 1.17e-13 | NTclustered | gi|161158851|emb|AM746676.1| | 448385 | g8484 | i0 | 82.407 | 9.02762430939227 | 108 | 13 | 58 | 5 | 76 | 180 | 1570140 | 1570244 | Sorangium cellulosum 'So ce 56' complete genome | blastn | 1634 | 89.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 15707635 | 15707635 | PRJNA382558_S_NODE_2013_length_269_cov_5.150862_g2009_i0 | PRJNA382558 | 2013 | 269 | 5.150862 | 13.85581878 | Myxococcus xanthus | 34 | Bacteria | Bacteria | 302 | 2.22e-77 | NTclustered | gi|1957989826|gb|CP068048.1| | 34 | g2009 | i0 | 88.934 | 25.4684014869888 | 244 | 27 | 91 | 0 | 26 | 269 | 5179952 | 5179709 | Myxococcus xanthus strain R31 chromosome, complete genome | blastn | 6851 | 302 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus | ||
| 19530846 | 19530846 | PRJNA382558_S_NODE_7576_length_187_cov_9.720000_g7572_i0 | PRJNA382558 | 7576 | 187 | 9.72 | 18.1764 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 145 | 2.5699999999999997e-30 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g7572 | i0 | 83.125 | 44.6149732620321 | 160 | 25 | 85 | 2 | 3 | 161 | 5376422 | 5376264 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 8343 | 145 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 23356885 | 23356885 | PRJNA382558_S_NODE_11219_length_167_cov_5.292308_g11215_i0 | PRJNA382558 | 11219 | 167 | 5.292308 | 8.83815436 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 84.2 | 4.97e-12 | NTclustered | gi|2579656172|gb|CP043491.1| | 43 | g11215 | i0 | 79.032 | 0.74251497005988 | 124 | 24 | 74 | 2 | 45 | 167 | 9293051 | 9293173 | Cystobacter fuscus strain Cbf 10 chromosome, complete genome | blastn | 124 | 84.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 28513218 | 28513218 | PRJNA382558_S_NODE_1107_length_311_cov_8.704380_g1103_i0 | PRJNA382558 | 1107 | 311 | 8.70438 | 27.0706218 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 91.7 | 4.92e-19 | NR | HTN52801.1 | 1872521 | g1103 | i0 | 55.1 | 5.02572347266881 | 89 | 35 | 85.9 | 1 | 309 | 43 | 425 | 508 | HTN52801.1 hypothetical protein [Anaeromyxobacter sp.] | diamond | 1563 | 92.4 | 0.992424242424242 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. | ||
| 29854082 | 29854082 | PRJNA382558_S_NODE_5111_length_210_cov_7.433526_g5107_i0 | PRJNA382558 | 5111 | 210 | 7.433526 | 15.6104046 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 102 | 2.62e-24 | NR | MEW5741872.1 | 2818507 | g5107 | i0 | 64.3 | 6.92857142857143 | 70 | 25 | 100 | 0 | 210 | 1 | 75 | 144 | MEW5741872.1 alpha/beta hydrolase [Myxococcota bacterium] | diamond | 1455 | 102 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30296786 | 30296786 | PRJNA382558_S_NODE_6592_length_195_cov_7.873418_g6588_i0 | PRJNA382558 | 6592 | 195 | 7.873418 | 15.3531651 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 41.6 | 0.032 | NR | MDP9033838.1 | 2818507 | g6588 | i0 | 47.5 | 0.615384615384615 | 40 | 19 | 61.5 | 1 | 183 | 64 | 52 | 89 | MDP9033838.1 hypothetical protein [Myxococcota bacterium] | diamond | 120 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30328456 | 30328456 | PRJNA382558_S_NODE_772_length_337_cov_8.686667_g768_i0 | PRJNA382558 | 772 | 337 | 8.686667 | 29.27406779 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 135 | 1.38e-37 | NR | MBM2803994.1 | 2026735 | g768 | i0 | 70.7 | 0.818991097922849 | 92 | 25 | 80.1 | 1 | 52 | 321 | 42 | 133 | MBM2803994.1 uncharacterized protein [Deltaproteobacteria bacterium] | diamond | 276 | 135 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30580459 | 30580459 | PRJNA382558_S_NODE_793_length_335_cov_10.926174_g789_i0 | PRJNA382558 | 793 | 335 | 10.926174 | 36.6026829 | Myxococcus qinghaiensis | 2906758 | Bacteria | Bacteria | 83.6 | 2.44e-16 | NR | WP_323389881.1 | 2906758 | g789 | i0 | 42.7 | 0.985074626865672 | 110 | 60 | 95.8 | 2 | 334 | 14 | 108 | 217 | WP_323389881.1 pre-peptidase C-terminal domain-containing protein, partial [Myxococcus qinghaiensis] | diamond | 330 | 83.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus qinghaiensis | ||
| 31686947 | 31686947 | PRJNA382558_S_NODE_4977_length_211_cov_10.798851_g4973_i0 | PRJNA382558 | 4977 | 211 | 10.798851 | 22.78557561 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 65.9 | 1.73e-10 | NR | MES2639945.1 | 2818507 | g4973 | i0 | 53.2 | 0.881516587677725 | 62 | 27 | 88.2 | 1 | 187 | 2 | 104 | 163 | MES2639945.1 hypothetical protein [Myxococcota bacterium] | diamond | 186 | 65.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32400146 | 32400146 | PRJNA382558_S_NODE_15299_length_152_cov_5.591304_g15295_i0 | PRJNA382558 | 15299 | 152 | 5.591304 | 8.49878208 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 72.8 | 2.7e-13 | NR | MBN1210300.1 | 2484252 | g15295 | i0 | 66.7 | 1.89473684210526 | 48 | 16 | 94.7 | 0 | 2 | 145 | 623 | 670 | MBN1210300.1 ATP-binding protein [Myxococcaceae bacterium] | diamond | 288 | 72.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 32698732 | 32698732 | PRJNA382558_S_NODE_8820_length_179_cov_8.654930_g8816_i0 | PRJNA382558 | 8820 | 179 | 8.65493 | 15.4923247 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 51.2 | 7.6e-7 | NR | MEO1335893.1 | 2818507 | g8816 | i0 | 42.6 | 0.905027932960894 | 54 | 29 | 87.2 | 1 | 2 | 157 | 3 | 56 | MEO1335893.1 hypothetical protein [Myxococcota bacterium] | diamond | 162 | 51.2 | 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);;