contig_metadata
16 rows where bioproject = "PRJNA393181", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 410470 | 410470 | PRJNA393181_S_NODE_28581_length_211_cov_2.436782_g28475_i0 | PRJNA393181 | 28581 | 211 | 2.436782 | 5.14161002 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 67.8 | 2.8e-12 | NR | HYM30214.1 | 2952917 | g28475 | i0 | 58.3 | 0.682464454976303 | 48 | 20 | 68.2 | 0 | 145 | 2 | 88 | 135 | HYM30214.1 tetratricopeptide repeat protein [Candidatus Cybelea sp.] | diamond | 144 | 67.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 410634 | 410634 | PRJNA393181_S_NODE_35381_length_184_cov_1.061224_g35275_i0 | PRJNA393181 | 35381 | 184 | 1.061224 | 1.95265216 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|2874253636|emb|OY968762.1| | 3107663 | g35275 | i0 | 96.875 | 0.173913043478261 | 32 | 1 | 17 | 0 | 110 | 141 | 1987272 | 1987303 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.1.72 genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 410985 | 410985 | PRJNA393181_S_NODE_7341_length_438_cov_4.264339_g7235_i0 | PRJNA393181 | 7341 | 438 | 4.264339 | 18.67780482 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 285 | 3.83e-72 | NTclustered | gi|2874253918|emb|OY970243.1| | 3107663 | g7235 | i0 | 79.167 | 13.1187214611872 | 432 | 75 | 97 | 15 | 10 | 434 | 245668 | 245245 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 | blastn | 5746 | 285 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 1685467 | 1685467 | PRJNA393181_S_NODE_342_length_1118_cov_3.284921_g300_i0 | PRJNA393181 | 342 | 1118 | 3.284921 | 36.72541678 | Vulcanimicrobium alpinum | 3016050 | Bacteria | Bacteria | 551 | 9.199999999999999e-152 | NTclustered | gi|2416250577|dbj|AP025523.1| | 3016050 | g300 | i0 | 79.048 | 24.8980322003578 | 840 | 148 | 74 | 22 | 136 | 958 | 2421877 | 2422705 | Vulcanimicrobium alpinum WC8-2 DNA, complete genome | blastn | 27836 | 551 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Vulcanimicrobium | Vulcanimicrobium alpinum | ||
| 13164126 | 13164126 | PRJNA393181_S_NODE_24051_length_235_cov_3.227273_g23945_i0 | PRJNA393181 | 24051 | 235 | 3.227273 | 7.58409155 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 141 | 4.37e-29 | NTclustered | gi|2874253824|emb|OY969808.1| | 3107663 | g23945 | i0 | 78.733 | 6.88510638297872 | 221 | 39 | 92 | 8 | 1 | 217 | 4095933 | 4095717 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.1 genome assembly, chromosome: 1 | blastn | 1618 | 141 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 15105995 | 15105995 | PRJNA393181_S_NODE_10092_length_380_cov_2.364431_g9986_i0 | PRJNA393181 | 10092 | 380 | 2.364431 | 8.9848378 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 114 | 3.4900000000000006e-27 | NR | HYM33183.1 | 2952917 | g9986 | i0 | 55 | 2.04473684210526 | 129 | 53 | 98.7 | 3 | 378 | 4 | 252 | 379 | HYM33183.1 nitrate/sulfonate/bicarbonate ABC transporter ATP-binding protein [Candidatus Cybelea sp.] | diamond | 777 | 114 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 20812634 | 20812634 | PRJNA393181_S_NODE_6517_length_462_cov_2.336471_g6411_i0 | PRJNA393181 | 6517 | 462 | 2.336471 | 10.79449602 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 52.8 | 0.045 | NTclustered | gi|2874254122|emb|OY970207.1| | 3107663 | g6411 | i0 | 100 | 0.0606060606060606 | 28 | 0 | 6 | 0 | 2 | 29 | 1290823 | 1290850 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 24636914 | 24636914 | PRJNA393181_S_NODE_3100_length_608_cov_2.942207_g3012_i0 | PRJNA393181 | 3100 | 608 | 2.942207 | 17.88861856 | Bacteria | 2 | Bacteria | Bacteria | 244 | 1.33e-78 | NR | HYM30922.1 | 2952917 | g3012 | i0 | 68.3 | 5.32401315789474 | 180 | 56 | 88.3 | 1 | 538 | 2 | 22 | 201 | HYM30922.1 helix-turn-helix domain-containing protein [Candidatus Cybelea sp.] | diamond | 3237 | 244 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 25304700 | 25304700 | PRJNA393181_S_NODE_35540_length_183_cov_2.047945_g35434_i0 | PRJNA393181 | 35540 | 183 | 2.047945 | 3.74773935 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 60.5 | 1.84e-9 | NR | HYM31984.1 | 2952917 | g35434 | i0 | 51.7 | 0.983606557377049 | 60 | 25 | 91.8 | 1 | 9 | 176 | 93 | 152 | HYM31984.1 hypothetical protein [Candidatus Cybelea sp.] | diamond | 180 | 60.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 26695349 | 26695349 | PRJNA393181_S_NODE_36121_length_181_cov_1.972222_g36015_i0 | PRJNA393181 | 36121 | 181 | 1.972222 | 3.56972182 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 57 | 9.39e-8 | NR | HTX53815.1 | 2952909 | g36015 | i0 | 75 | 0.662983425414365 | 40 | 10 | 66.3 | 0 | 1 | 120 | 194 | 233 | HTX53815.1 phosphatase PAP2 family protein [Candidatus Baltobacteraceae bacterium] | diamond | 120 | 57 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 27169857 | 27169857 | PRJNA393181_S_NODE_10422_length_374_cov_2.418398_g10316_i0 | PRJNA393181 | 10422 | 374 | 2.418398 | 9.04480852 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 79.7 | 1.39e-14 | NR | HYM31155.1 | 2952917 | g10316 | i0 | 58.8 | 1.6283422459893 | 68 | 28 | 54.5 | 0 | 4 | 207 | 331 | 398 | HYM31155.1 CoA transferase [Candidatus Cybelea sp.] | diamond | 609 | 79.7 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 27881746 | 27881746 | PRJNA393181_S_NODE_14625_length_315_cov_2.428058_g14519_i0 | PRJNA393181 | 14625 | 315 | 2.428058 | 7.6483827 | Bacteria | 2 | Bacteria | Bacteria | 78.2 | 1.56e-14 | NR | HVO00968.1 | 2952917 | g14519 | i0 | 78.4 | 2.92380952380952 | 51 | 11 | 48.6 | 0 | 314 | 162 | 271 | 321 | HVO00968.1 ABC transporter permease [Candidatus Cybelea sp.] | diamond | 921 | 78.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 28591290 | 28591290 | PRJNA393181_S_NODE_45467_length_155_cov_1.983051_g45361_i0 | PRJNA393181 | 45467 | 155 | 1.983051 | 3.07372905 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 68.2 | 1.02e-11 | NR | HYM31387.1 | 2952917 | g45361 | i0 | 59.6 | 0.909677419354839 | 47 | 19 | 91 | 0 | 15 | 155 | 155 | 201 | HYM31387.1 2OG-Fe(II) oxygenase [Candidatus Cybelea sp.] | diamond | 141 | 68.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 29349063 | 29349063 | PRJNA393181_S_NODE_33249_length_191_cov_3.032468_g33143_i0 | PRJNA393181 | 33249 | 191 | 3.032468 | 5.79201388 | Candidatus Lustribacter sp. | 3069335 | Bacteria | Bacteria | 45.8 | 0.00153 | NR | HEV8022820.1 | 3069335 | g33143 | i0 | 65.8 | 0.596858638743455 | 38 | 13 | 59.7 | 0 | 115 | 2 | 1 | 38 | HEV8022820.1 response regulator [Candidatus Lustribacter sp.] | diamond | 114 | 45.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Lustribacter | Candidatus Lustribacter sp. | ||
| 31086393 | 31086393 | PRJNA393181_S_NODE_8255_length_416_cov_2.976253_g8149_i0 | PRJNA393181 | 8255 | 416 | 2.976253 | 12.38121248 | Candidatus Elarobacter sp. | 3047550 | Bacteria | Bacteria | 57 | 2.3e-6 | NR | HEY0383590.1 | 3047550 | g8149 | i0 | 38.4 | 1.46394230769231 | 86 | 39 | 62 | 1 | 261 | 4 | 70 | 141 | HEY0383590.1 hypothetical protein [Candidatus Elarobacter sp.] | diamond | 609 | 57 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Elarobacter | Candidatus Elarobacter sp. | ||
| 31908624 | 31908624 | PRJNA393181_S_NODE_43277_length_160_cov_2.219512_g43171_i0 | PRJNA393181 | 43277 | 160 | 2.219512 | 3.5512192 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 45.8 | 9.99e-4 | NR | HYM33184.1 | 2952917 | g43171 | i0 | 52.4 | 0.7875 | 42 | 19 | 76.9 | 1 | 124 | 2 | 21 | 62 | HYM33184.1 ABC transporter permease subunit [Candidatus Cybelea sp.] | diamond | 126 | 45.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea 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);;