contig_metadata
8 rows where bioproject = "PRJNA1240804" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 347585 | 347585 | PRJNA1240804_P_NODE_1781_length_791_cov_3.667116_g1484_i0 | PRJNA1240804 | 1781 | 791 | 3.667116 | 29.00688756 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 680 | 0 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g1484 | i0 | 83.081 | 867.981036662453 | 792 | 90 | 98 | 38 | 17 | 785 | 5032174 | 5032944 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 686573 | 680 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 8001352 | 8001352 | PRJNA1240804_P_NODE_31367_length_261_cov_2.735849_g31001_i0 | PRJNA1240804 | 31367 | 261 | 2.735849 | 7.14056589 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 244 | 3.66e-60 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g31001 | i0 | 84.047 | 758.233716475096 | 257 | 37 | 98 | 4 | 7 | 261 | 5033519 | 5033265 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 197899 | 244 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 10551024 | 10551024 | PRJNA1240804_P_NODE_116929_length_168_cov_0.873950_g116563_i0 | PRJNA1240804 | 116929 | 168 | 0.87395 | 1.468236 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 119 | 1.37e-22 | NTclustered | gi|2874253953|emb|OY970278.1| | 3107663 | g116563 | i0 | 86.607 | 0.666666666666667 | 112 | 9 | 65 | 6 | 39 | 147 | 871666 | 871558 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.10 genome assembly, chromosome: 1 | blastn | 112 | 119 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 16925101 | 16925101 | PRJNA1240804_P_NODE_2534_length_692_cov_3.625194_g1484_i1 | PRJNA1240804 | 2534 | 692 | 3.625194 | 25.08634248 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 664 | 0 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g1484 | i1 | 85.347 | 770.596820809249 | 662 | 73 | 94 | 20 | 27 | 676 | 5032823 | 5032174 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 533253 | 664 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 22024805 | 22024805 | PRJNA1240804_P_NODE_3278_length_633_cov_7.390411_g2942_i0 | PRJNA1240804 | 3278 | 633 | 7.390411 | 46.78130163 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 815 | 0 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g2942 | i0 | 90.256 | 759.971563981043 | 626 | 57 | 99 | 4 | 9 | 633 | 5033143 | 5033765 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 481062 | 815 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 23300808 | 23300808 | PRJNA1240804_P_NODE_46679_length_224_cov_2.251429_g46313_i0 | PRJNA1240804 | 46679 | 224 | 2.251429 | 5.04320096 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 300 | 6.44e-77 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g46313 | i0 | 92.019 | 567.558035714286 | 213 | 17 | 95 | 0 | 1 | 213 | 5033765 | 5033553 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 127133 | 300 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32001671 | 32001671 | PRJNA1240804_P_NODE_122958_length_166_cov_2.401709_g122592_i0 | PRJNA1240804 | 122958 | 166 | 2.401709 | 3.98683694 | Candidatus Eremiobacteraceae bacterium | 3069296 | Bacteria | Bacteria | 68.9 | 7.56e-12 | NR | HXM14140.1 | 3069296 | g122592 | i0 | 64.7 | 1.8433734939759 | 51 | 18 | 92.2 | 0 | 1 | 153 | 245 | 295 | HXM14140.1 hypothetical protein [Candidatus Eremiobacteraceae bacterium] | diamond | 306 | 68.9 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Candidatus Eremiobacterales | Candidatus Eremiobacteraceae | Candidatus Eremiobacteraceae bacterium | |||
| 32602721 | 32602721 | PRJNA1240804_P_NODE_145620_length_163_cov_0.912281_g145254_i0 | PRJNA1240804 | 145620 | 163 | 0.912281 | 1.48701803 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 60.8 | 4.17e-9 | NR | HTA56600.1 | 2952909 | g145254 | i0 | 59.2 | 0.901840490797546 | 49 | 20 | 90.2 | 0 | 148 | 2 | 140 | 188 | HTA56600.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] | diamond | 147 | 60.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae 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);;