contig_metadata
11 rows where bioproject = "PRJNA789095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2047145 | 2047145 | PRJNA789095_P_NODE_61062_length_261_cov_1.744681_g59728_i0 | PRJNA789095 | 61062 | 261 | 1.744681 | 4.55361741 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 71.3 | 6.57e-8 | NTclustered | gi|684394820|ref|XM_009172760.1| | 6198 | g59728 | i0 | 100 | 0.145593869731801 | 38 | 0 | 15 | 0 | 223 | 260 | 2917 | 2880 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 38 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 6318611 | 6318611 | PRJNA789095_P_NODE_71325_length_245_cov_2.930233_g69991_i0 | PRJNA789095 | 71325 | 245 | 2.930233 | 7.17907085 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 453 | 5.1900000000000006e-123 | NTclustered | gi|60599826|gb|AY810568.1| | 6182 | g69991 | i0 | 100 | 25.7714285714286 | 245 | 0 | 100 | 0 | 1 | 245 | 79 | 323 | Schistosoma japonicum clone SJCHGC08893 unknown mRNA | blastn | 6314 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 10974146 | 10974146 | PRJNA789095_P_NODE_25049_length_447_cov_5.903743_g23717_i0 | PRJNA789095 | 25049 | 447 | 5.903743 | 26.38973121 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 266 | 5.28e-83 | NR | ABS52704.1 | 6192 | g23717 | i0 | 91.3 | 348 | 149 | 13 | 100 | 0 | 447 | 1 | 332 | 480 | ABS52704.1 heat shock protein 70 [Fasciola hepatica] | diamond | 155556 | 268 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 11418415 | 11418415 | PRJNA789095_P_NODE_25749_length_437_cov_4.140110_g24417_i0 | PRJNA789095 | 25749 | 437 | 4.14011 | 18.0922807 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 808 | 0 | NTclustered | gi|60600609|gb|AY810873.1| | 6182 | g24417 | i0 | 100 | 42.8260869565217 | 437 | 0 | 100 | 0 | 1 | 437 | 546 | 110 | Schistosoma japonicum clone SJCHGC07419 unknown mRNA | blastn | 18715 | 808 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27094530 | 27094530 | PRJNA789095_P_NODE_42282_length_310_cov_2.860759_g40948_i0 | PRJNA789095 | 42282 | 310 | 2.860759 | 8.8683529 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 65.5 | 1.72e-10 | NR | XP_018654912.1 | 6183 | g40948 | i0 | 72.5 | 1.52903225806452 | 40 | 11 | 38.7 | 0 | 189 | 308 | 17 | 56 | XP_018654912.1 putative prion interactor pint1 [Schistosoma mansoni] | diamond | 474 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 28033011 | 28033011 | PRJNA789095_P_NODE_29565_length_392_cov_6.078370_g28232_i0 | PRJNA789095 | 29565 | 392 | 6.07837 | 23.8272104 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 69.7 | 6.76e-11 | NR | KAA3669829.1 | 34504 | g28232 | i0 | 62.7 | 0.772959183673469 | 51 | 19 | 39 | 0 | 206 | 54 | 177 | 227 | KAA3669829.1 uncharacterized protein DEA37_0001408, partial [Paragonimus westermani] | diamond | 303 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 28317105 | 28317105 | PRJNA789095_P_NODE_54086_length_276_cov_3.000000_g52752_i0 | PRJNA789095 | 54086 | 276 | 3 | 8.28 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 44.7 | 0.0112 | NR | KAA3669829.1 | 34504 | g52752 | i0 | 60.6 | 0.782608695652174 | 33 | 13 | 35.9 | 0 | 23 | 121 | 198 | 230 | KAA3669829.1 uncharacterized protein DEA37_0001408, partial [Paragonimus westermani] | diamond | 216 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 28758995 | 28758995 | PRJNA789095_P_NODE_29487_length_393_cov_4.753125_g28154_i0 | PRJNA789095 | 29487 | 393 | 4.753125 | 18.67978125 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 73.2 | 4.27e-12 | NR | KAA3669829.1 | 34504 | g28154 | i0 | 40.2 | 4.84732824427481 | 82 | 43 | 58 | 1 | 61 | 288 | 268 | 349 | KAA3669829.1 uncharacterized protein DEA37_0001408, partial [Paragonimus westermani] | diamond | 1905 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 29705843 | 29705843 | PRJNA789095_P_NODE_59750_length_264_cov_1.554974_g58416_i0 | PRJNA789095 | 59750 | 264 | 1.554974 | 4.10513136 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 58.2 | 1.73e-7 | NR | KAA3669829.1 | 34504 | g58416 | i0 | 72.7 | 1.01136363636364 | 33 | 9 | 37.5 | 0 | 101 | 3 | 127 | 159 | KAA3669829.1 uncharacterized protein DEA37_0001408, partial [Paragonimus westermani] | diamond | 267 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 30062822 | 30062822 | PRJNA789095_P_NODE_49891_length_286_cov_1.333333_g48557_i0 | PRJNA789095 | 49891 | 286 | 1.333333 | 3.81333238 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 166 | 3.28e-50 | NR | KAH8871482.1 | 6182 | g48557 | i0 | 88.4 | 3.98601398601399 | 95 | 11 | 99.7 | 0 | 1 | 285 | 51 | 145 | KAH8871482.1 40S ribosomal protein S3-A [Schistosoma japonicum] | diamond | 1140 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31697232 | 31697232 | PRJNA789095_P_NODE_78057_length_232_cov_4.238994_g76723_i0 | PRJNA789095 | 78057 | 232 | 4.238994 | 9.83446608 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 48.9 | 1.53e-4 | NR | VZI46114.1 | 99802 | g76723 | i0 | 42.9 | 3.375 | 63 | 31 | 75 | 2 | 56 | 229 | 88 | 150 | VZI46114.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 783 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;