RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB14803", tax_clade = "Bacteria candidate phyla" 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 · 3 ✖

tax_clade 1

  • Bacteria candidate phyla · 3 ✖

bioproject 1

  • PRJEB14803 · 3 ✖

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
30538559 30538559 PRJEB14803_P_NODE_10813_length_387_cov_3.801136_g10348_i0 PRJEB14803 10813 387 3.801136 14.71039632 candidate division WOR-3 bacterium 2052148 Bacteria Bacteria 50.1 1.33e-4   NR MCS7244980.1 2052148 g10348 i0 32.8 0.89922480620155 116 66 89.9 3 383 36 39 142 MCS7244980.1 Hsp20/alpha crystallin family protein [candidate division WOR-3 bacterium] diamond 348 50.1 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
32277929 32277929 PRJEB14803_P_NODE_39959_length_165_cov_2.761538_g39493_i0 PRJEB14803 39959 165 2.761538 4.5565377 candidate division WOR-3 bacterium 2052148 Bacteria Bacteria 43.5 0.00683   NR MEO0160769.1 2052148 g39493 i0 46.2 0.709090909090909 39 21 70.9 0 45 161 45 83 MEO0160769.1 YCF48-related protein [candidate division WOR-3 bacterium] diamond 117 43.5 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
32303231 32303231 PRJEB14803_P_NODE_11179_length_379_cov_1.508721_g10714_i0 PRJEB14803 11179 379 1.508721 5.71805259 Pseudomonadati 3379134 Bacteria Bacteria 144 1.0499999999999998e-37   NR MEO0278166.1 2052148 g10714 i0 58.3 13.7810026385224 120 50 95 0 1 360 392 511 MEO0278166.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [candidate division WOR-3 bacterium] diamond 5223 144 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);;