contig_metadata
14 rows where bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3812237 | 3812237 | PRJNA946307_P_NODE_157583_length_163_cov_0.912281_g156709_i0 | PRJNA946307 | 157583 | 163 | 0.912281 | 1.48701803 | Macrostomum | 39217 | Platyhelminthes | Platyhelminthes | 270 | 3.4499999999999993e-68 | NTclustered | gi|261873755|gb|FJ715320.1| | 52054 | g156709 | i0 | 99.333 | 92.2269938650307 | 150 | 0 | 91 | 1 | 1 | 149 | 1028 | 879 | Macrostomum tuba voucher MTP LS 261 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15033 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum tuba | |
| 6029332 | 6029332 | PRJNA946307_P_NODE_136025_length_168_cov_3.067227_g135151_i0 | PRJNA946307 | 136025 | 168 | 3.067227 | 5.15294136 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 241 | 2.81e-59 | NTclustered | gi|926460157|gb|KR132223.1| | 282301 | g135151 | i0 | 98.529 | 0.80952380952381 | 136 | 2 | 81 | 0 | 6 | 141 | 526 | 391 | Macrostomum lignano clone c100550_g1_i1 mRNA sequence | blastn | 136 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 6364494 | 6364494 | PRJNA946307_P_NODE_28705_length_242_cov_1.015544_g27831_i0 | PRJNA946307 | 28705 | 242 | 1.015544 | 2.45761648 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 76.8 | 1.29e-9 | NTclustered | gi|115605663|gb|DQ925331.1| | 406067 | g27831 | i0 | 82.418 | 33.9669421487603 | 91 | 13 | 37 | 3 | 1 | 90 | 356 | 268 | Paraechinophallus japonicus 28S ribosomal RNA gene, partial sequence | blastn | 8220 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Pseudophyllidea | Parabothriocephalidae | Paraechinophallus | Paraechinophallus japonicus | |
| 7306045 | 7306045 | PRJNA946307_P_NODE_81326_length_193_cov_2.395833_g80452_i0 | PRJNA946307 | 81326 | 193 | 2.395833 | 4.62395769 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 331 | 1.91e-86 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g80452 | i0 | 100 | 75.1658031088083 | 179 | 0 | 93 | 0 | 1 | 179 | 2521 | 2343 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 14507 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 8580517 | 8580517 | PRJNA946307_P_NODE_62247_length_203_cov_1.487013_g61373_i0 | PRJNA946307 | 62247 | 203 | 1.487013 | 3.01863639 | Paracatenula sp. CEL-2014 | 1468208 | Platyhelminthes | Platyhelminthes | 99 | 2.24e-16 | NTclustered | gi|588313877|gb|KC869835.1| | 1468208 | g61373 | i0 | 87.5 | 38.4729064039409 | 88 | 8 | 42 | 3 | 1 | 86 | 1708 | 1622 | Paracatenula sp. CEL-2014 28S ribosomal RNA gene, partial sequence | blastn | 7810 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Catenulidae | Paracatenula | Paracatenula sp. CEL-2014 | |||
| 11129301 | 11129301 | PRJNA946307_P_NODE_10809_length_406_cov_8.028011_g9952_i0 | PRJNA946307 | 10809 | 406 | 8.028011 | 32.59372466 | Progamotaenia spearei | 1117265 | Platyhelminthes | Platyhelminthes | 102 | 3.81e-17 | NTclustered | gi|358748173|gb|JN683699.1| | 1117265 | g9952 | i0 | 89.157 | 24.2167487684729 | 83 | 8 | 20 | 1 | 238 | 319 | 1249 | 1331 | Progamotaenia spearei isolate V92 28S ribosomal RNA gene, partial sequence | blastn | 9832 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Anoplocephalidae | Progamotaenia | Progamotaenia spearei | |
| 12405449 | 12405449 | PRJNA946307_P_NODE_145190_length_166_cov_0.888889_g144316_i0 | PRJNA946307 | 145190 | 166 | 0.888889 | 1.47555574 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 254 | 3.55e-63 | NTclustered | gi|10945139|emb|AJ270178.1| | 52061 | g144316 | i0 | 97.315 | 94.1566265060241 | 149 | 4 | 90 | 0 | 15 | 163 | 1493 | 1641 | Stenostomum leucops partial 28S rRNA gene | blastn | 15630 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 12740399 | 12740399 | PRJNA946307_P_NODE_98830_length_185_cov_1.147059_g97956_i0 | PRJNA946307 | 98830 | 185 | 1.147059 | 2.12205915 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 89.8 | 1.2e-13 | NTclustered | gi|1243283765|gb|KY320127.1| | 99407 | g97956 | i0 | 78.723 | 48.3081081081081 | 141 | 25 | 76 | 3 | 2 | 142 | 1225 | 1090 | Monostichoplana filum isolate MFHE1 28S ribosomal RNA gene, partial sequence | blastn | 8937 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Otoplanidae | Monostichoplana | Monostichoplana filum | |
| 19111866 | 19111866 | PRJNA946307_P_NODE_33975_length_225_cov_3.056818_g33101_i0 | PRJNA946307 | 33975 | 225 | 3.056818 | 6.8778405 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 139 | 1.49e-28 | NTclustered | gi|472441132|gb|KC529546.1| | 297427 | g33101 | i0 | 90.476 | 46.6311111111111 | 105 | 10 | 47 | 0 | 1 | 105 | 1112 | 1008 | Ptychopera westbladi isolate UH143.12 28S ribosomal RNA gene, partial sequence | blastn | 10492 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Trigonostomidae | Ptychopera | Ptychopera westbladi | |
| 21329383 | 21329383 | PRJNA946307_P_NODE_42257_length_211_cov_5.444444_g41383_i0 | PRJNA946307 | 42257 | 211 | 5.444444 | 11.48777684 | Macrostomum sp. CEL-2014 | 1468207 | Platyhelminthes | Platyhelminthes | 241 | 3.69e-59 | NTclustered | gi|588313885|gb|KC869843.1| | 1468207 | g41383 | i0 | 87.065 | 117.161137440758 | 201 | 21 | 93 | 3 | 15 | 210 | 2175 | 2375 | Macrostomum sp. CEL-2014 28S ribosomal RNA gene, partial sequence | blastn | 24721 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum sp. CEL-2014 | |
| 22604215 | 22604215 | PRJNA946307_P_NODE_35998_length_220_cov_2.649123_g35124_i0 | PRJNA946307 | 35998 | 220 | 2.649123 | 5.8280706 | Bdelloura candida | 46766 | Platyhelminthes | Platyhelminthes | 95.3 | 3.19e-15 | NTclustered | gi|28273266|gb|AY157154.1| | 46766 | g35124 | i0 | 89.333 | 2.87727272727273 | 75 | 8 | 34 | 0 | 11 | 85 | 1626 | 1700 | Bdelloura candida 28S large subunit ribosomal RNA gene, partial sequence | blastn | 633 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Bdellouridae | Bdelloura | Bdelloura candida | |
| 23879533 | 23879533 | PRJNA946307_P_NODE_25279_length_256_cov_1.898551_g24405_i0 | PRJNA946307 | 25279 | 256 | 1.898551 | 4.86029056 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 431 | 2.56e-116 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g24405 | i0 | 98.76 | 43.1171875 | 242 | 3 | 95 | 0 | 1 | 242 | 2070 | 1829 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 11038 | 431 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 25486572 | 25486572 | PRJNA946307_P_NODE_132440_length_170_cov_1.066116_g131566_i0 | PRJNA946307 | 132440 | 170 | 1.066116 | 1.8123972 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 289 | 9.949999999999999e-74 | NTclustered | gi|2177180|gb|U95947.1|SSU95947 | 60215 | g131566 | i0 | 100 | 89.2058823529412 | 156 | 0 | 92 | 0 | 14 | 169 | 223 | 378 | Stenostomum sp. 'Aguinaldo, 1997' 18S ribosomal RNA gene, complete sequence | blastn | 15165 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sp. 'Aguinaldo, 1997' | |||
| 30822004 | 30822004 | PRJNA946307_P_NODE_55074_length_210_cov_2.900621_g54200_i0 | PRJNA946307 | 55074 | 210 | 2.900621 | 6.0913041 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 44.3 | 0.00712 | NR | VZI12983.1 | 99802 | g54200 | i0 | 65.5 | 5.58571428571429 | 29 | 10 | 41.4 | 0 | 118 | 204 | 111 | 139 | VZI12983.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 1173 | 44.3 | 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);;