RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA760904", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_clade 1

  • delta/epsilon subdivisions · 4 ✖

bioproject 1

  • PRJNA760904 · 4 ✖

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
29011404 29011404 PRJNA760904_P_NODE_19928_length_242_cov_0.911243_g19871_i0 PRJNA760904 19928 242 0.911243 2.20520806 Bradymonas sediminis 1548548 Bacteria Bacteria 83.2 1.49e-16   NR WP_111334596.1 1548548 g19871 i0 50.6 4.90909090909091 79 36 97.9 1 5 241 190 265 WP_111334596.1 lipid-transfer protein [Bradymonas sediminis] diamond 1188 83.2 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Bradymonadaceae Bradymonas Bradymonas sediminis
29137601 29137601 PRJNA760904_P_NODE_11749_length_273_cov_0.920000_g11692_i0 PRJNA760904 11749 273 0.92 2.5116 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-11 2013738 Bacteria Bacteria 74.3 2.47e-13   NR PKN60813.1 2013738 g11692 i0 42.5 1.74725274725275 80 45 87.9 1 3 242 160 238 PKN60813.1 MAG: hypothetical protein CVU53_01135 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-11] diamond 477 74.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-11
29494357 29494357 PRJNA760904_P_NODE_4790_length_387_cov_1.487261_g4733_i0 PRJNA760904 4790 387 1.487261 5.75570007 Pseudomonadota 1224 Bacteria Bacteria 108 1.24e-24   NR WP_163297993.1 1765737 g4733 i0 51.4 5.4031007751938 111 40 86 2 335 3 726 822 WP_163297993.1 response regulator [Dissulfurirhabdus thermomarina] diamond 2091 108 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria   Dissulfurirhabdaceae Dissulfurirhabdus Dissulfurirhabdus thermomarina
31253759 31253759 PRJNA760904_P_NODE_1635_length_611_cov_2.613383_g1581_i0 PRJNA760904 1635 611 2.613383 15.96777013 Persicimonas caeni 2292766 Bacteria Bacteria 64.7 3.29e-8   NR WP_141197549.1 2292766 g1581 i0 30.7 1.53682487725041 127 78 62.4 3 189 569 467 583 WP_141197549.1 IPT/TIG domain-containing protein [Persicimonas caeni] diamond 939 64.7 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Bradymonadaceae Persicimonas Persicimonas caeni

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