metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA274362" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA274362" and tax_clade = "Haptista"

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_class	tax_order	tax_family	tax_genus	tax_species
14399392	14399392	PRJNA274362_S_NODE_15352_length_230_cov_0.922652_g15232_i0	PRJNA274362	15352	230	0.922652	2.1220996	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	90.9	1.1500000000000002e-21	NR	KAG8469654.1	2081491	g15232	i0	65.8	0.991304347826087	76	26	99.1	0	228	1	8	83	KAG8469654.1 hypothetical protein KFE25_006109 [Diacronema lutheri]	diamond	228	90.9	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
24596652	24596652	PRJNA274362_S_NODE_22700_length_196_cov_0.952381_g22580_i0	PRJNA274362	22700	196	0.952381	1.86666676	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	105	1.1399999999999999e-24	NR	KAJ1619127.1	483367	g22580	i0	71.2	2.02040816326531	66	17	98	1	194	3	779	844	KAJ1619127.1 thiamine diphosphate-binding protein [Pavlovales sp. CCMP2436]	diamond	396	105	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
27390303	27390303	PRJNA274362_S_NODE_10943_length_265_cov_1.217593_g10823_i0	PRJNA274362	10943	265	1.217593	3.22662145	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	115	8.91e-31	NR	KAL1515397.1	97485	g10823	i0	72	4.26792452830189	75	21	84.9	0	40	264	1	75	KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum]	diamond	1131	115	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
28116235	28116235	PRJNA274362_S_NODE_37605_length_162_cov_0.920354_g37485_i0	PRJNA274362	37605	162	0.920354	1.49097348	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	50.8	1.05e-5	NR	KAG8470665.1	2081491	g37485	i0	60	2.12962962962963	40	16	74.1	0	160	41	72	111	KAG8470665.1 hypothetical protein KFE25_009086 [Diacronema lutheri]	diamond	345	50.8	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
28432117	28432117	PRJNA274362_S_NODE_31966_length_169_cov_1.083333_g31846_i0	PRJNA274362	31966	169	1.083333	1.83083277	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	67.4	2.73e-11	NR	KAL1524241.1	97485	g31846	i0	50.9	0.976331360946746	55	27	97.6	0	168	4	284	338	KAL1524241.1 hypothetical protein AB1Y20_019146 [Prymnesium parvum]	diamond	165	67.4	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30232018	30232018	PRJNA274362_S_NODE_23792_length_192_cov_1.244755_g23672_i0	PRJNA274362	23792	192	1.244755	2.3899296	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	73.6	6.72e-15	NR	KAL1508698.1	97485	g23672	i0	60	0.859375	55	22	85.9	0	165	1	44	98	KAL1508698.1 hypothetical protein AB1Y20_004793 [Prymnesium parvum]	diamond	165	73.6	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum

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