contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2979740 | 2979740 | PRJNA432257_S_NODE_114483_length_162_cov_1.160000_g114102_i0 | PRJNA432257 | 114483 | 162 | 1.16 | 1.8792 | Brachydistomum sp. PakPr2 | 2714095 | Platyhelminthes | Platyhelminthes | 204 | 3.52e-48 | NTclustered | gi|1829660974|gb|MK685273.1| | 2714095 | g114102 | i0 | 92.857 | 41.4506172839506 | 140 | 10 | 86 | 0 | 20 | 159 | 9297 | 9158 | Brachydistomum sp. PakPr2 mitochondrion, partial genome | blastn | 6715 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Brachydistomum | Brachydistomum sp. PakPr2 | |
| 6808011 | 6808011 | PRJNA432257_S_NODE_93466_length_181_cov_21.944444_g93085_i0 | PRJNA432257 | 93466 | 181 | 21.944444 | 39.71944364 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 63.9 | 7.1e-6 | NTclustered | gi|687545731|emb|LK646609.1| | 57078 | g93085 | i0 | 100 | 2.46961325966851 | 34 | 0 | 19 | 0 | 101 | 134 | 479 | 446 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0024035 | blastn | 447 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 7466871 | 7466871 | PRJNA432257_S_NODE_58646_length_217_cov_1088.166667_g58265_i0 | PRJNA432257 | 58646 | 217 | 1088.166667 | 2361.32166739 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 0.019 | NTclustered | gi|2318773805|ref|XM_051217790.1| | 6185 | g58265 | i0 | 100 | 0.258064516129032 | 28 | 0 | 13 | 0 | 108 | 135 | 2494 | 2467 | Schistosoma haematobium Potassium voltage-gated channel sub C member 4 (KCNC4_2), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 16391249 | 16391249 | PRJNA432257_S_NODE_35993_length_261_cov_34.415179_g35612_i0 | PRJNA432257 | 35993 | 261 | 34.415179 | 89.82361719 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 0.024 | NTclustered | gi|2318773805|ref|XM_051217790.1| | 6185 | g35612 | i0 | 100 | 0.21455938697318 | 28 | 0 | 11 | 0 | 152 | 179 | 2494 | 2467 | Schistosoma haematobium Potassium voltage-gated channel sub C member 4 (KCNC4_2), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 17666306 | 17666306 | PRJNA432257_S_NODE_3414_length_601_cov_2.939716_g3208_i0 | PRJNA432257 | 3414 | 601 | 2.939716 | 17.66769316 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 1053 | 0 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g3208 | i0 | 99.482 | 95.8452579034942 | 579 | 3 | 96 | 0 | 23 | 601 | 8 | 586 | Schistosoma japonicum unknown mRNA | blastn | 57603 | 1053 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 20832002 | 20832002 | PRJNA432257_S_NODE_94617_length_180_cov_82.923077_g94236_i0 | PRJNA432257 | 94617 | 180 | 82.923077 | 149.2615386 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 250 | 5.04e-62 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g94236 | i0 | 97.279 | 82.7111111111111 | 147 | 4 | 82 | 0 | 34 | 180 | 2378 | 2524 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 14888 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 24656069 | 24656069 | PRJNA432257_S_NODE_47540_length_235_cov_16.010101_g47159_i0 | PRJNA432257 | 47540 | 235 | 16.010101 | 37.62373735 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 52.8 | 0.021 | NTclustered | gi|1084312780|ref|XM_018793587.1| | 6183 | g47159 | i0 | 100 | 0.119148936170213 | 28 | 0 | 12 | 0 | 160 | 187 | 872 | 899 | Schistosoma mansoni cercarial elastase (S01 family) partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni |
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);;