metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA641707" 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
26669392	26669392	PRJNA641707_P_NODE_325941_length_156_cov_2.158879_g323278_i0	PRJNA641707	325941	156	2.158879	3.36785124	Giardia intestinalis	5741	Fornicata	other_Eukaryota	43.9	0.00411	NR	ESU35215.1	5741	g323278	i0	44.7	0.903846153846154	47	18	80.8	2	139	14	51	94	ESU35215.1 Variant-specific surface protein [Giardia intestinalis]	diamond	141	43.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
27965447	27965447	PRJNA641707_P_NODE_216105_length_194_cov_6.310345_g213442_i0	PRJNA641707	216105	194	6.310345	12.2420693	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	42.4	0.0257	NR	KAG9390649.1	201153	g213442	i0	40	0.850515463917526	55	30	85.1	1	11	175	114	165	KAG9390649.1 Sperm-tail PG-rich repeat [Carpediemonas membranifera]	diamond	165	42.4	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
28533995	28533995	PRJNA641707_P_NODE_147687_length_239_cov_5.842105_g145024_i0	PRJNA641707	147687	239	5.842105	13.96263095	Giardia intestinalis	5741	Fornicata	other_Eukaryota	48.9	2.38e-4	NR	ESU38684.1	5741	g145024	i0	41.8	0.690376569037657	55	32	69	0	45	209	513	567	ESU38684.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	165	48.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28691961	28691961	PRJNA641707_P_NODE_276827_length_171_cov_8.836066_g274164_i0	PRJNA641707	276827	171	8.836066	15.10967286	Hexamita inflata	28002	Fornicata	other_Eukaryota	54.7	8.42e-7	NR	CAK8776862.1	28002	g274164	i0	49.1	0.964912280701754	55	28	96.5	0	5	169	253	307	CAK8776862.1 HINF_068007 [Hexamita inflata]	diamond	165	54.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
28723384	28723384	PRJNA641707_P_NODE_257547_length_179_cov_4.376923_g254884_i0	PRJNA641707	257547	179	4.376923	7.83469217	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	48.9	1.05e-4	NR	XP_067764259.1	348837	g254884	i0	44.2	0.871508379888268	52	27	85.5	2	25	177	41	91	XP_067764259.1 Sec23 [Spironucleus salmonicida]	diamond	156	48.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
29007895	29007895	PRJNA641707_P_NODE_9128_length_707_cov_12.281155_g7222_i0	PRJNA641707	9128	707	12.281155	86.82776585	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	56.6	3.26e-5	NR	XP_067766868.1	348837	g7222	i0	29.5	0.58981612446959	139	80	57.3	6	699	295	474	598	XP_067766868.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida]	diamond	417	56.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
30554846	30554846	PRJNA641707_P_NODE_190713_length_198_cov_26.986577_g188050_i0	PRJNA641707	190713	198	26.986577	53.43342246	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	55.5	5.87e-7	NR	KAG9395968.1	201153	g188050	i0	78.8	1	33	7	50	0	196	98	126	158	KAG9395968.1 Ribosomal protein L10/acidic P0 [Carpediemonas membranifera]	diamond	198	55.5	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
32779949	32779949	PRJNA641707_P_NODE_217820_length_194_cov_2.358621_g215157_i0	PRJNA641707	217820	194	2.358621	4.57572474	root	1	Root_unresolved	Root_unresolved	53.1	2.31e-6	NR	CAK8757749.1	28002	g215157	i0	47.9	3.55670103092783	48	25	74.2	0	46	189	99	146	CAK8757749.1 HINF_090445 [Hexamita inflata]	diamond	690	53.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata

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