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

10 rows where analysis = "diamond", bioproject = "PRJEB81327" 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
140254	140254	PRJEB81327_P_NODE_8261_length_484_cov_1.116788_g7654_i0	PRJEB81327	8261	484	1.116788	5.40525392	Acropora digitifera	70779	Cnidaria	other_Eukaryota	190	1.42e-58	NR	XP_015754731.1	70779	g7654	i0	66.9	0.91735537190082606	148	48	91.7	1	446	3	1	147	XP_015754731.1 PREDICTED: 60S ribosomal protein L17-like isoform X1 [Acropora digitifera]	diamond	444	190	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
23091554	23091554	PRJEB81327_P_NODE_18599_length_313_cov_1.604167_g17991_i0	PRJEB81327	18599	313	1.604167	5.02104271	root	1	Root_unresolved	Root_unresolved	114	7.76e-30	NR	XP_020605211.1	48498	g17991	i0	63.7	8.30990415335463	91	32	86.3	1	271	2	22	112	XP_020605211.1 60S ribosomal protein L32-like [Orbicella faveolata]	diamond	2601	114	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
26646855	26646855	PRJEB81327_P_NODE_13661_length_365_cov_3.095890_g13053_i0	PRJEB81327	13661	365	3.09589	11.2999985	Opisthokonta	33154	Cnidaria	other_Eukaryota	183	9.99e-57	NR	XP_002165574.2	6087	g13053	i0	69.2	43.3479452054795	120	37	98.6	0	5	364	15	134	XP_002165574.2 eukaryotic translation initiation factor 5A [Hydra vulgaris]	diamond	15822	184	0.994565217391304	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
26646856	26646856	PRJEB81327_P_NODE_45721_length_251_cov_2.292135_g45113_i0	PRJEB81327	45721	251	2.292135	5.75325885	root	1	Root_unresolved	Root_unresolved	77.8	1.87e-14	NR	CAB4006378.1	317549	g45113	i0	41	8.23505976095618	83	49	99.2	0	3	251	296	378	CAB4006378.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	2067	78.2	0.994884910485933	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
26844634	26844634	PRJEB81327_P_NODE_57281_length_245_cov_0.895349_g56673_i0	PRJEB81327	57281	245	0.895349	2.19360505	Desmophyllum pertusum	174260	Cnidaria	other_Eukaryota	51.2	2.8e-5	NR	KAJ7383649.1	174260	g56673	i0	40	0.857142857142857	70	41	85.7	1	15	224	6	74	KAJ7383649.1 Activator of basal transcription 1 [Desmophyllum pertusum]	diamond	210	51.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Caryophylliidae	Desmophyllum	Desmophyllum pertusum
27002408	27002408	PRJEB81327_P_NODE_13822_length_363_cov_1.589655_g13214_i0	PRJEB81327	13822	363	1.589655	5.77044765	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	146	7.0199999999999986e-43	NR	XP_028401732.1	151771	g13214	i0	66.4	0.909090909090909	110	28	84.3	2	37	342	5	113	XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea]	diamond	330	146	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
28953594	28953594	PRJEB81327_P_NODE_17668_length_321_cov_3.189516_g17060_i0	PRJEB81327	17668	321	3.189516	10.23834636	Scleractinia	6125	Cnidaria	other_Eukaryota	88.2	1.05e-17	NR	CAH3152834.1	104759	g17060	i0	49.5	7.91588785046729	93	47	86.9	0	3	281	1036	1128	CAH3152834.1 unnamed protein product [Porites lobata]	diamond	2541	88.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
29213478	29213478	PRJEB81327_P_NODE_15909_length_338_cov_3.075472_g15301_i0	PRJEB81327	15909	338	3.075472	10.39509536	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	127	5.709999999999999e-32	NR	XP_028392378.1	151771	g15301	i0	51.8	5.95562130177515	112	54	99.4	0	338	3	82	193	XP_028392378.1 xaa-Pro dipeptidase-like isoform X1 [Dendronephthya gigantea]	diamond	2013	127	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
30160420	30160420	PRJEB81327_P_NODE_14712_length_351_cov_1.381295_g14104_i0	PRJEB81327	14712	351	1.381295	4.84834545	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	143	1.19e-40	NR	XP_020907839.1	2652724	g14104	i0	70.8	4.5042735042735	106	31	90.6	0	350	33	60	165	XP_020907839.1 60S ribosomal protein L17 [Exaiptasia diaphana]	diamond	1581	143	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
32120801	32120801	PRJEB81327_P_NODE_63798_length_242_cov_0.875740_g63190_i0	PRJEB81327	63798	242	0.87574	2.1192908	Porites evermanni	104178	Cnidaria	other_Eukaryota	88.2	2.83e-20	NR	CAH3181837.1	104178	g63190	i0	53.3	0.929752066115702	75	35	93	0	237	13	38	112	CAH3181837.1 unnamed protein product, partial [Porites evermanni]	diamond	225	88.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni

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