metadata: contig_metadata: 9 rows where bioproject = "PRJNA911178", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA911178", 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
5996692	5996692	PRJNA911178_P_NODE_74525_length_409_cov_4.333333_g72062_i0	PRJNA911178	74525	409	4.333333	17.72333197	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	195	6.17e-45	NTclustered	gi\|294874491\|ref\|XM_002766937.1\|	423536	g72062	i0	85.052	43.4767726161369	194	25	47	4	181	372	131	322	Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA	blastn	17782	195	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
11096713	11096713	PRJNA911178_P_NODE_49249_length_493_cov_1.823810_g46821_i0	PRJNA911178	49249	493	1.82381	8.9913833	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	195	6.11e-57	NR	KAF4671046.1	32597	g46821	i0	55.5	9.40162271805274	173	66	98.6	3	8	493	106	278	KAF4671046.1 hypothetical protein FOZ61_006864 [Perkinsus olseni]	diamond	4635	195	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
12370601	12370601	PRJNA911178_P_NODE_13110_length_924_cov_12.415981_g11261_i0	PRJNA911178	13110	924	12.415981	114.72366444	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	129	8.05e-32	NR	TEB19254.1	2494336	g11261	i0	33.7	0.866883116883117	267	155	80.8	8	83	829	1	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	801	129	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
18744891	18744891	PRJNA911178_P_NODE_62555_length_442_cov_8.983740_g60104_i0	PRJNA911178	62555	442	8.98374	39.7081308	Parvilucifera corolla	1955061	SAR_Eukaryotes	SAR_Eukaryotes	65.8	5.49e-6	NTclustered	gi\|1248939543\|gb\|MF197554.1\|	1955061	g60104	i0	97.368	0.712669683257919	38	1	9	0	70	107	305	268	Parvilucifera corolla strain Estartit_1 large subunit ribosomal RNA gene, partial sequence	blastn	315	65.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Parvilucifera	Parvilucifera corolla
27688308	27688308	PRJNA911178_P_NODE_21844_length_720_cov_7.001546_g19619_i0	PRJNA911178	21844	720	7.001546	50.4111312	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	122	1.17e-29	NR	TEB19254.1	2494336	g19619	i0	40.5	0.8125	195	107	77.5	3	642	85	3	197	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	585	122	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
29148100	29148100	PRJNA911178_P_NODE_45249_length_513_cov_1.543182_g42827_i0	PRJNA911178	45249	513	1.543182	7.91652366	Pelagophyceae	35675	SAR_Eukaryotes	SAR_Eukaryotes	77.8	4.54e-13	NR	KAF4701768.1	32597	g42827	i0	35.1	4.93567251461988	174	102	98.8	6	7	513	1639	1806	KAF4701768.1 hypothetical protein FOZ63_011987 [Perkinsus olseni]	diamond	2532	77.8	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29455684	29455684	PRJNA911178_P_NODE_270490_length_245_cov_1.244186_g268016_i0	PRJNA911178	270490	245	1.244186	3.0482557	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0428	NR	KAF4718902.1	32597	g268016	i0	46.7	0.955102040816327	45	18	47.8	1	2	118	51	95	KAF4718902.1 hypothetical protein FOZ62_014182, partial [Perkinsus olseni]	diamond	234	42.4	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30024705	30024705	PRJNA911178_P_NODE_70331_length_420_cov_2.175793_g67869_i0	PRJNA911178	70331	420	2.175793	9.1383306	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	196	4.2299999999999994e-61	NR	XP_002778466.1	423536	g67869	i0	70.1	0.978571428571429	137	40	97.1	1	11	418	52	188	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	411	196	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31825901	31825901	PRJNA911178_P_NODE_108197_length_349_cov_5.246377_g105725_i0	PRJNA911178	108197	349	5.246377	18.30985573	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	66.6	2.47e-10	NR	TEB19254.1	2494336	g105725	i0	63.8	0.404011461318052	47	17	40.4	0	3	143	217	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	141	66.6	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);;