metadata: contig_metadata: 7 rows where bioproject = "PRJNA674308", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA674308", tax_kingdom = "Metazoa" 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
13398733	13398733	PRJNA674308_P_NODE_20451_length_218_cov_1.142012_g20216_i0	PRJNA674308	20451	218	1.142012	2.48958616	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	138	4.25e-39	NR	THD25584.1	6192	g20216	i0	93.1	533.889908256881	72	5	99.1	0	218	3	19	90	THD25584.1 Rab GTPase [Fasciola hepatica]	diamond	116388	139	0.992805755395683	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
26986737	26986737	PRJNA674308_P_NODE_21642_length_213_cov_1.225610_g21407_i0	PRJNA674308	21642	213	1.22561	2.6105493	Hymenolepis diminuta	6216	Platyhelminthes	Platyhelminthes	57.8	1.21e-7	NR	VUZ40328.1	6216	g21407	i0	42.4	0.929577464788732	66	33	93	1	9	206	195	255	VUZ40328.1 unnamed protein product [Hymenolepis diminuta]	diamond	198	57.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
29651089	29651089	PRJNA674308_P_NODE_33510_length_175_cov_1.396825_g33275_i0	PRJNA674308	33510	175	1.396825	2.44444375	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	102	1.9799999999999998e-23	NR	Q6RWA9.1	6204	g33275	i0	87.7	92.8285714285714	57	7	97.7	0	2	172	722	778	Q6RWA9.1 RecName: Full=Sodium/potassium-transporting ATPase subunit alpha; Short=Na(+)/K(+) ATPase alpha subunit; AltName: Full=Sodium pump subunit alpha; AltName: Full=TNaK1-alpha [Taenia solium]	diamond	16245	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia solium
29682747	29682747	PRJNA674308_P_NODE_37990_length_168_cov_1.184874_g37755_i0	PRJNA674308	37990	168	1.184874	1.99058832	root	1	Root_unresolved	Root_unresolved	55.8	8.86e-8	NR	CAH8494576.1	39320	g37755	i0	48.1	2.48214285714286	52	27	92.9	0	6	161	72	123	CAH8494576.1 unnamed protein product [Heterobilharzia americana]	diamond	417	56.2	0.99288256227758	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Heterobilharzia	Heterobilharzia americana
29999038	29999038	PRJNA674308_P_NODE_50071_length_163_cov_0.912281_g49836_i0	PRJNA674308	50071	163	0.912281	1.48701803	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	93.2	1.07e-21	NR	AAX28612.2	6182	g49836	i0	83.3	16.7300613496933	54	9	99.4	0	1	162	67	120	AAX28612.2 SJCHGC08668 protein, partial [Schistosoma japonicum]	diamond	2727	93.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30915310	30915310	PRJNA674308_P_NODE_38734_length_168_cov_0.873950_g38499_i0	PRJNA674308	38734	168	0.87395	1.468236	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	75.9	7.5e-16	NR	VDP74362.1	6186	g38499	i0	70.2	1.67857142857143	47	14	83.9	0	27	167	12	58	VDP74362.1 unnamed protein product [Schistosoma curassoni]	diamond	282	76.6	0.990861618798956	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma curassoni
32654023	32654023	PRJNA674308_P_NODE_41220_length_167_cov_0.881356_g40985_i0	PRJNA674308	41220	167	0.881356	1.47186452	Metazoa	33208	Platyhelminthes	Platyhelminthes	74.3	9.64e-14	NR	XP_009176428.1	6198	g40985	i0	61.8	13.7065868263473	55	21	98.8	0	166	2	574	628	XP_009176428.1 hypothetical protein T265_11495 [Opisthorchis viverrini]	diamond	2289	74.7	0.994645247657296	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini

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