metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA408129" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA408129" 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
29712770	29712770	PRJNA408129_S_NODE_15530_length_193_cov_4.166667_g15512_i0	PRJNA408129	15530	193	4.166667	8.04166731	Metazoa	33208	Platyhelminthes	Platyhelminthes	49.3	9.42e-5	NR	CAH8846348.1	157069	g15512	i0	33.3	8.51813471502591	54	36	83.9	0	163	2	268	321	CAH8846348.1 unnamed protein product [Trichobilharzia regenti]	diamond	1644	49.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia regenti
30439922	30439922	PRJNA408129_S_NODE_35333_length_151_cov_1.324561_g35315_i0	PRJNA408129	35333	151	1.324561	2.00008711	Schistosoma	6181	Platyhelminthes	Platyhelminthes	41.6	0.0141	NR	VDP56863.1	6186	g35315	i0	66.7	4.2317880794702	30	10	59.6	0	118	29	94	123	VDP56863.1 unnamed protein product, partial [Schistosoma curassoni]	diamond	639	41.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma curassoni
31813919	31813919	PRJNA408129_S_NODE_11597_length_212_cov_3.645714_g11579_i0	PRJNA408129	11597	212	3.645714	7.72891368	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	43.9	0.00998	NR	XP_009169131.1	6198	g11579	i0	41.7	1.18867924528302	48	26	65.1	1	26	163	97	144	XP_009169131.1 hypothetical protein T265_13854, partial [Opisthorchis viverrini]	diamond	252	43.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
32415237	32415237	PRJNA408129_S_NODE_879_length_397_cov_3.697222_g861_i0	PRJNA408129	879	397	3.697222	14.67797134	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	73.6	1.3e-12	NR	XP_051064138.1	6185	g861	i0	38.6	1.17128463476071	83	48	62.7	1	250	2	1	80	XP_051064138.1 uncharacterized protein MS3_00008898 [Schistosoma haematobium]	diamond	465	73.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium

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