contig_metadata
20 rows where bioproject = "PRJNA274362", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370650 | 370650 | PRJNA274362_S_NODE_28161_length_178_cov_2.813953_g28041_i0 | PRJNA274362 | 28161 | 178 | 2.813953 | 5.00883634 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 307 | 2.91e-79 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g28041 | i0 | 97.753 | 1 | 178 | 4 | 100 | 0 | 1 | 178 | 216 | 39 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 178 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 6748050 | 6748050 | PRJNA274362_S_NODE_13586_length_242_cov_1.025907_g13466_i0 | PRJNA274362 | 13586 | 242 | 1.025907 | 2.48269494 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 289 | 1.53e-73 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g13466 | i0 | 90.783 | 0.896694214876033 | 217 | 19 | 89 | 1 | 1 | 216 | 8256 | 8040 | Stenostomum sthenum mitochondrion, complete genome | blastn | 217 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 7436510 | 7436510 | PRJNA274362_S_NODE_24246_length_190_cov_6.340426_g24126_i0 | PRJNA274362 | 24246 | 190 | 6.340426 | 12.0468094 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 307 | 3.16e-79 | NTclustered | gi|1126394097|gb|AY813297.2| | 6182 | g24126 | i0 | 99.412 | 34.7421052631579 | 170 | 0 | 89 | 1 | 21 | 190 | 148 | 316 | Schistosoma japonicum clone SJCHGC01483 unknown mRNA, partial cds | blastn | 6601 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9298950 | 9298950 | PRJNA274362_S_NODE_4628_length_387_cov_2.757396_g4508_i0 | PRJNA274362 | 4628 | 387 | 2.757396 | 10.67112252 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 185 | 4.77e-57 | NR | KAA0196388.1 | 27845 | g4508 | i0 | 71.1 | 18.953488372093 | 121 | 35 | 93.8 | 0 | 365 | 3 | 7 | 127 | KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii] | diamond | 7335 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 9299046 | 9299046 | PRJNA274362_S_NODE_9748_length_278_cov_1.807860_g9628_i0 | PRJNA274362 | 9748 | 278 | 1.80786 | 5.0258508 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 114 | 7.96e-30 | NR | AKG62119.1 | 79327 | g9628 | i0 | 61.8 | 1.64028776978417 | 76 | 29 | 82 | 0 | 1 | 228 | 100 | 175 | AKG62119.1 NME/NM23 nucleoside diphosphate kinase 1, partial [Schmidtea mediterranea] | diamond | 456 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 13811947 | 13811947 | PRJNA274362_S_NODE_10871_length_265_cov_3.217593_g10751_i0 | PRJNA274362 | 10871 | 265 | 3.217593 | 8.52662145 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 475 | 1.2099999999999996e-129 | NTclustered | gi|2866376384|gb|PQ722296.1| | 39377 | g10751 | i0 | 99.615 | 96.6754716981132 | 260 | 1 | 98 | 0 | 1 | 260 | 282 | 23 | Stenostomum sp. (in: flatworms) isolate F8 small subunit ribosomal RNA gene, partial sequence | blastn | 25619 | 477 | 0.9958071278826 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sp. (in: flatworms) | |||
| 16947881 | 16947881 | PRJNA274362_S_NODE_20914_length_202_cov_2.013072_g20794_i0 | PRJNA274362 | 20914 | 202 | 2.013072 | 4.06640544 | Catenula sp. THRL1 | 132422 | Platyhelminthes | Platyhelminthes | 102 | 9.56e-25 | NR | AAK57917.1 | 132422 | g20794 | i0 | 69.8 | 0.935643564356436 | 63 | 19 | 93.6 | 0 | 190 | 2 | 155 | 217 | AAK57917.1 elongation factor 1-a, partial [Catenula sp. THRL1] | diamond | 189 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Catenulidae | Catenula | Catenula sp. THRL1 | |||
| 17636131 | 17636131 | PRJNA274362_S_NODE_10394_length_270_cov_2.746606_g10274_i0 | PRJNA274362 | 10394 | 270 | 2.746606 | 7.4158362 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 120 | 1.14e-29 | NR | YP_009391128.1 | 1611831 | g10274 | i0 | 85.7 | 0.777777777777778 | 70 | 10 | 77.8 | 0 | 269 | 60 | 424 | 493 | YP_009391128.1 cytochrome c oxidase subunit I [Stenostomum sthenum] | diamond | 210 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 19496372 | 19496372 | PRJNA274362_S_NODE_16996_length_220_cov_1.497076_g16876_i0 | PRJNA274362 | 16996 | 220 | 1.497076 | 3.2935672 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 270 | 4.9399999999999996e-68 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g16876 | i0 | 88.991 | 0.990909090909091 | 218 | 24 | 99 | 0 | 3 | 220 | 13856 | 14073 | Stenostomum sthenum mitochondrion, complete genome | blastn | 218 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 20771767 | 20771767 | PRJNA274362_S_NODE_1117_length_726_cov_17.084195_g1030_i0 | PRJNA274362 | 1117 | 726 | 17.084195 | 124.0312557 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 1168 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g1030 | i0 | 95.856 | 29.0151515151515 | 724 | 26 | 99 | 4 | 4 | 725 | 8242 | 8963 | Stenostomum sthenum mitochondrion, complete genome | blastn | 21065 | 1168 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 22046953 | 22046953 | PRJNA274362_S_NODE_18018_length_215_cov_1.234940_g17898_i0 | PRJNA274362 | 18018 | 215 | 1.23494 | 2.655121 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 109 | 9.84e-27 | NR | AQN67657.1 | 52061 | g17898 | i0 | 90.7 | 0.753488372093023 | 54 | 5 | 75.3 | 0 | 28 | 189 | 15 | 68 | AQN67657.1 cytochrome b [Stenostomum leucops] | diamond | 162 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 27074033 | 27074033 | PRJNA274362_S_NODE_1302_length_682_cov_4.086888_g1206_i0 | PRJNA274362 | 1302 | 682 | 4.086888 | 27.87257616 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 67.8 | 1.76e-10 | NR | THD25754.1 | 6192 | g1206 | i0 | 37 | 2.1466275659824 | 119 | 72 | 51.9 | 2 | 27 | 380 | 4 | 120 | THD25754.1 Fatty acid-binding protein type 3 [Fasciola hepatica] | diamond | 1464 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 27611281 | 27611281 | PRJNA274362_S_NODE_2784_length_491_cov_3.590498_g2666_i0 | PRJNA274362 | 2784 | 491 | 3.590498 | 17.62934518 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 195 | 4.79e-60 | NR | VDM17221.1 | 6205 | g2666 | i0 | 60 | 7.86965376782077 | 160 | 62 | 97.8 | 1 | 481 | 2 | 60 | 217 | VDM17221.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 3864 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29144748 | 29144748 | PRJNA274362_S_NODE_26949_length_182_cov_1.466165_g26829_i0 | PRJNA274362 | 26949 | 182 | 1.466165 | 2.6684203 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 64.7 | 7.38e-11 | NR | CAH8490743.1 | 6188 | g26829 | i0 | 50 | 6.80769230769231 | 60 | 29 | 98.9 | 1 | 181 | 2 | 84 | 142 | CAH8490743.1 unnamed protein product [Schistosoma rodhaini] | diamond | 1239 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 29505478 | 29505478 | PRJNA274362_S_NODE_2790_length_491_cov_1.981900_g2672_i0 | PRJNA274362 | 2790 | 491 | 1.9819 | 9.731129 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 106 | 2.15e-25 | NR | XP_009162061.1 | 6198 | g2672 | i0 | 39.2 | 3.5132382892057 | 148 | 87 | 89.8 | 2 | 7 | 447 | 56 | 201 | XP_009162061.1 hypothetical protein T265_00140 [Opisthorchis viverrini] | diamond | 1725 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 29789615 | 29789615 | PRJNA274362_S_NODE_26411_length_184_cov_1.044444_g26291_i0 | PRJNA274362 | 26411 | 184 | 1.044444 | 1.92177696 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 45.8 | 0.00117 | NR | XP_024354392.1 | 6210 | g26291 | i0 | 42.9 | 1.59782608695652 | 49 | 21 | 68.5 | 1 | 183 | 58 | 108 | 156 | XP_024354392.1 Cytochrome c oxidase subunit 5B [Echinococcus granulosus] | diamond | 294 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 29916272 | 29916272 | PRJNA274362_S_NODE_16011_length_225_cov_3.545455_g15891_i0 | PRJNA274362 | 16011 | 225 | 3.545455 | 7.97727375 | Schistosoma curassoni | 6186 | Platyhelminthes | Platyhelminthes | 44.7 | 5.09e-4 | NR | CAH8459324.1 | 6186 | g15891 | i0 | 71.9 | 0.426666666666667 | 32 | 9 | 42.7 | 0 | 174 | 79 | 21 | 52 | CAH8459324.1 unnamed protein product [Schistosoma curassoni] | diamond | 96 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma curassoni | |
| 30390448 | 30390448 | PRJNA274362_S_NODE_38193_length_156_cov_2.214953_g38073_i0 | PRJNA274362 | 38193 | 156 | 2.214953 | 3.45532668 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 72.8 | 9.78e-14 | NR | AQN67664.1 | 52061 | g38073 | i0 | 90 | 0.769230769230769 | 40 | 4 | 76.9 | 0 | 11 | 130 | 10 | 49 | AQN67664.1 cytochrome oxidase subunit 3 [Stenostomum leucops] | diamond | 120 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 31147885 | 31147885 | PRJNA274362_S_NODE_15415_length_229_cov_1.727778_g15295_i0 | PRJNA274362 | 15415 | 229 | 1.727778 | 3.95661162 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 75.9 | 3.49e-15 | NR | THD27200.1 | 6192 | g15295 | i0 | 65.2 | 0.602620087336245 | 46 | 16 | 60.3 | 0 | 3 | 140 | 117 | 162 | THD27200.1 DM9 domain-containing protein [Fasciola hepatica] | diamond | 138 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 32746868 | 32746868 | PRJNA274362_S_NODE_14680_length_234_cov_1.545946_g14560_i0 | PRJNA274362 | 14680 | 234 | 1.545946 | 3.61751364 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 94.7 | 1.48e-23 | NR | XP_009176183.1 | 6198 | g14560 | i0 | 93.8 | 14.1025641025641 | 48 | 3 | 61.5 | 0 | 232 | 89 | 28 | 75 | XP_009176183.1 hypothetical protein T265_11298 [Opisthorchis viverrini] | diamond | 3300 | 95.5 | 0.991623036649215 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini |
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);;