metadata: contig_metadata: 7 rows where bioproject = "PRJNA797475", tax_clade = "Haptista" and tax

7 rows where bioproject = "PRJNA797475", tax_clade = "Haptista" and tax_phylum = "Haptophyta"

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
781299	781299	PRJNA797475_P_NODE_15021_length_283_cov_1.838095_g14922_i0	PRJNA797475	15021	283	1.838095	5.20180885	Dicrateria rotunda	2703868	Haptophyta	other_Eukaryota	233	8.689999999999999e-57	NTclustered	gi\|259419571\|emb\|FN392586.1\|	2703868	g14922	i0	82.824	71.6572438162544	262	43	92	2	23	283	274	14	Imantonia rotunda partial mRNA for guanine nucleotide-binding protein subunit beta-2-like 1, contig 15549	blastn	20279	233	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Dicrateria	Dicrateria rotunda
14809826	14809826	PRJNA797475_P_NODE_12132_length_306_cov_1.892704_g12033_i0	PRJNA797475	12132	306	1.892704	5.79167424	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	150	3.82e-45	NR	XP_005758635.1	280463	g12033	i0	86.4	0.794117647058823	81	11	79.4	0	29	271	3	83	XP_005758635.1 hypothetical protein EMIHUDRAFT_425447 [Emiliania huxleyi CCMP1516]	diamond	243	150	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
26714475	26714475	PRJNA797475_P_NODE_5901_length_415_cov_1.798246_g5803_i0	PRJNA797475	5901	415	1.798246	7.4627209	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	80.5	2.84e-16	NR	KAL1510948.1	97485	g5803	i0	45.1	2.93493975903614	102	44	72.3	2	343	44	45	136	KAL1510948.1 hypothetical protein AB1Y20_005775 [Prymnesium parvum]	diamond	1218	80.9	0.995055624227441	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
28452759	28452759	PRJNA797475_P_NODE_26426_length_245_cov_1.674419_g26327_i0	PRJNA797475	26426	245	1.674419	4.10232655	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47	0.00124	NR	KAL1519075.1	97485	g26327	i0	46.8	1.53061224489796	47	25	57.6	0	53	193	25	71	KAL1519075.1 hypothetical protein AB1Y20_003342 [Prymnesium parvum]	diamond	375	47	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29327470	29327470	PRJNA797475_P_NODE_12449_length_302_cov_5.052402_g12350_i0	PRJNA797475	12449	302	5.052402	15.25825404	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	84.7	9.44e-19	NR	XP_005782836.1	280463	g12350	i0	52.6	1.93708609271523	95	41	93.4	2	20	301	16	107	XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516]	diamond	585	84.7	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29832751	29832751	PRJNA797475_P_NODE_16811_length_274_cov_1.502488_g16712_i0	PRJNA797475	16811	274	1.502488	4.11681712	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	45.8	0.00427	NR	XP_005762481.1	280463	g16712	i0	56.3	0.843065693430657	32	14	35	0	179	274	214	245	XP_005762481.1 hypothetical protein EMIHUDRAFT_216215 [Emiliania huxleyi CCMP1516]	diamond	231	45.8	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31412742	31412742	PRJNA797475_P_NODE_16316_length_277_cov_1.132353_g16217_i0	PRJNA797475	16316	277	1.132353	3.13661781	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	95.5	1.11e-22	NR	KAJ1638552.1	483367	g16217	i0	68.1	1.63537906137184	72	23	78	0	62	277	4	75	KAJ1638552.1 transcription factor [Pavlovales sp. CCMP2436]	diamond	453	95.5	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436

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