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

4 rows where analysis = "diamond", bioproject = "PRJNA1054617" 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
27288153	27288153	PRJNA1054617_S_NODE_16163_length_150_cov_1.289720_g16075_i0	PRJNA1054617	16163	150	1.28972	1.93458	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	79.7	6.76e-17	NR	AAX25032.2	6182	g16075	i0	87.2	0.78	39	5	78	0	117	1	89	127	AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum]	diamond	117	79.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
29025225	29025225	PRJNA1054617_S_NODE_7248_length_209_cov_1.662651_g7160_i0	PRJNA1054617	7248	209	1.662651	3.47494059	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	64.3	1.3099999999999999e-10	NR	AAX25032.2	6182	g7160	i0	62.2	0.645933014354067	45	17	64.6	0	156	22	90	134	AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum]	diamond	135	64.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30098408	30098408	PRJNA1054617_S_NODE_4552_length_252_cov_1.454545_g4464_i0	PRJNA1054617	4552	252	1.454545	3.6654534	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	47.8	4.05e-4	NR	AAX25032.2	6182	g4464	i0	81.5	0.702380952380952	27	5	32.1	0	217	137	37	63	AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum]	diamond	177	47.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
32311874	32311874	PRJNA1054617_S_NODE_6059_length_224_cov_126.071823_g5971_i0	PRJNA1054617	6059	224	126.071823	282.40088352	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	78.6	1.46e-16	NR	AAW27122.1	6182	g5971	i0	81.6	0.65625	49	7	62.9	1	168	28	1	49	AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum]	diamond	147	78.6	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);;