metadata: contig_metadata: 6 rows where bioproject = "PRJNA760904", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA760904", 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
8395536	8395536	PRJNA760904_P_NODE_3947_length_420_cov_1.700288_g3890_i0	PRJNA760904	3947	420	1.700288	7.1412096	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	217	1.56e-66	NR	KAF4720670.1	32597	g3890	i0	74.6	6.9	138	35	98.6	0	418	5	210	347	KAF4720670.1 T-complex protein 1 subunit epsilon [Perkinsus olseni]	diamond	2898	218	0.995412844036697	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
13495995	13495995	PRJNA760904_P_NODE_1471_length_644_cov_1.851138_g1417_i0	PRJNA760904	1471	644	1.851138	11.92132872	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	313	5.33e-102	NR	KAF4671046.1	32597	g1417	i0	69.8	5.00776397515528	215	64	99.7	1	643	2	136	350	KAF4671046.1 hypothetical protein FOZ61_006864 [Perkinsus olseni]	diamond	3225	313	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27758097	27758097	PRJNA760904_P_NODE_16964_length_247_cov_0.885057_g16907_i0	PRJNA760904	16964	247	0.885057	2.18609079	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	87	9.7e-18	NR	KAF4701884.1	32597	g16907	i0	47.5	5.81781376518219	80	42	97.2	0	242	3	109	188	KAF4701884.1 hypothetical protein FOZ62_031219, partial [Perkinsus olseni]	diamond	1437	87.4	0.995423340961098	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28032373	28032373	PRJNA760904_P_NODE_12605_length_266_cov_1.834197_g12548_i0	PRJNA760904	12605	266	1.834197	4.87896402	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	94.4	3.34e-20	NR	KAF4697286.1	32597	g12548	i0	47.7	3.96992481203007	88	45	98.1	1	6	266	389	476	KAF4697286.1 hypothetical protein FOZ60_009909 [Perkinsus olseni]	diamond	1056	94.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29737001	29737001	PRJNA760904_P_NODE_13010_length_263_cov_1.763158_g12953_i0	PRJNA760904	13010	263	1.763158	4.63710554	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	57.8	2.13e-7	NR	KAF4690667.1	32597	g12953	i0	42.6	3.86692015209125	68	38	76.4	1	201	1	77	144	KAF4690667.1 hypothetical protein FOZ60_017035 [Perkinsus olseni]	diamond	1017	57.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32551142	32551142	PRJNA760904_P_NODE_11019_length_279_cov_1.233010_g10962_i0	PRJNA760904	11019	279	1.23301	3.4400979	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	49.7	2.09e-4	NR	KAF4666579.1	330153	g10962	i0	29.6	0.870967741935484	81	55	84.9	1	266	30	605	685	KAF4666579.1 meprin and TRAF y domain-containing protein MATH domain-containing protein [Perkinsus chesapeaki]	diamond	243	49.7	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);;