contig_metadata
8 rows where bioproject = "PRJNA1120771", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2827291 | 2827291 | PRJNA1120771_S_NODE_26743_length_232_cov_3.460317_g26343_i0 | PRJNA1120771 | 26743 | 232 | 3.460317 | 8.02793544 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 374 | 3.9e-99 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g26343 | i0 | 95.708 | 1.00431034482759 | 233 | 8 | 100 | 2 | 1 | 232 | 454 | 223 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 233 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 6131412 | 6131412 | PRJNA1120771_S_NODE_17205_length_276_cov_27.806867_g16805_i0 | PRJNA1120771 | 17205 | 276 | 27.806867 | 76.74695292 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 139 | 2.45e-40 | NR | CAX72137.1 | 6182 | g16805 | i0 | 75 | 28.3478260869565 | 92 | 22 | 100 | 1 | 276 | 1 | 39 | 129 | CAX72137.1 ribosomal protein S15 [Schistosoma japonicum] | diamond | 7824 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 15579427 | 15579427 | PRJNA1120771_S_NODE_1693_length_673_cov_8.238095_g1388_i0 | PRJNA1120771 | 1693 | 673 | 8.238095 | 55.44237935 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.019 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g1388 | i0 | 100 | 0.0430906389301634 | 29 | 0 | 4 | 0 | 163 | 191 | 5361 | 5389 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 18880153 | 18880153 | PRJNA1120771_S_NODE_24735_length_240_cov_3.959391_g24335_i0 | PRJNA1120771 | 24735 | 240 | 3.959391 | 9.5025384 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|15283994|gb|AY033597.1| | 6182 | g24335 | i0 | 100 | 0.7 | 28 | 0 | 12 | 0 | 157 | 184 | 355 | 382 | Schistosoma japonicum high voltage-activated calcium channel beta subunit CavB mRNA, complete cds | blastn | 168 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 19402590 | 19402590 | PRJNA1120771_S_NODE_7376_length_374_cov_1.577039_g6976_i0 | PRJNA1120771 | 7376 | 374 | 1.577039 | 5.89812586 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 143 | 6.3599999999999996e-40 | NR | VDN13523.1 | 60516 | g6976 | i0 | 69.6 | 8.85561497326203 | 92 | 28 | 73.8 | 0 | 373 | 98 | 142 | 233 | VDN13523.1 unnamed protein product [Dibothriocephalus latus] | diamond | 3312 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 24502497 | 24502497 | PRJNA1120771_S_NODE_15640_length_286_cov_6.131687_g15240_i0 | PRJNA1120771 | 15640 | 286 | 6.131687 | 17.53662482 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.026 | NTclustered | gi|690596878|emb|LN150304.1| | 99802 | g15240 | i0 | 100 | 0.0979020979020979 | 28 | 0 | 10 | 0 | 156 | 183 | 1801 | 1774 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0136384 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 28965050 | 28965050 | PRJNA1120771_S_NODE_31788_length_216_cov_6.872832_g31388_i0 | PRJNA1120771 | 31788 | 216 | 6.872832 | 14.84531712 | Dibothriocephalus latus | 60516 | Platyhelminthes | Platyhelminthes | 48.9 | 1.35e-4 | NR | VDN13523.1 | 60516 | g31388 | i0 | 100 | 0.277777777777778 | 20 | 0 | 27.8 | 0 | 214 | 155 | 214 | 233 | VDN13523.1 unnamed protein product [Dibothriocephalus latus] | diamond | 60 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 29364713 | 29364713 | PRJNA1120771_S_NODE_14549_length_294_cov_2.079681_g14149_i0 | PRJNA1120771 | 14549 | 294 | 2.079681 | 6.11426214 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 45.4 | 0.00374 | NR | VDQ12318.1 | 157069 | g14149 | i0 | 37.8 | 3.56122448979592 | 82 | 34 | 82.7 | 3 | 256 | 14 | 82 | 147 | VDQ12318.1 unnamed protein product [Trichobilharzia regenti] | diamond | 1047 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti |
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);;