contig_metadata
7 rows where bioproject = "PRJNA505329", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4310553 | 4310553 | PRJNA505329_P_NODE_5804_length_312_cov_2.091255_g5333_i0 | PRJNA505329 | 5804 | 312 | 2.091255 | 6.5247156 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 230 | 1.2599999999999998e-55 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g5333 | i0 | 83.665 | 7.92948717948718 | 251 | 34 | 79 | 6 | 65 | 312 | 5032845 | 5032599 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 2474 | 230 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 5586915 | 5586915 | PRJNA505329_P_NODE_13805_length_233_cov_2.777174_g13334_i0 | PRJNA505329 | 13805 | 233 | 2.777174 | 6.47081542 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 154 | 5.56e-33 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g13334 | i0 | 94.898 | 119.420600858369 | 98 | 5 | 42 | 0 | 4 | 101 | 5033918 | 5034015 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 27825 | 154 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 8136770 | 8136770 | PRJNA505329_P_NODE_6667_length_285_cov_4.576271_g6196_i0 | PRJNA505329 | 6667 | 285 | 4.576271 | 13.04237235 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 235 | 2.44e-57 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g6196 | i0 | 81.882 | 75.8140350877193 | 287 | 44 | 99 | 7 | 1 | 283 | 5031755 | 5031473 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 21607 | 235 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 11962333 | 11962333 | PRJNA505329_P_NODE_47210_length_164_cov_2.139130_g46739_i0 | PRJNA505329 | 47210 | 164 | 2.13913 | 3.5081732 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 228 | 2.1199999999999996e-55 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g46739 | i0 | 92.453 | 774.719512195122 | 159 | 12 | 97 | 0 | 3 | 161 | 5032269 | 5032111 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 127054 | 228 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 18335308 | 18335308 | PRJNA505329_P_NODE_52095_length_154_cov_2.923810_g51624_i0 | PRJNA505329 | 52095 | 154 | 2.92381 | 4.5026674 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 113 | 5.72e-21 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g51624 | i0 | 80.263 | 34.538961038961 | 152 | 28 | 98 | 2 | 3 | 153 | 5033433 | 5033583 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 5319 | 113 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 20885673 | 20885673 | PRJNA505329_P_NODE_52657_length_151_cov_6.715686_g52186_i0 | PRJNA505329 | 52657 | 151 | 6.715686 | 10.14068586 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 217 | 4.13e-52 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g52186 | i0 | 93.289 | 2.68211920529801 | 149 | 7 | 98 | 3 | 4 | 151 | 5032601 | 5032747 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 405 | 217 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32763684 | 32763684 | PRJNA505329_P_NODE_25360_length_194_cov_2.117241_g24889_i0 | PRJNA505329 | 25360 | 194 | 2.117241 | 4.10744754 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 59.3 | 2.73e-8 | NR | MFA7483177.1 | 3107663 | g24889 | i0 | 50.8 | 1.88659793814433 | 61 | 30 | 94.3 | 0 | 2 | 184 | 13 | 73 | MFA7483177.1 DUF4173 domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 366 | 59.3 | 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);;