contig_metadata
5 rows where bioproject = "PRJNA493244", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3006746 | 3006746 | PRJNA493244_P_NODE_1549363_length_231_cov_6.088235_g1526238_i0 | PRJNA493244 | 1549363 | 231 | 6.088235 | 14.06382285 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 219 | 1.9199999999999993e-52 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g1526238 | i0 | 86.275 | 133.125541125541 | 204 | 25 | 87 | 2 | 1 | 202 | 5031777 | 5031575 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 30752 | 219 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 14483853 | 14483853 | PRJNA493244_P_NODE_1246112_length_313_cov_6.325397_g1222988_i0 | PRJNA493244 | 1246112 | 313 | 6.325397 | 19.79849261 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 267 | 9.6e-67 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g1222988 | i0 | 85.185 | 87.0798722044728 | 270 | 29 | 84 | 9 | 33 | 296 | 5031553 | 5031289 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 27256 | 267 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 20858383 | 20858383 | PRJNA493244_P_NODE_265137_length_1041_cov_4.070408_g250902_i0 | PRJNA493244 | 265137 | 1041 | 4.070408 | 42.37294728 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 952 | 0 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g250902 | i0 | 83.734 | 1040.48799231508 | 1039 | 135 | 98 | 30 | 1 | 1021 | 5032986 | 5031964 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 1083148 | 952 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 27803161 | 27803161 | PRJNA493244_P_NODE_1669704_length_207_cov_1.890411_g1646579_i0 | PRJNA493244 | 1669704 | 207 | 1.890411 | 3.91315077 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 96.7 | 2.3700000000000003e-21 | NR | MFA5507039.1 | 3107663 | g1646579 | i0 | 80 | 0.869565217391304 | 60 | 12 | 87 | 0 | 26 | 205 | 311 | 370 | MFA5507039.1 alanine--tRNA ligase [Vulcanimicrobiota bacterium] | diamond | 180 | 96.7 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 30298116 | 30298116 | PRJNA493244_P_NODE_1515892_length_239_cov_1.831461_g1492767_i0 | PRJNA493244 | 1515892 | 239 | 1.831461 | 4.37719179 | Candidatus Eremiobacteraceae bacterium | 3069296 | Bacteria | Bacteria | 97.1 | 2.2400000000000003e-21 | NR | HME82531.1 | 3069296 | g1492767 | i0 | 57.1 | 2.88702928870293 | 77 | 31 | 96.7 | 1 | 3 | 233 | 117 | 191 | HME82531.1 hypothetical protein [Candidatus Eremiobacteraceae bacterium] | diamond | 690 | 97.1 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Candidatus Eremiobacterales | Candidatus Eremiobacteraceae | Candidatus Eremiobacteraceae 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);;