RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA994052" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA994052 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
26963011 26963011 PRJNA994052_P_NODE_15062_length_313_cov_15.458333_g13841_i0 PRJNA994052 15062 313 15.458333 48.38458229 Smithella sp. 2053614 Bacteria Bacteria 158 9.5e-47   NR MEN6623046.1 2053614 g13841 i0 83 0.843450479233227 88 14 84.3 1 3 266 102 188 MEN6623046.1 phage tail protein [Smithella sp.] diamond 264 158 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae Smithella Smithella sp.
27690306 27690306 PRJNA994052_P_NODE_56024_length_232_cov_6.295597_g54769_i0 PRJNA994052 56024 232 6.295597 14.60578504 Desulfovibrio sp. 885 Bacteria Bacteria 40.4 0.0475   NR MBC17444.1 885 g54769 i0 45.2 0.543103448275862 42 23 54.3 0 105 230 9 50 MBC17444.1 hypothetical protein [Desulfovibrio sp.] diamond 126 40.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
28132110 28132110 PRJNA994052_P_NODE_36545_length_266_cov_7.103627_g35299_i0 PRJNA994052 36545 266 7.103627 18.89564782 Desulfosalsimonadaceae bacterium 3060584 Bacteria Bacteria 43.1 0.0376   NR MDO9265179.1 3060584 g35299 i0 42 0.56390977443609 50 25 56.4 1 14 163 2345 2390 MDO9265179.1 DUF1566 domain-containing protein [Desulfosalsimonadaceae bacterium] diamond 150 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosalsimonadaceae   Desulfosalsimonadaceae bacterium
28194922 28194922 PRJNA994052_P_NODE_77646_length_203_cov_44.469231_g76389_i0 PRJNA994052 77646 203 44.469231 90.27253893 Desulfuromusa sp. 2614228 Bacteria Bacteria 72.8 5.56e-13   NR MCD6582391.1 2614228 g76389 i0 43.3 1.95073891625616 67 38 99 0 201 1 2 68 MCD6582391.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Desulfuromusa sp.] diamond 396 72.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae Desulfuromusa Desulfuromusa sp.
29521191 29521191 PRJNA994052_P_NODE_67650_length_215_cov_76.309859_g66394_i0 PRJNA994052 67650 215 76.309859 164.06619685 Desulfovibrionales bacterium 2448050 Bacteria Bacteria 45.4 0.00286   NR MCG8529688.1 2448050 g66394 i0 43.1 1.5906976744186 58 28 75.3 2 5 166 419 475 MCG8529688.1 tyrosine-protein phosphatase [Desulfovibrionales bacterium] diamond 342 45.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales     Desulfovibrionales bacterium
29773657 29773657 PRJNA994052_P_NODE_30971_length_279_cov_29.427184_g29727_i0 PRJNA994052 30971 279 29.427184 82.10184336 Desulfomarina profundi 2772557 Bacteria Bacteria 55.8 1.14e-6   NR WP_228855658.1 2772557 g29727 i0 42.7 0.806451612903226 75 43 80.6 0 271 47 183 257 WP_228855658.1 PKD domain-containing protein [Desulfomarina profundi] diamond 225 55.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfomarina Desulfomarina profundi
30285533 30285533 PRJNA994052_P_NODE_83232_length_197_cov_25.000000_g81975_i0 PRJNA994052 83232 197 25 49.25 Pseudomonadati 3379134 Bacteria Bacteria 78.6 4.79e-15   NR NMC48075.1 885 g81975 i0 61.4 10.2944162436548 57 22 86.8 0 176 6 123 179 NMC48075.1 efflux RND transporter permease subunit [Desulfovibrio sp.] diamond 2028 79 0.994936708860759 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
32239679 32239679 PRJNA994052_P_NODE_35698_length_268_cov_3.497436_g34452_i0 PRJNA994052 35698 268 3.497436 9.37312848 Desulfobacterales bacterium 2044940 Bacteria Bacteria 124 7.859999999999999e-31   NR MBC8421200.1 2044940 g34452 i0 64.8 10.9477611940299 88 31 98.5 0 4 267 481 568 MBC8421200.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Desulfobacterales bacterium] diamond 2934 124 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);;