metadata: contig_metadata: 14 rows where bioproject = "PRJNA1204310", tax_clade = "Metamonada" and tax

14 rows where bioproject = "PRJNA1204310", tax_clade = "Metamonada" and tax_phylum = "Preaxostyla"

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
14357814	14357814	PRJNA1204310_P_NODE_20512_length_400_cov_0.822630_g20215_i0	PRJNA1204310	20512	400	0.82263	3.29052	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	199	3.45e-60	NR	KAJ4454657.1	342808	g20215	i0	67.4	5.9325	132	43	99	0	3	398	161	292	KAJ4454657.1 putative Developmentally-regulated G-protein 3 [Paratrimastix pyriformis]	diamond	2373	199	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
26775168	26775168	PRJNA1204310_P_NODE_51341_length_253_cov_0.866667_g51044_i0	PRJNA1204310	51341	253	0.866667	2.19266751	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	49.3	1.39e-4	NR	KAJ4460384.1	342808	g51044	i0	48.6	1.49407114624506	35	18	41.5	0	209	105	29	63	KAJ4460384.1 hypothetical protein PAPYR_3403 [Paratrimastix pyriformis]	diamond	378	49.3	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
27198809	27198809	PRJNA1204310_P_NODE_48522_length_261_cov_2.090426_g48225_i0	PRJNA1204310	48522	261	2.090426	5.45601186	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	47	0.00148	NR	KAJ4458289.1	342808	g48225	i0	40.7	1.17241379310345	54	32	62.1	0	98	259	146	199	KAJ4458289.1 putative inositol 5-phosphatase 1 [Paratrimastix pyriformis]	diamond	306	47	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
27407768	27407768	PRJNA1204310_P_NODE_43003_length_283_cov_1.109524_g42706_i0	PRJNA1204310	43003	283	1.109524	3.13995292	Polymastigidae	302780	Preaxostyla	other_Eukaryota	111	5.18e-26	NR	KAK2958730.1	2049346	g42706	i0	60	4.04946996466431	95	37	99.6	1	2	283	41	135	KAK2958730.1 putative protein kinase [Blattamonas nauphoetae]	diamond	1146	111	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
27957027	27957027	PRJNA1204310_P_NODE_13505_length_481_cov_2.127451_g13208_i0	PRJNA1204310	13505	481	2.127451	10.23303931	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	59.7	8.35e-8	NR	KAJ4462268.1	342808	g13208	i0	57.4	0.336798336798337	54	22	33.1	1	160	2	81	134	KAJ4462268.1 putative nucleolar and coiled-body phosphoprotein 1 [Paratrimastix pyriformis]	diamond	162	59.7	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28620231	28620231	PRJNA1204310_P_NODE_44547_length_277_cov_1.279412_g44250_i0	PRJNA1204310	44547	277	1.279412	3.54397124	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	52.4	2.37e-5	NR	KAK2944813.1	2049346	g44250	i0	35.6	0.974729241877256	90	55	97.5	2	7	276	758	844	KAK2944813.1 putative Disheveled-associated activator of morphogenesis 2 [Blattamonas nauphoetae]	diamond	270	52.4	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
28651663	28651663	PRJNA1204310_P_NODE_62767_length_242_cov_0.923077_g62470_i0	PRJNA1204310	62767	242	0.923077	2.23384634	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	90.5	3.81e-20	NR	KAJ4454933.1	342808	g62470	i0	53.2	0.954545454545455	77	36	95.5	0	235	5	130	206	KAJ4454933.1 putative phosphatidylinositol glycan; class H [Paratrimastix pyriformis]	diamond	231	90.5	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
29661555	29661555	PRJNA1204310_P_NODE_3210_length_912_cov_8.523242_g2985_i0	PRJNA1204310	3210	912	8.523242	77.73196704	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	59.3	6.34e-6	NR	KAJ4456837.1	342808	g2985	i0	24	1.01315789473684	308	192	93.4	11	863	12	13	302	KAJ4456837.1 putative amino acid abc transporter [Paratrimastix pyriformis]	diamond	924	59.3	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30072508	30072508	PRJNA1204310_P_NODE_31992_length_330_cov_0.964981_g31695_i0	PRJNA1204310	31992	330	0.964981	3.1844373	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	72	1.62e-12	NR	XP_067734459.1	2049356	g31695	i0	43	2.02727272727273	114	49	99.1	5	2	328	33	135	XP_067734459.1 putative leucine-rich melanocyte differentiation-associated protein [Monocercomonoides exilis]	diamond	669	72	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
30198789	30198789	PRJNA1204310_P_NODE_61372_length_243_cov_0.917647_g61075_i0	PRJNA1204310	61372	243	0.917647	2.22988221	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	47	0.00124	NR	KAJ4457127.1	342808	g61075	i0	36.3	0.987654320987654	80	48	98.8	2	243	4	613	689	KAJ4457127.1 piwi-like protein [Paratrimastix pyriformis]	diamond	240	47	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30577884	30577884	PRJNA1204310_P_NODE_40853_length_290_cov_1.142857_g40556_i0	PRJNA1204310	40853	290	1.142857	3.3142853	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	54.3	5.62e-6	NR	KAJ4458064.1	342808	g40556	i0	45.2	0.641379310344828	62	32	64.1	1	46	231	496	555	KAJ4458064.1 putative nucleoside phosphatase GDA1/CD39 [Paratrimastix pyriformis]	diamond	186	54.3	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30641174	30641174	PRJNA1204310_P_NODE_56713_length_248_cov_0.891429_g56416_i0	PRJNA1204310	56713	248	0.891429	2.21074392	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	50.8	1.1e-5	NR	KAJ4455742.1	342808	g56416	i0	45.1	4.45161290322581	51	28	61.7	0	176	24	17	67	KAJ4455742.1 hypothetical protein PAPYR_9236 [Paratrimastix pyriformis]	diamond	1104	50.8	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
31052347	31052347	PRJNA1204310_P_NODE_57455_length_247_cov_0.896552_g57158_i0	PRJNA1204310	57455	247	0.896552	2.21448344	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	104	2.13e-24	NR	XP_067724490.1	2049356	g57158	i0	59.5	7.67611336032389	79	32	96	0	239	3	163	241	XP_067724490.1 putative NAD-dependent epimerase [Monocercomonoides exilis]	diamond	1896	104	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
31969100	31969100	PRJNA1204310_P_NODE_24298_length_372_cov_1.548495_g24001_i0	PRJNA1204310	24298	372	1.548495	5.7604014	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	160	5.319999999999999e-46	NR	XP_067725493.1	2049356	g24001	i0	64.5	0.975806451612903	121	43	97.6	0	365	3	31	151	XP_067725493.1 putative NAD+ synthase [Monocercomonoides exilis]	diamond	363	160	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis

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