RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA627467", tax_kingdom = "Bacillati" and tax_phylum = "Vulcanimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Vulcanimicrobiota · 5 ✖

tax_kingdom 1

  • Bacillati · 5 ✖

bioproject 1

  • PRJNA627467 · 5 ✖

analysis 1

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
1875183 1875183 PRJNA627467_P_NODE_10462_length_186_cov_1.788321_g10393_i0 PRJNA627467 10462 186 1.788321 3.32627706 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 302 1.43e-77   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g10393 i0 96.685 537.725806451613 181 6 97 0 1 181 5033597 5033777 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 100017 302 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
12078656 12078656 PRJNA627467_P_NODE_6350_length_297_cov_4.685484_g6282_i0 PRJNA627467 6350 297 4.685484 13.91588748 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 414 3.05e-111   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g6282 i0 93.007 38.040404040404 286 17 96 3 13 297 5032789 5032506 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 11298 414 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
15902123 15902123 PRJNA627467_P_NODE_18113_length_163_cov_2.543860_g18044_i0 PRJNA627467 18113 163 2.54386 4.1464918 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 230 5.8499999999999985e-56   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g18044 i0 92.025 294.693251533742 163 13 100 0 1 163 5031915 5031753 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 48035 230 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
15902232 15902232 PRJNA627467_P_NODE_8413_length_206_cov_5.713376_g8344_i0 PRJNA627467 8413 206 5.713376 11.76955456 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 279 7.59e-71   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g8344 i0 91.626 283.466019417476 203 15 99 2 4 206 5032974 5033174 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 58394 279 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
17177113 17177113 PRJNA627467_P_NODE_18474_length_162_cov_5.336283_g18405_i0 PRJNA627467 18474 162 5.336283 8.64477846 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 263 5.72e-66   NTclustered gi|2202949261|emb|OV972893.1| 3107663 g18405 i0 97.403 459.759259259259 154 4 95 0 9 162 5032169 5032016 MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 blastn 74481 263 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);;