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

14 rows where bioproject = "PRJNA315314", 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
2931694	2931694	PRJNA315314_S_NODE_7183_length_301_cov_2.801471_g6862_i0	PRJNA315314	7183	301	2.801471	8.43242771	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	331	3.2100000000000002e-86	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g6862	i0	86.667	26.890365448505	300	38	99	2	3	301	357	59	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	8094	331	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
8034143	8034143	PRJNA315314_S_NODE_25567_length_166_cov_1.540146_g25246_i0	PRJNA315314	25567	166	1.540146	2.55664236	Nitzschia ovalis	908985	SAR_Eukaryotes	SAR_Eukaryotes	91.6	2.95e-14	NTclustered	gi\|2202538962\|gb\|OM891868.1\|	908985	g25246	i0	77.193	13.5963855421687	171	29	100	10	1	166	4049	3884	Nitzschia ovalis small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	2257	91.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia ovalis
12543788	12543788	PRJNA315314_S_NODE_22150_length_176_cov_7.816327_g21829_i0	PRJNA315314	22150	176	7.816327	13.75673552	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	122	1.1199999999999999e-23	NTclustered	gi\|2839792213\|gb\|PQ512811.1\|	37318	g21829	i0	80.114	101.0625	176	26	100	5	1	176	5037	5203	Pseudo-nitzschia pungens isolate CNS00141 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	17787	122	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia pungens
19506711	19506711	PRJNA315314_S_NODE_17216_length_198_cov_3.437870_g16895_i0	PRJNA315314	17216	198	3.43787	6.8069826	Attheya longicornis	451786	SAR_Eukaryotes	SAR_Eukaryotes	113	7.76e-21	NTclustered	gi\|2046217437\|gb\|MW729336.1\|	451786	g16895	i0	79.874	6.90909090909091	159	28	79	4	43	198	38496	38339	Attheya longicornis mitochondrion, complete genome	blastn	1368	113	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Attheyaceae	Attheya	Attheya longicornis
20782335	20782335	PRJNA315314_S_NODE_21437_length_179_cov_2.700000_g21116_i0	PRJNA315314	21437	179	2.7	4.833	Berkeleya fennica	1577906	SAR_Eukaryotes	SAR_Eukaryotes	185	1.43e-42	NTclustered	gi\|746001744\|ref\|NC_026126.1\|	1577906	g21116	i0	85.393	78.1061452513967	178	26	99	0	2	179	2978	3155	Berkeleya fennica mitochondrion, complete genome	blastn	13981	185	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Berkeleyaceae	Berkeleya	Berkeleya fennica
22057403	22057403	PRJNA315314_S_NODE_2858_length_467_cov_9.522831_g2543_i0	PRJNA315314	2858	467	9.522831	44.47162077	Minutocellus polymorphus	265543	SAR_Eukaryotes	SAR_Eukaryotes	132	5.67e-26	NTclustered	gi\|2020303798\|gb\|MW417227.1\|	265543	g2543	i0	78.404	2.5524625267666	213	38	45	7	151	359	8483	8691	Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome	blastn	1192	132	1	Eukaryota	Sar	Bacillariophyta	Mediophyceae	Cymatosirales	Cymatosiraceae	Minutocellus	Minutocellus polymorphus
26807069	26807069	PRJNA315314_S_NODE_20121_length_184_cov_3.619355_g19800_i0	PRJNA315314	20121	184	3.619355	6.6596132	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	68.9	4.88e-12	NR	KAI2491943.1	210448	g19800	i0	72.5	2.59239130434783	40	11	65.2	0	2	121	180	219	KAI2491943.1 Ribosomal protein S3 [Fragilaria crotonensis]	diamond	477	69.3	0.994227994227994	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
27060252	27060252	PRJNA315314_S_NODE_21542_length_179_cov_1.460000_g21221_i0	PRJNA315314	21542	179	1.46	2.6134	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	54.7	4.94e-8	NR	YP_005090352.1	2850	g21221	i0	82.9	2.93296089385475	35	6	58.7	0	55	159	1	35	YP_005090352.1 ATPase subunit 9 [Phaeodactylum tricornutum]	diamond	525	55.1	0.992740471869329	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
27801029	27801029	PRJNA315314_S_NODE_3644_length_419_cov_3.443590_g3324_i0	PRJNA315314	3644	419	3.44359	14.4286421	Pseudo-nitzschia multistriata	183589	SAR_Eukaryotes	SAR_Eukaryotes	77.8	7.65e-14	NR	VEU33732.1	183589	g3324	i0	60	0.823389021479714	55	22	39.4	0	416	252	274	328	VEU33732.1 unnamed protein product [Pseudo-nitzschia multistriata]	diamond	345	77.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia multistriata
28779549	28779549	PRJNA315314_S_NODE_8027_length_285_cov_4.726562_g7706_i0	PRJNA315314	8027	285	4.726562	13.4707017	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	72	3.52e-13	NR	KAI2504009.1	210448	g7706	i0	51.7	2.74736842105263	87	28	76.8	2	284	66	98	184	KAI2504009.1 ribosomal eL6-like protein [Fragilaria crotonensis]	diamond	783	72	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
29428404	29428404	PRJNA315314_S_NODE_21809_length_178_cov_1.503356_g21488_i0	PRJNA315314	21809	178	1.503356	2.67597368	root	1	Root_unresolved	Root_unresolved	102	2.07e-23	NR	KAL3774488.1	382360	g21488	i0	83.9	14.6292134831461	56	9	94.4	0	2	169	241	296	KAL3774488.1 hypothetical protein ACHAWO_007008 [Cyclotella atomus]	diamond	2604	103	0.990291262135922	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella atomus
29948045	29948045	PRJNA315314_S_NODE_25331_length_166_cov_7.043796_g25010_i0	PRJNA315314	25331	166	7.043796	11.69270136	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	85.5	5.23e-20	NR	AID23594.1	2850	g25010	i0	85.2	15.6144578313253	54	8	97.6	0	2	163	7	60	AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum]	diamond	2592	85.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
30376624	30376624	PRJNA315314_S_NODE_30552_length_154_cov_1.272000_g30231_i0	PRJNA315314	30552	154	1.272	1.95888	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.00319	NR	KAL3918850.1	3061772	g30231	i0	38.1	3.75974025974026	42	26	81.8	0	28	153	136	177	KAL3918850.1 MAG: hypothetical protein SGILL_004048 [Bacillariaceae sp.]	diamond	579	44.7	0.991051454138702	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
30674565	30674565	PRJNA315314_S_NODE_30533_length_154_cov_1.432000_g30212_i0	PRJNA315314	30533	154	1.432	2.20528	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	50.8	1.55e-5	NR	GFH45186.1	426638	g30212	i0	51.1	0.876623376623377	45	22	87.7	0	139	5	302	346	GFH45186.1 hypothetical protein CTEN210_01660 [Chaetoceros tenuissimus]	diamond	135	50.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus

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