metadata: contig_metadata: 7 rows where bioproject = "PRJNA1087264", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA1087264", 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
6571969	6571969	PRJNA1087264_P_NODE_546_length_893_cov_5.094787_g489_i0	PRJNA1087264	546	893	5.094787	45.49644791	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	169	2.3599999999999996e-47	NR	TEB19254.1	2494336	g489	i0	41.4	0.893617021276596	266	142	86	6	51	818	2	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	798	169	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
7846758	7846758	PRJNA1087264_P_NODE_587_length_868_cov_2.477411_g526_i0	PRJNA1087264	587	868	2.477411	21.50392748	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	130	3.6199999999999996e-32	NR	TEB19254.1	2494336	g526	i0	34.1	0.922811059907834	267	154	86.1	7	826	80	1	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	801	130	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
10397390	10397390	PRJNA1087264_P_NODE_2869_length_390_cov_1.369501_g2788_i0	PRJNA1087264	2869	390	1.369501	5.3410539	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	191	1.56e-57	NR	XP_002774056.1	423536	g2788	i0	68.9	2.03076923076923	132	39	100	1	1	390	99	230	XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	792	191	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
15496718	15496718	PRJNA1087264_P_NODE_2153_length_458_cov_3.672372_g2072_i0	PRJNA1087264	2153	458	3.672372	16.81946376	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	112	2.5800000000000004e-27	NR	TEB19254.1	2494336	g2072	i0	48.1	0.858078602620087	131	65	85.8	2	16	408	136	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	393	112	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
27257146	27257146	PRJNA1087264_P_NODE_443_length_970_cov_15.374593_g390_i0	PRJNA1087264	443	970	15.374593	149.1335521	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	125	6.73e-30	NR	TEB19254.1	2494336	g390	i0	32.6	0.825773195876289	267	155	76.1	6	50	787	1	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	801	125	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
28330736	28330736	PRJNA1087264_P_NODE_2586_length_413_cov_3.148352_g2505_i0	PRJNA1087264	2586	413	3.148352	13.00269376	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	65.9	9.45e-10	NR	TEB19254.1	2494336	g2505	i0	37.5	0.929782082324455	128	71	86.4	3	51	407	3	130	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	384	65.9	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
32650905	32650905	PRJNA1087264_P_NODE_8700_length_214_cov_0.927273_g8618_i0	PRJNA1087264	8700	214	0.927273	1.98436422	Eustigmatophyceae	5747	SAR_Eukaryotes	SAR_Eukaryotes	90.5	1.19e-21	NR	XP_002779756.1	423536	g8618	i0	68.8	1.83644859813084	64	20	89.7	0	7	198	39	102	XP_002779756.1 cysteinyl-tRNA synthetase, putative, partial [Perkinsus marinus ATCC 50983]	diamond	393	90.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus

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);;