metadata: contig_metadata: 6 rows where bioproject = "PRJEB58983" and tax

6 rows where bioproject = "PRJEB58983" and tax_clade = "Metamonada"

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
5227667	5227667	PRJEB58983_P_NODE_34305_length_229_cov_3.602564_g33890_i0	PRJEB58983	34305	229	3.602564	8.24987156	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	172	1.5e-38	NTclustered	gi\|339759369\|dbj\|AB600297.1\|	201153	g33890	i0	80.531	36.3187772925764	226	42	98	2	5	229	235	11	Carpediemonas membranifera hsp90 gene for heat shock protein 90, partial cds, strain: BICM	blastn	8317	172	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
26843884	26843884	PRJEB58983_P_NODE_10141_length_392_cov_4.514107_g9726_i0	PRJEB58983	10141	392	4.514107	17.69529944	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	83.2	1.1e-17	NR	KAJ4453711.1	342808	g9726	i0	46	0.864795918367347	113	56	83.4	2	363	37	2	113	KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis]	diamond	339	83.2	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
27475997	27475997	PRJEB58983_P_NODE_29423_length_249_cov_0.886364_g29008_i0	PRJEB58983	29423	249	0.886364	2.20704636	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	99.8	4e-23	NR	XP_067725136.1	2049356	g29008	i0	56.1	0.987951807228916	82	36	98.8	0	2	247	30	111	XP_067725136.1 putative CMGC/CDK protein kinase [Monocercomonoides exilis]	diamond	246	99.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
29149836	29149836	PRJEB58983_P_NODE_11109_length_377_cov_2.440789_g10694_i0	PRJEB58983	11109	377	2.440789	9.20177453	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	157	6.65e-46	NR	XP_068360038.1	1144522	g10694	i0	60.8	0.994694960212202	125	49	99.5	0	377	3	5	129	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	375	157	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
29395276	29395276	PRJEB58983_P_NODE_24129_length_269_cov_1.591837_g23714_i0	PRJEB58983	24129	269	1.591837	4.28204153	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	81.6	5.96e-16	NR	XP_068368100.1	1144522	g23714	i0	44.2	12.2676579925651	86	48	95.9	0	11	268	7	92	XP_068368100.1 CMGC family protein kinase [Tritrichomonas foetus]	diamond	3300	81.6	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
30444469	30444469	PRJEB58983_P_NODE_11253_length_375_cov_2.314570_g10838_i0	PRJEB58983	11253	375	2.31457	8.6796375	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	94	6.72e-21	NR	XP_067768105.1	348837	g10838	i0	41.6	0.904	113	65	89.6	1	29	364	22	134	XP_067768105.1 Ribosomal protein L10a [Spironucleus salmonicida]	diamond	339	94	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);;