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

8 rows where bioproject = "PRJNA1103784", 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
9139761	9139761	PRJNA1103784_P_NODE_5688_length_251_cov_0.865169_g5633_i0	PRJNA1103784	5688	251	0.865169	2.17157419	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	154	6.06e-33	NTclustered	gi\|2782884422\|ref\|XM_067064532.1\|	252671	g5633	i0	80.095	35.4741035856574	211	39	83	3	13	221	231	440	PREDICTED: Clytia hemisphaerica tubulin alpha chain-like (LOC136807913), mRNA	blastn	8904	154	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
27343714	27343714	PRJNA1103784_P_NODE_6503_length_247_cov_0.885057_g6448_i0	PRJNA1103784	6503	247	0.885057	2.18609079	Scleractinia	6125	Cnidaria	other_Eukaryota	47.4	9.43e-4	NR	XP_044178091.1	45264	g6448	i0	60.5	4.70040485829959	43	17	52.2	0	243	115	260	302	XP_044178091.1 ubiquitin carboxyl-terminal hydrolase 45-like [Acropora millepora]	diamond	1161	47.8	0.99163179916318	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
27573220	27573220	PRJNA1103784_P_NODE_5624_length_251_cov_1.247191_g5569_i0	PRJNA1103784	5624	251	1.247191	3.13044941	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	122	3.99e-30	NR	XP_020895487.1	2652724	g5569	i0	65.4	7.79282868525896	81	28	96.8	0	9	251	1280	1360	XP_020895487.1 prolyl endopeptidase isoform X1 [Exaiptasia diaphana]	diamond	1956	122	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
28741465	28741465	PRJNA1103784_P_NODE_967_length_503_cov_1.251163_g912_i0	PRJNA1103784	967	503	1.251163	6.29334989	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	112	6.9e-26	NR	XP_057317537.1	13093	g912	i0	39.1	1.0675944333996	179	96	99	2	503	6	175	353	XP_057317537.1 nucleosome assembly protein 1-like 1 [Hydractinia symbiolongicarpus]	diamond	537	112	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
29553447	29553447	PRJNA1103784_P_NODE_4430_length_273_cov_2.700000_g4375_i0	PRJNA1103784	4430	273	2.7	7.371	Cnidaria	6073	Cnidaria	other_Eukaryota	88.6	4.21e-18	NR	XP_065070225.1	499914	g4375	i0	66.2	5.01098901098901	77	26	84.6	0	7	237	648	724	XP_065070225.1 transitional endoplasmic reticulum ATPase [Rhopilema esculentum]	diamond	1368	88.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
29688374	29688374	PRJNA1103784_P_NODE_6450_length_247_cov_0.885057_g6395_i0	PRJNA1103784	6450	247	0.885057	2.18609079	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	53.5	5.96e-6	NR	CAB3994711.1	317549	g6395	i0	52.2	0.558704453441296	46	22	55.9	0	185	48	73	118	CAB3994711.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	138	53.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
30636197	30636197	PRJNA1103784_P_NODE_1553_length_411_cov_3.455621_g1498_i0	PRJNA1103784	1553	411	3.455621	14.20260231	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	88.6	1.05e-18	NR	XP_065662030.1	6087	g1498	i0	49.4	0.605839416058394	83	41	60.6	1	397	149	86	167	XP_065662030.1 uncharacterized protein LOC136084840 [Hydra vulgaris]	diamond	249	88.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
32691281	32691281	PRJNA1103784_P_NODE_3920_length_284_cov_1.848341_g3865_i0	PRJNA1103784	3920	284	1.848341	5.24928844	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	70.9	1.52e-12	NR	XP_065662030.1	6087	g3865	i0	55.1	0.517605633802817	49	22	51.8	0	283	137	119	167	XP_065662030.1 uncharacterized protein LOC136084840 [Hydra vulgaris]	diamond	147	70.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris

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