RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA753112" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA753112 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28231070 28231070 PRJNA753112_P_NODE_17006_length_329_cov_1.828125_g16664_i0 PRJNA753112 17006 329 1.828125 6.01453125 root 1 Root_unresolved Root_unresolved 135 3.8e-36   NR MBI4962568.1 2358 g16664 i0 58.4 4.59574468085106 101 40 92.1 1 324 22 4 102 MBI4962568.1 Tat pathway signal protein [Desulfomonile tiedjei] diamond 1512 135 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfomonilia Desulfomonilales Desulfomonilaceae Desulfomonile Desulfomonile tiedjei
30062607 30062607 PRJNA753112_P_NODE_21011_length_296_cov_2.094170_g20669_i0 PRJNA753112 21011 296 2.09417 6.1987432 Pseudomonadati 3379134 Bacteria Bacteria 125 1.13e-33   NR WP_027360135.1 153026 g20669 i0 69.5 2.73648648648649 82 25 83.1 0 248 3 33 114 WP_027360135.1 papain-like cysteine protease family protein [Desulforegula conservatrix] diamond 810 125 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulforegulaceae Desulforegula Desulforegula conservatrix
31791092 31791092 PRJNA753112_P_NODE_5677_length_572_cov_4.595190_g5338_i0 PRJNA753112 5677 572 4.59519 26.2844868 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 57.8 7.4e-8   NR MBC2734153.1 2049433 g5338 i0 81.4 0.225524475524476 43 8 22.6 0 218 90 1 43 MBC2734153.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 129 57.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
32487532 32487532 PRJNA753112_P_NODE_8939_length_455_cov_1.225131_g8597_i0 PRJNA753112 8939 455 1.225131 5.57434605 Syntrophales bacterium 2928017 Bacteria Bacteria 131 1.01e-35   NR MDP3097440.1 2928017 g8597 i0 51.7 0.791208791208791 120 58 79.1 0 455 96 39 158 MDP3097440.1 hypothetical protein [Syntrophales bacterium] diamond 360 131 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales     Syntrophales 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);;