RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1104180" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1104180 · 3 ✖

analysis 1

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
6123375 6123375 PRJNA1104180_P_NODE_26205_length_241_cov_1.255952_g26062_i0 PRJNA1104180 26205 241 1.255952 3.02684432 Dugesiidae 31262 Platyhelminthes Platyhelminthes 71.3 5.99e-8   NTclustered gi|298501370|gb|HM149271.1| 6161 g26062 i0 100 2.46887966804979 38 0 16 0 204 241 289 326 Dugesia japonica strain Pek-1 18S ribosomal RNA gene, partial sequence blastn 595 71.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
14241173 14241173 PRJNA1104180_P_NODE_22032_length_248_cov_0.880000_g21889_i0 PRJNA1104180 22032 248 0.88 2.1824 Hexostoma thynni 92220 Platyhelminthes Platyhelminthes 130 1.01e-25   NTclustered gi|2195271684|gb|OM731590.1| 92220 g21889 i0 92.391 3.84274193548387 92 5 37 2 1 91 7484 7574 Hexostoma thynni small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA and large subunit ribosomal RNA genes, complete sequence blastn 953 130 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Diclybothriidea Hexostomatidae Hexostoma Hexostoma thynni
24438154 24438154 PRJNA1104180_P_NODE_13600_length_285_cov_5.245283_g13458_i0 PRJNA1104180 13600 285 5.245283 14.94905655 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 494 3.64e-135   NTclustered gi|926460157|gb|KR132223.1| 282301 g13458 i0 97.895 1 285 6 100 0 1 285 532 248 Macrostomum lignano clone c100550_g1_i1 mRNA sequence blastn 285 494 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano

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