metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA550047" 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
5617231	5617231	PRJNA550047_P_NODE_186665_length_344_cov_15.461255_g184704_i0	PRJNA550047	186665	344	15.461255	53.1867172	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	84.7	2.15e-16	NR	XP_002186434.1	556484	g184704	i0	89.8	1.28197674418605	49	5	42.7	0	198	344	139	187	XP_002186434.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1]	diamond	441	84.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
18370625	18370625	PRJNA550047_P_NODE_97255_length_345_cov_8.702206_g95295_i0	PRJNA550047	97255	345	8.702206	30.0226107	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	143	4.08e-38	NR	YP_010134181.1	138539	g95295	i0	59	58.1304347826087	134	35	99.1	1	1	342	122	255	YP_010134181.1 hypothetical protein RF45 [Navicula veneta]	diamond	20055	144	0.993055555555556	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Navicula	Navicula veneta
26698189	26698189	PRJNA550047_P_NODE_603061_length_197_cov_8.064516_g601088_i0	PRJNA550047	603061	197	8.064516	15.88709652	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	67.8	9.52e-12	NR	GKZ00577.1	2872254	g601088	i0	50	0.852791878172589	56	23	85.3	1	195	28	76	126	GKZ00577.1 hypothetical protein MPSEU_001009900 [Mayamaea pseudoterrestris]	diamond	168	67.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
27615221	27615221	PRJNA550047_P_NODE_158504_length_345_cov_4.169118_g156544_i0	PRJNA550047	158504	345	4.169118	14.3834571	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	83.6	5.8e-16	NR	GKY94691.1	2872254	g156544	i0	77.6	0.426086956521739	49	11	42.6	0	197	343	372	420	GKY94691.1 hypothetical protein MPSEU_000434600 [Mayamaea pseudoterrestris]	diamond	147	83.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
28531039	28531039	PRJNA550047_P_NODE_510127_length_227_cov_8.435065_g508154_i0	PRJNA550047	510127	227	8.435065	19.14759755	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	63.5	1.41e-9	NR	GFH59504.1	426638	g508154	i0	50.8	2.41850220264317	61	30	80.6	0	184	2	142	202	GFH59504.1 hypothetical protein CTEN210_15980 [Chaetoceros tenuissimus]	diamond	549	63.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
29604100	29604100	PRJNA550047_P_NODE_62690_length_345_cov_14.102941_g60730_i0	PRJNA550047	62690	345	14.102941	48.65514645	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	62.4	1.62e-8	NR	CAB9498246.1	568900	g60730	i0	58	0.434782608695652	50	21	43.5	0	196	345	917	966	CAB9498246.1 Lactococcin-G-processing and transport ATP-binding protein LagD [Seminavis robusta]	diamond	150	62.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
29698578	29698578	PRJNA550047_P_NODE_220690_length_301_cov_11.425439_g218721_i0	PRJNA550047	220690	301	11.425439	34.39057139	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	91.7	4.63e-19	NR	GKZ01346.1	2872254	g218721	i0	50	1.13621262458472	114	22	81.7	3	3	248	323	433	GKZ01346.1 hypothetical protein MPSEU_001085600 [Mayamaea pseudoterrestris]	diamond	342	91.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
30899754	30899754	PRJNA550047_P_NODE_529054_length_220_cov_18.625850_g527081_i0	PRJNA550047	529054	220	18.62585	40.97687	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	109	3.1100000000000004e-26	NR	YP_004376616.1	1519565	g527081	i0	77.8	0.981818181818182	72	16	98.2	0	3	218	91	162	YP_004376616.1 preprotein translocase subunit SecY [Fistulifera solaris]	diamond	216	109	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
31578223	31578223	PRJNA550047_P_NODE_296436_length_297_cov_15.977679_g294467_i0	PRJNA550047	296436	297	15.977679	47.45370663	root	1	Root_unresolved	Root_unresolved	103	1.99e-24	NR	OEU21956.1	635003	g294467	i0	48.4	7.16161616161616	91	44	88.9	1	34	297	44	134	OEU21956.1 Arginase/deacetylase [Fragilariopsis cylindrus CCMP1102]	diamond	2127	103	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
31830981	31830981	PRJNA550047_P_NODE_246557_length_300_cov_11.149780_g244588_i0	PRJNA550047	246557	300	11.14978	33.44934	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	55.8	1.89e-6	NR	GAX26976.1	1519565	g244588	i0	54.1	1.09	37	17	37	0	1	111	301	337	GAX26976.1 aminopeptidase 2 [Fistulifera solaris]	diamond	327	56.2	0.99288256227758	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);;