RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA1137393" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1137393 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
14313722 14313722 PRJNA1137393_P_NODE_57032_length_165_cov_0.896552_g56516_i0 PRJNA1137393 57032 165 0.896552 1.4793108 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 105 4.65e-25   NR MCF8029794.1 2683721 g56516 i0 96.3 0.981818181818182 54 2 98.2 0 164 3 339 392 MCF8029794.1 trimethylamine methyltransferase family protein [Desulfohalobiaceae bacterium] diamond 162 105 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
27101898 27101898 PRJNA1137393_P_NODE_32342_length_178_cov_1.232558_g31826_i0 PRJNA1137393 32342 178 1.232558 2.19395324 Smithellaceae bacterium 2964540 Bacteria Bacteria 87.4 2.86e-18   NR MFA7177189.1 2964540 g31826 i0 81.4 2.98314606741573 59 11 99.4 0 178 2 1 59 MFA7177189.1 hypothetical protein [Smithellaceae bacterium] diamond 531 87.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae   Smithellaceae bacterium
27196635 27196635 PRJNA1137393_P_NODE_58402_length_165_cov_0.896552_g57886_i0 PRJNA1137393 58402 165 0.896552 1.4793108 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 45.4 0.00144   NR MEF8823079.1 2683721 g57886 i0 70 0.545454545454545 30 9 54.5 0 3 92 630 659 MEF8823079.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Desulfohalobiaceae bacterium] diamond 90 45.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
27228328 27228328 PRJNA1137393_P_NODE_69223_length_162_cov_2.123894_g68707_i0 PRJNA1137393 69223 162 2.123894 3.44070828 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 82.4 1.49e-17   NR MEF8888567.1 2683721 g68707 i0 91.9 1.37037037037037 37 3 68.5 0 51 161 181 217 MEF8888567.1 radical SAM protein [Desulfohalobiaceae bacterium] diamond 222 82.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
30164995 30164995 PRJNA1137393_P_NODE_55612_length_166_cov_0.888889_g55096_i0 PRJNA1137393 55612 166 0.888889 1.47555574 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 106 2.56e-25   NR MEF8889204.1 2683721 g55096 i0 98.1 1.91566265060241 53 1 95.8 0 6 164 314 366 MEF8889204.1 trehalose-6-phosphate synthase [Desulfohalobiaceae bacterium] diamond 318 106 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
30638970 30638970 PRJNA1137393_P_NODE_52693_length_166_cov_0.888889_g52177_i0 PRJNA1137393 52693 166 0.888889 1.47555574 Desulfobacterales bacterium 2044940 Bacteria Bacteria 55.8 1.67e-7   NR MDJ0912425.1 2044940 g52177 i0 64.7 1.21084337349398 34 12 61.4 0 161 60 182 215 MDJ0912425.1 thermonuclease family protein [Desulfobacterales bacterium] diamond 201 55.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31682036 31682036 PRJNA1137393_P_NODE_40557_length_169_cov_0.866667_g40041_i0 PRJNA1137393 40557 169 0.866667 1.46466723 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 106 1.49e-26   NR MEF8943583.1 2683721 g40041 i0 90.9 0.976331360946746 55 5 97.6 0 3 167 11 65 MEF8943583.1 polyphenol oxidase family protein [Desulfohalobiaceae bacterium] diamond 165 106 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
32188542 32188542 PRJNA1137393_P_NODE_62038_length_164_cov_0.904348_g61522_i0 PRJNA1137393 62038 164 0.904348 1.48313072 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 72 6e-13   NR MEF8889342.1 2683721 g61522 i0 91.4 0.640243902439024 35 3 64 0 163 59 93 127 MEF8889342.1 FAD-dependent oxidoreductase [Desulfohalobiaceae bacterium] diamond 105 72 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
32252052 32252052 PRJNA1137393_P_NODE_61618_length_164_cov_0.904348_g61102_i0 PRJNA1137393 61618 164 0.904348 1.48313072 Geobacteraceae bacterium 2282154 Bacteria Bacteria 85.9 7.98e-18   NR HTP65246.1 2282154 g61102 i0 72.2 0.98780487804878 54 15 98.8 0 162 1 1009 1062 HTP65246.1 exodeoxyribonuclease V subunit beta [Geobacteraceae bacterium] diamond 162 85.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
32494075 32494075 PRJNA1137393_P_NODE_37399_length_171_cov_1.549180_g36883_i0 PRJNA1137393 37399 171 1.54918 2.6490978 Pseudomonadati 3379134 Bacteria Bacteria 75.1 1.98e-15   NR MDD2317129.1 2044940 g36883 i0 60.7 4.80701754385965 56 22 98.2 0 4 171 38 93 MDD2317129.1 hypothetical protein [Desulfobacterales bacterium] diamond 822 75.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales 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);;