RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA657860" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA657860 · 3 ✖

analysis 1

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
26764849 26764849 PRJNA657860_P_NODE_2881_length_175_cov_1.086957_g2825_i0 PRJNA657860 2881 175 1.086957 1.90217475 Polyangiaceae bacterium 2268199 Bacteria Bacteria 77.4 7.3e-15   NR HTQ08171.1 2268199 g2825 i0 62.1 1.98857142857143 58 22 99.4 0 174 1 131 188 HTQ08171.1 S53 family peptidase [Polyangiaceae bacterium] diamond 348 77.4 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
28186557 28186557 PRJNA657860_P_NODE_1946_length_221_cov_1.489130_g1890_i0 PRJNA657860 1946 221 1.48913 3.2909773 Corallococcus caeni 3082388 Bacteria Bacteria 65.1 9.55e-11   NR WP_338278474.1 3082388 g1890 i0 60 2.57918552036199 50 20 67.9 0 155 6 2 51 WP_338278474.1 malonic semialdehyde reductase [Corallococcus caeni] diamond 570 65.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus caeni
31926871 31926871 PRJNA657860_P_NODE_957_length_339_cov_2.549669_g901_i0 PRJNA657860 957 339 2.549669 8.64337791 Pseudomonadati 3379134 Bacteria Bacteria 139 5.999999999999998e-39   NR WP_044236814.1 51 g901 i0 60 5.87610619469027 110 44 97.3 0 1 330 45 154 WP_044236814.1 NAD(P)H:quinone oxidoreductase [Chondromyces apiculatus] diamond 1992 140 0.992857142857143 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Chondromyces Chondromyces apiculatus

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);;