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

7 rows where bioproject = "PRJDB9741", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

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
1285391	1285391	PRJDB9741_P_NODE_7202_length_234_cov_1.091892_g6885_i0	PRJDB9741	7202	234	1.091892	2.55502728	Dicrateria rotunda	2703868	Haptophyta	other_Eukaryota	156	1.55e-33	NTclustered	gi\|259419557\|emb\|FN392572.1\|	2703868	g6885	i0	87.5	20.3034188034188	136	15	58	2	1	135	452	318	Imantonia rotunda partial mRNA for 40S ribosomal protein S4, contig 03105	blastn	4751	156	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Dicrateria	Dicrateria rotunda
27406050	27406050	PRJDB9741_P_NODE_19903_length_178_cov_1.534884_g19586_i0	PRJDB9741	19903	178	1.534884	2.73209352	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	80.5	1.78e-17	NR	XP_005789979.1	280463	g19586	i0	72.9	4.95505617977528	59	16	99.4	0	2	178	9	67	XP_005789979.1 hypothetical protein EMIHUDRAFT_417676 [Emiliania huxleyi CCMP1516]	diamond	882	81.3	0.990159901599016	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
28927322	28927322	PRJDB9741_P_NODE_22768_length_173_cov_2.112903_g22451_i0	PRJDB9741	22768	173	2.112903	3.65532219	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	74.7	5.62e-14	NR	KAJ1634206.1	483367	g22451	i0	64.9	0.988439306358382	57	20	98.8	0	171	1	35	91	KAJ1634206.1 hypothetical protein T492DRAFT_974641 [Pavlovales sp. CCMP2436]	diamond	171	74.7	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
30411999	30411999	PRJDB9741_P_NODE_11653_length_197_cov_1.567568_g11336_i0	PRJDB9741	11653	197	1.567568	3.08810896	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	90.1	3.75e-19	NR	KAL1504882.1	97485	g11336	i0	72.7	3.51776649746193	55	15	83.8	0	195	31	320	374	KAL1504882.1 hypothetical protein AB1Y20_008652 [Prymnesium parvum]	diamond	693	90.1	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31770849	31770849	PRJDB9741_P_NODE_24997_length_170_cov_1.685950_g24680_i0	PRJDB9741	24997	170	1.68595	2.866115	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	67.8	4.07e-12	NR	KAL1503052.1	97485	g24680	i0	55.9	9.2470588235294109	59	22	97.1	1	169	5	92	150	KAL1503052.1 hypothetical protein AB1Y20_011119 [Prymnesium parvum]	diamond	1572	67.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32687720	32687720	PRJDB9741_P_NODE_27180_length_167_cov_1.567797_g26863_i0	PRJDB9741	27180	167	1.567797	2.61822099	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	41.2	0.0453	NR	KAJ1637674.1	483367	g26863	i0	32.7	0.934131736526946	52	34	93.4	1	6	161	104	154	KAJ1637674.1 translocon-associated protein [Pavlovales sp. CCMP2436]	diamond	156	41.2	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
32750834	32750834	PRJDB9741_P_NODE_33140_length_164_cov_1.686957_g32823_i0	PRJDB9741	33140	164	1.686957	2.76660948	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	49.3	5.92e-5	NR	KAL1528863.1	97485	g32823	i0	46	0.914634146341463	50	25	91.5	1	158	9	174	221	KAL1528863.1 hypothetical protein AB1Y20_010186 [Prymnesium parvum]	diamond	150	49.3	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);;