metadata: contig_metadata: 10 rows where bioproject = "PRJNA980587" and tax

10 rows where bioproject = "PRJNA980587" 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
6059212	6059212	PRJNA980587_P_NODE_63045_length_286_cov_1.056338_g62252_i0	PRJNA980587	63045	286	1.056338	3.02112668	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	145	2.05e-38	NR	KAF4733002.1	32597	g62252	i0	77.1	5.27622377622378	83	19	87.1	0	269	21	50	132	KAF4733002.1 Fibronectin type III and SPRY domain-containing protein 1 [Perkinsus olseni]	diamond	1509	145	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
21357668	21357668	PRJNA980587_P_NODE_42957_length_353_cov_2.196429_g42164_i0	PRJNA980587	42957	353	2.196429	7.75339437	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	201	7.909999999999999e-62	NR	KAF4726901.1	32597	g42164	i0	85.3	11.7705382436261	116	17	98.6	0	348	1	186	301	KAF4726901.1 26S protease regulatory subunit 8, partial [Perkinsus olseni]	diamond	4155	201	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27089516	27089516	PRJNA980587_P_NODE_19662_length_575_cov_2.521912_g18876_i0	PRJNA980587	19662	575	2.521912	14.500994	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	136	2.61e-33	NR	KAF4675741.1	330153	g18876	i0	42.5	9.51130434782609	181	99	93.4	3	572	36	748	925	KAF4675741.1 40S ribosomal protein S3-1 [Perkinsus chesapeaki]	diamond	5469	136	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
28163351	28163351	PRJNA980587_P_NODE_30685_length_434_cov_3.504155_g29892_i0	PRJNA980587	30685	434	3.504155	15.2080327	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	77.8	5.89e-15	NR	XP_002784356.1	423536	g29892	i0	32.2	1.95622119815668	143	93	97.5	2	10	432	1	141	XP_002784356.1 ubiquitin, putative [Perkinsus marinus ATCC 50983]	diamond	849	77.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28295542	28295542	PRJNA980587_P_NODE_80246_length_250_cov_0.870056_g79453_i0	PRJNA980587	80246	250	0.870056	2.17514	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	51.6	5.22e-6	NR	KAF4661834.1	32597	g79453	i0	54.8	6.996	42	19	50.4	0	248	123	80	121	KAF4661834.1 60S ribosomal protein L22 [Perkinsus olseni]	diamond	1749	52	0.992307692307692	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29079050	29079050	PRJNA980587_P_NODE_76868_length_254_cov_1.469613_g76075_i0	PRJNA980587	76868	254	1.469613	3.73281702	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	52.8	1.21e-5	NR	KAF4681221.1	32597	g76075	i0	69	2.70472440944882	29	9	34.3	0	98	12	223	251	KAF4681221.1 hypothetical protein FOZ60_012447, partial [Perkinsus olseni]	diamond	687	52.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30190183	30190183	PRJNA980587_P_NODE_69512_length_271_cov_1.156566_g68719_i0	PRJNA980587	69512	271	1.156566	3.13429386	Bolidophyceae	91989	SAR_Eukaryotes	SAR_Eukaryotes	81.6	1.09e-15	NR	KAF4676419.1	32597	g68719	i0	49.4	6.45387453874539	81	38	89.7	2	26	268	566	643	KAF4676419.1 CCR4-NOT transcription complex subunit 6-like [Perkinsus olseni]	diamond	1749	82.4	0.990291262135922	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31827648	31827648	PRJNA980587_P_NODE_76297_length_255_cov_1.719780_g75504_i0	PRJNA980587	76297	255	1.71978	4.385439	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	56.6	5.37e-7	NR	XP_002786596.1	423536	g75504	i0	47.4	0.894117647058824	76	30	82.4	3	41	250	278	349	XP_002786596.1 Splicing factor U2AF 65 kDa subunit, putative [Perkinsus marinus ATCC 50983]	diamond	228	56.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31897200	31897200	PRJNA980587_P_NODE_71137_length_267_cov_1.458763_g70344_i0	PRJNA980587	71137	267	1.458763	3.89489721	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	54.3	3.97e-6	NR	KAF4672203.1	330153	g70344	i0	52.6	5.59550561797753	57	22	62.9	2	168	1	16	68	KAF4672203.1 hypothetical protein FOL47_000786 [Perkinsus chesapeaki]	diamond	1494	54.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
32907937	32907937	PRJNA980587_P_NODE_67220_length_276_cov_1.137931_g66427_i0	PRJNA980587	67220	276	1.137931	3.14068956	Xanthophyceae	2833	SAR_Eukaryotes	SAR_Eukaryotes	120	1.6499999999999999e-32	NR	KAF4653627.1	32597	g66427	i0	72.2	2.96739130434783	90	24	96.7	1	274	8	1	90	KAF4653627.1 60S ribosomal protein L26 [Perkinsus olseni]	diamond	819	121	0.991735537190083	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);;