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

7 rows where bioproject = "PRJNA541476", 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
28751595	28751595	PRJNA541476_P_NODE_17107_length_296_cov_1.618834_g16901_i0	PRJNA541476	17107	296	1.618834	4.79174864	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	87.4	2.06e-18	NR	TEB19254.1	2494336	g16901	i0	43.9	0.993243243243243	98	51	99.3	2	1	294	159	252	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	294	87.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
28972786	28972786	PRJNA541476_P_NODE_8748_length_383_cov_2.570968_g8544_i0	PRJNA541476	8748	383	2.570968	9.84680744	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	76.6	6.87e-14	NR	TEB19254.1	2494336	g8544	i0	39	1.06527415143603	136	74	99.5	3	381	1	29	164	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	408	76.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
30394276	30394276	PRJNA541476_P_NODE_23453_length_268_cov_1.892308_g23247_i0	PRJNA541476	23453	268	1.892308	5.07138544	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	49.3	1.46e-4	NR	KAF4756948.1	32597	g23247	i0	45.5	3.82835820895522	66	32	69.4	2	267	82	121	186	KAF4756948.1 hypothetical protein FOZ63_033073, partial [Perkinsus olseni]	diamond	1026	49.3	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30394283	30394283	PRJNA541476_P_NODE_31333_length_249_cov_2.210227_g31127_i0	PRJNA541476	31333	249	2.210227	5.50346523	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	78.6	4.57e-15	NR	KAF4662129.1	32597	g31127	i0	47.2	4.30120481927711	72	36	84.3	1	211	2	38	109	KAF4662129.1 hypothetical protein FOZ61_002692 [Perkinsus olseni]	diamond	1071	78.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31721385	31721385	PRJNA541476_P_NODE_3837_length_589_cov_13.038760_g3643_i0	PRJNA541476	3837	589	13.03876	76.7982964	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	268	1e-88	NR	XP_002778466.1	423536	g3643	i0	70.7	0.957555178268251	188	54	95.2	1	564	4	1	188	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	564	268	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31784486	31784486	PRJNA541476_P_NODE_2557_length_736_cov_3.214178_g2372_i0	PRJNA541476	2557	736	3.214178	23.65635008	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	73.6	6.33e-11	NR	KAF4675177.1	330153	g2372	i0	44.1	0.823369565217391	68	34	27.7	1	736	533	97	160	KAF4675177.1 hypothetical protein FOL47_008184 [Perkinsus chesapeaki]	diamond	606	73.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
32764483	32764483	PRJNA541476_P_NODE_8800_length_382_cov_2.174757_g8596_i0	PRJNA541476	8800	382	2.174757	8.30757174	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	65.5	9.36e-10	NR	TEB19254.1	2494336	g8596	i0	38.3	1.00523560209424	128	70	93.5	3	365	9	3	130	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	384	65.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016

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);;