metadata: contig_metadata: 5 rows where bioproject = "PRJNA407087" and tax

5 rows where bioproject = "PRJNA407087" 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
16992487	16992487	PRJNA407087_S_NODE_4914_length_237_cov_3.951923_g4451_i0	PRJNA407087	4914	237	3.951923	9.36605751	Perkinsida	27998	SAR_Eukaryotes	SAR_Eukaryotes	120	8.02e-33	NR	KAF4712309.1	32597	g4451	i0	79.5	6.89873417721519	78	16	98.7	0	237	4	70	147	KAF4712309.1 60S ribosomal protein L19, partial [Perkinsus olseni]	diamond	1635	121	0.991735537190083	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29145109	29145109	PRJNA407087_S_NODE_6069_length_204_cov_3.080000_g5606_i0	PRJNA407087	6069	204	3.08	6.2832	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	58.9	1.93e-9	NR	XP_002768158.1	423536	g5606	i0	46.8	1.80882352941176	62	25	91.2	1	203	18	34	87	XP_002768158.1 translation initiation factor SUI1, putative [Perkinsus marinus ATCC 50983]	diamond	369	58.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29776153	29776153	PRJNA407087_S_NODE_6311_length_199_cov_2.129412_g5848_i0	PRJNA407087	6311	199	2.129412	4.23752988	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	55.5	6.78e-7	NR	KAF4711357.1	32597	g5848	i0	47.7	3.31658291457286	44	23	66.3	0	199	68	314	357	KAF4711357.1 hypothetical protein FOZ63_028272, partial [Perkinsus olseni]	diamond	660	55.8	0.99462365591397806	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29980708	29980708	PRJNA407087_S_NODE_591_length_976_cov_5.882788_g366_i0	PRJNA407087	591	976	5.882788	57.41601088	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	317	2.51e-100	NR	KAF4757904.1	32597	g366	i0	49.2	3.97745901639344	325	147	99.9	4	1	975	234	540	KAF4757904.1 hypothetical protein FOZ63_030879, partial [Perkinsus olseni]	diamond	3882	317	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32066863	32066863	PRJNA407087_S_NODE_8698_length_162_cov_3.030075_g8235_i0	PRJNA407087	8698	162	3.030075	4.9087215	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	70.9	1.46e-12	NR	KAF4690277.1	32597	g8235	i0	60.4	6.77777777777778	53	21	98.1	0	160	2	168	220	KAF4690277.1 Dynein light chain 1, axonemal [Perkinsus olseni]	diamond	1098	70.9	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);;