RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Placozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Placozoa · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA630162 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
10805588 10805588 PRJNA630162_P_NODE_110309_length_179_cov_3.115385_g108786_i0 PRJNA630162 110309 179 3.115385 5.57653915 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 106 3.06e-25   NR XP_002112890.1 10228 g108786 i0 86 18.2178770949721 57 8 95.5 0 172 2 229 285 XP_002112890.1 eukaryotic translation initiation factor 2 gamma [Trichoplax adhaerens] diamond 3261 107 0.990654205607477 Eukaryota Opisthokonta Metazoa Placozoa Uniplacotomia Trichoplacea Trichoplacidae Trichoplax Trichoplax adhaerens
28849016 28849016 PRJNA630162_P_NODE_23528_length_378_cov_2.522796_g22009_i0 PRJNA630162 23528 378 2.522796 9.53616888 Placozoa sp. H2 HM-2 573895 Placozoa other_Eukaryota 45.8 0.00238   NR BBI37372.1 2017985 g22009 i0 47.8 0.365079365079365 46 24 36.5 0 215 352 11 56 BBI37372.1 hypothetical protein [Placozoa sp. H2 HM-2017] diamond 138 45.8 1 Eukaryota Opisthokonta Metazoa Placozoa         Placozoa sp. H2 HM-2017
29461454 29461454 PRJNA630162_P_NODE_115610_length_176_cov_14.716535_g114087_i0 PRJNA630162 115610 176 14.716535 25.9011016 Trichoplax 10227 Placozoa other_Eukaryota 41.6 0.00909   NR EDV20230.1 10228 g114087 i0 63.9 1.22727272727273 36 13 61.4 0 130 23 7 42 EDV20230.1 hypothetical protein TRIADDRAFT_32270 [Trichoplax adhaerens] diamond 216 41.6 1 Eukaryota Opisthokonta Metazoa Placozoa Uniplacotomia Trichoplacea Trichoplacidae Trichoplax Trichoplax adhaerens

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