contig_metadata
7 rows where bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9485850 | 9485850 | PRJNA565584_P_NODE_70708_length_353_cov_2.200000_g69557_i0 | PRJNA565584 | 70708 | 353 | 2.2 | 7.766 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 58.4 | 7.17e-4 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g69557 | i0 | 97.059 | 0.0963172804532578 | 34 | 1 | 10 | 0 | 204 | 237 | 6979832 | 6979799 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 34 | 58.4 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 10759221 | 10759221 | PRJNA565584_P_NODE_131249_length_274_cov_2.462687_g130097_i0 | PRJNA565584 | 131249 | 274 | 2.462687 | 6.74776238 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 379 | 1.02e-100 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g130097 | i0 | 91.606 | 4.72627737226277 | 274 | 23 | 100 | 0 | 1 | 274 | 5032565 | 5032838 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 1295 | 379 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 28184522 | 28184522 | PRJNA565584_P_NODE_136226_length_271_cov_1.767677_g135074_i0 | PRJNA565584 | 136226 | 271 | 1.767677 | 4.79040467 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 81.3 | 3.69e-16 | NR | MFA5505677.1 | 3107663 | g135074 | i0 | 66.1 | 0.686346863468635 | 62 | 21 | 68.6 | 0 | 191 | 6 | 2 | 63 | MFA5505677.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 186 | 81.3 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29826530 | 29826530 | PRJNA565584_P_NODE_148011_length_263_cov_2.373684_g146859_i0 | PRJNA565584 | 148011 | 263 | 2.373684 | 6.24278892 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 83.2 | 2.78e-16 | NR | MFA5508923.1 | 3107663 | g146859 | i0 | 45.7 | 2.77186311787072 | 81 | 36 | 92.4 | 2 | 5 | 247 | 423 | 495 | MFA5508923.1 VIT domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 729 | 83.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 30616445 | 30616445 | PRJNA565584_P_NODE_27193_length_592_cov_1.603083_g26052_i0 | PRJNA565584 | 27193 | 592 | 1.603083 | 9.49025136 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 210 | 1.25e-61 | NR | HYM30215.1 | 2952917 | g26052 | i0 | 53.3 | 3.98817567567568 | 195 | 89 | 98.8 | 2 | 6 | 590 | 251 | 443 | HYM30215.1 3-(methylthio)propionyl-CoA ligase [Candidatus Cybelea sp.] | diamond | 2361 | 210 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 31059114 | 31059114 | PRJNA565584_P_NODE_111635_length_287_cov_1.439252_g110483_i0 | PRJNA565584 | 111635 | 287 | 1.439252 | 4.13065324 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 43.1 | 0.0464 | NR | MFA5503970.1 | 3107663 | g110483 | i0 | 32.2 | 0.940766550522648 | 90 | 55 | 89.9 | 2 | 259 | 2 | 468 | 555 | MFA5503970.1 ATP-dependent helicase C-terminal domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 270 | 43.1 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 31722787 | 31722787 | PRJNA565584_P_NODE_163597_length_253_cov_1.711111_g162445_i0 | PRJNA565584 | 163597 | 253 | 1.711111 | 4.32911083 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 56.6 | 5.14e-7 | NR | MFA7480872.1 | 3107663 | g162445 | i0 | 44.7 | 2.01581027667984 | 85 | 29 | 99.6 | 3 | 252 | 1 | 171 | 238 | MFA7480872.1 pilus assembly PilX N-terminal domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 510 | 56.6 | 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);;