contig_metadata
24 rows where bioproject = "PRJNA255848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1057010 | 1057010 | PRJNA255848_P_NODE_34221_length_169_cov_1.275000_g33903_i0 | PRJNA255848 | 34221 | 169 | 1.275 | 2.15475 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 313 | 5.859999999999999e-81 | NTclustered | gi|28273285|gb|AY157173.1| | 6183 | g33903 | i0 | 100 | 89.8934911242604 | 169 | 0 | 100 | 0 | 1 | 169 | 2051 | 1883 | Schistosoma mansoni 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15192 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 1643473 | 1643473 | PRJNA255848_P_NODE_29182_length_184_cov_1.385185_g28864_i0 | PRJNA255848 | 29182 | 184 | 1.3851850000000001 | 2.5487404 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 279 | 6.61e-71 | NTclustered | gi|3282532|gb|AF025674.1| | 6183 | g28864 | i0 | 94.944 | 93.5869565217391 | 178 | 9 | 97 | 0 | 1 | 178 | 2797 | 2974 | Schistosoma mansoni SR2 subfamily A non-LTR retrotransposon containing an insertion of a SR2 subfamily B non-LTR retrotransposon | blastn | 17220 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 10572671 | 10572671 | PRJNA255848_P_NODE_14889_length_259_cov_1.885714_g14571_i0 | PRJNA255848 | 14889 | 259 | 1.885714 | 4.88399926 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 477 | 3.2799999999999986e-130 | NTclustered | gi|1084307458|ref|XR_001974607.1| | 6183 | g14571 | i0 | 100 | 98.5868725868726 | 258 | 0 | 99 | 0 | 2 | 259 | 1441 | 1184 | Schistosoma mansoni ribosomal RNA rRNA | blastn | 25534 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 15671463 | 15671463 | PRJNA255848_P_NODE_35673_length_167_cov_0.864407_g35355_i0 | PRJNA255848 | 35673 | 167 | 0.864407 | 1.44355969 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 296 | 5.86e-76 | NTclustered | gi|1084302595|ref|XM_018788890.1| | 6183 | g35355 | i0 | 98.795 | 1.98802395209581 | 166 | 2 | 99 | 0 | 1 | 166 | 1078 | 1243 | Schistosoma mansoni putative glutamate synthase partial mRNA | blastn | 332 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 15671526 | 15671526 | PRJNA255848_P_NODE_47893_length_161_cov_0.910714_g47575_i0 | PRJNA255848 | 47893 | 161 | 0.910714 | 1.46624954 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 298 | 1.56e-76 | NTclustered | gi|1084294336|ref|XM_018796014.1| | 6183 | g47575 | i0 | 100 | 4.31055900621118 | 161 | 0 | 100 | 0 | 1 | 161 | 1648 | 1488 | Schistosoma mansoni putative o-linked n-acetylglucosamine transferase, ogt partial mRNA | blastn | 694 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 16945923 | 16945923 | PRJNA255848_P_NODE_13494_length_274_cov_2.408889_g13176_i0 | PRJNA255848 | 13494 | 274 | 2.408889 | 6.60035586 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 507 | 4.47e-139 | NTclustered | gi|28273285|gb|AY157173.1| | 6183 | g13176 | i0 | 100 | 96.6569343065693 | 274 | 0 | 100 | 0 | 1 | 274 | 2749 | 2476 | Schistosoma mansoni 28S large subunit ribosomal RNA gene, partial sequence | blastn | 26484 | 507 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 16946021 | 16946021 | PRJNA255848_P_NODE_39274_length_165_cov_0.879310_g38956_i0 | PRJNA255848 | 39274 | 165 | 0.87931 | 1.4508615 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 119 | 1.34e-22 | NTclustered | gi|60598747|gb|AY810034.1| | 6182 | g38956 | i0 | 90.11 | 1.55151515151515 | 91 | 9 | 55 | 0 | 75 | 165 | 101 | 11 | Schistosoma japonicum SJCHGC06689 protein mRNA, partial cds | blastn | 256 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18220444 | 18220444 | PRJNA255848_P_NODE_7895_length_379_cov_2.006061_g7577_i0 | PRJNA255848 | 7895 | 379 | 2.006061 | 7.60297119 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 701 | 0 | NTclustered | gi|1495840396|gb|MK085970.1| | 6183 | g7577 | i0 | 100 | 98.868073878628 | 379 | 0 | 100 | 0 | 1 | 379 | 466 | 844 | Schistosoma mansoni voucher LVBI12FC1 large subunit ribosomal RNA gene, partial sequence | blastn | 37471 | 701 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 22733792 | 22733792 | PRJNA255848_P_NODE_36838_length_166_cov_1.418803_g36520_i0 | PRJNA255848 | 36838 | 166 | 1.418803 | 2.35521298 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 307 | 2.69e-79 | NTclustered | gi|1805255|gb|U65657.1|SMU65657 | 6183 | g36520 | i0 | 100 | 100.006024096386 | 166 | 0 | 100 | 0 | 1 | 166 | 1802 | 1637 | Schistosoma mansoni 18S ribosomal RNA gene, complete sequence | blastn | 16601 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 24008828 | 24008828 | PRJNA255848_P_NODE_20239_length_221_cov_2.168605_g19921_i0 | PRJNA255848 | 20239 | 221 | 2.168605 | 4.79261705 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 409 | 1.0100000000000001e-109 | NTclustered | gi|28273285|gb|AY157173.1| | 6183 | g19921 | i0 | 100 | 101.203619909502 | 221 | 0 | 100 | 0 | 1 | 221 | 1867 | 1647 | Schistosoma mansoni 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22366 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 24594890 | 24594890 | PRJNA255848_P_NODE_34920_length_167_cov_1.296610_g34602_i0 | PRJNA255848 | 34920 | 167 | 1.29661 | 2.1653387 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 309 | 7.53e-80 | NTclustered | gi|74325485|gb|DQ137574.1| | 6183 | g34602 | i0 | 100 | 92.1796407185629 | 167 | 0 | 100 | 0 | 1 | 167 | 5 | 171 | Schistosoma mansoni clone 153AAT microsatellite sequence | blastn | 15394 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 24594933 | 24594933 | PRJNA255848_P_NODE_43880_length_163_cov_0.894737_g43562_i0 | PRJNA255848 | 43880 | 163 | 0.894737 | 1.45842131 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 250 | 4.49e-62 | NTclustered | gi|1084302811|ref|XM_018789011.1| | 6183 | g43562 | i0 | 98.582 | 5.57668711656442 | 141 | 2 | 87 | 0 | 1 | 141 | 160 | 20 | Schistosoma mansoni pbs lyase heat-like protein partial mRNA | blastn | 909 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 25282893 | 25282893 | PRJNA255848_P_NODE_11880_length_296_cov_1.230769_g11562_i0 | PRJNA255848 | 11880 | 296 | 1.230769 | 3.64307624 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 547 | 2.8799999999999986e-151 | NTclustered | gi|1495840396|gb|MK085970.1| | 6183 | g11562 | i0 | 100 | 99.1587837837838 | 296 | 0 | 100 | 0 | 1 | 296 | 1193 | 898 | Schistosoma mansoni voucher LVBI12FC1 large subunit ribosomal RNA gene, partial sequence | blastn | 29351 | 547 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 25282908 | 25282908 | PRJNA255848_P_NODE_12800_length_283_cov_1.833333_g12482_i0 | PRJNA255848 | 12800 | 283 | 1.833333 | 5.18833239 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 523 | 4.5999999999999983e-144 | NTclustered | gi|2497639026|gb|OQ883999.1| | 6183 | g12482 | i0 | 100 | 100.314487632509 | 283 | 0 | 100 | 0 | 1 | 283 | 512 | 794 | Schistosoma mansoni isolate S4 small subunit ribosomal RNA gene, partial sequence | blastn | 28389 | 523 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 26902091 | 26902091 | PRJNA255848_P_NODE_38821_length_165_cov_1.413793_g38503_i0 | PRJNA255848 | 38821 | 165 | 1.413793 | 2.33275845 | root | 1 | Root_unresolved | Root_unresolved | 107 | 1.03e-27 | NR | AAX25751.2 | 6182 | g38503 | i0 | 98.1 | 250.545454545455 | 53 | 1 | 96.4 | 0 | 160 | 2 | 33 | 85 | AAX25751.2 SJCHGC04980 protein, partial [Schistosoma japonicum] | diamond | 41340 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27944644 | 27944644 | PRJNA255848_P_NODE_34085_length_169_cov_1.700000_g33767_i0 | PRJNA255848 | 34085 | 169 | 1.7 | 2.873 | root | 1 | Root_unresolved | Root_unresolved | 110 | 3.71e-29 | NR | THD26469.1 | 6192 | g33767 | i0 | 96.4 | 242.538461538462 | 56 | 2 | 99.4 | 0 | 168 | 1 | 102 | 157 | THD26469.1 histone H3 [Fasciola hepatica] | diamond | 40989 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 28084622 | 28084622 | PRJNA255848_P_NODE_15565_length_254_cov_0.804878_g15247_i0 | PRJNA255848 | 15565 | 254 | 0.804878 | 2.04439012 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 95.5 | 3.6e-23 | NR | AAX24812.2 | 6182 | g15247 | i0 | 73.7 | 0.673228346456693 | 57 | 15 | 67.3 | 0 | 175 | 5 | 1 | 57 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 171 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28607650 | 28607650 | PRJNA255848_P_NODE_26467_length_193_cov_2.479167_g26149_i0 | PRJNA255848 | 26467 | 193 | 2.479167 | 4.78479231 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 82 | 1.41e-16 | NR | CAH8497687.1 | 6188 | g26149 | i0 | 60.3 | 9.57512953367876 | 63 | 25 | 97.9 | 0 | 191 | 3 | 217 | 279 | CAH8497687.1 unnamed protein product [Schistosoma rodhaini] | diamond | 1848 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 29600017 | 29600017 | PRJNA255848_P_NODE_10070_length_328_cov_1.229391_g9752_i0 | PRJNA255848 | 10070 | 328 | 1.229391 | 4.03240248 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 50.1 | 5.02e-5 | NR | AAX24812.2 | 6182 | g9752 | i0 | 65.7 | 0.557926829268293 | 35 | 12 | 32 | 0 | 108 | 4 | 3 | 37 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 183 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30642585 | 30642585 | PRJNA255848_P_NODE_17733_length_237_cov_0.984043_g17415_i0 | PRJNA255848 | 17733 | 237 | 0.984043 | 2.33218191 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 68.6 | 1.92e-12 | NR | AAX30334.2 | 6182 | g17415 | i0 | 89.7 | 0.493670886075949 | 39 | 4 | 49.4 | 0 | 120 | 236 | 1 | 39 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 117 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31766838 | 31766838 | PRJNA255848_P_NODE_26797_length_192_cov_1.426573_g26479_i0 | PRJNA255848 | 26797 | 192 | 1.426573 | 2.73902016 | root | 1 | Root_unresolved | Root_unresolved | 135 | 3.7e-36 | NR | VDM36598.1 | 6205 | g26479 | i0 | 96.8 | 566.015625 | 63 | 2 | 98.4 | 0 | 3 | 191 | 26 | 88 | VDM36598.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 108675 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 32033921 | 32033921 | PRJNA255848_P_NODE_21618_length_214_cov_1.545455_g21300_i0 | PRJNA255848 | 21618 | 214 | 1.545455 | 3.3072737 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 65.5 | 1.34e-11 | NR | AAX24812.2 | 6182 | g21300 | i0 | 67.5 | 1.94859813084112 | 40 | 13 | 56.1 | 0 | 3 | 122 | 11 | 50 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 417 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32508765 | 32508765 | PRJNA255848_P_NODE_33479_length_171_cov_1.270492_g33161_i0 | PRJNA255848 | 33479 | 171 | 1.270492 | 2.17254132 | Opisthorchis felineus | 147828 | Platyhelminthes | Platyhelminthes | 41.6 | 0.0354 | NR | TGZ59925.1 | 147828 | g33161 | i0 | 43.9 | 0.719298245614035 | 41 | 20 | 66.7 | 1 | 126 | 13 | 183 | 223 | TGZ59925.1 hypothetical protein CRM22_008798 [Opisthorchis felineus] | diamond | 123 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis felineus | |
| 32540377 | 32540377 | PRJNA255848_P_NODE_40879_length_164_cov_1.200000_g40561_i0 | PRJNA255848 | 40879 | 164 | 1.2 | 1.968 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 72 | 5.77e-13 | NR | VDP68547.1 | 27848 | g40561 | i0 | 97.1 | 76.3719512195122 | 34 | 1 | 62.2 | 0 | 62 | 163 | 112 | 145 | VDP68547.1 unnamed protein product [Echinostoma caproni] | diamond | 12525 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni |
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);;