metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA683669" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA683669" 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
4492854	4492854	PRJNA683669_P_NODE_18404_length_301_cov_1.798246_g18172_i0	PRJNA683669	18404	301	1.798246	5.41272046	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	298	3.26e-76	NTclustered	gi\|1116517974\|gb\|AY485340.2\|	6183	g18172	i0	87.597	252.774086378738	258	30	85	2	3	259	257	1	Schistosoma mansoni ubiquitin mRNA, partial cds	blastn	76085	298	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
12144303	12144303	PRJNA683669_P_NODE_18510_length_300_cov_2.876652_g18278_i0	PRJNA683669	18510	300	2.876652	8.629956	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	165	3.44e-36	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g18278	i0	85.806	28.1933333333333	155	22	52	0	1	155	159	5	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	8458	165	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
12144363	12144363	PRJNA683669_P_NODE_25570_length_253_cov_1.688889_g25338_i0	PRJNA683669	25570	253	1.688889	4.27288917	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	185	2.1699999999999998e-42	NTclustered	gi\|684394421\|ref\|XM_009172631.1\|	6198	g25338	i0	80	20.9802371541502	255	47	100	4	1	253	720	972	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	5308	185	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
12144490	12144490	PRJNA683669_P_NODE_8330_length_443_cov_1.424324_g8099_i0	PRJNA683669	8330	443	1.424324	6.30975532	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	228	6.629999999999999e-55	NTclustered	gi\|1929250148\|gb\|MT664960.1\|	79327	g8099	i0	84.322	16.334085778781	236	34	53	3	20	254	673	906	Schmidtea mediterranea protein phosphatase 1 catalytic subunit alpha (PPP1CA) mRNA, complete cds	blastn	7236	228	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
12654409	12654409	PRJNA683669_P_NODE_9890_length_407_cov_2.305389_g9659_i0	PRJNA683669	9890	407	2.305389	9.38293323	Metazoa	33208	Platyhelminthes	Platyhelminthes	348	4.45e-91	NTclustered	gi\|58197522\|dbj\|AB200392.1\|	6161	g9659	i0	83.836	31.8820638820639	365	59	90	0	41	405	43	407	Dugesia japonica CaM mRNA for calmodulin, complete cds	blastn	12976	350	0.994285714285714	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
14694026	14694026	PRJNA683669_P_NODE_4532_length_612_cov_1.439703_g4308_i0	PRJNA683669	4532	612	1.439703	8.81098236	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	915	0	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g4308	i0	93.528	34.5816993464052	618	34	100	4	1	612	148	765	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	21164	915	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
15967653	15967653	PRJNA683669_P_NODE_17113_length_313_cov_1.466667_g16882_i0	PRJNA683669	17113	313	1.466667	4.59066771	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	239	2.09e-58	NTclustered	gi\|2318767917\|ref\|XM_051215478.1\|	6185	g16882	i0	85.778	23.5878594249201	225	32	72	0	7	231	340	116	Schistosoma haematobium Tubulin beta chain (Beta tubulin) (TUB2_2), mRNA	blastn	7383	239	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
18517182	18517182	PRJNA683669_P_NODE_7655_length_462_cov_2.177378_g7424_i0	PRJNA683669	7655	462	2.177378	10.05948636	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	311	6.700000000000001e-80	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g7424	i0	85.522	2.23160173160173	297	43	64	0	1	297	297	1	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	1031	311	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
23617878	23617878	PRJNA683669_P_NODE_28659_length_248_cov_0.880000_g28427_i0	PRJNA683669	28659	248	0.88	2.1824	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	52.8	0.022	NTclustered	gi\|393794191\|dbj\|AK388788.1\|	6161	g28427	i0	100	0.112903225806452	28	0	11	0	125	152	1772	1799	Dugesia japonica cDNA, clone: Dj_aH_000_02497HH.full, full-insert sequence, expressed in adult head	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica

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