metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA904835" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA904835" and tax_phylum = "Ciliophora"

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_class	tax_order	tax_family	tax_genus	tax_species
7625549	7625549	PRJNA904835_P_NODE_46486_length_269_cov_1.515306_g46230_i0	PRJNA904835	46486	269	1.515306	4.07617314	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	120	1.91e-29	NR	XP_004039325.1	5932	g46230	i0	62.5	7.6728624535316	88	33	98.1	0	1	264	326	413	XP_004039325.1 papain family cysteine protease, putative [Ichthyophthirius multifiliis]	diamond	2064	120	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
14910966	14910966	PRJNA904835_P_NODE_34872_length_328_cov_0.905882_g34616_i0	PRJNA904835	34872	328	0.905882	2.97129296	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	134	2.99e-37	NR	XP_004034912.1	5932	g34616	i0	60.6	3.71341463414634	104	40	95.1	1	313	2	2	104	XP_004034912.1 hypothetical protein IMG5_109970 [Ichthyophthirius multifiliis]	diamond	1218	134	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
17461756	17461756	PRJNA904835_P_NODE_51614_length_250_cov_0.870056_g51358_i0	PRJNA904835	51614	250	0.870056	2.17514	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	127	2.59e-32	NR	XP_001024675.2	312017	g51358	i0	68.7	1.992	83	26	99.6	0	2	250	230	312	XP_001024675.2 aspartyl-tRNA synthetase protein [Tetrahymena thermophila SB210]	diamond	498	127	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
28635209	28635209	PRJNA904835_P_NODE_8587_length_736_cov_1.613876_g8357_i0	PRJNA904835	8587	736	1.613876	11.87812736	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	76.3	2.9e-13	NR	CDW86772.1	5949	g8357	i0	42.6	0.525815217391304	129	65	50.5	5	654	283	15	139	CDW86772.1 UNKNOWN [Stylonychia lemnae]	diamond	387	76.3	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
28950895	28950895	PRJNA904835_P_NODE_56548_length_244_cov_0.900585_g56292_i0	PRJNA904835	56548	244	0.900585	2.1974274	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	108	2.54e-25	NR	XP_004040108.1	5932	g56292	i0	62	1.94262295081967	79	30	97.1	0	239	3	108	186	XP_004040108.1 hypothetical protein IMG5_001810 [Ichthyophthirius multifiliis]	diamond	474	108	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
30537388	30537388	PRJNA904835_P_NODE_44513_length_278_cov_1.497561_g44257_i0	PRJNA904835	44513	278	1.497561	4.16321958	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	130	7.21e-35	NR	CAD8077690.1	5886	g44257	i0	67.8	3.82014388489209	90	29	97.1	0	273	4	147	236	CAD8077690.1 unnamed protein product [Paramecium primaurelia]	diamond	1062	130	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium primaurelia

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