RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 16 ✖

bioproject 1

  • PRJNA1078753 · 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
5295300 5295300 PRJNA1078753_P_NODE_20225_length_277_cov_2.014706_g20029_i0 PRJNA1078753 20225 277 2.014706 5.58073562 Trichlorobacter lovleyi 313985 Bacteria Bacteria 76.8 1.51e-9   NTclustered gi|189419341|gb|CP001089.1| 398767 g20029 i0 89.831 0.592057761732852 59 6 21 0 183 241 482732 482790 Geobacter lovleyi SZ, complete genome blastn 164 76.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Trichlorobacter Trichlorobacter lovleyi
15044534 15044534 PRJNA1078753_P_NODE_20612_length_276_cov_1.251232_g20416_i0 PRJNA1078753 20612 276 1.251232 3.45340032 Desulfamplus magnetovallimortis 1246637 Bacteria Bacteria 137 2.42e-35   NR WP_080797595.1 1246637 g20416 i0 74.2 6.81521739130435 89 23 96.7 0 275 9 67 155 WP_080797595.1 propionyl-CoA synthetase [Desulfamplus magnetovallimortis] diamond 1881 137 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfamplus Desulfamplus magnetovallimortis
27121816 27121816 PRJNA1078753_P_NODE_19082_length_282_cov_1.473684_g18886_i0 PRJNA1078753 19082 282 1.473684 4.15578888 Thermodesulfobacteriota 200940 Bacteria Bacteria 154 1.28e-41   NR MBF0225429.1 2044940 g18886 i0 73.4 16 94 25 100 0 282 1 97 190 MBF0225429.1 phosphoenolpyruvate carboxykinase (GTP) [Desulfobacterales bacterium] diamond 4512 154 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
27951956 27951956 PRJNA1078753_P_NODE_865_length_996_cov_6.631636_g726_i0 PRJNA1078753 865 996 6.631636 66.05109456 Candidatus Dadabacteria bacterium 2080303 Bacteria Bacteria 73.9 5.42e-12   NR NIP30510.1 2080303 g726 i0 37.7 0.319277108433735 106 65 31.9 1 433 116 42 146 NIP30510.1 Hsp20 family protein [Candidatus Dadabacteria bacterium] diamond 318 73.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Dadabacteria       Candidatus Dadabacteria bacterium
28015160 28015160 PRJNA1078753_P_NODE_12705_length_326_cov_1.581028_g12509_i0 PRJNA1078753 12705 326 1.581028 5.15415128 Desulfatitalea sp. BRH_c12 1629708 Bacteria Bacteria 58.9 2.81e-8   NR KJS30836.1 1629708 g12509 i0 39.1 0.800613496932515 87 52 80.1 1 319 59 51 136 KJS30836.1 MAG: hypothetical protein VR64_14275 [Desulfatitalea sp. BRH_c12] diamond 261 58.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfatitalea Desulfatitalea sp. BRH_c12
28615007 28615007 PRJNA1078753_P_NODE_26787_length_251_cov_1.730337_g26591_i0 PRJNA1078753 26787 251 1.730337 4.34314587 Syntrophorhabdaceae bacterium 2660714 Bacteria Bacteria 44.3 0.011   NR HEY3278073.1 2660714 g26591 i0 42.1 0.454183266932271 38 22 45.4 0 96 209 6 43 HEY3278073.1 NlpC/P60 family protein [Syntrophorhabdaceae bacterium] diamond 114 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophorhabdia Syntrophorhabdales Syntrophorhabdaceae   Syntrophorhabdaceae bacterium
29215074 29215074 PRJNA1078753_P_NODE_26789_length_251_cov_1.730337_g26593_i0 PRJNA1078753 26789 251 1.730337 4.34314587 Geobacteraceae bacterium 2282154 Bacteria Bacteria 57.4 1.93e-7   NR MDD2321586.1 2282154 g26593 i0 38.3 0.968127490039841 81 49 96.8 1 9 251 65 144 MDD2321586.1 putative 4-mercaptohistidine N1-methyltransferase [Geobacteraceae bacterium] diamond 243 57.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
29435560 29435560 PRJNA1078753_P_NODE_31430_length_248_cov_1.760000_g31234_i0 PRJNA1078753 31430 248 1.76 4.3648 Smithella sp. SDB 1735324 Bacteria Bacteria 68.6 3.18e-11   NR KQC11342.1 1735324 g31234 i0 44.7 1.02822580645161 85 44 99.2 1 1 246 568 652 KQC11342.1 MAG: hypothetical protein APR62_10075 [Smithella sp. SDB] diamond 255 68.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae Smithella Smithella sp. SDB
29458580 29458580 PRJNA1078753_P_NODE_13210_length_321_cov_10.008065_g13014_i0 PRJNA1078753 13210 321 10.008065 32.12588865 root 1 Root_unresolved Root_unresolved 100 6.11e-25   NR KAF0220805.1 2282154 g13014 i0 49.5 4.44859813084112 95 47 88.8 1 287 3 2 95 KAF0220805.1 MAG: chaperonin [Geobacteraceae bacterium] diamond 1428 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
29624814 29624814 PRJNA1078753_P_NODE_13670_length_317_cov_1.672131_g13474_i0 PRJNA1078753 13670 317 1.672131 5.30065527 Pseudodesulfovibrio 2035811 Bacteria Bacteria 46.2 0.00167   NR WP_013513085.1 2035811 g13474 i0 28 0.946372239747634 100 66 94.6 2 6 305 1 94 WP_013513085.1 MULTISPECIES: universal stress protein [Pseudodesulfovibrio] diamond 300 46.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio  
29995892 29995892 PRJNA1078753_P_NODE_13491_length_319_cov_1.252033_g13295_i0 PRJNA1078753 13491 319 1.252033 3.99398527 Pseudomonadati 3379134 Bacteria Bacteria 79.3 1.07e-14   NR OPX36341.1 1956167 g13295 i0 40.4 5.858934169279 104 60 97.8 1 4 315 270 371 OPX36341.1 MAG: hypothetical protein B1H11_07615 [Desulfobacteraceae bacterium 4484_190.1] diamond 1869 79.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium 4484_190.1
31015330 31015330 PRJNA1078753_P_NODE_33395_length_247_cov_0.885057_g33199_i0 PRJNA1078753 33395 247 0.885057 2.18609079 Desulfovibrio sp. 885 Bacteria Bacteria 43.5 0.0207   NR MBQ1846334.1 885 g33199 i0 37.7 1.48178137651822 61 36 71.7 1 179 3 558 618 MBQ1846334.1 AsmA family protein [Desulfovibrio sp.] diamond 366 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
31489805 31489805 PRJNA1078753_P_NODE_26796_length_251_cov_1.719101_g26600_i0 PRJNA1078753 26796 251 1.719101 4.31494351 Desulfobacterales bacterium 2044940 Bacteria Bacteria 52.8 1.19e-5   NR HID02574.1 2044940 g26600 i0 34.7 1.50597609561753 72 46 84.9 1 246 34 405 476 HID02574.1 PAS domain-containing sensor histidine kinase [Desulfobacterales bacterium] diamond 378 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32050417 32050417 PRJNA1078753_P_NODE_11518_length_338_cov_1.162264_g11322_i0 PRJNA1078753 11518 338 1.162264 3.92845232 root 1 Root_unresolved Root_unresolved 104 1.9e-23   NR WP_015947357.1 218208 g11322 i0 51.8 3.99408284023669 112 49 99.4 5 1 336 418 524 WP_015947357.1 thrombospondin type-1 domain-containing protein [Desulfatibacillum aliphaticivorans] diamond 1350 105 0.990476190476191 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfatibacillaceae Desulfatibacillum Desulfatibacillum aliphaticivorans
32249155 32249155 PRJNA1078753_P_NODE_18038_length_287_cov_1.084112_g17842_i0 PRJNA1078753 18038 287 1.084112 3.11140144 Syntrophotalea acetylenivorans 1842532 Bacteria Bacteria 78.6 1.62e-14   NR WP_072284403.1 1842532 g17842 i0 43 1.60975609756098 86 46 86.8 1 286 38 590 675 WP_072284403.1 FAD-dependent oxidoreductase [Syntrophotalea acetylenivorans] diamond 462 78.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Syntrophotaleaceae Syntrophotalea Syntrophotalea acetylenivorans
32470521 32470521 PRJNA1078753_P_NODE_31179_length_249_cov_0.875000_g30983_i0 PRJNA1078753 31179 249 0.875 2.17875 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 43.5 0.00492   NR MBQ7585259.1 2049043 g30983 i0 39.6 0.578313253012048 48 27 55.4 1 247 110 17 64 MBQ7585259.1 SEL1-like repeat protein [Desulfovibrionaceae bacterium] diamond 144 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae 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);;