contig_metadata
11 rows where bioproject = "PRJNA870096" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5065413 | 5065413 | PRJNA870096_S_NODE_66684_length_214_cov_13.508772_g65020_i0 | PRJNA870096 | 66684 | 214 | 13.508772 | 28.90877208 | Protopolystoma xenopodis | 117903 | Platyhelminthes | Platyhelminthes | 128 | 1.07e-36 | NR | VEL07836.1 | 117903 | g65020 | i0 | 88.1 | 5.53738317757009 | 67 | 8 | 93.9 | 0 | 3 | 203 | 23 | 89 | VEL07836.1 unnamed protein product [Protopolystoma xenopodis] | diamond | 1185 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 8502806 | 8502806 | PRJNA870096_S_NODE_20907_length_396_cov_9.473088_g19247_i0 | PRJNA870096 | 20907 | 396 | 9.473088 | 37.51342848 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 183 | 1.29e-41 | NTclustered | gi|62199298|gb|AY967668.1| | 79327 | g19247 | i0 | 85.714 | 8.07575757575758 | 175 | 23 | 44 | 2 | 155 | 328 | 642 | 469 | Schmidtea mediterranea clone NBE.7.02A mRNA sequence | blastn | 3198 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 14877362 | 14877362 | PRJNA870096_S_NODE_113312_length_167_cov_1.161290_g111648_i0 | PRJNA870096 | 113312 | 167 | 1.16129 | 1.9393543 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 292 | 7.58e-75 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g111648 | i0 | 98.204 | 1 | 167 | 3 | 100 | 0 | 1 | 167 | 2213 | 2379 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 167 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 19976676 | 19976676 | PRJNA870096_S_NODE_41276_length_276_cov_1.952790_g39612_i0 | PRJNA870096 | 41276 | 276 | 1.95279 | 5.3897004 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 130 | 1.15e-33 | NR | XP_024347049.1 | 6210 | g39612 | i0 | 87.1 | 25.8913043478261 | 70 | 9 | 76.1 | 0 | 276 | 67 | 230 | 299 | XP_024347049.1 Serine/threonine-protein phosphatase PP1-beta catalytic subunit [Echinococcus granulosus] | diamond | 7146 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 27821586 | 27821586 | PRJNA870096_S_NODE_124064_length_160_cov_1.230769_g122400_i0 | PRJNA870096 | 124064 | 160 | 1.230769 | 1.9692304 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82.4 | 8.8e-17 | NR | VDD76371.1 | 53468 | g122400 | i0 | 69.2 | 3.88125 | 52 | 16 | 97.5 | 0 | 156 | 1 | 301 | 352 | VDD76371.1 unnamed protein product [Mesocestoides corti] | diamond | 621 | 83.2 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 29202716 | 29202716 | PRJNA870096_S_NODE_94929_length_181_cov_1.217391_g93265_i0 | PRJNA870096 | 94929 | 181 | 1.217391 | 2.20347771 | Taenia asiatica | 60517 | Platyhelminthes | Platyhelminthes | 44.7 | 0.00347 | NR | VDK20279.1 | 60517 | g93265 | i0 | 58.1 | 1.02762430939227 | 31 | 13 | 51.4 | 0 | 106 | 14 | 661 | 691 | VDK20279.1 unnamed protein product [Taenia asiatica] | diamond | 186 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 29526491 | 29526491 | PRJNA870096_S_NODE_89710_length_186_cov_1.041958_g88046_i0 | PRJNA870096 | 89710 | 186 | 1.041958 | 1.93804188 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 60.5 | 8.14e-10 | NR | PAA92964.1 | 282301 | g88046 | i0 | 63.5 | 6.79032258064516 | 52 | 19 | 83.9 | 0 | 30 | 185 | 21 | 72 | PAA92964.1 hypothetical protein BOX15_Mlig002061g4, partial [Macrostomum lignano] | diamond | 1263 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29620660 | 29620660 | PRJNA870096_S_NODE_13150_length_506_cov_21.017279_g11523_i0 | PRJNA870096 | 13150 | 506 | 21.017279 | 106.34743174 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 157 | 9.89e-46 | NR | AAW25011.1 | 6182 | g11523 | i0 | 55.8 | 10.3458498023715 | 147 | 63 | 87.2 | 2 | 495 | 55 | 15 | 159 | AAW25011.1 SJCHGC00639 protein [Schistosoma japonicum] | diamond | 5235 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31833136 | 31833136 | PRJNA870096_S_NODE_88697_length_187_cov_1.000000_g87033_i0 | PRJNA870096 | 88697 | 187 | 1 | 1.87 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 65.9 | 3.85e-11 | NR | VDN15512.1 | 60516 | g87033 | i0 | 52.5 | 8.58288770053476 | 59 | 28 | 94.7 | 0 | 184 | 8 | 120 | 178 | VDN15512.1 unnamed protein product, partial [Dibothriocephalus latus] | diamond | 1605 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 31920137 | 31920137 | PRJNA870096_S_NODE_139837_length_152_cov_1.045872_g138173_i0 | PRJNA870096 | 139837 | 152 | 1.045872 | 1.58972544 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 40.8 | 0.0499 | NR | PAA86001.1 | 282301 | g138173 | i0 | 56.3 | 0.631578947368421 | 32 | 14 | 63.2 | 0 | 133 | 38 | 206 | 237 | PAA86001.1 hypothetical protein BOX15_Mlig023296g1, partial [Macrostomum lignano] | diamond | 96 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32394823 | 32394823 | PRJNA870096_S_NODE_120739_length_162_cov_1.210084_g119075_i0 | PRJNA870096 | 120739 | 162 | 1.210084 | 1.96033608 | Protopolystoma xenopodis | 117903 | Platyhelminthes | Platyhelminthes | 89.4 | 1.35e-19 | NR | VEL27917.1 | 117903 | g119075 | i0 | 76.5 | 0.944444444444444 | 51 | 12 | 94.4 | 0 | 154 | 2 | 129 | 179 | VEL27917.1 unnamed protein product, partial [Protopolystoma xenopodis] | diamond | 153 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis |
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);;