contig_metadata
23 rows where bioproject = "PRJNA971593", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 944260 | 944260 | PRJNA971593_P_NODE_23001_length_250_cov_0.870056_g22852_i0 | PRJNA971593 | 23001 | 250 | 0.870056 | 2.17514 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 148 | 1.7299999999999996e-43 | NR | THD23439.1 | 6192 | g22852 | i0 | 79.5 | 1.992 | 83 | 17 | 99.6 | 0 | 2 | 250 | 59 | 141 | THD23439.1 Peptidyl-prolyl cis-trans isomerase [Fasciola hepatica] | diamond | 498 | 149 | 0.993288590604027 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 4772697 | 4772697 | PRJNA971593_P_NODE_3124_length_678_cov_2.198347_g2982_i0 | PRJNA971593 | 3124 | 678 | 2.198347 | 14.90479266 | Chimaerohemecus trondheimensis | 216968 | Platyhelminthes | Platyhelminthes | 134 | 2.35e-26 | NTclustered | gi|29690329|gb|AY157239.1| | 216968 | g2982 | i0 | 86.29 | 3.50589970501475 | 124 | 15 | 18 | 1 | 160 | 283 | 2380 | 2259 | Chimaerohemecus trondheimensis 28S large subunit ribosomal RNA gene, partial sequence | blastn | 2377 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Aporocotylidae | Chimaerohemecus | Chimaerohemecus trondheimensis | |
| 9872462 | 9872462 | PRJNA971593_P_NODE_23668_length_249_cov_0.875000_g23519_i0 | PRJNA971593 | 23668 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 174 | 1.57e-50 | NR | RTG84574.1 | 6184 | g23519 | i0 | 93.9 | 207.469879518072 | 82 | 5 | 98.8 | 0 | 3 | 248 | 71 | 152 | RTG84574.1 histone deacetylase 1/2 [Schistosoma bovis] | diamond | 51660 | 175 | 0.994285714285714 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 15294277 | 15294277 | PRJNA971593_P_NODE_7652_length_440_cov_1.089918_g7503_i0 | PRJNA971593 | 7652 | 440 | 1.089918 | 4.7956392 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 813 | 0 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g7503 | i0 | 100 | 100 | 440 | 0 | 100 | 0 | 1 | 440 | 53 | 492 | Schistosoma japonicum unknown mRNA | blastn | 44000 | 813 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 16246999 | 16246999 | PRJNA971593_P_NODE_16033_length_298_cov_1.488889_g15884_i0 | PRJNA971593 | 16033 | 298 | 1.488889 | 4.43688922 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 107 | 2.23e-26 | NR | VUZ52058.1 | 6216 | g15884 | i0 | 52.5 | 3.97651006711409 | 99 | 47 | 99.7 | 0 | 297 | 1 | 90 | 188 | VUZ52058.1 unnamed protein product [Hymenolepis diminuta] | diamond | 1185 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 21346509 | 21346509 | PRJNA971593_P_NODE_8417_length_418_cov_3.489855_g8268_i0 | PRJNA971593 | 8417 | 418 | 3.489855 | 14.5875939 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 479 | 1.5599999999999993e-130 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g8268 | i0 | 87.53 | 0.997607655502392 | 417 | 49 | 99 | 3 | 3 | 418 | 432 | 18 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 417 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23896674 | 23896674 | PRJNA971593_P_NODE_17139_length_288_cov_1.074419_g16990_i0 | PRJNA971593 | 17139 | 288 | 1.074419 | 3.09432672 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 137 | 2.9899999999999997e-35 | NR | RTG83976.1 | 6184 | g16990 | i0 | 60 | 8.90625 | 95 | 38 | 99 | 0 | 286 | 2 | 183 | 277 | RTG83976.1 creatine kinase [Schistosoma bovis] | diamond | 2565 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 27151959 | 27151959 | PRJNA971593_P_NODE_8922_length_407_cov_0.916168_g8773_i0 | PRJNA971593 | 8922 | 407 | 0.916168 | 3.72880376 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 62.4 | 1.63e-8 | NR | PAA92045.1 | 282301 | g8773 | i0 | 34 | 2.14496314496314 | 97 | 61 | 71.5 | 1 | 115 | 405 | 127 | 220 | PAA92045.1 hypothetical protein BOX15_Mlig019930g1, partial [Macrostomum lignano] | diamond | 873 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27310655 | 27310655 | PRJNA971593_P_NODE_483_length_1482_cov_2.081618_g416_i0 | PRJNA971593 | 483 | 1482 | 2.081618 | 30.84957876 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 200 | 1.2799999999999999e-54 | NR | PAA93605.1 | 282301 | g416 | i0 | 30 | 1.67611336032389 | 414 | 270 | 83.6 | 6 | 211 | 1449 | 56 | 450 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 2484 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27562835 | 27562835 | PRJNA971593_P_NODE_21244_length_255_cov_2.104396_g21095_i0 | PRJNA971593 | 21244 | 255 | 2.104396 | 5.3662098 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 68.9 | 6.33e-12 | NR | PAA92100.1 | 282301 | g21095 | i0 | 38.6 | 0.976470588235294 | 83 | 51 | 97.6 | 0 | 5 | 253 | 104 | 186 | PAA92100.1 hypothetical protein BOX15_Mlig018188g1 [Macrostomum lignano] | diamond | 249 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27658019 | 27658019 | PRJNA971593_P_NODE_28204_length_242_cov_0.911243_g28055_i0 | PRJNA971593 | 28204 | 242 | 0.911243 | 2.20520806 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 101 | 1.35e-25 | NR | AAY97887.1 | 6182 | g28055 | i0 | 63.8 | 0.991735537190083 | 80 | 28 | 99.2 | 1 | 240 | 1 | 15 | 93 | AAY97887.1 unknown [Schistosoma japonicum] | diamond | 240 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27784338 | 27784338 | PRJNA971593_P_NODE_9904_length_385_cov_2.961538_g9755_i0 | PRJNA971593 | 9904 | 385 | 2.961538 | 11.4019213 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 42.4 | 0.0395 | NR | XP_024354019.1 | 6210 | g9755 | i0 | 37.7 | 0.412987012987013 | 53 | 32 | 41.3 | 1 | 174 | 16 | 40 | 91 | XP_024354019.1 Dynein light chain 1, cytoplasmic [Echinococcus granulosus] | diamond | 159 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 27853493 | 27853493 | PRJNA971593_P_NODE_2264_length_788_cov_3.134266_g2131_i0 | PRJNA971593 | 2264 | 788 | 3.134266 | 24.69801608 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 58.5 | 1.18e-6 | NR | KAF6771429.1 | 100269 | g2131 | i0 | 34.2 | 1.11167512690355 | 73 | 47 | 27.4 | 1 | 6 | 221 | 82 | 154 | KAF6771429.1 hypothetical protein AHF37_09851 [Paragonimus kellicotti] | diamond | 876 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 28453597 | 28453597 | PRJNA971593_P_NODE_14826_length_312_cov_0.966527_g14677_i0 | PRJNA971593 | 14826 | 312 | 0.966527 | 3.01556424 | Fasciolidae | 27843 | Platyhelminthes | Platyhelminthes | 129 | 1.18e-35 | NR | THD25954.1 | 6192 | g14677 | i0 | 58.3 | 1.98076923076923 | 103 | 41 | 99 | 1 | 3 | 311 | 23 | 123 | THD25954.1 Superoxide dismutase [Fasciola hepatica] | diamond | 618 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 29678210 | 29678210 | PRJNA971593_P_NODE_13710_length_325_cov_1.361111_g13561_i0 | PRJNA971593 | 13710 | 325 | 1.361111 | 4.42361075 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 98.2 | 3.4e-21 | NR | CAH8479948.1 | 39320 | g13561 | i0 | 61.8 | 1.86461538461538 | 68 | 26 | 62.8 | 0 | 2 | 205 | 647 | 714 | CAH8479948.1 unnamed protein product [Heterobilharzia americana] | diamond | 606 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 29684492 | 29684492 | PRJNA971593_P_NODE_4870_length_549_cov_1.596639_g4724_i0 | PRJNA971593 | 4870 | 549 | 1.596639 | 8.76554811 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 49.3 | 0.00103 | NR | VDL63945.1 | 6216 | g4724 | i0 | 27.3 | 4.37704918032787 | 88 | 60 | 47 | 2 | 15 | 272 | 70 | 155 | VDL63945.1 unnamed protein product [Hymenolepis diminuta] | diamond | 2403 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 30026131 | 30026131 | PRJNA971593_P_NODE_7131_length_455_cov_1.908377_g6982_i0 | PRJNA971593 | 7131 | 455 | 1.908377 | 8.68311535 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 65.5 | 3.85e-9 | NR | PAA86220.1 | 282301 | g6982 | i0 | 34.7 | 1.29230769230769 | 98 | 63 | 64 | 1 | 455 | 165 | 139 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 588 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30089075 | 30089075 | PRJNA971593_P_NODE_21192_length_256_cov_1.262295_g21043_i0 | PRJNA971593 | 21192 | 256 | 1.262295 | 3.2314752 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 70.9 | 5.64e-12 | NR | VDD84003.1 | 53468 | g21043 | i0 | 40 | 3.9609375 | 85 | 49 | 99.6 | 1 | 255 | 1 | 136 | 218 | VDD84003.1 unnamed protein product [Mesocestoides corti] | diamond | 1014 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 30474698 | 30474698 | PRJNA971593_P_NODE_6273_length_486_cov_1.876513_g6125_i0 | PRJNA971593 | 6273 | 486 | 1.876513 | 9.11985318 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 216 | 8.87e-65 | NR | CAH8479366.1 | 6185 | g6125 | i0 | 62.7 | 10.7469135802469 | 158 | 59 | 97.5 | 0 | 2 | 475 | 343 | 500 | CAH8479366.1 unnamed protein product [Schistosoma haematobium] | diamond | 5223 | 217 | 0.995391705069124 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 31163096 | 31163096 | PRJNA971593_P_NODE_11955_length_349_cov_1.847826_g11806_i0 | PRJNA971593 | 11955 | 349 | 1.847826 | 6.44891274 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 69.3 | 5.69e-11 | NR | PAA93605.1 | 282301 | g11806 | i0 | 29.9 | 1.82234957020057 | 97 | 67 | 83.4 | 1 | 292 | 2 | 321 | 416 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 636 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32245507 | 32245507 | PRJNA971593_P_NODE_20378_length_262_cov_1.878307_g20229_i0 | PRJNA971593 | 20378 | 262 | 1.878307 | 4.92116434 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 62 | 7.4e-9 | NR | PAA60074.1 | 282301 | g20229 | i0 | 39.5 | 3.8587786259542 | 76 | 46 | 87 | 0 | 262 | 35 | 301 | 376 | PAA60074.1 hypothetical protein BOX15_Mlig029719g1 [Macrostomum lignano] | diamond | 1011 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32492206 | 32492206 | PRJNA971593_P_NODE_17259_length_287_cov_1.205607_g17110_i0 | PRJNA971593 | 17259 | 287 | 1.205607 | 3.46009209 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 50.1 | 1.62e-4 | NR | PAA86220.1 | 282301 | g17110 | i0 | 26.5 | 1.73519163763066 | 83 | 55 | 80.5 | 1 | 231 | 1 | 132 | 214 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 498 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32775672 | 32775672 | PRJNA971593_P_NODE_17600_length_284_cov_1.454976_g17451_i0 | PRJNA971593 | 17600 | 284 | 1.454976 | 4.1321318399999996 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 132 | 3.7799999999999996e-34 | NR | CDS27691.1 | 85433 | g17451 | i0 | 68.8 | 0.982394366197183 | 93 | 29 | 98.2 | 0 | 284 | 6 | 365 | 457 | CDS27691.1 Biotin lipoyl attachment [Hymenolepis microstoma] | diamond | 279 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma |
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);;