RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA770361" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA770361 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
4574537 4574537 PRJNA770361_P_NODE_12164_length_269_cov_1.520408_g12069_i0 PRJNA770361 12164 269 1.520408 4.08989752 Spirochaetes bacterium GWC2_52_13 1802181 Bacteria Bacteria 160 7.4e-46   NR OHD31754.1 1802181 g12069 i0 95.5 1.98513011152416 89 4 99.3 0 268 2 217 305 OHD31754.1 MAG: DNA-directed RNA polymerase subunit alpha [Spirochaetes bacterium GWC2_52_13] diamond 534 160 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWC2_52_13
7125084 7125084 PRJNA770361_P_NODE_16686_length_247_cov_0.896552_g16591_i0 PRJNA770361 16686 247 0.896552 2.21448344 Spirochaetia bacterium 2053615 Bacteria Bacteria 162 2.39e-46   NR MCE1159502.1 2053615 g16591 i0 100 0.995951417004049 82 0 99.6 0 1 246 245 326 MCE1159502.1 ATP-dependent Clp protease ATP-binding subunit ClpX [Spirochaetia bacterium] diamond 246 162 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26958119 26958119 PRJNA770361_P_NODE_18142_length_244_cov_0.912281_g18047_i0 PRJNA770361 18142 244 0.912281 2.22596564 Sphaerochaeta sp. 1972642 Bacteria Bacteria 164 1.07e-47   NR HOE85190.1 1972642 g18047 i0 100 0.983606557377049 80 0 98.4 0 242 3 185 264 HOE85190.1 dihydroorotase [Sphaerochaeta sp.] diamond 240 164 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
27062792 27062792 PRJNA770361_P_NODE_17522_length_245_cov_0.906977_g17427_i0 PRJNA770361 17522 245 0.906977 2.22209365 Exilispira 568400 Bacteria Bacteria 147 5.52e-39   NR MBP7030242.1 2202144 g17427 i0 94.7 2.79183673469388 76 4 93.1 0 2 229 738 813 MBP7030242.1 transporter substrate-binding domain-containing protein [Spirochaetota bacterium] diamond 684 147 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27094399 27094399 PRJNA770361_P_NODE_18222_length_244_cov_0.906433_g18127_i0 PRJNA770361 18222 244 0.906433 2.21169652 Sphaerochaeta 399320 Bacteria Bacteria 122 9.679999999999999e-32   NR MEA5033699.1 1972642 g18127 i0 85.1 1.81967213114754 74 11 91 0 23 244 1 74 MEA5033699.1 FtsH protease activity modulator HflK [Sphaerochaeta sp.] diamond 444 122 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
27590556 27590556 PRJNA770361_P_NODE_6404_length_370_cov_1.313131_g6309_i0 PRJNA770361 6404 370 1.313131 4.8585847 Leptospirales bacterium 2604146 Bacteria Bacteria 112 4.76e-28   NR MEQ9363317.1 2604146 g6309 i0 40 3.95675675675676 125 73 99.7 1 369 1 24 148 MEQ9363317.1 TRAP transporter TatT component family protein [Leptospirales bacterium] diamond 1464 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales     Leptospirales bacterium
28389231 28389231 PRJNA770361_P_NODE_2566_length_591_cov_1.113900_g2472_i0 PRJNA770361 2566 591 1.1139 6.583149 Pseudomonadati 3379134 Bacteria Bacteria 173 2.64e-46   NR HNF27341.1 2026757 g2472 i0 49.7 8.05583756345178 199 96 99.5 3 588 1 465 662 HNF27341.1 hypothetical protein [Leptospiraceae bacterium] diamond 4761 173 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29232301 29232301 PRJNA770361_P_NODE_17609_length_245_cov_0.906977_g17514_i0 PRJNA770361 17609 245 0.906977 2.22209365 Spirochaetota bacterium 2202144 Bacteria Bacteria 167 1.45e-50   NR MDI9386965.1 2202144 g17514 i0 97.5 0.991836734693878 81 2 99.2 0 1 243 128 208 MDI9386965.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Spirochaetota bacterium] diamond 243 167 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30442100 30442100 PRJNA770361_P_NODE_12913_length_260_cov_1.251337_g12818_i0 PRJNA770361 12913 260 1.251337 3.2534762 Bacteria 2 Bacteria Bacteria 116 1.07e-29   NR MBO4759740.1 1898206 g12818 i0 61.6 8.87307692307692 86 33 99.2 0 260 3 86 171 MBO4759740.1 glucosamine-6-phosphate deaminase [Spirochaetaceae bacterium] diamond 2307 117 0.991452991452991 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30811482 30811482 PRJNA770361_P_NODE_13134_length_257_cov_1.695652_g13039_i0 PRJNA770361 13134 257 1.695652 4.35782564 Spirochaetota bacterium 2202144 Bacteria Bacteria 139 3.69e-40   NR MEW6547871.1 2202144 g13039 i0 80 0.992217898832685 85 17 99.2 0 3 257 28 112 MEW6547871.1 hypothetical protein [Spirochaetota bacterium] diamond 255 139 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32519604 32519604 PRJNA770361_P_NODE_17679_length_245_cov_0.906977_g17584_i0 PRJNA770361 17679 245 0.906977 2.22209365 Sphaerochaeta sp. 1972642 Bacteria Bacteria 166 1.14e-47   NR MDY0304069.1 1972642 g17584 i0 100 0.991836734693878 81 0 99.2 0 3 245 87 167 MDY0304069.1 ATP-binding protein [Sphaerochaeta sp.] diamond 243 166 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.

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