RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB7799 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
32964285 32964285 PRJEB7799a_S_NODE_6218_length_210_cov_1.365714_g6183_i0 PRJEB7799 6218 210 1.365714 2.8679994 Longimicrobium sp. 2029185 Bacteria Bacteria 57.4 5.55e-8   NR HEX2081502.1 2029185 g6183 i0 41.2 0.971428571428571 68 27 80 2 35 202 117 183 HEX2081502.1 hypothetical protein [Longimicrobium sp.] diamond 204 57.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
33083436 33083436 PRJEB7799a_S_NODE_13382_length_170_cov_1.829630_g13347_i0 PRJEB7799 13382 170 1.82963 3.110371 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 49.3 6.67e-5   NR HXY31950.1 2026741 g13347 i0 47.9 0.847058823529412 48 25 84.7 0 168 25 265 312 HXY31950.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 144 49.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
33084227 33084227 PRJEB7799n_S_NODE_11774_length_155_cov_1.941667_g11737_i0 PRJEB7799 11774 155 1.941667 3.00958385 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 49.7 3.95e-5   NR MDP1861325.1 2026741 g11737 i0 55.8 3.63870967741935 43 19 83.2 0 155 27 140 182 MDP1861325.1 glycosyltransferase [Gemmatimonadaceae bacterium] diamond 564 49.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
33151794 33151794 PRJEB7799a_S_NODE_4120_length_238_cov_8.940887_g4085_i0 PRJEB7799 4120 238 8.940887 21.27931106 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 43.5 0.0184   NR HMG12470.1 2026741 g4085 i0 40 1.51260504201681 60 32 75.6 1 34 213 51 106 HMG12470.1 chloride channel protein [Gemmatimonadaceae bacterium] diamond 360 43.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae 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);;