metadata: contig_metadata: 5 rows where bioproject = "PRJNA1078753", tax_clade = "Metamonada" and tax

5 rows where bioproject = "PRJNA1078753", tax_clade = "Metamonada" 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
1467300	1467300	PRJNA1078753_P_NODE_8582_length_376_cov_1.287129_g8386_i0	PRJNA1078753	8582	376	1.287129	4.83960504	Chilomastix caulleryi	926448	Fornicata	other_Eukaryota	274	7.02e-69	NTclustered	gi\|339759413\|dbj\|AB600320.1\|	926448	g8386	i0	82.951	71.5106382978723	305	50	81	2	1	304	387	84	Chilomastix caulleryi gene for alpha-tubulin, complete cds	blastn	26888	274	1	Eukaryota	Metamonada	Fornicata		Retortamonadidae	Chilomastix	Chilomastix caulleryi
20143185	20143185	PRJNA1078753_P_NODE_11776_length_335_cov_1.751908_g11580_i0	PRJNA1078753	11776	335	1.751908	5.8688918	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	79.3	8.84e-15	NR	GKT13252.1	2918883	g11580	i0	48.4	1.54925373134328	91	44	81.5	1	2	274	173	260	GKT13252.1 autophagy-related protein 18a [Aduncisulcus paluster]	diamond	519	79.3	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
26963851	26963851	PRJNA1078753_P_NODE_12442_length_329_cov_1.128906_g12246_i0	PRJNA1078753	12442	329	1.128906	3.71410074	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	49.3	3.53e-4	NR	KAG9393788.1	201153	g12246	i0	45.2	2.35258358662614	42	23	38.3	0	185	310	48	89	KAG9393788.1 Synaptobrevin [Carpediemonas membranifera]	diamond	774	49.7	0.991951710261569	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
27446939	27446939	PRJNA1078753_P_NODE_26903_length_251_cov_1.337079_g26707_i0	PRJNA1078753	26903	251	1.337079	3.35606829	Hexamita inflata	28002	Fornicata	other_Eukaryota	57	3.99e-7	NR	CAK8761137.1	28002	g26707	i0	59.6	0.561752988047809	47	19	56.2	0	33	173	980	1026	CAK8761137.1 HINF_002274 [Hexamita inflata]	diamond	141	57	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
30098929	30098929	PRJNA1078753_P_NODE_6652_length_416_cov_2.160350_g6456_i0	PRJNA1078753	6652	416	2.16035	8.987056	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	46.6	0.0108	NR	XP_067768360.1	348837	g6456	i0	57.9	0.274038461538462	38	16	27.4	0	299	412	48	85	XP_067768360.1 Sodium/potassium-transporting ATPase alpha chain [Spironucleus salmonicida]	diamond	114	46.6	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);;