RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA565584 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
5658388 5658388 PRJNA565584_P_NODE_119445_length_282_cov_1.473684_g118293_i0 PRJNA565584 119445 282 1.473684 4.15578888 Leptospira mgodei 3235172 Bacteria Bacteria 516 7.67e-142   NTclustered gi|2777195838|gb|CP162139.1| 3235172 g118293 i0 99.645 1 282 1 100 0 1 282 1824465 1824184 Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence blastn 282 516 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira mgodei
5661668 5661668 PRJNA565584_P_NODE_92485_length_310_cov_2.746835_g91333_i0 PRJNA565584 92485 310 2.746835 8.5151885 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 464 3.14e-126   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g91333 i0 92.605 3.10322580645161 311 21 99 1 2 310 2464696 2465006 Treponema sp. Marseille-Q4132 chromosome blastn 962 464 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
10062584 10062584 PRJNA565584_P_NODE_146528_length_264_cov_2.204188_g145376_i0 PRJNA565584 146528 264 2.204188 5.81905632 Treponema 157 Bacteria Bacteria 466 7.27e-127   NTclustered gi|719625061|gb|CP009227.1| 1539298 g145376 i0 98.485 12.9734848484848 264 4 100 0 1 264 1125897 1125634 Treponema sp. OMZ 838, complete genome blastn 3425 466 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 838
10759308 10759308 PRJNA565584_P_NODE_135489_length_272_cov_1.185930_g134337_i0 PRJNA565584 135489 272 1.18593 3.2257296 Leptospira cinconiae 3235173 Bacteria Bacteria 497 2.67e-136   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g134337 i0 99.632 1 272 1 100 0 1 272 1335280 1335009 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 272 497 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
17132364 17132364 PRJNA565584_P_NODE_123494_length_279_cov_2.733010_g122342_i0 PRJNA565584 123494 279 2.73301 7.6250979 Treponema vincentii 69710 Bacteria Bacteria 433 7.85e-117   NTclustered gi|2034589463|gb|CP050497.1| 69710 g122342 i0 94.624 5 279 15 100 0 1 279 1181273 1181551 Treponema vincentii strain OMZ 806 chromosome, complete genome blastn 1395 433 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
17712392 17712392 PRJNA565584_P_NODE_196574_length_245_cov_0.895349_g195422_i0 PRJNA565584 196574 245 0.895349 2.19360505 Treponema 157 Bacteria Bacteria 147 9.86e-31   NTclustered gi|2265141765|gb|CP051199.1| 2563664 g195422 i0 98.78 40.9836734693878 82 1 61 0 61 142 1330157 1330238 Treponema sp. OMZ 788 chromosome, complete genome blastn 10041 147 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 788
19682248 19682248 PRJNA565584_P_NODE_183196_length_248_cov_0.880000_g182044_i0 PRJNA565584 183196 248 0.88 2.1824 Treponema vincentii 69710 Bacteria Bacteria 453 5.2600000000000005e-123   NTclustered gi|2265115921|gb|CP051153.1| 69710 g182044 i0 99.597 5 248 1 100 0 1 248 2423206 2423453 Treponema vincentii strain OMZ 862 chromosome, complete genome blastn 1240 453 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii

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