metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1123309" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1123309" 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
9206560	9206560	PRJNA1123309_P_NODE_62728_length_244_cov_0.912281_g62348_i0	PRJNA1123309	62728	244	0.912281	2.22596564	Metazoa	33208	Platyhelminthes	Platyhelminthes	124	2.02e-33	NR	VEL10592.1	117903	g62348	i0	70.1	5.66803278688525	77	23	94.7	0	231	1	95	171	VEL10592.1 unnamed protein product [Protopolystoma xenopodis]	diamond	1383	125	0.992	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Protopolystoma	Protopolystoma xenopodis
26932832	26932832	PRJNA1123309_P_NODE_47982_length_253_cov_0.866667_g47602_i0	PRJNA1123309	47982	253	0.866667	2.19266751	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	82.4	1.68e-17	NR	PAA92643.1	282301	g47602	i0	58.7	2.31225296442688	63	26	74.7	0	197	9	2	64	PAA92643.1 hypothetical protein BOX15_Mlig022705g1 [Macrostomum lignano]	diamond	585	82.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
27628260	27628260	PRJNA1123309_P_NODE_8884_length_504_cov_1.064965_g8511_i0	PRJNA1123309	8884	504	1.064965	5.3674236	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	55.8	1.04e-5	NR	VZI22467.1	99802	g8511	i0	27.3	5.94047619047619	128	85	76.2	3	120	503	139	258	VZI22467.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	2994	56.2	0.99288256227758	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
31702878	31702878	PRJNA1123309_P_NODE_41277_length_267_cov_1.829897_g40897_i0	PRJNA1123309	41277	267	1.829897	4.88582499	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	94.4	3.58e-20	NR	VDL17052.1	6216	g40897	i0	55.6	3.61797752808989	81	36	91	0	11	253	1538	1618	VDL17052.1 unnamed protein product [Hymenolepis diminuta]	diamond	966	94.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
31808591	31808591	PRJNA1123309_P_NODE_30057_length_297_cov_0.995536_g29677_i0	PRJNA1123309	30057	297	0.995536	2.95674192	Calicophoron daubneyi	300641	Platyhelminthes	Platyhelminthes	77.8	4.51e-15	NR	CAL5130763.1	300641	g29677	i0	35.9	0.929292929292929	92	59	92.9	0	1	276	122	213	CAL5130763.1 unnamed protein product [Calicophoron daubneyi]	diamond	276	77.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Paramphistomidae	Calicophoron	Calicophoron daubneyi

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