RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA857143", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 8 ✖

tax_kingdom 1

  • Pseudomonadati · 8 ✖

bioproject 1

  • PRJNA857143 · 8 ✖

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
5946411 5946411 PRJNA857143_S_NODE_134985_length_279_cov_1.135922_g133892_i0 PRJNA857143 134985 279 1.135922 3.16922238 Spirochaetia bacterium 2053615 Bacteria Bacteria 70.1 1.26e-11   NR MBL8995636.1 2053615 g133892 i0 59.2 0.526881720430108 49 20 52.7 0 17 163 377 425 MBL8995636.1 ATP-dependent 6-phosphofructokinase [Spirochaetia bacterium] diamond 147 70.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28011046 28011046 PRJNA857143_S_NODE_144205_length_271_cov_1.575758_g143112_i0 PRJNA857143 144205 271 1.575758 4.27030418 root 1 Root_unresolved Root_unresolved 104 1.36e-24   NR MCE9499875.1 178 g143112 i0 54.7 7.52767527675277 86 39 95.2 0 11 268 253 338 MCE9499875.1 medium chain dehydrogenase/reductase family protein [Leptospira sp.] diamond 2040 105 0.990476190476191 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
29202575 29202575 PRJNA857143_S_NODE_180609_length_248_cov_1.068571_g179516_i0 PRJNA857143 180609 248 1.068571 2.65005608 Spirochaetales bacterium 2026792 Bacteria Bacteria 133 6.27e-34   NR MCD6121863.1 2026792 g179516 i0 80.2 4.91129032258065 81 16 98 0 2 244 171 251 MCD6121863.1 pyruvate, phosphate dikinase [Spirochaetales bacterium] diamond 1218 133 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29462858 29462858 PRJNA857143_S_NODE_49150_length_398_cov_2.160000_g48057_i0 PRJNA857143 49150 398 2.16 8.5968 FCB group 1783270 Bacteria Bacteria 57.4 1.48e-6   NR MBQ9495223.1 166 g48057 i0 35.6 4.2286432160804 87 52 64.8 2 20 277 438 521 MBQ9495223.1 5'-nucleotidase C-terminal domain-containing protein [Treponema sp.] diamond 1683 57.8 0.993079584775087 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30063116 30063116 PRJNA857143_S_NODE_139411_length_275_cov_1.500000_g138318_i0 PRJNA857143 139411 275 1.5 4.125 Pseudomonadati 3379134 Bacteria Bacteria 79.7 4.88e-16   NR RPI97743.1 2026792 g138318 i0 72.9 3.15272727272727 48 13 52.4 0 6 149 156 203 RPI97743.1 MAG: NAD(P)H:quinone oxidoreductase [Spirochaetales bacterium] diamond 867 80.5 0.990062111801242 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30474137 30474137 PRJNA857143_S_NODE_61033_length_371_cov_3.382550_g59940_i0 PRJNA857143 61033 371 3.38255 12.5492605 Bacteria 2 Bacteria Bacteria 81.6 3.68e-15   NR MDR1748921.1 1898206 g59940 i0 51.4 4.22911051212938 74 35 59 1 15 233 530 603 MDR1748921.1 phosphoenolpyruvate carboxykinase (GTP) [Spirochaetaceae bacterium] diamond 1569 82 0.995121951219512 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32086370 32086370 PRJNA857143_S_NODE_139738_length_275_cov_1.158416_g138645_i0 PRJNA857143 139738 275 1.158416 3.185644 Bacteria 2 Bacteria Bacteria 93.6 1.7e-21   NR MCB1321314.1 2026757 g138645 i0 57.9 5.21454545454545 76 26 82.9 2 2 229 111 180 MCB1321314.1 OsmC family protein [Leptospiraceae bacterium] diamond 1434 93.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32899070 32899070 PRJNA857143_S_NODE_181660_length_247_cov_3.114943_g180567_i0 PRJNA857143 181660 247 3.114943 7.69390921 Spirochaetota bacterium 2202144 Bacteria Bacteria 77.4 2.47e-14   NR MCX7787908.1 2202144 g180567 i0 63 1.2753036437247 46 17 55.9 0 243 106 784 829 MCX7787908.1 glycogen/starch/alpha-glucan phosphorylase [Spirochaetota bacterium] diamond 315 77.4 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);;