metadata: contig_metadata: 9 rows where bioproject = "PRJNA857143", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA857143", 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
21245701	21245701	PRJNA857143_S_NODE_178917_length_249_cov_0.886364_g177824_i0	PRJNA857143	178917	249	0.886364	2.20704636	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	93.6	7.34e-22	NR	KAF4680316.1	32597	g177824	i0	90.2	3.07228915662651	51	5	61.4	0	249	97	122	172	KAF4680316.1 26S protease regulatory subunit 10B [Perkinsus olseni]	diamond	765	93.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
22912978	22912978	PRJNA857143_S_NODE_200578_length_227_cov_7.759740_g199485_i0	PRJNA857143	200578	227	7.75974	17.6146098	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	115	1.64e-31	NR	XP_002781799.1	423536	g199485	i0	58.1	5.8942731277533	74	31	97.8	0	3	224	14	87	XP_002781799.1 cysteine protease Cys2, putative [Perkinsus marinus ATCC 50983]	diamond	1338	115	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
26611710	26611710	PRJNA857143_S_NODE_33441_length_449_cov_5.521277_g32349_i0	PRJNA857143	33441	449	5.521277	24.79053373	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	75.9	2.67e-13	NR	TEB19254.1	2494336	g32349	i0	44	0.66815144766147	100	51	66.1	3	449	153	168	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	300	75.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
27537238	27537238	PRJNA857143_S_NODE_34183_length_446_cov_3.080429_g33091_i0	PRJNA857143	34183	446	3.080429	13.73871334	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	97.8	1.12e-20	NR	KAF4734529.1	32597	g33091	i0	69.9	2.50896860986547	73	21	48.4	1	417	202	363	435	KAF4734529.1 hypothetical protein FOZ63_018977 [Perkinsus olseni]	diamond	1119	97.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27979223	27979223	PRJNA857143_S_NODE_170625_length_252_cov_1.737430_g169532_i0	PRJNA857143	170625	252	1.73743	4.3783236	Phaeophyceae	2870	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.00132	NR	XP_002765022.1	423536	g169532	i0	72	1.1547619047619	25	7	29.8	0	252	178	90	114	XP_002765022.1 hypothetical protein Pmar_PMAR004478, partial [Perkinsus marinus ATCC 50983]	diamond	291	46.2	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
27979227	27979227	PRJNA857143_S_NODE_186625_length_245_cov_1.813953_g185532_i0	PRJNA857143	186625	245	1.813953	4.44418485	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	68.9	7.36e-12	NR	KAF4714106.1	32597	g185532	i0	50	2.27755102040816	62	31	75.9	0	245	60	173	234	KAF4714106.1 hypothetical protein FOZ63_008129 [Perkinsus olseni]	diamond	558	68.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30212908	30212908	PRJNA857143_S_NODE_135772_length_278_cov_1.521951_g134679_i0	PRJNA857143	135772	278	1.521951	4.23102378	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	133	6.11e-37	NR	TEB18751.1	2494336	g134679	i0	74.1	0.87410071942446	81	21	87.4	0	276	34	120	200	TEB18751.1 40s ribosomal protein S7 [Perkinsus sp. BL_2016]	diamond	243	133	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
31350749	31350749	PRJNA857143_S_NODE_80796_length_337_cov_3.962121_g79703_i0	PRJNA857143	80796	337	3.962121	13.35234777	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0397	NR	XP_002788193.1	423536	g79703	i0	45.7	0.311572700296736	35	19	31.2	0	304	200	57	91	XP_002788193.1 hypothetical protein Pmar_PMAR006885 [Perkinsus marinus ATCC 50983]	diamond	105	42.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31888257	31888257	PRJNA857143_S_NODE_51117_length_393_cov_2.762500_g50024_i0	PRJNA857143	51117	393	2.7625	10.856625	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	72	1.15e-11	NR	KAF4690127.1	32597	g50024	i0	63.5	1.58778625954198	52	19	39.7	0	1	156	629	680	KAF4690127.1 hypothetical protein FOZ60_000583 [Perkinsus olseni]	diamond	624	72	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni

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