RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJEB81171", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 19 ✖

tax_phylum 1

  • Thermodesulfobacteriota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJEB81171 · 19 ✖

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
1414088 1414088 PRJEB81171_P_NODE_8122_length_251_cov_0.876404_g7995_i0 PRJEB81171 8122 251 0.876404 2.19977404 Desulfarculia bacterium 3065862 Bacteria Bacteria 183 7.73e-42   NTclustered gi|2621701821|emb|OY759351.1| 3065862 g7995 i0 80.247 58.8207171314741 243 48 97 0 4 246 700264 700506 MAG: Desulfarculia bacterium isolate c1361fd1-6016-418c-9b2d-a8e9625d1ec5 genome assembly, chromosome: 1 blastn 14764 183 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia       Desulfarculia bacterium
2689500 2689500 PRJEB81171_P_NODE_6523_length_271_cov_1.237374_g6396_i0 PRJEB81171 6523 271 1.237374 3.35328354 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 152 2.28e-44   NR MEF8822996.1 2683721 g6396 i0 91.7 0.929889298892989 84 7 93 0 18 269 1 84 MEF8822996.1 NAD(P)H:quinone oxidoreductase [Desulfohalobiaceae bacterium] diamond 252 152 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
11617974 11617974 PRJEB81171_P_NODE_5690_length_283_cov_2.171429_g5563_i0 PRJEB81171 5690 283 2.171429 6.14514407 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 135 2.3499999999999997e-35   NR MEF8941430.1 2683721 g5563 i0 98.6 0.731448763250883 69 1 73.1 0 281 75 435 503 MEF8941430.1 lysine--tRNA ligase [Desulfohalobiaceae bacterium] diamond 207 135 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
17574538 17574538 PRJEB81171_P_NODE_3334_length_361_cov_2.027778_g3207_i0 PRJEB81171 3334 361 2.027778 7.32027858 Geobacter 28231 Bacteria Bacteria 414 3.79e-111   NTclustered gi|747129828|gb|CP009788.1| 345632 g3207 i0 87.363 244.606648199446 364 42 100 4 1 361 2443725 2444087 Geobacter pickeringii strain G13, complete genome blastn 88303 414 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter pickeringii
21398774 21398774 PRJEB81171_P_NODE_8777_length_248_cov_0.891429_g8650_i0 PRJEB81171 8777 248 0.891429 2.21074392 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 79 8.71e-16   NR MEF8823945.1 2683721 g8650 i0 87 0.556451612903226 46 6 55.6 0 111 248 1 46 MEF8823945.1 precorrin-8X methylmutase [Desulfohalobiaceae bacterium] diamond 138 79 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
23091376 23091376 PRJEB81171_P_NODE_5319_length_290_cov_1.345622_g5192_i0 PRJEB81171 5319 290 1.345622 3.9023038 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 183 2.2099999999999995e-55   NR MEF8822942.1 2683721 g5192 i0 97.8 0.920689655172414 89 2 92.1 0 23 289 1 89 MEF8822942.1 YicC/YloC family endoribonuclease [Desulfohalobiaceae bacterium] diamond 267 183 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
24365197 24365197 PRJEB81171_P_NODE_5080_length_295_cov_1.229730_g4953_i0 PRJEB81171 5080 295 1.22973 3.6277035 Desulfolithobacter dissulfuricans 2795293 Bacteria Bacteria 270 6.9399999999999985e-68   NTclustered gi|2304357171|dbj|AP024233.1| 2795293 g4953 i0 83.388 225.613559322034 307 36 100 13 1 295 1926704 1927007 Desulfobulbaceae bacterium GF1 GF1 DNA, complete genome blastn 66556 270 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfolithobacter Desulfolithobacter dissulfuricans
27287107 27287107 PRJEB81171_P_NODE_4163_length_325_cov_0.928571_g4036_i0 PRJEB81171 4163 325 0.928571 3.01785575 Desulfomonile tiedjei 2358 Bacteria Bacteria 44.7 0.0198   NR MBI5571367.1 2358 g4036 i0 52.6 0.692307692307692 38 18 35.1 0 9 122 330 367 MBI5571367.1 ankyrin repeat domain-containing protein [Desulfomonile tiedjei] diamond 225 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfomonilia Desulfomonilales Desulfomonilaceae Desulfomonile Desulfomonile tiedjei
27476648 27476648 PRJEB81171_P_NODE_7723_length_253_cov_0.866667_g7596_i0 PRJEB81171 7723 253 0.866667 2.19266751 Desulfonatronovibrio sp. 2099676 Bacteria Bacteria 99.4 4.68e-22   NR MFN2268989.1 2099676 g7596 i0 58.5 0.972332015810277 82 33 97.2 1 7 252 316 396 MFN2268989.1 DNA polymerase [Desulfonatronovibrio sp.] diamond 246 99.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonatronovibrionaceae Desulfonatronovibrio Desulfonatronovibrio sp.
27603140 27603140 PRJEB81171_P_NODE_7064_length_262_cov_1.253968_g6937_i0 PRJEB81171 7064 262 1.253968 3.28539616 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 140 4.18e-38   NR MCF8085856.1 2683721 g6937 i0 80.5 0.99618320610687 87 17 99.6 0 1 261 33 119 MCF8085856.1 (Fe-S)-binding protein [Desulfohalobiaceae bacterium] diamond 261 140 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
27729623 27729623 PRJEB81171_P_NODE_5104_length_294_cov_1.615385_g4977_i0 PRJEB81171 5104 294 1.615385 4.7492319 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 91.3 5.76e-21   NR MEF8941797.1 2683721 g4977 i0 58 0.826530612244898 81 33 81.6 1 31 270 1 81 MEF8941797.1 hypothetical protein [Desulfohalobiaceae bacterium] diamond 243 91.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
28897386 28897386 PRJEB81171_P_NODE_8168_length_251_cov_0.876404_g8041_i0 PRJEB81171 8168 251 0.876404 2.19977404 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 132 1.23e-33   NR MCF8030385.1 2683721 g8041 i0 85.5 0.99203187250996006 83 12 99.2 0 249 1 591 673 MCF8030385.1 DNA-directed RNA polymerase subunit beta' [Desulfohalobiaceae bacterium] diamond 249 132 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
28960922 28960922 PRJEB81171_P_NODE_9568_length_244_cov_0.912281_g9441_i0 PRJEB81171 9568 244 0.912281 2.22596564 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 65.9 2.55e-10   NR MEF8888772.1 2683721 g9441 i0 100 0.381147540983607 31 0 38.1 0 95 3 1 31 MEF8888772.1 LON peptidase substrate-binding domain-containing protein [Desulfohalobiaceae bacterium] diamond 93 65.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
29433944 29433944 PRJEB81171_P_NODE_7890_length_252_cov_0.871508_g7763_i0 PRJEB81171 7890 252 0.871508 2.19620016 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 99.8 4.03e-24   NR HXG31702.1 2202153 g7763 i0 61.4 0.988095238095238 83 32 98.8 0 251 3 12 94 HXG31702.1 DnaJ C-terminal domain-containing protein [Thermodesulfobacteriota bacterium] diamond 249 99.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30002840 30002840 PRJEB81171_P_NODE_8091_length_251_cov_0.876404_g7964_i0 PRJEB81171 8091 251 0.876404 2.19977404 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 58.5 1.04e-7   NR MCF8030614.1 2683721 g7964 i0 84.4 0.382470119521912 32 5 38.2 0 98 193 329 360 MCF8030614.1 HigA family addiction module antidote protein [Desulfohalobiaceae bacterium] diamond 96 58.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
30602853 30602853 PRJEB81171_P_NODE_9933_length_242_cov_0.923077_g9806_i0 PRJEB81171 9933 242 0.923077 2.23384634 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 150 3.78e-41   NR MEF8822995.1 2683721 g9806 i0 88.8 0.991735537190083 80 9 99.2 0 2 241 94 173 MEF8822995.1 glucose-6-phosphate dehydrogenase [Desulfohalobiaceae bacterium] diamond 240 150 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
31013692 31013692 PRJEB81171_P_NODE_9595_length_244_cov_0.912281_g9468_i0 PRJEB81171 9595 244 0.912281 2.22596564 Desulfovermiculus sp. 2821143 Bacteria Bacteria 73.9 1.22e-13   NR MFP4034321.1 2821143 g9468 i0 68 1.22950819672131 50 16 61.5 0 4 153 205 254 MFP4034321.1 CoA-transferase subunit beta [Desulfovermiculus sp.] diamond 300 73.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
31804113 31804113 PRJEB81171_P_NODE_9977_length_242_cov_0.923077_g9850_i0 PRJEB81171 9977 242 0.923077 2.23384634 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 142 1.3e-39   NR MEF8823102.1 2683721 g9850 i0 91.3 0.991735537190083 80 7 99.2 0 242 3 170 249 MEF8823102.1 D-2-hydroxyacid dehydrogenase [Desulfohalobiaceae bacterium] diamond 240 142 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
32120782 32120782 PRJEB81171_P_NODE_9618_length_244_cov_0.912281_g9491_i0 PRJEB81171 9618 244 0.912281 2.22596564 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 97.4 4.24e-22   NR MEF8889063.1 2683721 g9491 i0 74.6 0.774590163934426 63 16 77.5 0 24 212 265 327 MEF8889063.1 DUF4340 domain-containing protein [Desulfohalobiaceae bacterium] diamond 189 97.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae 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);;