RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA358009 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
29032998 29032998 PRJNA358009_P_NODE_9828_length_183_cov_5.574627_g9759_i0 PRJNA358009 9828 183 5.5746270000000004 10.20156741 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 95.5 4.8e-24   NR OHD15025.1 1802176 g9759 i0 92.3 0.852459016393443 52 4 85.2 0 3 158 13 64 OHD15025.1 MAG: hypothetical protein A2Y38_25765 [Spirochaetes bacterium GWB1_59_5] diamond 156 95.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
29159259 29159259 PRJNA358009_P_NODE_3549_length_327_cov_2.582734_g3486_i0 PRJNA358009 3549 327 2.582734 8.44554018 Rectinema sp. 1937017 Bacteria Bacteria 67 1.97e-11   NR MEN6296780.1 1937017 g3486 i0 96.9 0.293577981651376 32 1 29.4 0 97 2 104 135 MEN6296780.1 Hsp20/alpha crystallin family protein [Rectinema sp.] diamond 96 67 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae Rectinema Rectinema sp.
29222394 29222394 PRJNA358009_P_NODE_3029_length_327_cov_3.000000_g2966_i0 PRJNA358009 3029 327 3 9.81 Spirochaetota bacterium 2202144 Bacteria Bacteria 81.3 3.24e-15   NR HOJ62950.1 2202144 g2966 i0 43.9 0.981651376146789 107 15 98.2 2 327 7 1489 1550 HOJ62950.1 Ig-like domain-containing protein [Spirochaetota bacterium] diamond 321 81.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31243857 31243857 PRJNA358009_P_NODE_16075_length_161_cov_3.526786_g16006_i0 PRJNA358009 16075 161 3.526786 5.67812546 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 84.7 1.95e-17   NR OHD15058.1 1802176 g16006 i0 80.4 1.90062111801242 51 10 95 0 154 2 1180 1230 OHD15058.1 MAG: hypothetical protein A2Y38_25950 [Spirochaetes bacterium GWB1_59_5] diamond 306 84.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
32400064 32400064 PRJNA358009_P_NODE_13919_length_165_cov_2.241379_g13850_i0 PRJNA358009 13919 165 2.241379 3.69827535 Pseudomonadati 3379134 Bacteria Bacteria 44.7 0.0013   NR MAI26614.1 28185 g13850 i0 78.3 1.2 23 5 41.8 0 97 165 2 24 MAI26614.1 deoxycytidylate deaminase [Spirochaeta sp.] diamond 198 44.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta sp.

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