RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA666695" and tax_phylum = "candidate division WOR-3"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • candidate division WOR-3 · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA666695 · 4 ✖

analysis 1

tax_kingdom 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
27366278 27366278 PRJNA666695_S_NODE_30663_length_353_cov_21.833333_g29569_i0 PRJNA666695 30663 353 21.833333 77.07166549 candidate division WOR-3 bacterium 2052148 Bacteria Bacteria 95.9 3.51e-22   NR MEO0143739.1 2052148 g29569 i0 51.6 0.773371104815864 91 43 76.5 1 1 270 80 170 MEO0143739.1 macro domain-containing protein [candidate division WOR-3 bacterium] diamond 273 95.9 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
29166003 29166003 PRJNA666695_S_NODE_7489_length_613_cov_4.720280_g6540_i0 PRJNA666695 7489 613 4.72028 28.9353164 candidate division WOR-3 bacterium 2052148 Bacteria Bacteria 53.9 9.43e-5   NR MCK4307176.1 2052148 g6540 i0 49.1 0.269168026101142 55 27 26.9 1 220 384 235 288 MCK4307176.1 DMT family transporter [candidate division WOR-3 bacterium] diamond 165 53.9 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
30903029 30903029 PRJNA666695_S_NODE_106734_length_213_cov_1.604651_g105640_i0 PRJNA666695 106734 213 1.604651 3.41790663 candidate division WOR-3 bacterium 2052148 Bacteria Bacteria 42 0.0468   NR MCK4232894.1 2052148 g105640 i0 36.8 0.802816901408451 57 34 78.9 2 5 172 132 187 MCK4232894.1 PAS domain S-box protein [candidate division WOR-3 bacterium] diamond 171 42 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
30915258 30915258 PRJNA666695_S_NODE_97234_length_222_cov_5.204420_g96140_i0 PRJNA666695 97234 222 5.20442 11.5538124 Bacillati 1783272 Bacteria Bacteria 68.2 4.85e-12   NR MEO0239253.1 2052148 g96140 i0 46.5 2.91891891891892 71 35 95.9 2 10 222 91 158 MEO0239253.1 macro domain-containing protein [candidate division WOR-3 bacterium] diamond 648 68.2 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 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);;