metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB76780" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB76780" 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
996412	996412	PRJEB76780_P_NODE_4461_length_385_cov_1.000000_g4361_i0	PRJEB76780	4461	385	1	3.85	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	168	2.64e-51	NR	CAJ1934332.1	2856	g4361	i0	63.9	0.950649350649351	122	44	95.1	0	370	5	1	122	CAJ1934332.1 unnamed protein product [Cylindrotheca closterium]	diamond	366	168	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
6516967	6516967	PRJEB76780_P_NODE_9686_length_261_cov_1.186170_g9586_i0	PRJEB76780	9686	261	1.18617	3.0959037	Naviculaceae	67474	SAR_Eukaryotes	SAR_Eukaryotes	151	2.11e-41	NR	CAB9510954.1	568900	g9586	i0	86	2.96551724137931	86	11	98.9	1	259	2	319	403	CAB9510954.1 adenosylhomocysteinase [Seminavis robusta]	diamond	774	152	0.993421052631579	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
23090712	23090712	PRJEB76780_P_NODE_3519_length_435_cov_6.964088_g3419_i0	PRJEB76780	3519	435	6.964088	30.2937828	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	134	1.33e-37	NR	EJK75259.1	159749	g3419	i0	64.1	0.710344827586207	103	36	70.3	1	100	405	9	111	EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica]	diamond	309	134	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
27160388	27160388	PRJEB76780_P_NODE_8622_length_276_cov_1.527094_g8522_i0	PRJEB76780	8622	276	1.527094	4.21477944	Halamphora sp.	1951536	SAR_Eukaryotes	SAR_Eukaryotes	55.8	8.22e-7	NR	XCD23995.1	1951536	g8522	i0	54.3	0.5	46	21	50	0	18	155	191	236	XCD23995.1 ribosomal protein S4 [Halamphora sp.]	diamond	138	55.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Amphipleuraceae	Halamphora	Halamphora sp.
28265801	28265801	PRJEB76780_P_NODE_4346_length_390_cov_1.596215_g4246_i0	PRJEB76780	4346	390	1.596215	6.2252385	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	84.3	3.41e-16	NR	GFH49118.1	426638	g4246	i0	50	0.630769230769231	82	39	62.3	2	243	1	13	93	GFH49118.1 cyclin-domain-containing protein [Chaetoceros tenuissimus]	diamond	246	84.3	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
28708181	28708181	PRJEB76780_P_NODE_2167_length_564_cov_1.788187_g2067_i0	PRJEB76780	2167	564	1.788187	10.08537468	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	51.2	9.12e-4	NR	CAB9513789.1	568900	g2067	i0	29.9	0.781914893617021	147	75	73.4	8	527	114	1184	1311	CAB9513789.1 lectin domain family 4 member M [Seminavis robusta]	diamond	441	51.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
29963846	29963846	PRJEB76780_P_NODE_7571_length_293_cov_1.772727_g7471_i0	PRJEB76780	7571	293	1.772727	5.19409011	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	67	1.86e-10	NR	CAJ1930937.1	2856	g7471	i0	62.1	7.08532423208191	58	13	50.2	1	144	290	5	62	CAJ1930937.1 unnamed protein product [Cylindrotheca closterium]	diamond	2076	67.4	0.99406528189911	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
30887327	30887327	PRJEB76780_P_NODE_10754_length_251_cov_1.831461_g10654_i0	PRJEB76780	10754	251	1.831461	4.59696711	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	50.4	7.75e-5	NR	GKY98274.1	2872254	g10654	i0	63.2	0.908366533864542	38	14	45.4	0	134	247	13	50	GKY98274.1 hypothetical protein MPSEU_000785000 [Mayamaea pseudoterrestris]	diamond	228	50.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
32152307	32152307	PRJEB76780_P_NODE_9598_length_262_cov_1.238095_g9498_i0	PRJEB76780	9598	262	1.238095	3.2438089	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	49.3	2.37e-4	NR	KAK1743435.1	267567	g9498	i0	43.7	5.26717557251908	71	32	72.1	2	189	1	564	634	KAK1743435.1 GABA-B receptor-like protein [Skeletonema marinoi]	diamond	1380	49.3	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
32310780	32310780	PRJEB76780_P_NODE_11179_length_250_cov_0.881356_g11079_i0	PRJEB76780	11179	250	0.881356	2.20339	Fragilariopsis cylindrus CCMP11	186039	SAR_Eukaryotes	SAR_Eukaryotes	83.2	2.3e-16	NR	OEU12046.1	635003	g11079	i0	51.8	1.992	83	39	99.6	1	249	1	267	348	OEU12046.1 nitrate transporter [Fragilariopsis cylindrus CCMP1102]	diamond	498	83.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus

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