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

5 rows where bioproject = "PRJEB28062", 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
3851745	3851745	PRJEB28062_P_NODE_83064_length_367_cov_3.061224_g80702_i0	PRJEB28062	83064	367	3.061224	11.23469208	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	577	4.649999999999999e-160	NTclustered	gi\|60698688\|gb\|AY915747.1\|	6182	g80702	i0	97.076	2.45231607629428	342	10	100	0	26	367	439	98	Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds	blastn	900	577	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
29489723	29489723	PRJEB28062_P_NODE_115710_length_271_cov_2.404040_g113347_i0	PRJEB28062	115710	271	2.40404	6.5149484	Echinococcus	6209	Platyhelminthes	Platyhelminthes	43.5	0.0269	NR	XP_024352761.1	6210	g113347	i0	30.5	1.81549815498155	82	53	90.8	1	3	248	463	540	XP_024352761.1 Ligatin [Echinococcus granulosus]	diamond	492	43.9	0.990888382687927	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
30918084	30918084	PRJEB28062_P_NODE_96454_length_325_cov_10.000000_g94092_i0	PRJEB28062	96454	325	10	32.5	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	55.8	1.05e-7	NR	AAX31080.1	6182	g94092	i0	73	0.341538461538462	37	10	34.2	0	166	276	1	37	AAX31080.1 SJCHGC09793 protein [Schistosoma japonicum]	diamond	111	55.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
31866288	31866288	PRJEB28062_P_NODE_117437_length_267_cov_1.268041_g115074_i0	PRJEB28062	117437	267	1.268041	3.38566947	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	79.7	6.89e-17	NR	AAX24812.2	6182	g115074	i0	56.9	0.730337078651685	65	28	73	0	226	32	1	65	AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum]	diamond	195	79.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
32151304	32151304	PRJEB28062_P_NODE_70478_length_409_cov_139.761905_g68117_i0	PRJEB28062	70478	409	139.761905	571.62619145	Alloglossidium progeneticum	1748108	Platyhelminthes	Platyhelminthes	45.4	0.017	NR	ALM03067.1	1748108	g68117	i0	43.4	0.557457212713936	76	34	49.1	2	98	298	120	195	ALM03067.1 NADH dehydrogenase subunit 1, partial [Alloglossidium progeneticum]	diamond	228	45.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Alloglossidiidae	Alloglossidium	Alloglossidium progeneticum

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