RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA474426" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA474426 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
26854988 26854988 PRJNA474426_P_NODE_34301_length_165_cov_0.887931_g34096_i0 PRJNA474426 34301 165 0.887931 1.46508615 Spirochaetota bacterium 2202144 Bacteria Bacteria 59.3 1.5e-8   NR TXG85857.1 2202144 g34096 i0 74.3 0.636363636363636 35 9 63.6 0 48 152 1 35 TXG85857.1 MAG: hypothetical protein E6R13_01545 [Spirochaetota bacterium] diamond 105 59.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
26886626 26886626 PRJNA474426_P_NODE_34321_length_165_cov_0.887931_g34116_i0 PRJNA474426 34321 165 0.887931 1.46508615 Spirochaetota bacterium 2202144 Bacteria Bacteria 53.1 2.72e-6   NR TXG85896.1 2202144 g34116 i0 60 0.818181818181818 45 17 80 1 33 164 1730 1774 TXG85896.1 MAG: hypothetical protein E6R13_01505, partial [Spirochaetota bacterium] diamond 135 53.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27471702 27471702 PRJNA474426_P_NODE_16223_length_255_cov_1.247573_g16018_i0 PRJNA474426 16223 255 1.247573 3.18131115 Leptospira 171 Bacteria Bacteria 143 8.789999999999998e-39   NR WP_135738905.1 172 g16018 i0 95.8 2.50588235294118 71 3 83.5 0 2 214 352 422 WP_135738905.1 porin [Leptospira biflexa] diamond 639 144 0.993055555555556 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira biflexa
27613506 27613506 PRJNA474426_P_NODE_30564_length_173_cov_1.258065_g30359_i0 PRJNA474426 30564 173 1.258065 2.17645245 Spirochaetota bacterium 2202144 Bacteria Bacteria 64.7 4.23e-12   NR TXG86431.1 2202144 g30359 i0 100 0.502890173410405 29 0 50.3 0 3 89 37 65 TXG86431.1 MAG: hypothetical protein E6R13_00415 [Spirochaetota bacterium] diamond 87 64.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28402715 28402715 PRJNA474426_P_NODE_21506_length_214_cov_1.581818_g21301_i0 PRJNA474426 21506 214 1.581818 3.38509052 Leptospira biflexa 172 Bacteria Bacteria 60.1 1.59e-8   NR WP_135578471.1 172 g21301 i0 58 1.4018691588785 50 14 61.7 2 181 50 50 98 WP_135578471.1 aldose 1-epimerase [Leptospira biflexa] diamond 300 60.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira biflexa
28718534 28718534 PRJNA474426_P_NODE_33727_length_166_cov_0.871795_g33522_i0 PRJNA474426 33727 166 0.871795 1.4471797 Treponema sp. 166 Bacteria Bacteria 117 9.81e-30   NR MFC2602618.1 166 g33522 i0 100 0.993975903614458 55 0 99.4 0 2 166 79 133 MFC2602618.1 pyridoxal phosphate-dependent aminotransferase [Treponema sp.] diamond 165 117 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29286649 29286649 PRJNA474426_P_NODE_36629_length_162_cov_0.911504_g36424_i0 PRJNA474426 36629 162 0.911504 1.47663648 Spirochaetota bacterium 2202144 Bacteria Bacteria 87.8 1.68e-18   NR TXG80592.1 2202144 g36424 i0 93.5 0.851851851851852 46 3 85.2 0 162 25 303 348 TXG80592.1 MAG: hypothetical protein E6R13_07820 [Spirochaetota bacterium] diamond 138 87.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29602184 29602184 PRJNA474426_P_NODE_36690_length_162_cov_0.902655_g36485_i0 PRJNA474426 36690 162 0.902655 1.4623011 Spirochaetota bacterium 2202144 Bacteria Bacteria 59.7 4.38e-10   NR MDH4127119.1 2202144 g36485 i0 82.9 0.648148148148148 35 6 64.8 0 151 47 43 77 MDH4127119.1 hypothetical protein [Spirochaetota bacterium] diamond 105 59.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30471660 30471660 PRJNA474426_P_NODE_12573_length_297_cov_2.495968_g12368_i0 PRJNA474426 12573 297 2.495968 7.41302496 Pseudomonadati 3379134 Bacteria Bacteria 105 3.0899999999999993e-24   NR OHD22916.1 1802176 g12368 i0 58.6 4.46464646464646 87 36 87.9 0 284 24 317 403 OHD22916.1 MAG: hypothetical protein A2Y38_19835, partial [Spirochaetes bacterium GWB1_59_5] diamond 1326 105 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
30802926 30802926 PRJNA474426_P_NODE_17654_length_242_cov_0.979275_g17449_i0 PRJNA474426 17654 242 0.979275 2.3698455 Leptospira biflexa 172 Bacteria Bacteria 83.6 1.19e-16   NR WP_012389578.1 172 g17449 i0 88.6 0.545454545454545 44 5 54.5 0 1 132 371 414 WP_012389578.1 PP2C family protein-serine/threonine phosphatase [Leptospira biflexa] diamond 132 83.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira biflexa
31056032 31056032 PRJNA474426_P_NODE_17335_length_244_cov_2.076923_g17130_i0 PRJNA474426 17335 244 2.076923 5.06769212 Spirochaetota bacterium 2202144 Bacteria Bacteria 107 9.05e-25   NR TXG86205.1 2202144 g17130 i0 83.9 0.762295081967213 62 10 76.2 0 217 32 152 213 TXG86205.1 MAG: DUF3987 domain-containing protein [Spirochaetota bacterium] diamond 186 107 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31688078 31688078 PRJNA474426_P_NODE_33597_length_166_cov_0.880342_g33392_i0 PRJNA474426 33597 166 0.880342 1.46136772 Spirochaetota bacterium 2202144 Bacteria Bacteria 43.5 0.00691   NR TXH11510.1 2202144 g33392 i0 49 0.921686746987952 51 25 92.2 1 12 164 542 591 TXH11510.1 MAG: hypothetical protein E6R04_02685 [Spirochaetota bacterium] diamond 153 43.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31782854 31782854 PRJNA474426_P_NODE_31397_length_170_cov_1.289256_g31192_i0 PRJNA474426 31397 170 1.289256 2.1917352 Spirochaetota bacterium 2202144 Bacteria Bacteria 84 4.13e-17   NR TXG80592.1 2202144 g31192 i0 97.7 0.776470588235294 44 1 77.6 0 2 133 205 248 TXG80592.1 MAG: hypothetical protein E6R13_07820 [Spirochaetota bacterium] diamond 132 84 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32131256 32131256 PRJNA474426_P_NODE_4518_length_501_cov_1.814159_g4326_i0 PRJNA474426 4518 501 1.814159 9.08893659 Spirochaetota bacterium 2202144 Bacteria Bacteria 102 1.36e-21   NR TXG81457.1 2202144 g4326 i0 40.4 0.964071856287425 161 86 96.4 3 496 14 1879 2029 TXG81457.1 MAG: hypothetical protein E6R13_06190, partial [Spirochaetota bacterium] diamond 483 102 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32194407 32194407 PRJNA474426_P_NODE_37398_length_155_cov_2.396226_g37193_i0 PRJNA474426 37398 155 2.396226 3.7141503 Spirochaetia bacterium 2053615 Bacteria Bacteria 49.7 7.19e-6   NR NCD07771.1 2053615 g37193 i0 58.8 0.658064516129032 34 14 65.8 0 16 117 2 35 NCD07771.1 hypothetical protein [Spirochaetia bacterium] diamond 102 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32194409 32194409 PRJNA474426_P_NODE_9858_length_342_cov_1.750853_g9653_i0 PRJNA474426 9858 342 1.750853 5.98791726 Spirochaetota bacterium 2202144 Bacteria Bacteria 91.3 8.23e-19   NR TXG84133.1 2202144 g9653 i0 40.2 0.93859649122807 107 64 93.9 0 1 321 159 265 TXG84133.1 MAG: hypothetical protein E6R13_03425 [Spirochaetota bacterium] diamond 321 91.3 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);;