contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 230739 | 230739 | PRJNA1118794_P_NODE_43921_length_260_cov_1.647059_g43171_i0 | PRJNA1118794 | 43921 | 260 | 1.647059 | 4.2823534 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.024 | NTclustered | gi|686670560|emb|LK405726.1| | 57078 | g43171 | i0 | 100 | 0.107692307692308 | 28 | 0 | 11 | 0 | 212 | 239 | 1745 | 1772 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0012303 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 1505871 | 1505871 | PRJNA1118794_P_NODE_75022_length_235_cov_3.709877_g74272_i0 | PRJNA1118794 | 75022 | 235 | 3.709877 | 8.71821095 | Hysteromorpha triloba | 234889 | Platyhelminthes | Platyhelminthes | 87.9 | 5.77e-13 | NTclustered | gi|1511118671|gb|MG770070.1| | 234889 | g74272 | i0 | 84.884 | 0.365957446808511 | 86 | 13 | 37 | 0 | 142 | 227 | 508 | 423 | Hysteromorpha triloba voucher 3LF-2754 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 86 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Diplostomida | Diplostomidae | Hysteromorpha | Hysteromorpha triloba | |
| 10433975 | 10433975 | PRJNA1118794_P_NODE_24969_length_313_cov_1.708333_g24219_i0 | PRJNA1118794 | 24969 | 313 | 1.708333 | 5.34708229 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 102 | 2.87e-17 | NTclustered | gi|148356702|dbj|AB243058.1| | 6161 | g24219 | i0 | 82.203 | 1.00958466453674 | 118 | 21 | 38 | 0 | 194 | 311 | 424 | 307 | Dugesia japonica Djmu1 mRNA for adaptor-related protein complex 1 mu 1 subunit, complete cds | blastn | 316 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 16807520 | 16807520 | PRJNA1118794_P_NODE_17594_length_354_cov_2.569395_g16844_i0 | PRJNA1118794 | 17594 | 354 | 2.569395 | 9.0956583 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 604 | 2.0499999999999992e-168 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g16844 | i0 | 97.458 | 1 | 354 | 9 | 100 | 0 | 1 | 354 | 365 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 354 | 604 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 19356818 | 19356818 | PRJNA1118794_P_NODE_57476_length_247_cov_1.770115_g56726_i0 | PRJNA1118794 | 57476 | 247 | 1.770115 | 4.37218405 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 224 | 4.469999999999999e-54 | NTclustered | gi|1084302960|ref|XM_018789082.1| | 6183 | g56726 | i0 | 88.235 | 73.1133603238866 | 187 | 22 | 76 | 0 | 53 | 239 | 1342 | 1156 | Schistosoma mansoni putative tubulin beta chain partial mRNA | blastn | 18059 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 20151456 | 20151456 | PRJNA1118794_P_NODE_59196_length_247_cov_0.885057_g58446_i0 | PRJNA1118794 | 59196 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|690652271|emb|LN200425.1| | 99802 | g58446 | i0 | 100 | 3.30364372469636 | 29 | 0 | 12 | 0 | 1 | 29 | 698 | 726 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0029760 | blastn | 816 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;