metadata: contig_metadata: 7 rows where bioproject = "PRJNA446034", tax_clade = "Opisthokonta" and tax

7 rows where bioproject = "PRJNA446034", 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
4920008	4920008	PRJNA446034_S_NODE_1024_length_450_cov_36.421308_g990_i0	PRJNA446034	1024	450	36.421308	163.895886	Metazoa	33208	Platyhelminthes	Platyhelminthes	830	0	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g990	i0	100	99.7777777777778	449	0	99	0	2	450	566	118	Schistosoma japonicum unknown mRNA	blastn	44900	830	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
13191627	13191627	PRJNA446034_S_NODE_107451_length_152_cov_10.330435_g107414_i0	PRJNA446034	107451	152	10.330435	15.7022612	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	268	1.13e-67	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g107414	i0	98.684	121.881578947368	152	1	100	1	1	152	735	885	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	18526	268	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
18289966	18289966	PRJNA446034_S_NODE_59395_length_176_cov_3.611511_g59358_i0	PRJNA446034	59395	176	3.611511	6.35625936	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	58.4	3.19e-4	NTclustered	gi\|690479935\|emb\|LN022006.1\|	99802	g59358	i0	90.909	0.25	44	3	25	1	132	175	6585	6627	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0021641	blastn	44	58.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
26664218	26664218	PRJNA446034_S_NODE_72581_length_168_cov_2.190840_g72544_i0	PRJNA446034	72581	168	2.19084	3.6806112	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	49.7	3.14e-6	NR	ABA40899.1	6182	g72544	i0	59	0.696428571428571	39	14	66.1	1	147	37	4	42	ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum]	diamond	117	49.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27518442	27518442	PRJNA446034_S_NODE_99603_length_155_cov_5.330508_g99566_i0	PRJNA446034	99603	155	5.330508	8.2622874	Neoheterocotyle quadrispinata	2559910	Platyhelminthes	Platyhelminthes	48.5	9.54e-5	NR	BBJ21535.1	2559910	g99566	i0	62.5	5.05161290322581	32	12	61.9	0	1	96	114	145	BBJ21535.1 cytochrome c oxidase subunit 1, partial [Neoheterocotyle quadrispinata]	diamond	783	48.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Monocotylidea	Monocotylidae	Neoheterocotyle	Neoheterocotyle quadrispinata
30771322	30771322	PRJNA446034_S_NODE_9974_length_262_cov_7.506667_g9937_i0	PRJNA446034	9974	262	7.506667	19.66746754	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	155	1.28e-42	NR	AAX28387.3	6182	g9937	i0	98.8	3.75572519083969	82	1	93.9	0	1	246	101	182	AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum]	diamond	984	156	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
32257757	32257757	PRJNA446034_S_NODE_3538_length_332_cov_5.115254_g3501_i0	PRJNA446034	3538	332	5.115254	16.98264328	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	55.5	1.3e-6	NR	AAX25032.2	6182	g3501	i0	65.9	0.75	41	14	37	0	133	11	147	187	AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum]	diamond	249	55.5	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);;