contig_metadata
8 rows where bioproject = "PRJNA1118794", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7884095 | 7884095 | PRJNA1118794_P_NODE_8547_length_481_cov_5.671569_g7803_i0 | PRJNA1118794 | 8547 | 481 | 5.671569 | 27.28024689 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 802 | 0 | NTclustered | gi|2874254138|emb|OY970223.1| | 3107663 | g7803 | i0 | 96.881 | 635.126819126819 | 481 | 12 | 99 | 3 | 2 | 481 | 2315690 | 2315212 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.c.5 genome assembly, chromosome: 1 | blastn | 305496 | 802 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 14259593 | 14259593 | PRJNA1118794_P_NODE_31372_length_288_cov_3.539535_g30622_i0 | PRJNA1118794 | 31372 | 288 | 3.539535 | 10.1938608 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 468 | 2.23e-127 | NTclustered | gi|2874253986|emb|OY970311.1| | 3107663 | g30622 | i0 | 96.154 | 173.711805555556 | 286 | 11 | 99 | 0 | 1 | 286 | 2945518 | 2945233 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.13 genome assembly, chromosome: 1 | blastn | 50029 | 468 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 16807574 | 16807574 | PRJNA1118794_P_NODE_21434_length_331_cov_0.864341_g20684_i0 | PRJNA1118794 | 21434 | 331 | 0.864341 | 2.86096871 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 588 | 1.92e-163 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g20684 | i0 | 98.788 | 6.1631419939577 | 330 | 4 | 99 | 0 | 1 | 330 | 5032597 | 5032926 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 2040 | 588 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 19356551 | 19356551 | PRJNA1118794_P_NODE_35456_length_279_cov_1.121359_g34706_i0 | PRJNA1118794 | 35456 | 279 | 1.121359 | 3.12859161 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 444 | 3.63e-120 | NTclustered | gi|2874254122|emb|OY970207.1| | 3107663 | g34706 | i0 | 95.341 | 867.94982078853 | 279 | 13 | 100 | 0 | 1 | 279 | 2165814 | 2165536 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1 | blastn | 242158 | 444 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 27763320 | 27763320 | PRJNA1118794_P_NODE_74144_length_241_cov_0.916667_g73394_i0 | PRJNA1118794 | 74144 | 241 | 0.916667 | 2.20916747 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 103 | 1.42e-23 | NR | MFN8609897.1 | 3107663 | g73394 | i0 | 75.9 | 1.96680497925311 | 79 | 19 | 98.3 | 0 | 239 | 3 | 376 | 454 | MFN8609897.1 FHA domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 474 | 103 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 28963038 | 28963038 | PRJNA1118794_P_NODE_17328_length_356_cov_2.173145_g16578_i0 | PRJNA1118794 | 17328 | 356 | 2.173145 | 7.7363962 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 46.6 | 0.00586 | NR | HEV7179043.1 | 2952909 | g16578 | i0 | 30.6 | 0.825842696629214 | 98 | 57 | 81.7 | 3 | 345 | 55 | 364 | 451 | HEV7179043.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] | diamond | 294 | 46.6 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 29436165 | 29436165 | PRJNA1118794_P_NODE_55710_length_248_cov_0.880000_g54960_i0 | PRJNA1118794 | 55710 | 248 | 0.88 | 2.1824 | Candidatus Elarobacter sp. | 3047550 | Bacteria | Bacteria | 143 | 5.99e-39 | NR | HEV2644618.1 | 3047550 | g54960 | i0 | 90.2 | 1.98387096774194 | 82 | 8 | 99.2 | 0 | 3 | 248 | 38 | 119 | HEV2644618.1 iron ABC transporter permease [Candidatus Elarobacter sp.] | diamond | 492 | 143 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Elarobacter | Candidatus Elarobacter sp. | ||
| 31205064 | 31205064 | PRJNA1118794_P_NODE_51215_length_250_cov_0.870056_g50465_i0 | PRJNA1118794 | 51215 | 250 | 0.870056 | 2.17514 | Candidatus Aquilonibacter sp. | 2952903 | Bacteria | Bacteria | 143 | 4.13e-39 | NR | HTZ73631.1 | 2952903 | g50465 | i0 | 84.1 | 3.948 | 82 | 13 | 98.4 | 0 | 246 | 1 | 251 | 332 | HTZ73631.1 glycosyltransferase family 4 protein [Candidatus Aquilonibacter sp.] | diamond | 987 | 143 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Aquilonibacter | Candidatus Aquilonibacter sp. |
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);;