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

6 rows where analysis = "diamond", bioproject = "PRJNA756891" and tax_phylum = "Fornicata"

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_phylum	tax_order	tax_family	tax_genus	tax_species
27115924	27115924	PRJNA756891_P_NODE_3102_length_474_cov_1.344140_g3034_i0	PRJNA756891	3102	474	1.34414	6.3712236	Kipferlia bialata	797122	Fornicata	other_Eukaryota	89.7	9.79e-18	NR	GCA63523.1	797122	g3034	i0	37.7	0.955696202531646	151	85	89.9	4	470	45	90	240	GCA63523.1 hypothetical protein KIPB_010413 [Kipferlia bialata]	diamond	453	89.7	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
27463853	27463853	PRJNA756891_P_NODE_10443_length_271_cov_1.393939_g10374_i0	PRJNA756891	10443	271	1.393939	3.77757469	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	71.2	5.09e-12	NR	KAG9392317.1	201153	g10374	i0	40.7	1.79335793357934	86	51	95.2	0	2	259	433	518	KAG9392317.1 Helicase conserved C-terminal domain [Carpediemonas membranifera]	diamond	486	71.2	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
28095206	28095206	PRJNA756891_P_NODE_7105_length_323_cov_1.232000_g7036_i0	PRJNA756891	7105	323	1.232	3.97936	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	57	7.21e-7	NR	XP_067768465.1	348837	g7036	i0	29	1.6625386996904	93	61	81.7	1	25	288	174	266	XP_067768465.1 Ubiquitin carboxyl-terminal hydrolase family protein [Spironucleus salmonicida]	diamond	537	57	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
29430896	29430896	PRJNA756891_P_NODE_5089_length_375_cov_1.529801_g5020_i0	PRJNA756891	5089	375	1.529801	5.73675375	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.5	0.00162	NR	KAG9392170.1	201153	g5020	i0	43.8	2.36	48	26	38.4	1	371	228	3830	3876	KAG9392170.1 FG-GAP repeat [Carpediemonas membranifera]	diamond	885	48.5	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
30748063	30748063	PRJNA756891_P_NODE_12194_length_251_cov_0.865169_g12125_i0	PRJNA756891	12194	251	0.865169	2.17157419	Kipferlia bialata	797122	Fornicata	other_Eukaryota	53.5	6.31e-6	NR	GIQ83745.1	797122	g12125	i0	37.7	0.824701195219124	69	38	82.5	1	229	23	308	371	GIQ83745.1 translation Initiation factor eIF- 4e [Kipferlia bialata]	diamond	207	53.5	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
32843830	32843830	PRJNA756891_P_NODE_11020_length_264_cov_1.209424_g10951_i0	PRJNA756891	11020	264	1.209424	3.19287936	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	80.9	1.06e-15	NR	KAG9396190.1	201153	g10951	i0	41.9	5.54545454545455	86	47	94.3	2	257	9	80	165	KAG9396190.1 Deoxyribonuclease II [Carpediemonas membranifera]	diamond	1464	80.9	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera

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