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

6 rows where analysis = "diamond", bioproject = "PRJNA1218816" and tax_phylum = "Bacillariophyta"

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
2884437	2884437	PRJNA1218816_P_NODE_58023_length_246_cov_1.393064_g57590_i0	PRJNA1218816	58023	246	1.393064	3.42693744	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	138	2.67e-36	NR	GKY98155.1	2872254	g57590	i0	79	0.98780487804878	81	17	98.8	0	245	3	148	228	GKY98155.1 Inositol monophosphatase 2 [Mayamaea pseudoterrestris]	diamond	243	138	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
7987003	7987003	PRJNA1218816_P_NODE_8047_length_953_cov_1.629545_g7710_i0	PRJNA1218816	8047	953	1.629545	15.52956385	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	350	2.039999999999999e-118	NR	XP_002181180.1	556484	g7710	i0	79.2	6.32423924449108	212	44	66.7	0	927	292	6	217	XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1]	diamond	6027	350	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
20734812	20734812	PRJNA1218816_P_NODE_38697_length_312_cov_1.196653_g38264_i0	PRJNA1218816	38697	312	1.196653	3.73355736	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	152	3.86e-40	NR	CAB9501098.1	568900	g38264	i0	76	1	104	24	100	1	1	312	335	437	CAB9501098.1 NAD(P) transhydrogenase [Seminavis robusta]	diamond	312	152	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
22723178	22723178	PRJNA1218816_P_NODE_45038_length_283_cov_1.466667_g44605_i0	PRJNA1218816	45038	283	1.466667	4.15066761	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	120	1.6699999999999998e-32	NR	GFH58943.1	426638	g44605	i0	74.7	0.92226148409894	87	22	92.2	0	21	281	25	111	GFH58943.1 hypothetical protein CTEN210_15419 [Chaetoceros tenuissimus]	diamond	261	120	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
27862290	27862290	PRJNA1218816_P_NODE_52345_length_255_cov_2.263736_g51912_i0	PRJNA1218816	52345	255	2.263736	5.7725268	Cyclostephanos tholiformis	382380	SAR_Eukaryotes	SAR_Eukaryotes	110	8.84e-26	NR	KAL3808413.1	382380	g51912	i0	65.5	1.97647058823529	84	29	98.8	0	255	4	626	709	KAL3808413.1 hypothetical protein ACHAXA_001350 [Cyclostephanos tholiformis]	diamond	504	110	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclostephanos	Cyclostephanos tholiformis
29883343	29883343	PRJNA1218816_P_NODE_49631_length_265_cov_1.526042_g49198_i0	PRJNA1218816	49631	265	1.526042	4.0440113	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	165	4.7e-47	NR	KAK1739474.1	267567	g49198	i0	85.2	8.92075471698113	88	13	99.6	0	264	1	246	333	KAK1739474.1 fucoxanthin-chlorophyll a-c binding protein [Skeletonema marinoi]	diamond	2364	165	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi

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