contig_metadata
10 rows where bioproject = "PRJNA788929", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 769323 | 769323 | PRJNA788929_P_NODE_28861_length_294_cov_22.027149_g28200_i0 | PRJNA788929 | 28861 | 294 | 22.027149 | 64.75981806 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 235 | 2.5199999999999997e-57 | NTclustered | gi|421976077|gb|JX679684.1| | 6161 | g28200 | i0 | 91.716 | 56.1258503401361 | 169 | 14 | 57 | 0 | 24 | 192 | 974 | 1142 | Dugesia japonica beta-actin mRNA, complete cds | blastn | 16501 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 3320319 | 3320319 | PRJNA788929_P_NODE_11663_length_512_cov_4.646925_g11009_i0 | PRJNA788929 | 11663 | 512 | 4.646925 | 23.792256 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 472 | 3.25e-128 | NTclustered | gi|690816508|emb|LN310741.1| | 99802 | g11009 | i0 | 87.104 | 2.857421875 | 442 | 25 | 83 | 10 | 65 | 490 | 569 | 144 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0219101 | blastn | 1463 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 8422161 | 8422161 | PRJNA788929_P_NODE_10067_length_564_cov_26.136456_g9414_i0 | PRJNA788929 | 10067 | 564 | 26.136456 | 147.40961184 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 147 | 5.039999999999999e-42 | NR | KAG5448272.1 | 79923 | g9414 | i0 | 65.1 | 1.63297872340426 | 106 | 36 | 56.4 | 1 | 97 | 414 | 4 | 108 | KAG5448272.1 12 kDa FK506-binding protein [Clonorchis sinensis] | diamond | 921 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 10973347 | 10973347 | PRJNA788929_P_NODE_29569_length_290_cov_22.769585_g28908_i0 | PRJNA788929 | 29569 | 290 | 22.769585 | 66.0317965 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 72 | 2.58e-14 | NR | VDP97528.1 | 157069 | g28908 | i0 | 71.7 | 3.41379310344828 | 46 | 13 | 47.6 | 0 | 267 | 130 | 6 | 51 | VDP97528.1 unnamed protein product [Trichobilharzia regenti] | diamond | 990 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 11418239 | 11418239 | PRJNA788929_P_NODE_33209_length_271_cov_14.393939_g32548_i0 | PRJNA788929 | 33209 | 271 | 14.393939 | 39.00757469 | Anthocephaliidae | 1617303 | Platyhelminthes | Platyhelminthes | 86.1 | 2.45e-12 | NTclustered | gi|223670572|gb|FJ177099.1| | 595947 | g32548 | i0 | 90.909 | 24.3247232472325 | 66 | 3 | 24 | 3 | 202 | 265 | 1067 | 1131 | Anthocephalum cf. centrurum LRP4219 voucher LRP4219 (TE141) 28S ribosomal RNA gene, partial sequence | blastn | 6592 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Rhinebothriidea | Anthocephaliidae | Anthocephalum | Anthocephalum cf. centrurum LRP4219 | |
| 21172110 | 21172110 | PRJNA788929_P_NODE_43917_length_234_cov_13.111801_g43256_i0 | PRJNA788929 | 43917 | 234 | 13.111801 | 30.68161434 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 52.8 | 0.021 | NTclustered | gi|1240504568|gb|MF667538.1| | 6161 | g43256 | i0 | 100 | 0.11965811965812 | 28 | 0 | 12 | 0 | 205 | 232 | 28 | 1 | Dugesia japonica 14-3-3 epsilon mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 22446855 | 22446855 | PRJNA788929_P_NODE_4238_length_988_cov_31.036066_g3737_i0 | PRJNA788929 | 4238 | 988 | 31.036066 | 306.63633208 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 1467 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g3737 | i0 | 94.804 | 21.8927125506073 | 943 | 45 | 95 | 4 | 46 | 986 | 8040 | 8980 | Stenostomum sthenum mitochondrion, complete genome | blastn | 21630 | 1467 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 27496169 | 27496169 | PRJNA788929_P_NODE_44383_length_232_cov_5.930818_g43722_i0 | PRJNA788929 | 44383 | 232 | 5.930818 | 13.75949776 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 42.4 | 0.0207 | NR | AAX30879.2 | 6182 | g43722 | i0 | 39.7 | 2.44396551724138 | 63 | 33 | 75 | 2 | 230 | 57 | 20 | 82 | AAX30879.2 SJCHGC08443 protein, partial [Schistosoma japonicum] | diamond | 567 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30970117 | 30970117 | PRJNA788929_P_NODE_35314_length_261_cov_10.425532_g34653_i0 | PRJNA788929 | 35314 | 261 | 10.425532 | 27.21063852 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 45.4 | 0.0054 | NR | GAA48052.1 | 79923 | g34653 | i0 | 41.1 | 0.64367816091954 | 56 | 31 | 63.2 | 2 | 174 | 10 | 385 | 439 | GAA48052.1 serine/threonine-protein kinase chk2 [Clonorchis sinensis] | diamond | 168 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 31611619 | 31611619 | PRJNA788929_P_NODE_25276_length_318_cov_17.228571_g24615_i0 | PRJNA788929 | 25276 | 318 | 17.228571 | 54.78685578 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 58.2 | 3.47e-7 | NR | RTG86584.1 | 6184 | g24615 | i0 | 45.9 | 17.7924528301887 | 61 | 32 | 56.6 | 1 | 6 | 185 | 811 | 871 | RTG86584.1 uncharacterized protein DC041_0006169 [Schistosoma bovis] | diamond | 5658 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis |
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);;