RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA169559" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 3 ✖

bioproject 1

  • PRJNA169559 · 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
27926758 27926758 PRJNA169559_P_NODE_1665_length_1278_cov_3.875901_g981_i0 PRJNA169559 1665 1278 3.875901 49.53401478 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 2013741 Bacteria Bacteria 139 1.36e-32   NR PKN55183.1 2013741 g981 i0 36.2 1.4037558685446 271 140 57.7 8 272 1009 170 432 PKN55183.1 MAG: hypothetical protein CVU56_22585 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] diamond 1794 139 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
32209850 32209850 PRJNA169559_P_NODE_23218_length_325_cov_2.645270_g21146_i0 PRJNA169559 23218 325 2.64527 8.5971275 Myxococcota 2818505 Bacteria Bacteria 47.8 0.0016   NR OQB16247.1 1852869 g21146 i0 41 2.76923076923077 78 34 68.3 6 318 97 220 289 OQB16247.1 MAG: hypothetical protein BWY17_01920 [Deltaproteobacteria bacterium ADurb.Bin207] diamond 900 48.1 0.993762993762994 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin207
32697468 32697468 PRJNA169559_P_NODE_1700_length_1269_cov_4.000806_g981_i1 PRJNA169559 1700 1269 4.000806 50.77022814 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 2013741 Bacteria Bacteria 142 5.07e-34   NR PKN55183.1 2013741 g981 i1 35.8 2.01891252955083 271 138 57.4 7 272 1000 170 432 PKN55183.1 MAG: hypothetical protein CVU56_22585 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] diamond 2562 142 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14

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