metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB25789" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB25789" and tax_phylum = "Porifera"

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
12776837	12776837	PRJEB25789_S_NODE_4331_length_425_cov_2.275568_g4252_i0	PRJEB25789	4331	425	2.275568	9.671164	Opisthokonta	33154	Porifera	other_Eukaryota	214	2.9e-69	NR	XP_065826293.1	121494	g4252	i0	79.2	7.34117647058823	130	27	91.8	0	424	35	1	130	XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis]	diamond	3120	214	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
22975296	22975296	PRJEB25789_S_NODE_7819_length_334_cov_2.080460_g7740_i0	PRJEB25789	7819	334	2.08046	6.9487364	Demospongiae	6042	Porifera	other_Eukaryota	175	5.46e-53	NR	XP_065898136.1	196820	g7740	i0	79.1	2.96407185628743	110	21	98.8	1	330	1	1	108	XP_065898136.1 small ribosomal subunit protein eS8-like [Dysidea avara]	diamond	990	175	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
27563593	27563593	PRJEB25789_S_NODE_19044_length_244_cov_0.900585_g18965_i0	PRJEB25789	19044	244	0.900585	2.1974274	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	65.9	2.68e-10	NR	XP_003387258.1	400682	g18965	i0	52.7	1.90573770491803	74	30	88.5	3	1	216	341	411	XP_003387258.1 PREDICTED: arylsulfatase I-like [Amphimedon queenslandica]	diamond	465	65.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
28826586	28826586	PRJEB25789_S_NODE_12568_length_280_cov_1.458937_g12489_i0	PRJEB25789	12568	280	1.458937	4.0850236	root	1	Root_unresolved	Root_unresolved	116	1.37e-28	NR	XP_064384573.1	6063	g12489	i0	64.8	11.6142857142857	91	32	97.5	0	2	274	32	122	XP_064384573.1 3-ketoacyl-CoA thiolase, mitochondrial-like [Halichondria panicea]	diamond	3252	116	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea

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