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

5 rows where bioproject = "PRJEB28589", 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
25965	25965	PRJEB28589_S_NODE_6041_length_307_cov_4.903846_g5933_i0	PRJEB28589	6041	307	4.903846	15.05480722	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	60.2	1.71e-4	NTclustered	gi\|687716252\|emb\|LK535971.1\|	57078	g5933	i0	97.143	0.11400651465798	35	1	11	0	168	202	29	63	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0134325	blastn	35	60.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
3852118	3852118	PRJEB28589_S_NODE_19404_length_155_cov_2.222222_g19296_i0	PRJEB28589	19404	155	2.222222	3.4444441	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	265	1.5e-66	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g19296	i0	97.419	128.8	155	4	100	0	1	155	1874	2028	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	19964	265	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
8953033	8953033	PRJEB28589_S_NODE_9428_length_256_cov_3.650718_g9320_i0	PRJEB28589	9428	256	3.650718	9.34583808	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	52.8	0.023	NTclustered	gi\|690689632\|emb\|LN243559.1\|	99802	g9320	i0	100	0.109375	28	0	11	0	75	102	730	757	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0049839	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
28006144	28006144	PRJEB28589_S_NODE_9225_length_259_cov_2.509434_g9117_i0	PRJEB28589	9225	259	2.509434	6.49943406	Schistosoma	6181	Platyhelminthes	Platyhelminthes	52	2.55e-5	NR	CAH8508570.1	6184	g9117	i0	46.4	3.82239382239382	56	30	64.9	0	259	92	137	192	CAH8508570.1 unnamed protein product [Schistosoma bovis]	diamond	990	52	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma bovis
30254703	30254703	PRJEB28589_S_NODE_3572_length_354_cov_4.423453_g3464_i0	PRJEB28589	3572	354	4.423453	15.65902362	Hymenolepis diminuta	6216	Platyhelminthes	Platyhelminthes	98.6	1.84e-21	NR	VDL19842.1	6216	g3464	i0	65.7	1.05084745762712	70	20	59.3	1	324	115	234	299	VDL19842.1 unnamed protein product [Hymenolepis diminuta]	diamond	372	98.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta

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