RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA168635 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
27231932 27231932 PRJNA168635_P_NODE_35203_length_152_cov_3.349515_g34787_i0 PRJNA168635 35203 152 3.349515 5.0912628 Rodentolepis nana 102285 Platyhelminthes Platyhelminthes 44.3 0.00211   NR VDN98320.1 102285 g34787 i0 48.9 1.71710526315789 45 23 88.8 0 148 14 26 70 VDN98320.1 unnamed protein product [Rodentolepis nana] diamond 261 44.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Hymenolepididae Rodentolepis Rodentolepis nana
27629009 27629009 PRJNA168635_P_NODE_28524_length_165_cov_2.568966_g28108_i0 PRJNA168635 28524 165 2.568966 4.2387939 Schistosoma 6181 Platyhelminthes Platyhelminthes 47.8 7.46e-5   NR XP_018645333.1 6183 g28108 i0 59 1.41818181818182 39 16 70.9 0 17 133 69 107 XP_018645333.1 hypothetical protein Smp_177580 [Schistosoma mansoni] diamond 234 47.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
27849664 27849664 PRJNA168635_P_NODE_22284_length_175_cov_5.777778_g21868_i0 PRJNA168635 22284 175 5.777778 10.1111115 Metazoa 33208 Platyhelminthes Platyhelminthes 50.1 1.16e-5   NR VDM21984.1 6205 g21868 i0 68.8 1.92 32 10 54.9 0 128 33 22 53 VDM21984.1 unnamed protein product [Hydatigera taeniaeformis] diamond 336 50.4 0.994047619047619 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Hydatigera Hydatigera taeniaeformis
29631442 29631442 PRJNA168635_P_NODE_21690_length_177_cov_1.726562_g21274_i0 PRJNA168635 21690 177 1.726562 3.05601474 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 55.5 4.62e-7   NR PAA72739.1 282301 g21274 i0 48.1 2.64406779661017 52 27 88.1 0 3 158 176 227 PAA72739.1 hypothetical protein BOX15_Mlig021389g1 [Macrostomum lignano] diamond 468 55.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
29789469 29789469 PRJNA168635_P_NODE_22091_length_176_cov_1.669291_g21675_i0 PRJNA168635 22091 176 1.669291 2.93795216 Neobenedenia melleni 280695 Platyhelminthes Platyhelminthes 72 5.16e-13   NR ABK62794.1 280695 g21675 i0 71.7 0.784090909090909 46 12 78.4 1 34 171 159 203 ABK62794.1 cathepsin L-like cysteine protease [Neobenedenia melleni] diamond 138 72 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Capsalidea Capsalidae Neobenedenia Neobenedenia melleni

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