RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA608660" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA608660 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
3135473 3135473 PRJNA608660_P_NODE_21143_length_304_cov_1.345098_g20787_i0 PRJNA608660 21143 304 1.345098 4.08909792 Sphaerochaeta sp. 1972642 Bacteria Bacteria 130 3.3e-36   NR MCK9601264.1 1972642 g20787 i0 95.4 0.641447368421053 65 3 64.1 0 17 211 28 92 MCK9601264.1 hypothetical protein [Sphaerochaeta sp.] diamond 195 130 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
26921925 26921925 PRJNA608660_P_NODE_1482_length_989_cov_17.611702_g1318_i0 PRJNA608660 1482 989 17.611702 174.17973278 Leptospira wolbachii 29511 Bacteria Bacteria 329 2.3599999999999994e-110   NR WP_015682231.1 29511 g1318 i0 96.5 0.51567239635996 170 6 51.6 0 525 16 10 179 WP_015682231.1 hypothetical protein [Leptospira wolbachii] diamond 510 329 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira wolbachii
26921927 26921927 PRJNA608660_P_NODE_45322_length_169_cov_2.650000_g44965_i0 PRJNA608660 45322 169 2.65 4.4785 Spirochaetota bacterium 2202144 Bacteria Bacteria 51.6 9.73e-6   NR MCL1992853.1 2202144 g44965 i0 44.4 0.958579881656805 54 30 95.9 0 1 162 222 275 MCL1992853.1 UbiA family prenyltransferase [Spirochaetota bacterium] diamond 162 51.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27174726 27174726 PRJNA608660_P_NODE_51102_length_152_cov_2.019417_g50745_i0 PRJNA608660 51102 152 2.019417 3.06951384 Leptospira sanjuanensis 2879643 Bacteria Bacteria 40.4 0.0346   NR WP_238731722.1 2879643 g50745 i0 47.4 0.75 38 20 75 0 35 148 80 117 WP_238731722.1 LBF_4227 family protein [Leptospira sanjuanensis] diamond 114 40.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sanjuanensis
27869650 27869650 PRJNA608660_P_NODE_42925_length_177_cov_2.437500_g42568_i0 PRJNA608660 42925 177 2.4375 4.314375 Treponema sp. 166 Bacteria Bacteria 80.5 7.46e-16   NR MFC2329926.1 166 g42568 i0 92.5 0.677966101694915 40 3 67.8 0 56 175 403 442 MFC2329926.1 glycogen/starch/alpha-glucan phosphorylase [Treponema sp.] diamond 120 80.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29132900 29132900 PRJNA608660_P_NODE_48969_length_163_cov_1.368421_g48612_i0 PRJNA608660 48969 163 1.368421 2.23052623 Spirochaetota bacterium 2202144 Bacteria Bacteria 41.2 0.0446   NR MEW5814881.1 2202144 g48612 i0 37.5 0.736196319018405 40 25 73.6 0 38 157 57 96 MEW5814881.1 sugar ABC transporter permease [Spirochaetota bacterium] diamond 120 41.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium

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