metadata: contig_metadata: 4 rows where bioproject = "PRJNA478247", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA478247", 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
18948642	18948642	PRJNA478247_P_NODE_875_length_444_cov_3.060241_g770_i0	PRJNA478247	875	444	3.060241	13.58747004	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	217	1.7299999999999998e-69	NR	THD26469.1	6192	g770	i0	87.7	755.810810810811	138	13	93.2	2	443	30	38	171	THD26469.1 histone H3 [Fasciola hepatica]	diamond	335580	219	0.990867579908676	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
27676761	27676761	PRJNA478247_P_NODE_1684_length_281_cov_1.892857_g1578_i0	PRJNA478247	1684	281	1.892857	5.31892817	Fasciolopsis buskii	27845	Platyhelminthes	Platyhelminthes	111	3.13e-29	NR	KAA0187222.1	27845	g1578	i0	59.5	2.83985765124555	84	34	89.7	0	252	1	28	111	KAA0187222.1 Thioredoxin H-type [Fasciolopsis buskii]	diamond	798	112	0.991071428571429	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
29492280	29492280	PRJNA478247_P_NODE_3450_length_157_cov_1.968750_g3344_i0	PRJNA478247	3450	157	1.96875	3.0909375	Cestoda	6199	Platyhelminthes	Platyhelminthes	64.3	2.33e-11	NR	VUZ42210.1	6216	g3344	i0	64.6	5.5031847133758	48	17	91.7	0	1	144	65	112	VUZ42210.1 unnamed protein product [Hymenolepis diminuta]	diamond	864	64.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
30155272	30155272	PRJNA478247_P_NODE_3472_length_156_cov_1.653543_g3366_i0	PRJNA478247	3472	156	1.653543	2.57952708	Metazoa	33208	Platyhelminthes	Platyhelminthes	80.1	7.51e-16	NR	OON19528.1	6198	g3366	i0	76.5	10.7884615384615	51	11	98.1	1	3	155	526	575	OON19528.1 major Vault Protein repeat-containing domain protein [Opisthorchis viverrini]	diamond	1683	80.1	1	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);;