contig_metadata
8 rows where bioproject = "PRJNA939415", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8568405 | 8568405 | PRJNA939415_P_NODE_40047_length_294_cov_4.380090_g39625_i0 | PRJNA939415 | 40047 | 294 | 4.38009 | 12.8774646 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 159 | 1.56e-34 | NTclustered | gi|2874254122|emb|OY970207.1| | 3107663 | g39625 | i0 | 81.771 | 3.26530612244898 | 192 | 33 | 65 | 2 | 104 | 294 | 1677102 | 1677292 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1 | blastn | 960 | 159 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 23867192 | 23867192 | PRJNA939415_P_NODE_107099_length_219_cov_5.986301_g106677_i0 | PRJNA939415 | 107099 | 219 | 5.986301 | 13.10999919 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 122 | 1.4599999999999995e-23 | NTclustered | gi|2874253986|emb|OY970311.1| | 3107663 | g106677 | i0 | 83.333 | 12.7397260273973 | 138 | 17 | 62 | 4 | 5 | 139 | 869263 | 869397 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.13 genome assembly, chromosome: 1 | blastn | 2790 | 122 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 26867087 | 26867087 | PRJNA939415_P_NODE_47301_length_286_cov_2.774648_g46879_i0 | PRJNA939415 | 47301 | 286 | 2.774648 | 7.93549328 | Candidatus Aquilonibacter sp. | 2952903 | Bacteria | Bacteria | 137 | 1.45e-36 | NR | HUO27545.1 | 2952903 | g46879 | i0 | 74.1 | 4.47902097902098 | 85 | 22 | 89.2 | 0 | 25 | 279 | 1 | 85 | HUO27545.1 carboxylate-amine ligase [Candidatus Aquilonibacter sp.] | diamond | 1281 | 137 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Aquilonibacter | Candidatus Aquilonibacter sp. | ||
| 27720602 | 27720602 | PRJNA939415_P_NODE_67144_length_266_cov_4.673575_g66722_i0 | PRJNA939415 | 67144 | 266 | 4.673575 | 12.4317095 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 148 | 3.25e-39 | NR | MFA7483777.1 | 3107663 | g66722 | i0 | 87.5 | 1.98496240601504 | 88 | 11 | 99.2 | 0 | 265 | 2 | 500 | 587 | MFA7483777.1 CusA/CzcA family heavy metal efflux RND transporter [Vulcanimicrobiota bacterium] | diamond | 528 | 148 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29267025 | 29267025 | PRJNA939415_P_NODE_52029_length_281_cov_4.884615_g51607_i0 | PRJNA939415 | 52029 | 281 | 4.884615 | 13.72576815 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 92 | 1.03e-19 | NR | HEY1868966.1 | 2952917 | g51607 | i0 | 54.4 | 0.96085409252669 | 90 | 41 | 96.1 | 0 | 12 | 281 | 1 | 90 | HEY1868966.1 hypothetical protein [Candidatus Cybelea sp.] | diamond | 270 | 92 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 29803854 | 29803854 | PRJNA939415_P_NODE_26031_length_310_cov_4.873418_g25609_i0 | PRJNA939415 | 26031 | 310 | 4.873418 | 15.1075958 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 68.2 | 1.51e-12 | NR | MFA7479225.1 | 3107663 | g25609 | i0 | 67.4 | 0.445161290322581 | 46 | 15 | 44.5 | 0 | 1 | 138 | 37 | 82 | MFA7479225.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 138 | 68.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 30056514 | 30056514 | PRJNA939415_P_NODE_111011_length_202_cov_4.519380_g110589_i0 | PRJNA939415 | 111011 | 202 | 4.51938 | 9.1291476 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 47.8 | 3.62e-4 | NR | HZY96916.1 | 2952917 | g110589 | i0 | 42.6 | 0.905940594059406 | 61 | 35 | 90.6 | 0 | 6 | 188 | 394 | 454 | HZY96916.1 lanthionine synthetase LanC family protein [Candidatus Cybelea sp.] | diamond | 183 | 47.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 32301735 | 32301735 | PRJNA939415_P_NODE_90599_length_245_cov_1.703488_g90177_i0 | PRJNA939415 | 90599 | 245 | 1.703488 | 4.1735456 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 52 | 2.03e-5 | NR | HEY4002610.1 | 3036772 | g90177 | i0 | 38.5 | 0.955102040816327 | 78 | 48 | 95.5 | 0 | 238 | 5 | 101 | 178 | HEY4002610.1 VWA domain-containing protein [Candidatus Xenobia bacterium] | diamond | 234 | 52 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Candidatus Xenobia | Candidatus Xenobia 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);;