metadata: contig_metadata: 5 rows where bioproject = "PRJNA1087264", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA1087264", 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
1017353	1017353	PRJNA1087264_P_NODE_4081_length_322_cov_2.347985_g3999_i0	PRJNA1087264	4081	322	2.347985	7.5605117	Metazoa	33208	Platyhelminthes	Platyhelminthes	595	1.1099999999999995e-165	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g3999	i0	100	100	322	0	100	0	1	322	347	668	Schistosoma japonicum unknown mRNA	blastn	32200	595	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
3568081	3568081	PRJNA1087264_P_NODE_4423_length_309_cov_1.811538_g4341_i0	PRJNA1087264	4423	309	1.811538	5.59765242	Metazoa	33208	Platyhelminthes	Platyhelminthes	571	1.7899999999999995e-158	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g4341	i0	100	100	309	0	100	0	1	309	55	363	Schistosoma japonicum unknown mRNA	blastn	30900	571	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
16770963	16770963	PRJNA1087264_P_NODE_13454_length_171_cov_2.090164_g13372_i0	PRJNA1087264	13454	171	2.090164	3.57418044	Calicophoron daubneyi	300641	Platyhelminthes	Platyhelminthes	94.4	6.31e-22	NR	CAL5135349.1	300641	g13372	i0	82.1	0.982456140350877	56	10	98.2	0	2	169	57	112	CAL5135349.1 unnamed protein product [Calicophoron daubneyi]	diamond	168	94.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Paramphistomidae	Calicophoron	Calicophoron daubneyi
28109652	28109652	PRJNA1087264_P_NODE_10545_length_194_cov_1.544828_g10463_i0	PRJNA1087264	10545	194	1.544828	2.99696632	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	53.5	2.98e-6	NR	KAL3320168.1	1844966	g10463	i0	47.1	1.05154639175258	68	32	99	2	194	3	247	314	KAL3320168.1 hypothetical protein Ciccas_001136 [Cichlidogyrus casuarinus]	diamond	204	53.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
29143453	29143453	PRJNA1087264_P_NODE_14189_length_167_cov_0.864407_g14107_i0	PRJNA1087264	14189	167	0.864407	1.44355969	Opisthorchiidae	6196	Platyhelminthes	Platyhelminthes	51.2	1.36e-5	NR	XP_009172925.1	6198	g14107	i0	43.8	4.31137724550898	48	27	86.2	0	165	22	525	572	XP_009172925.1 hypothetical protein T265_08769 [Opisthorchis viverrini]	diamond	720	51.2	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);;