metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA453567" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA453567" 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
441799	441799	PRJNA453567_P_NODE_17881_length_211_cov_1.344828_g17644_i0	PRJNA453567	17881	211	1.344828	2.83758708	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	54.7	0.005	NTclustered	gi\|690721831\|emb\|LN274429.1\|	99802	g17644	i0	96.875	0.947867298578199	32	1	15	0	139	170	1138	1107	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0067294	blastn	200	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
441933	441933	PRJNA453567_P_NODE_5581_length_429_cov_4.892857_g5345_i0	PRJNA453567	5581	429	4.892857	20.99035653	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	516	1.22e-141	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g5345	i0	88.863	0.983682983682984	422	44	98	3	4	423	432	12	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	422	516	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
1093448	1093448	PRJNA453567_P_NODE_33321_length_152_cov_1.200000_g33084_i0	PRJNA453567	33321	152	1.2	1.824	Metazoa	33208	Platyhelminthes	Platyhelminthes	56.5	0.001	NTclustered	gi\|690628440\|emb\|LN173117.1\|	99802	g33084	i0	96.97	1.38815789473684	33	1	22	0	16	48	1145	1177	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0020125	blastn	211	56.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
11920722	11920722	PRJNA453567_P_NODE_6790_length_380_cov_2.160350_g6554_i0	PRJNA453567	6790	380	2.16035	8.20933	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	52.8	0.036	NTclustered	gi\|684375731\|ref\|XM_009166899.1\|	6198	g6554	i0	100	0.0736842105263158	28	0	7	0	138	165	302	275	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
14470409	14470409	PRJNA453567_P_NODE_12772_length_258_cov_1.058824_g12535_i0	PRJNA453567	12772	258	1.058824	2.73176592	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	56.5	0.002	NTclustered	gi\|690792655\|emb\|LN306892.1\|	99802	g12535	i0	100	3.58139534883721	30	0	12	0	117	146	893	922	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0088843	blastn	924	56.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei

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