RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB2925" 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

  • PRJEB2925 · 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
27633640 27633640 PRJEB2925_P_NODE_2424_length_1005_cov_2.969072_g1806_i0 PRJEB2925 2424 1005 2.969072 29.8391736 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 99.4 4.29e-19   NR PAA86220.1 282301 g1806 i0 32.9 0.480597014925373 161 107 47.8 1 647 168 76 236 PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] diamond 483 99.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
28069025 28069025 PRJEB2925_P_NODE_15265_length_258_cov_1.403587_g13987_i0 PRJEB2925 15265 258 1.403587 3.62125446 Opisthokonta 33154 Platyhelminthes Platyhelminthes 55.1 1.06e-6   NR VDP91000.1 27848 g13987 i0 66.7 6.26744186046512 45 14 51.2 1 127 258 55 99 VDP91000.1 unnamed protein product [Echinostoma caproni] diamond 1617 55.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Echinostomatidae Echinostoma Echinostoma caproni
30570108 30570108 PRJEB2925_P_NODE_11273_length_330_cov_2.159322_g9999_i0 PRJEB2925 11273 330 2.159322 7.1257626 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 53.9 1.15e-5   NR PAA93605.1 282301 g9999 i0 29.8 1.89090909090909 104 72 94.5 1 15 326 321 423 PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] diamond 624 53.9 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);;