RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1196438" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1196438 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
21999614 21999614 PRJNA1196438_P_NODE_10538_length_327_cov_2.602362_g10112_i0 PRJNA1196438 10538 327 2.602362 8.50972374 Dibothriocephalus latus 60516 Platyhelminthes Platyhelminthes 131 3.45e-36   NR VDN22910.1 60516 g10112 i0 57.4 2.93577981651376 108 45 98.2 1 323 3 27 134 VDN22910.1 unnamed protein product, partial [Dibothriocephalus latus] diamond 960 131 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Dibothriocephalus Dibothriocephalus latus
27028195 27028195 PRJNA1196438_P_NODE_46602_length_278_cov_2.853659_g46175_i0 PRJNA1196438 46602 278 2.853659 7.93317202 Metazoa 33208 Platyhelminthes Platyhelminthes 59.7 3.36e-8   NR PAA58506.1 282301 g46175 i0 36.1 1.73741007194245 83 39 77.7 3 34 249 134 213 PAA58506.1 hypothetical protein BOX15_Mlig007719g1 [Macrostomum lignano] diamond 483 60.1 0.993344425956739 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
27975799 27975799 PRJNA1196438_P_NODE_7665_length_373_cov_1.816667_g7243_i0 PRJNA1196438 7665 373 1.816667 6.77616791 Hymenolepididae 6214 Platyhelminthes Platyhelminthes 114 1.78e-29   NR CDS26983.2 85433 g7243 i0 50.4 1.89812332439678 117 55 94.1 1 360 10 35 148 CDS26983.2 RNA and export factor binding protein 2 [Hymenolepis microstoma] diamond 708 115 0.991304347826087 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Hymenolepididae Hymenolepis Hymenolepis microstoma
28922894 28922894 PRJNA1196438_P_NODE_4848_length_450_cov_2.785146_g4430_i0 PRJNA1196438 4848 450 2.785146 12.533157 Platyhelminthes 6157 Platyhelminthes Platyhelminthes 247 1.04e-77   NR CAE55205.1 37629 g4430 i0 72 256.453333333333 150 42 100 0 450 1 16 165 CAE55205.1 beta-tubulin [Gyrodactylus salaris] diamond 115404 247 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Gyrodactylidea Gyrodactylidae Gyrodactylus Gyrodactylus salaris

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