RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA690124", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 10 ✖

tax_kingdom 1

  • Pseudomonadati · 10 ✖

bioproject 1

  • PRJNA690124 · 10 ✖

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
5773156 5773156 PRJNA690124_P_NODE_47545_length_249_cov_0.886364_g47179_i0 PRJNA690124 47545 249 0.886364 2.20704636 Pelobacter propionicus 29543 Bacteria Bacteria 335 2e-87   NTclustered gi|118501159|gb|CP000482.1| 338966 g47179 i0 91.093 94.0803212851406 247 22 99 0 1 247 571866 572112 Pelobacter propionicus DSM 2379, complete genome blastn 23426 335 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
22346385 22346385 PRJNA690124_P_NODE_22918_length_341_cov_1.164179_g22552_i0 PRJNA690124 22918 341 1.164179 3.96985039 Desulfovibrio desulfuricans 876 Bacteria Bacteria 630 3.2499999999999986e-176   NTclustered gi|2172810686|gb|CP077745.1| 876 g22552 i0 100 524.205278592375 341 0 100 0 1 341 217828 217488 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 178754 630 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
22855981 22855981 PRJNA690124_P_NODE_42478_length_254_cov_2.585635_g42112_i0 PRJNA690124 42478 254 2.585635 6.5675129 Bacteria 2 Bacteria Bacteria 470 5.37e-128   NTclustered gi|2418936308|gb|OQ154933.1| 876 g42112 i0 100 104 254 0 100 0 1 254 1356 1103 Desulfovibrio desulfuricans strain JN-38 16S ribosomal RNA gene, partial sequence blastn 26416 470 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
27019102 27019102 PRJNA690124_P_NODE_44382_length_252_cov_0.871508_g44016_i0 PRJNA690124 44382 252 0.871508 2.19620016 Geobacteraceae bacterium 2282154 Bacteria Bacteria 48.5 3.29e-4   NR HZV82296.1 2282154 g44016 i0 69.7 0.785714285714286 33 10 39.3 0 100 2 1 33 HZV82296.1 IS982 family transposase [Geobacteraceae bacterium] diamond 198 48.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
28945824 28945824 PRJNA690124_P_NODE_52908_length_245_cov_0.877907_g52542_i0 PRJNA690124 52908 245 0.877907 2.15087215 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 152 1.1e-45   NR MEW6377405.1 2202153 g52542 i0 91.4 0.991836734693878 81 7 99.2 0 244 2 22 102 MEW6377405.1 putative toxin-antitoxin system toxin component, PIN family [Thermodesulfobacteriota bacterium] diamond 243 152 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29335963 29335963 PRJNA690124_P_NODE_37389_length_272_cov_1.402010_g37023_i0 PRJNA690124 37389 272 1.40201 3.8134672 Pseudomonadati 3379134 Bacteria Bacteria 70.9 2.56e-13   NR WP_092121880.1 617002 g37023 i0 61.5 2.29411764705882 52 20 57.4 0 270 115 77 128 WP_092121880.1 type II toxin-antitoxin system VapC family toxin [Desulfonatronum thiosulfatophilum] diamond 624 71.2 0.995786516853933 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonatronaceae Desulfonatronum Desulfonatronum thiosulfatophilum
30682488 30682488 PRJNA690124_P_NODE_49173_length_248_cov_0.891429_g48807_i0 PRJNA690124 49173 248 0.891429 2.21074392 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 77 2.4e-15   NR MEW6375308.1 2202153 g48807 i0 58 0.834677419354839 69 27 81 1 229 29 87 155 MEW6375308.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 207 77 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30872220 30872220 PRJNA690124_P_NODE_47574_length_249_cov_0.886364_g47208_i0 PRJNA690124 47574 249 0.886364 2.20704636 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 67.4 8.27e-11   NR MEA3361562.1 2202153 g47208 i0 62.5 2.50602409638554 64 19 74.7 2 188 3 476 536 MEA3361562.1 PKD domain-containing protein [Thermodesulfobacteriota bacterium] diamond 624 67.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
31042044 31042044 PRJNA690124_P_NODE_49975_length_247_cov_0.896552_g49609_i0 PRJNA690124 49975 247 0.896552 2.21448344 Pseudomonadati 3379134 Bacteria Bacteria 75.5 1.11e-13   NR MDX9819735.1 897 g49609 i0 56.1 7.09311740890688 66 28 78.9 1 6 200 217 282 MDX9819735.1 acyl-CoA dehydratase activase [Desulfococcus multivorans] diamond 1752 75.9 0.994729907773386 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfococcus Desulfococcus multivorans
32117124 32117124 PRJNA690124_P_NODE_45378_length_251_cov_0.876404_g45012_i0 PRJNA690124 45378 251 0.876404 2.19977404 Thermodesulfobacteriota 200940 Bacteria Bacteria 156 1.4e-43   NR MDP2647433.1 2044940 g45012 i0 95 2.86852589641434 80 4 95.6 0 3 242 391 470 MDP2647433.1 ABC transporter permease [Desulfobacterales bacterium] diamond 720 156 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales 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);;