RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA596870" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA596870 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
3119723 3119723 PRJNA596870_P_NODE_7643_length_448_cov_1.472000_g7510_i0 PRJNA596870 7643 448 1.472 6.59456 Spirochaetales bacterium 2026792 Bacteria Bacteria 185 2.81e-51   NR NMC68367.1 2026792 g7510 i0 70.1 5.97991071428571 127 38 85 0 381 1 3 129 NMC68367.1 pyruvate, phosphate dikinase [Spirochaetales bacterium] diamond 2679 185 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28153881 28153881 PRJNA596870_P_NODE_29425_length_251_cov_0.865169_g29292_i0 PRJNA596870 29425 251 0.865169 2.17157419 Spirochaetota bacterium 2202144 Bacteria Bacteria 126 5.9e-34   NR MBE3064887.1 2202144 g29292 i0 81.5 4.86454183266932 81 15 96.8 0 247 5 155 235 MBE3064887.1 ribokinase [Spirochaetota bacterium] diamond 1221 126 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29763740 29763740 PRJNA596870_P_NODE_11991_length_370_cov_0.993266_g11858_i0 PRJNA596870 11991 370 0.993266 3.6750842 Spirochaetia bacterium 2053615 Bacteria Bacteria 112 1.83e-29   NR MFO7729640.1 2053615 g11858 i0 93.3 0.486486486486487 60 2 48.6 1 181 2 9 66 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 180 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29763751 29763751 PRJNA596870_P_NODE_6531_length_479_cov_1.896552_g6398_i0 PRJNA596870 6531 479 1.896552 9.08448408 Leptospira sp. 178 Bacteria Bacteria 115 9.23e-28   NR MCC5816713.1 178 g6398 i0 52.1 0.732776617954071 117 55 72.7 1 381 34 2 118 MCC5816713.1 SDR family NAD(P)-dependent oxidoreductase [Leptospira sp.] diamond 351 115 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira 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);;