metadata: contig_metadata: 8 rows where bioproject = "PRJNA688736", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA688736", 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
13422277	13422277	PRJNA688736_P_NODE_8871_length_499_cov_1.798122_g8587_i0	PRJNA688736	8871	499	1.798122	8.97262878	Metazoa	33208	Cnidaria	other_Eukaryota	209	1.26e-62	NR	XP_044175904.1	45264	g8587	i0	83.5	20.0501002004008	115	19	69.1	0	1	345	321	435	XP_044175904.1 LOW QUALITY PROTEIN: adenosylhomocysteinase B-like [Acropora millepora]	diamond	10005	210	0.995238095238095	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
27082277	27082277	PRJNA688736_P_NODE_42662_length_250_cov_0.881356_g42377_i0	PRJNA688736	42662	250	0.881356	2.20339	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	73.6	5.62e-13	NR	XP_031561318.1	6105	g42377	i0	45.7	3.864	81	43	97.2	1	248	6	322	401	XP_031561318.1 hemicentin-1-like [Actinia tenebrosa]	diamond	966	73.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
28440411	28440411	PRJNA688736_P_NODE_44566_length_248_cov_0.891429_g44281_i0	PRJNA688736	44566	248	0.891429	2.21074392	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	87.8	5.37e-18	NR	XP_057312408.1	13093	g44281	i0	48.1	0.979838709677419	81	42	98	0	2	244	312	392	XP_057312408.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 1-like [Hydractinia symbiolongicarpus]	diamond	243	87.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
29198214	29198214	PRJNA688736_P_NODE_41849_length_251_cov_0.876404_g41564_i0	PRJNA688736	41849	251	0.876404	2.19977404	Acropora digitifera	70779	Cnidaria	other_Eukaryota	84.3	4.1e-18	NR	XP_015765847.1	70779	g41564	i0	65.7	1.64940239043825	70	24	83.7	0	39	248	62	131	XP_015765847.1 PREDICTED: 60S ribosomal protein L35-like [Acropora digitifera]	diamond	414	84.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
30378559	30378559	PRJNA688736_P_NODE_15152_length_393_cov_2.412500_g14867_i0	PRJNA688736	15152	393	2.4125	9.481125	Metazoa	33208	Cnidaria	other_Eukaryota	49.3	9.42e-4	NR	XP_065654020.1	6087	g14867	i0	34.9	1.87786259541985	83	42	62.6	2	329	84	8	79	XP_065654020.1 plastin-3 [Hydra vulgaris]	diamond	738	49.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
30967078	30967078	PRJNA688736_P_NODE_19894_length_349_cov_1.677536_g19609_i0	PRJNA688736	19894	349	1.677536	5.85460064	Desmophyllum pertusum	174260	Cnidaria	other_Eukaryota	84.3	5.68e-18	NR	KAJ7321400.1	174260	g19609	i0	56.7	0.575931232091691	67	23	57.6	2	347	147	85	145	KAJ7321400.1 hypothetical protein OS493_034973, partial [Desmophyllum pertusum]	diamond	201	84.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Caryophylliidae	Desmophyllum	Desmophyllum pertusum
31357888	31357888	PRJNA688736_P_NODE_44096_length_249_cov_0.886364_g43811_i0	PRJNA688736	44096	249	0.886364	2.20704636	Metazoa	33208	Cnidaria	other_Eukaryota	47.8	5.57e-4	NR	XP_044183836.1	45264	g43811	i0	41.8	9.86746987951807	55	26	66.3	1	218	54	124	172	XP_044183836.1 uncharacterized protein LOC122964347 [Acropora millepora]	diamond	2457	48.1	0.993762993762994	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
32894718	32894718	PRJNA688736_P_NODE_41740_length_251_cov_0.876404_g41455_i0	PRJNA688736	41740	251	0.876404	2.19977404	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	43.1	0.0314	NR	PFX17576.1	50429	g41455	i0	36.2	0.824701195219124	69	42	80.1	1	239	39	4238	4306	PFX17576.1 E3 ubiquitin-protein ligase HERC2 [Stylophora pistillata]	diamond	207	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata

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