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

5 rows where analysis = "blastn", bioproject = "PRJNA896554" 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
2145468	2145468	PRJNA896554_P_NODE_131882_length_273_cov_2.600000_g124342_i0	PRJNA896554	131882	273	2.6	7.098	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	396	1.0099999999999997e-105	NTclustered	gi\|60698688\|gb\|AY915747.1\|	6182	g124342	i0	97.021	2.23443223443223	235	7	86	0	39	273	421	187	Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds	blastn	610	396	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
3421976	3421976	PRJNA896554_P_NODE_24443_length_1530_cov_2.789979_g19587_i0	PRJNA896554	24443	1530	2.789979	42.6866787	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	56.5	0.012	NTclustered	gi\|690513703\|emb\|LN064217.1\|	99802	g19587	i0	100	0.177777777777778	30	0	2	0	1327	1356	1135	1164	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0062117	blastn	272	56.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
3423463	3423463	PRJNA896554_P_NODE_97023_length_340_cov_1.056180_g89483_i0	PRJNA896554	97023	340	1.05618	3.591012	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	577	4.2899999999999987e-160	NTclustered	gi\|60698656\|gb\|AY915745.1\|	6182	g89483	i0	97.093	73.5088235294118	344	6	100	1	1	340	369	26	Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds	blastn	24993	577	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
9798020	9798020	PRJNA896554_P_NODE_136188_length_268_cov_1.010256_g128648_i0	PRJNA896554	136188	268	1.010256	2.70748608	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	459	1.2399999999999996e-124	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g128648	i0	97.744	0.992537313432836	266	6	99	0	3	268	79	344	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	266	459	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
14899853	14899853	PRJNA896554_P_NODE_64152_length_500_cov_1.217799_g56618_i0	PRJNA896554	64152	500	1.217799	6.088995	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	75	1.04e-8	NTclustered	gi\|60698656\|gb\|AY915745.1\|	6182	g56618	i0	97.674	1.724	43	1	9	0	458	500	467	425	Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds	blastn	862	75	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);;