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

5 rows where analysis = "diamond", bioproject = "PRJNA1129273" 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
6661126	6661126	PRJNA1129273_P_NODE_5526_length_301_cov_1.017544_g5246_i0	PRJNA1129273	5526	301	1.017544	3.06280744	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	159	6.32e-48	NR	KAL1523551.1	97485	g5246	i0	84.7	0.976744186046512	98	15	97.7	0	296	3	1	98	KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum]	diamond	294	159	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
12510389	12510389	PRJNA1129273_P_NODE_10730_length_240_cov_2.275449_g10450_i0	PRJNA1129273	10730	240	2.275449	5.4610776	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	132	1.87e-37	NR	KAL1515397.1	97485	g10450	i0	79.5	4.8625	78	16	97.5	0	237	4	43	120	KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum]	diamond	1167	132	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
16860438	16860438	PRJNA1129273_P_NODE_4634_length_332_cov_1.961390_g4354_i0	PRJNA1129273	4634	332	1.96139	6.5118148	Haptophyta	2830	Haptophyta	other_Eukaryota	131	5.33e-36	NR	KAJ1627111.1	483367	g4354	i0	70.8	7.88855421686747	96	27	85.8	1	330	46	104	199	KAJ1627111.1 40S ribosomal protein S7 [Pavlovales sp. CCMP2436]	diamond	2619	131	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
29754322	29754322	PRJNA1129273_P_NODE_3991_length_360_cov_4.480836_g3711_i0	PRJNA1129273	3991	360	4.480836	16.1310096	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	93.2	9.12e-22	NR	XP_005782836.1	280463	g3711	i0	51	7.75833333333333	102	46	84.2	2	339	37	16	114	XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516]	diamond	2793	93.2	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29975555	29975555	PRJNA1129273_P_NODE_9871_length_245_cov_0.901163_g9591_i0	PRJNA1129273	9871	245	0.901163	2.20784935	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	72.4	1.39e-12	NR	KAG8467436.1	2081491	g9591	i0	55.7	0.746938775510204	61	27	74.7	0	184	2	693	753	KAG8467436.1 hypothetical protein KFE25_000752 [Diacronema lutheri]	diamond	183	72.4	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri

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