contig_metadata
9 rows where bioproject = "PRJNA931595", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2530640 | 2530640 | PRJNA931595_P_NODE_5322_length_341_cov_1.723881_g5213_i0 | PRJNA931595 | 5322 | 341 | 1.723881 | 5.87843421 | Pendulispora | 3375062 | Bacteria | Bacteria | 501 | 2.66e-137 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g5213 | i0 | 93.255 | 161.431085043988 | 341 | 22 | 100 | 1 | 1 | 341 | 7191285 | 7191624 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 55048 | 503 | 0.996023856858847 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 6012801 | 6012801 | PRJNA931595_P_NODE_12585_length_250_cov_0.870056_g12476_i0 | PRJNA931595 | 12585 | 250 | 0.870056 | 2.17514 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 156 | 1.68e-33 | NTclustered | gi|2579656172|gb|CP043491.1| | 43 | g12476 | i0 | 82.584 | 18.012 | 178 | 29 | 71 | 2 | 1 | 177 | 9673896 | 9674072 | Cystobacter fuscus strain Cbf 10 chromosome, complete genome | blastn | 4503 | 156 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 7287686 | 7287686 | PRJNA931595_P_NODE_13846_length_246_cov_0.976879_g13737_i0 | PRJNA931595 | 13846 | 246 | 0.976879 | 2.40312234 | Pendulispora rubella | 2741070 | Bacteria | Bacteria | 267 | 7.289999999999999e-67 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g13737 | i0 | 86.345 | 522.426829268293 | 249 | 29 | 100 | 5 | 1 | 246 | 7289992 | 7289746 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 128517 | 267 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 14937424 | 14937424 | PRJNA931595_P_NODE_10352_length_269_cov_1.571429_g10243_i0 | PRJNA931595 | 10352 | 269 | 1.571429 | 4.22714401 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 84.2 | 8.74e-12 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g10243 | i0 | 86.667 | 0.278810408921933 | 75 | 10 | 28 | 0 | 192 | 266 | 11484885 | 11484811 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 75 | 84.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 27941060 | 27941060 | PRJNA931595_P_NODE_7205_length_302_cov_2.187773_g7096_i0 | PRJNA931595 | 7205 | 302 | 2.187773 | 6.60707446 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 44.3 | 0.0211 | NR | WP_338054962.1 | 927083 | g7096 | i0 | 43.6 | 0.387417218543046 | 39 | 22 | 38.7 | 0 | 56 | 172 | 487 | 525 | WP_338054962.1 N-acyl-D-amino-acid deacylase family protein [Sandaracinus amylolyticus] | diamond | 117 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 30151089 | 30151089 | PRJNA931595_P_NODE_10472_length_268_cov_1.579487_g10363_i0 | PRJNA931595 | 10472 | 268 | 1.579487 | 4.23302516 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 47.8 | 7.2e-4 | NR | MBS2031688.1 | 2026735 | g10363 | i0 | 31.1 | 0.828358208955224 | 74 | 50 | 82.8 | 1 | 4 | 225 | 176 | 248 | MBS2031688.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 222 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30498931 | 30498931 | PRJNA931595_P_NODE_8413_length_286_cov_1.798122_g8304_i0 | PRJNA931595 | 8413 | 286 | 1.798122 | 5.14262892 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 92.8 | 6.860000000000001e-21 | NR | MBL8608393.1 | 2026763 | g8304 | i0 | 47.4 | 0.996503496503496 | 95 | 50 | 99.7 | 0 | 2 | 286 | 112 | 206 | MBL8608393.1 hypothetical protein [Myxococcales bacterium] | diamond | 285 | 92.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31257207 | 31257207 | PRJNA931595_P_NODE_12375_length_251_cov_0.865169_g12266_i0 | PRJNA931595 | 12375 | 251 | 0.865169 | 2.17157419 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.1 | 0.006 | NR | MBT4088359.1 | 2026735 | g12266 | i0 | 65.5 | 0.346613545816733 | 29 | 10 | 34.7 | 0 | 122 | 36 | 246 | 274 | MBT4088359.1 4Fe-4S binding protein [Deltaproteobacteria bacterium] | diamond | 87 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32206295 | 32206295 | PRJNA931595_P_NODE_8918_length_282_cov_1.277512_g8809_i0 | PRJNA931595 | 8918 | 282 | 1.277512 | 3.60258384 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 95.1 | 1.9e-22 | NR | HEX3855461.1 | 2268199 | g8809 | i0 | 61.3 | 0.98936170212766 | 93 | 36 | 98.9 | 0 | 2 | 280 | 19 | 111 | HEX3855461.1 helix-turn-helix domain-containing protein [Polyangiaceae bacterium] | diamond | 279 | 95.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae 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);;