RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA770361" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA770361 · 15 ✖

analysis 1

  • diamond · 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
24972935 24972935 PRJNA770361_P_NODE_14940_length_250_cov_0.881356_g14845_i0 PRJNA770361 14940 250 0.881356 2.20339 Bacteria 2 Bacteria Bacteria 148 3.09e-39   NR OEU55161.1 1869301 g14845 i0 91.4 1.944 81 7 97.2 0 245 3 92 172 OEU55161.1 MAG: phosphoenolpyruvate synthase [Desulfobacterales bacterium C00003106] diamond 486 148 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium C00003106
26651053 26651053 PRJNA770361_P_NODE_4121_length_464_cov_1.792839_g4026_i0 PRJNA770361 4121 464 1.792839 8.31877296 Pseudomonadati 3379134 Bacteria Bacteria 101 4.81e-24   NR WP_038057828.1 161156 g4026 i0 48 1.26077586206897 98 51 63.4 0 166 459 6 103 WP_038057828.1 cyclic pyranopterin monophosphate synthase MoaC [Thermodesulfobacterium hydrogeniphilum] diamond 585 101 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Thermodesulfobacterium Thermodesulfobacterium hydrogeniphilum
27274527 27274527 PRJNA770361_P_NODE_12843_length_261_cov_0.962766_g12748_i0 PRJNA770361 12843 261 0.962766 2.51281926 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 174 2.17e-51   NR MEA3429428.1 2202153 g12748 i0 97.7 2.95402298850575 86 2 98.9 0 260 3 128 213 MEA3429428.1 HPr family phosphocarrier protein [Thermodesulfobacteriota bacterium] diamond 771 174 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27464187 27464187 PRJNA770361_P_NODE_17043_length_246_cov_0.901734_g16948_i0 PRJNA770361 17043 246 0.901734 2.21826564 Syntrophobacteraceae bacterium 2052185 Bacteria Bacteria 147 5.329999999999998e-42   NR NTV42496.1 2052185 g16948 i0 91.4 0.98780487804878 81 7 98.8 0 2 244 161 241 NTV42496.1 diaminopimelate epimerase [Syntrophobacteraceae bacterium] diamond 243 147 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae   Syntrophobacteraceae bacterium
27495689 27495689 PRJNA770361_P_NODE_14143_length_252_cov_0.871508_g14048_i0 PRJNA770361 14143 252 0.871508 2.19620016 Candidatus Desulfaltia bathyphila 2841697 Bacteria Bacteria 170 5.699999999999999e-47   NR MBC8198674.1 2841697 g14048 i0 97.6 2.98809523809524 84 2 100 0 252 1 1199 1282 MBC8198674.1 pyruvate, phosphate dikinase [Candidatus Desulfaltia bathyphila] diamond 753 170 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales   Candidatus Desulfaltia Candidatus Desulfaltia bathyphila
28158905 28158905 PRJNA770361_P_NODE_13825_length_253_cov_0.866667_g13730_i0 PRJNA770361 13825 253 0.866667 2.19266751 Trichlorobacter sp. 2911007 Bacteria Bacteria 121 9.689999999999999e-30   NR WP_320371733.1 2911007 g13730 i0 79.3 0.972332015810277 82 17 97.2 0 248 3 440 521 WP_320371733.1 ATP-dependent helicase [Trichlorobacter sp.] diamond 246 121 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Trichlorobacter Trichlorobacter sp.
28452602 28452602 PRJNA770361_P_NODE_13806_length_253_cov_0.866667_g13711_i0 PRJNA770361 13806 253 0.866667 2.19266751 Smithella 182623 Bacteria Bacteria 135 5.56e-35   NR NLD79821.1 2053614 g13711 i0 100 2.24110671936759 63 0 74.7 0 189 1 118 180 NLD79821.1 glycerol-3-phosphate dehydrogenase/oxidase [Smithella sp.] diamond 567 135 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae Smithella Smithella sp.
28484070 28484070 PRJNA770361_P_NODE_14306_length_252_cov_0.871508_g14211_i0 PRJNA770361 14306 252 0.871508 2.19620016 Bacteria 2 Bacteria Bacteria 90.5 7.16e-21   NR MCK4469927.1 2044940 g14211 i0 93.3 1.07142857142857 45 3 53.6 0 2 136 108 152 MCK4469927.1 ribose 5-phosphate isomerase B [Desulfobacterales bacterium] diamond 270 90.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
29011522 29011522 PRJNA770361_P_NODE_15308_length_250_cov_0.881356_g15213_i0 PRJNA770361 15308 250 0.881356 2.20339 Syntrophorhabdaceae bacterium 2660714 Bacteria Bacteria 137 1.3599999999999998e-35   NR MBP6941000.1 2660714 g15213 i0 100 0.864 72 0 86.4 0 218 3 590 661 MBP6941000.1 Smr/MutS family protein [Syntrophorhabdaceae bacterium] diamond 216 137 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophorhabdia Syntrophorhabdales Syntrophorhabdaceae   Syntrophorhabdaceae bacterium
29895376 29895376 PRJNA770361_P_NODE_16691_length_247_cov_0.896552_g16596_i0 PRJNA770361 16691 247 0.896552 2.21448344 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 159 3.61e-45   NR NQT09763.1 2049433 g16596 i0 95.1 0.995951417004049 82 4 99.6 0 247 2 149 230 NQT09763.1 diaminopimelate decarboxylase [Desulfobacteraceae bacterium] diamond 246 159 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
30621833 30621833 PRJNA770361_P_NODE_19113_length_242_cov_0.923077_g19018_i0 PRJNA770361 19113 242 0.923077 2.23384634 Desulfobacterales bacterium 2044940 Bacteria Bacteria 160 5.21e-46   NR MCK4469090.1 2044940 g19018 i0 97.5 0.991735537190083 80 2 99.2 0 242 3 243 322 MCK4469090.1 insulinase family protein [Desulfobacterales bacterium] diamond 240 160 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31001189 31001189 PRJNA770361_P_NODE_17174_length_246_cov_0.901734_g17079_i0 PRJNA770361 17174 246 0.901734 2.21826564 Syntrophaceae bacterium 2052184 Bacteria Bacteria 154 2.0299999999999994e-42   NR MBK7551426.1 2052184 g17079 i0 100 0.98780487804878 81 0 98.8 0 3 245 205 285 MBK7551426.1 efflux transporter outer membrane subunit [Syntrophaceae bacterium] diamond 243 154 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae   Syntrophaceae bacterium
31285437 31285437 PRJNA770361_P_NODE_17155_length_246_cov_0.901734_g17060_i0 PRJNA770361 17155 246 0.901734 2.21826564 Trichlorobacter lovleyi 313985 Bacteria Bacteria 87.4 6.94e-18   NR WP_265549881.1 313985 g17060 i0 56.3 0.865853658536585 71 31 86.6 0 244 32 441 511 WP_265549881.1 sigma 54-interacting transcriptional regulator [Trichlorobacter lovleyi] diamond 213 87.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Trichlorobacter Trichlorobacter lovleyi
31759941 31759941 PRJNA770361_P_NODE_16437_length_247_cov_0.896552_g16342_i0 PRJNA770361 16437 247 0.896552 2.21448344 Syntrophales bacterium 2928017 Bacteria Bacteria 170 9.9e-50   NR HPG71760.1 2928017 g16342 i0 97.6 0.995951417004049 82 2 99.6 0 2 247 106 187 HPG71760.1 peptidoglycan bridge formation glycyltransferase FemA/FemB family protein [Syntrophales bacterium] diamond 246 170 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales bacterium
32298224 32298224 PRJNA770361_P_NODE_15699_length_249_cov_0.886364_g15604_i0 PRJNA770361 15699 249 0.886364 2.20704636 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 149 7.6100000000000005e-44   NR MCG2757212.1 2049433 g15604 i0 93 3.42168674698795 71 5 85.5 0 1 213 89 159 MCG2757212.1 YbhB/YbcL family Raf kinase inhibitor-like protein [Desulfobacteraceae bacterium] diamond 852 149 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);;