metadata: contig_metadata: 7 rows where bioproject = "PRJNA1093380" and tax

7 rows where bioproject = "PRJNA1093380" 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
15501800	15501800	PRJNA1093380_P_NODE_16733_length_241_cov_2.321429_g16627_i0	PRJNA1093380	16733	241	2.321429	5.59464389	Fragilariopsis cylindrus CCMP11	186039	SAR_Eukaryotes	SAR_Eukaryotes	138	1.38e-36	NR	OEU15381.1	635003	g16627	i0	84.8	5.90041493775934	79	12	98.3	0	3	239	317	395	OEU15381.1 S-Adenosyl homocysteine hydrolase [Fragilariopsis cylindrus CCMP1102]	diamond	1422	138	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
23971575	23971575	PRJNA1093380_P_NODE_9379_length_265_cov_2.911458_g9273_i0	PRJNA1093380	9379	265	2.911458	7.7153637	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	100	1.76e-22	NR	GKZ00870.1	2872254	g9273	i0	56.3	1.94716981132075	87	38	98.5	0	2	262	649	735	GKZ00870.1 hypothetical protein MPSEU_001038700 [Mayamaea pseudoterrestris]	diamond	516	100	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
29530768	29530768	PRJNA1093380_P_NODE_11170_length_255_cov_1.461538_g11064_i0	PRJNA1093380	11170	255	1.461538	3.7269219	Pseudo-nitzschia multistriata	183589	SAR_Eukaryotes	SAR_Eukaryotes	95.1	8.360000000000001e-21	NR	VEU39975.1	183589	g11064	i0	65.7	1.63529411764706	67	22	77.6	1	43	240	310	376	VEU39975.1 unnamed protein product [Pseudo-nitzschia multistriata]	diamond	417	95.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia multistriata
29972801	29972801	PRJNA1093380_P_NODE_12371_length_250_cov_0.870056_g12265_i0	PRJNA1093380	12371	250	0.870056	2.17514	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	119	2.21e-29	NR	KAL3797964.1	29204	g12265	i0	65.1	5.028	86	27	99.6	1	2	250	368	453	KAL3797964.1 hypothetical protein HJC23_013202 [Cyclotella cryptica]	diamond	1257	119	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
29972802	29972802	PRJNA1093380_P_NODE_16391_length_242_cov_0.911243_g16285_i0	PRJNA1093380	16391	242	0.911243	2.20520806	Thalassiosira pseudonana CCMP1335	296543	SAR_Eukaryotes	SAR_Eukaryotes	48.1	4.71e-4	NR	XP_002287180.1	296543	g16285	i0	40.3	0.830578512396694	67	40	83.1	0	42	242	1350	1416	XP_002287180.1 predicted protein [Thalassiosira pseudonana CCMP1335]	diamond	201	48.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana
31299894	31299894	PRJNA1093380_P_NODE_16095_length_243_cov_0.905882_g15989_i0	PRJNA1093380	16095	243	0.905882	2.20129326	Cyclostephanos tholiformis	382380	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0497	NR	KAL3822218.1	382380	g15989	i0	30.8	0.802469135802469	65	45	80.2	0	235	41	358	422	KAL3822218.1 hypothetical protein ACHAXA_000658 [Cyclostephanos tholiformis]	diamond	195	42.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclostephanos	Cyclostephanos tholiformis
32565651	32565651	PRJNA1093380_P_NODE_3079_length_344_cov_1.398524_g2973_i0	PRJNA1093380	3079	344	1.398524	4.81092256	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	99.4	1.68e-21	NR	KAL3786977.1	29204	g2973	i0	57.1	2.51162790697674	98	40	83.7	1	288	1	607	704	KAL3786977.1 hypothetical protein HJC23_005488 [Cyclotella cryptica]	diamond	864	99.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica

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