metadata: contig_metadata: 6 rows where bioproject = "PRJNA1199330", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA1199330", 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
20727002	20727002	PRJNA1199330_P_NODE_39577_length_328_cov_3.043137_g38878_i0	PRJNA1199330	39577	328	3.043137	9.98148936	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	54.7	0.009	NTclustered	gi\|2519002640\|ref\|XM_057452941.1\|	13093	g38878	i0	100	0.0884146341463415	29	0	9	0	89	117	794	766	PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130647178 (LOC130647178), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
26679801	26679801	PRJNA1199330_P_NODE_89921_length_263_cov_2.142105_g89222_i0	PRJNA1199330	89921	263	2.142105	5.63373615	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	88.6	1.15e-18	NR	CAB4017450.1	317549	g89222	i0	64.1	11.7376425855513	64	23	73	0	51	242	55	118	CAB4017450.1 Chaperone dnaK2 [Paramuricea clavata]	diamond	3087	88.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
26914273	26914273	PRJNA1199330_P_NODE_40162_length_326_cov_1.229249_g39463_i0	PRJNA1199330	40162	326	1.229249	4.00735174	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	104	1.07e-24	NR	XP_066932387.1	252671	g39463	i0	48.1	1.95092024539877	106	54	97.5	1	320	3	129	233	XP_066932387.1 uncharacterized protein [Clytia hemisphaerica]	diamond	636	104	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
26914279	26914279	PRJNA1199330_P_NODE_59622_length_291_cov_1.431193_g58923_i0	PRJNA1199330	59622	291	1.431193	4.16477163	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	92	1.25e-19	NR	XP_066932378.1	252671	g58923	i0	47.4	2.01030927835052	97	49	97.9	2	2	286	106	202	XP_066932378.1 uncharacterized protein [Clytia hemisphaerica]	diamond	585	92	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
27167219	27167219	PRJNA1199330_P_NODE_64522_length_286_cov_3.328638_g63823_i0	PRJNA1199330	64522	286	3.328638	9.51990468	Myxobolus squamalis	59785	Cnidaria	other_Eukaryota	73.6	9.05e-13	NR	KAF1743360.1	59785	g63823	i0	38.3	0.986013986013986	94	58	98.6	0	4	285	481	574	KAF1743360.1 hypothetical protein MXB_1819, partial [Myxobolus squamalis]	diamond	282	73.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
29440653	29440653	PRJNA1199330_P_NODE_78650_length_274_cov_1.552239_g77951_i0	PRJNA1199330	78650	274	1.552239	4.25313486	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	104	3.86e-24	NR	XP_031571901.1	6105	g77951	i0	54.7	38.2335766423358	86	39	94.2	0	272	15	42	127	XP_031571901.1 transmembrane protein 184C-like [Actinia tenebrosa]	diamond	10476	104	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa

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