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

6 rows where analysis = "diamond", bioproject = "PRJNA1226487" 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
27830820	27830820	PRJNA1226487_P_NODE_74984_length_243_cov_1.811765_g74882_i0	PRJNA1226487	74984	243	1.811765	4.40258895	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	78.6	9.43e-15	NR	CDW83970.1	5949	g74882	i0	66.1	0.691358024691358	56	19	69.1	0	1	168	210	265	CDW83970.1 snf2 family dna-dependent atpase [Stylonychia lemnae]	diamond	168	78.6	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
28083371	28083371	PRJNA1226487_P_NODE_81465_length_227_cov_3.961039_g81363_i0	PRJNA1226487	81465	227	3.961039	8.99155853	Paramecium sonneborni	65129	SAR_Eukaryotes	SAR_Eukaryotes	57.4	2.09e-7	NR	CAD8058350.1	65129	g81363	i0	39.1	1.62555066079295	64	39	84.6	0	9	200	806	869	CAD8058350.1 unnamed protein product [Paramecium sonneborni]	diamond	369	57.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
28133935	28133935	PRJNA1226487_P_NODE_4065_length_597_cov_7.368321_g3973_i0	PRJNA1226487	4065	597	7.368321	43.98887637	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	152	1.51e-43	NR	CAD8061965.1	5886	g3973	i0	60.2	2.47738693467337	128	49	63.3	1	40	417	1	128	CAD8061965.1 unnamed protein product [Paramecium primaurelia]	diamond	1479	153	0.993464052287582	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium primaurelia
28430883	28430883	PRJNA1226487_P_NODE_43306_length_283_cov_1.466667_g43204_i0	PRJNA1226487	43306	283	1.466667	4.15066761	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	135	2.26e-34	NR	CDW75137.1	5949	g43204	i0	77.7	0.996466431095406	94	21	99.6	0	282	1	1843	1936	CDW75137.1 dynein heavy chain axonemal [Stylonychia lemnae]	diamond	282	135	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
30389121	30389121	PRJNA1226487_P_NODE_73633_length_244_cov_1.801170_g73531_i0	PRJNA1226487	73633	244	1.80117	4.3948548	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	80.9	1.41e-15	NR	CDW86533.1	5949	g73531	i0	71.2	0.639344262295082	52	15	63.9	0	242	87	3390	3441	CDW86533.1 UNKNOWN [Stylonychia lemnae]	diamond	156	80.9	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
31400122	31400122	PRJNA1226487_P_NODE_49096_length_274_cov_1.532338_g48994_i0	PRJNA1226487	49096	274	1.532338	4.19860612	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	52.8	1.62e-5	NR	CDW84829.1	5949	g48994	i0	63.2	0.416058394160584	38	14	41.6	0	18	131	147	184	CDW84829.1 UNKNOWN [Stylonychia lemnae]	diamond	114	52.8	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae

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