metadata: contig_metadata: 10 rows where bioproject = "PRJNA1136505", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA1136505", tax_clade = "Sar" 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
9212533	9212533	PRJNA1136505_P_NODE_87748_length_310_cov_1.223629_g80888_i0	PRJNA1136505	87748	310	1.223629	3.7932499	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	73.9	9e-13	NR	CAG9331851.1	1481888	g80888	i0	40.2	2.02258064516129	102	39	98.7	2	308	3	137	216	CAG9331851.1 unnamed protein product [Blepharisma stoltei]	diamond	627	73.9	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
18136174	18136174	PRJNA1136505_P_NODE_117155_length_266_cov_1.595855_g110295_i0	PRJNA1136505	117155	266	1.595855	4.2449743	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	94.7	2.4e-20	NR	KRX07276.1	266149	g110295	i0	75	9.28195488721805	56	13	62	1	167	3	11	66	KRX07276.1 Succinyl-CoA synthetase-like protein [Pseudocohnilembus persalinus]	diamond	2469	95.1	0.995793901156677	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
18136248	18136248	PRJNA1136505_P_NODE_72995_length_344_cov_1.918819_g66135_i0	PRJNA1136505	72995	344	1.918819	6.60073736	Paramecium	5884	SAR_Eukaryotes	SAR_Eukaryotes	109	4.99e-25	NR	CAD8160439.1	43137	g66135	i0	51.6	2.45058139534884	91	44	79.4	0	59	331	62	152	CAD8160439.1 unnamed protein product [Paramecium octaurelia]	diamond	843	109	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
27133212	27133212	PRJNA1136505_P_NODE_23942_length_913_cov_2.259524_g17580_i0	PRJNA1136505	23942	913	2.259524	20.62945412	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	162	7.2e-41	NR	CDW87873.1	5949	g17580	i0	34.6	1.68893756845564	257	158	82.8	6	768	13	722	973	CDW87873.1 UNKNOWN [Stylonychia lemnae]	diamond	1542	162	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
28543988	28543988	PRJNA1136505_P_NODE_105527_length_281_cov_1.365385_g98667_i0	PRJNA1136505	105527	281	1.365385	3.83673185	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	67.4	2.41e-11	NR	XP_001022414.2	312017	g98667	i0	47.1	2.18861209964413	68	36	72.6	0	252	49	95	162	XP_001022414.2 small guanosine triphosphatase family (GTPase)-like Ras family protein [Tetrahymena thermophila SB210]	diamond	615	67.8	0.994100294985251	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29470025	29470025	PRJNA1136505_P_NODE_88230_length_309_cov_1.305085_g81370_i0	PRJNA1136505	88230	309	1.305085	4.03271265	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	92	8.42e-20	NR	CAG9332919.1	1481888	g81370	i0	44.6	1.90291262135922	101	56	98.1	0	306	4	44	144	CAG9332919.1 unnamed protein product [Blepharisma stoltei]	diamond	588	92	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
30355244	30355244	PRJNA1136505_P_NODE_53752_length_420_cov_1.573487_g46893_i0	PRJNA1136505	53752	420	1.573487	6.6086454	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	73.2	4.6e-12	NR	CAG9313904.1	1481888	g46893	i0	50	1.34285714285714	86	38	61.4	1	162	419	21	101	CAG9313904.1 unnamed protein product [Blepharisma stoltei]	diamond	564	73.2	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
30860277	30860277	PRJNA1136505_P_NODE_155094_length_241_cov_0.916667_g148234_i0	PRJNA1136505	155094	241	0.916667	2.20916747	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	72.4	1.09e-12	NR	CAG9329454.1	1481888	g148234	i0	41	0.970954356846473	78	44	94.6	1	229	2	264	341	CAG9329454.1 unnamed protein product [Blepharisma stoltei]	diamond	234	72.4	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
31524224	31524224	PRJNA1136505_P_NODE_48716_length_452_cov_1.656992_g41857_i0	PRJNA1136505	48716	452	1.656992	7.48960384	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	56.6	6.95e-7	NR	KRX01051.1	266149	g41857	i0	33.6	1.73230088495575	119	70	76.3	4	352	8	1	114	KRX01051.1 Profilin [Pseudocohnilembus persalinus]	diamond	783	56.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
32399071	32399071	PRJNA1136505_P_NODE_77219_length_333_cov_3.850000_g70359_i0	PRJNA1136505	77219	333	3.85	12.8205	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	135	9.149999999999999e-39	NR	CDW83169.1	5949	g70359	i0	70.4	11.7837837837838	98	29	88.3	0	298	5	8	105	CDW83169.1 UNKNOWN [Stylonychia lemnae]	diamond	3924	135	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);;