metadata: contig_metadata: 4 rows where bioproject = "PRJNA1198392", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA1198392", tax_clade = "Opisthokonta" 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
27691987	27691987	PRJNA1198392_P_NODE_18764_length_246_cov_0.890173_g18623_i0	PRJNA1198392	18764	246	0.890173	2.18982558	Porites	46719	Cnidaria	other_Eukaryota	50.4	7.46e-5	NR	CAH3027875.1	104178	g18623	i0	46.7	2.19512195121951	45	24	54.9	0	108	242	1264	1308	CAH3027875.1 unnamed protein product [Porites evermanni]	diamond	540	50.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
29491323	29491323	PRJNA1198392_P_NODE_8110_length_291_cov_1.802752_g7969_i0	PRJNA1198392	8110	291	1.802752	5.24600832	Opisthokonta	33154	Cnidaria	other_Eukaryota	55.1	2.56e-6	NR	XP_065668876.1	6087	g7969	i0	65.9	3.57731958762887	44	14	44.3	1	152	280	3	46	XP_065668876.1 mitochondrial glutamate carrier 1 isoform X3 [Hydra vulgaris]	diamond	1041	55.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
30091252	30091252	PRJNA1198392_P_NODE_14452_length_259_cov_1.284946_g14311_i0	PRJNA1198392	14452	259	1.284946	3.32801014	Anthozoa	6101	Cnidaria	other_Eukaryota	122	5.98e-30	NR	XP_001628323.2	45351	g14311	i0	66.7	8.64092664092664	87	26	97.3	1	252	1	373	459	XP_001628323.2 protein DD3-3 [Nematostella vectensis]	diamond	2238	122	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
30546472	30546472	PRJNA1198392_P_NODE_20213_length_243_cov_0.905882_g20072_i0	PRJNA1198392	20213	243	0.905882	2.20129326	Montipora capricornis	246305	Cnidaria	other_Eukaryota	42.7	0.0357	NR	XP_068732247.1	246305	g20072	i0	32.8	0.827160493827161	67	33	67.9	2	78	242	334	400	XP_068732247.1 uncharacterized protein [Montipora capricornis]	diamond	201	42.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis

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