metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB76780" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB76780" 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
3964946	3964946	PRJEB76780_P_NODE_6944_length_306_cov_2.008584_g6844_i0	PRJEB76780	6944	306	2.008584	6.14626704	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	163	4.26e-48	NR	XP_018650840.1	6183	g6844	i0	69.3	13.8627450980392	101	30	99	1	305	3	7	106	XP_018650840.1 putative protein arginine N-methyltransferase 1 [Schistosoma mansoni]	diamond	4242	164	0.99390243902439	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
5241391	5241391	PRJEB76780_P_NODE_7665_length_292_cov_0.958904_g7565_i0	PRJEB76780	7665	292	0.958904	2.79999968	Metazoa	33208	Platyhelminthes	Platyhelminthes	93.6	9.42e-20	NR	TPP59494.1	46835	g7565	i0	50	16.2534246575342	84	42	86.3	0	291	40	658	741	TPP59494.1 ELAV like protein 2/3/4 [Fasciola gigantica]	diamond	4746	93.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola gigantica
19264292	19264292	PRJEB76780_P_NODE_2796_length_492_cov_5.350835_g2696_i0	PRJEB76780	2796	492	5.350835	26.3261082	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	206	4.27e-58	NR	KAH9283812.1	6210	g2696	i0	64.5	32.8536585365854	155	54	94.5	1	7	471	881	1034	KAH9283812.1 40S ribosomal protein S18 [Echinococcus granulosus]	diamond	16164	207	0.995169082125604	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
27855478	27855478	PRJEB76780_P_NODE_1405_length_699_cov_2.634185_g1311_i0	PRJEB76780	1405	699	2.634185	18.41295315	Paragonimus skrjabini miyazakii	59628	Platyhelminthes	Platyhelminthes	56.6	3.52e-5	NR	KAF7261212.1	59628	g1311	i0	31.1	0.510729613733906	119	74	50.2	5	125	475	17	129	KAF7261212.1 hypothetical protein EG68_01484 [Paragonimus skrjabini miyazakii]	diamond	357	56.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus skrjabini miyazakii
27879830	27879830	PRJEB76780_P_NODE_12885_length_244_cov_0.912281_g12785_i0	PRJEB76780	12885	244	0.912281	2.22596564	Trichobilharzia	100601	Platyhelminthes	Platyhelminthes	43.1	0.0272	NR	CAH8864886.1	157069	g12785	i0	40.8	2.80327868852459	76	42	89.8	2	244	26	141	216	CAH8864886.1 unnamed protein product [Trichobilharzia regenti]	diamond	684	43.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia regenti
28195396	28195396	PRJEB76780_P_NODE_12326_length_246_cov_0.901734_g12226_i0	PRJEB76780	12326	246	0.901734	2.21826564	Metazoa	33208	Platyhelminthes	Platyhelminthes	105	2.36e-24	NR	OON13331.1	6198	g12226	i0	69.1	2.80487804878049	81	25	98.8	0	2	244	1162	1242	OON13331.1 RNA binding repeat protein, Pumilio-family [Opisthorchis viverrini]	diamond	690	105	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
30563772	30563772	PRJEB76780_P_NODE_11153_length_250_cov_0.881356_g11053_i0	PRJEB76780	11153	250	0.881356	2.20339	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	57.4	2.69e-7	NR	VDL60192.1	6216	g11053	i0	42.6	5.88	68	38	80.4	1	218	18	21	88	VDL60192.1 unnamed protein product [Hymenolepis diminuta]	diamond	1470	57.8	0.993079584775087	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta

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