metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax_phylum = "Cnidaria"

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
26941345	26941345	PRJNA1115053_S_NODE_304322_length_160_cov_1.641026_g302505_i0	PRJNA1115053	304322	160	1.641026	2.6256416	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	52	6.61e-6	NR	CAB4027350.1	317549	g302505	i0	51.2	4.03125	43	21	80.6	0	1	129	117	159	CAB4027350.1 Transposon Tf2-6 poly, partial [Paramuricea clavata]	diamond	645	52	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
27384189	27384189	PRJNA1115053_S_NODE_220963_length_185_cov_3.126761_g219146_i0	PRJNA1115053	220963	185	3.126761	5.78450785	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	43.9	0.00547	NR	CAB4006633.1	317549	g219146	i0	48.5	4.94594594594595	33	17	53.5	0	172	74	74	106	CAB4006633.1 Hypothetical predicted protein, partial [Paramuricea clavata]	diamond	915	43.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
27668386	27668386	PRJNA1115053_S_NODE_310164_length_159_cov_0.836207_g308347_i0	PRJNA1115053	310164	159	0.836207	1.32956913	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	63.5	3.99e-10	NR	CAB4022477.1	317549	g308347	i0	59.2	8.32075471698113	49	20	92.5	0	6	152	4	52	CAB4022477.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	1323	63.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
31015843	31015843	PRJNA1115053_S_NODE_171915_length_207_cov_1.463415_g170098_i0	PRJNA1115053	171915	207	1.463415	3.02926905	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	47.8	3.41e-4	NR	CAB4001341.1	317549	g170098	i0	55	2.28985507246377	40	18	58	0	64	183	83	122	CAB4001341.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	474	47.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
32059470	32059470	PRJNA1115053_S_NODE_193618_length_197_cov_0.772727_g191801_i0	PRJNA1115053	193618	197	0.772727	1.52227219	Porites lobata	104759	Cnidaria	other_Eukaryota	76.6	8.4e-17	NR	CAH3187615.1	104759	g191801	i0	56.9	0.989847715736041	65	19	99	1	2	196	1	56	CAH3187615.1 unnamed protein product [Porites lobata]	diamond	195	76.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
32754698	32754698	PRJNA1115053_S_NODE_180360_length_203_cov_1.200000_g178543_i0	PRJNA1115053	180360	203	1.2	2.436	Acropora millepora	45264	Cnidaria	other_Eukaryota	42	0.0242	NR	XP_044183263.1	45264	g178543	i0	36	0.738916256157635	50	32	73.9	0	52	201	104	153	XP_044183263.1 dedicator of cytokinesis protein 9-like [Acropora millepora]	diamond	150	42	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora

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