metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA846110" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA846110" 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
7211313	7211313	PRJNA846110_P_NODE_866_length_1071_cov_1.945892_g709_i0	PRJNA846110	866	1071	1.945892	20.84050332	Metazoa	33208	Platyhelminthes	Platyhelminthes	581	1.1699999999999995e-202	NR	ABS52704.1	6192	g709	i0	82.6	314.977591036415	357	60	100	1	1071	1	116	470	ABS52704.1 heat shock protein 70 [Fasciola hepatica]	diamond	337341	583	0.996569468267582	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
27086425	27086425	PRJNA846110_P_NODE_15782_length_283_cov_2.680952_g15537_i0	PRJNA846110	15782	283	2.680952	7.58709416	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	106	2.17e-26	NR	KAL3307196.1	1844966	g15537	i0	61.2	0.710247349823322	67	26	71	0	281	81	122	188	KAL3307196.1 hypothetical protein Ciccas_014297 [Cichlidogyrus casuarinus]	diamond	201	106	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
27505747	27505747	PRJNA846110_P_NODE_16423_length_280_cov_2.806763_g16178_i0	PRJNA846110	16423	280	2.806763	7.8589364	Metazoa	33208	Platyhelminthes	Platyhelminthes	183	3.99e-54	NR	XP_051075095.1	6185	g16178	i0	98.9	174.375	93	1	99.6	0	1	279	241	333	XP_051075095.1 26S proteasome regulatory subunit 6B, variant 3 [Schistosoma haematobium]	diamond	48825	184	0.994565217391304	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
29233802	29233802	PRJNA846110_P_NODE_27989_length_244_cov_0.900585_g27744_i0	PRJNA846110	27989	244	0.900585	2.1974274	Paragonimus skrjabini miyazakii	59628	Platyhelminthes	Platyhelminthes	80.5	1.98e-15	NR	KAF7258569.1	59628	g27744	i0	70.9	0.676229508196721	55	16	67.6	0	1	165	961	1015	KAF7258569.1 hypothetical protein EG68_03236 [Paragonimus skrjabini miyazakii]	diamond	165	80.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus skrjabini miyazakii
30339616	30339616	PRJNA846110_P_NODE_26592_length_246_cov_0.890173_g26347_i0	PRJNA846110	26592	246	0.890173	2.18982558	Paragonimus skrjabini miyazakii	59628	Platyhelminthes	Platyhelminthes	106	9.96e-25	NR	KAF7257817.1	59628	g26347	i0	56.2	1.08536585365854	89	31	98.8	1	244	2	372	460	KAF7257817.1 hypothetical protein EG68_05064 [Paragonimus skrjabini miyazakii]	diamond	267	106	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus skrjabini miyazakii
30821474	30821474	PRJNA846110_P_NODE_5774_length_434_cov_0.808864_g5530_i0	PRJNA846110	5774	434	0.808864	3.51046976	Metazoa	33208	Platyhelminthes	Platyhelminthes	121	8.15e-29	NR	CAH8508541.1	57078	g5530	i0	45.6	7.13364055299539	147	72	98.8	3	432	4	86	228	CAH8508541.1 unnamed protein product [Dicrocoelium dendriticum]	diamond	3096	121	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
31074307	31074307	PRJNA846110_P_NODE_12555_length_308_cov_2.438298_g12310_i0	PRJNA846110	12555	308	2.438298	7.50995784	Trematoda	6178	Platyhelminthes	Platyhelminthes	42.7	0.0109	NR	KAH8852684.1	6182	g12310	i0	55.3	2.12337662337662	38	17	37	0	300	187	5	42	KAH8852684.1 beta thymosin [Schistosoma japonicum]	diamond	654	43.1	0.990719257540603	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
32781188	32781188	PRJNA846110_P_NODE_19300_length_266_cov_3.212435_g19055_i0	PRJNA846110	19300	266	3.212435	8.5450771	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	123	2.1399999999999997e-31	NR	VDL89117.1	70667	g19055	i0	60.2	20.8421052631579	88	35	99.2	0	266	3	66	153	VDL89117.1 unnamed protein product [Schistocephalus solidus]	diamond	5544	124	0.991935483870968	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Schistocephalus	Schistocephalus solidus

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