metadata: contig_metadata: 5 rows where bioproject = "PRJNA540466" and tax

5 rows where bioproject = "PRJNA540466" 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
27678370	27678370	PRJNA540466_S_NODE_37724_length_297_cov_3.352679_g37175_i0	PRJNA540466	37724	297	3.352679	9.95745663	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	112	1.3600000000000002e-27	NR	KAG9390653.1	201153	g37175	i0	53.1	4.08080808080808	98	40	99	2	295	2	159	250	KAG9390653.1 Papain family cysteine protease [Carpediemonas membranifera]	diamond	1212	112	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
28166685	28166685	PRJNA540466_S_NODE_21565_length_382_cov_2.491909_g21016_i0	PRJNA540466	21565	382	2.491909	9.51909238	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.9	3.13e-4	NR	CAK8772847.1	28002	g21016	i0	38.2	2.98429319371728	68	38	53.4	1	308	105	7	70	CAK8772847.1 HINF_100844 [Hexamita inflata]	diamond	1140	49.3	0.991886409736308	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
28972737	28972737	PRJNA540466_S_NODE_48568_length_267_cov_2.649485_g48019_i0	PRJNA540466	48568	267	2.649485	7.07412495	Giardia muris	5742	Fornicata	other_Eukaryota	50.1	1.36e-4	NR	TNJ28442.1	5742	g48019	i0	50	0.51685393258427	46	23	51.7	0	267	130	714	759	TNJ28442.1 High cysteine membrane protein [Giardia muris]	diamond	138	50.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
29856688	29856688	PRJNA540466_S_NODE_64131_length_240_cov_3.227545_g63582_i0	PRJNA540466	64131	240	3.227545	7.746108	Giardia intestinalis ATCC 5	5741	Fornicata	other_Eukaryota	65.5	6.51e-11	NR	EES99890.1	598745	g63582	i0	65.9	1.6625	44	15	55	0	93	224	135	178	EES99890.1 Hypothetical protein GL50581_2875 [Giardia intestinalis ATCC 50581]	diamond	399	65.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31752902	31752902	PRJNA540466_S_NODE_44717_length_276_cov_6.798030_g44168_i0	PRJNA540466	44717	276	6.79803	18.7625628	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	45.4	0.00108	NR	XP_067762115.1	348837	g44168	i0	40	0.597826086956522	55	32	59.8	1	63	227	42	95	XP_067762115.1 Dynein light chain [Spironucleus salmonicida]	diamond	165	45.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida

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