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

10 rows where bioproject = "PRJNA1108487", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"

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_order	tax_family	tax_genus	tax_species
213446	213446	PRJNA1108487_P_NODE_9581_length_248_cov_0.891429_g9515_i0	PRJNA1108487	9581	248	0.891429	2.21074392	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	63.9	1.04e-5	NTclustered	gi\|294886904\|ref\|XM_002771866.1\|	423536	g9515	i0	97.297	0.262096774193548	37	1	15	0	42	78	1883	1919	Perkinsus marinus ATCC 50983 protein arginine n-methyltransferase, putative, mRNA	blastn	65	63.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
6591511	6591511	PRJNA1108487_P_NODE_2266_length_450_cov_3.015915_g2200_i0	PRJNA1108487	2266	450	3.015915	13.5716175	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	211	7.379999999999999e-67	NR	XP_002778466.1	423536	g2200	i0	76.3	0.9	135	32	90	0	406	2	1	135	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	405	211	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
11692118	11692118	PRJNA1108487_P_NODE_6050_length_291_cov_1.220183_g5984_i0	PRJNA1108487	6050	291	1.220183	3.55073253	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	156	1.01e-44	NR	XP_002774056.1	423536	g5984	i0	78.4	1	97	21	100	0	291	1	188	284	XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	291	156	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
21890227	21890227	PRJNA1108487_P_NODE_1258_length_591_cov_9.851351_g1193_i0	PRJNA1108487	1258	591	9.851351	58.22148441	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	313	2.43e-80	NTclustered	gi\|294891115\|ref\|XM_002773382.1\|	423536	g1193	i0	82.432	64.6142131979695	370	53	62	12	132	495	438	75	Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA	blastn	38187	313	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
26615722	26615722	PRJNA1108487_P_NODE_7201_length_270_cov_1.182741_g7135_i0	PRJNA1108487	7201	270	1.182741	3.1934007	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	124	1.08e-30	NR	KAF4651834.1	32597	g7135	i0	59.8	8.76666666666667	87	35	96.7	0	8	268	276	362	KAF4651834.1 ubiquitin-conjugating enzyme E2 K [Perkinsus olseni]	diamond	2367	125	0.992	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28615272	28615272	PRJNA1108487_P_NODE_2667_length_415_cov_2.590643_g2601_i0	PRJNA1108487	2667	415	2.590643	10.75116845	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	196	4.06e-61	NR	XP_002778466.1	423536	g2601	i0	71.8	0.946987951807229	131	37	94.7	0	394	2	5	135	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	393	196	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30384094	30384094	PRJNA1108487_P_NODE_5873_length_294_cov_2.683258_g5807_i0	PRJNA1108487	5873	294	2.683258	7.88877852	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	47.4	0.00141	NR	XP_002788164.1	423536	g5807	i0	64.5	0.316326530612245	31	11	31.6	0	293	201	246	276	XP_002788164.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	93	47.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
32335518	32335518	PRJNA1108487_P_NODE_4199_length_339_cov_1.172932_g4133_i0	PRJNA1108487	4199	339	1.172932	3.97623948	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	114	5.520000000000001e-27	NR	KAF4758630.1	32597	g4133	i0	64.9	10.716814159292	97	27	79.6	1	338	69	440	536	KAF4758630.1 heat shock protein 90, partial [Perkinsus olseni]	diamond	3633	114	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32493666	32493666	PRJNA1108487_P_NODE_8159_length_255_cov_1.285714_g8093_i0	PRJNA1108487	8159	255	1.285714	3.2785707	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	70.9	5.25e-12	NR	KAF4717748.1	32597	g8093	i0	47.6	2.96470588235294	84	44	98.8	0	253	2	206	289	KAF4717748.1 hypothetical protein FOZ62_002431, partial [Perkinsus olseni]	diamond	756	70.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32659697	32659697	PRJNA1108487_P_NODE_2840_length_402_cov_2.732523_g2774_i0	PRJNA1108487	2840	402	2.732523	10.98474246	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	172	9.319999999999999e-47	NR	KAF4675435.1	330153	g2774	i0	61.9	9	134	50	99.3	1	3	401	1732	1865	KAF4675435.1 hypothetical protein FOL47_007743 [Perkinsus chesapeaki]	diamond	3618	172	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki

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