metadata: contig_metadata: 5 rows where bioproject = "PRJNA577226", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA577226", tax_clade = "Opisthokonta" 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
9490182	9490182	PRJNA577226_S_NODE_36248_length_207_cov_1.323529_g35309_i0	PRJNA577226	36248	207	1.323529	2.73970503	Bresslauilla relicta	1311963	Platyhelminthes	Platyhelminthes	86.1	1.79e-12	NTclustered	gi\|588313927\|gb\|KC869885.1\|	1311963	g35309	i0	81.081	0.811594202898551	111	17	54	2	10	120	1606	1712	Bresslauilla relicta 28S ribosomal RNA genes, partial sequence	blastn	168	86.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Rhabdocoela	Graffillidae	Bresslauilla	Bresslauilla relicta
23514402	23514402	PRJNA577226_S_NODE_44199_length_187_cov_1.806667_g43260_i0	PRJNA577226	44199	187	1.806667	3.37846729	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	60.2	9.57e-5	NTclustered	gi\|226470623\|emb\|FN321019.1\|	6182	g43260	i0	94.872	2.71122994652406	39	1	20	1	150	187	459	421	Schistosoma japonicum isolate Anhui full length mRNA clone SJFCE3716.006\|FSE001-P00022-C24, complete sequence	blastn	507	60.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27427487	27427487	PRJNA577226_S_NODE_35103_length_210_cov_2.028902_g34164_i0	PRJNA577226	35103	210	2.028902	4.2606942	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	102	1.37e-26	NR	AAX30341.2	6182	g34164	i0	80.3	0.942857142857143	66	10	91.4	2	194	3	4	68	AAX30341.2 SJCHGC03035 protein [Schistosoma japonicum]	diamond	198	102	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
29321652	29321652	PRJNA577226_S_NODE_70769_length_151_cov_1.368421_g69830_i0	PRJNA577226	70769	151	1.368421	2.06631571	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	82.4	3.32e-18	NR	KAL3311549.1	1844966	g69830	i0	73.5	12.6556291390728	49	13	97.4	0	3	149	14	62	KAL3311549.1 GTP-binding protein Rho1 [Cichlidogyrus casuarinus]	diamond	1911	82.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
31723057	31723057	PRJNA577226_S_NODE_50497_length_176_cov_1.064748_g49558_i0	PRJNA577226	50497	176	1.064748	1.87395648	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	80.1	1.46e-17	NR	AAX24812.2	6182	g49558	i0	69.4	1.63636363636364	49	15	83.5	0	3	149	8	56	AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum]	diamond	288	80.1	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);;