contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax_phylum = "Vulcanimicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3064992 | 3064992 | PRJNA550047_P_NODE_248603_length_300_cov_9.960352_g246634_i0 | PRJNA550047 | 248603 | 300 | 9.960352 | 29.881056 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 139 | 2.08e-28 | NTclustered | gi|2874253918|emb|OY970243.1| | 3107663 | g246634 | i0 | 82.558 | 18.5833333333333 | 172 | 17 | 56 | 10 | 8 | 174 | 59067 | 58904 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 | blastn | 5575 | 139 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 6895241 | 6895241 | PRJNA550047_P_NODE_516306_length_225_cov_7.138158_g514333_i0 | PRJNA550047 | 516306 | 225 | 7.138158 | 16.0608555 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 193 | 1.13e-44 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g514333 | i0 | 86.441 | 91.4266666666667 | 177 | 23 | 79 | 1 | 1 | 177 | 5031750 | 5031575 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 20571 | 193 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 9442047 | 9442047 | PRJNA550047_P_NODE_208128_length_317_cov_15.926230_g206160_i0 | PRJNA550047 | 208128 | 317 | 15.92623 | 50.4861491 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 475 | 1.49e-129 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g206160 | i0 | 93.711 | 598.826498422713 | 318 | 19 | 100 | 1 | 1 | 317 | 5032101 | 5031784 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 189828 | 475 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 9447081 | 9447081 | PRJNA550047_P_NODE_82508_length_345_cov_10.363971_g80548_i0 | PRJNA550047 | 82508 | 345 | 10.363971 | 35.75569995 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 130 | 1.47e-25 | NTclustered | gi|2874253918|emb|OY970243.1| | 3107663 | g80548 | i0 | 82.667 | 16.1275362318841 | 150 | 23 | 43 | 3 | 2 | 149 | 117038 | 117186 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 | blastn | 5564 | 130 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 10721361 | 10721361 | PRJNA550047_P_NODE_503909_length_229_cov_8.089744_g501936_i0 | PRJNA550047 | 503909 | 229 | 8.089744 | 18.52551376 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 187 | 5.37e-43 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g501936 | i0 | 82.174 | 5.58078602620087 | 230 | 30 | 97 | 10 | 6 | 227 | 5032833 | 5032607 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 1278 | 187 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 11993327 | 11993327 | PRJNA550047_P_NODE_277670_length_299_cov_5.942478_g275701_i0 | PRJNA550047 | 277670 | 299 | 5.942478 | 17.76800922 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 122 | 2.0899999999999994e-23 | NTclustered | gi|2874254122|emb|OY970207.1| | 3107663 | g275701 | i0 | 82.609 | 0.919732441471572 | 138 | 24 | 46 | 0 | 153 | 290 | 2789831 | 2789968 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1 | blastn | 275 | 122 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota 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);;