metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA493244" 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
27392669	27392669	PRJNA493244_P_NODE_1399063_length_268_cov_6.425121_g1375938_i0	PRJNA493244	1399063	268	6.425121	17.21932428	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	119	6.97e-29	NR	GKY97346.1	2872254	g1375938	i0	66.7	0.906716417910448	81	27	90.7	0	23	265	550	630	GKY97346.1 hypothetical protein MPSEU_000693000 [Mayamaea pseudoterrestris]	diamond	243	119	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
27408739	27408739	PRJNA493244_P_NODE_1385303_length_272_cov_2.364929_g1362178_i0	PRJNA493244	1385303	272	2.364929	6.43260688	root	1	Root_unresolved	Root_unresolved	44.3	0.015	NR	KAI2491351.1	210448	g1362178	i0	36.6	3.38602941176471	71	45	78.3	0	256	44	262	332	KAI2491351.1 transposition [Fragilaria crotonensis]	diamond	921	44.3	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
28513586	28513586	PRJNA493244_P_NODE_1576787_length_225_cov_2.969512_g1553662_i0	PRJNA493244	1576787	225	2.969512	6.681402	Nitzschia	2857	SAR_Eukaryotes	SAR_Eukaryotes	65.1	1.58e-10	NR	KAG7344113.1	303405	g1553662	i0	55.3	2.50666666666667	47	21	62.7	0	190	50	187	233	KAG7344113.1 proteasome subunit alpha [Nitzschia inconspicua]	diamond	564	65.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
28750211	28750211	PRJNA493244_P_NODE_1578687_length_225_cov_1.560976_g1555562_i0	PRJNA493244	1578687	225	1.560976	3.512196	Haslea silbo	1146997	SAR_Eukaryotes	SAR_Eukaryotes	94.4	1.96e-20	NR	QUS63590.1	1146997	g1555562	i0	68.3	0.84	63	20	84	0	218	30	613	675	QUS63590.1 rt-like putative protein [Haslea silbo]	diamond	189	94.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Haslea	Haslea silbo
29286862	29286862	PRJNA493244_P_NODE_543789_length_688_cov_4.290271_g522970_i0	PRJNA493244	543789	688	4.290271	29.51706448	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	75.1	8.58e-12	NR	CAB9504729.1	568900	g522970	i0	37.5	0.523255813953488	120	59	52.3	2	67	426	245	348	CAB9504729.1 Mitochondrial aspartate-glutamate transporter AGC1 [Seminavis robusta]	diamond	360	75.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
29318467	29318467	PRJNA493244_P_NODE_1558269_length_229_cov_5.279762_g1535144_i0	PRJNA493244	1558269	229	5.279762	12.09065498	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	129	7.34e-33	NR	GAX29431.1	1519565	g1535144	i0	84.1	0.903930131004367	69	11	90.4	0	14	220	358	426	GAX29431.1 hypothetical protein FisN_16Hh128 [Fistulifera solaris]	diamond	207	129	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
29413197	29413197	PRJNA493244_P_NODE_999269_length_407_cov_2.748555_g976182_i0	PRJNA493244	999269	407	2.748555	11.18661885	Fragilariopsis cylindrus CCMP11	186039	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.0175	NR	OEU10709.1	635003	g976182	i0	35.8	0.390663390663391	53	34	39.1	0	236	78	87	139	OEU10709.1 D-aminoacid aminotransferase-like PLP-dependent enzyme [Fragilariopsis cylindrus CCMP1102]	diamond	159	45.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
30708293	30708293	PRJNA493244_P_NODE_1315294_length_292_cov_2.216450_g1292170_i0	PRJNA493244	1315294	292	2.21645	6.472034	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	58.9	1.09e-7	NR	GKY95217.1	2872254	g1292170	i0	44.3	1.5	70	39	71.9	0	29	238	225	294	GKY95217.1 hypothetical protein MPSEU_000484700 [Mayamaea pseudoterrestris]	diamond	438	58.9	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
32636892	32636892	PRJNA493244_P_NODE_1373780_length_275_cov_9.757009_g1350655_i0	PRJNA493244	1373780	275	9.757009	26.83177475	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	60.5	4.45e-9	NR	EJK58599.1	159749	g1350655	i0	71.1	0.414545454545455	38	11	41.5	0	21	134	107	144	EJK58599.1 hypothetical protein THAOC_21264 [Thalassiosira oceanica]	diamond	114	60.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica

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