contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA758088" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3289965 | 3289965 | PRJNA758088_P_NODE_63163_length_545_cov_0.877119_g56249_i0 | PRJNA758088 | 63163 | 545 | 0.877119 | 4.78029855 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 109 | 4.91e-26 | NR | VDP93023.1 | 27848 | g56249 | i0 | 58.6 | 0.913761467889908 | 87 | 36 | 47.9 | 0 | 1 | 261 | 122 | 208 | VDP93023.1 unnamed protein product [Echinostoma caproni] | diamond | 498 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 27495440 | 27495440 | PRJNA758088_P_NODE_215503_length_290_cov_1.336406_g208532_i0 | PRJNA758088 | 215503 | 290 | 1.336406 | 3.8755774 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 43.1 | 0.0461 | NR | PAA86220.1 | 282301 | g208532 | i0 | 45.2 | 0.43448275862069 | 42 | 23 | 43.4 | 0 | 183 | 58 | 76 | 117 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 126 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28189766 | 28189766 | PRJNA758088_P_NODE_320626_length_246_cov_0.890173_g313655_i0 | PRJNA758088 | 320626 | 246 | 0.890173 | 2.18982558 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 49.7 | 4.8e-5 | NR | CAH8520294.1 | 57078 | g313655 | i0 | 41.1 | 0.682926829268293 | 56 | 33 | 68.3 | 0 | 246 | 79 | 54 | 109 | CAH8520294.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 168 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 28347860 | 28347860 | PRJNA758088_P_NODE_360246_length_241_cov_1.380952_g353275_i0 | PRJNA758088 | 360246 | 241 | 1.380952 | 3.32809432 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 44.7 | 0.00743 | NR | PAA93073.1 | 282301 | g353275 | i0 | 39.6 | 0.659751037344398 | 53 | 32 | 66 | 0 | 160 | 2 | 315 | 367 | PAA93073.1 hypothetical protein BOX15_Mlig006903g3 [Macrostomum lignano] | diamond | 159 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29452663 | 29452663 | PRJNA758088_P_NODE_87370_length_451_cov_2.113757_g80401_i0 | PRJNA758088 | 87370 | 451 | 2.113757 | 9.53304407 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 69.7 | 1.28e-10 | NR | GAA54537.1 | 79923 | g80401 | i0 | 43.3 | 0.851441241685144 | 67 | 35 | 43.9 | 2 | 88 | 285 | 382 | 446 | GAA54537.1 protein disulfide-isomerase, partial [Clonorchis sinensis] | diamond | 384 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 29705142 | 29705142 | PRJNA758088_P_NODE_84750_length_459_cov_1.396373_g77781_i0 | PRJNA758088 | 84750 | 459 | 1.396373 | 6.40935207 | Paragonimus kellicotti | 100269 | Platyhelminthes | Platyhelminthes | 95.9 | 8.150000000000001e-21 | NR | KAF6772794.1 | 100269 | g77781 | i0 | 39.3 | 2.91503267973856 | 150 | 77 | 95.4 | 5 | 21 | 458 | 55 | 194 | KAF6772794.1 Lysosomal acid lipase/cholesteryl ester hydrolase [Paragonimus kellicotti] | diamond | 1338 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 31832615 | 31832615 | PRJNA758088_P_NODE_324217_length_246_cov_0.890173_g317246_i0 | PRJNA758088 | 324217 | 246 | 0.890173 | 2.18982558 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 50.8 | 2.33e-5 | NR | CAH8629620.1 | 57078 | g317246 | i0 | 43.1 | 1.9390243902439 | 65 | 32 | 78 | 3 | 242 | 51 | 70 | 130 | CAH8629620.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 477 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 32244455 | 32244455 | PRJNA758088_P_NODE_276978_length_253_cov_0.827778_g270007_i0 | PRJNA758088 | 276978 | 253 | 0.827778 | 2.09427834 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 113 | 7.22e-27 | NR | XP_018644522.1 | 6183 | g270007 | i0 | 65.5 | 3.98418972332016 | 84 | 29 | 99.6 | 0 | 253 | 2 | 480 | 563 | XP_018644522.1 hypothetical protein Smp_182910 [Schistosoma mansoni] | diamond | 1008 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 32456017 | 32456017 | PRJNA758088_P_NODE_222319_length_286_cov_1.046948_g215348_i0 | PRJNA758088 | 222319 | 286 | 1.046948 | 2.99427128 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 45.1 | 0.00936 | NR | PAA86220.1 | 282301 | g215348 | i0 | 26.4 | 3.73426573426573 | 91 | 66 | 94.4 | 1 | 285 | 16 | 136 | 226 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 1068 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32654694 | 32654694 | PRJNA758088_P_NODE_349800_length_243_cov_0.905882_g342829_i0 | PRJNA758088 | 349800 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 59.7 | 2.21e-9 | NR | CAL5136697.1 | 300641 | g342829 | i0 | 40.3 | 1.49382716049383 | 72 | 43 | 88.9 | 0 | 6 | 221 | 5 | 76 | CAL5136697.1 unnamed protein product [Calicophoron daubneyi] | diamond | 363 | 60.1 | 0.993344425956739 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 32771071 | 32771071 | PRJNA758088_P_NODE_135180_length_361_cov_2.302083_g128209_i0 | PRJNA758088 | 135180 | 361 | 2.302083 | 8.31051963 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 48.1 | 0.00171 | NR | PAA93605.1 | 282301 | g128209 | i0 | 32.9 | 1.36288088642659 | 82 | 54 | 68.1 | 1 | 116 | 361 | 328 | 408 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 492 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano |
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);;