RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA692200" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA692200 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
26682327 26682327 PRJNA692200_S_NODE_14441_length_191_cov_1.028169_g14384_i0 PRJNA692200 14441 191 1.0281690000000001 1.96380279 Opisthokonta 33154 Platyhelminthes Platyhelminthes 52.8 5.34e-6   NR VDL19842.1 6216 g14384 i0 61.8 1.02094240837696 34 13 53.4 0 9 110 269 302 VDL19842.1 unnamed protein product [Hymenolepis diminuta] diamond 195 53.1 0.994350282485876 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Hymenolepididae Hymenolepis Hymenolepis diminuta
26829547 26829547 PRJNA692200_S_NODE_961_length_446_cov_4.052897_g917_i0 PRJNA692200 961 446 4.052897 18.07592062 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 62 5.64e-8   NR PAA93605.1 282301 g917 i0 31.7 1.35874439461883 101 68 67.9 1 445 143 333 432 PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] diamond 606 62 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
29545548 29545548 PRJNA692200_S_NODE_6710_length_261_cov_2.745283_g6653_i0 PRJNA692200 6710 261 2.745283 7.16518863 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 45.1 0.00682   NR PAA93605.1 282301 g6653 i0 40.7 1.24137931034483 54 27 62.1 1 259 98 386 434 PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] diamond 324 45.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
31378289 31378289 PRJNA692200_S_NODE_3056_length_338_cov_3.356401_g2999_i0 PRJNA692200 3056 338 3.356401 11.34463538 Fasciola hepatica 6192 Platyhelminthes Platyhelminthes 43.9 0.00825   NR THD24704.1 6192 g2999 i0 42.6 0.914201183431953 54 30 47.9 1 294 133 46 98 THD24704.1 hypothetical protein D915_004555 [Fasciola hepatica] diamond 309 43.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciola Fasciola hepatica
31504860 31504860 PRJNA692200_S_NODE_6656_length_262_cov_1.291080_g6599_i0 PRJNA692200 6656 262 1.29108 3.3826296 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 55.5 5.36e-7   NR PAA90112.1 282301 g6599 i0 43.9 2.66793893129771 57 32 65.3 0 262 92 117 173 PAA90112.1 hypothetical protein BOX15_Mlig032831g1 [Macrostomum lignano] diamond 699 55.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
32105712 32105712 PRJNA692200_S_NODE_12358_length_204_cov_1.632258_g12301_i0 PRJNA692200 12358 204 1.632258 3.32980632 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 102 5.57e-26   NR AAY97887.1 6182 g12301 i0 94.3 0.779411764705882 53 3 77.9 0 2 160 76 128 AAY97887.1 unknown [Schistosoma japonicum] diamond 159 102 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum

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