metadata: contig_metadata: 7 rows where bioproject = "PRJNA603943", tax_clade = "Opisthokonta" and tax

7 rows where bioproject = "PRJNA603943", 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
3128837	3128837	PRJNA603943_P_NODE_62563_length_245_cov_1.343023_g62371_i0	PRJNA603943	62563	245	1.343023	3.29040635	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2917940696\|emb\|OZ237557.1\|	6108	g62371	i0	94.595	0.387755102040816	37	1	15	1	85	120	20108761	20108797	Anemonia sulcata genome assembly, chromosome: 3	blastn	95	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
28627664	28627664	PRJNA603943_P_NODE_52927_length_251_cov_0.865169_g52735_i0	PRJNA603943	52927	251	0.865169	2.17157419	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	65.9	2.96e-10	NR	XP_031569409.1	6105	g52735	i0	35.4	2.83266932270916	82	52	96.8	1	250	8	146	227	XP_031569409.1 utrophin-like isoform X3 [Actinia tenebrosa]	diamond	711	65.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
28753694	28753694	PRJNA603943_P_NODE_45447_length_274_cov_1.532338_g45255_i0	PRJNA603943	45447	274	1.532338	4.19860612	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	47.4	0.00119	NR	CAB4034423.1	317549	g45255	i0	61.1	1.97080291970803	36	14	39.4	0	271	164	115	150	CAB4034423.1 Retrovirus-related Pol poly from transposon TNT 1-94, partial [Paramuricea clavata]	diamond	540	47.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
30142811	30142811	PRJNA603943_P_NODE_7352_length_573_cov_1.390000_g7165_i0	PRJNA603943	7352	573	1.39	7.9647	Desmophyllum pertusum	174260	Cnidaria	other_Eukaryota	207	6.14e-60	NR	KAJ7394266.1	174260	g7165	i0	58	4.73298429319372	181	74	94.8	1	568	26	412	590	KAJ7394266.1 NADP-dependent malic enzyme [Desmophyllum pertusum]	diamond	2712	207	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Caryophylliidae	Desmophyllum	Desmophyllum pertusum
31388962	31388962	PRJNA603943_P_NODE_16176_length_415_cov_3.187135_g15984_i0	PRJNA603943	16176	415	3.187135	13.22661025	Anthozoa	6101	Cnidaria	other_Eukaryota	128	2.55e-35	NR	EDO33935.1	45351	g15984	i0	61.1	2.84096385542169	131	40	94.7	1	414	22	3	122	EDO33935.1 predicted protein [Nematostella vectensis]	diamond	1179	129	0.992248062015504	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
31736593	31736593	PRJNA603943_P_NODE_56797_length_249_cov_0.875000_g56605_i0	PRJNA603943	56797	249	0.875	2.17875	Anthozoa	6101	Cnidaria	other_Eukaryota	86.3	1.44e-17	NR	XP_029197265.1	45264	g56605	i0	52.6	8.24096385542169	76	34	89.2	1	28	249	115	190	XP_029197265.1 synapsin-2-like isoform X2 [Acropora millepora]	diamond	2052	87	0.991954022988506	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
31818314	31818314	PRJNA603943_P_NODE_55257_length_250_cov_0.870056_g55065_i0	PRJNA603943	55257	250	0.870056	2.17514	Xenia sp. Carnegie-2	86540	Cnidaria	other_Eukaryota	44.7	0.00428	NR	XP_046844246.1	2897299	g55065	i0	32.4	1.548	68	44	80.4	2	214	14	92	158	XP_046844246.1 selenoprotein F-like [Xenia sp. Carnegie-2017]	diamond	387	44.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017

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