metadata: contig_metadata: 7 rows where bioproject = "PRJNA1035005", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA1035005", 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
7821359	7821359	PRJNA1035005_P_NODE_2787_length_668_cov_8.931092_g2400_i0	PRJNA1035005	2787	668	8.931092	59.65969456	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	198	8.079999999999999e-46	NTclustered	gi\|294881230\|ref\|XM_002769261.1\|	423536	g2400	i0	76.456	26.2949101796407	412	70	60	24	194	596	444	51	Perkinsus marinus ATCC 50983 60S ribosomal protein L27a, putative, mRNA	blastn	17565	198	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
21845895	21845895	PRJNA1035005_P_NODE_5678_length_446_cov_5.495979_g5278_i0	PRJNA1035005	5678	446	5.495979	24.51206634	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	207	2.35e-65	NR	XP_002778466.1	423536	g5278	i0	77.1	0.881165919282511	131	30	88.1	0	394	2	1	131	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	393	207	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
27635583	27635583	PRJNA1035005_P_NODE_73804_length_246_cov_0.901734_g73398_i0	PRJNA1035005	73804	246	0.901734	2.21826564	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	51.6	2.75e-5	NR	XP_002782791.1	423536	g73398	i0	34.6	1.8780487804878	78	46	89	1	27	245	70	147	XP_002782791.1 hypothetical protein Pmar_PMAR025050, partial [Perkinsus marinus ATCC 50983]	diamond	462	51.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29332465	29332465	PRJNA1035005_P_NODE_49049_length_258_cov_1.681081_g48643_i0	PRJNA1035005	49049	258	1.681081	4.33718898	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	81.6	4.19e-16	NR	KAF4657463.1	32597	g48643	i0	49.4	3.05813953488372	85	37	98.8	1	255	1	11	89	KAF4657463.1 hypothetical protein FOZ61_006257 [Perkinsus olseni]	diamond	789	81.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29624105	29624105	PRJNA1035005_P_NODE_4990_length_476_cov_1.392060_g4590_i0	PRJNA1035005	4990	476	1.39206	6.6262056	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	50.4	8.95e-4	NR	KAF4652938.1	330153	g4590	i0	24.2	0.964285714285714	153	85	93.9	3	476	30	2433	2558	KAF4652938.1 hypothetical protein FOL47_010776 [Perkinsus chesapeaki]	diamond	459	50.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
29995749	29995749	PRJNA1035005_P_NODE_68171_length_248_cov_0.891429_g67765_i0	PRJNA1035005	68171	248	0.891429	2.21074392	root	1	Root_unresolved	Root_unresolved	45.1	0.00185	NR	KAF4733685.1	32597	g67765	i0	42.1	1.39112903225806	57	32	67.7	1	22	189	50	106	KAF4733685.1 hypothetical protein FOZ63_018713, partial [Perkinsus olseni]	diamond	345	45.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31457370	31457370	PRJNA1035005_P_NODE_90396_length_208_cov_4.066667_g89989_i0	PRJNA1035005	90396	208	4.066667	8.45866736	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	84.7	3.72e-17	NR	KAF4666579.1	330153	g89989	i0	57.4	1.96153846153846	68	25	93.8	2	12	206	577	643	KAF4666579.1 meprin and TRAF y domain-containing protein MATH domain-containing protein [Perkinsus chesapeaki]	diamond	408	84.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);;