metadata: contig_metadata: 10 rows where bioproject = "PRJNA352610" and tax

10 rows where bioproject = "PRJNA352610" 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
26694826	26694826	PRJNA352610_P_NODE_32001_length_241_cov_0.916667_g31940_i0	PRJNA352610	32001	241	0.916667	2.20916747	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	64.7	6.78e-10	NR	CDW87295.1	5949	g31940	i0	38.3	5.850622406639	81	48	98.3	1	5	241	745	825	CDW87295.1 nucleolar rna helicase 2 [Stylonychia lemnae]	diamond	1410	64.7	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
27201033	27201033	PRJNA352610_P_NODE_8502_length_392_cov_1.097179_g8441_i0	PRJNA352610	8502	392	1.097179	4.30094168	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	70.9	1.98e-11	NR	KAL4462567.1	5901	g8441	i0	39.3	7.36224489795918	89	50	65.8	2	67	324	122	209	KAL4462567.1 hypothetical protein ABPG74_000397 [Tetrahymena malaccensis]	diamond	2886	70.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
27327736	27327736	PRJNA352610_P_NODE_19623_length_283_cov_1.276190_g19562_i0	PRJNA352610	19623	283	1.27619	3.6116177	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	51.6	1.57e-5	NR	CAG9330569.1	1481888	g19562	i0	63.3	0.318021201413428	30	11	31.8	0	65	154	4	33	CAG9330569.1 unnamed protein product [Blepharisma stoltei]	diamond	90	51.6	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
29632272	29632272	PRJNA352610_P_NODE_4610_length_496_cov_0.903073_g4549_i0	PRJNA352610	4610	496	0.903073	4.47924208	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	80.1	3.94e-14	NR	CDW83009.1	5949	g4549	i0	33.6	0.828629032258065	137	85	80.4	4	22	420	204	338	CDW83009.1 fbox domain containing protein [Stylonychia lemnae]	diamond	411	80.1	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
30011767	30011767	PRJNA352610_P_NODE_6591_length_432_cov_1.047354_g6530_i0	PRJNA352610	6591	432	1.047354	4.52456928	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	64.7	6.46e-9	NR	CAG9333893.1	1481888	g6530	i0	39.1	0.604166666666667	87	53	60.4	0	264	4	718	804	CAG9333893.1 unnamed protein product [Blepharisma stoltei]	diamond	261	64.7	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
30770017	30770017	PRJNA352610_P_NODE_25954_length_250_cov_0.870056_g25893_i0	PRJNA352610	25954	250	0.870056	2.17514	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	47.8	6.89e-4	NR	KAL4468966.1	5901	g25893	i0	32.5	1.86	77	47	91.2	2	241	14	278	350	KAL4468966.1 hypothetical protein ABPG73_019734 [Tetrahymena malaccensis]	diamond	465	47.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
31165909	31165909	PRJNA352610_P_NODE_995_length_864_cov_3.194690_g951_i0	PRJNA352610	995	864	3.19469	27.6021216	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	70.5	2.12e-9	NR	KAL4454048.1	5901	g951	i0	26.6	4.59722222222222	301	172	92.4	14	806	9	2157	2443	KAL4454048.1 hypothetical protein ABPG73_009847 [Tetrahymena malaccensis]	diamond	3972	70.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
31433556	31433556	PRJNA352610_P_NODE_30836_length_242_cov_1.366864_g30775_i0	PRJNA352610	30836	242	1.366864	3.30781088	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	73.2	4.46e-14	NR	KRW98677.1	266149	g30775	i0	41.8	0.979338842975207	79	42	93	1	242	18	73	151	KRW98677.1 Endonuclease/exonuclease/phosphatase [Pseudocohnilembus persalinus]	diamond	237	73.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
32841419	32841419	PRJNA352610_P_NODE_20480_length_278_cov_0.995122_g20419_i0	PRJNA352610	20480	278	0.995122	2.76643916	root	1	Root_unresolved	Root_unresolved	62.4	6.5e-9	NR	CAG9318571.1	1481888	g20419	i0	50	2.75179856115108	62	24	59.4	2	166	2	146	207	CAG9318571.1 unnamed protein product [Blepharisma stoltei]	diamond	765	62.4	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
32887226	32887226	PRJNA352610_P_NODE_27860_length_247_cov_0.885057_g27799_i0	PRJNA352610	27860	247	0.885057	2.18609079	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	95.9	1.9900000000000003e-21	NR	CAI2375377.1	5936	g27799	i0	63.5	0.898785425101215	74	27	89.9	0	224	3	106	179	CAI2375377.1 unnamed protein product [Moneuplotes crassus]	diamond	222	95.9	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus

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