metadata: contig_metadata: 4 rows where bioproject = "PRJNA385396", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA385396", tax_kingdom = "Metazoa" 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
27391455	27391455	PRJNA385396_P_NODE_13783_length_251_cov_0.865169_g13691_i0	PRJNA385396	13783	251	0.865169	2.17157419	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	64.7	7.35e-10	NR	XP_031575365.1	6105	g13691	i0	39.7	1.8406374501992	73	43	86.1	1	10	225	179	251	XP_031575365.1 cathepsin L-like [Actinia tenebrosa]	diamond	462	64.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
28765729	28765729	PRJNA385396_P_NODE_14187_length_250_cov_0.870056_g14095_i0	PRJNA385396	14187	250	0.870056	2.17514	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	86.7	7.01e-18	NR	XP_065673848.1	6087	g14095	i0	45.6	7.5	79	43	94.8	0	3	239	282	360	XP_065673848.1 mannose-1-phosphate guanyltransferase beta isoform X2 [Hydra vulgaris]	diamond	1875	87	0.996551724137931	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29601194	29601194	PRJNA385396_P_NODE_21670_length_241_cov_0.916667_g21578_i0	PRJNA385396	21670	241	0.916667	2.20916747	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	43.5	0.0201	NR	XP_065071325.1	499914	g21578	i0	32.4	0.846473029045643	68	44	84.6	1	37	240	995	1060	XP_065071325.1 WD repeat-containing protein 11-like [Rhopilema esculentum]	diamond	204	43.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
30580525	30580525	PRJNA385396_P_NODE_6193_length_338_cov_2.320755_g6101_i0	PRJNA385396	6193	338	2.320755	7.8441519	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	158	5.78e-45	NR	XP_065061962.1	499914	g6101	i0	59	1.03846153846154	117	40	96.7	2	6	332	91	207	XP_065061962.1 cathepsin B-like [Rhopilema esculentum]	diamond	351	158	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum

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