RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA785164 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
5869964 5869964 PRJNA785164_P_NODE_51265_length_251_cov_0.865169_g50800_i0 PRJNA785164 51265 251 0.865169 2.17157419 Leptospira mgodei 3235172 Bacteria Bacteria 448 2.48e-121   NTclustered gi|2777195838|gb|CP162139.1| 3235172 g50800 i0 98.805 1 251 3 100 0 1 251 2600082 2600332 Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence blastn 251 448 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira mgodei
7145018 7145018 PRJNA785164_P_NODE_54606_length_248_cov_0.880000_g54141_i0 PRJNA785164 54606 248 0.88 2.1824 Leptospira mgodei 3235172 Bacteria Bacteria 453 5.2600000000000005e-123   NTclustered gi|2777195838|gb|CP162139.1| 3235172 g54141 i0 99.597 1 248 1 100 0 1 248 3507865 3507618 Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence blastn 248 453 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira mgodei
12246292 12246292 PRJNA785164_P_NODE_58450_length_244_cov_0.900585_g57985_i0 PRJNA785164 58450 244 0.900585 2.1974274 Leptospira mgodei 3235172 Bacteria Bacteria 451 1.86e-122   NTclustered gi|2777195838|gb|CP162139.1| 3235172 g57985 i0 100 6.83606557377049 244 0 100 0 1 244 479236 479479 Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence blastn 1668 451 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira mgodei
14794712 14794712 PRJNA785164_P_NODE_36372_length_300_cov_1.017621_g35907_i0 PRJNA785164 36372 300 1.017621 3.052863 Leptospira mgodei 3235172 Bacteria Bacteria 488 1.7899999999999996e-133   NTclustered gi|2777195838|gb|CP162139.1| 3235172 g35907 i0 96 1.09333333333333 300 12 100 0 1 300 1411621 1411322 Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence blastn 328 488 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);;