metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA846486" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA846486" 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
28475982	28475982	PRJNA846486_P_NODE_70206_length_174_cov_1.464000_g70110_i0	PRJNA846486	70206	174	1.464	2.54736	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	95.1	5.16e-21	NR	CAB9504775.1	568900	g70110	i0	80.7	0.982758620689655	57	11	98.3	0	2	172	1289	1345	CAB9504775.1 Nitric oxide synthase [Seminavis robusta]	diamond	171	95.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
28539335	28539335	PRJNA846486_P_NODE_92367_length_162_cov_1.699115_g92271_i0	PRJNA846486	92367	162	1.699115	2.7525663	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	77	7.44e-15	NR	GAX25881.1	1519565	g92271	i0	71.1	0.833333333333333	45	13	83.3	0	162	28	315	359	GAX25881.1 hypothetical protein FisN_6Hh081 [Fistulifera solaris]	diamond	135	77	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
28634060	28634060	PRJNA846486_P_NODE_59187_length_186_cov_1.138686_g59091_i0	PRJNA846486	59187	186	1.138686	2.11795596	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	72	1.75e-13	NR	GKY94857.1	2872254	g59091	i0	59.1	1.06451612903226	66	23	100	1	1	186	130	195	GKY94857.1 fucoxanthin chlorophyll a c protein [Mayamaea pseudoterrestris]	diamond	198	72	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
28949783	28949783	PRJNA846486_P_NODE_78848_length_168_cov_0.873950_g78752_i0	PRJNA846486	78848	168	0.87395	1.468236	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	107	3.76e-27	NR	KAI2494987.1	210448	g78752	i0	92.9	1	56	4	100	0	168	1	175	230	KAI2494987.1 Uracil phosphoribosyltransferase [Fragilaria crotonensis]	diamond	168	107	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
29770339	29770339	PRJNA846486_P_NODE_81111_length_167_cov_0.881356_g81015_i0	PRJNA846486	81111	167	0.881356	1.47186452	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	83.6	5.38e-17	NR	XP_002178974.1	556484	g81015	i0	67.3	0.988023952095808	55	18	98.8	0	167	3	534	588	XP_002178974.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	165	83.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
31698280	31698280	PRJNA846486_P_NODE_88757_length_164_cov_0.904348_g88661_i0	PRJNA846486	88757	164	0.904348	1.48313072	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	61.2	3.48e-9	NR	GFH48247.1	426638	g88661	i0	55.3	1.8109756097561	47	21	86	0	2	142	219	265	GFH48247.1 hypothetical protein CTEN210_04723 [Chaetoceros tenuissimus]	diamond	297	61.2	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
32362903	32362903	PRJNA846486_P_NODE_20099_length_285_cov_2.211864_g20003_i0	PRJNA846486	20099	285	2.211864	6.3038124	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	67.8	9.72e-11	NR	GKZ00473.1	2872254	g20003	i0	60.4	0.557894736842105	53	21	55.8	0	29	187	1163	1215	GKZ00473.1 hypothetical protein MPSEU_000999800 [Mayamaea pseudoterrestris]	diamond	159	67.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris

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