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

7 rows where analysis = "diamond", bioproject = "PRJNA494251" and tax_phylum = "Bryozoa"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3026074	3026074	PRJNA494251_P_NODE_15903_length_349_cov_1.409420_g15590_i0	PRJNA494251	15903	349	1.40942	4.9188758	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	202	7.06e-62	NR	KAF6024418.1	10212	g15590	i0	84.3	44.4154727793696	115	18	98.9	0	3	347	184	298	KAF6024418.1 PSMC1 [Bugula neritina]	diamond	15501	202	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
27108334	27108334	PRJNA494251_S_NODE_542_length_291_cov_1.178899_g527_i0	PRJNA494251	542	291	1.178899	3.43059609	Watersipora subatra	2589382	Bryozoa	other_Eukaryota	118	1.15e-31	NR	XP_067928495.1	2589382	g527	i0	75	2.35051546391753	76	19	78.4	0	50	277	1	76	XP_067928495.1 transcription factor BTF3 homolog 4-like [Watersipora subatra]	diamond	684	118	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Watersiporidae	Watersipora	Watersipora subatra
30692749	30692749	PRJNA494251_P_NODE_8493_length_453_cov_2.757895_g8189_i0	PRJNA494251	8493	453	2.757895	12.49326435	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	45.4	0.03	NR	KAF6029332.1	10212	g8189	i0	43.1	0.596026490066225	51	29	33.8	0	429	277	256	306	KAF6029332.1 ELOVL5 [Bugula neritina]	diamond	270	45.8	0.991266375545852	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
30850753	30850753	PRJNA494251_P_NODE_31714_length_266_cov_1.450777_g31400_i0	PRJNA494251	31714	266	1.450777	3.85906682	root	1	Root_unresolved	Root_unresolved	84.3	6.37e-17	NR	KAF6031675.1	10212	g31400	i0	56.7	14.0187969924812	67	29	75.6	0	265	65	293	359	KAF6031675.1 PDHB [Bugula neritina]	diamond	3729	85.1	0.990599294947121	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
31688733	31688733	PRJNA494251_P_NODE_20377_length_315_cov_1.272727_g20063_i0	PRJNA494251	20377	315	1.272727	4.00909005	Bugula neritina	10212	Bryozoa	other_Eukaryota	77.4	3.51e-14	NR	KAF6034364.1	10212	g20063	i0	39.4	1.03809523809524	109	62	100	3	1	315	68	176	KAF6034364.1 DSCR3 [Bugula neritina]	diamond	327	77.4	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
31910222	31910222	PRJNA494251_P_NODE_14137_length_366_cov_2.218430_g13828_i0	PRJNA494251	14137	366	2.21843	8.1194538	Bugula neritina	10212	Bryozoa	other_Eukaryota	171	8.619999999999999e-52	NR	KAF6037814.1	10212	g13828	i0	65.6	30	122	42	100	0	366	1	54	175	KAF6037814.1 DRG1 [Bugula neritina]	diamond	10980	171	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
32100073	32100073	PRJNA494251_P_NODE_46518_length_243_cov_1.358824_g46204_i0	PRJNA494251	46518	243	1.358824	3.30194232	Watersipora subatra	2589382	Bryozoa	other_Eukaryota	90.5	1.7e-19	NR	XP_067932298.1	2589382	g46204	i0	59.3	3.97530864197531	81	31	98.8	2	242	3	52	131	XP_067932298.1 phytanoyl-CoA dioxygenase, peroxisomal-like [Watersipora subatra]	diamond	966	90.5	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Watersiporidae	Watersipora	Watersipora subatra

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