metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1197996" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1197996" 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
16901392	16901392	PRJNA1197996_S_NODE_3914_length_448_cov_2.437333_g3860_i0	PRJNA1197996	3914	448	2.437333	10.91925184	Opisthokonta	33154	Cnidaria	other_Eukaryota	114	2.69e-26	NR	XP_022794529.1	50429	g3860	i0	53.3	14.4441964285714	107	46	71.7	1	448	128	1806	1908	XP_022794529.1 TATA-binding protein-associated factor 172-like [Stylophora pistillata]	diamond	6471	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
26755808	26755808	PRJNA1197996_S_NODE_4081_length_442_cov_4.823848_g4027_i0	PRJNA1197996	4081	442	4.823848	21.32140816	Xenia sp. Carnegie-2	86540	Cnidaria	other_Eukaryota	49.3	0.00154	NR	XP_046863262.1	2897299	g4027	i0	42.2	0.434389140271493	64	35	43.4	1	409	218	544	605	XP_046863262.1 uncharacterized protein LOC124457003 [Xenia sp. Carnegie-2017]	diamond	192	49.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
27009120	27009120	PRJNA1197996_S_NODE_18102_length_276_cov_1.719212_g18048_i0	PRJNA1197996	18102	276	1.719212	4.74502512	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	57	5e-7	NR	XP_020617347.1	48498	g18048	i0	54	2.64130434782609	50	23	54.3	0	245	96	351	400	XP_020617347.1 enoyl-CoA delta isomerase 2, mitochondrial-like [Orbicella faveolata]	diamond	729	57	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
27198714	27198714	PRJNA1197996_S_NODE_15982_length_288_cov_1.195349_g15928_i0	PRJNA1197996	15982	288	1.195349	3.44260512	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	49.7	2.23e-4	NR	RMX47423.1	46731	g15928	i0	53.1	2.14583333333333	49	23	51	0	30	176	301	349	RMX47423.1 hypothetical protein pdam_00002155 [Pocillopora damicornis]	diamond	618	49.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
28872496	28872496	PRJNA1197996_S_NODE_5028_length_413_cov_5.567647_g4974_i0	PRJNA1197996	5028	413	5.567647	22.99438211	Desmophyllum pertusum	174260	Cnidaria	other_Eukaryota	43.5	0.0305	NR	KAJ7363163.1	174260	g4974	i0	41.8	0.399515738498789	55	32	40	0	21	185	49	103	KAJ7363163.1 Caspase-7 [Desmophyllum pertusum]	diamond	165	43.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Caryophylliidae	Desmophyllum	Desmophyllum pertusum
28903913	28903913	PRJNA1197996_S_NODE_11788_length_317_cov_3.061475_g11734_i0	PRJNA1197996	11788	317	3.061475	9.70487575	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	68.6	7.51e-11	NR	XP_047135460.2	6087	g11734	i0	73.9	0.870662460567823	46	12	43.5	0	1	138	465	510	XP_047135460.2 uncharacterized protein LOC101234788 [Hydra vulgaris]	diamond	276	68.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
28967446	28967446	PRJNA1197996_S_NODE_18648_length_273_cov_1.875000_g18594_i0	PRJNA1197996	18648	273	1.875	5.11875	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	44.7	0.0113	NR	XP_028415428.1	151771	g18594	i0	43.6	0.428571428571429	39	22	42.9	0	25	141	526	564	XP_028415428.1 TGF-beta-activated kinase 1 and MAP3K7-binding protein 3-like isoform X2 [Dendronephthya gigantea]	diamond	117	44.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
29333520	29333520	PRJNA1197996_S_NODE_13089_length_307_cov_1.106838_g13035_i0	PRJNA1197996	13089	307	1.106838	3.39799266	Malacalcyonacea	3028843	Cnidaria	other_Eukaryota	115	5.799999999999998e-29	NR	XP_028394635.1	151771	g13035	i0	71.8	2.0814332247557	71	20	69.4	0	280	68	206	276	XP_028394635.1 geranylgeranyl transferase type-2 subunit beta-like isoform X2 [Dendronephthya gigantea]	diamond	639	116	0.991379310344828	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
29617339	29617339	PRJNA1197996_S_NODE_2650_length_509_cov_1.346330_g2598_i0	PRJNA1197996	2650	509	1.34633	6.8528197	Metazoa	33208	Cnidaria	other_Eukaryota	50.4	9.42e-4	NR	XP_057311090.1	13093	g2598	i0	43.5	1.46758349705305	62	34	36	1	15	197	61	122	XP_057311090.1 phospholipase A2 inhibitor beta-like isoform X3 [Hydractinia symbiolongicarpus]	diamond	747	50.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
29743742	29743742	PRJNA1197996_S_NODE_7690_length_363_cov_1.327586_g7636_i0	PRJNA1197996	7690	363	1.327586	4.81913718	root	1	Root_unresolved	Root_unresolved	44.3	0.00938	NR	XP_032231058.1	45351	g7636	i0	38.8	1.20661157024793	49	30	40.5	0	6	152	63	111	XP_032231058.1 uncharacterized protein LOC5506731 [Nematostella vectensis]	diamond	438	44.7	0.991051454138702	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
29996823	29996823	PRJNA1197996_S_NODE_26891_length_244_cov_1.280702_g26837_i0	PRJNA1197996	26891	244	1.280702	3.12491288	Metazoa	33208	Cnidaria	other_Eukaryota	91.7	4.1e-20	NR	XP_057289553.1	13093	g26837	i0	73.6	9.82377049180328	53	14	65.2	0	219	61	238	290	XP_057289553.1 eukaryotic translation initiation factor 3 subunit G-like isoform X2 [Hydractinia symbiolongicarpus]	diamond	2397	92	0.996739130434783	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus

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