RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315314 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27786990 27786990 PRJNA315314_S_NODE_24924_length_168_cov_1.489209_g24603_i0 PRJNA315314 24924 168 1.489209 2.50187112 Desulfocapsaceae 2886822 Bacteria Bacteria 87.4 8.52e-19   NR WP_073614043.1 231440 g24603 i0 77.8 4.78571428571429 54 12 96.4 0 5 166 210 263 WP_073614043.1 malate dehydrogenase [Desulfopila aestuarii] diamond 804 87.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfopila Desulfopila aestuarii
28291813 28291813 PRJNA315314_S_NODE_18046_length_194_cov_2.757576_g17725_i0 PRJNA315314 18046 194 2.757576 5.34969744 Pseudomonadati 3379134 Bacteria Bacteria 42.7 0.00899   NR MEW6263850.1 2202153 g17725 i0 58.6 0.865979381443299 29 12 44.8 0 88 2 13 41 MEW6263850.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 168 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29144814 29144814 PRJNA315314_S_NODE_26829_length_162_cov_4.015038_g26508_i0 PRJNA315314 26829 162 4.015038 6.50436156 Pseudomonadati 3379134 Bacteria Bacteria 84 6.24e-18   NR WP_009182997.1 345370 g26508 i0 69.8 3.90740740740741 53 16 98.1 0 160 2 154 206 WP_009182997.1 cytidylyltransferase domain-containing protein [Solidesulfovibrio carbinoliphilus] diamond 633 84 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Solidesulfovibrio Solidesulfovibrio carbinoliphilus
29284682 29284682 PRJNA315314_S_NODE_10609_length_249_cov_2.513636_g10288_i0 PRJNA315314 10609 249 2.513636 6.25895364 Desulfobulbus sp. 895 Bacteria Bacteria 43.5 0.0216   NR MDD2467979.1 895 g10288 i0 36.5 0.759036144578313 63 40 75.9 0 27 215 188 250 MDD2467979.1 hypothetical protein [Desulfobulbus sp.] diamond 189 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus sp.
30548243 30548243 PRJNA315314_S_NODE_4273_length_387_cov_6.857542_g3952_i0 PRJNA315314 4273 387 6.857542 26.53868754 Desulfomonilia bacterium 3041274 Bacteria Bacteria 100 1.4e-21   NR HEY9161941.1 3041274 g3952 i0 51.4 1.84496124031008 107 51 82.2 1 387 70 141 247 HEY9161941.1 alginate lyase family protein [Desulfomonilia bacterium] diamond 714 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfomonilia       Desulfomonilia bacterium
31514239 31514239 PRJNA315314_S_NODE_14236_length_216_cov_6.989305_g13915_i0 PRJNA315314 14236 216 6.989305 15.0968988 Bacteria 2 Bacteria Bacteria 42 0.0397   NR PHR26009.1 2030813 g13915 i0 46.2 1.52777777777778 52 17 59.7 2 44 172 123 172 PHR26009.1 MAG: hypothetical protein COA36_13230 [Desulfotalea sp.] diamond 330 42.4 0.990566037735849 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfotalea Desulfotalea sp.
32886761 32886761 PRJNA315314_S_NODE_1220_length_690_cov_13.588502_g989_i0 PRJNA315314 1220 690 13.588502 93.7606638 Desulfobacterales bacterium HSG2 3055596 Bacteria Bacteria 80.1 2.26e-13   NR MDM8549572.1 3055596 g989 i0 31.9 2.27391304347826 182 107 73 5 563 60 33 211 MDM8549572.1 peptidase inhibitor family I36 protein [Desulfobacterales bacterium HSG2] diamond 1569 80.1 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);;