metadata: contig_metadata: 10 rows where bioproject = "PRJNA934332", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA934332", 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
1255418	1255418	PRJNA934332_P_NODE_11341_length_241_cov_0.916667_g11254_i0	PRJNA934332	11341	241	0.916667	2.20916747	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	88.2	3.55e-18	NR	CAJ1955309.1	2856	g11254	i0	50	0.995850622406639	80	39	99.6	1	240	1	380	458	CAJ1955309.1 unnamed protein product [Cylindrotheca closterium]	diamond	240	88.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
6013844	6013844	PRJNA934332_P_NODE_3965_length_328_cov_1.458824_g3878_i0	PRJNA934332	3965	328	1.458824	4.78494272	Asterionellopsis glacialis	33640	SAR_Eukaryotes	SAR_Eukaryotes	248	3.67e-61	NTclustered	gi\|225685848\|dbj\|AB461922.1\|	33640	g3878	i0	81.973	41.7987804878049	294	51	89	2	2	294	115	407	Asterionellopsis glacialis MAT mRNA for methionine S-adenosyl transferase, complete cds	blastn	13710	248	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Asterionellopsis	Asterionellopsis glacialis
10184102	10184102	PRJNA934332_P_NODE_11308_length_241_cov_0.916667_g11221_i0	PRJNA934332	11308	241	0.916667	2.20916747	Cyclostephanos tholiformis	382380	SAR_Eukaryotes	SAR_Eukaryotes	119	5.76e-29	NR	KAL3815529.1	382380	g11221	i0	63.2	0.946058091286307	76	28	94.6	0	14	241	714	789	KAL3815529.1 hypothetical protein ACHAXA_007385 [Cyclostephanos tholiformis]	diamond	228	119	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclostephanos	Cyclostephanos tholiformis
21312652	21312652	PRJNA934332_P_NODE_10837_length_242_cov_0.911243_g10750_i0	PRJNA934332	10837	242	0.911243	2.20520806	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	76.6	5.01e-15	NR	KAL3763406.1	259834	g10750	i0	76.1	3.33471074380165	46	11	57	0	240	103	94	139	KAL3763406.1 hypothetical protein ACHAWU_001979 [Discostella pseudostelligera]	diamond	807	77	0.994805194805195	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera
27593823	27593823	PRJNA934332_P_NODE_1364_length_519_cov_1.762332_g1279_i0	PRJNA934332	1364	519	1.762332	9.14650308	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	224	1.86e-69	NR	CAJ1937478.1	2856	g1279	i0	65.7	0.976878612716763	169	57	97.1	1	509	6	95	263	CAJ1937478.1 unnamed protein product [Cylindrotheca closterium]	diamond	507	224	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
28390005	28390005	PRJNA934332_P_NODE_10246_length_244_cov_0.900585_g10159_i0	PRJNA934332	10246	244	0.900585	2.1974274	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0205	NR	KAI2494853.1	210448	g10159	i0	58.8	0.823770491803279	34	14	41.8	0	234	133	38	71	KAI2494853.1 serine/threonine kinase [Fragilaria crotonensis]	diamond	201	43.5	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
29109386	29109386	PRJNA934332_P_NODE_6048_length_276_cov_1.517241_g5961_i0	PRJNA934332	6048	276	1.517241	4.18758516	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	114	2.8700000000000003e-27	NR	GKY94063.1	2872254	g5961	i0	58.7	13	92	38	100	0	1	276	449	540	GKY94063.1 proteasome regulatory particle base subunit [Mayamaea pseudoterrestris]	diamond	3588	114	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
29393508	29393508	PRJNA934332_P_NODE_2289_length_410_cov_1.181009_g2202_i0	PRJNA934332	2289	410	1.181009	4.8421369	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	107	1.18e-26	NR	CAB9498408.1	568900	g2202	i0	42.1	0.921951219512195	126	73	92.2	0	31	408	27	152	CAB9498408.1 60S ribosomal protein L14 [Seminavis robusta]	diamond	378	107	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
30088082	30088082	PRJNA934332_P_NODE_8692_length_248_cov_0.880000_g8605_i0	PRJNA934332	8692	248	0.88	2.1824	Discostella pseudostelligera	259834	SAR_Eukaryotes	SAR_Eukaryotes	92	1.81e-19	NR	KAL3758788.1	259834	g8605	i0	69	0.701612903225806	58	18	70.2	0	247	74	61	118	KAL3758788.1 hypothetical protein ACHAWU_010081 [Discostella pseudostelligera]	diamond	174	92	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera
31858132	31858132	PRJNA934332_P_NODE_8257_length_249_cov_0.875000_g8170_i0	PRJNA934332	8257	249	0.875	2.17875	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	139	2.66e-36	NR	GAX17011.1	1519565	g8170	i0	72.3	1.97590361445783	83	22	98.8	1	248	3	316	398	GAX17011.1 hypothetical protein FisN_5Hh393 [Fistulifera solaris]	diamond	492	139	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris

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