contig_metadata
13 rows where bioproject = "PRJEB14175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25500932 | 25500932 | PRJEB14175_P_NODE_100993_length_355_cov_12.823129_g98727_i0 | PRJEB14175 | 100993 | 355 | 12.823129 | 45.52210795 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 130 | 5.03e-33 | NR | MFN8614286.1 | 3107663 | g98727 | i0 | 63.8 | 0.887323943661972 | 105 | 38 | 88.7 | 0 | 320 | 6 | 249 | 353 | MFN8614286.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 315 | 130 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 25502260 | 25502260 | PRJEB14175_P_NODE_128177_length_306_cov_17.665306_g125910_i0 | PRJEB14175 | 128177 | 306 | 17.665306 | 54.05583636 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 364 | 3.2299999999999992e-96 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g125910 | i0 | 92.218 | 203.993464052288 | 257 | 20 | 86 | 0 | 28 | 284 | 5031486 | 5031230 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 62422 | 364 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 25503517 | 25503517 | PRJEB14175_P_NODE_153513_length_272_cov_10.379147_g151246_i0 | PRJEB14175 | 153513 | 272 | 10.379147 | 28.23127984 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 401 | 2.1499999999999993e-107 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g151246 | i0 | 98.261 | 13.9705882352941 | 230 | 3 | 84 | 1 | 24 | 252 | 5032492 | 5032721 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 3800 | 401 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 25508275 | 25508275 | PRJEB14175_P_NODE_266745_length_194_cov_2.157895_g264477_i0 | PRJEB14175 | 266745 | 194 | 2.157895 | 4.1863163 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|2874253636|emb|OY968762.1| | 3107663 | g264477 | i0 | 96.97 | 0.484536082474227 | 33 | 1 | 34 | 0 | 155 | 187 | 1208000 | 1207968 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.1.72 genome assembly, chromosome: 1 | blastn | 94 | 56.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 25637941 | 25637941 | PRJEB14175_P_NODE_123810_length_313_cov_4.952381_g121544_i0 | PRJEB14175 | 123810 | 313 | 4.952381 | 15.50095253 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2874253953|emb|OY970278.1| | 3107663 | g121544 | i0 | 97.059 | 0.108626198083067 | 34 | 0 | 11 | 1 | 206 | 239 | 2937957 | 2937989 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.10 genome assembly, chromosome: 1 | blastn | 34 | 56.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 26053571 | 26053571 | PRJEB14175_P_NODE_3917_length_1714_cov_5.630974_g3137_i0 | PRJEB14175 | 3917 | 1714 | 5.630974 | 96.51489436 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 359 | 9.29e-94 | NTclustered | gi|2874253918|emb|OY970243.1| | 3107663 | g3137 | i0 | 81.031 | 23.3745624270712 | 485 | 63 | 27 | 27 | 20 | 484 | 159760 | 160235 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 | blastn | 40064 | 359 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 26186942 | 26186942 | PRJEB14175_P_NODE_22054_length_782_cov_5.545076_g20153_i0 | PRJEB14175 | 22054 | 782 | 5.545076 | 43.36249432 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 255 | 5.57e-63 | NTclustered | gi|2874253918|emb|OY970243.1| | 3107663 | g20153 | i0 | 87.124 | 21.6687979539642 | 233 | 21 | 29 | 9 | 518 | 744 | 63459 | 63688 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 | blastn | 16945 | 255 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 26322278 | 26322278 | PRJEB14175_P_NODE_211823_length_219_cov_3.227848_g209556_i0 | PRJEB14175 | 211823 | 219 | 3.227848 | 7.06898712 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 104 | 5.27e-18 | NTclustered | gi|2874253636|emb|OY968762.1| | 3107663 | g209556 | i0 | 78.286 | 23.6803652968037 | 175 | 28 | 78 | 9 | 50 | 219 | 422259 | 422428 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.1.72 genome assembly, chromosome: 1 | blastn | 5186 | 104 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 26455265 | 26455265 | PRJEB14175_P_NODE_137584_length_293_cov_1.517241_g135317_i0 | PRJEB14175 | 137584 | 293 | 1.517241 | 4.44551613 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 226 | 1.5099999999999998e-54 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g135317 | i0 | 81.119 | 101.027303754266 | 286 | 50 | 97 | 3 | 1 | 283 | 5031773 | 5031489 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 29601 | 226 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32995372 | 32995372 | PRJEB14175_P_NODE_46411_length_548_cov_1.451745_g44188_i0 | PRJEB14175 | 46411 | 548 | 1.451745 | 7.9555626 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 312 | 3.86e-103 | NR | MFN8612886.1 | 3107663 | g44188 | i0 | 90.8 | 0.952554744525547 | 174 | 16 | 95.3 | 0 | 26 | 547 | 95 | 268 | MFN8612886.1 IS256 family transposase [Vulcanimicrobiota bacterium] | diamond | 522 | 312 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 33028027 | 33028027 | PRJEB14175_P_NODE_122268_length_316_cov_1.019608_g120002_i0 | PRJEB14175 | 122268 | 316 | 1.019608 | 3.22196128 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 152 | 5.39e-42 | NR | HYM32311.1 | 2952917 | g120002 | i0 | 69.2 | 2.00316455696203 | 104 | 32 | 98.7 | 0 | 3 | 314 | 62 | 165 | HYM32311.1 hypothetical protein [Candidatus Cybelea sp.] | diamond | 633 | 152 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 33062887 | 33062887 | PRJEB14175_P_NODE_210757_length_220_cov_1.874214_g208490_i0 | PRJEB14175 | 210757 | 220 | 1.874214 | 4.1232708 | Candidatus Eremiobacteraceae bacterium | 3069296 | Bacteria | Bacteria | 60.5 | 1.56e-8 | NR | HME81451.1 | 3069296 | g208490 | i0 | 64.3 | 1.13181818181818 | 42 | 15 | 57.3 | 0 | 211 | 86 | 524 | 565 | HME81451.1 di-heme-cytochrome C peroxidase [Candidatus Eremiobacteraceae bacterium] | diamond | 249 | 60.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Candidatus Eremiobacterales | Candidatus Eremiobacteraceae | Candidatus Eremiobacteraceae bacterium | |||
| 33096366 | 33096366 | PRJEB14175_P_NODE_135238_length_296_cov_4.600000_g132971_i0 | PRJEB14175 | 135238 | 296 | 4.6 | 13.616 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 94.7 | 1.47e-22 | NR | GMU56020.1 | 3036772 | g132971 | i0 | 45.9 | 0.993243243243243 | 98 | 48 | 94.3 | 2 | 281 | 3 | 1 | 98 | GMU56020.1 MAG: hypothetical protein AMXMBFR33_51660 [Candidatus Xenobia bacterium] | diamond | 294 | 94.7 | 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);;