metadata: contig_metadata: 9 rows where bioproject = "PRJNA841653", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA841653", 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
6334883	6334883	PRJNA841653_P_NODE_43005_length_251_cov_28.129213_g42331_i0	PRJNA841653	43005	251	28.129213	70.60432463	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82.4	2.9e-11	NTclustered	gi\|1858375043\|gb\|MT622645.1\|	84095	g42331	i0	82.609	38.2151394422311	92	16	37	0	8	99	5960	6051	Graffilla buccinicola small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	9592	82.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Rhabdocoela	Graffillidae	Graffilla	Graffilla buccinicola
11434607	11434607	PRJNA841653_P_NODE_44629_length_250_cov_3348.129944_g43955_i0	PRJNA841653	44629	250	3348.129944	8370.32486	Rhabditophora	147100	Platyhelminthes	Platyhelminthes	176	1.2899999999999999e-39	NTclustered	gi\|28273268\|gb\|AY157156.1\|	84079	g43955	i0	89.51	51.704	143	9	57	5	99	240	2894	2757	Geocentrophora wagini 28S large subunit ribosomal RNA gene, partial sequence	blastn	12926	176	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Lecithoepitheliata	Prorhynchidae	Geocentrophora	Geocentrophora wagini
18681496	18681496	PRJNA841653_P_NODE_22155_length_346_cov_1.457875_g21481_i0	PRJNA841653	22155	346	1.457875	5.0442475	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	204	8.539999999999999e-48	NTclustered	gi\|1116517974\|gb\|AY485340.2\|	6183	g21481	i0	83.186	82.2312138728324	226	34	65	4	10	233	6	229	Schistosoma mansoni ubiquitin mRNA, partial cds	blastn	28452	204	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
20357138	20357138	PRJNA841653_P_NODE_38056_length_267_cov_1.438144_g37382_i0	PRJNA841653	38056	267	1.438144	3.83984448	Monogenea	37945	Platyhelminthes	Platyhelminthes	99	3.09e-16	NTclustered	gi\|28273281\|gb\|AY157169.1\|	82849	g37382	i0	83.81	10.4794007490637	105	15	39	2	1	105	2439	2337	Diclidophora denticulata 28S large subunit ribosomal RNA gene, partial sequence	blastn	2798	99	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Mazocraeidea	Diclidophoridae	Diclidophora	Diclidophora denticulata
22507838	22507838	PRJNA841653_P_NODE_63978_length_226_cov_24.732026_g63304_i0	PRJNA841653	63978	226	24.732026	55.89437876	Temnosewellia minor	216952	Platyhelminthes	Platyhelminthes	150	6.93e-32	NTclustered	gi\|28273276\|gb\|AY157164.1\|	216952	g63304	i0	89.167	55.8318584070796	120	13	53	0	3	122	2666	2785	Temnosewellia minor 28S large subunit ribosomal RNA gene, partial sequence	blastn	12618	150	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Rhabdocoela	Temnocephalidae	Temnosewellia	Temnosewellia minor
29391635	29391635	PRJNA841653_P_NODE_27509_length_311_cov_1.210084_g26835_i0	PRJNA841653	27509	311	1.210084	3.76336124	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	57.8	4.18e-7	NR	PAA86220.1	282301	g26835	i0	30.1	0.993569131832797	103	71	98.4	1	5	310	113	215	PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano]	diamond	309	57.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30474060	30474060	PRJNA841653_P_NODE_48033_length_249_cov_0.875000_g47359_i0	PRJNA841653	48033	249	0.875	2.17875	Metazoa	33208	Platyhelminthes	Platyhelminthes	105	2.5399999999999998e-24	NR	XP_018650241.1	6183	g47359	i0	65.9	60.9156626506024	82	28	98.8	0	4	249	270	351	XP_018650241.1 putative coatomer beta subunit [Schistosoma mansoni]	diamond	15168	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
32244820	32244820	PRJNA841653_P_NODE_48538_length_248_cov_0.880000_g47864_i0	PRJNA841653	48538	248	0.88	2.1824	Cestoda	6199	Platyhelminthes	Platyhelminthes	135	1.3399999999999996e-34	NR	VDM31463.1	6205	g47864	i0	78.8	97.741935483871	80	17	96.8	0	8	247	767	846	VDM31463.1 unnamed protein product [Hydatigera taeniaeformis]	diamond	24240	136	0.992647058823529	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Hydatigera	Hydatigera taeniaeformis
32781175	32781175	PRJNA841653_P_NODE_39400_length_263_cov_1.163158_g38726_i0	PRJNA841653	39400	263	1.163158	3.05910554	Metazoa	33208	Platyhelminthes	Platyhelminthes	88.6	2.23e-19	NR	CDS41856.1	6211	g38726	i0	59.5	5.06463878326996	74	30	84.4	0	27	248	15	88	CDS41856.1 elongation factor 1 beta [Echinococcus multilocularis]	diamond	1332	89.4	0.991051454138702	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus multilocularis

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