metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax

6 rows where analysis = "diamond", bioproject = "PRJDB9741" 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
3837277	3837277	PRJDB9741_P_NODE_8584_length_215_cov_3.259036_g8267_i0	PRJDB9741	8584	215	3.259036	7.0069274	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	112	1.5999999999999999e-29	NR	KAA0196388.1	27845	g8267	i0	75.7	6.86511627906977	70	17	97.7	0	4	213	50	119	KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii]	diamond	1476	112	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
15009770	15009770	PRJDB9741_P_NODE_5652_length_265_cov_1.166667_g5336_i0	PRJDB9741	5652	265	1.166667	3.09166755	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	140	3.82e-40	NR	KAA0196388.1	27845	g5336	i0	74.7	10.8339622641509	87	22	98.5	0	263	3	53	139	KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii]	diamond	2871	141	0.99290780141844	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
27632900	27632900	PRJDB9741_P_NODE_7684_length_226_cov_4.395480_g7367_i0	PRJDB9741	7684	226	4.39548	9.9337848	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	79.3	7.58e-17	NR	AAW27122.1	6182	g7367	i0	83.7	0.650442477876106	49	6	62.4	1	205	65	1	49	AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum]	diamond	147	79.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30001092	30001092	PRJDB9741_P_NODE_25751_length_169_cov_1.658333_g25434_i0	PRJDB9741	25751	169	1.658333	2.80258277	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	67.4	2.63e-11	NR	PAA49706.1	282301	g25434	i0	75.6	2.18343195266272	41	10	72.8	0	168	46	358	398	PAA49706.1 hypothetical protein BOX15_Mlig025502g3 [Macrostomum lignano]	diamond	369	67.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
31163716	31163716	PRJDB9741_P_NODE_30575_length_166_cov_0.871795_g30258_i0	PRJDB9741	30575	166	0.871795	1.4471797	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	58.9	1.88e-8	NR	VDL96212.1	70667	g30258	i0	49.1	6.32530120481928	55	28	99.4	0	2	166	6	60	VDL96212.1 unnamed protein product [Schistocephalus solidus]	diamond	1050	58.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Schistocephalus	Schistocephalus solidus
31581272	31581272	PRJDB9741_P_NODE_4596_length_301_cov_1.285714_g4280_i0	PRJDB9741	4596	301	1.285714	3.86999914	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	45.8	0.0059	NR	PAA93605.1	282301	g4280	i0	32.5	1.53488372093023	77	51	76.7	1	235	5	328	403	PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano]	diamond	462	45.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano

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