contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA315399" 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 |
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);;