metadata: contig_metadata: 6 rows where bioproject = "PRJNA833575", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA833575", 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
16531645	16531645	PRJNA833575_P_NODE_37253_length_239_cov_1.270588_g37116_i0	PRJNA833575	37253	239	1.270588	3.03670532	Metazoa	33208	Platyhelminthes	Platyhelminthes	107	5.1e-26	NR	AWM96389.1	6161	g37116	i0	65.8	4.80753138075314	79	27	99.2	0	3	239	152	230	AWM96389.1 cathepsin L2 [Dugesia japonica]	diamond	1149	108	0.990740740740741	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
22906537	22906537	PRJNA833575_P_NODE_34218_length_253_cov_1.032609_g34081_i0	PRJNA833575	34218	253	1.032609	2.61250077	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	149	4.929999999999999e-42	NR	CAB89813.1	107733	g34081	i0	83.3	25.897233201581	84	14	99.6	0	253	2	234	317	CAB89813.1 putative elongation factor 1-alpha, partial [Leptoplana tremellaris]	diamond	6552	149	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Polycladida	Leptoplanidae	Leptoplana	Leptoplana tremellaris
29075874	29075874	PRJNA833575_P_NODE_33568_length_255_cov_1.548387_g33431_i0	PRJNA833575	33568	255	1.548387	3.94838685	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	109	1.84e-26	NR	PAA58179.1	282301	g33431	i0	59.3	1.01176470588235	86	33	98.8	1	254	3	199	284	PAA58179.1 hypothetical protein BOX15_Mlig030029g2 [Macrostomum lignano]	diamond	258	109	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30505529	30505529	PRJNA833575_P_NODE_29693_length_273_cov_1.058824_g29556_i0	PRJNA833575	29693	273	1.058824	2.89058952	Metazoa	33208	Platyhelminthes	Platyhelminthes	110	6.77e-28	NR	KAF8569295.1	34504	g29556	i0	60.2	4.92307692307692	88	35	96.7	0	267	4	109	196	KAF8569295.1 hypothetical protein P879_00883 [Paragonimus westermani]	diamond	1344	111	0.990990990990991	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus westermani
32267746	32267746	PRJNA833575_P_NODE_30258_length_270_cov_1.432836_g30121_i0	PRJNA833575	30258	270	1.432836	3.8686572	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	126	2.19e-33	NR	AAX73171.1	6210	g30121	i0	69.7	3.95555555555556	89	27	98.9	0	269	3	100	188	AAX73171.1 putative malate dehydrogenase, partial [Echinococcus granulosus]	diamond	1068	126	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
32678109	32678109	PRJNA833575_P_NODE_31480_length_265_cov_1.102041_g31343_i0	PRJNA833575	31480	265	1.102041	2.92040865	Paragonimus heterotremus	100268	Platyhelminthes	Platyhelminthes	117	8.85e-30	NR	KAF5401317.1	100268	g31343	i0	65.5	6.54339622641509	84	29	95.1	0	252	1	75	158	KAF5401317.1 Ubiquinol-cytochrome c reductase cytochrome c1 subunit [Paragonimus heterotremus]	diamond	1734	117	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus heterotremus

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