metadata: contig_metadata: 9 rows where bioproject = "PRJEB12237" and tax

9 rows where bioproject = "PRJEB12237" 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
28201401	28201401	PRJEB12237_P_NODE_6426_length_227_cov_3.442708_g6230_i0	PRJEB12237	6426	227	3.442708	7.81494716	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	66.6	9.2e-12	NR	KAJ5069708.1	1746090	g6230	i0	55.4	0.740088105726872	56	25	74	0	227	60	86	141	KAJ5069708.1 coactosin [Anaeramoeba ignava]	diamond	168	66.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
28296219	28296219	PRJEB12237_P_NODE_10566_length_163_cov_1.250000_g10370_i0	PRJEB12237	10566	163	1.25	2.0375	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	49.7	3.09e-5	NR	KAA6391469.1	222440	g10370	i0	48.1	1.95092024539877	54	23	99.4	2	163	2	30	78	KAA6391469.1 MAG: hypothetical protein EZS28_013002 [Streblomastix strix]	diamond	318	49.7	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
28864602	28864602	PRJEB12237_P_NODE_11848_length_152_cov_1.709402_g11652_i0	PRJEB12237	11848	152	1.709402	2.59829104	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	51.2	6.78e-6	NR	KAJ4458877.1	342808	g11652	i0	50	1.91447368421053	48	24	94.7	0	152	9	119	166	KAJ4458877.1 putative sialate O-acetylesterase [Paratrimastix pyriformis]	diamond	291	51.2	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28921353	28921353	PRJEB12237_P_NODE_11308_length_156_cov_2.206612_g11112_i0	PRJEB12237	11308	156	2.206612	3.44231472	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.5	1.35e-9	NR	KAG9392544.1	201153	g11112	i0	61.4	4.17307692307692	44	17	84.6	0	1	132	121	164	KAG9392544.1 Ribosomal protein L11/L12 [Carpediemonas membranifera]	diamond	651	60.8	0.995065789473684	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
29212148	29212148	PRJEB12237_P_NODE_4569_length_294_cov_2.463320_g4373_i0	PRJEB12237	4569	294	2.46332	7.2421608	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	111	1.53e-29	NR	KAA6379614.1	222440	g4373	i0	58.2	4.55102040816327	91	38	92.9	0	290	18	3	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1338	111	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
30475455	30475455	PRJEB12237_P_NODE_4453_length_300_cov_1.860377_g4257_i0	PRJEB12237	4453	300	1.860377	5.581131	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	44.3	0.0217	NR	KAK2942807.1	2049346	g4257	i0	34.1	9.1	91	52	83	2	287	39	1363	1453	KAK2942807.1 hypothetical protein BLNAU_22286 [Blattamonas nauphoetae]	diamond	2730	44.3	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
31834447	31834447	PRJEB12237_P_NODE_4917_length_279_cov_1.475410_g4721_i0	PRJEB12237	4917	279	1.47541	4.1163939	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	72.4	1.61e-13	NR	KAG9392754.1	201153	g4721	i0	42	0.946236559139785	88	50	93.5	1	267	7	37	124	KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera]	diamond	264	72.4	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
32151075	32151075	PRJEB12237_P_NODE_2618_length_433_cov_2.814070_g2422_i0	PRJEB12237	2618	433	2.81407	12.1849231	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	83.2	1.4e-16	NR	KAJ3452455.1	1746091	g2422	i0	43.2	5.25173210161663	95	52	65.8	2	14	298	1	93	KAJ3452455.1 40S ribosomal protein S10 [Anaeramoeba flamelloides]	diamond	2274	83.2	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
32499327	32499327	PRJEB12237_P_NODE_7019_length_214_cov_1.776536_g6823_i0	PRJEB12237	7019	214	1.776536	3.80178704	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	56.6	3.26e-7	NR	KAJ3448198.1	1746091	g6823	i0	54.4	0.799065420560748	57	25	78.5	1	47	214	226	282	KAJ3448198.1 hypothetical protein M0812_00674 [Anaeramoeba flamelloides]	diamond	171	56.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides

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