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

4 rows where analysis = "diamond", bioproject = "PRJNA572587" 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
27269098	27269098	PRJNA572587_P_NODE_39163_length_175_cov_3.492063_g38835_i0	PRJNA572587	39163	175	3.492063	6.11111025	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	100	7.689999999999999e-23	NR	AAX28387.3	6182	g38835	i0	94.1	1.74857142857143	51	3	87.4	0	22	174	445	495	AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum]	diamond	306	100	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
29510904	29510904	PRJNA572587_P_NODE_15950_length_287_cov_14.521008_g15622_i0	PRJNA572587	15950	287	14.521008	41.67529296	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	43.5	0.0354	NR	CAH8664748.1	57078	g15622	i0	36.9	0.878048780487805	84	46	83.6	4	240	1	2665	2745	CAH8664748.1 unnamed protein product [Dicrocoelium dendriticum]	diamond	252	43.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
31533473	31533473	PRJNA572587_P_NODE_7696_length_438_cov_29.372751_g7371_i0	PRJNA572587	7696	438	29.372751	128.65264938	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	130	3.75e-35	NR	AAX25032.2	6182	g7371	i0	78.2	0.534246575342466	78	17	53.4	0	24	257	102	179	AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum]	diamond	234	130	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
32229425	32229425	PRJNA572587_P_NODE_31458_length_198_cov_2.006711_g31130_i0	PRJNA572587	31458	198	2.006711	3.97328778	Clonorchis sinensis	79923	Platyhelminthes	Platyhelminthes	40.4	0.031	NR	GAA50846.1	79923	g31130	i0	59.3	0.409090909090909	27	11	40.9	0	14	94	59	85	GAA50846.1 U6 snRNA-associated Sm-like protein LSm8 [Clonorchis sinensis]	diamond	81	40.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis

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