contig_metadata
13 rows where bioproject = "PRJNA874604", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13605112 | 13605112 | PRJNA874604_P_NODE_19971_length_403_cov_1.863636_g19619_i0 | PRJNA874604 | 19971 | 403 | 1.863636 | 7.51045308 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 488 | 2.49e-133 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g19619 | i0 | 88.614 | 1.00248138957816 | 404 | 43 | 99 | 3 | 2 | 403 | 432 | 30 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 404 | 488 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 13605635 | 13605635 | PRJNA874604_P_NODE_47871_length_288_cov_1.432558_g47519_i0 | PRJNA874604 | 47871 | 288 | 1.432558 | 4.12576704 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 111 | 3.08e-26 | NR | VEL23967.1 | 117903 | g47519 | i0 | 62.5 | 4 | 96 | 35 | 100 | 1 | 1 | 288 | 233 | 327 | VEL23967.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 1152 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 22528760 | 22528760 | PRJNA874604_P_NODE_51618_length_281_cov_1.423077_g51266_i0 | PRJNA874604 | 51618 | 281 | 1.423077 | 3.99884637 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 121 | 1.23e-32 | NR | THD21371.1 | 6192 | g51266 | i0 | 67.8 | 21.2562277580071 | 87 | 28 | 92.9 | 0 | 262 | 2 | 75 | 161 | THD21371.1 Dynein light chain 2 cytoplasmic [Fasciola hepatica] | diamond | 5973 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 27915975 | 27915975 | PRJNA874604_P_NODE_50865_length_282_cov_2.210526_g50513_i0 | PRJNA874604 | 50865 | 282 | 2.210526 | 6.23368332 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 104 | 2.41e-26 | NR | KAL3313757.1 | 1844966 | g50513 | i0 | 58.3 | 2.70212765957447 | 84 | 35 | 89.4 | 0 | 1 | 252 | 49 | 132 | KAL3313757.1 60S ribosomal protein L32 [Cichlidogyrus casuarinus] | diamond | 762 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 28444991 | 28444991 | PRJNA874604_P_NODE_64026_length_259_cov_1.241935_g63674_i0 | PRJNA874604 | 64026 | 259 | 1.241935 | 3.21661165 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 134 | 3.96e-34 | NR | KAL3317733.1 | 1844966 | g63674 | i0 | 76.7 | 1.99227799227799 | 86 | 20 | 99.6 | 0 | 1 | 258 | 581 | 666 | KAL3317733.1 hypothetical protein Ciccas_003610 [Cichlidogyrus casuarinus] | diamond | 516 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 28886748 | 28886748 | PRJNA874604_P_NODE_82388_length_247_cov_0.885057_g82036_i0 | PRJNA874604 | 82388 | 247 | 0.885057 | 2.18609079 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 52.8 | 9.49e-6 | NR | VUZ38768.1 | 6216 | g82036 | i0 | 50 | 1.02024291497976 | 42 | 21 | 51 | 0 | 236 | 111 | 99 | 140 | VUZ38768.1 unnamed protein product [Hymenolepis diminuta] | diamond | 252 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 29179246 | 29179246 | PRJNA874604_P_NODE_46929_length_290_cov_1.368664_g46577_i0 | PRJNA874604 | 46929 | 290 | 1.368664 | 3.9691256 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 57 | 4.94e-7 | NR | VDM36091.1 | 6205 | g46577 | i0 | 44.4 | 7.39655172413793 | 63 | 33 | 63.1 | 1 | 62 | 244 | 125 | 187 | VDM36091.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 2145 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29494836 | 29494836 | PRJNA874604_P_NODE_37990_length_315_cov_1.859504_g37638_i0 | PRJNA874604 | 37990 | 315 | 1.859504 | 5.8574376 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 111 | 7.8e-26 | NR | OON20707.1 | 6198 | g37638 | i0 | 66.3 | 30.9333333333333 | 80 | 27 | 76.2 | 0 | 67 | 306 | 502 | 581 | OON20707.1 glutamine-fructose-6-phosphate transaminase [Opisthorchis viverrini] | diamond | 9744 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 29873783 | 29873783 | PRJNA874604_P_NODE_53551_length_277_cov_2.259804_g53199_i0 | PRJNA874604 | 53551 | 277 | 2.259804 | 6.25965708 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 75.9 | 2.36e-14 | NR | KAH9278277.1 | 6210 | g53199 | i0 | 60.3 | 7.10469314079422 | 58 | 23 | 62.8 | 0 | 175 | 2 | 52 | 109 | KAH9278277.1 60S ribosomal protein L11 [Echinococcus granulosus] | diamond | 1968 | 76.3 | 0.99475753604194 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 30086744 | 30086744 | PRJNA874604_P_NODE_71272_length_250_cov_1.553672_g70920_i0 | PRJNA874604 | 71272 | 250 | 1.553672 | 3.88418 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 53.1 | 8.34e-6 | NR | KAL3320116.1 | 1844966 | g70920 | i0 | 56.3 | 2.64 | 48 | 15 | 50.4 | 2 | 219 | 94 | 169 | 216 | KAL3320116.1 Mitogen-activated protein kinase 1 [Cichlidogyrus casuarinus] | diamond | 660 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 30916545 | 30916545 | PRJNA874604_P_NODE_91134_length_244_cov_0.900585_g90782_i0 | PRJNA874604 | 91134 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 2.4800000000000003e-27 | NR | VEL23967.1 | 117903 | g90782 | i0 | 66.7 | 33.5409836065574 | 81 | 27 | 99.6 | 0 | 2 | 244 | 368 | 448 | VEL23967.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 8184 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 31129110 | 31129110 | PRJNA874604_P_NODE_81715_length_247_cov_0.885057_g81363_i0 | PRJNA874604 | 81715 | 247 | 0.885057 | 2.18609079 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 57.4 | 2.82e-7 | NR | CAL5135399.1 | 300641 | g81363 | i0 | 44.6 | 5.25910931174089 | 83 | 40 | 99.6 | 3 | 2 | 247 | 1928 | 2005 | CAL5135399.1 unnamed protein product [Calicophoron daubneyi] | diamond | 1299 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 31572392 | 31572392 | PRJNA874604_P_NODE_96296_length_242_cov_0.911243_g95944_i0 | PRJNA874604 | 96296 | 242 | 0.911243 | 2.20520806 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 80.5 | 2.02e-16 | NR | VZI50126.1 | 99802 | g95944 | i0 | 66.7 | 5.88842975206612 | 57 | 19 | 70.7 | 0 | 67 | 237 | 3 | 59 | VZI50126.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 1425 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;