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

10 rows where analysis = "diamond", bioproject = "PRJNA508758" 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
4311348	4311348	PRJNA508758_P_NODE_21764_length_430_cov_14.120448_g20717_i0	PRJNA508758	21764	430	14.120448	60.7179264	Ptychodera flava	63121	Hemichordata	other_Eukaryota	190	1.17e-59	NR	XP_070578318.1	63121	g20717	i0	71.9	6.53023255813954	114	32	79.5	0	40	381	15	128	XP_070578318.1 DNA-directed RNA polymerase II subunit RPB9-like [Ptychodera flava]	diamond	2808	190	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
26712450	26712450	PRJNA508758_P_NODE_45541_length_312_cov_1.610879_g44493_i0	PRJNA508758	45541	312	1.610879	5.02594248	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.7	0.0175	NR	XP_006821523.1	10224	g44493	i0	40.8	0.942307692307692	49	29	47.1	0	150	4	34	82	XP_006821523.1 PREDICTED: conserved oligomeric Golgi complex subunit 8-like [Saccoglossus kowalevskii]	diamond	294	44.7	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
27077124	27077124	PRJNA508758_P_NODE_16602_length_499_cov_1.544601_g15555_i0	PRJNA508758	16602	499	1.544601	7.70755899	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	160	3.71e-42	NR	XP_002734641.1	10224	g15555	i0	55.6	2.11022044088176	117	52	70.3	0	3	353	637	753	XP_002734641.1 PREDICTED: testin-like [Saccoglossus kowalevskii]	diamond	1053	160	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
27693039	27693039	PRJNA508758_P_NODE_14404_length_541_cov_4.380342_g13382_i0	PRJNA508758	14404	541	4.380342	23.69765022	Metazoa	33208	Hemichordata	other_Eukaryota	87.4	6.67e-18	NR	XP_070546437.1	63121	g13382	i0	31.8	5.42329020332717	173	110	91.5	1	37	531	3	175	XP_070546437.1 dynactin subunit 6-like [Ptychodera flava]	diamond	2934	87.4	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
27772304	27772304	PRJNA508758_P_NODE_46904_length_308_cov_1.702128_g45856_i0	PRJNA508758	46904	308	1.702128	5.24255424	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	43.1	0.0214	NR	XP_006822713.1	10224	g45856	i0	37.2	0.418831168831169	43	27	41.9	0	117	245	83	125	XP_006822713.1 PREDICTED: uncharacterized protein LOC102806180 [Saccoglossus kowalevskii]	diamond	129	43.1	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
28277136	28277136	PRJNA508758_P_NODE_80326_length_246_cov_2.202312_g79278_i0	PRJNA508758	80326	246	2.202312	5.41768752	Ptychodera flava	63121	Hemichordata	other_Eukaryota	67	1.14e-10	NR	XP_070562121.1	63121	g79278	i0	41.5	1	82	48	100	0	1	246	298	379	XP_070562121.1 LOW QUALITY PROTEIN: condensin complex subunit 1-like [Ptychodera flava]	diamond	246	67	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
28719382	28719382	PRJNA508758_P_NODE_46567_length_309_cov_1.703390_g45519_i0	PRJNA508758	46567	309	1.70339	5.2634751	Ptychodera flava	63121	Hemichordata	other_Eukaryota	67.4	1.7e-10	NR	XP_070542930.1	63121	g45519	i0	49.4	6.27184466019417	83	36	74.8	1	231	1	328	410	XP_070542930.1 heterogeneous nuclear ribonucleoprotein K-like isoform X1 [Ptychodera flava]	diamond	1938	67.4	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
29082116	29082116	PRJNA508758_P_NODE_13028_length_576_cov_2.491054_g12020_i0	PRJNA508758	13028	576	2.491054	14.34847104	Metazoa	33208	Hemichordata	other_Eukaryota	123	1.06e-30	NR	XP_070567638.1	63121	g12020	i0	43.1	3.140625	153	74	75.5	2	537	103	114	261	XP_070567638.1 uncharacterized protein [Ptychodera flava]	diamond	1809	123	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
31767629	31767629	PRJNA508758_P_NODE_7077_length_870_cov_5.367629_g6234_i0	PRJNA508758	7077	870	5.367629	46.6983723	Metazoa	33208	Hemichordata	other_Eukaryota	316	5.569999999999999e-98	NR	XP_070582113.1	63121	g6234	i0	55.8	6.17931034482759	303	120	99.7	4	1	867	548	850	XP_070582113.1 pre-mRNA-splicing factor SYF1-like [Ptychodera flava]	diamond	5376	317	0.996845425867508	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
31830750	31830750	PRJNA508758_P_NODE_37877_length_336_cov_2.110266_g36829_i0	PRJNA508758	37877	336	2.110266	7.09049376	Metazoa	33208	Hemichordata	other_Eukaryota	48.5	0.0011	NR	XP_070532518.1	63121	g36829	i0	37.1	1.66964285714286	62	36	52.7	2	16	192	2405	2466	XP_070532518.1 protein eyes shut homolog isoform X2 [Ptychodera flava]	diamond	561	48.9	0.991820040899796	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava

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