metadata: contig_metadata: 10 rows where bioproject = "PRJDB3785", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJDB3785", 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
15310915	15310915	PRJDB3785_S_NODE_22793_length_168_cov_1.168067_g22640_i0	PRJDB3785	22793	168	1.168067	1.96235256	root	1	Root_unresolved	Root_unresolved	97.4	7.6e-22	NR	AND95702.1	32597	g22640	i0	80.4	11.6964285714286	56	11	100	0	1	168	414	469	AND95702.1 Aconitate hydratase, cytoplasmic, partial [Perkinsus olseni]	diamond	1965	98.2	0.991853360488798	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
16585687	16585687	PRJDB3785_S_NODE_24014_length_166_cov_0.871795_g23861_i0	PRJDB3785	24014	166	0.871795	1.4471797	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	80.5	6.38e-11	NTclustered	gi\|294905936\|ref\|XM_002777668.1\|	423536	g23861	i0	94.231	0.626506024096386	52	3	31	0	95	146	405	354	Perkinsus marinus ATCC 50983 60s ribosomal protein l22, putative, mRNA	blastn	104	80.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
21685414	21685414	PRJDB3785_S_NODE_23198_length_167_cov_0.864407_g23045_i0	PRJDB3785	23198	167	0.864407	1.44355969	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	60.2	8.37e-5	NTclustered	gi\|294955501\|ref\|XM_002788491.1\|	423536	g23045	i0	94.737	0.227544910179641	38	2	23	0	15	52	169	132	Perkinsus marinus ATCC 50983 chaperone protein DNAK, putative, mRNA	blastn	38	60.2	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
22960734	22960734	PRJDB3785_S_NODE_19579_length_179_cov_1.569231_g19426_i0	PRJDB3785	19579	179	1.569231	2.80892349	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	103	5.810000000000001e-26	NR	KAF4700315.1	32597	g19426	i0	77.6	51.1508379888268	58	13	97.2	0	2	175	43	100	KAF4700315.1 Arf GTPase arf1 [Perkinsus olseni]	diamond	9156	104	0.990384615384615	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
27221876	27221876	PRJDB3785_S_NODE_26263_length_162_cov_1.353982_g26110_i0	PRJDB3785	26263	162	1.353982	2.19345084	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	59.7	3.03e-9	NR	XP_002765022.1	423536	g26110	i0	55.1	2.77777777777778	49	21	88.9	1	160	17	83	131	XP_002765022.1 hypothetical protein Pmar_PMAR004478, partial [Perkinsus marinus ATCC 50983]	diamond	450	59.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
27311269	27311269	PRJDB3785_S_NODE_25623_length_163_cov_1.342105_g25470_i0	PRJDB3785	25623	163	1.342105	2.18763115	root	1	Root_unresolved	Root_unresolved	73.6	8.58e-14	NR	XP_002782567.1	423536	g25470	i0	61.5	3.82822085889571	52	20	95.7	0	158	3	188	239	XP_002782567.1 Basic endochitinase 1 precursor, putative, partial [Perkinsus marinus ATCC 50983]	diamond	624	73.6	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28037400	28037400	PRJDB3785_S_NODE_16525_length_193_cov_1.062500_g16372_i0	PRJDB3785	16525	193	1.0625	2.050625	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	81.6	3.83e-16	NR	KAF4680713.1	32597	g16372	i0	56.5	9.63730569948187	62	27	96.4	0	193	8	1715	1776	KAF4680713.1 hypothetical protein FOZ60_013098 [Perkinsus olseni]	diamond	1860	82.4	0.990291262135922	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28800794	28800794	PRJDB3785_S_NODE_8328_length_261_cov_1.127358_g8175_i0	PRJDB3785	8328	261	1.127358	2.94240438	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	92	3.79e-20	NR	XP_002782567.1	423536	g8175	i0	53.5	0.988505747126437	86	39	97.7	1	257	3	37	122	XP_002782567.1 Basic endochitinase 1 precursor, putative, partial [Perkinsus marinus ATCC 50983]	diamond	258	92	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29615649	29615649	PRJDB3785_S_NODE_10550_length_233_cov_1.663043_g10397_i0	PRJDB3785	10550	233	1.663043	3.87489019	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	95.9	6.420000000000001e-21	NR	KAF4685907.1	32597	g10397	i0	53.6	4.32618025751073	84	28	94	1	223	5	239	322	KAF4685907.1 Obg-like ATPase [Perkinsus olseni]	diamond	1008	95.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31037917	31037917	PRJDB3785_S_NODE_25135_length_164_cov_0.886957_g24982_i0	PRJDB3785	25135	164	0.886957	1.45460948	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	89.4	3.5e-19	NR	KAF4706806.1	32597	g24982	i0	68.5	10.8658536585366	54	17	98.8	0	162	1	1	54	KAF4706806.1 hypothetical protein FOZ62_009284, partial [Perkinsus olseni]	diamond	1782	89.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);;