RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA600413" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA600413 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
27490809 27490809 PRJNA600413_P_NODE_150583_length_161_cov_0.910714_g149882_i0 PRJNA600413 150583 161 0.910714 1.46624954 Leptospiraceae bacterium 2026757 Bacteria Bacteria 105 7.07e-25   NR MBK8397868.1 2026757 g149882 i0 98.1 5.92546583850932 53 1 98.8 0 161 3 461 513 MBK8397868.1 SpoIIE family protein phosphatase [Leptospiraceae bacterium] diamond 954 105 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28627602 28627602 PRJNA600413_P_NODE_120507_length_165_cov_0.879310_g119806_i0 PRJNA600413 120507 165 0.87931 1.4508615 Leptospiraceae bacterium 2026757 Bacteria Bacteria 71.6 3.93e-13   NR MBP9887302.1 2026757 g119806 i0 83.3 0.763636363636364 42 7 76.4 0 2 127 86 127 MBP9887302.1 hypothetical protein [Leptospiraceae bacterium] diamond 126 71.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28785077 28785077 PRJNA600413_P_NODE_68587_length_187_cov_1.492754_g67886_i0 PRJNA600413 68587 187 1.492754 2.79144998 Leptospiraceae bacterium 2026757 Bacteria Bacteria 115 1.83e-28   NR MBP9889392.1 2026757 g67886 i0 90.3 1.97326203208556 62 6 99.5 0 1 186 23 84 MBP9889392.1 hypothetical protein [Leptospiraceae bacterium] diamond 369 115 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29195824 29195824 PRJNA600413_P_NODE_110449_length_166_cov_0.871795_g109748_i0 PRJNA600413 110449 166 0.871795 1.4471797 Leptospiraceae bacterium 2026757 Bacteria Bacteria 115 8.98e-29   NR MBK9502366.1 2026757 g109748 i0 96.3 0.975903614457831 54 2 97.6 0 3 164 263 316 MBK9502366.1 hypothetical protein [Leptospiraceae bacterium] diamond 162 115 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29195843 29195843 PRJNA600413_P_NODE_24249_length_289_cov_1.183333_g23548_i0 PRJNA600413 24249 289 1.183333 3.41983237 Treponema sp. 166 Bacteria Bacteria 68.2 7.18e-11   NR MCF0241710.1 166 g23548 i0 45.1 10.4117647058824 91 48 93.4 2 7 276 298 387 MCF0241710.1 DNA translocase FtsK [Treponema sp.] diamond 3009 68.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29827082 29827082 PRJNA600413_P_NODE_133291_length_163_cov_0.894737_g132590_i0 PRJNA600413 133291 163 0.894737 1.45842131 Spirochaetota bacterium 2202144 Bacteria Bacteria 71.6 8.18e-13   NR MDK2818543.1 2202144 g132590 i0 64.8 0.993865030674847 54 19 99.4 0 2 163 233 286 MDK2818543.1 phosphoenolpyruvate--protein phosphotransferase [Spirochaetota bacterium] diamond 162 71.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29985161 29985161 PRJNA600413_P_NODE_125791_length_164_cov_0.886957_g125090_i0 PRJNA600413 125791 164 0.886957 1.45460948 Leptospiraceae bacterium 2026757 Bacteria Bacteria 108 5.460000000000001e-26   NR MBP7281104.1 2026757 g125090 i0 92.6 2.96341463414634 54 4 98.8 0 3 164 275 328 MBP7281104.1 hypothetical protein [Leptospiraceae bacterium] diamond 486 108 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30553679 30553679 PRJNA600413_P_NODE_102973_length_167_cov_0.864407_g102272_i0 PRJNA600413 102973 167 0.864407 1.44355969 Leptospiraceae bacterium 2026757 Bacteria Bacteria 70.5 2.04e-12   NR MBP7281381.1 2026757 g102272 i0 83.8 0.664670658682635 37 6 66.5 0 166 56 255 291 MBP7281381.1 NarK/NasA family nitrate transporter [Leptospiraceae bacterium] diamond 111 70.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30585284 30585284 PRJNA600413_P_NODE_124893_length_164_cov_0.886957_g124192_i0 PRJNA600413 124893 164 0.886957 1.45460948 Leptospiraceae bacterium 2026757 Bacteria Bacteria 110 1.6899999999999999e-28   NR MBP7280244.1 2026757 g124192 i0 94.4 0.98780487804878 54 3 98.8 0 2 163 167 220 MBP7280244.1 hypothetical protein [Leptospiraceae bacterium] diamond 162 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31216967 31216967 PRJNA600413_P_NODE_150895_length_161_cov_0.910714_g150194_i0 PRJNA600413 150895 161 0.910714 1.46624954 Leptospira barantonii 2023184 Bacteria Bacteria 50.1 3.02e-5   NR WP_135671798.1 2023184 g150194 i0 48.1 1.90062111801242 52 26 96.9 1 156 1 228 278 WP_135671798.1 ankyrin repeat domain-containing protein [Leptospira barantonii] diamond 306 50.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira barantonii
32166537 32166537 PRJNA600413_P_NODE_126778_length_164_cov_0.886957_g126077_i0 PRJNA600413 126778 164 0.886957 1.45460948 Leptospiraceae bacterium 2026757 Bacteria Bacteria 106 1.28e-26   NR HRG75793.1 2026757 g126077 i0 94.4 2.96341463414634 54 3 98.8 0 2 163 64 117 HRG75793.1 penicillin-binding protein 2 [Leptospiraceae bacterium] diamond 486 106 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32609140 32609140 PRJNA600413_P_NODE_143360_length_162_cov_0.902655_g142659_i0 PRJNA600413 143360 162 0.902655 1.4623011 uncultured spirochete 156406 Bacteria Bacteria 111 7.65e-28   NR SLM19657.1 156406 g142659 i0 94.3 0.981481481481482 53 3 98.1 0 2 160 83 135 SLM19657.1 Protein HflK [uncultured spirochete] diamond 159 111 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     uncultured spirochete
32640370 32640370 PRJNA600413_P_NODE_156160_length_153_cov_2.115385_g155459_i0 PRJNA600413 156160 153 2.115385 3.23653905 Leptospiraceae bacterium 2026757 Bacteria Bacteria 89.4 1.18e-20   NR MBK6603869.1 2026757 g155459 i0 84 1.96078431372549 50 8 98 0 152 3 22 71 MBK6603869.1 hypothetical protein [Leptospiraceae bacterium] diamond 300 89.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae 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);;