RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Vulcanimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Vulcanimicrobiota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJEB64798 · 11 ✖

analysis 1

  • blastn · 11 ✖

tax_clade 0

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
1401891 1401891 PRJEB64798_P_NODE_16802_length_486_cov_9.972540_g15099_i0 PRJEB64798 16802 486 9.97254 48.4665444 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 261 7.23e-65   NTclustered gi|2874253737|emb|OY969579.1| 3107663 g15099 i0 78.538 82.5514403292181 424 71 86 16 71 486 3060777 3060366 MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.c.2 genome assembly, chromosome: 1 blastn 40120 261 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
1403163 1403163 PRJEB64798_P_NODE_26482_length_382_cov_63.849850_g24731_i0 PRJEB64798 26482 382 63.849850000000004 243.906427 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 564 3.78e-156   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g24731 i0 93.668 357.180628272251 379 21 99 3 1 377 5032114 5031737 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 136443 564 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
9056272 9056272 PRJEB64798_P_NODE_47388_length_285_cov_5.093220_g45623_i0 PRJEB64798 47388 285 5.09322 14.515677 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 62.1 4.37e-5   NTclustered gi|2874253636|emb|OY968762.1| 3107663 g45623 i0 93.023 0.150877192982456 43 2 15 1 93 134 423581 423539 MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.1.72 genome assembly, chromosome: 1 blastn 43 62.1 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
11608046 11608046 PRJEB64798_P_NODE_73510_length_225_cov_4.045455_g71745_i0 PRJEB64798 73510 225 4.045455 9.10227375 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 176 1.14e-39   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g71745 i0 90.84 1.69777777777778 131 12 58 0 7 137 5032594 5032724 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 382 176 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
14157426 14157426 PRJEB64798_P_NODE_47592_length_284_cov_12.838298_g45827_i0 PRJEB64798 47592 284 12.838298 36.46076632 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 342 1.3899999999999999e-89   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g45827 i0 89.209 709.017605633803 278 24 98 5 7 284 5032951 5033222 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 201361 342 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
15429013 15429013 PRJEB64798_P_NODE_11853_length_581_cov_78.342105_g10271_i0 PRJEB64798 11853 581 78.342105 455.16763005 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 466 1.7299999999999994e-126   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g10271 i0 81.583 56.605851979346 581 92 99 14 2 574 5033080 5032507 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 32888 466 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
17979848 17979848 PRJEB64798_P_NODE_2315_length_1196_cov_96.228422_g1718_i0 PRJEB64798 2315 1196 96.228422 1150.89192712 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 1059 0   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g1718 i0 83.127 524.609531772575 1209 157 99 41 17 1196 5031240 5032430 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 627433 1059 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
19253460 19253460 PRJEB64798_P_NODE_203716_length_166_cov_5.282051_g201950_i0 PRJEB64798 203716 166 5.282051 8.76820466 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 89.8 1.06e-13   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g201950 i0 78.767 203.325301204819 146 22 84 7 23 161 7831144 7831287 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 33752 89.8 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
19255296 19255296 PRJEB64798_P_NODE_8456_length_680_cov_36.679873_g7057_i0 PRJEB64798 8456 680 36.679873 249.4231364 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 529 2.5699999999999992e-145   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g7057 i0 81.223 398.039705882353 687 101 99 27 1 673 5033179 5032507 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 270667 529 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
20529762 20529762 PRJEB64798_P_NODE_3597_length_990_cov_122.109458_g625_i4 PRJEB64798 3597 990 122.109458 1208.8836342 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 994 0   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g625 i4 87.346 110.281818181818 893 81 87 17 1 866 5032364 5033251 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 109179 994 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
23080814 23080814 PRJEB64798_P_NODE_38999_length_316_cov_9.640449_g37236_i0 PRJEB64798 38999 316 9.640449 30.46381884 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 159 1.69e-34   NTclustered gi|2874253918|emb|OY970243.1| 3107663 g37236 i0 76.508 20.5664556962025 315 60 97 13 5 312 3133045 3133352 MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 blastn 6499 159 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;