RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA909412", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJNA909412 · 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
5993962 5993962 PRJNA909412_P_NODE_7105_length_198_cov_2.088050_g6964_i0 PRJNA909412 7105 198 2.08805 4.134339 Leptospira cinconiae 3235173 Bacteria Bacteria 117 6e-22   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g6964 i0 92.593 40.540404040404 81 6 41 0 17 97 2586485 2586565 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 8027 117 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
27663881 27663881 PRJNA909412_P_NODE_5784_length_217_cov_2.719101_g5643_i0 PRJNA909412 5784 217 2.719101 5.90044917 Pseudomonadati 3379134 Bacteria Bacteria 101 1.1199999999999999e-23   NR MCQ2583283.1 166 g5643 i0 66.7 7.88018433179723 72 24 99.5 0 1 216 192 263 MCQ2583283.1 2-hydroxyacid dehydrogenase [Treponema sp.] diamond 1710 102 0.990196078431373 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29077275 29077275 PRJNA909412_P_NODE_2268_length_354_cov_6.057143_g2128_i0 PRJNA909412 2268 354 6.057143 21.44228622 Leptospiraceae bacterium 2026757 Bacteria Bacteria 67 2.23e-10   NR MCB1191003.1 2026757 g2128 i0 43.6 2.78813559322034 110 59 91.5 2 329 6 3 111 MCB1191003.1 50S ribosomal protein L2 [Leptospiraceae bacterium] diamond 987 67 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29361342 29361342 PRJNA909412_P_NODE_16269_length_152_cov_2.017699_g16128_i0 PRJNA909412 16269 152 2.017699 3.06690248 Spirochaetales bacterium 2026792 Bacteria Bacteria 60.1 8.1e-9   NR MBN2536430.1 2026792 g16128 i0 54.2 1.91447368421053 48 22 94.7 0 147 4 367 414 MBN2536430.1 VWA domain-containing protein [Spirochaetales bacterium] diamond 291 60.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29779158 29779158 PRJNA909412_P_NODE_3271_length_291_cov_1.805556_g3130_i0 PRJNA909412 3271 291 1.805556 5.25416796 Bacteria 2 Bacteria Bacteria 60.1 3.3e-8   NR MCL1865074.1 2202144 g3130 i0 31.2 4.84536082474227 93 60 95.9 1 8 286 146 234 MCL1865074.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 1410 60.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32301014 32301014 PRJNA909412_P_NODE_3699_length_273_cov_3.034188_g3558_i0 PRJNA909412 3699 273 3.034188 8.28333324 Spirochaetae bacterium HGW-Spirochaetae-5 2013837 Bacteria Bacteria 42.7 0.0413   NR PKL16907.1 2013837 g3558 i0 54.1 0.406593406593407 37 17 40.7 0 207 97 29 65 PKL16907.1 MAG: methyltransferase type 11 [Spirochaetae bacterium HGW-Spirochaetae-5] diamond 111 42.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-5

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