metadata: contig_metadata: 5 rows where bioproject = "PRJNA1164198" and tax

5 rows where bioproject = "PRJNA1164198" 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
1039512	1039512	PRJNA1164198_P_NODE_32061_length_201_cov_4.585938_g31792_i0	PRJNA1164198	32061	201	4.585938	9.21773538	Raillietina	70662	Platyhelminthes	Platyhelminthes	265	2.06e-66	NTclustered	gi\|14388903\|gb\|AF286980.1\|AF286980	137598	g31792	i0	90.594	85.8457711442786	202	15	100	4	1	201	362	164	Raillietina australis 18S ribosomal RNA gene, complete sequence	blastn	17255	265	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Davaineidae	Raillietina	Raillietina australis
14340960	14340960	PRJNA1164198_P_NODE_5712_length_527_cov_1.579295_g5457_i0	PRJNA1164198	5712	527	1.579295	8.32288465	Geocentrophora applanata	1468192	Platyhelminthes	Platyhelminthes	385	4.49e-102	NTclustered	gi\|588313805\|gb\|KC869763.1\|	1468192	g5457	i0	96.943	3.84440227703985	229	7	43	0	1	229	229	1	Geocentrophora applanata 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	2026	385	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Lecithoepitheliata	Prorhynchidae	Geocentrophora	Geocentrophora applanata
15614768	15614768	PRJNA1164198_P_NODE_21253_length_269_cov_2.229592_g20984_i0	PRJNA1164198	21253	269	2.229592	5.99760248	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	315	2.85e-81	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g20984	i0	87.778	1.00371747211896	270	31	100	2	1	269	281	13	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	270	315	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27533689	27533689	PRJNA1164198_P_NODE_6643_length_488_cov_1.684337_g6383_i0	PRJNA1164198	6643	488	1.684337	8.21956456	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	57.4	6.13e-7	NR	KAF6771429.1	100269	g6383	i0	32.4	5.51434426229508	68	46	41.8	0	5	208	87	154	KAF6771429.1 hypothetical protein AHF37_09851 [Paragonimus kellicotti]	diamond	2691	57.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus kellicotti
32095183	32095183	PRJNA1164198_P_NODE_11678_length_364_cov_1.072165_g11410_i0	PRJNA1164198	11678	364	1.072165	3.9026806	Hymenolepis microstoma	85433	Platyhelminthes	Platyhelminthes	48.1	0.00171	NR	CDS30671.2	85433	g11410	i0	35.2	1.13736263736264	71	46	58.5	0	2	214	273	343	CDS30671.2 Aquaporin [Hymenolepis microstoma]	diamond	414	48.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis microstoma

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