metadata: contig_metadata: 14 rows where bioproject = "PRJNA529241", tax_clade = "Opisthokonta" and tax

14 rows where bioproject = "PRJNA529241", 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
1776090	1776090	PRJNA529241_P_NODE_419962_length_168_cov_1.244275_g417640_i0	PRJNA529241	419962	168	1.244275	2.090382	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	52.8	0.014	NTclustered	gi\|2918369555\|emb\|OZ237727.1\|	317547	g417640	i0	100	0.166666666666667	28	0	17	0	36	63	11614604	11614631	Eunicella cavolini genome assembly, chromosome: 11	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
3050993	3050993	PRJNA529241_P_NODE_315763_length_173_cov_3.308824_g313441_i0	PRJNA529241	315763	173	3.308824	5.72426552	Montipora capricornis	246305	Cnidaria	other_Eukaryota	54.7	0.004	NTclustered	gi\|2812175844\|ref\|XM_068900837.1\|	246305	g313441	i0	100	0.167630057803468	29	0	17	0	18	46	2212	2240	PREDICTED: Montipora capricornis uncharacterized protein (LOC138054395), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
9428542	9428542	PRJNA529241_P_NODE_356028_length_173_cov_2.808824_g353706_i0	PRJNA529241	356028	173	2.808824	4.85926552	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	52.8	0.015	NTclustered	gi\|2918369538\|emb\|OZ237720.1\|	317547	g353706	i0	100	0.161849710982659	28	0	16	0	130	157	46926129	46926156	Eunicella cavolini genome assembly, chromosome: 4	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
13868520	13868520	PRJNA529241_P_NODE_138191_length_192_cov_1.006452_g135869_i0	PRJNA529241	138191	192	1.006452	1.93238784	Acropora	6127	Cnidaria	other_Eukaryota	52.8	0.017	NTclustered	gi\|2114256896\|ref\|XM_044323785.1\|	45264	g135869	i0	100	0.291666666666667	28	0	15	0	123	150	1085	1112	PREDICTED: Acropora millepora collagen alpha-1(III) chain-like (LOC114955317), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
18967261	18967261	PRJNA529241_P_NODE_366395_length_173_cov_2.698529_g364073_i0	PRJNA529241	366395	173	2.698529	4.66845517	Metazoa	33208	Cnidaria	other_Eukaryota	52.8	0.015	NTclustered	gi\|2917940714\|emb\|OZ237561.1\|	6108	g364073	i0	100	0.520231213872832	28	0	16	0	1	28	12046804	12046831	Anemonia sulcata genome assembly, chromosome: 7	blastn	90	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
20903096	20903096	PRJNA529241_P_NODE_430437_length_164_cov_1.842520_g428115_i0	PRJNA529241	430437	164	1.84252	3.0217328	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	52.8	0.014	NTclustered	gi\|2744808726\|ref\|XM_012698110.3\|	6087	g428115	i0	90.244	0.25	41	2	24	2	82	121	1092	1131	PREDICTED: Hydra vulgaris uncharacterized LOC105843149 (LOC105843149), transcript variant X1, mRNA	blastn	41	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
22176114	22176114	PRJNA529241_P_NODE_235618_length_173_cov_4.808824_g233296_i0	PRJNA529241	235618	173	4.808824	8.31926552	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	54.7	0.004	NTclustered	gi\|2917940720\|emb\|OZ237562.1\|	6108	g233296	i0	100	0.167630057803468	29	0	17	0	134	162	12117082	12117110	Anemonia sulcata genome assembly, chromosome: 8	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
24066614	24066614	PRJNA529241_P_NODE_131719_length_195_cov_4.297468_g129397_i0	PRJNA529241	131719	195	4.297468	8.3800626	Metazoa	33208	Cnidaria	other_Eukaryota	58.4	3.62e-4	NTclustered	gi\|2918369563\|emb\|OZ237729.1\|	317547	g129397	i0	100	0.476923076923077	31	0	16	0	7	37	1011793	1011823	Eunicella cavolini genome assembly, chromosome: 13	blastn	93	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
26712579	26712579	PRJNA529241_P_NODE_479601_length_151_cov_7.070175_g477279_i0	PRJNA529241	479601	151	7.070175	10.67596425	Metazoa	33208	Cnidaria	other_Eukaryota	42.7	0.0104	NR	XP_057317583.1	13093	g477279	i0	48.3	1.7682119205298	29	15	57.6	0	1	87	205	233	XP_057317583.1 RING finger protein 141-like [Hydractinia symbiolongicarpus]	diamond	267	43.1	0.990719257540603	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
27140360	27140360	PRJNA529241_P_NODE_392102_length_173_cov_2.375000_g389780_i0	PRJNA529241	392102	173	2.375	4.10875	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	42.7	0.0148	NR	XP_028413947.1	151771	g389780	i0	66.7	0.832369942196532	24	8	41.6	0	171	100	520	543	XP_028413947.1 uncharacterized protein LOC114536804 [Dendronephthya gigantea]	diamond	144	42.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
27835477	27835477	PRJNA529241_P_NODE_436404_length_162_cov_0.904000_g434082_i0	PRJNA529241	436404	162	0.904	1.46448	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	80.9	2.4e-18	NR	KAK3732718.1	3060491	g434082	i0	73.1	142.203703703704	52	14	96.3	0	160	5	34	85	KAK3732718.1 hypothetical protein QZH41_003064 [Actinostola sp. cb2023]	diamond	23037	80.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023
28877472	28877472	PRJNA529241_P_NODE_424968_length_166_cov_2.418605_g422646_i0	PRJNA529241	424968	166	2.418605	4.0148843	Montipora foliosa	591990	Cnidaria	other_Eukaryota	40.8	0.0434	NR	XP_068706487.1	591990	g422646	i0	59.4	1.1566265060241	32	11	54.2	1	128	39	114	145	XP_068706487.1 AP-5 complex subunit sigma-1-like isoform X3 [Montipora foliosa]	diamond	192	40.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora foliosa
31293297	31293297	PRJNA529241_P_NODE_425315_length_166_cov_1.426357_g422993_i0	PRJNA529241	425315	166	1.426357	2.36775262	Acropora	6127	Cnidaria	other_Eukaryota	50.1	3.32e-5	NR	KAK2555066.1	6130	g422993	i0	48.1	3.8855421686747	54	26	94	1	161	6	499	552	KAK2555066.1 Transient receptor potential cation channel subfamily A member 1 [Acropora cervicornis]	diamond	645	50.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
32322398	32322398	PRJNA529241_P_NODE_298699_length_173_cov_3.566176_g296377_i0	PRJNA529241	298699	173	3.566176	6.16948448	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	42.4	0.0198	NR	XP_020608850.1	48498	g296377	i0	41.3	0.797687861271676	46	27	79.8	0	16	153	295	340	XP_020608850.1 tyrosyl-DNA phosphodiesterase 1-like [Orbicella faveolata]	diamond	138	42.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);;