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

7 rows where bioproject = "PRJNA1105232", 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
11223817	11223817	PRJNA1105232_S_NODE_9869_length_203_cov_1.681818_g9653_i0	PRJNA1105232	9869	203	1.681818	3.41409054	Metazoa	33208	Platyhelminthes	Platyhelminthes	56.5	0.001	NTclustered	gi\|1084302705\|ref\|XM_018788951.1\|	6183	g9653	i0	100	4.11822660098522	30	0	15	0	90	119	1763	1792	Schistosoma mansoni hypothetical protein partial mRNA	blastn	836	56.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
23164875	23164875	PRJNA1105232_S_NODE_4259_length_282_cov_3.506438_g4043_i0	PRJNA1105232	4259	282	3.506438	9.88815516	Diplorchis hangzhouensis	1131906	Platyhelminthes	Platyhelminthes	54.7	0.007	NTclustered	gi\|379771686\|gb\|JQ038227.1\|	1131906	g4043	i0	100	0.102836879432624	29	0	10	0	98	126	5361	5389	Diplorchis hangzhouensis mitochondrion sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Diplorchis	Diplorchis hangzhouensis
27974973	27974973	PRJNA1105232_S_NODE_6365_length_241_cov_1.500000_g6149_i0	PRJNA1105232	6365	241	1.5	3.615	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	72	1.75e-12	NR	KAG5449752.1	79923	g6149	i0	40	17.2655601659751	80	48	99.6	0	240	1	400	479	KAG5449752.1 Serine/threonine-protein kinase PAK 3 [Clonorchis sinensis]	diamond	4161	72.4	0.994475138121547	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis
29719991	29719991	PRJNA1105232_S_NODE_530_length_625_cov_2.803819_g334_i0	PRJNA1105232	530	625	2.803819	17.52386875	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	90.5	1.96e-18	NR	AAX26676.1	6182	g334	i0	39.3	0.672	140	71	66.2	4	614	201	2	129	AAX26676.1 unknown [Schistosoma japonicum]	diamond	420	90.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30952553	30952553	PRJNA1105232_S_NODE_13634_length_177_cov_1.218750_g13418_i0	PRJNA1105232	13634	177	1.21875	2.1571875	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	84.3	6.11e-20	NR	AAX30326.1	6182	g13418	i0	70.4	0.915254237288136	54	16	91.5	0	162	1	6	59	AAX30326.1 SJCHGC03015 protein [Schistosoma japonicum]	diamond	162	84.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
31015554	31015554	PRJNA1105232_S_NODE_14875_length_170_cov_3.669421_g14659_i0	PRJNA1105232	14875	170	3.669421	6.2380157	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	70.9	7.38e-14	NR	AAW27122.1	6182	g14659	i0	93.8	0.564705882352941	32	2	56.5	0	38	133	18	49	AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum]	diamond	96	70.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
31806091	31806091	PRJNA1105232_S_NODE_6297_length_242_cov_2.424870_g6081_i0	PRJNA1105232	6297	242	2.42487	5.8681854	Echinostoma caproni	27848	Platyhelminthes	Platyhelminthes	57.4	7.06e-8	NR	VDP77810.1	27848	g6081	i0	41.8	2.21900826446281	55	32	68.2	0	8	172	104	158	VDP77810.1 unnamed protein product [Echinostoma caproni]	diamond	537	57.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Echinostomatidae	Echinostoma	Echinostoma caproni

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