metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB17675" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB17675" 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
14049792	14049792	PRJEB17675_P_NODE_17972_length_186_cov_2.079470_g17668_i0	PRJEB17675	17972	186	2.07947	3.8678142	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	182	1.94e-41	NTclustered	gi\|690919959\|emb\|LN427828.1\|	99802	g17668	i0	84.916	22.5860215053763	179	27	96	0	5	183	494	316	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0177640	blastn	4201	182	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
17873294	17873294	PRJEB17675_P_NODE_3035_length_565_cov_5.884906_g2765_i0	PRJEB17675	3035	565	5.884906	33.2497189	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	460	7.809999999999998e-125	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g2765	i0	86.493	0.952212389380531	422	54	95	3	127	546	12	432	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	538	460	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
22662803	22662803	PRJEB17675_P_NODE_7358_length_341_cov_1.790850_g7054_i0	PRJEB17675	7358	341	1.79085	6.1067985	Metazoa	33208	Platyhelminthes	Platyhelminthes	58.4	6.93e-4	NTclustered	gi\|2318767573\|ref\|XM_051213998.1\|	6185	g7054	i0	97.059	2.92375366568915	34	1	10	0	63	96	146	113	Schistosoma haematobium uncharacterized protein (MS3_00005903), mRNA	blastn	997	58.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
24247451	24247451	PRJEB17675_P_NODE_11540_length_250_cov_2.660465_g11236_i0	PRJEB17675	11540	250	2.660465	6.6511625	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	75	4.83e-9	NTclustered	gi\|2318755324\|ref\|XM_012944977.2\|	6185	g11236	i0	92.308	4.728	52	4	21	0	91	142	878	929	Schistosoma haematobium uncharacterized protein (MS3_00002600), partial mRNA	blastn	1182	75	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
24247525	24247525	PRJEB17675_P_NODE_4900_length_438_cov_18.945409_g4602_i0	PRJEB17675	4900	438	18.945409	82.98089142	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	499	1.26e-136	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g4602	i0	87.414	0.997716894977169	437	52	99	3	3	438	446	12	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	437	499	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);;