metadata: contig_metadata: 5 rows where bioproject = "PRJNA1063685", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA1063685", 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
13765536	13765536	PRJNA1063685_S_NODE_77891_length_227_cov_9.123377_g77348_i0	PRJNA1063685	77891	227	9.123377	20.71006579	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	82.4	2.58e-11	NTclustered	gi\|218526343\|gb\|EU919449.1\|	31276	g77348	i0	94.34	23.3788546255507	53	3	23	0	9	61	932	880	Perkinsus marinus isolate EBPICv15-H6-G5 clone 3 large subunit ribosomal RNA gene, partial sequence	blastn	5307	82.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
27311945	27311945	PRJNA1063685_S_NODE_13923_length_575_cov_1.470120_g13400_i0	PRJNA1063685	13923	575	1.47012	8.45319	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	201	9.93e-61	NR	KAF4659862.1	330153	g13400	i0	51	6.04173913043478	194	89	98.1	3	574	11	50	243	KAF4659862.1 hypothetical protein FOL47_007401 [Perkinsus chesapeaki]	diamond	3474	201	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
27509600	27509600	PRJNA1063685_S_NODE_10663_length_619_cov_4.443223_g10148_i0	PRJNA1063685	10663	619	4.443223	27.50355037	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	267	4.0699999999999997e-88	NR	XP_002778466.1	423536	g10148	i0	71.1	0.906300484652666	187	53	90.1	1	560	3	1	187	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	561	267	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30035575	30035575	PRJNA1063685_S_NODE_15851_length_552_cov_3.887265_g15323_i0	PRJNA1063685	15851	552	3.887265	21.4577028	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	186	5.469999999999999e-55	NR	KAF4684998.1	32597	g15323	i0	60.9	3.39673913043478	156	58	84.8	2	482	15	43	195	KAF4684998.1 Protein phosphatase PP2A regulatory subunit B, partial [Perkinsus olseni]	diamond	1875	186	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30667426	30667426	PRJNA1063685_S_NODE_61533_length_275_cov_1.143564_g60990_i0	PRJNA1063685	61533	275	1.143564	3.144801	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.00611	NR	KAF4665648.1	32597	g60990	i0	43.9	1.12363636363636	66	31	72	2	263	66	1	60	KAF4665648.1 hypothetical protein FOZ61_010655 [Perkinsus olseni]	diamond	309	42.7	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);;