contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9462428 | 9462428 | PRJNA556992_P_NODE_852688_length_243_cov_1.882353_g850498_i0 | PRJNA556992 | 852688 | 243 | 1.882353 | 4.57411779 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 172 | 1.6099999999999996e-38 | NTclustered | gi|2874254122|emb|OY970207.1| | 3107663 | g850498 | i0 | 80.687 | 1.10699588477366 | 233 | 35 | 94 | 10 | 15 | 242 | 1988875 | 1988648 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1 | blastn | 269 | 172 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 10735901 | 10735901 | PRJNA556992_P_NODE_684709_length_252_cov_2.189944_g682520_i0 | PRJNA556992 | 684709 | 252 | 2.189944 | 5.51865888 | Vulcanimicrobium alpinum | 3016050 | Bacteria | Bacteria | 65.8 | 2.94e-6 | NTclustered | gi|2416250577|dbj|AP025523.1| | 3016050 | g682520 | i0 | 86.441 | 0.599206349206349 | 59 | 8 | 23 | 0 | 151 | 209 | 1459298 | 1459240 | Vulcanimicrobium alpinum WC8-2 DNA, complete genome | blastn | 151 | 65.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Vulcanimicrobium | Vulcanimicrobium alpinum | ||
| 18383384 | 18383384 | PRJNA556992_P_NODE_662155_length_254_cov_1.580110_g659966_i0 | PRJNA556992 | 662155 | 254 | 1.58011 | 4.0134794 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 134 | 8.01e-27 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g659966 | i0 | 80 | 8.57086614173228 | 195 | 28 | 75 | 11 | 64 | 254 | 2483907 | 2483720 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 2177 | 134 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 19653507 | 19653507 | PRJNA556992_P_NODE_318656_length_286_cov_1.830986_g316467_i0 | PRJNA556992 | 318656 | 286 | 1.830986 | 5.23661996 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 169 | 2.52e-37 | NTclustered | gi|2874254122|emb|OY970207.1| | 3107663 | g316467 | i0 | 80.349 | 39.0629370629371 | 229 | 39 | 79 | 6 | 59 | 284 | 2422471 | 2422246 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1 | blastn | 11172 | 169 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 23480329 | 23480329 | PRJNA556992_P_NODE_378059_length_279_cov_1.427184_g375870_i0 | PRJNA556992 | 378059 | 279 | 1.427184 | 3.98184336 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 270 | 6.519999999999999e-68 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g375870 | i0 | 89.238 | 49.5017921146953 | 223 | 15 | 80 | 3 | 1 | 223 | 2484020 | 2483807 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 13811 | 270 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 23486644 | 23486644 | PRJNA556992_P_NODE_877459_length_242_cov_0.911243_g875269_i0 | PRJNA556992 | 877459 | 242 | 0.911243 | 2.20520806 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 187 | 5.73e-43 | NTclustered | gi|2874253953|emb|OY970278.1| | 3107663 | g875269 | i0 | 80.833 | 75.2933884297521 | 240 | 44 | 99 | 2 | 4 | 242 | 743214 | 742976 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.10 genome assembly, chromosome: 1 | blastn | 18221 | 187 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 24751111 | 24751111 | PRJNA556992_P_NODE_169840_length_345_cov_1.073529_g167652_i0 | PRJNA556992 | 169840 | 345 | 1.073529 | 3.70367505 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 141 | 6.77e-29 | NTclustered | gi|2874253737|emb|OY969579.1| | 3107663 | g167652 | i0 | 78.448 | 129.794202898551 | 232 | 38 | 65 | 11 | 1 | 225 | 3062487 | 3062261 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.c.2 genome assembly, chromosome: 1 | blastn | 44779 | 141 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 24753672 | 24753672 | PRJNA556992_P_NODE_338280_length_283_cov_4.038095_g336091_i0 | PRJNA556992 | 338280 | 283 | 4.038095 | 11.42780885 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2874253824|emb|OY969808.1| | 3107663 | g336091 | i0 | 86.792 | 0.798586572438163 | 53 | 3 | 19 | 4 | 119 | 171 | 3547964 | 3547916 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.1 genome assembly, chromosome: 1 | blastn | 226 | 56.5 | 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);;