metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA771359" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA771359" 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
27053363	27053363	PRJNA771359_S_NODE_1642_length_264_cov_1.894273_g1559_i0	PRJNA771359	1642	264	1.894273	5.00088072	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	64.3	3.1e-11	NR	XP_012651983.1	312017	g1559	i0	50.7	0.806818181818182	71	35	80.7	0	6	218	15	85	XP_012651983.1 hypothetical protein TTHERM_000784569 [Tetrahymena thermophila SB210]	diamond	213	64.3	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
27189140	27189140	PRJNA771359_S_NODE_3782_length_173_cov_1.419118_g3699_i0	PRJNA771359	3782	173	1.419118	2.45507414	Tetrahymenidae	291294	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00221	NR	NP_049598.1	5908	g3699	i0	81.8	0.763005780346821	22	4	38.2	0	172	107	185	206	NP_049598.1 apocytochrome b [Tetrahymena pyriformis]	diamond	132	45.4	0.993392070484582	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
27685426	27685426	PRJNA771359_S_NODE_2384_length_217_cov_1.577778_g2301_i0	PRJNA771359	2384	217	1.577778	3.42377826	Paramecium pentaurelia	43138	SAR_Eukaryotes	SAR_Eukaryotes	68.6	2.59e-12	NR	CAD8155930.1	43138	g2301	i0	55.4	0.898617511520737	65	28	89.9	1	215	21	16	79	CAD8155930.1 unnamed protein product [Paramecium pentaurelia]	diamond	195	68.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium pentaurelia
28158966	28158966	PRJNA771359_S_NODE_4145_length_166_cov_1.744186_g4062_i0	PRJNA771359	4145	166	1.744186	2.89534876	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	93.6	2.62e-22	NR	CAG9318382.1	1481888	g4062	i0	75.9	0.975903614457831	54	13	97.6	0	162	1	52	105	CAG9318382.1 unnamed protein product [Blepharisma stoltei]	diamond	162	93.6	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
28853151	28853151	PRJNA771359_S_NODE_2668_length_205_cov_1.428571_g2585_i0	PRJNA771359	2668	205	1.428571	2.92857055	Paramecium sonneborni	65129	SAR_Eukaryotes	SAR_Eukaryotes	65.9	1.21e-10	NR	CAD8069000.1	65129	g2585	i0	61.9	2.75121951219512	63	24	92.2	0	204	16	250	312	CAD8069000.1 unnamed protein product [Paramecium sonneborni]	diamond	564	65.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
28979834	28979834	PRJNA771359_S_NODE_4268_length_164_cov_1.204724_g4185_i0	PRJNA771359	4268	164	1.204724	1.97574736	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00145	NR	CAD8135162.1	43137	g4185	i0	38.5	0.951219512195122	52	30	95.1	1	2	157	736	785	CAD8135162.1 unnamed protein product [Paramecium octaurelia]	diamond	156	45.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
29074573	29074573	PRJNA771359_S_NODE_3228_length_187_cov_1.033333_g3145_i0	PRJNA771359	3228	187	1.033333	1.93233271	Thuricola similis	2784598	SAR_Eukaryotes	SAR_Eukaryotes	78.2	5.5e-15	NR	YP_010147331.1	2784598	g3145	i0	83.3	0.770053475935829	48	8	77	0	3	146	335	382	YP_010147331.1 cytochrome c oxidase subunit 1 [Thuricola similis]	diamond	144	78.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vaginicolidae	Thuricola	Thuricola similis
29494405	29494405	PRJNA771359_S_NODE_3450_length_181_cov_1.340278_g3367_i0	PRJNA771359	3450	181	1.340278	2.42590318	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	40.8	0.0283	NR	XP_012652362.1	312017	g3367	i0	56.8	1.83977900552486	37	16	61.3	0	137	27	17	53	XP_012652362.1 hypothetical protein TTHERM_000294739 [Tetrahymena thermophila SB210]	diamond	333	40.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29999817	29999817	PRJNA771359_S_NODE_4271_length_164_cov_1.181102_g4188_i0	PRJNA771359	4271	164	1.181102	1.93700728	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	59.7	1.16e-8	NR	CAD8084070.1	65129	g4188	i0	52.9	15.1646341463415	51	24	93.3	0	164	12	206	256	CAD8084070.1 unnamed protein product [Paramecium sonneborni]	diamond	2487	60.1	0.993344425956739	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
30401312	30401312	PRJNA771359_S_NODE_3453_length_181_cov_1.340278_g3370_i0	PRJNA771359	3453	181	1.340278	2.42590318	Paramecium primaurelia	5886	SAR_Eukaryotes	SAR_Eukaryotes	71.6	1.06e-12	NR	CAD8044685.1	5886	g3370	i0	61.8	1.8232044198895	55	21	91.2	0	180	16	214	268	CAD8044685.1 unnamed protein product, partial [Paramecium primaurelia]	diamond	330	71.6	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);;