metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB75230" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB75230" 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
16298989	16298989	PRJEB75230_P_NODE_8613_length_496_cov_1.799054_g8431_i0	PRJEB75230	8613	496	1.799054	8.92330784	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	211	1.17e-64	NR	KAF4741851.1	32597	g8431	i0	56.4	13.8629032258065	165	70	98.6	1	489	1	27	191	KAF4741851.1 hypothetical protein FOZ62_016568, partial [Perkinsus olseni]	diamond	6876	211	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
17573972	17573972	PRJEB75230_P_NODE_3594_length_717_cov_1.908385_g3421_i0	PRJEB75230	3594	717	1.908385	13.68312045	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	250	1.03e-80	NR	XP_002778466.1	423536	g3421	i0	65.4	0.774058577405858	185	63	77	1	19	570	6	190	XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983]	diamond	555	250	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
28423980	28423980	PRJEB75230_P_NODE_59126_length_300_cov_2.475771_g58944_i0	PRJEB75230	59126	300	2.475771	7.427313	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0161	NR	KAF4654741.1	32597	g58944	i0	38.8	0.49	49	30	49	0	282	136	8	56	KAF4654741.1 hypothetical protein FOZ61_008070 [Perkinsus olseni]	diamond	147	43.1	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28676554	28676554	PRJEB75230_P_NODE_136127_length_248_cov_0.880000_g135945_i0	PRJEB75230	136127	248	0.88	2.1824	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	52	2.21e-5	NR	TEB18997.1	2494336	g135945	i0	30.7	1.81451612903226	88	54	98	1	244	2	557	644	TEB18997.1 oxidoreductase [Perkinsus sp. BL_2016]	diamond	450	52	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
29339596	29339596	PRJEB75230_P_NODE_176949_length_242_cov_0.911243_g176767_i0	PRJEB75230	176949	242	0.911243	2.20520806	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	83.2	1.75e-16	NR	KAF4720405.1	32597	g176767	i0	64.7	5.05785123966942	68	22	84.3	1	218	15	39	104	KAF4720405.1 hypothetical protein FOZ62_008038 [Perkinsus olseni]	diamond	1224	83.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);;