RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1093008" 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

  • PRJNA1093008 · 4 ✖

analysis 1

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
5301885 5301885 PRJNA1093008_S_NODE_99545_length_230_cov_2.452229_g99218_i0 PRJNA1093008 99545 230 2.452229 5.6401267 Treponema sp. 166 Bacteria Bacteria 139 1.8199999999999999e-40   NR MDY5831685.1 166 g99218 i0 100 0.88695652173913 68 0 88.7 0 27 230 59 126 MDY5831685.1 hypothetical protein [Treponema sp.] diamond 204 139 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27691149 27691149 PRJNA1093008_S_NODE_85544_length_248_cov_1.320000_g85217_i0 PRJNA1093008 85544 248 1.32 3.2736 Treponema 157 Bacteria Bacteria 110 4.96e-26   NR MBR0544875.1 166 g85217 i0 100 5.03225806451613 52 0 62.9 0 245 90 457 508 MBR0544875.1 hypothetical protein [Treponema sp.] diamond 1248 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30794199 30794199 PRJNA1093008_S_NODE_97054_length_238_cov_3.266667_g96727_i0 PRJNA1093008 97054 238 3.266667 7.77466746 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 42.4 0.0485   NR MBP7480259.1 1898206 g96727 i0 41.3 0.579831932773109 46 26 56.7 1 222 88 242 287 MBP7480259.1 NAD(+) synthase [Spirochaetaceae bacterium] diamond 138 42.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31268329 31268329 PRJNA1093008_S_NODE_66575_length_269_cov_1.571429_g66248_i0 PRJNA1093008 66575 269 1.571429 4.22714401 Leptospira soteropolitanensis 2950025 Bacteria Bacteria 40.8 0.0491   NR WP_265351254.1 2950025 g66248 i0 40.4 0.524163568773234 47 28 52.4 0 239 99 31 77 WP_265351254.1 SemiSWEET transporter [Leptospira soteropolitanensis] diamond 141 40.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira soteropolitanensis

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