metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA781196" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA781196" 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
26841615	26841615	PRJNA781196_P_NODE_39881_length_283_cov_1.547619_g39504_i0	PRJNA781196	39881	283	1.547619	4.37976177	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	106	3.1600000000000003e-27	NR	KAF4697926.1	32597	g39504	i0	56.2	11.5441696113074	89	39	94.3	0	17	283	9	97	KAF4697926.1 60S ribosomal protein L5, partial [Perkinsus olseni]	diamond	3267	107	0.990654205607477	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28032822	28032822	PRJNA781196_P_NODE_41125_length_279_cov_1.674757_g40748_i0	PRJNA781196	41125	279	1.674757	4.67257203	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.003	NR	XP_002788722.1	423536	g40748	i0	53.1	0.344086021505376	32	15	34.4	0	133	228	44	75	XP_002788722.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	96	45.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
29390498	29390498	PRJNA781196_P_NODE_6549_length_608_cov_2.822430_g6178_i0	PRJNA781196	6549	608	2.82243	17.1603744	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	295	1.77e-97	NR	XP_002774056.1	423536	g6178	i0	77	1.80592105263158	183	42	90.3	0	2	550	133	315	XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983]	diamond	1098	295	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30685310	30685310	PRJNA781196_P_NODE_52753_length_251_cov_1.314607_g52376_i0	PRJNA781196	52753	251	1.314607	3.29966357	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	71.2	2.77e-12	NR	KAF4661988.1	330153	g52376	i0	44	1.88844621513944	75	42	89.6	0	227	3	64	138	KAF4661988.1 hypothetical protein FOL47_006471 [Perkinsus chesapeaki]	diamond	474	71.2	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
31263624	31263624	PRJNA781196_P_NODE_37675_length_290_cov_1.437788_g37298_i0	PRJNA781196	37675	290	1.437788	4.1695852	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	105	6.91e-26	NR	KAF4701760.1	32597	g37298	i0	56.3	5.73103448275862	96	41	99.3	1	3	290	3	97	KAF4701760.1 hypothetical protein FOZ62_030128, partial [Perkinsus olseni]	diamond	1662	105	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32645500	32645500	PRJNA781196_P_NODE_59560_length_247_cov_0.896552_g59183_i0	PRJNA781196	59560	247	0.896552	2.21448344	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	49.7	1.24e-4	NR	TEB18264.1	2494336	g59183	i0	41.8	0.668016194331984	55	30	66.8	1	170	6	25	77	TEB18264.1 hypothetical protein C9890_0425 [Perkinsus sp. BL_2016]	diamond	165	49.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
32708676	32708676	PRJNA781196_P_NODE_27380_length_332_cov_1.806950_g27003_i0	PRJNA781196	27380	332	1.80695	5.999074	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	78.2	3.76e-14	NR	KAF4744263.1	32597	g27003	i0	76.1	0.41566265060241	46	11	41.6	0	326	189	414	459	KAF4744263.1 U4 u6 small nuclear ribonucleoprotein, partial [Perkinsus olseni]	diamond	138	78.2	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);;