contig_metadata
19 rows where bioproject = "PRJEB3181", tax_kingdom = "Metazoa" and tax_phylum = "Platyhelminthes"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5158267 | 5158267 | PRJEB3181_P_NODE_1805_length_500_cov_2.494670_g1633_i0 | PRJEB3181 | 1805 | 500 | 2.49467 | 12.47335 | Bresslauilla relicta | 1311963 | Platyhelminthes | Platyhelminthes | 86.1 | 4.82e-12 | NTclustered | gi|588313927|gb|KC869885.1| | 1311963 | g1633 | i0 | 81.081 | 0.336 | 111 | 17 | 22 | 2 | 154 | 264 | 1606 | 1712 | Bresslauilla relicta 28S ribosomal RNA genes, partial sequence | blastn | 168 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Graffillidae | Bresslauilla | Bresslauilla relicta | |
| 6434334 | 6434334 | PRJEB3181_S_NODE_5326_length_262_cov_118.850220_g5033_i0 | PRJEB3181 | 5326 | 262 | 118.85022 | 311.3875764 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 185 | 2.26e-42 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g5033 | i0 | 87.5 | 14.0190839694656 | 160 | 20 | 61 | 0 | 17 | 176 | 1379 | 1538 | Stenostomum sthenum mitochondrion, complete genome | blastn | 3673 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 7708493 | 7708493 | PRJEB3181_S_NODE_7067_length_234_cov_2046.301508_g6774_i0 | PRJEB3181 | 7067 | 234 | 2046.301508 | 4788.34552872 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 95.3 | 3.43e-15 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g6774 | i0 | 91.304 | 28.6367521367521 | 69 | 6 | 29 | 0 | 166 | 234 | 533 | 601 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6701 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 10258639 | 10258639 | PRJEB3181_P_NODE_10649_length_260_cov_7.777293_g10385_i0 | PRJEB3181 | 10649 | 260 | 7.777293 | 20.2209618 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g10385 | i0 | 100 | 0.111538461538462 | 29 | 0 | 11 | 0 | 205 | 233 | 5389 | 5361 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 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 | |
| 12467967 | 12467967 | PRJEB3181_S_NODE_17730_length_154_cov_3.705882_g17437_i0 | PRJEB3181 | 17730 | 154 | 3.705882 | 5.70705828 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 279 | 5.33e-71 | NTclustered | gi|209968707|gb|FJ384870.1| | 52061 | g17437 | i0 | 99.351 | 42.6623376623377 | 154 | 1 | 100 | 0 | 1 | 154 | 190 | 37 | Stenostomum leucops isolate K05_55 28S ribosomal RNA gene, partial sequence | blastn | 6570 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 12809539 | 12809539 | PRJEB3181_P_NODE_7471_length_308_cov_1.722022_g7210_i0 | PRJEB3181 | 7471 | 308 | 1.722022 | 5.30382776 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 361 | 4.21e-95 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g7210 | i0 | 93.416 | 0.788961038961039 | 243 | 16 | 79 | 0 | 66 | 308 | 356 | 114 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 243 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14084428 | 14084428 | PRJEB3181_S_NODE_472_length_631_cov_209.206376_g251_i0 | PRJEB3181 | 472 | 631 | 209.206376 | 1320.09223256 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 1014 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g251 | i0 | 98.438 | 33.2963549920761 | 576 | 9 | 91 | 0 | 53 | 628 | 8984 | 8409 | Stenostomum sthenum mitochondrion, complete genome | blastn | 21010 | 1014 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 16633043 | 16633043 | PRJEB3181_S_NODE_8814_length_212_cov_2483.146893_g8521_i0 | PRJEB3181 | 8814 | 212 | 2483.146893 | 5264.27141316 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 93.5 | 1.1e-14 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g8521 | i0 | 92.308 | 31.7594339622642 | 65 | 5 | 31 | 0 | 148 | 212 | 537 | 601 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6733 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 17566712 | 17566712 | PRJEB3181_S_NODE_5234_length_264_cov_17.209607_g4941_i0 | PRJEB3181 | 5234 | 264 | 17.209607 | 45.43336248 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 483 | 7.219999999999998e-132 | NTclustered | gi|2866376384|gb|PQ722296.1| | 39377 | g4941 | i0 | 99.621 | 99.5227272727273 | 264 | 1 | 100 | 0 | 1 | 264 | 292 | 29 | Stenostomum sp. (in: flatworms) isolate F8 small subunit ribosomal RNA gene, partial sequence | blastn | 26274 | 483 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sp. (in: flatworms) | |||
| 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 | |
| 19181373 | 19181373 | PRJEB3181_P_NODE_13636_length_228_cov_52.177665_g13372_i0 | PRJEB3181 | 13636 | 228 | 52.177665 | 118.9650762 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g13372 | i0 | 100 | 1 | 30 | 0 | 13 | 0 | 1 | 30 | 564 | 535 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 228 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 20456882 | 20456882 | PRJEB3181_S_NODE_2197_length_359_cov_587.246914_g1904_i0 | PRJEB3181 | 2197 | 359 | 587.246914 | 2108.21642126 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 298 | 3.96e-76 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g1904 | i0 | 88.306 | 20.1448467966574 | 248 | 29 | 69 | 0 | 112 | 359 | 14090 | 13843 | Stenostomum sthenum mitochondrion, complete genome | blastn | 7232 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 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
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);;