contig_metadata
7 rows where bioproject = "PRJNA493632", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4295795 | 4295795 | PRJNA493632_P_NODE_726244_length_204_cov_6.877863_g722801_i0 | PRJNA493632 | 726244 | 204 | 6.877863 | 14.03084052 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 134 | 6.1800000000000006e-27 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g722801 | i0 | 87.395 | 1.11274509803922 | 119 | 11 | 62 | 3 | 42 | 159 | 3269051 | 3268936 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 227 | 134 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 11939268 | 11939268 | PRJNA493632_P_NODE_260690_length_310_cov_4.046414_g257254_i0 | PRJNA493632 | 260690 | 310 | 4.046414 | 12.5438834 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 171 | 7.66e-38 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g257254 | i0 | 90.37 | 13.9774193548387 | 135 | 5 | 44 | 2 | 161 | 295 | 2483873 | 2483999 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 4333 | 171 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 11947448 | 11947448 | PRJNA493632_P_NODE_720730_length_209_cov_13.698529_g717288_i0 | PRJNA493632 | 720730 | 209 | 13.698529 | 28.62992561 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 318 | 1.64e-82 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g717288 | i0 | 94.231 | 558.55023923445 | 208 | 12 | 99 | 0 | 1 | 208 | 5033755 | 5033548 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 116737 | 318 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 23421490 | 23421490 | PRJNA493632_P_NODE_75659_length_509_cov_25.282110_g72295_i0 | PRJNA493632 | 75659 | 509 | 25.28211 | 128.6859399 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 520 | 1.14e-142 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g72295 | i0 | 85.356 | 98.7151277013753 | 519 | 57 | 100 | 14 | 1 | 509 | 5031243 | 5031752 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 50246 | 520 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 26823545 | 26823545 | PRJNA493632_P_NODE_335801_length_286_cov_1.389671_g332362_i0 | PRJNA493632 | 335801 | 286 | 1.389671 | 3.97445906 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 83.2 | 5.53e-17 | NR | MFN8611091.1 | 3107663 | g332362 | i0 | 44.7 | 1.99300699300699 | 94 | 51 | 97.6 | 1 | 281 | 3 | 34 | 127 | MFN8611091.1 FecR family protein [Vulcanimicrobiota bacterium] | diamond | 570 | 83.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29728994 | 29728994 | PRJNA493632_P_NODE_713590_length_216_cov_20.370629_g710148_i0 | PRJNA493632 | 713590 | 216 | 20.370629 | 44.00055864 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 50.1 | 6.15e-5 | NR | GMU54463.1 | 3036772 | g710148 | i0 | 45.2 | 0.861111111111111 | 62 | 34 | 86.1 | 0 | 199 | 14 | 129 | 190 | GMU54463.1 MAG: hypothetical protein AMXMBFR33_36090 [Candidatus Xenobia bacterium] | diamond | 186 | 50.1 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Candidatus Xenobia | Candidatus Xenobia bacterium | |||||
| 31277328 | 31277328 | PRJNA493632_P_NODE_719035_length_211_cov_5.760870_g715593_i0 | PRJNA493632 | 719035 | 211 | 5.76087 | 12.1554357 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 88.2 | 1.3e-19 | NR | MFA5505779.1 | 3107663 | g715593 | i0 | 58.6 | 0.995260663507109 | 70 | 27 | 99.5 | 1 | 210 | 1 | 93 | 160 | MFA5505779.1 nuclear transport factor 2 family protein [Vulcanimicrobiota bacterium] | diamond | 210 | 88.2 | 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);;