RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA399711 · 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
25561944 25561944 PRJNA399711_S_NODE_109225_length_150_cov_2.911504_g109083_i0 PRJNA399711 109225 150 2.911504 4.367256 Leptospira cinconiae 3235173 Bacteria Bacteria 202 1.15e-47   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g109083 i0 91.724 0.966666666666667 145 12 97 0 1 145 217965 218109 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 145 202 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
25565320 25565320 PRJNA399711_S_NODE_94177_length_158_cov_4.272727_g94035_i0 PRJNA399711 94177 158 4.272727 6.75090866 Leptospira cinconiae 3235173 Bacteria Bacteria 204 3.4099999999999996e-48   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g94035 i0 90.385 0.987341772151899 156 14 98 1 1 155 2354460 2354615 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 156 204 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
25837563 25837563 PRJNA399711_S_NODE_94627_length_158_cov_2.603306_g94485_i0 PRJNA399711 94627 158 2.603306 4.11322348 Leptospira cinconiae 3235173 Bacteria Bacteria 198 1.5899999999999999e-46   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g94485 i0 89.241 1 158 17 100 0 1 158 328631 328474 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 158 198 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
25970431 25970431 PRJNA399711_S_NODE_109076_length_150_cov_3.345133_g108934_i0 PRJNA399711 109076 150 3.345133 5.0176995 Spirochaetota bacterium 2202144 Bacteria Bacteria 60.2 7.3e-5   NTclustered gi|1869993210|dbj|AP019861.1| 2202144 g108934 i0 100 0.42 32 0 21 0 24 55 477545 477514 Spirochaetes bacterium COTS27 DNA, nearly complete genome blastn 63 60.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
26242512 26242512 PRJNA399711_S_NODE_107238_length_151_cov_2.631579_g107096_i0 PRJNA399711 107238 151 2.631579 3.97368429 Leptospira cinconiae 3235173 Bacteria Bacteria 163 5.4600000000000004e-36   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g107096 i0 88.235 0.900662251655629 136 16 90 0 1 136 1216497 1216362 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 136 163 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
26515783 26515783 PRJNA399711_S_NODE_32520_length_232_cov_2.938462_g32378_i0 PRJNA399711 32520 232 2.938462 6.81723184 Leptospira cinconiae 3235173 Bacteria Bacteria 193 1.17e-44   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g32378 i0 82.883 0.956896551724138 222 30 94 8 2 219 1383750 1383967 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 222 193 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae

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