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

6 rows where analysis = "diamond", bioproject = "PRJNA700095" 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
26841039	26841039	PRJNA700095_P_NODE_39941_length_276_cov_1.477833_g38677_i0	PRJNA700095	39941	276	1.477833	4.07881908	Metazoa	33208	Platyhelminthes	Platyhelminthes	55.8	1.18e-6	NR	VUZ55185.1	6216	g38677	i0	45.6	8.43478260869565	57	31	62	0	172	2	46	102	VUZ55185.1 unnamed protein product, partial [Hymenolepis diminuta]	diamond	2328	55.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
27504931	27504931	PRJNA700095_P_NODE_69963_length_216_cov_4.020979_g68698_i0	PRJNA700095	69963	216	4.020979	8.68531464	Schistosoma	6181	Platyhelminthes	Platyhelminthes	46.2	0.00158	NR	TNN08009.1	6182	g68698	i0	37.2	9.55555555555556	43	27	59.7	0	144	16	377	419	TNN08009.1 CCR4-NOT transcription complex subunit 11 isoform 1 [Schistosoma japonicum]	diamond	2064	46.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27683337	27683337	PRJNA700095_P_NODE_42264_length_270_cov_1.558376_g41000_i0	PRJNA700095	42264	270	1.558376	4.2076152	Calicophoron daubneyi	300641	Platyhelminthes	Platyhelminthes	50.4	9.79e-5	NR	CAL5135764.1	300641	g41000	i0	44.1	1.51111111111111	68	27	75.6	2	221	18	9	65	CAL5135764.1 unnamed protein product [Calicophoron daubneyi]	diamond	408	50.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Paramphistomidae	Calicophoron	Calicophoron daubneyi
29746229	29746229	PRJNA700095_P_NODE_18350_length_418_cov_0.884058_g17087_i0	PRJNA700095	18350	418	0.884058	3.69536244	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	56.6	2.68e-6	NR	VZI22467.1	99802	g17087	i0	27.8	10.0478468899522	126	83	90.4	3	3	380	141	258	VZI22467.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	4200	57	0.992982456140351	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
29893369	29893369	PRJNA700095_P_NODE_19171_length_406_cov_1.510511_g17908_i0	PRJNA700095	19171	406	1.510511	6.13267466	Schistosoma margrebowiei	48269	Platyhelminthes	Platyhelminthes	108	2.9400000000000004e-27	NR	VDP18829.1	48269	g17908	i0	52.6	2.15024630541872	97	44	71.7	1	398	108	35	129	VDP18829.1 unnamed protein product [Schistosoma margrebowiei]	diamond	873	108	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma margrebowiei
30504757	30504757	PRJNA700095_P_NODE_67053_length_236_cov_2.656442_g65789_i0	PRJNA700095	67053	236	2.656442	6.26920312	Diphyllobothriidae	28843	Platyhelminthes	Platyhelminthes	66.6	2.55e-11	NR	VDN09442.1	60516	g65789	i0	42.9	1.95762711864407	77	44	97.9	0	232	2	73	149	VDN09442.1 unnamed protein product, partial [Dibothriocephalus latus]	diamond	462	66.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Dibothriocephalus	Dibothriocephalus latus

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