metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1174207" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1174207" 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
26838421	26838421	PRJNA1174207_P_NODE_28261_length_272_cov_1.160804_g27732_i0	PRJNA1174207	28261	272	1.160804	3.15738688	Metazoa	33208	Cnidaria	other_Eukaryota	107	1.04e-24	NR	XP_057312324.1	13093	g27732	i0	62.1	5.70220588235294	87	32	94.9	1	271	14	357	443	XP_057312324.1 probable protein phosphatase 2C 3 [Hydractinia symbiolongicarpus]	diamond	1551	107	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
27072085	27072085	PRJNA1174207_P_NODE_35502_length_248_cov_1.760000_g34973_i0	PRJNA1174207	35502	248	1.76	4.3648	Montipora foliosa	591990	Cnidaria	other_Eukaryota	44.3	0.0111	NR	XP_068679017.1	591990	g34973	i0	33.8	0.895161290322581	74	47	88.3	2	29	247	43	115	XP_068679017.1 inactive peptidyl-prolyl cis-trans isomerase FKBP6-like isoform X2 [Montipora foliosa]	diamond	222	44.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora foliosa
27198343	27198343	PRJNA1174207_P_NODE_22722_length_298_cov_2.053333_g22193_i0	PRJNA1174207	22722	298	2.053333	6.11893234	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	164	4.87e-50	NR	XP_065065749.1	499914	g22193	i0	75.8	1.99328859060403	99	24	99.7	0	1	297	2	100	XP_065065749.1 small ribosomal subunit protein uS8 [Rhopilema esculentum]	diamond	594	164	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
28354564	28354564	PRJNA1174207_P_NODE_12046_length_428_cov_1.890141_g11519_i0	PRJNA1174207	12046	428	1.890141	8.08980348	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	142	7.399999999999998e-41	NR	XP_065056435.1	499914	g11519	i0	58.6	7.03738317757009	111	46	77.8	0	77	409	3	113	XP_065056435.1 large ribosomal subunit protein eL33-like [Rhopilema esculentum]	diamond	3012	142	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
29301917	29301917	PRJNA1174207_P_NODE_39489_length_243_cov_1.811765_g38960_i0	PRJNA1174207	39489	243	1.811765	4.40258895	Cnidaria	6073	Cnidaria	other_Eukaryota	79	6.6e-15	NR	XP_027042427.1	46731	g38960	i0	50	7.11111111111111	58	29	71.6	0	236	63	1152	1209	XP_027042427.1 LOW QUALITY PROTEIN: WD repeat-containing protein 35-like [Pocillopora damicornis]	diamond	1728	79.3	0.996216897856242	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
29585706	29585706	PRJNA1174207_P_NODE_30730_length_261_cov_4.085106_g30201_i0	PRJNA1174207	30730	261	4.085106	10.66212666	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47.4	4.86e-4	NR	XP_029189783.1	45264	g30201	i0	42.6	2.50574712643678	54	31	62.1	0	196	35	105	158	XP_029189783.1 calmodulin-like [Acropora millepora]	diamond	654	47.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
29819179	29819179	PRJNA1174207_P_NODE_23751_length_291_cov_2.472477_g23222_i0	PRJNA1174207	23751	291	2.472477	7.19490807	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	78.2	2.4e-14	NR	XP_057316447.1	13093	g23222	i0	41	1.98969072164948	100	50	93.8	3	290	18	2021	2120	XP_057316447.1 uncharacterized protein LOC130657480 [Hydractinia symbiolongicarpus]	diamond	579	78.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
29977315	29977315	PRJNA1174207_P_NODE_41571_length_241_cov_0.916667_g41042_i0	PRJNA1174207	41571	241	0.916667	2.20916747	Acropora digitifera	70779	Cnidaria	other_Eukaryota	51.6	2.57e-5	NR	XP_015752986.1	70779	g41042	i0	32.4	3.36099585062241	74	46	87.1	2	212	3	126	199	XP_015752986.1 PREDICTED: BTB/POZ domain-containing protein 6-like isoform X5 [Acropora digitifera]	diamond	810	51.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
30577410	30577410	PRJNA1174207_P_NODE_14353_length_384_cov_0.971061_g13824_i0	PRJNA1174207	14353	384	0.971061	3.72887424	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	85.1	1.44e-16	NR	XP_066914638.1	252671	g13824	i0	37.6	1.953125	125	49	97.7	2	8	382	58	153	XP_066914638.1 dTDP-glucose 4,6-dehydratase-like [Clytia hemisphaerica]	diamond	750	85.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
31241052	31241052	PRJNA1174207_P_NODE_40675_length_242_cov_0.911243_g40146_i0	PRJNA1174207	40675	242	0.911243	2.20520806	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	81.3	4.86e-16	NR	XP_065071704.1	499914	g40146	i0	61.1	2.00826446280992	54	21	66.9	0	81	242	172	225	XP_065071704.1 glutaredoxin-3-like [Rhopilema esculentum]	diamond	486	81.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
31905378	31905378	PRJNA1174207_P_NODE_41457_length_241_cov_0.916667_g40928_i0	PRJNA1174207	41457	241	0.916667	2.20916747	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	53.9	4.18e-6	NR	XP_028391390.1	151771	g40928	i0	32.9	1.92946058091286	79	51	98.3	1	241	5	370	446	XP_028391390.1 WD repeat-containing protein 1-like [Dendronephthya gigantea]	diamond	465	53.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
31968624	31968624	PRJNA1174207_P_NODE_23558_length_292_cov_2.602740_g23029_i0	PRJNA1174207	23558	292	2.60274	7.6000008	Montipora capricornis	246305	Cnidaria	other_Eukaryota	59.7	6.71e-8	NR	XP_068746382.1	246305	g23029	i0	63.4	0.421232876712329	41	14	41.1	1	171	290	79	119	XP_068746382.1 uncharacterized protein [Montipora capricornis]	diamond	123	59.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
32462670	32462670	PRJNA1174207_P_NODE_30839_length_261_cov_1.638298_g30310_i0	PRJNA1174207	30839	261	1.638298	4.27595778	Opisthokonta	33154	Cnidaria	other_Eukaryota	79.7	9.09e-17	NR	XP_031561497.1	6105	g30310	i0	48.2	3.90804597701149	85	43	97.7	1	260	6	27	110	XP_031561497.1 60S ribosomal protein L14-like [Actinia tenebrosa]	diamond	1020	79.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
32758791	32758791	PRJNA1174207_P_NODE_28840_length_269_cov_2.173469_g28311_i0	PRJNA1174207	28840	269	2.173469	5.84663161	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	104	8.64e-25	NR	XP_027047034.1	46731	g28311	i0	57.7	0.869888475836431	78	33	87	0	269	36	221	298	XP_027047034.1 cyclin-dependent kinase 1-like [Pocillopora damicornis]	diamond	234	104	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis

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