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

5 rows where analysis = "blastn", bioproject = "PRJNA896758" 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
872937	872937	PRJNA896758_P_NODE_6961_length_429_cov_2.474719_g6571_i0	PRJNA896758	6961	429	2.474719	10.61654451	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	490	7.399999999999999e-134	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g6571	i0	87.281	1.68997668997669	456	24	99	13	3	429	1005	555	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	725	490	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
8525610	8525610	PRJNA896758_P_NODE_19447_length_264_cov_1.130890_g19057_i0	PRJNA896758	19447	264	1.13089	2.9855496	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	80.5	1.11e-10	NTclustered	gi\|687324330\|emb\|LK450395.1\|	57078	g19057	i0	85.526	0.287878787878788	76	11	29	0	171	246	988	913	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0055049	blastn	76	80.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
11076441	11076441	PRJNA896758_P_NODE_5609_length_480_cov_2.061425_g5220_i0	PRJNA896758	5609	480	2.061425	9.89484	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	326	2.49e-84	NTclustered	gi\|226473513\|emb\|FN315710.1\|	6182	g5220	i0	81.865	60.45	386	70	80	0	17	402	446	61	Schistosoma japonicum isolate Anhui full length mRNA clone SJFCA3771.015\|FSA001-P00005-L14, complete sequence	blastn	29016	326	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
12351747	12351747	PRJNA896758_P_NODE_13470_length_313_cov_2.225000_g13080_i0	PRJNA896758	13470	313	2.225	6.96425	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	52.8	0.029	NTclustered	gi\|1373862076\|ref\|XM_024497415.1\|	6210	g13080	i0	100	0.0894568690095847	28	0	9	0	155	182	2526	2553	Echinococcus granulosus Dual specificity protein kinase CLK2 (EGR_08166), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
13626652	13626652	PRJNA896758_P_NODE_3271_length_638_cov_2.233628_g2893_i0	PRJNA896758	3271	638	2.233628	14.25054664	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	739	0	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g2893	i0	91.45	54.5391849529781	538	46	84	0	1	538	538	1	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	34796	739	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni

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