RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1126661" 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

  • PRJNA1126661 · 6 ✖

analysis 1

  • blastn · 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
2832986 2832986 PRJNA1126661_P_NODE_30543_length_326_cov_1.802372_g30014_i0 PRJNA1126661 30543 326 1.802372 5.87573272 Leptospira mgodei 3235172 Bacteria Bacteria 268 2.7999999999999998e-67   NTclustered gi|2777195838|gb|CP162139.1| 3235172 g30014 i0 98.675 0.46319018404908 151 2 46 0 1 151 2518928 2518778 Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence blastn 151 268 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira mgodei
4109287 4109287 PRJNA1126661_P_NODE_28264_length_326_cov_2.822134_g27735_i0 PRJNA1126661 28264 326 2.822134 9.20015684 Leptospira cinconiae 3235173 Bacteria Bacteria 279 1.29e-70   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g27735 i0 100 0.926380368098159 151 0 93 0 176 326 2881758 2881608 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 302 279 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
9959032 9959032 PRJNA1126661_P_NODE_30948_length_325_cov_5.638889_g30419_i0 PRJNA1126661 30948 325 5.638889 18.32638925 Treponema 157 Bacteria Bacteria 272 2.1499999999999996e-68   NTclustered gi|1996291085|gb|CP027017.1| 58231 g30419 i0 99.333 12.0123076923077 150 1 92 0 1 150 1801015 1800866 Treponema medium strain T19 chromosome, complete genome blastn 3904 272 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
20683825 20683825 PRJNA1126661_P_NODE_35857_length_301_cov_5.548246_g35328_i0 PRJNA1126661 35857 301 5.548246 16.70022046 Leptospira mgodei 3235172 Bacteria Bacteria 283 9.12e-72   NTclustered gi|2777195838|gb|CP162139.1| 3235172 g35328 i0 100 1.00996677740864 153 0 100 0 149 301 3184908 3184756 Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence blastn 304 283 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira mgodei
23983293 23983293 PRJNA1126661_P_NODE_43539_length_300_cov_4.718062_g43010_i0 PRJNA1126661 43539 300 4.718062 14.154186 Leptospira 171 Bacteria Bacteria 279 1.18e-70   NTclustered gi|2330606|emb|Z98588.1| 172 g43010 i0 100 93.1633333333333 151 0 100 0 1 151 261 411 Leptospira biflexa 16S ribosomal RNA, mutant 3/1994 blastn 27949 279 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira biflexa
24508702 24508702 PRJNA1126661_P_NODE_67820_length_259_cov_1.677419_g67290_i0 PRJNA1126661 67820 259 1.677419 4.34451521 Leptospira mgodei 3235172 Bacteria Bacteria 462 9.2e-126   NTclustered gi|2777195838|gb|CP162139.1| 3235172 g67290 i0 98.842 2.15057915057915 259 3 100 0 1 259 1923003 1922745 Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence blastn 557 462 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira mgodei

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