contig_metadata
11 rows where bioproject = "PRJNA493244", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6832495 | 6832495 | PRJNA493244_P_NODE_1085206_length_371_cov_2.454839_g1062087_i0 | PRJNA493244 | 1085206 | 371 | 2.454839 | 9.10745269 | Toia sp. TJ-2014 | 1524992 | Platyhelminthes | Platyhelminthes | 78.7 | 5.82e-10 | NTclustered | gi|667755613|gb|KJ887547.1| | 1524992 | g1062087 | i0 | 94.118 | 1.50673854447439 | 51 | 3 | 14 | 0 | 319 | 369 | 984 | 1034 | Toia sp. TJ-2014 voucher DNA89LAN 28S ribosomal RNA gene, partial sequence | blastn | 559 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Cicerinidae | Toia | Toia sp. TJ-2014 | |
| 6832782 | 6832782 | PRJNA493244_P_NODE_1209566_length_325_cov_9.306818_g1186442_i0 | PRJNA493244 | 1209566 | 325 | 9.306818 | 30.2471585 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.031 | NTclustered | gi|690818156|emb|LN312609.1| | 99802 | g1186442 | i0 | 100 | 0.172307692307692 | 28 | 0 | 9 | 0 | 163 | 190 | 145 | 172 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0093026 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 6833029 | 6833029 | PRJNA493244_P_NODE_1314186_length_292_cov_6.329004_g1291062_i0 | PRJNA493244 | 1314186 | 292 | 6.329004 | 18.48069168 | Cura pinguis | 69521 | Platyhelminthes | Platyhelminthes | 444 | 3.82e-120 | NTclustered | gi|4104158|gb|AF033043.1|AF033043 | 69521 | g1291062 | i0 | 96.296 | 92.1472602739726 | 270 | 10 | 92 | 0 | 23 | 292 | 126 | 395 | Cura pinguis 18S ribosomal RNA gene, complete sequence | blastn | 26907 | 444 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Cura | Cura pinguis | |
| 8753003 | 8753003 | PRJNA493244_P_NODE_574807_length_661_cov_12.296667_g553560_i0 | PRJNA493244 | 574807 | 661 | 12.296667 | 81.28096887 | Tricladida | 6159 | Platyhelminthes | Platyhelminthes | 171 | 1.74e-37 | NTclustered | gi|2112774280|gb|OK491323.1| | 79738 | g553560 | i0 | 81.643 | 38.1164901664145 | 207 | 37 | 31 | 1 | 320 | 526 | 1403 | 1198 | Dugesia ryukyuensis isolate Dryu2 large subunit ribosomal RNA gene, partial sequence | blastn | 25195 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia ryukyuensis | |
| 13211441 | 13211441 | PRJNA493244_P_NODE_889571_length_459_cov_1.939698_g866633_i0 | PRJNA493244 | 889571 | 459 | 1.939698 | 8.90321382 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 385 | 3.87e-102 | NTclustered | gi|687201987|emb|LN275469.1| | 99802 | g866633 | i0 | 97.768 | 0.941176470588235 | 224 | 3 | 49 | 2 | 3 | 225 | 223 | 1 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0207537 | blastn | 432 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 14485138 | 14485138 | PRJNA493244_P_NODE_1724352_length_201_cov_0.914286_g1701227_i0 | PRJNA493244 | 1724352 | 201 | 0.914286 | 1.83771486 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.017 | NTclustered | gi|687266059|emb|LK445928.1| | 57078 | g1701227 | i0 | 100 | 0.139303482587065 | 28 | 0 | 14 | 0 | 129 | 156 | 959 | 932 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0050834 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 16402207 | 16402207 | PRJNA493244_P_NODE_1197913_length_329_cov_7.402985_g1174789_i0 | PRJNA493244 | 1197913 | 329 | 7.402985 | 24.35582065 | root | 1 | Root_unresolved | Root_unresolved | 67.6 | 1.11e-6 | NTclustered | gi|690926604|emb|LN435279.1| | 99802 | g1174789 | i0 | 91.667 | 1.08814589665653 | 48 | 4 | 15 | 0 | 1 | 48 | 435 | 482 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_contig0184311 | blastn | 358 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 20857642 | 20857642 | PRJNA493244_P_NODE_1566897_length_228_cov_0.916168_g1543772_i0 | PRJNA493244 | 1566897 | 228 | 0.916168 | 2.08886304 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 128 | 3.28e-25 | NTclustered | gi|690816508|emb|LN310741.1| | 99802 | g1543772 | i0 | 86.667 | 0.802631578947368 | 120 | 11 | 53 | 2 | 48 | 167 | 461 | 347 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0219101 | blastn | 183 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27424315 | 27424315 | PRJNA493244_P_NODE_1076863_length_374_cov_4.961661_g1053746_i0 | PRJNA493244 | 1076863 | 374 | 4.961661 | 18.55661214 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 65.5 | 1.77e-9 | NR | VZI21838.1 | 99802 | g1053746 | i0 | 43.7 | 2.6951871657754 | 87 | 47 | 69 | 2 | 52 | 309 | 579 | 664 | VZI21838.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 1008 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 29444615 | 29444615 | PRJNA493244_P_NODE_1377170_length_274_cov_30.948357_g1354045_i0 | PRJNA493244 | 1377170 | 274 | 30.948357 | 84.79849818 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 69.7 | 1.83e-11 | NR | CAL5133260.1 | 300641 | g1354045 | i0 | 61.5 | 1.16058394160584 | 52 | 19 | 55.8 | 1 | 122 | 274 | 180 | 231 | CAL5133260.1 unnamed protein product [Calicophoron daubneyi] | diamond | 318 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 31181996 | 31181996 | PRJNA493244_P_NODE_210955_length_1155_cov_11.851920_g198766_i0 | PRJNA493244 | 210955 | 1155 | 11.85192 | 136.889676 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 51.2 | 0.00863 | NR | CAH8859879.1 | 157069 | g198766 | i0 | 37.9 | 0.301298701298701 | 58 | 36 | 15.1 | 0 | 765 | 938 | 167 | 224 | CAH8859879.1 unnamed protein product [Trichobilharzia regenti] | diamond | 348 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti |
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);;