RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA796753", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 3 ✖

tax_clade 1

  • delta/epsilon subdivisions · 3 ✖

bioproject 1

  • PRJNA796753 · 3 ✖

analysis 1

tax_phylum 0

tax_kingdom 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
19907379 19907379 PRJNA796753_P_NODE_10836_length_422_cov_4.292264_g10524_i0 PRJNA796753 10836 422 4.292264 18.11335408 Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 1797895 Bacteria Bacteria 114 1e-29   NR OGQ88263.1 1797895 g10524 i0 61.2 1.19431279620853 85 33 60.4 0 53 307 5 89 OGQ88263.1 MAG: RNA-binding protein [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 504 114 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
30401919 30401919 PRJNA796753_P_NODE_6313_length_539_cov_2.828326_g6005_i0 PRJNA796753 6313 539 2.828326 15.24467714 Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 1797895 Bacteria Bacteria 114 5.37e-29   NR OGQ88263.1 1797895 g6005 i0 61.2 0.935064935064935 85 33 47.3 0 487 233 5 89 OGQ88263.1 MAG: RNA-binding protein [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] diamond 504 114 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
30442263 30442263 PRJNA796753_P_NODE_32493_length_272_cov_1.231156_g32181_i0 PRJNA796753 32493 272 1.231156 3.34874432 Bacteria 2 Bacteria Bacteria 74.7 2.17e-13   NR OGQ06247.1 1797856 g32181 i0 38.2 3.90441176470588 89 55 98.2 0 3 269 246 334 OGQ06247.1 MAG: hypothetical protein A2712_05160 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49] diamond 1062 74.7 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49

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