RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA385073" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA385073 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
2956341 2956341 PRJNA385073_P_NODE_21503_length_310_cov_4.654008_g21341_i0 PRJNA385073 21503 310 4.654008 14.4274248 Geobacter 28231 Bacteria Bacteria 104 1.8899999999999994e-23   NR WP_039646382.1 28231 g21341 i0 100 0.483870967741935 50 0 48.4 0 2 151 279 328 WP_039646382.1 MULTISPECIES: cation acetate symporter [Geobacter] diamond 150 104 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter  
2956809 2956809 PRJNA385073_P_NODE_43223_length_250_cov_0.870056_g43061_i0 PRJNA385073 43223 250 0.870056 2.17514 Geobacter sp. 46610 Bacteria Bacteria 162 1.35e-47   NR RII25261.1 46610 g43061 i0 98.8 1.992 83 1 99.6 0 1 249 101 183 RII25261.1 MAG: 2,5-diketo-D-gluconic acid reductase [Geobacter sp.] diamond 498 162 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
4233031 4233031 PRJNA385073_P_NODE_33144_length_270_cov_2.121827_g32982_i0 PRJNA385073 33144 270 2.121827 5.7289329 Desulfomonile tiedjei 2358 Bacteria Bacteria 137 4.69e-40   NR WP_014808297.1 2358 g32982 i0 91.7 0.8 72 6 80 0 269 54 14 85 WP_014808297.1 50S ribosomal protein L27 [Desulfomonile tiedjei] diamond 216 137 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfomonilia Desulfomonilales Desulfomonilaceae Desulfomonile Desulfomonile tiedjei
19531675 19531675 PRJNA385073_P_NODE_29776_length_279_cov_5.237864_g29614_i0 PRJNA385073 29776 279 5.237864 14.61364056 Geobacter sp. 46610 Bacteria Bacteria 173 2.77e-51   NR RII25746.1 46610 g29614 i0 97.8 0.989247311827957 92 2 98.9 0 2 277 10 101 RII25746.1 MAG: dihydrouridine synthase [Geobacter sp.] diamond 276 173 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
21478007 21478007 PRJNA385073_P_NODE_46717_length_248_cov_0.880000_g46555_i0 PRJNA385073 46717 248 0.88 2.1824 Oryzomonas japonica 2603858 Bacteria Bacteria 159 1.8199999999999998e-43   NR WP_151129738.1 2603858 g46555 i0 93.9 0.991935483870968 82 5 99.2 0 1 246 535 616 WP_151129738.1 elongation factor G [Oryzomonas japonica] diamond 246 159 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Oryzomonas Oryzomonas japonica
27233245 27233245 PRJNA385073_P_NODE_21783_length_310_cov_2.548523_g21621_i0 PRJNA385073 21783 310 2.548523 7.9004213 Geobacteraceae bacterium GWF2_54_21 1798319 Bacteria Bacteria 85.9 3.23e-17   NR OGU24278.1 1798319 g21621 i0 85.7 0.474193548387097 49 7 47.4 0 162 308 78 126 OGU24278.1 MAG: hypothetical protein A2X85_10080 [Geobacteraceae bacterium GWF2_54_21] diamond 147 85.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium GWF2_54_21
27328162 27328162 PRJNA385073_P_NODE_16163_length_343_cov_2.051852_g16002_i0 PRJNA385073 16163 343 2.051852 7.03785236 Deferrisomatales bacterium 2814224 Bacteria Bacteria 160 1.25e-44   NR MDF1552485.1 2814224 g16002 i0 69.3 1.98542274052478 114 34 99.7 1 2 343 280 392 MDF1552485.1 hypothetical protein [Deferrisomatales bacterium] diamond 681 160 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Deferrisomatia Deferrisomatales     Deferrisomatales bacterium
27391442 27391442 PRJNA385073_P_NODE_56303_length_242_cov_1.715976_g56141_i0 PRJNA385073 56303 242 1.715976 4.15266192 Geobacter sp. 46610 Bacteria Bacteria 164 3.1699999999999995e-47   NR RII30640.1 46610 g56141 i0 98.8 0.991735537190083 80 1 99.2 0 240 1 300 379 RII30640.1 MAG: hypothetical protein CXR30_06555 [Geobacter sp.] diamond 240 164 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
27612424 27612424 PRJNA385073_P_NODE_52264_length_245_cov_0.895349_g52102_i0 PRJNA385073 52264 245 0.895349 2.19360505 Desulfuromonas sp. AOP6 1566351 Bacteria Bacteria 42.4 0.0495   NR WP_155875288.1 1566351 g52102 i0 44.2 0.636734693877551 52 29 63.7 0 166 11 243 294 WP_155875288.1 GGDEF domain-containing protein [Desulfuromonas sp. AOP6] diamond 156 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp. AOP6
28938524 28938524 PRJNA385073_P_NODE_54488_length_243_cov_2.300000_g54326_i0 PRJNA385073 54488 243 2.3 5.589 Geobacter sp. 46610 Bacteria Bacteria 127 4.14e-33   NR RII30638.1 46610 g54326 i0 100 0.765432098765432 62 0 76.5 0 241 56 345 406 RII30638.1 MAG: hypothetical protein CXR30_06545 [Geobacter sp.] diamond 186 127 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
29664236 29664236 PRJNA385073_P_NODE_65350_length_199_cov_4.246032_g65188_i0 PRJNA385073 65350 199 4.246032 8.44960368 Geobacter sp. 46610 Bacteria Bacteria 118 2.34e-30   NR RII31235.1 46610 g65188 i0 100 0.844221105527638 56 0 84.4 0 170 3 1 56 RII31235.1 MAG: hypothetical protein CXR30_05250 [Geobacter sp.] diamond 168 118 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
30169832 30169832 PRJNA385073_P_NODE_54072_length_244_cov_0.900585_g53910_i0 PRJNA385073 54072 244 0.900585 2.1974274 Geomonas diazotrophica 2843197 Bacteria Bacteria 44.7 8.16e-4   NR WP_216497151.1 2843197 g53910 i0 86.4 0.270491803278689 22 3 27 0 67 2 1 22 WP_216497151.1 helix-turn-helix transcriptional regulator [Geomonas diazotrophica] diamond 66 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomonas Geomonas diazotrophica
30675355 30675355 PRJNA385073_P_NODE_31953_length_273_cov_2.400000_g31791_i0 PRJNA385073 31953 273 2.4 6.552 Geobacter sp. 46610 Bacteria Bacteria 172 9.1e-48   NR RII31715.1 46610 g31791 i0 96.7 0.989010989010989 90 3 98.9 0 1 270 503 592 RII31715.1 MAG: phenylalanine--tRNA ligase subunit beta [Geobacter sp.] diamond 270 172 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
30818797 30818797 PRJNA385073_P_NODE_32814_length_271_cov_1.595960_g32652_i0 PRJNA385073 32814 271 1.59596 4.3250516 Geobacter 28231 Bacteria Bacteria 171 1.62e-51   NR WP_082021152.1 28231 g32652 i0 98.9 1.97047970479705 89 1 98.5 0 269 3 126 214 WP_082021152.1 MULTISPECIES: nucleoside diphosphate kinase regulator [Geobacter] diamond 534 171 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter  
30959929 30959929 PRJNA385073_P_NODE_21814_length_310_cov_2.375527_g21652_i0 PRJNA385073 21814 310 2.375527 7.3641337 Geobacter sp. 46610 Bacteria Bacteria 102 7.539999999999999e-23   NR RII26116.1 46610 g21652 i0 70.9 0.764516129032258 79 17 76.5 1 2 238 275 347 RII26116.1 MAG: membrane protein insertase YidC [Geobacter sp.] diamond 237 102 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
31023082 31023082 PRJNA385073_P_NODE_28115_length_284_cov_1.635071_g27953_i0 PRJNA385073 28115 284 1.635071 4.64360164 Geobacter sp. 46610 Bacteria Bacteria 193 1.11e-60   NR RII30719.1 46610 g27953 i0 100 0.992957746478873 94 0 99.3 0 283 2 24 117 RII30719.1 MAG: MBL fold metallo-hydrolase [Geobacter sp.] diamond 282 193 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
31497455 31497455 PRJNA385073_P_NODE_25496_length_292_cov_2.739726_g25334_i0 PRJNA385073 25496 292 2.739726 7.99999992 Geobacter 28231 Bacteria Bacteria 157 1.24e-46   NR WP_286350716.1 28231 g25334 i0 81.9 0.965753424657534 94 17 96.6 0 283 2 1 94 WP_286350716.1 MULTISPECIES: hypothetical protein [Geobacter] diamond 282 157 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter  
31845126 31845126 PRJNA385073_P_NODE_34997_length_265_cov_3.427083_g34835_i0 PRJNA385073 34997 265 3.427083 9.08176995 Desulfonatronum thioautotrophicum 617001 Bacteria Bacteria 95.1 1.9e-20   NR WP_045221842.1 617001 g34835 i0 59.6 1.00754716981132 89 35 99.6 1 265 2 345 433 WP_045221842.1 SNF2-related protein [Desulfonatronum thioautotrophicum] diamond 267 95.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonatronaceae Desulfonatronum Desulfonatronum thioautotrophicum
31845141 31845141 PRJNA385073_P_NODE_62297_length_228_cov_3.322581_g62135_i0 PRJNA385073 62297 228 3.322581 7.57548468 Geobacter sp. 46610 Bacteria Bacteria 153 4.19e-42   NR RII28273.1 46610 g62135 i0 98.7 0.986842105263158 75 1 98.7 0 227 3 310 384 RII28273.1 MAG: hypothetical protein CXR30_13800 [Geobacter sp.] diamond 225 153 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
31925333 31925333 PRJNA385073_P_NODE_41657_length_251_cov_0.865169_g41495_i0 PRJNA385073 41657 251 0.865169 2.17157419 Solidesulfovibrio 2910984 Bacteria Bacteria 87.8 8.650000000000001e-21   NR WP_029456761.1 81406 g41495 i0 78.3 1.43426294820717 60 12 71.7 1 232 53 1 59 WP_029456761.1 hypothetical protein [Solidesulfovibrio alcoholivorans] diamond 360 87.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Solidesulfovibrio Solidesulfovibrio alcoholivorans
32098320 32098320 PRJNA385073_P_NODE_62018_length_229_cov_3.673077_g61856_i0 PRJNA385073 62018 229 3.673077 8.41134633 Desulfomonile tiedjei 2358 Bacteria Bacteria 134 1.5499999999999998e-35   NR MBI4962179.1 2358 g61856 i0 85.3 1.96506550218341 75 11 98.3 0 226 2 73 147 MBI4962179.1 bifunctional 3,4-dihydroxy-2-butanone-4-phosphate synthase/GTP cyclohydrolase II [Desulfomonile tiedjei] diamond 450 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfomonilia Desulfomonilales Desulfomonilaceae Desulfomonile Desulfomonile tiedjei
32351700 32351700 PRJNA385073_P_NODE_39339_length_255_cov_2.010989_g39177_i0 PRJNA385073 39339 255 2.010989 5.12802195 Desulfomicrobiaceae bacterium 2053547 Bacteria Bacteria 76.3 5.94e-15   NR MEJ5242608.1 2053547 g39177 i0 75 0.517647058823529 44 11 51.8 0 134 3 1 44 MEJ5242608.1 dTDP-4-dehydrorhamnose 3,5-epimerase [Desulfomicrobiaceae bacterium] diamond 132 76.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae   Desulfomicrobiaceae 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);;