contig_metadata
11 rows where bioproject = "PRJNA315314", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5484239 | 5484239 | PRJNA315314_S_NODE_18085_length_194_cov_2.078788_g17764_i0 | PRJNA315314 | 18085 | 194 | 2.078788 | 4.03284872 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 54.7 | 0.005 | NTclustered | gi|1084294672|ref|XM_018796201.1| | 6183 | g17764 | i0 | 100 | 0.314432989690722 | 29 | 0 | 15 | 0 | 99 | 127 | 1172 | 1200 | Schistosoma mansoni putative serine-rich repeat protein partial mRNA | blastn | 61 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 9309062 | 9309062 | PRJNA315314_S_NODE_6228_length_323_cov_2568.367347_g5907_i0 | PRJNA315314 | 6228 | 323 | 2568.367347 | 8295.82653081 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 512 | 1.16e-140 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g5907 | i0 | 98.616 | 48.5820433436533 | 289 | 4 | 89 | 0 | 2 | 290 | 2127 | 1839 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15692 | 512 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 15683553 | 15683553 | PRJNA315314_S_NODE_27873_length_160_cov_1.175573_g27552_i0 | PRJNA315314 | 27873 | 160 | 1.175573 | 1.8809168 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 96.7 | 8.979999999999999e-23 | NR | CAL5131531.1 | 300641 | g27552 | i0 | 75.5 | 7.93125 | 53 | 13 | 99.4 | 0 | 2 | 160 | 95 | 147 | CAL5131531.1 unnamed protein product [Calicophoron daubneyi] | diamond | 1269 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 16367822 | 16367822 | PRJNA315314_S_NODE_19373_length_187_cov_20.658228_g19052_i0 | PRJNA315314 | 19373 | 187 | 20.658228 | 38.63088636 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 340 | 3.0499999999999998e-89 | NTclustered | gi|209968707|gb|FJ384870.1| | 52061 | g19052 | i0 | 99.465 | 73.0106951871658 | 187 | 1 | 100 | 0 | 1 | 187 | 1026 | 840 | Stenostomum leucops isolate K05_55 28S ribosomal RNA gene, partial sequence | blastn | 13653 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 16958052 | 16958052 | PRJNA315314_S_NODE_11574_length_238_cov_27.028708_g11253_i0 | PRJNA315314 | 11574 | 238 | 27.028708 | 64.32832504 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 411 | 3.06e-110 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g11253 | i0 | 98.291 | 94.3067226890756 | 234 | 4 | 98 | 0 | 2 | 235 | 2950 | 2717 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22445 | 411 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 16958272 | 16958272 | PRJNA315314_S_NODE_25094_length_167_cov_2.978261_g24773_i0 | PRJNA315314 | 25094 | 167 | 2.978261 | 4.97369587 | Prolecithophora cf. Euxinia sp. CEL-2014 | 1468210 | Platyhelminthes | Platyhelminthes | 86.1 | 1.38e-12 | NTclustered | gi|588313916|gb|KC869874.1| | 1468210 | g24773 | i0 | 88.732 | 2.58083832335329 | 71 | 6 | 42 | 2 | 14 | 83 | 2815 | 2884 | Prolecithophora cf. Euxinia sp. CEL-2014 28S ribosomal RNA gene, partial sequence | blastn | 431 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Prolecithophora | Prolecithophora cf. Euxinia sp. CEL-2014 | |||
| 22742151 | 22742151 | PRJNA315314_S_NODE_2678_length_484_cov_13.760440_g2366_i0 | PRJNA315314 | 2678 | 484 | 13.76044 | 66.6005296 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 826 | 0 | NTclustered | gi|209968685|gb|FJ384848.1| | 52061 | g2366 | i0 | 97.516 | 61.2747933884297 | 483 | 12 | 99 | 0 | 2 | 484 | 813 | 331 | Stenostomum leucops isolate K04_75 28S ribosomal RNA gene, partial sequence | blastn | 29657 | 826 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 23332848 | 23332848 | PRJNA315314_S_NODE_22179_length_176_cov_4.761905_g21858_i0 | PRJNA315314 | 22179 | 176 | 4.761905 | 8.3809528 | Strongylostoma elongatum | 297429 | Platyhelminthes | Platyhelminthes | 58.4 | 3.19e-4 | NTclustered | gi|588313925|gb|KC869883.1| | 1468203 | g21858 | i0 | 100 | 16.0284090909091 | 31 | 0 | 18 | 0 | 67 | 97 | 1852 | 1882 | Strongylostoma elongatum spinosum 28S ribosomal RNA genes, partial sequence | blastn | 2821 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Typhloplanidae | Strongylostoma | Strongylostoma elongatum | |
| 23333056 | 23333056 | PRJNA315314_S_NODE_6539_length_315_cov_20.451049_g6218_i0 | PRJNA315314 | 6539 | 315 | 20.451049 | 64.42080435 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 562 | 1.1e-155 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g6218 | i0 | 99.042 | 42.7269841269841 | 313 | 3 | 99 | 0 | 1 | 313 | 2501 | 2189 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 13459 | 562 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 24017238 | 24017238 | PRJNA315314_S_NODE_7879_length_287_cov_32.821705_g7558_i0 | PRJNA315314 | 7879 | 287 | 32.821705 | 94.19829335 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 512 | 1.01e-140 | NTclustered | gi|2866376384|gb|PQ722296.1| | 39377 | g7558 | i0 | 98.625 | 99.4912891986063 | 291 | 0 | 100 | 1 | 1 | 287 | 292 | 2 | Stenostomum sp. (in: flatworms) isolate F8 small subunit ribosomal RNA gene, partial sequence | blastn | 28554 | 512 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sp. (in: flatworms) | |||
| 32368387 | 32368387 | PRJNA315314_S_NODE_21179_length_180_cov_2.291391_g20858_i0 | PRJNA315314 | 21179 | 180 | 2.291391 | 4.1245038 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 53.9 | 1.69e-7 | NR | XP_018645103.1 | 6183 | g20858 | i0 | 81.5 | 0.9 | 27 | 5 | 45 | 0 | 83 | 3 | 18 | 44 | XP_018645103.1 unnamed protein product [Schistosoma mansoni] | diamond | 162 | 53.9 | 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);;