metadata: contig_metadata: 9 rows where bioproject = "PRJEB12237" and tax

9 rows where bioproject = "PRJEB12237" 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
20717	20717	PRJEB12237_P_NODE_8441_length_188_cov_1.823529_g8245_i0	PRJEB12237	8441	188	1.823529	3.42823452	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	102	7.72e-25	NR	KAF4672183.1	330153	g8245	i0	75.4	2.92021276595745	61	15	97.3	0	1	183	2	62	KAF4672183.1 hypothetical protein FOL47_000834, partial [Perkinsus chesapeaki]	diamond	549	102	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
10223464	10223464	PRJEB12237_P_NODE_629_length_907_cov_3.413991_g519_i0	PRJEB12237	629	907	3.413991	30.96489837	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	130	3.61e-32	NR	TEB19254.1	2494336	g519	i0	34.5	0.883131201764057	267	153	82.4	8	67	813	1	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	801	130	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
11498689	11498689	PRJEB12237_P_NODE_2250_length_472_cov_4.297483_g2057_i0	PRJEB12237	2250	472	4.297483	20.28411976	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	313	1.91e-80	NTclustered	gi\|294891115\|ref\|XM_002773382.1\|	423536	g2057	i0	82.432	80.9046610169491	370	53	77	12	97	460	75	438	Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA	blastn	38187	313	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
20421323	20421323	PRJEB12237_P_NODE_1537_length_583_cov_3.014599_g1360_i0	PRJEB12237	1537	583	3.014599	17.57511217	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	159	1.65e-45	NR	XP_002778466.1	423536	g1360	i0	75.2	1.03945111492281	101	25	52	0	557	255	1	101	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	606	159	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30917839	30917839	PRJEB12237_P_NODE_1734_length_547_cov_4.072266_g1553_i0	PRJEB12237	1734	547	4.072266	22.27529502	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	103	2.45e-23	NR	TEB19254.1	2494336	g1553	i0	46.8	0.680073126142596	124	63	68	1	7	378	143	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	372	103	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
31417127	31417127	PRJEB12237_P_NODE_9456_length_175_cov_1.185714_g9260_i0	PRJEB12237	9456	175	1.185714	2.0749995	Perkinsozoa	2497438	SAR_Eukaryotes	SAR_Eukaryotes	92.8	2.21e-22	NR	KAF4696041.1	32597	g9260	i0	85.7	22.6628571428571	49	7	84	0	1	147	90	138	KAF4696041.1 suppressor of kinetochore protein mutant [Perkinsus olseni]	diamond	3966	92.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31613205	31613205	PRJEB12237_P_NODE_3636_length_345_cov_3.229032_g3440_i0	PRJEB12237	3636	345	3.229032	11.1401604	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	65.5	6.37e-10	NR	TEB19254.1	2494336	g3440	i0	39.5	1.03478260869565	119	63	95.7	3	11	340	22	140	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	357	65.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
31796478	31796478	PRJEB12237_P_NODE_7477_length_204_cov_1.656805_g7281_i0	PRJEB12237	7477	204	1.656805	3.3798822	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	45.8	7.1e-4	NR	KAF4693414.1	32597	g7281	i0	55.6	1.58823529411765	36	16	52.9	0	199	92	100	135	KAF4693414.1 hypothetical protein FOZ63_008178, partial [Perkinsus olseni]	diamond	324	45.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32214355	32214355	PRJEB12237_P_NODE_10578_length_163_cov_1.250000_g10382_i0	PRJEB12237	10578	163	1.25	2.0375	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	60.1	9.54e-9	NR	XP_002765185.1	423536	g10382	i0	66	0.865030674846626	47	14	86.5	1	23	163	1	45	XP_002765185.1 DNAJ domain protein, putative [Perkinsus marinus ATCC 50983]	diamond	141	60.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus

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