metadata: contig_metadata: 5 rows where bioproject = "PRJNA1022392", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA1022392", 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
2712979	2712979	PRJNA1022392_P_NODE_75383_length_161_cov_0.894737_g74714_i0	PRJNA1022392	75383	161	0.894737	1.44052657	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	52.8	0.013	NTclustered	gi\|2729078046\|ref\|XM_065201365.1\|	499914	g74714	i0	96.774	0.192546583850932	31	1	19	0	61	91	2008	2038	PREDICTED: Rhopilema esculentum 5'-nucleotidase domain-containing protein 1-like (LOC135685428), transcript variant X1, mRNA	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
27951078	27951078	PRJNA1022392_P_NODE_58565_length_179_cov_1.765152_g57896_i0	PRJNA1022392	58565	179	1.765152	3.15962208	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	82.8	1.21e-16	NR	CAB4025375.1	317549	g57896	i0	66.1	0.988826815642458	59	20	98.9	0	177	1	1266	1324	CAB4025375.1 zinc finger [Paramuricea clavata]	diamond	177	82.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
28803255	28803255	PRJNA1022392_P_NODE_55648_length_183_cov_1.360294_g54979_i0	PRJNA1022392	55648	183	1.360294	2.48933802	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	42.4	0.0236	NR	XP_065671761.1	6087	g54979	i0	47.4	1.24590163934426	38	19	60.7	1	180	70	112	149	XP_065671761.1 uncharacterized protein LOC136089638 [Hydra vulgaris]	diamond	228	42.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
30224504	30224504	PRJNA1022392_P_NODE_53212_length_186_cov_1.388489_g52543_i0	PRJNA1022392	53212	186	1.388489	2.58258954	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	79.3	2.24e-15	NR	XP_065641469.1	6087	g52543	i0	73.3	1.45161290322581	45	12	72.6	0	135	1	51	95	XP_065641469.1 uncharacterized protein LOC124806957 [Hydra vulgaris]	diamond	270	79.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
32776831	32776831	PRJNA1022392_P_NODE_65620_length_170_cov_1.894309_g64951_i0	PRJNA1022392	65620	170	1.894309	3.2203253	root	1	Root_unresolved	Root_unresolved	45.8	0.00114	NR	XP_065673940.1	6087	g64951	i0	58.8	4.44705882352941	34	14	60	0	159	58	543	576	XP_065673940.1 uncharacterized protein LOC136090891 [Hydra vulgaris]	diamond	756	46.2	0.991341991341991	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);;