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

5 rows where bioproject = "PRJEB75227", 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
16712333	16712333	PRJEB75227_P_NODE_4294_length_343_cov_1.774074_g4123_i0	PRJEB75227	4294	343	1.774074	6.08507382	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	196	1.42e-45	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g4123	i0	86.188	6.02915451895044	181	25	53	0	163	343	1	181	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	2068	196	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
16712355	16712355	PRJEB75227_P_NODE_7874_length_257_cov_1.467391_g7703_i0	PRJEB75227	7874	257	1.467391	3.77119487	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	361	3.42e-95	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g7703	i0	92.157	0.992217898832685	255	20	99	0	2	256	294	40	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	255	361	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
17987212	17987212	PRJEB75227_P_NODE_4475_length_336_cov_1.216730_g4304_i0	PRJEB75227	4475	336	1.21673	4.0882128	Metazoa	33208	Platyhelminthes	Platyhelminthes	205	8.48e-65	NR	Q26537.1	6183	g4304	i0	93.6	3.92857142857143	110	7	98.2	0	6	335	47	156	Q26537.1 RecName: Full=14-3-3 protein homolog 2; Short=14-3-3-2 [Schistosoma mansoni]	diamond	1320	205	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
27002333	27002333	PRJEB75227_P_NODE_4322_length_342_cov_1.308550_g4151_i0	PRJEB75227	4322	342	1.30855	4.475241	Fasciola hepatica	6192	Platyhelminthes	Platyhelminthes	43.5	0.04	NR	THD21906.1	6192	g4151	i0	32	0.43859649122807	50	30	43.9	1	90	239	48	93	THD21906.1 hypothetical protein D915_007509 [Fasciola hepatica]	diamond	150	43.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
28865802	28865802	PRJEB75227_P_NODE_8928_length_251_cov_0.876404_g8757_i0	PRJEB75227	8928	251	0.876404	2.19977404	Clonorchis sinensis	79923	Platyhelminthes	Platyhelminthes	42.4	0.0237	NR	GAA52571.1	79923	g8757	i0	35.2	0.848605577689243	71	44	84.9	2	6	218	23	91	GAA52571.1 TM2 domain-containing protein 2 [Clonorchis sinensis]	diamond	213	42.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis

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