metadata: contig_metadata: 6 rows where bioproject = "PRJNA493244", tax_clade = "Metamonada" and tax

6 rows where bioproject = "PRJNA493244", 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
457668	457668	PRJNA493244_P_NODE_853381_length_477_cov_13.156250_g830528_i0	PRJNA493244	853381	477	13.15625	62.7553125	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	222	2.11e-68	NR	KAJ3448950.1	1746091	g830528	i0	83.3	1.66037735849057	132	22	83	0	23	418	269	400	KAJ3448950.1 hypothetical protein M0812_01438 [Anaeramoeba flamelloides]	diamond	792	222	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
19581088	19581088	PRJNA493244_P_NODE_1241756_length_315_cov_1.649606_g1218632_i0	PRJNA493244	1241756	315	1.649606	5.1962589	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	52.8	0.029	NTclustered	gi\|2794891824\|ref\|XM_067908299.1\|	348837	g1218632	i0	85.185	0.17142857142857101	54	5	17	3	241	294	1473	1423	Spironucleus salmonicida Inositol-hexakisphosphate/diphosphoinositol-pentakisphosphate 1-kinase (SS50377_24458), partial mRNA	blastn	54	52.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
29160948	29160948	PRJNA493244_P_NODE_367929_length_879_cov_1.650367_g350504_i0	PRJNA493244	367929	879	1.650367	14.50672593	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	161	1.0499999999999998e-41	NR	GKT33306.1	2918883	g350504	i0	36.3	1.58703071672355	234	141	79.2	4	841	146	190	417	GKT33306.1 DDE-type integrase/transposase/recombinase, partial [Aduncisulcus paluster]	diamond	1395	161	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
29760449	29760449	PRJNA493244_P_NODE_1718391_length_201_cov_7.614286_g1695266_i0	PRJNA493244	1718391	201	7.614286	15.30471486	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	53.5	1.67e-6	NR	KAA6397624.1	222440	g1695266	i0	75.9	0.43283582089552203	29	7	43.3	0	73	159	126	154	KAA6397624.1 MAG: hypothetical protein EZS28_006851 [Streblomastix strix]	diamond	87	53.5	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
30455991	30455991	PRJNA493244_P_NODE_1448793_length_255_cov_2.762887_g1425668_i0	PRJNA493244	1448793	255	2.762887	7.04536185	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	53.9	5.04e-6	NR	XP_067778113.1	135588	g1425668	i0	52.2	0.541176470588235	46	22	54.1	0	114	251	84	129	XP_067778113.1 CAMK family protein kinase [Histomonas meleagridis]	diamond	138	53.9	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
31118831	31118831	PRJNA493244_P_NODE_1607695_length_219_cov_1.215190_g1584570_i0	PRJNA493244	1607695	219	1.21519	2.6612661	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	53.5	4.06e-6	NR	KAJ3435200.1	1746091	g1584570	i0	47.6	0.575342465753425	42	21	56.2	1	3	125	340	381	KAJ3435200.1 lysophosphatidic acid phosphatase type [Anaeramoeba flamelloides]	diamond	126	53.5	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides

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