contig_metadata
6 rows where bioproject = "PRJNA1020854", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5263706 | 5263706 | PRJNA1020854_S_NODE_21825_length_232_cov_9.926108_g19061_i0 | PRJNA1020854 | 21825 | 232 | 9.926108 | 23.02857056 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 228 | 3.209999999999999e-55 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g19061 | i0 | 86.449 | 53.948275862069 | 214 | 22 | 91 | 6 | 1 | 210 | 5031450 | 5031240 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 12516 | 228 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 9088897 | 9088897 | PRJNA1020854_S_NODE_7228_length_572_cov_696.171271_g4628_i0 | PRJNA1020854 | 7228 | 572 | 696.171271 | 3982.09967012 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 758 | 0 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g4628 | i0 | 92.776 | 419.762237762238 | 526 | 34 | 92 | 4 | 49 | 572 | 5032924 | 5032401 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 240104 | 758 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 14190018 | 14190018 | PRJNA1020854_S_NODE_8932_length_457_cov_43.184579_g6235_i0 | PRJNA1020854 | 8932 | 457 | 43.184579 | 197.35352603 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 534 | 3.6099999999999997e-147 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g6235 | i0 | 87.826 | 399.262582056893 | 460 | 50 | 100 | 6 | 1 | 457 | 5032399 | 5031943 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 182463 | 534 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 19287021 | 19287021 | PRJNA1020854_S_NODE_7236_length_571_cov_1081.079336_g4628_i1 | PRJNA1020854 | 7236 | 571 | 1081.079336 | 6172.96300856 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 725 | 0 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g4628 | i1 | 91.635 | 420.532399299475 | 526 | 40 | 92 | 4 | 1 | 524 | 5032401 | 5032924 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 240124 | 725 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 19287022 | 19287022 | PRJNA1020854_S_NODE_7256_length_570_cov_16.855823_g4651_i0 | PRJNA1020854 | 7256 | 570 | 16.855823 | 96.0781911 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 569 | 1.2599999999999999e-157 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g4651 | i0 | 85.663 | 80.9719298245614 | 558 | 61 | 96 | 14 | 23 | 570 | 5031240 | 5031788 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 46154 | 569 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 24386806 | 24386806 | PRJNA1020854_S_NODE_15320_length_298_cov_11.353160_g12556_i0 | PRJNA1020854 | 15320 | 298 | 11.35316 | 33.8324168 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 239 | 1.98e-58 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g12556 | i0 | 83.088 | 95.4295302013423 | 272 | 36 | 90 | 7 | 1 | 267 | 5031788 | 5031522 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 28438 | 239 | 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);;