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

5 rows where bioproject = "PRJNA395690", tax_clade = "Metamonada" and tax_superkingdom = "Eukaryota"

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
20205244	20205244	PRJNA395690_P_NODE_34496_length_162_cov_0.902655_g34344_i0	PRJNA395690	34496	162	0.902655	1.4623011	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	89.4	7.29e-20	NR	GKT24450.1	2918883	g34344	i0	78.8	10.7777777777778	52	11	96.3	0	5	160	152	203	GKT24450.1 40S ribosomal protein S2 [Aduncisulcus paluster]	diamond	1746	89.4	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
24637892	24637892	PRJNA395690_P_NODE_15980_length_203_cov_1.727273_g15828_i0	PRJNA395690	15980	203	1.727273	3.50636419	Holomastigotes sp.	3086161	Parabasalia	other_Eukaryota	54.7	0.005	NTclustered	gi\|2637867513\|gb\|OR995878.1\|	3086161	g15828	i0	100	0.556650246305419	29	0	14	0	175	203	2885	2857	Holomastigotes sp. clone Hsjo_Para28S_sq46sz39 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	113	54.7	1	Eukaryota	Metamonada	Parabasalia	Spirotrichonymphida	Holomastigotoididae	Holomastigotes	Holomastigotes sp.
27138127	27138127	PRJNA395690_P_NODE_35242_length_161_cov_2.250000_g35090_i0	PRJNA395690	35242	161	2.25	3.6225	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	42.4	0.0148	NR	GKT30733.1	2918883	g35090	i0	55.9	0.633540372670807	34	15	63.4	0	133	32	174	207	GKT30733.1 hypothetical protein ADUPG1_005616, partial [Aduncisulcus paluster]	diamond	102	42.4	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
27503055	27503055	PRJNA395690_P_NODE_19243_length_188_cov_1.834532_g19091_i0	PRJNA395690	19243	188	1.834532	3.44892016	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	61.2	1.54e-9	NR	XP_068360038.1	1144522	g19091	i0	49.2	8.56914893617021	61	31	97.3	0	187	5	117	177	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	1611	61.6	0.993506493506494	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
32463459	32463459	PRJNA395690_P_NODE_10699_length_249_cov_1.275000_g10547_i0	PRJNA395690	10699	249	1.275	3.17475	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	100	8.46e-25	NR	KAG9390573.1	201153	g10547	i0	73.9	4.97590361445783	69	17	83.1	1	42	248	59	126	KAG9390573.1 Ribosomal protein S11 [Carpediemonas membranifera]	diamond	1239	100	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);;