RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 11 ✖

bioproject 1

  • PRJNA1199330 · 11 ✖

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
16903118 16903118 PRJNA1199330_P_NODE_70554_length_281_cov_2.057692_g69855_i0 PRJNA1199330 70554 281 2.057692 5.78211452 Desulfovibrio desulfuricans 876 Bacteria Bacteria 514 2.75e-141   NTclustered gi|2884834435|gb|CP176628.1| 876 g69855 i0 99.644 151.975088967972 281 1 100 0 1 281 4140 3860 Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome blastn 42705 514 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
27893681 27893681 PRJNA1199330_P_NODE_21625_length_440_cov_3.479564_g20931_i0 PRJNA1199330 21625 440 3.479564 15.3100816 Candidatus Dadabacteria bacterium 2080303 Bacteria Bacteria 58.2 5.59e-8   NR MCY4042723.1 2080303 g20931 i0 56 1.73181818181818 50 22 34.1 0 440 291 39 88 MCY4042723.1 ankyrin repeat domain-containing protein [Candidatus Dadabacteria bacterium] diamond 762 58.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Dadabacteria       Candidatus Dadabacteria bacterium
29175838 29175838 PRJNA1199330_P_NODE_94889_length_258_cov_2.410811_g94190_i0 PRJNA1199330 94889 258 2.410811 6.21989238 Pseudomonadati 3379134 Bacteria Bacteria 116 5.25e-29   NR MBK5100298.1 2049433 g94190 i0 75 21.2325581395349 68 17 79.1 0 54 257 226 293 MBK5100298.1 peptide-methionine (R)-S-oxide reductase MsrB [Desulfobacteraceae bacterium] diamond 5478 117 0.991452991452991 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
29251297 29251297 PRJNA1199330_P_NODE_94649_length_258_cov_3.243243_g93950_i0 PRJNA1199330 94649 258 3.243243 8.36756694 Desulfobacterales bacterium 2044940 Bacteria Bacteria 83.6 7.43e-17   NR MCG2778030.1 2044940 g93950 i0 48.1 0.918604651162791 79 40 91.9 1 258 22 232 309 MCG2778030.1 carbohydrate kinase family protein [Desulfobacterales bacterium] diamond 237 83.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
30786554 30786554 PRJNA1199330_P_NODE_95934_length_257_cov_2.179348_g95235_i0 PRJNA1199330 95934 257 2.179348 5.60092436 Bacteria 2 Bacteria Bacteria 106 4.11e-27   NR WP_028577986.1 29503 g95235 i0 60.5 3.92217898832685 86 33 99.2 1 2 256 60 145 WP_028577986.1 DUF1810 domain-containing protein [Desulfomicrobium escambiense] diamond 1008 107 0.990654205607477 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium escambiense
30988955 30988955 PRJNA1199330_P_NODE_84794_length_268_cov_1.641026_g84095_i0 PRJNA1199330 84794 268 1.641026 4.39794968 Trichlorobacter sp. 2911007 Bacteria Bacteria 45.1 0.00429   NR MDY0301212.1 2911007 g84095 i0 37.6 1.41044776119403 85 32 95.1 3 13 267 52 115 MDY0301212.1 adenine phosphoribosyltransferase [Trichlorobacter sp.] diamond 378 45.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Trichlorobacter Trichlorobacter sp.
31178109 31178109 PRJNA1199330_P_NODE_22775_length_429_cov_3.853933_g22080_i0 PRJNA1199330 22775 429 3.853933 16.53337257 Desulfobacterales bacterium HSG2 3055596 Bacteria Bacteria 53.9 3.42e-5   NR MDM8552009.1 3055596 g22080 i0 42.2 0.447552447552448 64 35 43.4 1 41 226 362 425 MDM8552009.1 SMP-30/gluconolactonase/LRE family protein [Desulfobacterales bacterium HSG2] diamond 192 53.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium HSG2
31399947 31399947 PRJNA1199330_P_NODE_61756_length_289_cov_1.444444_g61057_i0 PRJNA1199330 61756 289 1.444444 4.17444316 Desulfuromonas thiophila 57664 Bacteria Bacteria 198 1.5e-63   NR MDD3802452.1 57664 g61057 i0 93.8 0.996539792387543 96 6 99.7 0 2 289 3 98 MDD3802452.1 transposase [Desulfuromonas thiophila] diamond 288 198 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas thiophila
31558156 31558156 PRJNA1199330_P_NODE_99876_length_253_cov_1.733333_g99177_i0 PRJNA1199330 99876 253 1.733333 4.38533249 Oceanidesulfovibrio indonesiensis 54767 Bacteria Bacteria 70.5 1.81e-12   NR WP_144304240.1 54767 g99177 i0 43.5 1.09090909090909 92 42 98.4 3 251 3 85 175 WP_144304240.1 FkbM family methyltransferase [Oceanidesulfovibrio indonesiensis] diamond 276 70.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Oceanidesulfovibrio Oceanidesulfovibrio indonesiensis
32178070 32178070 PRJNA1199330_P_NODE_85598_length_267_cov_2.268041_g84899_i0 PRJNA1199330 85598 267 2.268041 6.05566947 Pseudomonadati 3379134 Bacteria Bacteria 103 1.99e-23   NR WP_306533778.1 46610 g84899 i0 57.3 7.74157303370786 82 35 92.1 0 20 265 324 405 WP_306533778.1 multicopper oxidase family protein [Geobacter sp.] diamond 2067 103 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
32317491 32317491 PRJNA1199330_P_NODE_120239_length_233_cov_2.487500_g119540_i0 PRJNA1199330 120239 233 2.4875 5.795875 Desulfobacterales bacterium HSG2 3055596 Bacteria Bacteria 52 1.81e-5   NR MDM8552009.1 3055596 g119540 i0 39.4 0.849785407725322 66 38 82.4 1 35 226 363 428 MDM8552009.1 SMP-30/gluconolactonase/LRE family protein [Desulfobacterales bacterium HSG2] diamond 198 52 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium HSG2

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