RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB50765" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 5 ✖

bioproject 1

  • PRJEB50765 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
28044268 28044268 PRJEB50765_P_NODE_2645_length_172_cov_1.140741_g2621_i0 PRJEB50765 2645 172 1.140741 1.96207452 Coriobacteriales bacterium 2478480 Bacteria Bacteria 47.8 2.47e-4   NR MDR3315660.1 2478480 g2621 i0 53.1 1.11627906976744 32 15 55.8 0 172 77 459 490 MDR3315660.1 RICIN domain-containing protein [Coriobacteriales bacterium] diamond 192 47.8 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales     Coriobacteriales bacterium
28732236 28732236 PRJEB50765_P_NODE_1827_length_216_cov_1.296089_g1803_i0 PRJEB50765 1827 216 1.296089 2.79955224 Bacteria 2 Bacteria Bacteria 45.1 0.00423   NR WP_027086007.1 400776 g1803 i0 44.6 2.45833333333333 56 31 77.8 0 31 198 854 909 WP_027086007.1 carboxypeptidase regulatory-like domain-containing protein [Cohnella panacarvi] diamond 531 45.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella panacarvi
31132350 31132350 PRJEB50765_P_NODE_2475_length_179_cov_1.352113_g2451_i0 PRJEB50765 2475 179 1.352113 2.42028227 Bacillota 1239 Bacteria Bacteria 93.2 9.42e-21   NR WP_328207969.1 1422 g2451 i0 81.4 57.2011173184358 59 11 98.9 0 1 177 101 159 WP_328207969.1 Hsp70 family protein, partial [Geobacillus stearothermophilus] diamond 10239 93.6 0.995726495726496 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus stearothermophilus
31993337 31993337 PRJEB50765_P_NODE_3038_length_158_cov_1.256198_g3014_i0 PRJEB50765 3038 158 1.256198 1.98479284 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 80.5 2.81e-16   NR MBX9694561.1 2847862 g3014 i0 75 0.987341772151899 52 13 98.7 0 2 157 24 75 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 156 80.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32745225 32745225 PRJEB50765_P_NODE_3040_length_158_cov_0.958678_g3016_i0 PRJEB50765 3040 158 0.958678 1.51471124 PVC group 1783257 Bacteria Bacteria 73.6 7.05e-14   NR MDA1175223.1 2026724 g3016 i0 64.7 9.6645569620253209 51 18 96.8 0 6 158 132 182 MDA1175223.1 aldolase/citrate lyase family protein [Chloroflexota bacterium] diamond 1527 73.9 0.995940460081191 Bacteria   Bacillati Chloroflexota         Chloroflexota 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);;