metadata: contig_metadata: 5 rows where bioproject = "PRJNA526367" and tax

5 rows where bioproject = "PRJNA526367" 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_order	tax_family	tax_genus	tax_species
4322840	4322840	PRJNA526367_P_NODE_34824_length_200_cov_12.324503_g34614_i0	PRJNA526367	34824	200	12.324503	24.649006	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	244	2.67e-60	NTclustered	gi\|551569863\|ref\|XM_005770835.1\|	280463	g34614	i0	91.304	6.53	184	8	88	2	18	193	736	919	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	1306	244	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
17073186	17073186	PRJNA526367_P_NODE_3334_length_367_cov_3.433962_g3128_i0	PRJNA526367	3334	367	3.433962	12.60264054	Haptophyta environmental samples	171259	Haptophyta	other_Eukaryota	265	4.1099999999999995e-66	NTclustered	gi\|311909458\|gb\|HQ446272.1\|	171259	g3128	i0	100	64.5885558583106	143	0	64	0	1	143	1620	1478	Uncultured haptophyte clone BrayaSo_water_18S 18S ribosomal RNA gene, partial sequence	blastn	23704	265	1	Eukaryota	Haptista	Haptophyta				Haptophyta environmental samples
25340260	25340260	PRJNA526367_P_NODE_4880_length_332_cov_3.985866_g4671_i0	PRJNA526367	4880	332	3.985866	13.23307512	Emiliania	2902	Haptophyta	other_Eukaryota	235	2.8899999999999996e-57	NTclustered	gi\|1706993689\|gb\|MN194619.1\|	171259	g4671	i0	99.237	70.7259036144578	131	0	74	1	196	325	291	161	Haptophyta environmental samples clone cvl2 small subunit ribosomal RNA gene, partial sequence	blastn	23481	235	1	Eukaryota	Haptista	Haptophyta				Haptophyta environmental samples
29004204	29004204	PRJNA526367_P_NODE_55868_length_162_cov_6.610619_g55658_i0	PRJNA526367	55868	162	6.610619	10.70920278	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	54.7	7.23e-7	NR	XP_005773861.1	280463	g55658	i0	65.8	0.703703703703704	38	13	70.4	0	158	45	166	203	XP_005773861.1 hypothetical protein EMIHUDRAFT_241189 [Emiliania huxleyi CCMP1516]	diamond	114	54.7	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32163979	32163979	PRJNA526367_P_NODE_16238_length_324_cov_2.774545_g16029_i0	PRJNA526367	16238	324	2.774545	8.9895258	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	68.9	5.9e-11	NR	XP_005778159.1	280463	g16029	i0	39.6	0.981481481481482	106	23	98.1	1	322	5	201	265	XP_005778159.1 hypothetical protein EMIHUDRAFT_435152 [Emiliania huxleyi CCMP1516]	diamond	318	68.9	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi

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