RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB36940" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB36940 · 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
27791587 27791587 PRJEB36940_P_NODE_6004_length_351_cov_1.115108_g5875_i0 PRJEB36940 6004 351 1.115108 3.91402908 Chlamydiales bacterium 2047757 Bacteria Bacteria 125 1.73e-30   NR MFT5318489.1 2047757 g5875 i0 60.2 1.76068376068376 103 39 88 1 311 3 1069 1169 MFT5318489.1 malate synthase [Chlamydiales bacterium] diamond 618 125 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
28139048 28139048 PRJEB36940_P_NODE_5045_length_380_cov_1.622150_g4916_i0 PRJEB36940 5045 380 1.62215 6.16417 Chlamydiota bacterium 2081524 Bacteria Bacteria 92.8 1.17e-19   NR MCX6987222.1 2081524 g4916 i0 65.4 0.615789473684211 78 24 61.6 1 145 378 2 76 MCX6987222.1 transaldolase [Chlamydiota bacterium] diamond 234 92.8 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
29086165 29086165 PRJEB36940_P_NODE_2768_length_508_cov_13.613793_g2641_i0 PRJEB36940 2768 508 13.613793 69.15806844 Chlamydiales bacterium 2047757 Bacteria Bacteria 147 8.13e-42   NR MCP5470421.1 2047757 g2641 i0 51.9 3.5255905511811 156 69 90.9 2 15 476 6 157 MCP5470421.1 hypothetical protein [Chlamydiales bacterium] diamond 1791 147 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
32372996 32372996 PRJEB36940_P_NODE_13539_length_249_cov_0.875000_g13410_i0 PRJEB36940 13539 249 0.875 2.17875 Waddliaceae bacterium 2026802 Bacteria Bacteria 110 1.5600000000000002e-26   NR HEY4832801.1 2026802 g13410 i0 59.8 0.987951807228916 82 33 98.8 0 4 249 121 202 HEY4832801.1 Fe-S cluster assembly protein SufD [Waddliaceae bacterium] diamond 246 110 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Waddliaceae   Waddliaceae 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);;