contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25517323 | 25517323 | PRJEB20058_P_NODE_205161_length_252_cov_16.874346_g202337_i0 | PRJEB20058 | 205161 | 252 | 16.874346 | 42.52335192 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 392 | 1.1899999999999997e-104 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g202337 | i0 | 95.219 | 120.349206349206 | 251 | 6 | 97 | 4 | 8 | 252 | 2128 | 2378 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 30328 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25612361 | 25612361 | PRJEB20058_P_NODE_132425_length_341_cov_37.157143_g129605_i0 | PRJEB20058 | 132425 | 341 | 37.157143 | 126.70585763 | root | 1 | Root_unresolved | Root_unresolved | 108 | 6.78e-19 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g129605 | i0 | 100 | 19.2287390029326 | 58 | 0 | 17 | 0 | 29 | 86 | 595 | 538 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6557 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 25612853 | 25612853 | PRJEB20058_P_NODE_164513_length_294_cov_2.922747_g161690_i0 | PRJEB20058 | 164513 | 294 | 2.922747 | 8.59287618 | Coronacanthus | 1518487 | Platyhelminthes | Platyhelminthes | 492 | 1.36e-134 | NTclustered | gi|662488960|gb|KJ710320.1| | 1518488 | g161690 | i0 | 98.913 | 93.8707482993197 | 276 | 2 | 94 | 1 | 1 | 275 | 936 | 661 | Coronacanthus integrus isolate Ci18 18S ribosomal RNA gene, partial sequence | blastn | 27598 | 492 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Coronacanthus | Coronacanthus integrus | |
| 25749982 | 25749982 | PRJEB20058_P_NODE_22426_length_878_cov_451.603427_g20261_i0 | PRJEB20058 | 22426 | 878 | 451.603427 | 3965.07808906 | root | 1 | Root_unresolved | Root_unresolved | 108 | 1.86e-18 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g20261 | i0 | 100 | 7.43621867881549 | 58 | 0 | 7 | 0 | 29 | 86 | 595 | 538 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6529 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 25750503 | 25750503 | PRJEB20058_P_NODE_34298_length_717_cov_8.429878_g31729_i0 | PRJEB20058 | 34298 | 717 | 8.429878 | 60.44222526 | root | 1 | Root_unresolved | Root_unresolved | 108 | 1.51e-18 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g31729 | i0 | 100 | 8.63040446304045 | 58 | 0 | 8 | 0 | 632 | 689 | 538 | 595 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6188 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 25791608 | 25791608 | PRJEB20058_P_NODE_36819_length_693_cov_2.740506_g34221_i0 | PRJEB20058 | 36819 | 693 | 2.740506 | 18.99170658 | Paracatenula sp. CEL-2 | 1468208 | Platyhelminthes | Platyhelminthes | 137 | 1.86e-27 | NTclustered | gi|588313877|gb|KC869835.1| | 1468208 | g34221 | i0 | 86.992 | 1.16017316017316 | 123 | 15 | 18 | 1 | 274 | 396 | 2208 | 2087 | Paracatenula sp. CEL-2014 28S ribosomal RNA gene, partial sequence | blastn | 804 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Catenulidae | Paracatenula | Paracatenula sp. CEL-2014 | |||
| 25791912 | 25791912 | PRJEB20058_P_NODE_42203_length_647_cov_10.781570_g39542_i0 | PRJEB20058 | 42203 | 647 | 10.78157 | 69.7567579 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 979 | 0 | NTclustered | gi|28273293|gb|AY157181.1| | 6216 | g39542 | i0 | 95.087 | 72.6630602782071 | 631 | 16 | 95 | 10 | 9 | 625 | 3216 | 2587 | Hymenolepis diminuta 28S large subunit ribosomal RNA gene, partial sequence | blastn | 47013 | 979 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 25793647 | 25793647 | PRJEB20058_P_NODE_74595_length_481_cov_8.019048_g71818_i0 | PRJEB20058 | 74595 | 481 | 8.019048 | 38.57162088 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 614 | 4.769999999999999e-171 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g71818 | i0 | 97.493 | 2.25363825363825 | 359 | 9 | 95 | 0 | 23 | 381 | 81 | 439 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 1084 | 614 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25886126 | 25886126 | PRJEB20058_P_NODE_27779_length_794_cov_9.215553_g25424_i0 | PRJEB20058 | 27779 | 794 | 9.215553 | 73.17149082 | root | 1 | Root_unresolved | Root_unresolved | 108 | 1.68e-18 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g25424 | i0 | 100 | 7.79345088161209 | 58 | 0 | 7 | 0 | 29 | 86 | 595 | 538 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6188 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26335930 | 26335930 | PRJEB20058_P_NODE_36759_length_693_cov_11.667722_g34162_i0 | PRJEB20058 | 36759 | 693 | 11.667722 | 80.85731346 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 699 | 0 | NTclustered | gi|1089667270|dbj|AP017665.1| | 85433 | g34162 | i0 | 87.541 | 83.965367965368 | 610 | 69 | 87 | 7 | 87 | 692 | 2119 | 2725 | Hymenolepis microstoma mitochondrial DNA, complete genome | blastn | 58188 | 699 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 26428585 | 26428585 | PRJEB20058_P_NODE_132383_length_341_cov_120.832143_g129563_i0 | PRJEB20058 | 132383 | 341 | 120.832143 | 412.03760763 | root | 1 | Root_unresolved | Root_unresolved | 108 | 6.78e-19 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g129563 | i0 | 100 | 35.466275659824 | 58 | 0 | 32 | 0 | 256 | 313 | 538 | 595 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 12094 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26470716 | 26470716 | PRJEB20058_P_NODE_22504_length_877_cov_5.825980_g20339_i0 | PRJEB20058 | 22504 | 877 | 5.82598 | 51.0938446 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 156 | 6.55e-33 | NTclustered | gi|690710103|emb|LN267007.1| | 99802 | g20339 | i0 | 85.714 | 3.24629418472064 | 147 | 21 | 17 | 0 | 584 | 730 | 1057 | 1203 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0204090 | blastn | 2847 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 26474129 | 26474129 | PRJEB20058_P_NODE_72072_length_490_cov_8.237762_g69297_i0 | PRJEB20058 | 72072 | 490 | 8.237762 | 40.3650338 | Monocercus arionis | 700174 | Platyhelminthes | Platyhelminthes | 551 | 3.869999999999999e-152 | NTclustered | gi|282765738|gb|GU299827.1| | 700174 | g69297 | i0 | 89.953 | 85.1040816326531 | 428 | 41 | 87 | 2 | 41 | 467 | 881 | 455 | Monocercus arionis isolate EST_430 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 41701 | 551 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Dilepididae | Monocercus | Monocercus arionis | |
| 26475427 | 26475427 | PRJEB20058_P_NODE_98536_length_411_cov_1.520000_g95730_i0 | PRJEB20058 | 98536 | 411 | 1.52 | 6.2472 | Didymorchis sp. Australia-DTJL-2 | 216950 | Platyhelminthes | Platyhelminthes | 58.4 | 8.49e-4 | NTclustered | gi|28273275|gb|AY157163.1| | 216950 | g95730 | i0 | 87.755 | 0.18978102189781 | 49 | 6 | 12 | 0 | 166 | 214 | 2435 | 2387 | Didymorchis sp. Australia-DTJL-2002 28S large subunit ribosomal RNA gene, partial sequence | blastn | 78 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Didymorchiidae | Didymorchis | Didymorchis sp. Australia-DTJL-2002 | |
| 26565189 | 26565189 | PRJEB20058_P_NODE_166280_length_292_cov_1.952381_g163457_i0 | PRJEB20058 | 166280 | 292 | 1.952381 | 5.70095252 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 204 | 7.06e-48 | NTclustered | gi|215398155|gb|EU878031.1| | 79923 | g163457 | i0 | 84.615 | 62 | 208 | 29 | 71 | 3 | 26 | 233 | 1140 | 1344 | Clonorchis sinensis beta-tubulin (TB1) mRNA, complete cds | blastn | 18104 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis |
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);;