contig_metadata
8 rows where analysis = "blastn", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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);;