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

4 rows where analysis = "diamond", bioproject = "PRJNA446034" 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
26664218	26664218	PRJNA446034_S_NODE_72581_length_168_cov_2.190840_g72544_i0	PRJNA446034	72581	168	2.19084	3.6806112	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	49.7	3.14e-6	NR	ABA40899.1	6182	g72544	i0	59	0.696428571428571	39	14	66.1	1	147	37	4	42	ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum]	diamond	117	49.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27518442	27518442	PRJNA446034_S_NODE_99603_length_155_cov_5.330508_g99566_i0	PRJNA446034	99603	155	5.330508	8.2622874	Neoheterocotyle quadrispinata	2559910	Platyhelminthes	Platyhelminthes	48.5	9.54e-5	NR	BBJ21535.1	2559910	g99566	i0	62.5	5.05161290322581	32	12	61.9	0	1	96	114	145	BBJ21535.1 cytochrome c oxidase subunit 1, partial [Neoheterocotyle quadrispinata]	diamond	783	48.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Monocotylidea	Monocotylidae	Neoheterocotyle	Neoheterocotyle quadrispinata
30771322	30771322	PRJNA446034_S_NODE_9974_length_262_cov_7.506667_g9937_i0	PRJNA446034	9974	262	7.506667	19.66746754	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	155	1.28e-42	NR	AAX28387.3	6182	g9937	i0	98.8	3.75572519083969	82	1	93.9	0	1	246	101	182	AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum]	diamond	984	156	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
32257757	32257757	PRJNA446034_S_NODE_3538_length_332_cov_5.115254_g3501_i0	PRJNA446034	3538	332	5.115254	16.98264328	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	55.5	1.3e-6	NR	AAX25032.2	6182	g3501	i0	65.9	0.75	41	14	37	0	133	11	147	187	AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum]	diamond	249	55.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum

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