RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB673" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB673 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
9062172 9062172 PRJEB673_P_NODE_2328_length_641_cov_1.719472_g2047_i0 PRJEB673 2328 641 1.719472 11.02181552 Myxococcales 29 Bacteria Bacteria 63.5 1e-7   NR MBL8934140.1 1872627 g2047 i0 63.6 1.2402496099844 44 16 20.6 0 638 507 470 513 MBL8934140.1 hypothetical protein [Archangium sp.] diamond 795 63.9 0.993740219092332 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
27761005 27761005 PRJEB673_P_NODE_4184_length_475_cov_1.984091_g3844_i0 PRJEB673 4184 475 1.984091 9.42443225 Myxococcales bacterium 2026763 Bacteria Bacteria 53.5 7.36e-5   NR MDR0965324.1 2026763 g3844 i0 51.1 1.13684210526316 45 20 27.2 2 464 336 54 98 MDR0965324.1 hypothetical protein [Myxococcales bacterium] diamond 540 53.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
29458199 29458199 PRJEB673_P_NODE_11290_length_162_cov_2.874016_g10941_i0 PRJEB673 11290 162 2.874016 4.65590592 root 1 Root_unresolved Root_unresolved 83.2 5.72e-19   NR MCA9640749.1 2026763 g10941 i0 82.7 6.85185185185185 52 9 96.3 0 5 160 54 105 MCA9640749.1 hypothetical protein [Myxococcales bacterium] diamond 1110 83.6 0.995215311004785 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31677518 31677518 PRJEB673_P_NODE_9197_length_207_cov_1.395349_g8848_i0 PRJEB673 9197 207 1.395349 2.88837243 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 100 9.68e-23   NR MBN1655723.1 2026735 g8848 i0 70.1 0.971014492753623 67 20 97.1 0 205 5 280 346 MBN1655723.1 ATP-dependent protease ATPase subunit HslU [Deltaproteobacteria bacterium] diamond 201 100 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria 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);;