metadata: contig_metadata: 8 rows where bioproject = "PRJNA951810", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA951810", tax_kingdom = "Metazoa" 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
23888875	23888875	PRJNA951810_P_NODE_168279_length_243_cov_9.652941_g167934_i0	PRJNA951810	168279	243	9.652941	23.45664663	Trichobilharzia szidati	157070	Platyhelminthes	Platyhelminthes	70.5	6.61e-13	NR	CAH8863867.1	157070	g167934	i0	44.2	1.90123456790123	77	42	93.8	1	1	228	27	103	CAH8863867.1 unnamed protein product [Trichobilharzia szidati]	diamond	462	70.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia szidati
27095346	27095346	PRJNA951810_P_NODE_163562_length_247_cov_3.925287_g163217_i0	PRJNA951810	163562	247	3.925287	9.69545889	root	1	Root_unresolved	Root_unresolved	54.7	2.29e-6	NR	KAL3314937.1	1844966	g163217	i0	58.1	2.10121457489879	43	18	52.2	0	245	117	257	299	KAL3314937.1 hypothetical protein Ciccas_006432 [Cichlidogyrus casuarinus]	diamond	519	55.1	0.992740471869329	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
27601099	27601099	PRJNA951810_P_NODE_196164_length_201_cov_5.468750_g195819_i0	PRJNA951810	196164	201	5.46875	10.9921875	Schistosoma	6181	Platyhelminthes	Platyhelminthes	45.8	0.00102	NR	RTG82716.1	6184	g195819	i0	45.8	5.17910447761194	48	26	71.6	0	154	11	68	115	RTG82716.1 uncharacterized protein DC041_0009252, partial [Schistosoma bovis]	diamond	1041	45.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma bovis
29583310	29583310	PRJNA951810_P_NODE_68710_length_309_cov_3.669492_g68366_i0	PRJNA951810	68710	309	3.669492	11.33873028	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	66.2	4.51e-10	NR	PAA62748.1	282301	g68366	i0	47	1.35922330097087	66	35	64.1	0	3	200	845	910	PAA62748.1 hypothetical protein BOX15_Mlig007730g1 [Macrostomum lignano]	diamond	420	66.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30063658	30063658	PRJNA951810_P_NODE_184911_length_226_cov_3.529412_g184566_i0	PRJNA951810	184911	226	3.529412	7.97647112	Trichobilharzia	100601	Platyhelminthes	Platyhelminthes	62.8	5e-10	NR	VDQ01085.1	157069	g184566	i0	53.1	2.64159292035398	64	29	85	1	33	224	27	89	VDQ01085.1 unnamed protein product [Trichobilharzia regenti]	diamond	597	62.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia regenti
30151783	30151783	PRJNA951810_P_NODE_147532_length_260_cov_2.187166_g147187_i0	PRJNA951810	147532	260	2.187166	5.6866316	Opisthorchis felineus	147828	Platyhelminthes	Platyhelminthes	119	7.899999999999999e-33	NR	TGZ59676.1	147828	g147187	i0	67.9	4.51153846153846	78	25	90	0	236	3	1	78	TGZ59676.1 hypothetical protein CRM22_008960 [Opisthorchis felineus]	diamond	1173	119	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis felineus
30657500	30657500	PRJNA951810_P_NODE_121773_length_279_cov_1.354369_g121428_i0	PRJNA951810	121773	279	1.354369	3.77868951	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	85.9	4.61e-19	NR	PAA73746.1	282301	g121428	i0	48.1	0.849462365591398	79	40	84.9	1	42	278	16	93	PAA73746.1 hypothetical protein BOX15_Mlig034390g2, partial [Macrostomum lignano]	diamond	237	85.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30853605	30853605	PRJNA951810_P_NODE_118554_length_281_cov_2.677885_g118210_i0	PRJNA951810	118554	281	2.677885	7.52485685	Metazoa	33208	Platyhelminthes	Platyhelminthes	44.3	0.00236	NR	VDD79693.1	53468	g118210	i0	65.5	2.7864768683274	29	10	31	0	141	227	54	82	VDD79693.1 unnamed protein product [Mesocestoides corti]	diamond	783	44.7	0.991051454138702	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Mesocestoididae	Mesocestoides	Mesocestoides corti

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