RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1174234" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1174234 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
11244245 11244245 PRJNA1174234_P_NODE_9869_length_439_cov_1.207650_g9673_i0 PRJNA1174234 9869 439 1.20765 5.3015835 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 115 1.8000000000000002e-28   NR VUZ52058.1 6216 g9673 i0 46.6 5.59681093394077 103 53 70.4 1 317 9 115 215 VUZ52058.1 unnamed protein product [Hymenolepis diminuta] diamond 2457 116 0.991379310344828 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Hymenolepididae Hymenolepis Hymenolepis diminuta
13069621 13069621 PRJNA1174234_P_NODE_11991_length_398_cov_1.052308_g11795_i0 PRJNA1174234 11991 398 1.052308 4.18818584 Platyhelminthes 6157 Platyhelminthes Platyhelminthes 65.9 1.68e-9   NR KAH8866224.1 6182 g11795 i0 54 8.33668341708543 50 23 37.7 0 246 395 159 208 KAH8866224.1 Fizzy-related protein like [Schistosoma japonicum] diamond 3318 66.2 0.995468277945619 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
21442889 21442889 PRJNA1174234_P_NODE_32617_length_246_cov_0.884393_g32421_i0 PRJNA1174234 32617 246 0.884393 2.17560678 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 78.2 1.22e-14   NR CAH8623356.1 57078 g32421 i0 42.5 1.95121951219512 80 38 97.6 1 242 3 399 470 CAH8623356.1 unnamed protein product [Dicrocoelium dendriticum] diamond 480 78.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
26692248 26692248 PRJNA1174234_P_NODE_20281_length_307_cov_0.978632_g20085_i0 PRJNA1174234 20281 307 0.978632 3.00440024 Schistosoma turkestanicum 1163369 Platyhelminthes Platyhelminthes 45.4 0.00421   NR CAH8528155.1 1163369 g20085 i0 29.1 3.09771986970684 86 52 75.2 2 2 232 76 161 CAH8528155.1 unnamed protein product [Schistosoma turkestanicum] diamond 951 45.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma turkestanicum
27166813 27166813 PRJNA1174234_P_NODE_23662_length_283_cov_1.466667_g23466_i0 PRJNA1174234 23662 283 1.466667 4.15066761 Fasciola hepatica 6192 Platyhelminthes Platyhelminthes 84.7 1.79e-17   NR THD19443.1 6192 g23466 i0 44.8 3.0530035335689 96 50 98.6 1 282 4 68 163 THD19443.1 Sphingosine 1 phosphate lyase 1 [Fasciola hepatica] diamond 864 84.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciola Fasciola hepatica
27735867 27735867 PRJNA1174234_P_NODE_1764_length_923_cov_2.269412_g1626_i0 PRJNA1174234 1764 923 2.269412 20.94667276 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 67.4 1.79e-8   NR PAA93605.1 282301 g1626 i0 23.5 1.96316359696641 302 213 96.9 6 904 11 160 447 PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] diamond 1812 67.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
28859700 28859700 PRJNA1174234_P_NODE_22888_length_288_cov_1.427907_g22692_i0 PRJNA1174234 22888 288 1.427907 4.11237216 Opisthokonta 33154 Platyhelminthes Platyhelminthes 116 1.4599999999999999e-31   NR CDI98016.1 6211 g22692 i0 62.1 32.40625 87 32 90.6 1 270 10 1 86 CDI98016.1 ribosomal protein L37 [Echinococcus multilocularis] diamond 9333 117 0.991452991452991 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus multilocularis
29093415 29093415 PRJNA1174234_P_NODE_33768_length_244_cov_0.900585_g33572_i0 PRJNA1174234 33768 244 0.900585 2.1974274 Heterobilharzia americana 39320 Platyhelminthes Platyhelminthes 87.4 2.8e-18   NR CAH8557482.1 39320 g33572 i0 53.4 0.897540983606557 73 34 89.8 0 15 233 153 225 CAH8557482.1 unnamed protein product [Heterobilharzia americana] diamond 219 87.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Heterobilharzia Heterobilharzia americana
29965043 29965043 PRJNA1174234_P_NODE_23991_length_281_cov_1.360577_g23795_i0 PRJNA1174234 23991 281 1.360577 3.82322137 Platyhelminthes 6157 Platyhelminthes Platyhelminthes 81.6 1.21e-15   NR XP_009169015.1 6198 g23795 i0 53 11.3807829181495 83 37 87.5 2 258 13 430 511 XP_009169015.1 hypothetical protein T265_05682 [Opisthorchis viverrini] diamond 3198 81.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Opisthorchiidae Opisthorchis Opisthorchis viverrini
29977376 29977376 PRJNA1174234_P_NODE_7691_length_494_cov_2.237530_g7495_i0 PRJNA1174234 7691 494 2.23753 11.0533982 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 48.5 0.00392   NR PAA86220.1 282301 g7495 i0 30.6 0.437246963562753 72 48 42.5 1 274 483 76 147 PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] diamond 216 48.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
30628245 30628245 PRJNA1174234_P_NODE_22993_length_287_cov_2.070093_g22797_i0 PRJNA1174234 22993 287 2.070093 5.94116691 Metazoa 33208 Platyhelminthes Platyhelminthes 105 2.7200000000000003e-26   NR TNN06665.1 6182 g22797 i0 63.6 8.61324041811847 77 25 79.4 2 275 48 112 186 TNN06665.1 Muscle LIM protein [Schistosoma japonicum] diamond 2472 105 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31083227 31083227 PRJNA1174234_P_NODE_16255_length_342_cov_2.249071_g16059_i0 PRJNA1174234 16255 342 2.249071 7.69182282 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 144 4.69e-42   NR AAY97887.1 6182 g16059 i0 65.8 0.973684210526316 111 37 97.4 1 335 3 15 124 AAY97887.1 unknown [Schistosoma japonicum] diamond 333 144 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31608355 31608355 PRJNA1174234_P_NODE_34356_length_243_cov_0.905882_g34160_i0 PRJNA1174234 34356 243 0.905882 2.20129326 Plagiorchiida 27871 Platyhelminthes Platyhelminthes 106 3.1999999999999997e-25   NR THD22513.1 6192 g34160 i0 57.5 4.9382716049382704 80 34 98.8 0 241 2 265 344 THD22513.1 GDP-mannose pyrophosphorylase [Fasciola hepatica] diamond 1200 106 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciola Fasciola hepatica
32063571 32063571 PRJNA1174234_P_NODE_23758_length_283_cov_0.847619_g23562_i0 PRJNA1174234 23758 283 0.847619 2.39876177 Cichlidogyrus casuarinus 1844966 Platyhelminthes Platyhelminthes 45.4 0.00575   NR KAL3316124.1 1844966 g23562 i0 38.4 0.911660777385159 86 51 91.2 2 277 20 143 226 KAL3316124.1 Transportin-1 [Cichlidogyrus casuarinus] diamond 258 45.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Dactylogyridea Ancyrocephalidae Cichlidogyrus Cichlidogyrus casuarinus
32601457 32601457 PRJNA1174234_P_NODE_36020_length_239_cov_2.783133_g35824_i0 PRJNA1174234 36020 239 2.783133 6.65168787 Cichlidogyrus casuarinus 1844966 Platyhelminthes Platyhelminthes 43.9 0.0114   NR KAL3318493.1 1844966 g35824 i0 57.6 1.4937238493723899 33 14 41.4 0 1 99 145 177 KAL3318493.1 thymidine kinase 2, mitochondrial [Cichlidogyrus casuarinus] diamond 357 43.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Dactylogyridea Ancyrocephalidae Cichlidogyrus Cichlidogyrus casuarinus
32714934 32714934 PRJNA1174234_P_NODE_22200_length_293_cov_1.050000_g22004_i0 PRJNA1174234 22200 293 1.05 3.0765 Platyhelminthes 6157 Platyhelminthes Platyhelminthes 84.3 1.15e-16   NR VDD76477.1 53468 g22004 i0 78.8 12.4095563139932 52 11 53.2 0 259 104 239 290 VDD76477.1 unnamed protein product [Mesocestoides corti] diamond 3636 84.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Mesocestoididae Mesocestoides Mesocestoides corti
32727389 32727389 PRJNA1174234_P_NODE_1620_length_949_cov_1.721461_g1485_i0 PRJNA1174234 1620 949 1.721461 16.33666489 Hymenolepis diminuta 6216 Platyhelminthes Platyhelminthes 169 3.93e-46   NR VDL51394.1 6216 g1485 i0 36.7 6.36037934668072 294 162 91.7 5 19 888 8 281 VDL51394.1 unnamed protein product [Hymenolepis diminuta] diamond 6036 169 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Hymenolepididae Hymenolepis Hymenolepis diminuta

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