metadata: contig_metadata: 8 rows where bioproject = "PRJNA1101946" and tax

8 rows where bioproject = "PRJNA1101946" 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
1485941	1485941	PRJNA1101946_S_NODE_3582_length_339_cov_3.848276_g3483_i0	PRJNA1101946	3582	339	3.848276	13.04565564	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	586	7.1e-163	NTclustered	gi\|60600058\|gb\|AY810684.1\|	6182	g3483	i0	100	8.65191740412979	317	0	94	0	1	317	262	578	Schistosoma japonicum SJCHGC04723 protein mRNA, partial cds	blastn	2933	586	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
5314145	5314145	PRJNA1101946_S_NODE_25805_length_158_cov_592.385321_g25706_i0	PRJNA1101946	25805	158	592.385321	935.96880718	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	278	1.98e-70	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g25706	i0	98.125	124.632911392405	160	1	100	1	1	158	1920	1761	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	19692	278	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
14240063	14240063	PRJNA1101946_S_NODE_5712_length_299_cov_6.528000_g5613_i0	PRJNA1101946	5712	299	6.528	19.51872	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	54.7	0.008	NTclustered	gi\|687322327\|emb\|LK415164.1\|	57078	g5613	i0	92.105	0.127090301003344	38	3	13	0	6	43	1706	1743	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0021439	blastn	38	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
28362414	28362414	PRJNA1101946_S_NODE_16686_length_197_cov_2.986486_g16587_i0	PRJNA1101946	16686	197	2.986486	5.88337742	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	100	3.32e-25	NR	AAX30334.2	6182	g16587	i0	82.4	3.10659898477157	68	9	99	1	195	1	60	127	AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum]	diamond	612	101	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
29120539	29120539	PRJNA1101946_S_NODE_1729_length_413_cov_8.343407_g1630_i0	PRJNA1101946	1729	413	8.343407	34.45827091	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	49.7	4.15e-5	NR	ABA40899.1	6182	g1630	i0	59	0.283292978208232	39	14	26.9	1	63	173	4	42	ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum]	diamond	117	49.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
29719953	29719953	PRJNA1101946_S_NODE_3630_length_338_cov_5.117647_g3531_i0	PRJNA1101946	3630	338	5.117647	17.29764686	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	95.5	3.74e-23	NR	AAX30336.2	6182	g3531	i0	86	2.11242603550296	50	7	44.4	0	153	4	24	73	AAX30336.2 SJCHGC03028 protein, partial [Schistosoma japonicum]	diamond	714	95.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
31015505	31015505	PRJNA1101946_S_NODE_5255_length_306_cov_5.926070_g5156_i0	PRJNA1101946	5255	306	5.92607	18.1337742	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	65.1	2.6e-11	NR	AAX30341.2	6182	g5156	i0	93.5	1.46078431372549	31	2	30.4	0	121	29	20	50	AAX30341.2 SJCHGC03035 protein [Schistosoma japonicum]	diamond	447	65.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
32439117	32439117	PRJNA1101946_S_NODE_1779_length_409_cov_2.252778_g1680_i0	PRJNA1101946	1779	409	2.252778	9.21386202	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	252	4.61e-79	NR	AAX28387.3	6182	g1680	i0	97.8	6.93154034229829	135	3	99	0	407	3	357	491	AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum]	diamond	2835	252	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum

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