metadata: contig_metadata: 10 rows where bioproject = "PRJNA438687", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA438687", 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
435311	435311	PRJNA438687_S_NODE_3801_length_228_cov_5.896373_g3711_i0	PRJNA438687	3801	228	5.896373	13.44373044	Pacifides sp. n. ML-2020	2771503	Platyhelminthes	Platyhelminthes	87.9	5.57e-13	NTclustered	gi\|1900854572\|gb\|MT994578.1\|	2771503	g3711	i0	81.25	4.60087719298246	112	18	48	3	49	158	320	210	Pacifides sp. n. ML-2020 isolate ML3 large subunit ribosomal RNA gene, partial sequence	blastn	1049	87.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Cercyridae	Pacifides	Pacifides sp. n. ML-2020
2366607	2366607	PRJNA438687_S_NODE_3122_length_253_cov_6.077982_g3032_i0	PRJNA438687	3122	253	6.077982	15.37729446	Stenostomum	39238	Platyhelminthes	Platyhelminthes	466	6.9199999999999996e-127	NTclustered	gi\|219718173\|gb\|FJ196334.1\|	570253	g3032	i0	100	99.0869565217391	252	0	99	0	2	253	341	90	Stenostomum bryophilum isolate K04_78 18S ribosomal RNA gene, partial sequence	blastn	25069	466	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum bryophilum
3642207	3642207	PRJNA438687_S_NODE_6723_length_168_cov_3.909774_g6633_i0	PRJNA438687	6723	168	3.909774	6.56842032	Stenostomum	39238	Platyhelminthes	Platyhelminthes	305	9.81e-79	NTclustered	gi\|209968693\|gb\|FJ384856.1\|	570256	g6633	i0	99.405	54.4880952380952	168	1	100	0	1	168	26	193	Stenostomum sp. 'island' isolate K04_93 28S ribosomal RNA gene, partial sequence	blastn	9154	305	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sp. 'island'
6194177	6194177	PRJNA438687_S_NODE_1245_length_353_cov_2.940252_g1155_i0	PRJNA438687	1245	353	2.940252	10.37908956	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	496	1.28e-135	NTclustered	gi\|2866376382\|gb\|PQ722294.1\|	39377	g1155	i0	92.068	93.7705382436261	353	27	100	1	1	353	539	890	Stenostomum sp. (in: flatworms) isolate F6 small subunit ribosomal RNA gene, partial sequence	blastn	33101	501	0.99001996007984	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sp. (in: flatworms)
6194198	6194198	PRJNA438687_S_NODE_2625_length_275_cov_2.966667_g2535_i0	PRJNA438687	2625	275	2.966667	8.15833425	Metazoa	33208	Platyhelminthes	Platyhelminthes	78.7	4.17e-10	NTclustered	gi\|28273266\|gb\|AY157154.1\|	46766	g2535	i0	92.593	1.87636363636364	54	4	20	0	222	275	1700	1647	Bdelloura candida 28S large subunit ribosomal RNA gene, partial sequence	blastn	516	78.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Bdellouridae	Bdelloura	Bdelloura candida
6813160	6813160	PRJNA438687_S_NODE_8206_length_150_cov_2.747826_g8116_i0	PRJNA438687	8206	150	2.747826	4.121739	Stenostomum leucops	52061	Platyhelminthes	Platyhelminthes	261	1.86e-65	NTclustered	gi\|28273263\|gb\|AY157151.1\|	52061	g8116	i0	98	3.74666666666667	150	3	100	0	1	150	1828	1977	Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence	blastn	562	261	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum leucops
8744195	8744195	PRJNA438687_S_NODE_5967_length_180_cov_1.634483_g5877_i0	PRJNA438687	5967	180	1.634483	2.9420694	Stenostomum	39238	Platyhelminthes	Platyhelminthes	316	4.899999999999999e-82	NTclustered	gi\|2177180\|gb\|U95947.1\|SSU95947	60215	g5877	i0	98.343	100.277777777778	181	2	100	1	1	180	1617	1437	Stenostomum sp. 'Aguinaldo, 1997' 18S ribosomal RNA gene, complete sequence	blastn	18050	316	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sp. 'Aguinaldo, 1997'
11914116	11914116	PRJNA438687_S_NODE_7930_length_153_cov_2.949153_g7840_i0	PRJNA438687	7930	153	2.949153	4.51220409	Stenostomum sp. 'island'	570256	Platyhelminthes	Platyhelminthes	272	8.84e-69	NTclustered	gi\|209968693\|gb\|FJ384856.1\|	570256	g7840	i0	98.693	72.1960784313726	153	2	100	0	1	153	853	1005	Stenostomum sp. 'island' isolate K04_93 28S ribosomal RNA gene, partial sequence	blastn	11046	272	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sp. 'island'
17012692	17012692	PRJNA438687_S_NODE_6954_length_165_cov_2.407692_g6864_i0	PRJNA438687	6954	165	2.407692	3.9726918	Stenostomum leucops	52061	Platyhelminthes	Platyhelminthes	270	3.4999999999999993e-68	NTclustered	gi\|28273263\|gb\|AY157151.1\|	52061	g6864	i0	98.077	44.3454545454545	156	2	95	1	10	165	2310	2464	Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence	blastn	7317	270	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum leucops
22768111	22768111	PRJNA438687_S_NODE_4478_length_210_cov_1.600000_g4388_i0	PRJNA438687	4478	210	1.6	3.36	Metazoa	33208	Platyhelminthes	Platyhelminthes	388	1.24e-103	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g4388	i0	100	100	210	0	100	0	1	210	133	342	Schistosoma japonicum unknown mRNA	blastn	21000	388	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);;