RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA725806", 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 · 15 ✖

tax_kingdom 1

  • Pseudomonadati · 15 ✖

bioproject 1

  • PRJNA725806 · 15 ✖

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
4540335 4540335 PRJNA725806_P_NODE_52984_length_244_cov_3.797101_g52687_i0 PRJNA725806 52984 244 3.797101 9.26492644 Pseudodesulfovibrio nedwellii 2973072 Bacteria Bacteria 52.8 0.022   NTclustered gi|2342767992|dbj|AP026709.1| 2973072 g52687 i0 100 0.114754098360656 28 0 11 0 46 73 3358677 3358650 Pseudodesulfovibrio sp. SYK DNA, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio nedwellii
7090457 7090457 PRJNA725806_P_NODE_103546_length_195_cov_1.215190_g103244_i0 PRJNA725806 103546 195 1.21519 2.3696205 Desulfonema magnum 45655 Bacteria Bacteria 62.1 2.8e-5   NTclustered gi|2007135636|gb|CP061800.1| 45655 g103244 i0 97.222 10.5641025641026 36 1 18 0 131 166 6850664 6850699 Desulfonema magnum strain 4be13 chromosome, complete genome blastn 2060 62.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfonema Desulfonema magnum
7090735 7090735 PRJNA725806_P_NODE_7586_length_401_cov_4.142857_g7302_i0 PRJNA725806 7586 401 4.142857 16.61285657 Geopsychrobacteraceae bacterium 3065857 Bacteria Bacteria 56.5 0.003   NTclustered gi|2814788343|emb|OY759449.2| 3065857 g7302 i0 100 0.144638403990025 30 0 7 0 301 330 1438196 1438167 MAG: Geopsychrobacteraceae bacterium isolate 8bef1a23-9d7b-4f83-8c15-2fdf164f3e48 genome assembly, chromosome: 1 blastn 58 56.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae   Geopsychrobacteraceae bacterium
9640464 9640464 PRJNA725806_P_NODE_52968_length_244_cov_3.937198_g52671_i0 PRJNA725806 52968 244 3.937198 9.60676312 Syntrophus aciditrophicus 316277 Bacteria Bacteria 52.8 0.022   NTclustered gi|85720936|gb|CP000252.1| 56780 g52671 i0 100 0.114754098360656 28 0 11 0 154 181 2292455 2292482 Syntrophus aciditrophicus SB, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae Syntrophus Syntrophus aciditrophicus
17289850 17289850 PRJNA725806_P_NODE_182074_length_155_cov_2.177966_g181772_i0 PRJNA725806 182074 155 2.177966 3.3758473 Pseudomonadati 3379134 Bacteria Bacteria 95.9 6.1300000000000005e-22   NR WP_078790660.1 115783 g181772 i0 80.4 5.92258064516129 51 10 98.7 0 154 2 229 279 WP_078790660.1 beta-3-deoxy-D-manno-oct-2-ulosonic acid transferase [Trichlorobacter thiogenes] diamond 918 96.7 0.991726990692865 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Trichlorobacter Trichlorobacter thiogenes
23664819 23664819 PRJNA725806_P_NODE_16139_length_334_cov_9.734007_g15849_i0 PRJNA725806 16139 334 9.734007 32.51158338 Thermosulfuriphilus ammonigenes 1936021 Bacteria Bacteria 52.8 0.031   NTclustered gi|1820436950|gb|CP048877.1| 1936021 g15849 i0 96.875 0.0958083832335329 32 0 9 1 163 193 2099492 2099461 Thermosulfuriphilus ammonigenes strain ST65 chromosome, complete genome blastn 32 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Thermosulfuriphilus Thermosulfuriphilus ammonigenes
27020666 27020666 PRJNA725806_P_NODE_55962_length_240_cov_3.428571_g55665_i0 PRJNA725806 55962 240 3.428571 8.2285704 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 42.7 0.0191   NR MBC2713828.1 2049433 g55665 i0 36.2 0.725 58 34 72.5 2 234 61 39 93 MBC2713828.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 174 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
27873528 27873528 PRJNA725806_P_NODE_41625_length_262_cov_4.062222_g41328_i0 PRJNA725806 41625 262 4.062222 10.64302164 uncultured Mailhella sp. 1981031 Bacteria Bacteria 43.1 0.0341   NR WP_294485651.1 1981031 g41328 i0 36.1 0.824427480916031 72 37 73.3 3 237 46 351 421 WP_294485651.1 carboxylesterase/lipase family protein [uncultured Mailhella sp.] diamond 216 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella uncultured Mailhella sp.
28442022 28442022 PRJNA725806_P_NODE_140806_length_173_cov_2.411765_g140504_i0 PRJNA725806 140806 173 2.411765 4.17235345 Desulfurivibrionaceae bacterium 3024425 Bacteria Bacteria 41.6 0.0376   NR MFA6283155.1 3024425 g140504 i0 47.6 0.728323699421965 42 22 72.8 0 155 30 173 214 MFA6283155.1 hypothetical protein [Desulfurivibrionaceae bacterium] diamond 126 41.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfurivibrionaceae   Desulfurivibrionaceae bacterium
28757519 28757519 PRJNA725806_P_NODE_139247_length_174_cov_1.408759_g138945_i0 PRJNA725806 139247 174 1.408759 2.45124066 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 78.6 9.56e-17   NR HEX7125680.1 2202153 g138945 i0 57.4 2.81034482758621 54 23 93.1 0 11 172 26 79 HEX7125680.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 489 78.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30115347 30115347 PRJNA725806_P_NODE_190592_length_152_cov_1.347826_g190290_i0 PRJNA725806 190592 152 1.347826 2.04869552 Candidatus Desulfovibrio gallistercoris 2838533 Bacteria Bacteria 39.3 0.0235   NR HJA77531.1 2838533 g190290 i0 50 0.671052631578947 34 13 67.1 1 146 45 12 41 HJA77531.1 hypothetical protein [Candidatus Desulfovibrio gallistercoris] diamond 102 39.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Candidatus Desulfovibrio gallistercoris
30463418 30463418 PRJNA725806_P_NODE_165193_length_162_cov_1.248000_g164891_i0 PRJNA725806 165193 162 1.248 2.02176 Desulfobacterales bacterium 2044940 Bacteria Bacteria 53.5 6.65e-7   NR MEX1327357.1 2044940 g164891 i0 48.1 3 54 27 98.1 1 161 3 111 164 MEX1327357.1 reverse transcriptase domain-containing protein [Desulfobacterales bacterium] diamond 486 53.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31980390 31980390 PRJNA725806_P_NODE_164758_length_162_cov_2.104000_g164456_i0 PRJNA725806 164758 162 2.104 3.40848 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 40 0.0334   NR WP_300800561.1 167968 g164456 i0 33.3 0.833333333333333 45 30 83.3 0 142 8 14 58 WP_300800561.1 transposase, partial [uncultured Desulfovibrio sp.] diamond 135 40 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
32707451 32707451 PRJNA725806_P_NODE_10080_length_374_cov_6.899110_g9793_i0 PRJNA725806 10080 374 6.89911 25.8026714 Desulfocicer vacuolatum 2298 Bacteria Bacteria 45.8 0.0125   NR WP_170923653.1 2298 g9793 i0 34.3 0.561497326203209 70 44 54.5 1 56 259 13 82 WP_170923653.1 BCCT family transporter [Desulfocicer vacuolatum] diamond 210 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfocicer Desulfocicer vacuolatum
32739203 32739203 PRJNA725806_P_NODE_73280_length_220_cov_1.896175_g72979_i0 PRJNA725806 73280 220 1.896175 4.171585 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 43.1 0.00942   NR MFA6008419.1 2049433 g72979 i0 36.2 0.640909090909091 47 30 64.1 0 21 161 12 58 MFA6008419.1 Hsp20/alpha crystallin family protein [Desulfobacteraceae bacterium] diamond 141 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae 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);;