contig_metadata
18 rows where bioproject = "PRJNA315399", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1657146 | 1657146 | PRJNA315399_P_NODE_291442_length_179_cov_3.936620_g290994_i0 | PRJNA315399 | 291442 | 179 | 3.93662 | 7.0465498 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 108 | 3.19e-19 | NTclustered | gi|690890525|emb|LN395113.1| | 99802 | g290994 | i0 | 98.361 | 1.0391061452514 | 61 | 1 | 34 | 0 | 16 | 76 | 1 | 61 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0241153 | blastn | 186 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 5485674 | 5485674 | PRJNA315399_P_NODE_259065_length_181_cov_3.729167_g258617_i0 | PRJNA315399 | 259065 | 181 | 3.729167 | 6.74979227 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|1084298151|ref|XM_018797096.1| | 6183 | g258617 | i0 | 100 | 0.160220994475138 | 29 | 0 | 16 | 0 | 17 | 45 | 166 | 194 | Schistosoma mansoni hypothetical protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 6168826 | 6168826 | PRJNA315399_P_NODE_383705_length_163_cov_7.079365_g383257_i0 | PRJNA315399 | 383705 | 163 | 7.079365 | 11.53936495 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 135 | 1.3100000000000002e-27 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g383257 | i0 | 100 | 87.1717791411043 | 73 | 0 | 86 | 0 | 17 | 89 | 739 | 667 | Schistosoma japonicum unknown mRNA | blastn | 14209 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9309153 | 9309153 | PRJNA315399_P_NODE_100688_length_201_cov_3.841463_g100240_i0 | PRJNA315399 | 100688 | 201 | 3.841463 | 7.72134063 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 60.2 | 1.04e-4 | NTclustered | gi|690480383|emb|LN022558.1| | 99802 | g100240 | i0 | 81.081 | 2.86069651741294 | 74 | 14 | 37 | 0 | 1 | 74 | 7132 | 7205 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0022181 | blastn | 575 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 10585661 | 10585661 | PRJNA315399_P_NODE_20369_length_294_cov_100.416342_g19926_i0 | PRJNA315399 | 20369 | 294 | 100.416342 | 295.22404548 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 254 | 6.97e-63 | NTclustered | gi|690816508|emb|LN310741.1| | 99802 | g19926 | i0 | 84.249 | 1.38775510204082 | 273 | 29 | 93 | 8 | 12 | 284 | 529 | 271 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0219101 | blastn | 408 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 13138078 | 13138078 | PRJNA315399_S_NODE_124091_length_169_cov_1.719697_g123890_i0 | PRJNA315399 | 124091 | 169 | 1.719697 | 2.90628793 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|687703571|emb|LK563487.1| | 57078 | g123890 | i0 | 94.444 | 0.21301775147929 | 36 | 1 | 21 | 1 | 36 | 70 | 351 | 386 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0158971 | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 14412664 | 14412664 | PRJNA315399_P_NODE_52072_length_235_cov_4.838384_g51624_i0 | PRJNA315399 | 52072 | 235 | 4.838384 | 11.3702024 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.021 | NTclustered | gi|690851313|emb|LN350557.1| | 99802 | g51624 | i0 | 100 | 0.119148936170213 | 28 | 0 | 12 | 0 | 104 | 131 | 237 | 264 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0121685 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 18235768 | 18235768 | PRJNA315399_S_NODE_104035_length_176_cov_11.079137_g103834_i0 | PRJNA315399 | 104035 | 176 | 11.079137 | 19.49928112 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 289 | 1.04e-73 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g103834 | i0 | 98.182 | 63.3693181818182 | 165 | 3 | 94 | 0 | 10 | 174 | 8815 | 8979 | Stenostomum sthenum mitochondrion, complete genome | blastn | 11153 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 20193132 | 20193132 | PRJNA315399_S_NODE_6616_length_401_cov_16.774725_g6417_i0 | PRJNA315399 | 6616 | 401 | 16.774725 | 67.26664725 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 736 | 0 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g6417 | i0 | 99.751 | 99.2743142144638 | 401 | 1 | 100 | 0 | 1 | 401 | 217 | 617 | Schistosoma japonicum unknown mRNA | blastn | 39809 | 736 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 20785079 | 20785079 | PRJNA315399_P_NODE_501137_length_151_cov_3.298246_g500689_i0 | PRJNA315399 | 501137 | 151 | 3.298246 | 4.98035146 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 93.5 | 7.26e-15 | NTclustered | gi|60600276|gb|AY810793.1| | 6182 | g500689 | i0 | 89.189 | 6.07284768211921 | 74 | 8 | 49 | 0 | 4 | 77 | 88 | 15 | Schistosoma japonicum SJCHGC09635 protein mRNA, partial cds | blastn | 917 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 22057778 | 22057778 | PRJNA315399_P_NODE_122158_length_194_cov_2.006369_g121710_i0 | PRJNA315399 | 122158 | 194 | 2.006369 | 3.89235586 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 54.7 | 0.005 | NTclustered | gi|2318772814|ref|XM_051216883.1| | 6185 | g121710 | i0 | 94.286 | 0.180412371134021 | 35 | 2 | 18 | 0 | 112 | 146 | 1851 | 1885 | Schistosoma haematobium uncharacterized protein (MS3_00008551), mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 22743681 | 22743681 | PRJNA315399_S_NODE_24118_length_264_cov_18.696035_g23917_i0 | PRJNA315399 | 24118 | 264 | 18.696035 | 49.3575324 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 453 | 5.66e-123 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g23917 | i0 | 100 | 92.8030303030303 | 245 | 0 | 93 | 0 | 20 | 264 | 253 | 9 | Schistosoma japonicum unknown mRNA | blastn | 24500 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28211239 | 28211239 | PRJNA315399_P_NODE_466286_length_154_cov_5.871795_g465838_i0 | PRJNA315399 | 466286 | 154 | 5.871795 | 9.0425643 | Schistosoma curassoni | 6186 | Platyhelminthes | Platyhelminthes | 50.1 | 1.28e-5 | NR | VDP64617.1 | 6186 | g465838 | i0 | 56.8 | 2.68831168831169 | 44 | 19 | 85.7 | 0 | 134 | 3 | 49 | 92 | VDP64617.1 unnamed protein product [Schistosoma curassoni] | diamond | 414 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma curassoni | |
| 28653536 | 28653536 | PRJNA315399_S_NODE_137507_length_164_cov_6.062992_g137306_i0 | PRJNA315399 | 137507 | 164 | 6.062992 | 9.94330688 | Protopolystoma xenopodis | 117903 | Platyhelminthes | Platyhelminthes | 42 | 0.0148 | NR | VEL37462.1 | 117903 | g137306 | i0 | 61.4 | 0.804878048780488 | 44 | 12 | 71.3 | 1 | 10 | 126 | 1 | 44 | VEL37462.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 132 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 29379668 | 29379668 | PRJNA315399_P_NODE_62249_length_224_cov_8.898396_g61801_i0 | PRJNA315399 | 62249 | 224 | 8.898396 | 19.93240704 | Paragonimus kellicotti | 100269 | Platyhelminthes | Platyhelminthes | 49.3 | 9.38e-5 | NR | KAF6773936.1 | 100269 | g61801 | i0 | 53.5 | 1.17857142857143 | 43 | 20 | 57.6 | 0 | 205 | 77 | 123 | 165 | KAF6773936.1 hypothetical protein AHF37_06135 [Paragonimus kellicotti] | diamond | 264 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 29948106 | 29948106 | PRJNA315399_P_NODE_349511_length_169_cov_9.446970_g349063_i0 | PRJNA315399 | 349511 | 169 | 9.44697 | 15.9653793 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 49.7 | 4.91e-5 | NR | KAA3669829.1 | 34504 | g349063 | i0 | 54.3 | 0.816568047337278 | 46 | 21 | 81.7 | 0 | 29 | 166 | 185 | 230 | KAA3669829.1 uncharacterized protein DEA37_0001408, partial [Paragonimus westermani] | diamond | 138 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31292481 | 31292481 | PRJNA315399_P_NODE_366975_length_166_cov_2.852713_g366527_i0 | PRJNA315399 | 366975 | 166 | 2.852713 | 4.73550358 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 7.66e-7 | NR | CAH8869896.1 | 157069 | g366527 | i0 | 55.6 | 4.96987951807229 | 45 | 20 | 81.3 | 0 | 10 | 144 | 149 | 193 | CAH8869896.1 unnamed protein product [Trichobilharzia regenti] | diamond | 825 | 55.1 | 0.992740471869329 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 32526695 | 32526695 | PRJNA315399_P_NODE_452719_length_156_cov_2.747899_g452271_i0 | PRJNA315399 | 452719 | 156 | 2.747899 | 4.28672244 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 52.8 | 3.12e-6 | NR | XP_051072164.1 | 6185 | g452271 | i0 | 64.7 | 8.21153846153846 | 34 | 12 | 65.4 | 0 | 154 | 53 | 286 | 319 | XP_051072164.1 hypothetical protein MS3_00001239 [Schistosoma haematobium] | diamond | 1281 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium |
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);;