metadata: contig_metadata: 4 rows where bioproject = "PRJEB83101", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJEB83101", tax_clade = "Opisthokonta" 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
2692059	2692059	PRJEB83101_P_NODE_43843_length_287_cov_1.369159_g43538_i0	PRJEB83101	43843	287	1.369159	3.92948633	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	52.8	0.027	NTclustered	gi\|2318764897\|ref\|XM_051212940.1\|	6185	g43538	i0	100	0.195121951219512	28	0	10	0	236	263	48	75	Schistosoma haematobium uncharacterized protein (MS3_00004947), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
28700904	28700904	PRJEB83101_P_NODE_44067_length_286_cov_7.370892_g43762_i0	PRJEB83101	44067	286	7.3708920000000004	21.08075112	Schistosoma	6181	Platyhelminthes	Platyhelminthes	65.1	4.87e-11	NR	XP_018645349.1	6183	g43762	i0	60	1.25874125874126	60	23	61.9	1	236	60	45	104	XP_018645349.1 hypothetical protein Smp_184280, partial [Schistosoma mansoni]	diamond	360	65.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
30058393	30058393	PRJEB83101_P_NODE_62111_length_257_cov_1.282609_g61806_i0	PRJEB83101	62111	257	1.282609	3.29630513	Metazoa	33208	Platyhelminthes	Platyhelminthes	54.7	1.27e-6	NR	KAF6779088.1	100269	g61806	i0	54.5	10.4124513618677	44	20	51.4	0	3	134	154	197	KAF6779088.1 hypothetical protein AHF37_01188 [Paragonimus kellicotti]	diamond	2676	55.1	0.992740471869329	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus kellicotti
30255808	30255808	PRJEB83101_P_NODE_65992_length_253_cov_0.866667_g65687_i0	PRJEB83101	65992	253	0.866667	2.19266751	Opisthorchis felineus	147828	Platyhelminthes	Platyhelminthes	68.9	8.57e-12	NR	TGZ70632.1	147828	g65687	i0	60.7	2.31225296442688	61	20	72.3	1	249	67	6	62	TGZ70632.1 hypothetical protein CRM22_003089 [Opisthorchis felineus]	diamond	585	68.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis felineus

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