contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA864829" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11051048 | 11051048 | PRJNA864829_S_NODE_9789_length_201_cov_1.401316_g9703_i0 | PRJNA864829 | 9789 | 201 | 1.401316 | 2.81664516 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 96.3 | 1.48e-21 | NR | MBU0607340.1 | 2033014 | g9703 | i0 | 70.1 | 9 | 67 | 20 | 100 | 0 | 1 | 201 | 224 | 290 | MBU0607340.1 IS5 family transposase [Armatimonadota bacterium] | diamond | 1809 | 96.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 14875327 | 14875327 | PRJNA864829_S_NODE_9172_length_207_cov_0.841772_g9086_i0 | PRJNA864829 | 9172 | 207 | 0.841772 | 1.74246804 | Bacteria | 2 | Bacteria | Bacteria | 116 | 2.26e-28 | NR | MBX3119070.1 | 2682144 | g9086 | i0 | 72.1 | 5.91304347826087 | 68 | 19 | 98.6 | 0 | 205 | 2 | 9 | 76 | MBX3119070.1 DNA primase [Fimbriimonadaceae bacterium] | diamond | 1224 | 117 | 0.991452991452991 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 26897087 | 26897087 | PRJNA864829_S_NODE_6681_length_236_cov_3.406417_g6595_i0 | PRJNA864829 | 6681 | 236 | 3.406417 | 8.03914412 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 140 | 9.619999999999998e-37 | NR | MCC7438988.1 | 2033014 | g6595 | i0 | 89.2 | 1.88135593220339 | 74 | 8 | 94.1 | 0 | 236 | 15 | 600 | 673 | MCC7438988.1 OmpA family protein [Armatimonadota bacterium] | diamond | 444 | 140 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28065813 | 28065813 | PRJNA864829_S_NODE_16065_length_162_cov_3.964602_g15979_i0 | PRJNA864829 | 16065 | 162 | 3.964602 | 6.42265524 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 92.4 | 1.79e-22 | NR | MCC7437879.1 | 2033014 | g15979 | i0 | 86.8 | 0.981481481481482 | 53 | 7 | 98.1 | 0 | 161 | 3 | 39 | 91 | MCC7437879.1 endonuclease domain-containing protein [Armatimonadota bacterium] | diamond | 159 | 92.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30253039 | 30253039 | PRJNA864829_S_NODE_9232_length_206_cov_1.917197_g9146_i0 | PRJNA864829 | 9232 | 206 | 1.917197 | 3.94942582 | FCB group | 1783270 | Bacteria | Bacteria | 72.4 | 8.05e-13 | NR | MCC7436866.1 | 2033014 | g9146 | i0 | 100 | 2.47572815533981 | 34 | 0 | 49.5 | 0 | 136 | 35 | 745 | 778 | MCC7436866.1 hypothetical protein [Armatimonadota bacterium] | diamond | 510 | 72.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30403112 | 30403112 | PRJNA864829_S_NODE_9933_length_200_cov_1.463576_g9847_i0 | PRJNA864829 | 9933 | 200 | 1.463576 | 2.927152 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 136 | 1.95e-35 | NR | MCC7438601.1 | 2033014 | g9847 | i0 | 90.9 | 0.99 | 66 | 6 | 99 | 0 | 199 | 2 | 92 | 157 | MCC7438601.1 Eco57I restriction-modification methylase domain-containing protein [Armatimonadota bacterium] | diamond | 198 | 136 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30876599 | 30876599 | PRJNA864829_S_NODE_4414_length_277_cov_1.307018_g4328_i0 | PRJNA864829 | 4414 | 277 | 1.307018 | 3.62043986 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 128 | 1e-36 | NR | MBL8065531.1 | 2739509 | g4328 | i0 | 100 | 0.649819494584838 | 60 | 0 | 65 | 0 | 180 | 1 | 1 | 60 | MBL8065531.1 type Z 30S ribosomal protein S14 [Chthonomonadaceae bacterium] | diamond | 180 | 128 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30916512 | 30916512 | PRJNA864829_S_NODE_3454_length_301_cov_3.535714_g3368_i0 | PRJNA864829 | 3454 | 301 | 3.535714 | 10.64249914 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 77.4 | 2.07e-15 | NR | WP_025227921.1 | 1005039 | g3368 | i0 | 50.7 | 1.42524916943522 | 69 | 34 | 68.8 | 0 | 259 | 53 | 90 | 158 | WP_025227921.1 hypothetical protein [Fimbriimonas ginsengisoli] | diamond | 429 | 77.8 | 0.994858611825193 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 32402868 | 32402868 | PRJNA864829_S_NODE_11019_length_191_cov_3.401408_g10933_i0 | PRJNA864829 | 11019 | 191 | 3.401408 | 6.49668928 | FCB group | 1783270 | Bacteria | Bacteria | 138 | 8.259999999999999e-37 | NR | MCC7437919.1 | 2033014 | g10933 | i0 | 100 | 1.97905759162304 | 63 | 0 | 99 | 0 | 191 | 3 | 111 | 173 | MCC7437919.1 aldehyde dehydrogenase family protein [Armatimonadota bacterium] | diamond | 378 | 138 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;