metadata: contig_metadata: 14 rows where bioproject = "PRJNA540466", tax_clade = "Sar" and tax

14 rows where bioproject = "PRJNA540466", tax_clade = "Sar" 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
3058808	3058808	PRJNA540466_S_NODE_22063_length_378_cov_2.150820_g21514_i0	PRJNA540466	22063	378	2.15082	8.1300996	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	302	3.24e-77	NTclustered	gi\|657012465\|gb\|KF302574.1\|	2850	g21514	i0	90.086	1.7962962962963	232	23	61	0	14	245	113	344	Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds	blastn	679	302	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
10711887	10711887	PRJNA540466_S_NODE_13809_length_467_cov_4.078680_g13264_i0	PRJNA540466	13809	467	4.07868	19.0474356	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	220	1.4499999999999998e-68	NR	AAX09600.1	29204	g13264	i0	89.7	2.3576017130621	117	12	75.2	0	466	116	213	329	AAX09600.1 elongation factor 1 alpha, partial [Cyclotella cryptica]	diamond	1101	220	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
17696411	17696411	PRJNA540466_S_NODE_52014_length_260_cov_1.529412_g51465_i0	PRJNA540466	52014	260	1.529412	3.9764712	root	1	Root_unresolved	Root_unresolved	91.6	5.02e-14	NTclustered	gi\|2074156200\|gb\|MW413905.1\|	216802	g51465	i0	90	24.7615384615385	70	7	27	0	117	186	24609	24540	Guinardia delicatula mitochondrion, complete genome	blastn	6438	91.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Rhizosoleniales	Rhizosoleniaceae	Guinardia	Guinardia delicatula
18359777	18359777	PRJNA540466_S_NODE_64055_length_240_cov_4.604790_g63506_i0	PRJNA540466	64055	240	4.60479	11.051496	root	1	Root_unresolved	Root_unresolved	68.9	2.11e-11	NR	YP_010131923.1	1335017	g63506	i0	53.8	9.725	65	30	81.3	0	16	210	53	117	YP_010131923.1 NADH dehydrogenase subunit 4 [Odontella regia]	diamond	2334	69.3	0.994227994227994	Eukaryota	Sar	Bacillariophyta	Mediophyceae	Eupodiscales	Parodontellaceae	Trieres	Trieres regia
27124004	27124004	PRJNA540466_S_NODE_17422_length_421_cov_5.439655_g16873_i0	PRJNA540466	17422	421	5.439655	22.90094755	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	107	1.03e-25	NR	KAL3786048.1	29204	g16873	i0	66.2	7.67458432304038	74	25	52.7	0	2	223	158	231	KAL3786048.1 hypothetical protein HJC23_003896 [Cyclotella cryptica]	diamond	3231	107	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
28513903	28513903	PRJNA540466_S_NODE_26547_length_347_cov_1.405109_g25998_i0	PRJNA540466	26547	347	1.405109	4.87572823	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	53.9	1.5e-5	NR	KAG7352108.1	303405	g25998	i0	50	1.14121037463977	44	22	38	0	5	136	866	909	KAG7352108.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Nitzschia inconspicua]	diamond	396	54.3	0.992633517495396	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
28657003	28657003	PRJNA540466_S_NODE_35307_length_306_cov_1.669528_g34758_i0	PRJNA540466	35307	306	1.669528	5.10875568	Fragilariopsis cylindrus CCMP11	186039	SAR_Eukaryotes	SAR_Eukaryotes	63.2	6.07e-10	NR	OEU18810.1	635003	g34758	i0	46.2	0.764705882352941	78	37	72.5	2	290	69	63	139	OEU18810.1 hypothetical protein FRACYDRAFT_237091 [Fragilariopsis cylindrus CCMP1102]	diamond	234	63.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
29618608	29618608	PRJNA540466_S_NODE_70510_length_212_cov_4.309353_g69961_i0	PRJNA540466	70510	212	4.309353	9.13582836	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	76.3	3.83e-14	NR	CAJ1946837.1	2856	g69961	i0	83.8	7.5	37	6	52.4	0	189	79	183	219	CAJ1946837.1 unnamed protein product [Cylindrotheca closterium]	diamond	1590	77	0.990909090909091	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
30299425	30299425	PRJNA540466_S_NODE_62532_length_243_cov_1.605882_g61983_i0	PRJNA540466	62532	243	1.605882	3.90229326	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	52.8	2.78e-6	NR	KAG7362121.1	303405	g61983	i0	57.1	0.975308641975309	42	18	51.9	0	151	26	6	47	KAG7362121.1 hypothetical protein IV203_025787 [Nitzschia inconspicua]	diamond	237	52.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
31009005	31009005	PRJNA540466_S_NODE_39434_length_292_cov_1.369863_g38885_i0	PRJNA540466	39434	292	1.369863	3.99999996	root	1	Root_unresolved	Root_unresolved	52.4	2.8e-5	NR	CAB9515627.1	568900	g38885	i0	66.7	3.35958904109589	33	11	33.9	0	1	99	509	541	CAB9515627.1 Hybrid signal transduction histidine kinase [Seminavis robusta]	diamond	981	52.8	0.992424242424242	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
31293380	31293380	PRJNA540466_S_NODE_55195_length_254_cov_1.270718_g54646_i0	PRJNA540466	55195	254	1.270718	3.22762372	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	90.1	8.47e-19	NR	XP_002177350.1	556484	g54646	i0	72.4	2.06692913385827	58	16	68.5	0	231	58	465	522	XP_002177350.1 glutamate-trna ligase [Phaeodactylum tricornutum CCAP 1055/1]	diamond	525	90.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
31799335	31799335	PRJNA540466_S_NODE_25377_length_354_cov_5.053381_g24828_i0	PRJNA540466	25377	354	5.053381	17.88896874	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	86.3	2.68e-17	NR	KAG7361485.1	303405	g24828	i0	42.2	4.15254237288136	83	48	70.3	0	353	105	246	328	KAG7361485.1 GDP-L-fucose synthase [Nitzschia inconspicua]	diamond	1470	86.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
32322833	32322833	PRJNA540466_S_NODE_71119_length_207_cov_4.082090_g70570_i0	PRJNA540466	71119	207	4.08209	8.4499263	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	60.5	1.29e-8	NR	GFH58819.1	426638	g70570	i0	63.8	0.681159420289855	47	15	65.2	1	203	69	950	996	GFH58819.1 hypothetical protein CTEN210_15295 [Chaetoceros tenuissimus]	diamond	141	60.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
32842202	32842202	PRJNA540466_S_NODE_21960_length_379_cov_1.408497_g21411_i0	PRJNA540466	21960	379	1.408497	5.33820363	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	73.2	5.43e-13	NR	XP_002178545.1	556484	g21411	i0	33.6	1.79683377308707	116	70	87.9	3	378	46	88	201	XP_002178545.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	681	73.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum

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