metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA981359" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA981359" and tax_phylum = "Platyhelminthes"

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
22639171	22639171	PRJNA981359_S_NODE_25378_length_341_cov_2.619403_g25278_i0	PRJNA981359	25378	341	2.619403	8.93216423	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	90.9	1.44e-18	NR	VZI19895.1	99802	g25278	i0	47.1	4.68035190615836	87	46	76.5	0	44	304	360	446	VZI19895.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	1596	90.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
27279252	27279252	PRJNA981359_S_NODE_42723_length_296_cov_2.098655_g42623_i0	PRJNA981359	42723	296	2.098655	6.2120188	Trichobilharzia regenti	157069	Platyhelminthes	Platyhelminthes	53.5	1.12e-5	NR	CAH8840565.1	157069	g42623	i0	38.4	2.00675675675676	99	42	81.1	2	10	249	200	298	CAH8840565.1 unnamed protein product [Trichobilharzia regenti]	diamond	594	53.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia regenti
29710115	29710115	PRJNA981359_S_NODE_33210_length_319_cov_1.215447_g33110_i0	PRJNA981359	33210	319	1.215447	3.87727593	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	43.9	0.0368	NR	VZI35910.1	99802	g33110	i0	46.2	0.366771159874608	39	21	36.7	0	5	121	1094	1132	VZI35910.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	117	43.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
30563111	30563111	PRJNA981359_S_NODE_45753_length_289_cov_4.171296_g45653_i0	PRJNA981359	45753	289	4.171296	12.05504544	Paragonimus westermani	34504	Platyhelminthes	Platyhelminthes	48.9	4.24e-4	NR	KAA3672102.1	34504	g45653	i0	45.1	0.529411764705882	51	28	52.9	0	287	135	545	595	KAA3672102.1 uncharacterized protein DEA37_0004539 [Paragonimus westermani]	diamond	153	48.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus westermani
31549523	31549523	PRJNA981359_S_NODE_43056_length_295_cov_3.279279_g42956_i0	PRJNA981359	43056	295	3.279279	9.67387305	Schistosoma	6181	Platyhelminthes	Platyhelminthes	43.1	0.0404	NR	VDP31476.1	31246	g42956	i0	48.8	0.783050847457627	41	21	41.7	0	221	99	162	202	VDP31476.1 unnamed protein product [Schistosoma mattheei]	diamond	231	43.5	0.990804597701149	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mattheei

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