contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA681822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3205194 | 3205194 | PRJNA681822_P_NODE_322923_length_268_cov_1.456410_g321434_i0 | PRJNA681822 | 322923 | 268 | 1.45641 | 3.9031788 | Lacistorhynchus tenuis | 56695 | Platyhelminthes | Platyhelminthes | 135 | 2.3700000000000003e-27 | NTclustered | gi|1839203|gb|U85828.1|LTU85828 | 56695 | g321434 | i0 | 78.846 | 2.10820895522388 | 208 | 38 | 76 | 3 | 14 | 218 | 266 | 62 | Lacistorhynchus tenuis enolase mRNA, partial cds | blastn | 565 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Trypanorhyncha | Lacistorhynchidae | Lacistorhynchus | Lacistorhynchus tenuis | |
| 7034118 | 7034118 | PRJNA681822_P_NODE_419626_length_247_cov_1.770115_g418137_i0 | PRJNA681822 | 419626 | 247 | 1.770115 | 4.37218405 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 307 | 4.32e-79 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g418137 | i0 | 89.113 | 1.00404858299595 | 248 | 25 | 100 | 2 | 1 | 247 | 8426 | 8180 | Stenostomum sthenum mitochondrion, complete genome | blastn | 248 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 8308141 | 8308141 | PRJNA681822_P_NODE_373147_length_253_cov_2.522222_g371658_i0 | PRJNA681822 | 373147 | 253 | 2.522222 | 6.38122166 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|690520301|emb|LN071422.1| | 99802 | g371658 | i0 | 100 | 0.114624505928854 | 29 | 0 | 11 | 0 | 182 | 210 | 4560 | 4532 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0068861 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 9582903 | 9582903 | PRJNA681822_P_NODE_324428_length_267_cov_2.881443_g322939_i0 | PRJNA681822 | 324428 | 267 | 2.881443 | 7.69345281 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 409 | 1.2599999999999998e-109 | NTclustered | gi|690749576|emb|LN305853.1| | 99802 | g322939 | i0 | 94.526 | 1.02621722846442 | 274 | 0 | 97 | 4 | 9 | 267 | 1 | 274 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_contig0088093 | blastn | 274 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 20296277 | 20296277 | PRJNA681822_P_NODE_160476_length_334_cov_1.095785_g158988_i0 | PRJNA681822 | 160476 | 334 | 1.095785 | 3.6599219 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.031 | NTclustered | gi|55469740|gb|AY791899.1| | 6206 | g158988 | i0 | 100 | 0.251497005988024 | 28 | 0 | 8 | 0 | 180 | 207 | 545 | 518 | Taenia saginata 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia saginata | |
| 21056395 | 21056395 | PRJNA681822_P_NODE_280637_length_279_cov_1.417476_g279148_i0 | PRJNA681822 | 280637 | 279 | 1.417476 | 3.95475804 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 505 | 1.6399999999999995e-138 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g279148 | i0 | 99.283 | 85.6523297491039 | 279 | 2 | 100 | 0 | 1 | 279 | 2131 | 1853 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 23897 | 505 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 24883114 | 24883114 | PRJNA681822_P_NODE_69080_length_452_cov_3.519789_g67606_i0 | PRJNA681822 | 69080 | 452 | 3.519789 | 15.90944628 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 791 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g67606 | i0 | 98.23 | 45.6703539823009 | 452 | 8 | 100 | 0 | 1 | 452 | 8525 | 8976 | Stenostomum sthenum mitochondrion, complete genome | blastn | 20643 | 791 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum |
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);;