metadata: contig_metadata: 14 rows where bioproject = "PRJNA352610", tax_kingdom = "Metazoa" and tax

14 rows where bioproject = "PRJNA352610", tax_kingdom = "Metazoa" and tax_phylum = "Hemichordata"

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_family	tax_genus	tax_species
1668245	1668245	PRJNA352610_P_NODE_11362_length_351_cov_1.392086_g11301_i0	PRJNA352610	11362	351	1.392086	4.88622186	Ptychodera flava	63121	Hemichordata	other_Eukaryota	142	5.29e-39	NR	XP_070581936.1	63121	g11301	i0	79.5	3.00854700854701	88	18	75.2	0	3	266	213	300	XP_070581936.1 large ribosomal subunit protein eL8-like [Ptychodera flava]	diamond	1056	142	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
4221380	4221380	PRJNA352610_P_NODE_7844_length_404_cov_1.504532_g7783_i0	PRJNA352610	7844	404	1.504532	6.07830928	Metazoa	33208	Hemichordata	other_Eukaryota	206	3.3699999999999995e-61	NR	XP_070531707.1	63121	g7783	i0	77.6	5.94059405940594	134	30	99.5	0	402	1	46	179	XP_070531707.1 T-complex protein 1 subunit beta-like [Ptychodera flava]	diamond	2400	206	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
9321613	9321613	PRJNA352610_P_NODE_11828_length_346_cov_0.846154_g11767_i0	PRJNA352610	11828	346	0.846154	2.92769284	Ptychodera flava	63121	Hemichordata	other_Eukaryota	201	8.06e-62	NR	XP_070544256.1	63121	g11767	i0	78.3	1.99421965317919	115	25	99.7	0	345	1	160	274	XP_070544256.1 hydroxyacyl-coenzyme A dehydrogenase, mitochondrial-like isoform X2 [Ptychodera flava]	diamond	690	201	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
11872192	11872192	PRJNA352610_P_NODE_11450_length_350_cov_1.328520_g11389_i0	PRJNA352610	11450	350	1.32852	4.64982	Hemichordata	10219	Hemichordata	other_Eukaryota	163	4.17e-47	NR	XP_070581936.1	63121	g11389	i0	70.7	9.92571428571429	116	34	99.4	0	2	349	179	294	XP_070581936.1 large ribosomal subunit protein eL8-like [Ptychodera flava]	diamond	3474	163	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
15696801	15696801	PRJNA352610_P_NODE_913_length_887_cov_1.300983_g872_i0	PRJNA352610	913	887	1.300983	11.53971921	root	1	Root_unresolved	Root_unresolved	168	1.92e-45	NR	XP_070532298.1	63121	g872	i0	35.9	4.46110484780158	259	144	85.2	7	7	762	134	377	XP_070532298.1 uncharacterized protein [Ptychodera flava]	diamond	3957	168	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
26648591	26648591	PRJNA352610_P_NODE_22061_length_268_cov_1.184615_g22000_i0	PRJNA352610	22061	268	1.184615	3.1747682	Metazoa	33208	Hemichordata	other_Eukaryota	91.3	5.85e-20	NR	XP_070532578.1	63121	g22000	i0	53.2	3.71641791044776	79	37	88.4	0	243	7	139	217	XP_070532578.1 glutamate--cysteine ligase regulatory subunit-like [Ptychodera flava]	diamond	996	91.3	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
27264525	27264525	PRJNA352610_P_NODE_32003_length_241_cov_0.916667_g31942_i0	PRJNA352610	32003	241	0.916667	2.20916747	Ptychodera flava	63121	Hemichordata	other_Eukaryota	52.4	1.51e-5	NR	XP_070571647.1	63121	g31942	i0	66.7	2.31535269709544	36	12	44.8	0	216	109	29	64	XP_070571647.1 neurogenic locus notch homolog protein 1-like isoform X31 [Ptychodera flava]	diamond	558	52.4	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
27439915	27439915	PRJNA352610_P_NODE_15823_length_310_cov_1.029536_g15762_i0	PRJNA352610	15823	310	1.029536	3.1915616	Metazoa	33208	Hemichordata	other_Eukaryota	158	1.46e-42	NR	XP_002742151.1	10224	g15762	i0	74.8	10.9645161290323	103	26	99.7	0	310	2	532	634	XP_002742151.1 PREDICTED: NADH-ubiquinone oxidoreductase 75 kDa subunit, mitochondrial-like [Saccoglossus kowalevskii]	diamond	3399	158	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
28653858	28653858	PRJNA352610_P_NODE_31467_length_241_cov_1.833333_g31406_i0	PRJNA352610	31467	241	1.833333	4.41833253	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	49.7	1.23e-4	NR	XP_006818287.1	10224	g31406	i0	55.6	0.448132780082988	36	16	44.8	0	6	113	268	303	XP_006818287.1 PREDICTED: low-density lipoprotein receptor-related protein 1B-like [Saccoglossus kowalevskii]	diamond	108	49.7	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
30359655	30359655	PRJNA352610_P_NODE_5132_length_474_cov_2.945137_g5071_i0	PRJNA352610	5132	474	2.945137	13.95994938	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	158	2.33e-44	NR	XP_006825592.1	10224	g5071	i0	56.8	1.9873417721519	148	41	79.1	4	474	100	149	296	XP_006825592.1 PREDICTED: 40S ribosomal protein SA-like [Saccoglossus kowalevskii]	diamond	942	158	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
31134287	31134287	PRJNA352610_P_NODE_26795_length_249_cov_0.875000_g26734_i0	PRJNA352610	26795	249	0.875	2.17875	Metazoa	33208	Hemichordata	other_Eukaryota	135	1.82e-36	NR	XP_002739498.1	10224	g26734	i0	75.6	9.85542168674699	82	20	98.8	0	248	3	183	264	XP_002739498.1 PREDICTED: isocitrate dehydrogenase [NAD] subunit gamma 1, mitochondrial-like [Saccoglossus kowalevskii]	diamond	2454	135	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
31338658	31338658	PRJNA352610_P_NODE_19896_length_281_cov_1.846154_g19835_i0	PRJNA352610	19896	281	1.846154	5.18769274	Ptychodera flava	63121	Hemichordata	other_Eukaryota	83.6	2.49e-16	NR	XP_070566051.1	63121	g19835	i0	55.3	1.00355871886121	94	33	95	3	269	3	1	90	XP_070566051.1 ATP synthase subunit beta, mitochondrial-like isoform X1 [Ptychodera flava]	diamond	282	83.6	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
32256519	32256519	PRJNA352610_P_NODE_25798_length_250_cov_0.870056_g25737_i0	PRJNA352610	25798	250	0.870056	2.17514	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	44.3	0.0114	NR	XP_006812760.1	10224	g25737	i0	33.8	1.536	80	39	92.4	3	18	248	566	634	XP_006812760.1 PREDICTED: uncharacterized protein LOC100370596 [Saccoglossus kowalevskii]	diamond	384	44.3	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
32887217	32887217	PRJNA352610_P_NODE_23340_length_260_cov_1.636364_g23279_i0	PRJNA352610	23340	260	1.636364	4.2545464	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	144	6.639999999999999e-40	NR	XP_006825592.1	10224	g23279	i0	76.5	1.95	85	20	98.1	0	259	5	13	97	XP_006825592.1 PREDICTED: 40S ribosomal protein SA-like [Saccoglossus kowalevskii]	diamond	507	144	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii

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