metadata: contig_metadata: 11 rows where bioproject = "PRJNA1120060", tax_clade = "Sar" and tax

11 rows where bioproject = "PRJNA1120060", 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
4077618	4077618	PRJNA1120060_P_NODE_2372844_length_258_cov_3.200000_g2354779_i0	PRJNA1120060	2372844	258	3.2	8.256	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|2326535463\|gb\|ON035646.1\|	330153	g2354779	i0	100	0.108527131782946	28	0	11	0	1	28	17012	17039	Perkinsus chesapeaki strain PAND-A8-4a chromosome 2 mitochondrion, complete sequence	blastn	28	52.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
27921346	27921346	PRJNA1120060_P_NODE_1765_length_4307_cov_19.695796_g623_i0	PRJNA1120060	1765	4307	19.695796	848.29793372	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.0112	NR	KAF4648517.1	330153	g623	i0	40.9	0.0842814023682378	66	35	4.5	2	1005	1196	64	127	KAF4648517.1 hypothetical protein FOL47_003130 [Perkinsus chesapeaki]	diamond	363	52.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
28552740	28552740	PRJNA1120060_P_NODE_1295687_length_307_cov_2.448718_g1277740_i0	PRJNA1120060	1295687	307	2.448718	7.51756426	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00934	NR	XP_002778586.1	423536	g1277740	i0	57.6	0.322475570032573	33	14	32.2	0	274	176	152	184	XP_002778586.1 retrovirus polyprotein, putative [Perkinsus marinus ATCC 50983]	diamond	99	45.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29658639	29658639	PRJNA1120060_P_NODE_3314310_length_225_cov_6.842105_g3296199_i0	PRJNA1120060	3314310	225	6.842105	15.39473625	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0219	NR	XP_002784922.1	423536	g3296199	i0	53.6	0.373333333333333	28	13	37.3	0	142	59	406	433	XP_002784922.1 hypothetical protein Pmar_PMAR022565 [Perkinsus marinus ATCC 50983]	diamond	84	43.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30132631	30132631	PRJNA1120060_P_NODE_4572_length_2367_cov_19.480384_g623_i2	PRJNA1120060	4572	2367	19.480384	461.10068928	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.00538	NR	KAF4648517.1	330153	g623	i2	40.9	0.153358681875792	66	35	8.1	2	1363	1172	64	127	KAF4648517.1 hypothetical protein FOL47_003130 [Perkinsus chesapeaki]	diamond	363	52.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
30891190	30891190	PRJNA1120060_P_NODE_3267194_length_228_cov_3.870968_g3249086_i0	PRJNA1120060	3267194	228	3.870968	8.82580704	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0167	NR	KAF4655276.1	330153	g3249086	i0	47.2	0.473684210526316	36	19	47.4	0	181	74	1436	1471	KAF4655276.1 hypothetical protein FOL47_009493 [Perkinsus chesapeaki]	diamond	108	43.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31427134	31427134	PRJNA1120060_P_NODE_1455916_length_295_cov_3.779279_g1437931_i0	PRJNA1120060	1455916	295	3.779279	11.14887305	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	48.1	9.18e-4	NR	XP_002778586.1	423536	g1437931	i0	52.8	0.366101694915254	36	17	36.6	0	166	59	149	184	XP_002778586.1 retrovirus polyprotein, putative [Perkinsus marinus ATCC 50983]	diamond	108	48.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31648231	31648231	PRJNA1120060_P_NODE_1160937_length_311_cov_2.100840_g1143002_i0	PRJNA1120060	1160937	311	2.10084	6.5336124	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.0132	NR	XP_002784922.1	423536	g1143002	i0	39.6	0.752411575562701	48	24	41.5	2	173	301	405	452	XP_002784922.1 hypothetical protein Pmar_PMAR022565 [Perkinsus marinus ATCC 50983]	diamond	234	45.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
32124106	32124106	PRJNA1120060_P_NODE_2586278_length_251_cov_2.314607_g2568201_i0	PRJNA1120060	2586278	251	2.314607	5.80966357	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	41.2	0.0377	NR	KAF4757374.1	32597	g2568201	i0	35.7	0.669322709163347	56	35	66.9	1	251	84	37	91	KAF4757374.1 hypothetical protein FOZ63_014240, partial [Perkinsus olseni]	diamond	168	41.2	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32661394	32661394	PRJNA1120060_P_NODE_2960_length_3111_cov_22.614220_g623_i1	PRJNA1120060	2960	3111	22.61422	703.5283842	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.00761	NR	KAF4648517.1	330153	g623	i1	40.9	0.116682738669238	66	35	6.2	2	2107	1916	64	127	KAF4648517.1 hypothetical protein FOL47_003130 [Perkinsus chesapeaki]	diamond	363	52.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
32692140	32692140	PRJNA1120060_P_NODE_1737140_length_283_cov_3.228571_g1719132_i0	PRJNA1120060	1737140	283	3.228571	9.13685593	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0496	NR	KAF4707660.1	32597	g1719132	i0	53.3	0.318021201413428	30	14	31.8	0	210	121	179	208	KAF4707660.1 hypothetical protein FOZ63_017596, partial [Perkinsus olseni]	diamond	90	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);;