metadata: contig_metadata: 5 rows where bioproject = "PRJNA1150539", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA1150539", 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
26818895	26818895	PRJNA1150539_S_NODE_51361_length_309_cov_0.978814_g50765_i0	PRJNA1150539	51361	309	0.978814	3.02453526	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	54.3	7.46e-6	NR	XP_006826086.1	10224	g50765	i0	47.8	0.446601941747573	46	24	44.7	0	88	225	1156	1201	XP_006826086.1 PREDICTED: uncharacterized protein LOC102808992 [Saccoglossus kowalevskii]	diamond	138	54.3	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
26976952	26976952	PRJNA1150539_S_NODE_8402_length_460_cov_4.439276_g7808_i0	PRJNA1150539	8402	460	4.4392760000000004	20.4206696	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	47.4	0.00858	NR	XP_006826086.1	10224	g7808	i0	42.9	0.319565217391304	49	28	32	0	180	326	1177	1225	XP_006826086.1 PREDICTED: uncharacterized protein LOC102808992 [Saccoglossus kowalevskii]	diamond	147	47.4	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
28019614	28019614	PRJNA1150539_S_NODE_67345_length_283_cov_2.933333_g66749_i0	PRJNA1150539	67345	283	2.933333	8.30133239	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	93.2	1.04e-19	NR	XP_006820893.1	10224	g66749	i0	51.6	2.01413427561837	95	43	99.6	2	282	1	121	213	XP_006820893.1 PREDICTED: uncharacterized protein LOC102808110 [Saccoglossus kowalevskii]	diamond	570	93.2	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
30419786	30419786	PRJNA1150539_S_NODE_96673_length_246_cov_4.745665_g96077_i0	PRJNA1150539	96673	246	4.745665	11.6743359	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	50.8	5.48e-5	NR	XP_006826086.1	10224	g96077	i0	54.8	0.51219512195122	42	19	51.2	0	128	3	1151	1192	XP_006826086.1 PREDICTED: uncharacterized protein LOC102808992 [Saccoglossus kowalevskii]	diamond	126	50.8	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
31589052	31589052	PRJNA1150539_S_NODE_43256_length_323_cov_3.824000_g42660_i0	PRJNA1150539	43256	323	3.824	12.35152	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	84	3.38e-16	NR	XP_006826086.1	10224	g42660	i0	50	0.761609907120743	82	41	76.2	0	310	65	1112	1193	XP_006826086.1 PREDICTED: uncharacterized protein LOC102808992 [Saccoglossus kowalevskii]	diamond	246	84	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);;