metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA760976" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA760976" and tax_clade = "Metamonada"

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_phylum	tax_order	tax_family	tax_genus	tax_species
28726902	28726902	PRJNA760976_P_NODE_24867_length_323_cov_1.528000_g24546_i0	PRJNA760976	24867	323	1.528	4.93544	Giardia intestinalis	5741	Fornicata	other_Eukaryota	50.8	1.36e-4	NR	ESU40154.1	5741	g24546	i0	47.6	2.58204334365325	42	22	39	0	1	126	406	447	ESU40154.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	834	50.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29074417	29074417	PRJNA760976_P_NODE_30448_length_301_cov_1.000000_g30127_i0	PRJNA760976	30448	301	1	3.01	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	55.5	2.5e-6	NR	KAJ3444726.1	1746091	g30127	i0	37.1	2.07308970099668	105	56	97.7	4	2	295	64	165	KAJ3444726.1 copine [Anaeramoeba flamelloides]	diamond	624	55.5	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29642247	29642247	PRJNA760976_P_NODE_57150_length_238_cov_2.187879_g56829_i0	PRJNA760976	57150	238	2.187879	5.20715202	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	67	3.54e-11	NR	KAJ5074052.1	1746090	g56829	i0	38.5	0.983193277310924	78	48	98.3	0	2	235	139	216	KAJ5074052.1 hypothetical protein M0811_00680 [Anaeramoeba ignava]	diamond	234	67	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
30189114	30189114	PRJNA760976_P_NODE_16972_length_369_cov_2.702703_g16651_i0	PRJNA760976	16972	369	2.702703	9.97297407	Giardia	5740	Fornicata	other_Eukaryota	45.8	0.00268	NR	ESU39623.1	5741	g16651	i0	50	2	52	26	42.3	0	159	4	40	91	ESU39623.1 Variant-specific surface protein [Giardia intestinalis]	diamond	738	45.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30464282	30464282	PRJNA760976_P_NODE_50453_length_247_cov_0.885057_g50132_i0	PRJNA760976	50453	247	0.885057	2.18609079	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	65.5	1.75e-10	NR	KAJ5067156.1	1746090	g50132	i0	38.5	0.947368421052632	78	47	94.7	1	239	6	37	113	KAJ5067156.1 nicotinamide/nicotinic acid mononucleotide adenylyltransferase 2 [Anaeramoeba ignava]	diamond	234	65.5	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
31411996	31411996	PRJNA760976_P_NODE_37916_length_277_cov_1.509804_g37595_i0	PRJNA760976	37916	277	1.509804	4.18215708	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	72.4	3.23e-13	NR	KAJ3452455.1	1746091	g37595	i0	38.8	2.67509025270758	85	51	92.1	1	264	10	1	84	KAJ3452455.1 40S ribosomal protein S10 [Anaeramoeba flamelloides]	diamond	741	72.4	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31485107	31485107	PRJNA760976_P_NODE_43396_length_262_cov_1.947090_g43075_i0	PRJNA760976	43396	262	1.94709	5.1013758	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	70.5	8.22e-12	NR	KAJ4462581.1	342808	g43075	i0	54.9	3.65267175572519	71	31	81.3	1	213	1	39	108	KAJ4462581.1 putative DNA repair protein RAD50 [Paratrimastix pyriformis]	diamond	957	70.9	0.994358251057828	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
31949546	31949546	PRJNA760976_P_NODE_48457_length_250_cov_1.248588_g48136_i0	PRJNA760976	48457	250	1.248588	3.12147	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	104	6.46e-25	NR	KAJ4462711.1	342808	g48136	i0	67.1	0.948	79	26	94.8	0	10	246	89	167	KAJ4462711.1 putative 60S acidic ribosomal protein P0 [Paratrimastix pyriformis]	diamond	237	104	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
32202847	32202847	PRJNA760976_P_NODE_49858_length_248_cov_0.862857_g49537_i0	PRJNA760976	49858	248	0.862857	2.13988536	Hexamita inflata	28002	Fornicata	other_Eukaryota	55.8	7.71e-7	NR	CAK8793668.1	28002	g49537	i0	47.9	0.580645161290323	48	25	58.1	0	5	148	65	112	CAK8793668.1 HINF_078939 [Hexamita inflata]	diamond	144	55.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata

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