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

7 rows where bioproject = "PRJNA270367", 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
28702502	28702502	PRJNA270367_P_NODE_38167_length_173_cov_1.048387_g37962_i0	PRJNA270367	38167	173	1.048387	1.81370951	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	75.9	3.01e-14	NR	KAF4747297.1	32597	g37962	i0	82.6	6.38150289017341	46	8	79.8	0	171	34	238	283	KAF4747297.1 Sodium/potassium-transporting ATPase subunit alpha-1, partial [Perkinsus olseni]	diamond	1104	75.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28810573	28810573	PRJNA270367_P_NODE_21368_length_257_cov_1.000000_g21163_i0	PRJNA270367	21368	257	1	2.57	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0111	NR	XP_002788236.1	423536	g21163	i0	30.6	1.14396887159533	98	52	98.1	5	255	4	84	179	XP_002788236.1 hypothetical protein Pmar_PMAR007293 [Perkinsus marinus ATCC 50983]	diamond	294	43.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29631569	29631569	PRJNA270367_P_NODE_14610_length_336_cov_1.170732_g14405_i0	PRJNA270367	14610	336	1.170732	3.93365952	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	119	5.86e-29	NR	KAF4662336.1	330153	g14405	i0	52.3	1.92857142857143	109	50	95.5	1	322	2	269	377	KAF4662336.1 branched-chain-amino-acid aminotransferase [Perkinsus chesapeaki]	diamond	648	119	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
30421964	30421964	PRJNA270367_P_NODE_10093_length_419_cov_1.113514_g9891_i0	PRJNA270367	10093	419	1.113514	4.66562366	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	65.1	4.14e-9	NR	XP_002776286.1	423536	g9891	i0	33.1	5.13365155131265	127	81	90.2	2	379	2	157	280	XP_002776286.1 NAD-specific glutamate dehydrogenase, putative [Perkinsus marinus ATCC 50983]	diamond	2151	65.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31432834	31432834	PRJNA270367_P_NODE_29716_length_205_cov_1.000000_g29511_i0	PRJNA270367	29716	205	1	2.05	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	59.3	2.08e-8	NR	KAF4729468.1	32597	g29511	i0	60	2.19512195121951	50	20	73.2	0	160	11	81	130	KAF4729468.1 hypothetical protein FOZ63_026808 [Perkinsus olseni]	diamond	450	59.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31893408	31893408	PRJNA270367_P_NODE_33097_length_191_cov_1.098592_g32892_i0	PRJNA270367	33097	191	1.098592	2.09831072	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	87.4	2.36e-18	NR	KAF4716354.1	32597	g32892	i0	65.6	16.413612565445	61	20	95.8	1	187	5	216	275	KAF4716354.1 hypothetical protein FOZ63_029843 [Perkinsus olseni]	diamond	3135	88.2	0.99092970521542	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32683760	32683760	PRJNA270367_P_NODE_33900_length_188_cov_0.942446_g33695_i0	PRJNA270367	33900	188	0.942446	1.77179848	root	1	Root_unresolved	Root_unresolved	52.4	6.99e-6	NR	KAF4653429.1	32597	g33695	i0	96	3.98936170212766	25	1	39.9	0	75	1	20	44	KAF4653429.1 Isocitrate dehydrogenase [NADP], mitochondrial precursor (Oxalosuccinate decarboxylase) [Perkinsus olseni]	diamond	750	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);;