metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA763243" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA763243" 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
26999367	26999367	PRJNA763243_P_NODE_22262_length_339_cov_1.687970_g21916_i0	PRJNA763243	22262	339	1.68797	5.7222183	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	2.11e-5	NR	XP_024353857.1	6210	g21916	i0	60.6	0.97345132743362806	33	13	29.2	0	19	117	159	191	XP_024353857.1 Butyrate response factor [Echinococcus granulosus]	diamond	330	53.1	0.994350282485876	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
27915531	27915531	PRJNA763243_P_NODE_32905_length_297_cov_5.834821_g32559_i0	PRJNA763243	32905	297	5.834821	17.32941837	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	119	1.18e-30	NR	PAA53253.1	282301	g32559	i0	65.1	2.72727272727273	83	29	83.8	0	249	1	41	123	PAA53253.1 hypothetical protein BOX15_Mlig016645g3, partial [Macrostomum lignano]	diamond	810	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
27915533	27915533	PRJNA763243_P_NODE_45965_length_263_cov_0.810526_g45619_i0	PRJNA763243	45965	263	0.810526	2.13168338	Cestoda	6199	Platyhelminthes	Platyhelminthes	95.9	9.38e-21	NR	KAH9282093.1	6210	g45619	i0	59.8	50.532319391635	87	31	97	3	8	262	116	200	KAH9282093.1 Calcium/calmodulin-dependent protein kinase type II alpha chain [Echinococcus granulosus]	diamond	13290	96.7	0.991726990692865	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
28073443	28073443	PRJNA763243_P_NODE_24105_length_328_cov_1.662745_g23759_i0	PRJNA763243	24105	328	1.662745	5.4538036	Opisthorchiidae	6196	Platyhelminthes	Platyhelminthes	64.3	2.74e-9	NR	OON19107.1	6198	g23759	i0	36.1	4.68292682926829	108	62	92.4	1	307	5	397	504	OON19107.1 kinase domain protein, partial [Opisthorchis viverrini]	diamond	1536	64.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
32361310	32361310	PRJNA763243_P_NODE_46219_length_262_cov_1.962963_g45873_i0	PRJNA763243	46219	262	1.962963	5.14296306	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	56.6	6.02e-7	NR	PAA55015.1	282301	g45873	i0	39	0.881679389312977	77	44	87	2	9	236	243	317	PAA55015.1 hypothetical protein BOX15_Mlig028881g1 [Macrostomum lignano]	diamond	231	56.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
32865819	32865819	PRJNA763243_P_NODE_71560_length_213_cov_4.371429_g71214_i0	PRJNA763243	71560	213	4.371429	9.31114377	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	47.4	5.72e-4	NR	PAA86220.1	282301	g71214	i0	39.3	1.57746478873239	56	34	78.9	0	170	3	156	211	PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano]	diamond	336	47.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano

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