RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB80557", tax_kingdom = "Pseudomonadati" 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

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJEB80557 · 4 ✖

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
15441709 15441709 PRJEB80557_S_NODE_6593_length_343_cov_2.717687_g6197_i0 PRJEB80557 6593 343 2.717687 9.32166641 Desulfovibrio desulfuricans 876 Bacteria Bacteria 60.5 2.1e-9   NR WP_227118408.1 876 g6197 i0 87.5 0.568513119533528 32 4 28 0 141 236 1 32 WP_227118408.1 hypothetical protein [Desulfovibrio desulfuricans] diamond 195 60.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
27318868 27318868 PRJEB80557_S_NODE_7523_length_325_cov_3.076087_g7127_i0 PRJEB80557 7523 325 3.076087 9.99728275 Syntrophorhabdaceae bacterium 2660714 Bacteria Bacteria 176 2.39e-50   NR HOV91013.1 2660714 g7127 i0 73.1 2.99076923076923 108 29 99.7 0 325 2 201 308 HOV91013.1 N-6 DNA methylase [Syntrophorhabdaceae bacterium] diamond 972 176 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophorhabdia Syntrophorhabdales Syntrophorhabdaceae   Syntrophorhabdaceae bacterium
28676604 28676604 PRJEB80557_S_NODE_31067_length_174_cov_1.248000_g30671_i0 PRJEB80557 31067 174 1.248 2.17152 Desulfocapsa sulfexigens 65555 Bacteria Bacteria 42.4 0.0212   NR WP_015404236.1 65555 g30671 i0 66.7 0.46551724137931 27 9 46.6 0 105 25 17 43 WP_015404236.1 FkbM family methyltransferase [Desulfocapsa sulfexigens] diamond 81 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfocapsa Desulfocapsa sulfexigens
31385917 31385917 PRJEB80557_S_NODE_4436_length_402_cov_2.155807_g4040_i0 PRJEB80557 4436 402 2.155807 8.66634414 Pseudomonadati 3379134 Bacteria Bacteria 48.5 0.00177   NR PIP08742.1 1974096 g4040 i0 52.6 0.813432835820896 38 18 28.4 0 95 208 177 214 PIP08742.1 MAG: hypothetical protein COX51_02805 [Syntrophobacteraceae bacterium CG23_combo_of_CG06-09_8_20_14_all_50_8] diamond 327 48.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae   Syntrophobacteraceae bacterium CG23_combo_of_CG06-09_8_20_14_all_50_8

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);;