metadata: contig_metadata: 11 rows where bioproject = "PRJNA1164198", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJNA1164198", 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
7965211	7965211	PRJNA1164198_P_NODE_22127_length_264_cov_1.633508_g21858_i0	PRJNA1164198	22127	264	1.633508	4.31246112	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	161	4.0599999999999997e-48	NR	XP_001629850.3	45351	g21858	i0	88.6	27	88	10	100	0	264	1	98	185	XP_001629850.3 40S ribosomal protein S20 [Nematostella vectensis]	diamond	7128	162	0.993827160493827	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
10515568	10515568	PRJNA1164198_P_NODE_13469_length_337_cov_2.659091_g13200_i0	PRJNA1164198	13469	337	2.659091	8.96113667	Pocilloporidae	46729	Cnidaria	other_Eukaryota	171	2.49e-49	NR	RMX51428.1	46731	g13200	i0	82.7	6.05341246290801	98	17	87.2	0	2	295	298	395	RMX51428.1 hypothetical protein pdam_00012625 [Pocillopora damicornis]	diamond	2040	172	0.994186046511628	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
13792834	13792834	PRJNA1164198_P_NODE_6511_length_493_cov_3.011905_g6252_i0	PRJNA1164198	6511	493	3.011905	14.84869165	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	215	5.8e-51	NTclustered	gi\|2689317130\|gb\|PP410662.1\|	204378	g6252	i0	75.728	158.878296146045	515	78	100	31	1	493	2137	1648	Antillogorgia americana voucher USNM:1606827 large subunit ribosomal RNA gene, partial sequence	blastn	78327	217	0.990783410138249	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Gorgoniidae	Antillogorgia	Antillogorgia americana
27198266	27198266	PRJNA1164198_P_NODE_10402_length_386_cov_0.971246_g10134_i0	PRJNA1164198	10402	386	0.971246	3.74900956	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	54.7	1.18e-5	NR	KXJ17741.1	2652724	g10134	i0	39.2	0.575129533678757	74	43	56.7	2	22	240	353	425	KXJ17741.1 RNA polymerase-associated protein RTF1-like [Exaiptasia diaphana]	diamond	222	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
27893212	27893212	PRJNA1164198_P_NODE_27365_length_248_cov_0.891429_g27096_i0	PRJNA1164198	27365	248	0.891429	2.21074392	Xenia sp. Carnegie-2	86540	Cnidaria	other_Eukaryota	67.4	7.94e-11	NR	XP_046860330.1	2897299	g27096	i0	44.6	0.786290322580645	65	32	78.6	2	207	13	373	433	XP_046860330.1 PDZ and LIM domain protein 7-like [Xenia sp. Carnegie-2017]	diamond	195	67.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
28101860	28101860	PRJNA1164198_P_NODE_23385_length_257_cov_1.135870_g23116_i0	PRJNA1164198	23385	257	1.13587	2.9191859	Opisthokonta	33154	Cnidaria	other_Eukaryota	92	6.79e-22	NR	XP_031552790.1	6105	g23116	i0	65.3	7.89105058365759	72	20	78.2	1	3	203	42	113	XP_031552790.1 60S ribosomal protein L35a-like [Actinia tenebrosa]	diamond	2028	92	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
30281336	30281336	PRJNA1164198_P_NODE_29112_length_245_cov_0.906977_g28843_i0	PRJNA1164198	29112	245	0.906977	2.22209365	Metazoa	33208	Cnidaria	other_Eukaryota	82.8	3.08e-16	NR	XP_031550459.1	6105	g28843	i0	50.6	26.9755102040816	77	38	94.3	0	244	14	887	963	XP_031550459.1 brefeldin A-inhibited guanine nucleotide-exchange protein 1-like [Actinia tenebrosa]	diamond	6609	83.2	0.995192307692308	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
30356927	30356927	PRJNA1164198_P_NODE_14112_length_329_cov_2.433594_g13843_i0	PRJNA1164198	14112	329	2.433594	8.00652426	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	57	9.17e-7	NR	EDO36987.1	45351	g13843	i0	34.2	1.6595744680851101	79	51	72	1	246	10	226	303	EDO36987.1 predicted protein [Nematostella vectensis]	diamond	546	57	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
30407621	30407621	PRJNA1164198_P_NODE_26133_length_250_cov_0.881356_g25864_i0	PRJNA1164198	26133	250	0.881356	2.20339	root	1	Root_unresolved	Root_unresolved	58.2	1.5e-7	NR	XP_065053483.1	499914	g25864	i0	42.1	1.512	76	41	87.6	1	238	20	258	333	XP_065053483.1 uncharacterized protein LOC135682495 isoform X2 [Rhopilema esculentum]	diamond	378	58.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
31924571	31924571	PRJNA1164198_P_NODE_28257_length_246_cov_0.901734_g27988_i0	PRJNA1164198	28257	246	0.901734	2.21826564	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	100	6.619999999999999e-23	NR	XP_057310722.1	13093	g27988	i0	65.8	1.91463414634146	76	25	92.7	1	229	2	131	205	XP_057310722.1 soluble calcium-activated nucleotidase 1-like [Hydractinia symbiolongicarpus]	diamond	471	100	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
32746472	32746472	PRJNA1164198_P_NODE_17200_length_298_cov_1.386667_g16931_i0	PRJNA1164198	17200	298	1.386667	4.13226766	Opisthokonta	33154	Cnidaria	other_Eukaryota	130	5.63e-36	NR	RMX60754.1	46731	g16931	i0	61.6	16.9530201342282	99	38	99.7	0	297	1	50	148	RMX60754.1 hypothetical protein pdam_00014285, partial [Pocillopora damicornis]	diamond	5052	130	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis

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