contig_metadata
7 rows where bioproject = "PRJNA734348", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3269267 | 3269267 | PRJNA734348_P_NODE_28823_length_362_cov_4.737024_g28128_i0 | PRJNA734348 | 28823 | 362 | 4.737024 | 17.14802688 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 652 | 0 | NTclustered | gi|1124902734|gb|AY812498.2| | 6182 | g28128 | i0 | 99.171 | 99.9447513812155 | 362 | 3 | 100 | 0 | 1 | 362 | 1074 | 713 | Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds | blastn | 36180 | 652 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 7097085 | 7097085 | PRJNA734348_P_NODE_50406_length_289_cov_2.671296_g49709_i0 | PRJNA734348 | 50406 | 289 | 2.671296 | 7.72004544 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 329 | 1.1e-85 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g49709 | i0 | 97.423 | 9.41176470588235 | 194 | 4 | 67 | 1 | 1 | 194 | 275 | 467 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 2720 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 11401092 | 11401092 | PRJNA734348_P_NODE_64929_length_274_cov_5.716418_g64232_i0 | PRJNA734348 | 64929 | 274 | 5.716418 | 15.66298532 | Plagiostomum | 84130 | Platyhelminthes | Platyhelminthes | 145 | 4.04e-30 | NTclustered | gi|1587089599|gb|MG882058.1| | 2544880 | g64232 | i0 | 86.232 | 47.3175182481752 | 138 | 13 | 49 | 5 | 2 | 136 | 1063 | 929 | Plagiostomum sp. n. MW-2019 isolate XK2 28S ribosomal RNA gene, partial sequence | blastn | 12965 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Prolecithophora | Plagiostomidae | Plagiostomum | Plagiostomum sp. n. MW-2019 | |
| 13472702 | 13472702 | PRJNA734348_P_NODE_75931_length_264_cov_1.612565_g75233_i0 | PRJNA734348 | 75931 | 264 | 1.612565 | 4.2571716 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g75233 | i0 | 100 | 0.109848484848485 | 29 | 0 | 11 | 0 | 98 | 126 | 5361 | 5389 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 16020898 | 16020898 | PRJNA734348_P_NODE_45273_length_299_cov_3.500000_g44576_i0 | PRJNA734348 | 45273 | 299 | 3.5 | 10.465 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 477 | 3.8699999999999984e-130 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g44576 | i0 | 95.638 | 128.200668896321 | 298 | 11 | 100 | 2 | 1 | 297 | 1768 | 2064 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 38332 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 19845944 | 19845944 | PRJNA734348_P_NODE_83016_length_258_cov_1.502703_g82318_i0 | PRJNA734348 | 83016 | 258 | 1.502703 | 3.87697374 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|690474727|emb|LN015249.1| | 99802 | g82318 | i0 | 100 | 0.116279069767442 | 30 | 0 | 12 | 0 | 223 | 252 | 5608 | 5637 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0015041 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 29420677 | 29420677 | PRJNA734348_P_NODE_95289_length_250_cov_1.666667_g94591_i0 | PRJNA734348 | 95289 | 250 | 1.666667 | 4.1666675 | Schistosoma mattheei | 31246 | Platyhelminthes | Platyhelminthes | 57.8 | 1.91e-7 | NR | VDP78995.1 | 31246 | g94591 | i0 | 42.7 | 1.812 | 75 | 42 | 90 | 1 | 3 | 227 | 136 | 209 | VDP78995.1 unnamed protein product, partial [Schistosoma mattheei] | diamond | 453 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mattheei |
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);;