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

10 rows where analysis = "diamond", bioproject = "PRJNA615351" and tax_phylum = "Ctenophora"

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
27396726	27396726	PRJNA615351_P_NODE_59063_length_608_cov_2.141361_g45913_i0	PRJNA615351	59063	608	2.141361	13.01947488	Mnemiopsis leidyi	27923	Ctenophora	other_Eukaryota	87.8	3.69e-16	NR	AEF59084.1	27923	g45913	i0	38.7	0.547697368421053	111	66	54.8	1	276	608	716	824	AEF59084.1 putative voltage-dependent N-type calcium channel, partial [Mnemiopsis leidyi]	diamond	333	87.8	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Mnemiopsis	Mnemiopsis leidyi
27996440	27996440	PRJNA615351_P_NODE_128285_length_230_cov_1.256410_g114185_i0	PRJNA615351	128285	230	1.25641	2.889743	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	115	2.55e-29	NR	XP_063681478.1	2820187	g114185	i0	77.6	2.97391304347826	76	17	99.1	0	229	2	56	131	XP_063681478.1 small ribosomal subunit protein uS2-like [Bolinopsis microptera]	diamond	684	115	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
28059524	28059524	PRJNA615351_P_NODE_46845_length_775_cov_60.977027_g35255_i0	PRJNA615351	46845	775	60.977027	472.57195925	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	76.6	1.17e-12	NR	XP_063689751.1	2820187	g35255	i0	28.7	0.754838709677419	195	124	73.2	5	643	77	43	228	XP_063689751.1 uncharacterized protein LOC134822563 [Bolinopsis microptera]	diamond	585	76.6	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
28533308	28533308	PRJNA615351_P_NODE_162407_length_174_cov_1.093525_g148307_i0	PRJNA615351	162407	174	1.093525	1.9027335	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	44.3	0.0042	NR	XP_063674807.1	2820187	g148307	i0	38.6	0.982758620689655	57	35	98.3	0	3	173	634	690	XP_063674807.1 piwi-like protein 1 [Bolinopsis microptera]	diamond	171	44.3	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
28691280	28691280	PRJNA615351_P_NODE_37967_length_940_cov_6.138122_g15095_i1	PRJNA615351	37967	940	6.138122	57.6983468	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	66.6	3.63e-8	NR	XP_063676492.1	2820187	g15095	i1	23.7	1.83191489361702	312	194	91.3	11	897	40	31	324	XP_063676492.1 proton-coupled amino acid transporter 1-like [Bolinopsis microptera]	diamond	1722	66.6	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
28722733	28722733	PRJNA615351_P_NODE_3847_length_2926_cov_2.996195_g2720_i0	PRJNA615351	3847	2926	2.996195	87.6686657	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	130	5.25e-27	NR	XP_063683004.1	2820187	g2720	i0	32.7	0.831510594668489	263	150	27	6	7	795	29	264	XP_063683004.1 serine/threonine-protein kinase PLK4-like isoform X2 [Bolinopsis microptera]	diamond	2433	130	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
29606265	29606265	PRJNA615351_P_NODE_175150_length_160_cov_1.856000_g161050_i0	PRJNA615351	175150	160	1.856	2.9696	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	45.1	0.00179	NR	XP_063694548.1	2820187	g161050	i0	45.3	0.99375	53	26	93.8	1	155	6	248	300	XP_063694548.1 LOW QUALITY PROTEIN: copine-3-like [Bolinopsis microptera]	diamond	159	45.1	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
30333759	30333759	PRJNA615351_P_NODE_9852_length_2052_cov_4.728805_g7042_i0	PRJNA615351	9852	2052	4.728805	97.0350786	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	117	9.96e-23	NR	XP_063678796.1	2820187	g7042	i0	20	0.912280701754386	624	404	86	13	1983	220	1589	2153	XP_063678796.1 DNA polymerase epsilon catalytic subunit A-like [Bolinopsis microptera]	diamond	1872	117	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
30585691	30585691	PRJNA615351_P_NODE_105473_length_296_cov_2.068966_g91374_i0	PRJNA615351	105473	296	2.068966	6.12413936	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	68.2	8.53e-11	NR	XP_063681995.1	2820187	g91374	i0	47.8	2.58445945945946	67	34	67.9	1	1	201	814	879	XP_063681995.1 dynein axonemal heavy chain 8-like [Bolinopsis microptera]	diamond	765	68.2	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera
31091593	31091593	PRJNA615351_P_NODE_79875_length_426_cov_2.984655_g65839_i0	PRJNA615351	79875	426	2.984655	12.7146303	Bolinopsis microptera	2820187	Ctenophora	other_Eukaryota	54.7	1.54e-5	NR	XP_063688431.1	2820187	g65839	i0	32.4	1	142	79	93.7	8	425	27	73	206	XP_063688431.1 major surface-labeled trophozoite antigen 417-like [Bolinopsis microptera]	diamond	426	54.7	1	Eukaryota	Opisthokonta	Metazoa	Ctenophora	Tentaculata	Lobata	Bolinopsidae	Bolinopsis	Bolinopsis microptera

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