metadata: contig_metadata: 9 rows where bioproject = "PRJNA891846", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA891846", tax_clade = "Opisthokonta" and tax_phylum = "Platyhelminthes"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
866718	866718	PRJNA891846_P_NODE_13481_length_412_cov_1.215339_g13262_i0	PRJNA891846	13481	412	1.215339	5.00719668	Calicophoron daubneyi	300641	Platyhelminthes	Platyhelminthes	191	4.25e-58	NR	CAL5139973.1	300641	g13262	i0	65.1	2.78155339805825	129	45	93.9	0	412	26	132	260	CAL5139973.1 unnamed protein product [Calicophoron daubneyi]	diamond	1146	191	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Paramphistomidae	Calicophoron	Calicophoron daubneyi
7245150	7245150	PRJNA891846_P_NODE_2586_length_870_cov_3.249686_g2419_i0	PRJNA891846	2586	870	3.249686	28.2722682	Metazoa	33208	Platyhelminthes	Platyhelminthes	439	5.79e-150	NR	CDS16437.1	6210	g2419	i0	81.7	402.748275862069	252	46	86.9	0	758	3	58	309	CDS16437.1 tubulin alpha chain [Echinococcus granulosus]	diamond	350391	443	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
8519887	8519887	PRJNA891846_P_NODE_24587_length_307_cov_1.277778_g24368_i0	PRJNA891846	24587	307	1.277778	3.92277846	Metazoa	33208	Platyhelminthes	Platyhelminthes	202	1.3000000000000002e-60	NR	CDS16437.1	6210	g24368	i0	97.1	661.749185667752	102	3	99.7	0	1	306	157	258	CDS16437.1 tubulin alpha chain [Echinococcus granulosus]	diamond	203157	204	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
16170367	16170367	PRJNA891846_P_NODE_9953_length_472_cov_2.305764_g9736_i0	PRJNA891846	9953	472	2.305764	10.88320608	Fasciola gigantica	46835	Platyhelminthes	Platyhelminthes	279	3.47e-90	NR	TPP61778.1	46835	g9736	i0	85.4	20.9300847457627	157	23	99.8	0	472	2	34	190	TPP61778.1 Adenosylhomocysteinase B [Fasciola gigantica]	diamond	9879	279	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola gigantica
18718139	18718139	PRJNA891846_P_NODE_1295_length_1172_cov_2.363967_g1182_i0	PRJNA891846	1295	1172	2.363967	27.70569324	root	1	Root_unresolved	Root_unresolved	322	1.23e-97	NR	CDS31835.1	85433	g1182	i0	39.5	7.95563139931741	408	212	96.2	6	1129	2	338	742	CDS31835.1 Papilin [Hymenolepis microstoma]	diamond	9324	323	0.996904024767802	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis microstoma
25093268	25093268	PRJNA891846_P_NODE_35680_length_254_cov_1.618785_g35460_i0	PRJNA891846	35680	254	1.618785	4.1117139	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	52.8	0.023	NTclustered	gi\|687615665\|emb\|LK490202.1\|	57078	g35460	i0	100	0.110236220472441	28	0	11	0	39	66	478	505	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0004960	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
28223972	28223972	PRJNA891846_P_NODE_24146_length_310_cov_1.143460_g23927_i0	PRJNA891846	24146	310	1.14346	3.544726	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	135	1.13e-35	NR	PAA66530.1	282301	g23927	i0	60.2	1.99354838709677	103	41	99.7	0	310	2	155	257	PAA66530.1 hypothetical protein BOX15_Mlig030441g1 [Macrostomum lignano]	diamond	618	135	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
29392519	29392519	PRJNA891846_P_NODE_42829_length_245_cov_0.994186_g42609_i0	PRJNA891846	42829	245	0.994186	2.4357557	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	71.6	2.49e-12	NR	VZI51601.1	99802	g42609	i0	44.4	1.91020408163265	81	44	99.2	1	244	2	127	206	VZI51601.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	468	71.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
31319469	31319469	PRJNA891846_P_NODE_28035_length_288_cov_1.297674_g27816_i0	PRJNA891846	28035	288	1.297674	3.73730112	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	50.1	1.62e-4	NR	KAH9280019.1	6210	g27816	i0	39.2	2.1875	74	41	74	2	218	6	1	73	KAH9280019.1 UBX domain-containing protein 2 [Echinococcus granulosus]	diamond	630	50.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus

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);;