RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA994052 · 6 ✖

analysis 1

  • diamond · 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
29836880 29836880 PRJNA994052_P_NODE_74191_length_207_cov_58.492537_g72935_i0 PRJNA994052 74191 207 58.492537 121.07955159 Leptospira andrefontaineae 2484976 Bacteria Bacteria 42.7 0.023   NR WP_135775968.1 2484976 g72935 i0 44 0.72463768115942 50 27 71 1 44 190 472 521 WP_135775968.1 phage portal protein [Leptospira andrefontaineae] diamond 150 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira andrefontaineae
30152642 30152642 PRJNA994052_P_NODE_9952_length_340_cov_24.647940_g8746_i0 PRJNA994052 9952 340 24.64794 83.802996 Treponema endosymbiont of Eucomonympha sp. 1580831 Bacteria Bacteria 48.1 1.13e-4   NR WP_062326615.1 1580831 g8746 i0 42.7 1.32352941176471 75 37 66.2 3 106 330 4 72 WP_062326615.1 hypothetical protein [Treponema endosymbiont of Eucomonympha sp.] diamond 450 48.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema endosymbiont of Eucomonympha sp.
30847974 30847974 PRJNA994052_P_NODE_22674_length_302_cov_6.751092_g21445_i0 PRJNA994052 22674 302 6.751092 20.38829784 Leptospiraceae bacterium 2026757 Bacteria Bacteria 120 2.02e-29   NR HNF28214.1 2026757 g21445 i0 51.5 2.62251655629139 132 29 96.4 1 297 7 262 393 HNF28214.1 VapE family protein [Leptospiraceae bacterium] diamond 792 120 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30879507 30879507 PRJNA994052_P_NODE_48674_length_243_cov_51.629412_g47422_i0 PRJNA994052 48674 243 51.629412 125.45947116 Leptospiraceae bacterium 2026757 Bacteria Bacteria 65.1 4.65e-10   NR MBK8396143.1 2026757 g47422 i0 43.8 1.74074074074074 73 41 90.1 0 236 18 196 268 MBK8396143.1 coat protein [Leptospiraceae bacterium] diamond 423 65.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32176376 32176376 PRJNA994052_P_NODE_78898_length_202_cov_11.201550_g77641_i0 PRJNA994052 78898 202 11.20155 22.627131 Leptospiraceae bacterium 2026757 Bacteria Bacteria 95.1 5.37e-24   NR MBK8396224.1 2026757 g77641 i0 84.2 0.846534653465347 57 9 84.7 0 200 30 10 66 MBK8396224.1 hypothetical protein [Leptospiraceae bacterium] diamond 171 95.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32681560 32681560 PRJNA994052_P_NODE_57020_length_230_cov_57.254777_g55765_i0 PRJNA994052 57020 230 57.254777 131.6859871 Spirochaetota bacterium 2202144 Bacteria Bacteria 60.1 2.4e-8   NR TXG81302.1 2202144 g55765 i0 41.8 1.72173913043478 67 39 87.4 0 2 202 491 557 TXG81302.1 MAG: hypothetical protein E6R13_06460 [Spirochaetota bacterium] diamond 396 60.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium

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