metadata: contig_metadata: 9 rows where bioproject = "PRJNA667863" and tax

9 rows where bioproject = "PRJNA667863" 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
7012461	7012461	PRJNA667863_P_NODE_1286_length_457_cov_5.247396_g1252_i0	PRJNA667863	1286	457	5.247396	23.98059972	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	220	1.15e-52	NTclustered	gi\|294933094\|ref\|XM_002780549.1\|	423536	g1252	i0	78.916	74.5010940919037	332	65	72	5	78	407	595	267	Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA	blastn	34047	220	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
14662984	14662984	PRJNA667863_P_NODE_4172_length_319_cov_1.000000_g4138_i0	PRJNA667863	4172	319	1	3.19	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	144	9.31e-41	NR	KAF4756585.1	32597	g4138	i0	69.9	47.8871473354232	103	31	96.9	0	3	311	56	158	KAF4756585.1 70-kilodalton heat shock protein, partial [Perkinsus olseni]	diamond	15276	144	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
17212125	17212125	PRJNA667863_P_NODE_8654_length_266_cov_1.507772_g8620_i0	PRJNA667863	8654	266	1.507772	4.01067352	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	163	1.08e-35	NTclustered	gi\|294953922\|ref\|XM_002787921.1\|	423536	g8620	i0	79.399	8.26691729323308	233	46	87	2	24	255	172	403	Perkinsus marinus ATCC 50983 60S ribosomal protein L11, putative, mRNA	blastn	2199	163	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
22840984	22840984	PRJNA667863_P_NODE_5498_length_294_cov_1.416290_g5464_i0	PRJNA667863	5498	294	1.41629	4.1638926	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	101	6.08e-24	NR	KAF4725977.1	32597	g5464	i0	54.1	7.04081632653061	85	38	86.7	1	256	2	18	101	KAF4725977.1 hypothetical protein FOZ63_008683, partial [Perkinsus olseni]	diamond	2070	101	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
26682050	26682050	PRJNA667863_P_NODE_14081_length_246_cov_0.890173_g14047_i0	PRJNA667863	14081	246	0.890173	2.18982558	Synurophyceae	33859	SAR_Eukaryotes	SAR_Eukaryotes	129	1.05e-35	NR	XP_002778466.1	423536	g14047	i0	70.4	1.92682926829268	81	24	98.8	0	245	3	25	105	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	474	130	0.992307692307692	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
26745155	26745155	PRJNA667863_P_NODE_5381_length_296_cov_1.493274_g5347_i0	PRJNA667863	5381	296	1.493274	4.42009104	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	75.5	1.13e-14	NR	KAF4717142.1	32597	g5347	i0	40	7.7027027027027	95	56	96.3	1	296	12	28	121	KAF4717142.1 40S ribosomal protein S3-1, partial [Perkinsus olseni]	diamond	2280	75.9	0.994729907773386	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27914741	27914741	PRJNA667863_P_NODE_16385_length_242_cov_0.911243_g16351_i0	PRJNA667863	16385	242	0.911243	2.20520806	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	59.3	1.06e-8	NR	KAF4717142.1	32597	g16351	i0	39.5	5.65289256198347	76	45	94.2	1	13	240	24	98	KAF4717142.1 40S ribosomal protein S3-1, partial [Perkinsus olseni]	diamond	1368	59.7	0.993299832495812	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29386979	29386979	PRJNA667863_P_NODE_18129_length_231_cov_2.588608_g18095_i0	PRJNA667863	18129	231	2.588608	5.97968448	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	92.4	1.52e-21	NR	KAF4744194.1	32597	g18095	i0	55.8	4.03896103896104	77	34	100	0	231	1	70	146	KAF4744194.1 70-kilodalton heat shock protein, partial [Perkinsus olseni]	diamond	933	92.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30757149	30757149	PRJNA667863_P_NODE_11414_length_251_cov_0.865169_g11380_i0	PRJNA667863	11414	251	0.865169	2.17157419	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	112	5.65e-28	NR	KAF4757553.1	32597	g11380	i0	67.5	7.9362549800796804	83	26	99.2	1	1	249	174	255	KAF4757553.1 ATP synthase subunit 9, partial [Perkinsus olseni]	diamond	1992	112	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);;