RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA453567" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA453567 · 16 ✖

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
2992421 2992421 PRJNA453567_P_NODE_14463_length_238_cov_2.124378_g14226_i0 PRJNA453567 14463 238 2.124378 5.05601964 Pseudomonadati 3379134 Bacteria Bacteria 81.3 9.19e-16   NR HSL39310.1 2099376 g14226 i0 54.5 7.6890756302521 77 35 97.1 0 236 6 179 255 HSL39310.1 HAD-IC family P-type ATPase [Desulforhopalus sp.] diamond 1830 81.6 0.996323529411765 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulforhopalus Desulforhopalus sp.
8094977 8094977 PRJNA453567_P_NODE_26127_length_171_cov_2.970149_g25890_i0 PRJNA453567 26127 171 2.970149 5.07895479 Pseudodesulfovibrio indicus 1716143 Bacteria Bacteria 134 4.97e-27   NTclustered gi|998152336|gb|CP014206.1| 1716143 g25890 i0 81.325 0.970760233918129 166 29 96 2 6 170 660567 660731 Pseudodesulfovibrio indicus strain J2 chromosome, complete genome blastn 166 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio indicus
14470405 14470405 PRJNA453567_P_NODE_12392_length_262_cov_2.115556_g12155_i0 PRJNA453567 12392 262 2.115556 5.54275672 Pelobacter propionicus 29543 Bacteria Bacteria 54.7 0.007   NTclustered gi|118501159|gb|CP000482.1| 338966 g12155 i0 96.97 0.125954198473282 33 0 12 1 171 202 96023 95991 Pelobacter propionicus DSM 2379, complete genome blastn 33 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
14470523 14470523 PRJNA453567_P_NODE_29692_length_161_cov_0.943548_g29455_i0 PRJNA453567 29692 161 0.943548 1.51911228 root 1 Root_unresolved Root_unresolved 110 1.03e-26   NR HCR13096.1 885 g29455 i0 90.6 9.87577639751553 53 5 98.8 0 3 161 136 188 HCR13096.1 catalase [Desulfovibrio sp.] diamond 1590 110 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
14470583 14470583 PRJNA453567_P_NODE_6452_length_392_cov_2.149296_g6216_i0 PRJNA453567 6452 392 2.149296 8.42524032 root 1 Root_unresolved Root_unresolved 114 6.04e-29   NR NMC49970.1 885 g6216 i0 53.8 9.83418367346939 104 48 79.6 0 80 391 17 120 NMC49970.1 50S ribosomal protein L4 [Desulfovibrio sp.] diamond 3855 115 0.991304347826087 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
18293528 18293528 PRJNA453567_P_NODE_31475_length_156_cov_1.571429_g31238_i0 PRJNA453567 31475 156 1.571429 2.45142924 Pseudomonadati 3379134 Bacteria Bacteria 85.1 4.91e-18   NR WP_008870277.1 488939 g31238 i0 69.2 10.6346153846154 52 16 100 0 156 1 114 165 WP_008870277.1 histone deacetylase [Desulfonatronospira thiodismutans] diamond 1659 85.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonatronovibrionaceae Desulfonatronospira Desulfonatronospira thiodismutans
22118263 22118263 PRJNA453567_P_NODE_1298_length_1030_cov_4.959718_g1185_i0 PRJNA453567 1298 1030 4.959718 51.0850954 Candidatus Dadabacteria bacterium 2080303 Bacteria Bacteria 275 9.029999999999998e-86   NR RMF15619.1 2080303 g1185 i0 72 0.530097087378641 182 51 53 0 3 548 251 432 RMF15619.1 MAG: O-acetylhomoserine aminocarboxypropyltransferase/cysteine synthase [Candidatus Dadabacteria bacterium] diamond 546 275 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Dadabacteria       Candidatus Dadabacteria bacterium
23394114 23394114 PRJNA453567_P_NODE_4719_length_478_cov_2.240363_g4486_i0 PRJNA453567 4719 478 2.240363 10.70893514 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 54.7 0.013   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g4486 i0 96.875 0.0669456066945607 32 1 7 0 185 216 2625942 2625973 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis
24668090 24668090 PRJNA453567_P_NODE_4660_length_482_cov_2.521348_g4427_i0 PRJNA453567 4660 482 2.521348 12.15289736 root 1 Root_unresolved Root_unresolved 193 1.74e-58   NR WP_024333593.1 115781 g4427 i0 62.4 7.94190871369295 157 59 97.7 0 472 2 50 206 WP_024333593.1 fumarylacetoacetate hydrolase family protein [Desulfotignum balticum] diamond 3828 194 0.994845360824742 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfotignum Desulfotignum balticum
27976694 27976694 PRJNA453567_P_NODE_15485_length_229_cov_1.843750_g15248_i0 PRJNA453567 15485 229 1.84375 4.2221875 Desulfobacter 2289 Bacteria Bacteria 47.4 7.02e-4   NR WP_287561129.1 2294 g15248 i0 36.4 6.02620087336245 77 36 98.3 3 228 4 13 78 WP_287561129.1 ADP-ribosylglycohydrolase family protein [Desulfobacter sp.] diamond 1380 47.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter Desulfobacter sp.
28134764 28134764 PRJNA453567_P_NODE_26585_length_170_cov_1.172932_g26348_i0 PRJNA453567 26585 170 1.172932 1.9939844 Bacteria 2 Bacteria Bacteria 44.7 0.00292   NR MBI9086514.1 2044940 g26348 i0 48.6 5.06470588235294 37 19 65.3 0 2 112 90 126 MBI9086514.1 FAD-dependent oxidoreductase [Desulfobacterales bacterium] diamond 861 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
29602029 29602029 PRJNA453567_P_NODE_19710_length_199_cov_2.141975_g19473_i0 PRJNA453567 19710 199 2.141975 4.26253025 Desulforapulum autotrophicum 2296 Bacteria Bacteria 60.1 1.54e-8   NR WP_015903179.1 2296 g19473 i0 46.8 0.934673366834171 62 31 93.5 1 188 3 379 438 WP_015903179.1 sulfurtransferase [Desulforapulum autotrophicum] diamond 186 60.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulforapulum Desulforapulum autotrophicum
30945541 30945541 PRJNA453567_P_NODE_25634_length_173_cov_1.617647_g25397_i0 PRJNA453567 25634 173 1.617647 2.79852931 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 66.6 5.43e-11   NR MCG8617954.1 2044940 g25397 i0 58.2 11.4277456647399 55 23 95.4 0 8 172 506 560 MCG8617954.1 response regulator [Desulfobacterales bacterium] diamond 1977 66.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31561678 31561678 PRJNA453567_P_NODE_27056_length_168_cov_1.786260_g26819_i0 PRJNA453567 27056 168 1.78626 3.0009168 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 56.6 4.2e-8   NR NTV13522.1 2053307 g26819 i0 54.3 1.66071428571429 46 21 82.1 0 143 6 4 49 NTV13522.1 hypothetical protein [Desulfobulbaceae bacterium] diamond 279 56.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
32052208 32052208 PRJNA453567_P_NODE_30178_length_159_cov_1.918033_g29941_i0 PRJNA453567 30178 159 1.918033 3.04967247 Bacteria 2 Bacteria Bacteria 48.1 1.45e-4   NR WP_205241668.1 869814 g29941 i0 46.9 3.49056603773585 49 26 92.5 0 148 2 446 494 WP_205241668.1 glutamate--tRNA ligase [Desulfobulbus alkaliphilus] diamond 555 48.5 0.991752577319588 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus alkaliphilus
32873312 32873312 PRJNA453567_P_NODE_13220_length_253_cov_1.083333_g12983_i0 PRJNA453567 13220 253 1.083333 2.74083249 Pseudomonadati 3379134 Bacteria Bacteria 42.7 0.0337   NR WP_167940288.1 995050 g12983 i0 35.9 1.61264822134387 64 36 70 1 179 3 124 187 WP_167940288.1 phage baseplate assembly protein V [Desulfobaculum xiamenense] diamond 408 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfobaculum Desulfobaculum xiamenense

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);;