RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB50332" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB50332 · 3 ✖

analysis 1

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
24345244 24345244 PRJEB50332_P_NODE_1280_length_483_cov_1.798578_g1199_i0 PRJEB50332 1280 483 1.798578 8.68713174 Thermodesulforhabdaceae bacterium 3050377 Bacteria Bacteria 242 1.02e-73   NR MEJ5301537.1 3050377 g1199 i0 75.6 4.96894409937888 160 39 99.4 0 482 3 324 483 MEJ5301537.1 molecular chaperone DnaK [Thermodesulforhabdaceae bacterium] diamond 2400 242 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Thermodesulforhabdaceae   Thermodesulforhabdaceae bacterium
27823457 27823457 PRJEB50332_P_NODE_14064_length_208_cov_1.639456_g13982_i0 PRJEB50332 14064 208 1.639456 3.41006848 Desulfoluna spongiiphila 419481 Bacteria Bacteria 145 6.13e-42   NR SCY54660.1 419481 g13982 i0 100 0.995192307692308 69 0 99.5 0 207 1 5 73 SCY54660.1 hypothetical protein SAMN05216233_111116 [Desulfoluna spongiiphila] diamond 207 145 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfolunaceae Desulfoluna Desulfoluna spongiiphila
29142913 29142913 PRJEB50332_P_NODE_2269_length_374_cov_2.111821_g2188_i0 PRJEB50332 2269 374 2.111821 7.89821054 Pseudomonadati 3379134 Bacteria Bacteria 129 1.05e-34   NR MBG0776896.1 2049043 g2188 i0 51.3 8.58288770053476 119 58 95.5 0 373 17 81 199 MBG0776896.1 NAD(P)H:quinone oxidoreductase [Desulfovibrionaceae bacterium] diamond 3210 130 0.992307692307692 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);;