contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1595945 | 1595945 | PRJNA1195374_P_NODE_26122_length_443_cov_17.551351_g25778_i0 | PRJNA1195374 | 26122 | 443 | 17.551351 | 77.75248493 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 765 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g25778 | i0 | 98.174 | 0.988713318284424 | 438 | 8 | 99 | 0 | 2 | 439 | 449 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 438 | 765 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 5425589 | 5425589 | PRJNA1195374_P_NODE_83385_length_242_cov_0.911243_g83041_i0 | PRJNA1195374 | 83385 | 242 | 0.911243 | 2.20520806 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|2318748516|ref|XM_051210251.1| | 6185 | g83041 | i0 | 100 | 1.92148760330579 | 30 | 0 | 12 | 0 | 29 | 58 | 348 | 319 | Schistosoma haematobium Arf guanine nucleotide exchange factor syt1 (SYT1_1), mRNA | blastn | 465 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 13796045 | 13796045 | PRJNA1195374_P_NODE_38931_length_359_cov_1.059441_g38587_i0 | PRJNA1195374 | 38931 | 359 | 1.059441 | 3.80339319 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 65.8 | 4.37e-6 | NTclustered | gi|2318770865|ref|XM_051217305.1| | 6185 | g38587 | i0 | 84.058 | 7.27298050139276 | 69 | 9 | 19 | 2 | 251 | 318 | 1026 | 1093 | Schistosoma haematobium Protein phosphatase 1G (PPM1G), mRNA | blastn | 2611 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 16898959 | 16898959 | PRJNA1195374_P_NODE_54454_length_295_cov_1.126126_g54110_i0 | PRJNA1195374 | 54454 | 295 | 1.126126 | 3.3220717 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 54.7 | 0.008 | NTclustered | gi|56759179|gb|AY815998.1| | 6182 | g54110 | i0 | 100 | 0.193220338983051 | 29 | 0 | 10 | 0 | 264 | 292 | 32 | 4 | Schistosoma japonicum SJCHGC09290 protein mRNA, complete cds | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18894113 | 18894113 | PRJNA1195374_P_NODE_33635_length_389_cov_1.218354_g33291_i0 | PRJNA1195374 | 33635 | 389 | 1.218354 | 4.73939706 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 52.8 | 0.037 | NTclustered | gi|690938882|emb|LN448689.1| | 99802 | g33291 | i0 | 100 | 0.143958868894602 | 28 | 0 | 7 | 0 | 142 | 169 | 69 | 42 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0197368 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 23273696 | 23273696 | PRJNA1195374_P_NODE_36099_length_374_cov_1.431894_g35755_i0 | PRJNA1195374 | 36099 | 374 | 1.431894 | 5.35528356 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.036 | NTclustered | gi|690495462|emb|LN041878.1| | 99802 | g35755 | i0 | 100 | 0.0748663101604278 | 28 | 0 | 7 | 0 | 8 | 35 | 5671 | 5698 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0040878 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 24547353 | 24547353 | PRJNA1195374_P_NODE_2460_length_1197_cov_1.991103_g2273_i0 | PRJNA1195374 | 2460 | 1197 | 1.991103 | 23.83350291 | Toia sp. 2 NWVS-2022 | 2911860 | Platyhelminthes | Platyhelminthes | 224 | 2.45e-53 | NTclustered | gi|2181858295|gb|OM339544.1| | 2911860 | g2273 | i0 | 75.097 | 14.6340852130326 | 518 | 110 | 45 | 18 | 692 | 1197 | 928 | 1438 | Toia sp. 2 NWVS-2022 voucher Toia_sp2_70 large subunit ribosomal RNA gene, partial sequence | blastn | 17517 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Cicerinidae | Toia | Toia sp. 2 NWVS-2022 | |
| 25269089 | 25269089 | PRJNA1195374_P_NODE_66240_length_263_cov_1.331579_g65896_i0 | PRJNA1195374 | 66240 | 263 | 1.331579 | 3.50205277 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 230 | 1.0299999999999995e-55 | NTclustered | gi|393794740|dbj|AK389164.1| | 6161 | g65896 | i0 | 86.829 | 71.2091254752852 | 205 | 27 | 78 | 0 | 59 | 263 | 1356 | 1152 | Dugesia japonica cDNA, clone: Dj_aH_325_F08.full, full-insert sequence, expressed in adult head | blastn | 18728 | 231 | 0.995670995670996 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica |
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);;