RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA1150539", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 9 ✖

tax_kingdom 1

  • Pseudomonadati · 9 ✖

bioproject 1

  • PRJNA1150539 · 9 ✖

analysis 1

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
1576200 1576200 PRJNA1150539_S_NODE_70242_length_279_cov_2.325243_g69646_i0 PRJNA1150539 70242 279 2.325243 6.48742797 Treponema sp. 166 Bacteria Bacteria 191 8.76e-56   NR MBQ1972198.1 166 g69646 i0 100 0.989247311827957 92 0 98.9 0 3 278 13 104 MBQ1972198.1 2-isopropylmalate synthase [Treponema sp.] diamond 276 191 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
23253430 23253430 PRJNA1150539_S_NODE_29379_length_354_cov_3.658363_g28783_i0 PRJNA1150539 29379 354 3.658363 12.95060502 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 234 3.04e-71   NR MBQ8384626.1 1898206 g28783 i0 97.4 1.98305084745763 117 3 99.2 0 3 353 111 227 MBQ8384626.1 site-specific DNA-methyltransferase [Spirochaetaceae bacterium] diamond 702 234 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
27071828 27071828 PRJNA1150539_S_NODE_111062_length_217_cov_5.111111_g110466_i0 PRJNA1150539 111062 217 5.111111 11.09111087 Leptospira sp. 178 Bacteria Bacteria 109 6.08e-26   NR MCC5816350.1 178 g110466 i0 73.2 0.981566820276498 71 19 98.2 0 3 215 381 451 MCC5816350.1 hypothetical protein [Leptospira sp.] diamond 213 109 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
27261636 27261636 PRJNA1150539_S_NODE_84823_length_260_cov_1.155080_g84227_i0 PRJNA1150539 84823 260 1.15508 3.003208 Treponema porcinum 261392 Bacteria Bacteria 112 1.95e-27   NR MCI5644986.1 261392 g84227 i0 96.2 1.83461538461538 53 2 61.2 0 161 3 300 352 MCI5644986.1 ABC transporter substrate-binding protein [Treponema porcinum] diamond 477 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema porcinum
27324810 27324810 PRJNA1150539_S_NODE_38103_length_334_cov_1.068966_g37507_i0 PRJNA1150539 38103 334 1.068966 3.57034644 Treponema porcinum 261392 Bacteria Bacteria 89.7 4.8100000000000005e-21   NR WP_143593185.1 261392 g37507 i0 100 0.377245508982036 42 0 37.7 0 1 126 31 72 WP_143593185.1 hypothetical protein [Treponema porcinum] diamond 126 89.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema porcinum
27482713 27482713 PRJNA1150539_S_NODE_93243_length_250_cov_1.305085_g92647_i0 PRJNA1150539 93243 250 1.305085 3.2627125 Treponema sp. 166 Bacteria Bacteria 162 4.85e-44   NR MBQ1174878.1 166 g92647 i0 100 0.972 81 0 97.2 0 248 6 699 779 MBQ1174878.1 SpoIIE family protein phosphatase [Treponema sp.] diamond 243 162 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29787431 29787431 PRJNA1150539_S_NODE_87691_length_256_cov_2.420765_g87095_i0 PRJNA1150539 87691 256 2.420765 6.1971584 Brevinematales bacterium 2614249 Bacteria Bacteria 43.1 0.0332   NR MCX7882531.1 2614249 g87095 i0 35.3 0.796875 68 42 78.5 2 44 244 98 164 MCX7882531.1 OmpA family protein [Brevinematales bacterium] diamond 204 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brevinematales     Brevinematales bacterium
30925191 30925191 PRJNA1150539_S_NODE_54474_length_303_cov_3.591304_g53878_i0 PRJNA1150539 54474 303 3.591304 10.88165112 Treponema sp. 166 Bacteria Bacteria 202 1.1399999999999999e-62   NR MBR0545431.1 166 g53878 i0 97 0.99009900990099 100 3 99 0 3 302 69 168 MBR0545431.1 hypothetical protein [Treponema sp.] diamond 300 202 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32221626 32221626 PRJNA1150539_S_NODE_80898_length_265_cov_1.203125_g80302_i0 PRJNA1150539 80898 265 1.203125 3.18828125 Spirochaetes bacterium RIFOXYB1_FULL_32_8 1802197 Bacteria Bacteria 42.7 0.0491   NR OHD80410.1 1802197 g80302 i0 43.1 0.577358490566038 51 25 53.2 1 40 180 53 103 OHD80410.1 MAG: hypothetical protein A2355_13075 [Spirochaetes bacterium RIFOXYB1_FULL_32_8] diamond 153 42.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RIFOXYB1_FULL_32_8

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