metadata: contig_metadata: 4 rows where bioproject = "PRJNA951810", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA951810", 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
2212296	2212296	PRJNA951810_P_NODE_24822_length_403_cov_6.918182_g24481_i0	PRJNA951810	24822	403	6.918182	27.88027346	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	283	1.26e-71	NTclustered	gi\|294950766\|ref\|XM_002786717.1\|	423536	g24481	i0	87.449	44.531017369727	247	29	61	2	157	402	174	419	Perkinsus marinus ATCC 50983 40S ribosomal protein S14, putative, mRNA	blastn	17946	283	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28737614	28737614	PRJNA951810_P_NODE_80767_length_299_cov_3.840708_g80423_i0	PRJNA951810	80767	299	3.840708	11.48371692	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	84	2.22e-16	NR	KAF4676809.1	32597	g80423	i0	45	8.87959866220736	100	48	94.3	2	299	18	205	303	KAF4676809.1 hypothetical protein FOZ62_004234, partial [Perkinsus olseni]	diamond	2655	84.7	0.991735537190083	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29937484	29937484	PRJNA951810_P_NODE_168011_length_244_cov_1.637427_g167666_i0	PRJNA951810	168011	244	1.637427	3.99532188	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	74.3	1.69e-13	NR	KAF4676519.1	330153	g167666	i0	86.8	8.87704918032787	38	5	46.7	0	3	116	288	325	KAF4676519.1 suppressor of kinetochore protein mutant [Perkinsus chesapeaki]	diamond	2166	74.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
30215039	30215039	PRJNA951810_P_NODE_129192_length_273_cov_7.760000_g128847_i0	PRJNA951810	129192	273	7.76	21.1848	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	52.4	2.11e-5	NR	KAF4715818.1	32597	g128847	i0	41.4	2.81318681318681	70	41	76.9	0	62	271	313	382	KAF4715818.1 hypothetical protein FOZ62_006567 [Perkinsus olseni]	diamond	768	52.4	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);;