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

4 rows where analysis = "diamond", bioproject = "PRJNA977246" 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
16254631	16254631	PRJNA977246_S_NODE_5393_length_695_cov_4.243243_g4720_i0	PRJNA977246	5393	695	4.243243	29.49053885	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	185	4.029999999999999e-55	NR	XP_031562005.1	6105	g4720	i0	52.3	0.850359712230216	197	92	85	2	1	591	17	211	XP_031562005.1 60S ribosomal protein L13-like [Actinia tenebrosa]	diamond	591	185	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
31416585	31416585	PRJNA977246_S_NODE_35356_length_200_cov_2.017544_g34364_i0	PRJNA977246	35356	200	2.017544	4.035088	Acropora cervicornis	6130	Cnidaria	other_Eukaryota	70.9	1.47e-14	NR	KAK2569077.1	6130	g34364	i0	88.2	14.775	34	4	51	0	1	102	18	51	KAK2569077.1 60S ribosomal protein L39-1 [Acropora cervicornis]	diamond	2955	70.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
32492410	32492410	PRJNA977246_S_NODE_36899_length_193_cov_3.524390_g35907_i0	PRJNA977246	36899	193	3.52439	6.8020727	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	44.3	0.00523	NR	XP_020607581.1	48498	g35907	i0	42.2	2.47150259067358	45	26	69.9	0	136	2	135	179	XP_020607581.1 uncharacterized protein LOC110046199, partial [Orbicella faveolata]	diamond	477	44.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
32907912	32907912	PRJNA977246_S_NODE_30020_length_226_cov_4.340102_g29028_i0	PRJNA977246	30020	226	4.340102	9.80863052	Acroporidae	6126	Cnidaria	other_Eukaryota	49.3	1.5e-4	NR	XP_044180531.1	45264	g29028	i0	47.1	4.79203539823009	51	27	67.7	0	4	156	990	1040	XP_044180531.1 uncharacterized protein LOC122961786 [Acropora millepora]	diamond	1083	49.7	0.991951710261569	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);;