RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA896758" 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

  • PRJNA896758 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
18724332 18724332 PRJNA896758_P_NODE_25855_length_242_cov_0.911243_g25465_i0 PRJNA896758 25855 242 0.911243 2.20520806 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 101 6.649999999999999e-23   NR MCG6905396.1 2049433 g25465 i0 62.7 2.76446280991736 75 28 93 0 227 3 293 367 MCG6905396.1 leucyl aminopeptidase [Desulfobacteraceae bacterium] diamond 669 101 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31066953 31066953 PRJNA896758_P_NODE_23415_length_247_cov_0.885057_g23025_i0 PRJNA896758 23415 247 0.885057 2.18609079 Desulfomicrobium norvegicum 52561 Bacteria Bacteria 42.7 0.0373   NR WP_092190130.1 52561 g23025 i0 34.7 0.874493927125506 72 39 80.2 2 11 208 132 201 WP_092190130.1 hemolytic protein HlpA-like protein [Desulfomicrobium norvegicum] diamond 216 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium norvegicum
31604381 31604381 PRJNA896758_P_NODE_21856_length_250_cov_0.870056_g21466_i0 PRJNA896758 21856 250 0.870056 2.17514 Candidatus Dadabacteria bacterium 2080303 Bacteria Bacteria 44.3 0.0103   NR KAB2833988.1 2080303 g21466 i0 39.2 1.788 74 39 88.8 2 245 24 105 172 KAB2833988.1 MAG: hypothetical protein F9K51_02640 [Candidatus Dadabacteria bacterium] diamond 447 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Dadabacteria       Candidatus Dadabacteria 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);;