metadata: contig_metadata: 5 rows where bioproject = "PRJNA738523", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA738523", 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
4548054	4548054	PRJNA738523_P_NODE_3984_length_345_cov_1.665441_g3913_i0	PRJNA738523	3984	345	1.665441	5.74577145	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	97.8	4.19e-22	NR	XP_002782044.1	423536	g3913	i0	68.5	1.45217391304348	73	23	63.5	0	127	345	4	76	XP_002782044.1 molecular chaperone, putative, partial [Perkinsus marinus ATCC 50983]	diamond	501	97.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
26925917	26925917	PRJNA738523_P_NODE_2002_length_457_cov_1.203125_g1931_i0	PRJNA738523	2002	457	1.203125	5.49828125	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	57.4	2.84e-6	NR	KAF4676703.1	330153	g1931	i0	37.2	0.564551422319475	86	51	56.5	1	417	160	50	132	KAF4676703.1 hypothetical protein FOL47_005420 [Perkinsus chesapeaki]	diamond	258	57.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31411373	31411373	PRJNA738523_P_NODE_7796_length_276_cov_1.344828_g7725_i0	PRJNA738523	7796	276	1.344828	3.71172528	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.0111	NR	KAF4654442.1	330153	g7725	i0	48.4	0.33695652173913	31	16	33.7	0	235	143	404	434	KAF4654442.1 hypothetical protein FOL47_009980 [Perkinsus chesapeaki]	diamond	93	44.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31421472	31421472	PRJNA738523_P_NODE_6196_length_293_cov_1.750000_g6125_i0	PRJNA738523	6196	293	1.75	5.1275	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	164	1.3999999999999998e-44	NR	KAF4658562.1	32597	g6125	i0	81.4	8.93856655290102	97	18	99.3	0	291	1	1037	1133	KAF4658562.1 hypothetical protein FOL46_006904 [Perkinsus olseni]	diamond	2619	164	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31927534	31927534	PRJNA738523_P_NODE_14957_length_243_cov_0.905882_g14886_i0	PRJNA738523	14957	243	0.905882	2.20129326	Perkinsida	27998	SAR_Eukaryotes	SAR_Eukaryotes	163	1.8e-47	NR	XP_002768537.1	423536	g14886	i0	96.3	3.95061728395062	80	3	98.8	0	2	241	45	124	XP_002768537.1 Casein kinase I, putative [Perkinsus marinus ATCC 50983]	diamond	960	164	0.99390243902439	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);;