metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA550047" 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
26712726	26712726	PRJNA550047_P_NODE_481541_length_236_cov_17.294479_g479568_i0	PRJNA550047	481541	236	17.294479	40.81497044	Metazoa	33208	Cnidaria	other_Eukaryota	72	1.63e-12	NR	CAB4044065.1	317549	g479568	i0	44.6	1.91949152542373	74	41	94.1	0	222	1	122	195	CAB4044065.1 Transposon Ty3-G Gag-Pol poly [Paramuricea clavata]	diamond	453	72	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
27583476	27583476	PRJNA550047_P_NODE_334084_length_291_cov_5.619266_g332114_i0	PRJNA550047	334084	291	5.619266	16.35206406	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	49.3	2.1e-4	NR	PFX22390.1	50429	g332114	i0	29.8	0.969072164948454	94	58	88.7	2	258	1	78	171	PFX22390.1 Tigger transposable element-derived protein 6 [Stylophora pistillata]	diamond	282	49.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
28467880	28467880	PRJNA550047_P_NODE_495166_length_232_cov_6.257862_g493193_i0	PRJNA550047	495166	232	6.257862	14.51823984	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	62.4	1.3e-10	NR	CAB4018876.1	317549	g493193	i0	43.8	0.943965517241379	73	39	93.1	2	15	230	9	80	CAB4018876.1 Sel1 repeat-containing 1A [Paramuricea clavata]	diamond	219	62.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
28909299	28909299	PRJNA550047_P_NODE_147548_length_345_cov_4.871324_g145588_i0	PRJNA550047	147548	345	4.871324	16.8060678	Acropora millepora	45264	Cnidaria	other_Eukaryota	47.8	0.00203	NR	XP_029186312.2	45264	g145588	i0	49	0.426086956521739	49	25	42.6	0	3	149	87	135	XP_029186312.2 gamma-tubulin complex component 4-like [Acropora millepora]	diamond	147	47.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
29036097	29036097	PRJNA550047_P_NODE_161388_length_345_cov_3.981618_g159428_i0	PRJNA550047	161388	345	3.981618	13.7365821	Acropora muricata	159855	Cnidaria	other_Eukaryota	77.8	3.86e-14	NR	XP_067026538.1	159855	g159428	i0	67.4	0.4	46	15	40	0	334	197	208	253	XP_067026538.1 uncharacterized protein [Acropora muricata]	diamond	138	77.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora muricata
32052668	32052668	PRJNA550047_P_NODE_402938_length_264_cov_3.094241_g400966_i0	PRJNA550047	402938	264	3.094241	8.16879624	Pocillopora	46730	Cnidaria	other_Eukaryota	48.5	4.58e-4	NR	RMX46056.1	46731	g400966	i0	48.8	2.86363636363636	43	22	48.9	0	8	136	2519	2561	RMX46056.1 hypothetical protein pdam_00002040 [Pocillopora damicornis]	diamond	756	48.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
32481208	32481208	PRJNA550047_P_NODE_71839_length_345_cov_12.033088_g69879_i0	PRJNA550047	71839	345	12.033088	41.5141536	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	42	0.0375	NR	CAB3987432.1	317549	g69879	i0	45.2	0.365217391304348	42	23	36.5	0	344	219	7	48	CAB3987432.1 Hypothetical predicted protein, partial [Paramuricea clavata]	diamond	126	42	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
32607313	32607313	PRJNA550047_P_NODE_50160_length_345_cov_22.566176_g48200_i0	PRJNA550047	50160	345	22.566176	77.8533072	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	51.2	1.33e-4	NR	XP_065056493.1	499914	g48200	i0	24.2	1.89565217391304	120	76	91.3	1	342	28	540	659	XP_065056493.1 importin-5-like [Rhopilema esculentum]	diamond	654	51.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
32764631	32764631	PRJNA550047_P_NODE_332460_length_291_cov_12.972477_g330490_i0	PRJNA550047	332460	291	12.972477	37.74990807	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	43.9	0.0262	NR	XP_057310690.1	13093	g330490	i0	40.5	0.43298969072165	42	25	43.3	0	131	6	1098	1139	XP_057310690.1 uncharacterized protein LOC130648651 [Hydractinia symbiolongicarpus]	diamond	126	43.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
32890448	32890448	PRJNA550047_P_NODE_244440_length_300_cov_12.568282_g242471_i0	PRJNA550047	244440	300	12.568282	37.704846	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	43.9	0.0282	NR	KAK3707093.1	3060491	g242471	i0	46.3	0.54	54	23	49	2	296	150	67	119	KAK3707093.1 hypothetical protein QZH41_004166 [Actinostola sp. cb2023]	diamond	162	43.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023

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