RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA450632" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA450632 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
30329379 30329379 PRJNA450632_P_NODE_20852_length_164_cov_1.240310_g20673_i0 PRJNA450632 20852 164 1.24031 2.0341084 Terracoccus sp. 1871061 Bacteria Bacteria 41.2 0.0416   NR MEO5745467.1 1871061 g20673 i0 61.8 1.24390243902439 34 13 62.2 0 125 24 12 45 MEO5745467.1 tetratricopeptide repeat protein [Terracoccus sp.] diamond 204 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Terracoccus Terracoccus sp.
30392490 30392490 PRJNA450632_P_NODE_18673_length_177_cov_0.964789_g18494_i0 PRJNA450632 18673 177 0.964789 1.70767653 Candidatus Dormiibacterota bacterium 2052315 Bacteria Bacteria 42.4 0.0208   NR MDQ6919382.1 2052315 g18494 i0 51.1 0.796610169491525 47 23 79.7 0 5 145 157 203 MDQ6919382.1 siroheme synthase CysG [Candidatus Dormiibacterota bacterium] diamond 141 42.4 1 Bacteria   Bacillati Candidatus Dormiibacterota         Candidatus Dormiibacterota bacterium
32162657 32162657 PRJNA450632_P_NODE_11358_length_246_cov_2.658768_g11179_i0 PRJNA450632 11358 246 2.658768 6.54056928 Streptomyces bambusae 1550616 Bacteria Bacteria 45.4 0.00441   NR WP_226734668.1 1550616 g11179 i0 51.3 0.475609756097561 39 19 47.6 0 19 135 255 293 WP_226734668.1 pentapeptide repeat-containing protein [Streptomyces bambusae] diamond 117 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces bambusae

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