RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJDB3785" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJDB3785 · 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
981173 981173 PRJDB3785_S_NODE_7201_length_280_cov_1.346320_g7048_i0 PRJDB3785 7201 280 1.34632 3.769696 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 110 1.06e-28   NR GJM17742.1 2202153 g7048 i0 64.5 0.996428571428571 93 26 99.6 1 280 2 2 87 GJM17742.1 MAG: hypothetical protein DHS20C13_30690 [Thermodesulfobacteriota bacterium] diamond 279 110 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
28100306 28100306 PRJDB3785_S_NODE_23705_length_166_cov_1.299145_g23552_i0 PRJDB3785 23705 166 1.299145 2.1565807 Pseudomonadati 3379134 Bacteria Bacteria 54.7 3.31e-7   NR NSW87421.1 2052185 g23552 i0 52.2 2.53012048192771 46 22 83.1 0 20 157 37 82 NSW87421.1 lipocalin family protein [Syntrophobacteraceae bacterium] diamond 420 55.1 0.992740471869329 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae   Syntrophobacteraceae bacterium
28138134 28138134 PRJDB3785_S_NODE_17705_length_187_cov_1.478261_g17552_i0 PRJDB3785 17705 187 1.478261 2.76434807 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 42 0.0254   NR MCP4110641.1 2049433 g17552 i0 33.9 0.898395721925134 56 31 80.2 1 171 22 83 138 MCP4110641.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 168 42 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
28200818 28200818 PRJDB3785_S_NODE_1106_length_766_cov_2.365411_g1004_i0 PRJDB3785 1106 766 2.365411 18.11904826 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 53.9 1.09e-4   NR GJM17643.1 2202153 g1004 i0 25.6 0.857702349869452 219 140 82.6 7 695 63 10 213 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 657 53.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
28548576 28548576 PRJDB3785_S_NODE_18887_length_182_cov_1.481203_g18734_i0 PRJDB3785 18887 182 1.481203 2.69578946 Syntrophales bacterium LBB04 2914040 Bacteria Bacteria 51.2 2.06e-6   NR MCG6536285.1 2914040 g18734 i0 45.7 0.758241758241758 46 25 75.8 0 142 5 12 57 MCG6536285.1 hypothetical protein [Syntrophales bacterium LBB04] diamond 138 51.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium LBB04
28800788 28800788 PRJDB3785_S_NODE_26468_length_162_cov_0.902655_g26315_i0 PRJDB3785 26468 162 0.902655 1.4623011 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 42 0.0203   NR GJM17643.1 2202153 g26315 i0 36 0.925925925925926 50 32 92.6 0 2 151 152 201 GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] diamond 150 42 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30184462 30184462 PRJDB3785_S_NODE_26932_length_161_cov_1.366071_g26779_i0 PRJDB3785 26932 161 1.366071 2.19937431 Pseudomonadati 3379134 Bacteria Bacteria 77.4 7.27e-15   NR PLX83074.1 892 g26779 i0 65.4 5.88819875776398 52 18 96.9 0 5 160 438 489 PLX83074.1 MAG: DUF1365 domain-containing protein [Desulfuromonas sp.] diamond 948 77.8 0.994858611825193 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
32719241 32719241 PRJDB3785_S_NODE_10740_length_231_cov_1.472527_g10587_i0 PRJDB3785 10740 231 1.472527 3.40153737 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 51.2 2.49e-5   NR NLZ17542.1 2053307 g10587 i0 43.7 0.922077922077922 71 36 92.2 2 12 224 160 226 NLZ17542.1 CAP domain-containing protein [Desulfobulbaceae bacterium] diamond 213 51.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae 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);;