RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB3181 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
12467915 12467915 PRJEB3181_P_NODE_12770_length_237_cov_2.470874_g12506_i0 PRJEB3181 12770 237 2.470874 5.85597138 Trichobilharzia regenti 157069 Platyhelminthes Platyhelminthes 92.8 8.46e-20   NR CAH8854675.1 157069 g12506 i0 77.4 8.05063291139241 53 12 67.1 0 231 73 798 850 CAH8854675.1 unnamed protein product [Trichobilharzia regenti] diamond 1908 92.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Trichobilharzia Trichobilharzia regenti
17907648 17907648 PRJEB3181_P_NODE_9595_length_274_cov_3.888889_g9331_i0 PRJEB3181 9595 274 3.888889 10.65555586 Opisthokonta 33154 Platyhelminthes Platyhelminthes 126 4.989999999999998e-35   NR VDQ12308.1 157069 g9331 i0 71.4 20.8357664233577 77 22 84.3 0 274 44 72 148 VDQ12308.1 unnamed protein product [Trichobilharzia regenti] diamond 5709 127 0.992125984251969 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Trichobilharzia Trichobilharzia regenti
24281763 24281763 PRJEB3181_P_NODE_27700_length_152_cov_1.016529_g27435_i0 PRJEB3181 27700 152 1.016529 1.54512408 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 88.2 3e-21   NR PAA62966.1 282301 g27435 i0 75 1.93421052631579 48 12 94.7 0 8 151 27 74 PAA62966.1 hypothetical protein BOX15_Mlig026016g1 [Macrostomum lignano] diamond 294 88.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
29048010 29048010 PRJEB3181_S_NODE_7028_length_235_cov_3.015000_g6735_i0 PRJEB3181 7028 235 3.015 7.08525 Metazoa 33208 Platyhelminthes Platyhelminthes 52.4 1.44e-6   NR XP_024348860.1 6210 g6735 i0 48.1 2.05531914893617 54 27 67.7 1 235 77 46 99 XP_024348860.1 40S ribosomal protein S27 [Echinococcus granulosus] diamond 483 52.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus
30254771 30254771 PRJEB3181_S_NODE_12892_length_180_cov_1.655172_g12599_i0 PRJEB3181 12892 180 1.655172 2.9793096 Stenostomum leucops 52061 Platyhelminthes Platyhelminthes 97.8 5.6e-25   NR AQN67658.1 52061 g12599 i0 89.3 0.933333333333333 56 6 93.3 0 175 8 28 83 AQN67658.1 NADH dehydrogenase subunit 4L [Stenostomum leucops] diamond 168 97.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum leucops
30665216 30665216 PRJEB3181_S_NODE_13613_length_175_cov_2.000000_g13320_i0 PRJEB3181 13613 175 2 3.5 Calicophoron daubneyi 300641 Platyhelminthes Platyhelminthes 48.5 5.23e-5   NR CAL5132835.1 300641 g13320 i0 37.7 0.908571428571429 53 33 90.9 0 2 160 27 79 CAL5132835.1 unnamed protein product [Calicophoron daubneyi] diamond 159 48.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Paramphistomidae Calicophoron Calicophoron daubneyi
30690175 30690175 PRJEB3181_S_NODE_4593_length_279_cov_3.811475_g4300_i0 PRJEB3181 4593 279 3.811475 10.63401525 Metazoa 33208 Platyhelminthes Platyhelminthes 68.2 1.83e-12   NR PAA64051.1 282301 g4300 i0 60.3 4.80645161290323 58 20 59.1 1 2 166 8 65 PAA64051.1 hypothetical protein BOX15_Mlig003163g1, partial [Macrostomum lignano] diamond 1341 68.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
31138818 31138818 PRJEB3181_S_NODE_15615_length_164_cov_2.751938_g15322_i0 PRJEB3181 15615 164 2.751938 4.51317832 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 74.3 2.69e-15   NR AAY97887.1 6182 g15322 i0 94.7 0.695121951219512 38 2 69.5 0 162 49 91 128 AAY97887.1 unknown [Schistosoma japonicum] diamond 114 74.3 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);;