metadata: contig_metadata: 3 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax

3 rows where analysis = "diamond", bioproject = "PRJNA900999" 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
27947890	27947890	PRJNA900999_S_NODE_7185_length_170_cov_2.141844_g7129_i0	PRJNA900999	7185	170	2.141844	3.6411348	Metazoa	33208	Cnidaria	other_Eukaryota	49.7	4.96e-5	NR	XP_065676795.1	6087	g7129	i0	57.5	3.44117647058824	40	17	70.6	0	31	150	626	665	XP_065676795.1 DNA transposase THAP9-like isoform X2 [Hydra vulgaris]	diamond	585	50.1	0.992015968063872	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
28918840	28918840	PRJNA900999_S_NODE_4328_length_207_cov_3.803371_g4272_i0	PRJNA900999	4328	207	3.803371	7.87297797	Porites lobata	104759	Cnidaria	other_Eukaryota	47.4	5.66e-4	NR	CAH3119332.1	104759	g4272	i0	50	2.88405797101449	30	14	43.5	1	123	34	1142	1170	CAH3119332.1 unnamed protein product [Porites lobata]	diamond	597	47.8	0.99163179916318	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
30213624	30213624	PRJNA900999_S_NODE_3812_length_217_cov_7.930851_g3756_i0	PRJNA900999	3812	217	7.930851	17.20994667	Porites lobata	104759	Cnidaria	other_Eukaryota	43.9	0.00373	NR	CAH3175177.1	104759	g3756	i0	51.1	0.622119815668203	45	20	62.2	1	211	77	83	125	CAH3175177.1 unnamed protein product [Porites lobata]	diamond	135	43.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata

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