RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB43370" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB43370 · 7 ✖

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
1334524 1334524 PRJEB43370_P_NODE_3782_length_227_cov_1.168539_g3739_i0 PRJEB43370 3782 227 1.168539 2.65258353 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 134 2.05e-38   NR GJM17675.1 2202153 g3739 i0 90.7 0.991189427312775 75 7 99.1 0 226 2 70 144 GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium] diamond 225 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
6438337 6438337 PRJEB43370_P_NODE_3246_length_242_cov_1.378238_g3203_i0 PRJEB43370 3246 242 1.378238 3.33533596 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 95.9 2.6199999999999998e-23   NR GJM17742.1 2202153 g3203 i0 65.4 0.966942148760331 78 20 96.7 1 237 4 12 82 GJM17742.1 MAG: hypothetical protein DHS20C13_30690 [Thermodesulfobacteriota bacterium] diamond 234 95.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27791720 27791720 PRJEB43370_P_NODE_7024_length_173_cov_1.346774_g6981_i0 PRJEB43370 7024 173 1.346774 2.32991902 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 53.1 5.95e-7   NR GJM17742.1 2202153 g6981 i0 54.7 0.919075144508671 53 19 91.9 1 14 172 1 48 GJM17742.1 MAG: hypothetical protein DHS20C13_30690 [Thermodesulfobacteriota bacterium] diamond 159 53.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
28100554 28100554 PRJEB43370_P_NODE_6145_length_185_cov_1.147059_g6102_i0 PRJEB43370 6145 185 1.147059 2.12205915 Pseudodesulfovibrio 2035811 Bacteria Bacteria 80.1 1.13e-15   NR HKI82445.1 2035812 g6102 i0 67.8 21.0324324324324 59 19 95.7 0 184 8 119 177 HKI82445.1 plasma-membrane proton-efflux P-type ATPase [Pseudodesulfovibrio sp.] diamond 3891 80.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio sp.
30949882 30949882 PRJEB43370_P_NODE_10414_length_163_cov_0.912281_g10371_i0 PRJEB43370 10414 163 0.912281 1.48701803 Oryzomonas sp. 2855186 Bacteria Bacteria 45.4 0.00143   NR WP_309360163.1 2855186 g10371 i0 42.9 1.52760736196319 42 23 75.5 1 150 28 370 411 WP_309360163.1 TPR end-of-group domain-containing protein [Oryzomonas sp.] diamond 249 45.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Oryzomonas Oryzomonas sp.
31803313 31803313 PRJEB43370_P_NODE_2177_length_294_cov_1.485714_g2134_i0 PRJEB43370 2177 294 1.485714 4.36799916 Smithella sp. 2053614 Bacteria Bacteria 42 0.0398   NR MBP9013957.1 2053614 g2134 i0 39 0.785714285714286 77 35 71.4 3 279 70 43 114 MBP9013957.1 hypothetical protein [Smithella sp.] diamond 231 42 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae Smithella Smithella sp.
32246772 32246772 PRJEB43370_P_NODE_9398_length_165_cov_0.896552_g9355_i0 PRJEB43370 9398 165 0.896552 1.4793108 Geobacteraceae bacterium 2282154 Bacteria Bacteria 68.9 4.49e-12   NR NMC75321.1 2282154 g9355 i0 60 3.18181818181818 55 19 100 1 1 165 71 122 NMC75321.1 NUDIX domain-containing protein [Geobacteraceae bacterium] diamond 525 68.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae 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);;