contig_metadata
10 rows where bioproject = "PRJNA896554" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1243797 | 1243797 | PRJNA896554_P_NODE_42201_length_831_cov_14.186016_g35084_i0 | PRJNA896554 | 42201 | 831 | 14.186016 | 117.88579296 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 243 | 2.01e-77 | NR | KAA0196388.1 | 27845 | g35084 | i0 | 68.2 | 2.50180505415162 | 173 | 55 | 62.5 | 0 | 50 | 568 | 4 | 176 | KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii] | diamond | 2079 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 2145468 | 2145468 | PRJNA896554_P_NODE_131882_length_273_cov_2.600000_g124342_i0 | PRJNA896554 | 131882 | 273 | 2.6 | 7.098 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 396 | 1.0099999999999997e-105 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g124342 | i0 | 97.021 | 2.23443223443223 | 235 | 7 | 86 | 0 | 39 | 273 | 421 | 187 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 610 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 3421976 | 3421976 | PRJNA896554_P_NODE_24443_length_1530_cov_2.789979_g19587_i0 | PRJNA896554 | 24443 | 1530 | 2.789979 | 42.6866787 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.012 | NTclustered | gi|690513703|emb|LN064217.1| | 99802 | g19587 | i0 | 100 | 0.177777777777778 | 30 | 0 | 2 | 0 | 1327 | 1356 | 1135 | 1164 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0062117 | blastn | 272 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 3423463 | 3423463 | PRJNA896554_P_NODE_97023_length_340_cov_1.056180_g89483_i0 | PRJNA896554 | 97023 | 340 | 1.05618 | 3.591012 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 577 | 4.2899999999999987e-160 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g89483 | i0 | 97.093 | 73.5088235294118 | 344 | 6 | 100 | 1 | 1 | 340 | 369 | 26 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 24993 | 577 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9798020 | 9798020 | PRJNA896554_P_NODE_136188_length_268_cov_1.010256_g128648_i0 | PRJNA896554 | 136188 | 268 | 1.010256 | 2.70748608 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 459 | 1.2399999999999996e-124 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g128648 | i0 | 97.744 | 0.992537313432836 | 266 | 6 | 99 | 0 | 3 | 268 | 79 | 344 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 266 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14899853 | 14899853 | PRJNA896554_P_NODE_64152_length_500_cov_1.217799_g56618_i0 | PRJNA896554 | 64152 | 500 | 1.217799 | 6.088995 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 75 | 1.04e-8 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g56618 | i0 | 97.674 | 1.724 | 43 | 1 | 9 | 0 | 458 | 500 | 467 | 425 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 862 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28413781 | 28413781 | PRJNA896554_P_NODE_159026_length_247_cov_1.735632_g151486_i0 | PRJNA896554 | 159026 | 247 | 1.735632 | 4.28701104 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 58.2 | 2.42e-8 | NR | AAX30334.2 | 6182 | g151486 | i0 | 65.1 | 0.522267206477733 | 43 | 13 | 49.8 | 1 | 125 | 247 | 49 | 91 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 129 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31074516 | 31074516 | PRJNA896554_P_NODE_102075_length_327_cov_1.212598_g94535_i0 | PRJNA896554 | 102075 | 327 | 1.212598 | 3.96519546 | Taenia | 6202 | Platyhelminthes | Platyhelminthes | 93.2 | 5.64e-20 | NR | BAH03397.1 | 60517 | g94535 | i0 | 46 | 1.88990825688073 | 100 | 51 | 89 | 1 | 295 | 5 | 37 | 136 | BAH03397.1 cathepsin L-like cysteine peptidase [Taenia asiatica] | diamond | 618 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 31857230 | 31857230 | PRJNA896554_P_NODE_72137_length_442_cov_1.501355_g64597_i0 | PRJNA896554 | 72137 | 442 | 1.501355 | 6.6359891 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 66.6 | 2.07e-11 | NR | AAX31080.1 | 6182 | g64597 | i0 | 75 | 0.298642533936652 | 44 | 11 | 29.9 | 0 | 311 | 442 | 1 | 44 | AAX31080.1 SJCHGC09793 protein [Schistosoma japonicum] | diamond | 132 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31888835 | 31888835 | PRJNA896554_P_NODE_150817_length_251_cov_0.865169_g143277_i0 | PRJNA896554 | 150817 | 251 | 0.865169 | 2.17157419 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 85.9 | 1.05e-18 | NR | AAX25032.2 | 6182 | g143277 | i0 | 77.1 | 0.573705179282869 | 48 | 11 | 57.4 | 0 | 149 | 6 | 86 | 133 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 144 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum |
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);;