contig_metadata
12 rows where bioproject = "PRJNA635874", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6985473 | 6985473 | PRJNA635874_P_NODE_20766_length_347_cov_3.744526_g20619_i0 | PRJNA635874 | 20766 | 347 | 3.744526 | 12.99350522 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 145 | 1.78e-41 | NR | KAA0196388.1 | 27845 | g20619 | i0 | 70.3 | 4.34870317002882 | 101 | 30 | 87.3 | 0 | 304 | 2 | 4 | 104 | KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii] | diamond | 1509 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 12086231 | 12086231 | PRJNA635874_P_NODE_16490_length_379_cov_1.869281_g16343_i0 | PRJNA635874 | 16490 | 379 | 1.869281 | 7.08457499 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 160 | 3.3999999999999997e-48 | NR | THD19570.1 | 6192 | g16343 | i0 | 79.8 | 3.00791556728232 | 94 | 19 | 74.4 | 0 | 374 | 93 | 15 | 108 | THD19570.1 peptidyl-prolyl cis-trans isomerase FKBP1B [Fasciola hepatica] | diamond | 1140 | 161 | 0.993788819875776 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 19733736 | 19733736 | PRJNA635874_P_NODE_24576_length_326_cov_1.450593_g24429_i0 | PRJNA635874 | 24576 | 326 | 1.450593 | 4.72893318 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 558 | 1.48e-154 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g24429 | i0 | 97.546 | 1 | 326 | 8 | 100 | 0 | 1 | 326 | 356 | 31 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 326 | 558 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23560792 | 23560792 | PRJNA635874_P_NODE_68039_length_243_cov_0.905882_g67892_i0 | PRJNA635874 | 68039 | 243 | 0.905882 | 2.20129326 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|690486527|emb|LN030482.1| | 99802 | g67892 | i0 | 94.444 | 0.263374485596708 | 36 | 1 | 15 | 1 | 132 | 167 | 3967 | 3933 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0029896 | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27713172 | 27713172 | PRJNA635874_P_NODE_27824_length_312_cov_0.991632_g27677_i0 | PRJNA635874 | 27824 | 312 | 0.991632 | 3.09389184 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 129 | 3.65e-33 | NR | VZI28585.1 | 99802 | g27677 | i0 | 64.4 | 7.78846153846154 | 90 | 32 | 86.5 | 0 | 310 | 41 | 69 | 158 | VZI28585.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 2430 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27776122 | 27776122 | PRJNA635874_P_NODE_30464_length_301_cov_0.872807_g30317_i0 | PRJNA635874 | 30464 | 301 | 0.872807 | 2.62714907 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 53.5 | 1.22e-5 | NR | VZI39702.1 | 99802 | g30317 | i0 | 45.3 | 3.06976744186047 | 53 | 29 | 52.8 | 0 | 114 | 272 | 1584 | 1636 | VZI39702.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 924 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 28596990 | 28596990 | PRJNA635874_P_NODE_70787_length_242_cov_0.911243_g70640_i0 | PRJNA635874 | 70787 | 242 | 0.911243 | 2.20520806 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 50.8 | 5.08e-5 | NR | VZI48410.1 | 99802 | g70640 | i0 | 46 | 1.88429752066116 | 50 | 27 | 62 | 0 | 212 | 63 | 67 | 116 | VZI48410.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 456 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 29133802 | 29133802 | PRJNA635874_P_NODE_45469_length_253_cov_0.855556_g45322_i0 | PRJNA635874 | 45469 | 253 | 0.855556 | 2.16455668 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 79.7 | 2.73e-15 | NR | CAH8846589.1 | 157069 | g45322 | i0 | 52.2 | 1.63636363636364 | 69 | 33 | 81.8 | 0 | 211 | 5 | 244 | 312 | CAH8846589.1 unnamed protein product [Trichobilharzia regenti] | diamond | 414 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 29512339 | 29512339 | PRJNA635874_P_NODE_43770_length_258_cov_1.221622_g43623_i0 | PRJNA635874 | 43770 | 258 | 1.221622 | 3.15178476 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 109 | 1.69e-25 | NR | VZI50567.1 | 99802 | g43623 | i0 | 60.7 | 10.7441860465116 | 84 | 33 | 97.7 | 0 | 256 | 5 | 230 | 313 | VZI50567.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 2772 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 30017886 | 30017886 | PRJNA635874_P_NODE_43731_length_258_cov_1.248649_g43584_i0 | PRJNA635874 | 43731 | 258 | 1.248649 | 3.22151442 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 57 | 4.08e-7 | NR | PAA86220.1 | 282301 | g43584 | i0 | 35.4 | 1.90697674418605 | 82 | 52 | 94.2 | 1 | 250 | 8 | 135 | 216 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 492 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30776173 | 30776173 | PRJNA635874_P_NODE_28074_length_311_cov_0.957983_g27927_i0 | PRJNA635874 | 28074 | 311 | 0.957983 | 2.97932713 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 70.9 | 1.08e-11 | NR | VZI48410.1 | 99802 | g27927 | i0 | 48.6 | 0.694533762057878 | 72 | 37 | 69.5 | 0 | 86 | 301 | 67 | 138 | VZI48410.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 216 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 32243563 | 32243563 | PRJNA635874_P_NODE_19538_length_356_cov_0.883392_g19391_i0 | PRJNA635874 | 19538 | 356 | 0.883392 | 3.14487552 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 122 | 2.22e-29 | NR | KAA3669964.1 | 34504 | g19391 | i0 | 62.2 | 9.10112359550562 | 90 | 34 | 75.8 | 0 | 275 | 6 | 563 | 652 | KAA3669964.1 uncharacterized protein DEA37_0012425 [Paragonimus westermani] | diamond | 3240 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani |
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);;