contig_metadata
7 rows where bioproject = "PRJNA716463", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1983771 | 1983771 | PRJNA716463_P_NODE_32202_length_302_cov_6.742358_g31785_i0 | PRJNA716463 | 32202 | 302 | 6.742358 | 20.36192116 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 407 | 5.21e-109 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g31785 | i0 | 92.58 | 6.09271523178808 | 283 | 21 | 98 | 0 | 1 | 283 | 5032507 | 5032789 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 1840 | 407 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 3259213 | 3259213 | PRJNA716463_P_NODE_4003_length_501_cov_4.114486_g3604_i0 | PRJNA716463 | 4003 | 501 | 4.114486 | 20.61357486 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 715 | 0 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g3604 | i0 | 92.445 | 44.1596806387226 | 503 | 34 | 100 | 4 | 1 | 501 | 5032507 | 5033007 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 22124 | 715 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 17286805 | 17286805 | PRJNA716463_P_NODE_94734_length_256_cov_2.185792_g94317_i0 | PRJNA716463 | 94734 | 256 | 2.185792 | 5.59562752 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 187 | 6.1099999999999985e-43 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g94317 | i0 | 80.309 | 40.1015625 | 259 | 41 | 99 | 8 | 3 | 256 | 5031705 | 5031452 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 10266 | 187 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 27399815 | 27399815 | PRJNA716463_P_NODE_45543_length_294_cov_2.882353_g45126_i0 | PRJNA716463 | 45543 | 294 | 2.882353 | 8.47411782 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 103 | 1.8199999999999994e-23 | NR | HYM31224.1 | 2952917 | g45126 | i0 | 51.6 | 0.969387755102041 | 95 | 46 | 96.9 | 0 | 286 | 2 | 335 | 429 | HYM31224.1 thiamine pyrophosphate-dependent enzyme [Candidatus Cybelea sp.] | diamond | 285 | 103 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 28757273 | 28757273 | PRJNA716463_P_NODE_52347_length_289_cov_1.712963_g51930_i0 | PRJNA716463 | 52347 | 289 | 1.712963 | 4.95046307 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 118 | 4.7e-29 | NR | MFA5508723.1 | 3107663 | g51930 | i0 | 54.7 | 0.986159169550173 | 95 | 43 | 98.6 | 0 | 4 | 288 | 73 | 167 | MFA5508723.1 radical SAM protein [Vulcanimicrobiota bacterium] | diamond | 285 | 118 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32707212 | 32707212 | PRJNA716463_P_NODE_84140_length_265_cov_2.390625_g83723_i0 | PRJNA716463 | 84140 | 265 | 2.390625 | 6.33515625 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 68.2 | 7e-12 | NR | MFA5504510.1 | 3107663 | g83723 | i0 | 53.2 | 0.70188679245283 | 62 | 29 | 70.2 | 0 | 188 | 3 | 1 | 62 | MFA5504510.1 DUF177 domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 186 | 68.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32896058 | 32896058 | PRJNA716463_P_NODE_79140_length_269_cov_2.275510_g78723_i0 | PRJNA716463 | 79140 | 269 | 2.27551 | 6.1211219 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 112 | 2.22e-26 | NR | MFA5505245.1 | 3107663 | g78723 | i0 | 67.8 | 1.94052044609665 | 87 | 28 | 97 | 0 | 265 | 5 | 188 | 274 | MFA5505245.1 HAMP domain-containing sensor histidine kinase [Vulcanimicrobiota bacterium] | diamond | 522 | 112 | 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);;