metadata: contig_metadata: 8 rows where bioproject = "PRJNA781196", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA781196", tax_kingdom = "Metazoa" 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
26736568	26736568	PRJNA781196_P_NODE_51141_length_252_cov_1.564246_g50764_i0	PRJNA781196	51141	252	1.564246	3.94189992	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	60.1	8.09e-10	NR	PAA59348.1	282301	g50764	i0	41.9	2.11904761904762	62	36	73.8	0	228	43	6	67	PAA59348.1 hypothetical protein BOX15_Mlig020961g1 [Macrostomum lignano]	diamond	534	60.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
27631684	27631684	PRJNA781196_P_NODE_40664_length_281_cov_1.254808_g40287_i0	PRJNA781196	40664	281	1.254808	3.52601048	Taeniidae	6208	Platyhelminthes	Platyhelminthes	84.3	1.43e-16	NR	VDM30214.1	6205	g40287	i0	48.8	2.62633451957295	82	42	87.5	0	5	250	64	145	VDM30214.1 unnamed protein product [Hydatigera taeniaeformis]	diamond	738	84.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Hydatigera	Hydatigera taeniaeformis
28326043	28326043	PRJNA781196_P_NODE_50966_length_253_cov_0.866667_g50589_i0	PRJNA781196	50966	253	0.866667	2.19266751	Metazoa	33208	Platyhelminthes	Platyhelminthes	103	1.1399999999999999e-23	NR	KAA0192185.1	27845	g50589	i0	61.7	21.7351778656126	81	31	96	0	4	246	123	203	KAA0192185.1 Annexin [Fasciolopsis buskii]	diamond	5499	104	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
29651912	29651912	PRJNA781196_P_NODE_21710_length_365_cov_1.602740_g21333_i0	PRJNA781196	21710	365	1.60274	5.850001	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	67.8	2.96e-11	NR	ABX58011.1	6192	g21333	i0	52.7	1.38082191780822	55	26	45.2	0	2	166	5	59	ABX58011.1 pumilio-like protein 2, partial [Fasciola hepatica]	diamond	504	67.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
30157436	30157436	PRJNA781196_P_NODE_16692_length_407_cov_0.934132_g16315_i0	PRJNA781196	16692	407	0.934132	3.80191724	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	126	1.24e-33	NR	PAA64251.1	282301	g16315	i0	48.8	8.36609336609337	127	64	93.6	1	1	381	76	201	PAA64251.1 hypothetical protein BOX15_Mlig028052g1, partial [Macrostomum lignano]	diamond	3405	126	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30252656	30252656	PRJNA781196_P_NODE_65312_length_243_cov_0.917647_g64935_i0	PRJNA781196	65312	243	0.917647	2.22988221	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	90.5	5.63e-19	NR	TNN06667.1	6182	g64935	i0	61.1	14.9382716049383	72	28	88.9	0	23	238	44	115	TNN06667.1 Pre-mRNA-splicing factor ATP-dependent RNA helicase DHX15 [Schistosoma japonicum]	diamond	3630	91.3	0.991237677984666	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
31475768	31475768	PRJNA781196_P_NODE_63516_length_244_cov_0.912281_g63139_i0	PRJNA781196	63516	244	0.912281	2.22596564	Dibothriocephalus latus	60516	Platyhelminthes	Platyhelminthes	48.1	4.27e-4	NR	VDK85990.1	60516	g63139	i0	41.8	1.97950819672131	55	30	67.6	1	3	167	250	302	VDK85990.1 unnamed protein product [Dibothriocephalus latus]	diamond	483	48.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Dibothriocephalus	Dibothriocephalus latus
32117781	32117781	PRJNA781196_P_NODE_61918_length_245_cov_0.906977_g61541_i0	PRJNA781196	61918	245	0.906977	2.22209365	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	91.7	6.59e-21	NR	VZI41763.1	99802	g61541	i0	68.7	11.4857142857143	67	20	82	1	203	3	1	66	VZI41763.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	2814	92	0.996739130434783	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei

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