metadata: contig_metadata: 15 rows where bioproject = "PRJNA290839", tax_clade = "Sar" and tax

15 rows where bioproject = "PRJNA290839", 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
13126719	13126719	PRJNA290839_P_NODE_591_length_333_cov_1.196154_g570_i0	PRJNA290839	591	333	1.196154	3.98319282	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	483	9.389999999999999e-132	NTclustered	gi\|829187607\|ref\|XM_001011429.3\|	312017	g570	i0	95.96	6.8018018018018	297	12	89	0	1	297	297	1	Tetrahymena thermophila SB210 40S ribosomal protein S23 partial mRNA	blastn	2265	483	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
15675638	15675638	PRJNA290839_P_NODE_653_length_317_cov_1.135246_g632_i0	PRJNA290839	653	317	1.135246	3.59872982	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	339	2.0399999999999995e-88	NTclustered	gi\|829143070\|ref\|XM_001009843.3\|	312017	g632	i0	88.809	0.873817034700315	277	29	87	2	40	315	849	1124	Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA	blastn	277	339	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
27579637	27579637	PRJNA290839_P_NODE_1284_length_248_cov_0.885714_g1263_i0	PRJNA290839	1284	248	0.885714	2.19657072	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	91.7	2.3e-21	NR	XP_001011168.1	312017	g1263	i0	89.4	0.568548387096774	47	5	56.9	0	143	3	99	145	XP_001011168.1 EF-hand protein [Tetrahymena thermophila SB210]	diamond	141	91.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
28242589	28242589	PRJNA290839_P_NODE_1266_length_248_cov_0.891429_g1245_i0	PRJNA290839	1266	248	0.891429	2.21074392	Paramecium primaurelia	5886	SAR_Eukaryotes	SAR_Eukaryotes	51.2	3.97e-5	NR	CAD8042925.1	5886	g1245	i0	41.9	1.75403225806452	93	42	98	2	247	5	390	482	CAD8042925.1 unnamed protein product [Paramecium primaurelia]	diamond	435	51.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium primaurelia
29049845	29049845	PRJNA290839_P_NODE_1288_length_248_cov_0.885714_g1267_i0	PRJNA290839	1288	248	0.885714	2.19657072	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	78.6	4.53e-15	NR	XP_001014712.3	312017	g1267	i0	49.3	1.66935483870968	69	35	83.5	0	1	207	90	158	XP_001014712.3 RNA recognition motif protein [Tetrahymena thermophila SB210]	diamond	414	79	0.994936708860759	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29459872	29459872	PRJNA290839_P_NODE_290_length_497_cov_1.283019_g269_i0	PRJNA290839	290	497	1.283019	6.37660443	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	138	2.61e-35	NR	OMJ80348.1	5963	g269	i0	58.8	4.3943661971831	119	48	71.2	1	79	432	224	342	OMJ80348.1 hypothetical protein SteCoe_19390 [Stentor coeruleus]	diamond	2184	138	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
29554719	29554719	PRJNA290839_P_NODE_770_length_291_cov_1.403670_g749_i0	PRJNA290839	770	291	1.40367	4.0846797	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	63.2	4.5e-9	NR	XP_001020999.2	312017	g749	i0	37	2.92783505154639	92	53	90.7	3	27	290	472	562	XP_001020999.2 zinc finger lsd1 subclass family protein [Tetrahymena thermophila SB210]	diamond	852	63.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
30422128	30422128	PRJNA290839_P_NODE_1213_length_249_cov_0.886364_g1192_i0	PRJNA290839	1213	249	0.886364	2.20704636	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	80.1	1.89e-15	NR	KRX04487.1	266149	g1192	i0	43.9	0.987951807228916	82	46	98.8	0	1	246	280	361	KRX04487.1 hypothetical protein PPERSA_06040 [Pseudocohnilembus persalinus]	diamond	246	80.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
30800755	30800755	PRJNA290839_P_NODE_934_length_263_cov_1.215789_g913_i0	PRJNA290839	934	263	1.215789	3.19752507	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	130	8.100000000000001e-34	NR	XP_001018735.1	312017	g913	i0	89.6	0.76425855513308	67	7	76.4	0	1	201	369	435	XP_001018735.1 eukaryotic peptide chain release factor subunit 1 [Tetrahymena thermophila SB210]	diamond	201	130	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
30958946	30958946	PRJNA290839_P_NODE_754_length_294_cov_1.411765_g733_i0	PRJNA290839	754	294	1.411765	4.1505891	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	146	2.7e-42	NR	CAG9318382.1	1481888	g733	i0	73.2	0.989795918367347	97	25	98	1	5	292	4	100	CAG9318382.1 unnamed protein product [Blepharisma stoltei]	diamond	291	146	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
31464888	31464888	PRJNA290839_P_NODE_536_length_351_cov_1.122302_g515_i0	PRJNA290839	536	351	1.122302	3.93928002	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	167	1.7199999999999998e-48	NR	XP_001011149.1	312017	g515	i0	85	0.854700854700855	100	15	85.5	0	3	302	35	134	XP_001011149.1 zinc-binding dehydrogenase family oxidoreductase [Tetrahymena thermophila SB210]	diamond	300	167	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31685936	31685936	PRJNA290839_P_NODE_657_length_316_cov_1.271605_g636_i0	PRJNA290839	657	316	1.271605	4.0182718	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	55.5	2.96e-6	NR	XP_001030960.2	312017	g636	i0	64.1	0.370253164556962	39	14	37	0	221	105	783	821	XP_001030960.2 Serine/Threonine kinase [Tetrahymena thermophila SB210]	diamond	117	55.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
32065612	32065612	PRJNA290839_P_NODE_1218_length_249_cov_0.886364_g1197_i0	PRJNA290839	1218	249	0.886364	2.20704636	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	47.8	7.32e-4	NR	KAL4453750.1	5901	g1197	i0	52.5	0.963855421686747	40	19	48.2	0	120	1	2881	2920	KAL4453750.1 hypothetical protein ABPG74_009646 [Tetrahymena malaccensis]	diamond	240	47.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
32445625	32445625	PRJNA290839_P_NODE_1639_length_242_cov_0.917160_g1618_i0	PRJNA290839	1639	242	0.91716	2.2195272	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	134	2.06e-34	NR	XP_001030002.1	312017	g1618	i0	79.7	0.91735537190082606	74	15	91.7	0	241	20	173	246	XP_001030002.1 transmembrane protein, putative [Tetrahymena thermophila SB210]	diamond	222	134	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
32666334	32666334	PRJNA290839_P_NODE_1020_length_253_cov_0.866667_g999_i0	PRJNA290839	1020	253	0.866667	2.19266751	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	129	1.74e-33	NR	KRX11177.1	266149	g999	i0	73.8	0.99604743083004	84	22	99.6	0	252	1	300	383	KRX11177.1 WD40-repeat-containing domain [Pseudocohnilembus persalinus]	diamond	252	129	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus

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