metadata: contig_metadata: 12 rows where bioproject = "PRJNA421571", tax_clade = "Sar" and tax

12 rows where bioproject = "PRJNA421571", 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
1085856	1085856	PRJNA421571_P_NODE_51021_length_384_cov_1.282958_g48473_i0	PRJNA421571	51021	384	1.282958	4.92655872	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	167	9.12e-46	NR	KAF4681143.1	32597	g48473	i0	61.8	6.7421875	123	46	95.3	1	5	370	280	402	KAF4681143.1 Ca(2+)-dependent cysteine protease [Perkinsus olseni]	diamond	2589	167	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
24648941	24648941	PRJNA421571_P_NODE_29120_length_603_cov_4.100000_g26603_i0	PRJNA421571	29120	603	4.1	24.723	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	228	1.09e-72	NR	XP_002778466.1	423536	g26603	i0	62.2	0.895522388059702	180	62	86.6	3	601	80	11	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	540	228	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
26949005	26949005	PRJNA421571_P_NODE_68942_length_307_cov_1.316239_g66393_i0	PRJNA421571	68942	307	1.316239	4.04085373	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	72	3.98e-12	NR	KAF4704420.1	32597	g66393	i0	42.7	2.00325732899023	103	49	98.7	4	4	306	86	180	KAF4704420.1 hypothetical protein FOZ62_026523 [Perkinsus olseni]	diamond	615	72	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28797327	28797327	PRJNA421571_P_NODE_57827_length_348_cov_3.072727_g55278_i0	PRJNA421571	57827	348	3.072727	10.69308996	Viridiplantae	33090	SAR_Eukaryotes	SAR_Eukaryotes	145	1.7899999999999996e-38	NR	KAF4745133.1	32597	g55278	i0	62.4	14.0258620689655	117	40	100	2	1	348	302	415	KAF4745133.1 Long-chain-fatty-acid--CoA ligase 3 [Perkinsus olseni]	diamond	4881	146	0.993150684931507	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28970451	28970451	PRJNA421571_P_NODE_40448_length_462_cov_2.645244_g37900_i0	PRJNA421571	40448	462	2.645244	12.22102728	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	80.5	7.03e-16	NR	XP_002784356.1	423536	g37900	i0	31.8	3.38311688311688	129	88	83.8	0	63	449	19	147	XP_002784356.1 ubiquitin, putative [Perkinsus marinus ATCC 50983]	diamond	1563	80.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29555150	29555150	PRJNA421571_P_NODE_98070_length_247_cov_0.885057_g95521_i0	PRJNA421571	98070	247	0.885057	2.18609079	Dinophyceae	2864	SAR_Eukaryotes	SAR_Eukaryotes	89.7	1.22e-19	NR	KAF4750808.1	32597	g95521	i0	53.8	10.5546558704453	78	31	93.5	2	239	9	45	118	KAF4750808.1 ATP-dependent helicase NAM7, partial [Perkinsus olseni]	diamond	2607	90.1	0.995560488346282	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30265547	30265547	PRJNA421571_P_NODE_84832_length_266_cov_1.119171_g82283_i0	PRJNA421571	84832	266	1.119171	2.97699486	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	79	9.31e-15	NR	KAF4680848.1	32597	g82283	i0	62.7	8.09774436090226	59	21	65.4	1	250	77	3148	3206	KAF4680848.1 hypothetical protein FOZ60_012879 [Perkinsus olseni]	diamond	2154	79	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30439961	30439961	PRJNA421571_P_NODE_70033_length_303_cov_3.160870_g67484_i0	PRJNA421571	70033	303	3.16087	9.5774361	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	83.6	2.64e-18	NR	KAF4646887.1	32597	g67484	i0	54.2	24.6534653465347	83	36	82.2	1	4	252	28	108	KAF4646887.1 Histone H2B 1 [Perkinsus olseni]	diamond	7470	83.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30913851	30913851	PRJNA421571_P_NODE_81834_length_272_cov_2.708543_g79285_i0	PRJNA421571	81834	272	2.708543	7.36723696	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	56.6	3.9e-7	NR	KAF4688746.1	32597	g79285	i0	67.4	2.51470588235294	46	15	50.7	0	2	139	184	229	KAF4688746.1 NPC intracellular cholesterol transporter 1, partial [Perkinsus olseni]	diamond	684	57	0.992982456140351	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31023537	31023537	PRJNA421571_P_NODE_60095_length_339_cov_1.646617_g57546_i0	PRJNA421571	60095	339	1.646617	5.58203163	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	49.3	5.21e-4	NR	KAF4664095.1	330153	g57546	i0	38.8	0.592920353982301	67	41	59.3	0	49	249	175	241	KAF4664095.1 hypothetical protein FOL47_005300 [Perkinsus chesapeaki]	diamond	201	49.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31371406	31371406	PRJNA421571_P_NODE_100516_length_245_cov_0.895349_g97967_i0	PRJNA421571	100516	245	0.895349	2.19360505	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	102	3.19e-23	NR	KAF4712768.1	32597	g97967	i0	57.5	6.86938775510204	80	34	98	0	240	1	203	282	KAF4712768.1 Tetratricopeptide repeat protein 30A, partial [Perkinsus olseni]	diamond	1683	102	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32463581	32463581	PRJNA421571_P_NODE_89899_length_254_cov_2.364641_g87350_i0	PRJNA421571	89899	254	2.364641	6.00618814	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	67	8.21e-11	NR	KAF4704796.1	32597	g87350	i0	83.8	4.44094488188976	37	6	43.7	0	112	2	230	266	KAF4704796.1 thiamine metabolism- protein, partial [Perkinsus olseni]	diamond	1128	67	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);;