metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA474426" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA474426" 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
28481998	28481998	PRJNA474426_P_NODE_27926_length_183_cov_1.529851_g27721_i0	PRJNA474426	27926	183	1.529851	2.79962733	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	70.9	2.07e-12	NR	CDW78896.1	5949	g27721	i0	68.6	3.91803278688525	51	15	82	1	162	13	553	603	CDW78896.1 tubulin-tyrosine ligase family protein [Stylonychia lemnae]	diamond	717	71.6	0.990223463687151	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
29129127	29129127	PRJNA474426_P_NODE_11269_length_317_cov_2.376866_g11064_i0	PRJNA474426	11269	317	2.376866	7.53466522	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	96.3	9.7e-22	NR	CAI2378551.1	5936	g11064	i0	51.7	0.823343848580442	87	42	82.3	0	57	317	56	142	CAI2378551.1 unnamed protein product [Moneuplotes crassus]	diamond	261	96.3	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
29397594	29397594	PRJNA474426_P_NODE_34289_length_165_cov_0.887931_g34084_i0	PRJNA474426	34289	165	0.887931	1.46508615	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	42	0.0239	NR	CAD8051780.1	65129	g34084	i0	79.2	2.30909090909091	24	5	43.6	0	152	81	273	296	CAD8051780.1 unnamed protein product [Paramecium sonneborni]	diamond	381	42	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
29855193	29855193	PRJNA474426_P_NODE_15831_length_259_cov_1.152381_g15626_i0	PRJNA474426	15831	259	1.152381	2.98466679	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	114	1.33e-27	NR	CAD8206787.1	43137	g15626	i0	75.7	3.42857142857143	74	18	85.7	0	223	2	1	74	CAD8206787.1 unnamed protein product [Paramecium octaurelia]	diamond	888	114	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
30297903	30297903	PRJNA474426_P_NODE_11452_length_314_cov_2.116981_g11247_i0	PRJNA474426	11452	314	2.116981	6.64732034	Tetrahymena utriculariae	2486642	SAR_Eukaryotes	SAR_Eukaryotes	107	9.22e-25	NR	KAL4491372.1	2486642	g11247	i0	61.5	1.49044585987261	78	30	74.5	0	241	8	78	155	KAL4491372.1 hypothetical protein ABPG72_008028 [Tetrahymena utriculariae]	diamond	468	107	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena utriculariae
30581574	30581574	PRJNA474426_P_NODE_5773_length_450_cov_1.678304_g5571_i0	PRJNA474426	5773	450	1.678304	7.552368	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	84	2.8e-16	NR	XP_001460553.1	5888	g5571	i0	32.2	0.993333333333333	149	89	95.3	3	2	430	48	190	XP_001460553.1 uncharacterized protein GSPATT00004025001 [Paramecium tetraurelia]	diamond	447	84	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
32415956	32415956	PRJNA474426_P_NODE_12519_length_298_cov_1.642570_g12314_i0	PRJNA474426	12519	298	1.64257	4.8948586	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	82.8	6.43e-16	NR	CDW91214.1	5949	g12314	i0	69.8	1.08724832214765	53	16	53.4	0	244	86	3005	3057	CDW91214.1 dynein heavy chain axonemal [Stylonychia lemnae]	diamond	324	82.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);;