metadata: contig_metadata: 5 rows where bioproject = "PRJNA290839" and tax

5 rows where bioproject = "PRJNA290839" 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
9300977	9300977	PRJNA290839_P_NODE_388_length_422_cov_1.338109_g367_i0	PRJNA290839	388	422	1.338109	5.64681998	root	1	Root_unresolved	Root_unresolved	214	2.91e-68	NR	XP_057303614.1	13093	g367	i0	77.4	92.1682464454976	133	30	94.5	0	22	420	5	137	XP_057303614.1 60S ribosomal protein L11-like [Hydractinia symbiolongicarpus]	diamond	38895	214	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
27927026	27927026	PRJNA290839_P_NODE_765_length_292_cov_1.045662_g744_i0	PRJNA290839	765	292	1.045662	3.05333304	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	139	3.0099999999999993e-40	NR	XP_028401732.1	151771	g744	i0	64.8	1.07876712328767	105	28	99.7	2	291	1	8	111	XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea]	diamond	315	139	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
28418463	28418463	PRJNA290839_P_NODE_1166_length_250_cov_0.875706_g1145_i0	PRJNA290839	1166	250	0.875706	2.189265	Anthozoa	6101	Cnidaria	other_Eukaryota	66.6	1.56e-10	NR	XP_031566134.1	6105	g1145	i0	42.7	7.896	75	39	85.2	2	2	214	456	530	XP_031566134.1 testin-like [Actinia tenebrosa]	diamond	1974	66.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
29063821	29063821	PRJNA290839_P_NODE_1068_length_252_cov_0.865922_g1047_i0	PRJNA290839	1068	252	0.865922	2.18212344	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	89.7	7.080000000000001e-21	NR	XP_057311792.1	13093	g1047	i0	53.4	1.04761904761905	88	32	94	2	247	11	10	97	XP_057311792.1 ragulator complex protein LAMTOR2-like [Hydractinia symbiolongicarpus]	diamond	264	89.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
31559746	31559746	PRJNA290839_P_NODE_1036_length_252_cov_1.731844_g1015_i0	PRJNA290839	1036	252	1.731844	4.36424688	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	62.4	3.25e-9	NR	XP_020614672.1	48498	g1015	i0	53.2	0.55952380952381	47	22	56	0	250	110	12	58	XP_020614672.1 protein lin-41-like [Orbicella faveolata]	diamond	141	62.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata

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