contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA812715" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2087529 | 2087529 | PRJNA812715_P_NODE_106762_length_248_cov_2.605714_g104961_i0 | PRJNA812715 | 106762 | 248 | 2.605714 | 6.46217072 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 259 | 1.23e-64 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g104961 | i0 | 86.192 | 4.92741935483871 | 239 | 33 | 96 | 0 | 6 | 244 | 5154 | 5392 | Stenostomum sthenum mitochondrion, complete genome | blastn | 1222 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 4643132 | 4643132 | PRJNA812715_P_NODE_85444_length_276_cov_1.137931_g83643_i0 | PRJNA812715 | 85444 | 276 | 1.137931 | 3.14068956 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.025 | NTclustered | gi|690658596|emb|LN207720.1| | 99802 | g83643 | i0 | 96.774 | 0.22463768115942 | 31 | 1 | 11 | 0 | 235 | 265 | 1271 | 1301 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0174958 | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 8465513 | 8465513 | PRJNA812715_P_NODE_18447_length_808_cov_13.580952_g16886_i0 | PRJNA812715 | 18447 | 808 | 13.580952 | 109.73409216 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 1288 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g16886 | i0 | 95.432 | 26.3341584158416 | 810 | 33 | 100 | 4 | 1 | 808 | 8964 | 8157 | Stenostomum sthenum mitochondrion, complete genome | blastn | 21278 | 1288 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 11017028 | 11017028 | PRJNA812715_P_NODE_38249_length_461_cov_3.644330_g36459_i0 | PRJNA812715 | 38249 | 461 | 3.64433 | 16.8003613 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 514 | 4.75e-141 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g36459 | i0 | 86.9 | 78.353579175705 | 458 | 60 | 99 | 0 | 3 | 460 | 457 | 914 | Stenostomum sthenum mitochondrion, complete genome | blastn | 36121 | 514 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 13565261 | 13565261 | PRJNA812715_P_NODE_100431_length_252_cov_2.513966_g98630_i0 | PRJNA812715 | 100431 | 252 | 2.513966 | 6.33519432 | Brachylaima thompsoni | 138588 | Platyhelminthes | Platyhelminthes | 466 | 6.89e-127 | NTclustered | gi|31711564|gb|AY222085.1| | 138588 | g98630 | i0 | 100 | 86.515873015873 | 252 | 0 | 100 | 0 | 1 | 252 | 657 | 908 | Brachylaima thompsoni 18S ribosomal RNA gene, partial sequence | blastn | 21802 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Diplostomida | Brachylaimidae | Brachylaima | Brachylaima thompsoni | |
| 16116294 | 16116294 | PRJNA812715_P_NODE_56693_length_351_cov_2.115108_g54894_i0 | PRJNA812715 | 56693 | 351 | 2.115108 | 7.42402908 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 58.4 | 7.13e-4 | NTclustered | gi|687277514|emb|LK436380.1| | 57078 | g54894 | i0 | 86.207 | 0.925925925925926 | 58 | 3 | 15 | 4 | 247 | 300 | 215 | 271 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0041755 | blastn | 325 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum |
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);;