metadata: contig_metadata: 9 rows where bioproject = "PRJNA554794", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA554794", 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
23473332	23473332	PRJNA554794_P_NODE_10219_length_383_cov_0.925150_g6334_i0	PRJNA554794	10219	383	0.92515	3.5433245	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	64.7	9.57e-10	NR	XP_065662034.1	6087	g6334	i0	59.6	1.40992167101828	57	22	44.6	1	55	225	82	137	XP_065662034.1 uncharacterized protein LOC136084842 [Hydra vulgaris]	diamond	540	64.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
27977155	27977155	PRJNA554794_P_NODE_24625_length_161_cov_0.910714_g20696_i0	PRJNA554794	24625	161	0.910714	1.46624954	Opisthokonta	33154	Cnidaria	other_Eukaryota	62.4	3.29e-10	NR	XP_020608651.1	48498	g20696	i0	62.3	7.90062111801242	53	20	98.8	0	2	160	68	120	XP_020608651.1 bis(5'-adenosyl)-triphosphatase-like isoform X1 [Orbicella faveolata]	diamond	1272	62.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
28373029	28373029	PRJNA554794_P_NODE_22566_length_167_cov_1.296610_g18637_i0	PRJNA554794	22566	167	1.29661	2.1653387	Xenia sp. Carnegie-2	86540	Cnidaria	other_Eukaryota	56.6	1.52e-7	NR	XP_046861427.1	2897299	g18637	i0	57.1	1.52694610778443	42	18	75.4	0	21	146	230	271	XP_046861427.1 uncharacterized protein LOC124454695 [Xenia sp. Carnegie-2017]	diamond	255	56.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
29099385	29099385	PRJNA554794_P_NODE_8868_length_485_cov_0.993119_g5118_i0	PRJNA554794	8868	485	0.993119	4.81662715	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	80.5	3.56e-14	NR	XP_028408447.1	151771	g5118	i0	37.9	1.43505154639175	116	65	69.9	3	146	484	893	1004	XP_028408447.1 uncharacterized protein LOC114531019 isoform X1 [Dendronephthya gigantea]	diamond	696	80.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
29776832	29776832	PRJNA554794_P_NODE_19711_length_207_cov_0.867089_g15782_i0	PRJNA554794	19711	207	0.867089	1.79487423	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99.4	2.6e-22	NR	XP_066925850.1	252671	g15782	i0	67.7	24.6231884057971	65	21	94.2	0	8	202	230	294	XP_066925850.1 protein DD3-3-like [Clytia hemisphaerica]	diamond	5097	99.8	0.995991983967936	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
30520539	30520539	PRJNA554794_P_NODE_20553_length_192_cov_1.622378_g16624_i0	PRJNA554794	20553	192	1.622378	3.11496576	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	63.2	1.12e-9	NR	XP_022794989.1	50429	g16624	i0	57.1	2.375	49	21	76.6	0	187	41	302	350	XP_022794989.1 protein hedgehog-like [Stylophora pistillata]	diamond	456	63.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
31198236	31198236	PRJNA554794_P_NODE_12995_length_258_cov_0.846890_g9066_i0	PRJNA554794	12995	258	0.84689	2.1849762	Pocilloporidae	46729	Cnidaria	other_Eukaryota	90.1	3.9e-21	NR	XP_027048772.1	46731	g9066	i0	57.3	3.56976744186047	75	32	87.2	0	226	2	3	77	XP_027048772.1 60S ribosomal protein L35a-like [Pocillopora damicornis]	diamond	921	90.9	0.991199119911991	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
31942972	31942972	PRJNA554794_P_NODE_24377_length_162_cov_0.884956_g20448_i0	PRJNA554794	24377	162	0.884956	1.43362872	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	64.7	2.26e-10	NR	XP_057315901.1	13093	g20448	i0	57.4	4.74074074074074	54	22	98.1	1	1	159	456	509	XP_057315901.1 L-asparaginase-like isoform X1 [Hydractinia symbiolongicarpus]	diamond	768	64.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
32069722	32069722	PRJNA554794_P_NODE_23338_length_165_cov_0.862069_g19409_i0	PRJNA554794	23338	165	0.862069	1.42241385	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	85.5	1.09e-17	NR	XP_066925850.1	252671	g19409	i0	69.8	3.83636363636364	53	16	96.4	0	3	161	239	291	XP_066925850.1 protein DD3-3-like [Clytia hemisphaerica]	diamond	633	85.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica

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