metadata: contig_metadata: 16 rows where bioproject = "PRJNA812715" and tax

16 rows where bioproject = "PRJNA812715" 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
7603134	7603134	PRJNA812715_P_NODE_57006_length_350_cov_1.667870_g55207_i0	PRJNA812715	57006	350	1.66787	5.837545	Monocercomonoides	302781	Preaxostyla	other_Eukaryota	392	1.72e-104	NTclustered	gi\|156708131\|gb\|EF474123.1\|	302782	g55207	i0	88.379	92.9085714285714	327	36	93	2	25	350	1278	953	Monocercomonoides sp. PA clone 4/4 tubulin alpha subunit mRNA, complete cds	blastn	32518	392	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides sp. PA
12291124	12291124	PRJNA812715_P_NODE_108490_length_248_cov_0.880000_g106689_i0	PRJNA812715	108490	248	0.88	2.1824	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	209	1.26e-49	NTclustered	gi\|2794954618\|ref\|XM_067872953.1\|	2049356	g106689	i0	82.258	64.0201612903226	248	38	99	6	4	248	423	179	Monocercomonoides exilis conventional actin (MONOS_2989), mRNA	blastn	15877	209	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
12291311	12291311	PRJNA812715_P_NODE_115690_length_244_cov_0.900585_g113889_i0	PRJNA812715	115690	244	0.900585	2.1974274	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	76.8	1.31e-9	NTclustered	gi\|2794977061\|ref\|XM_067879212.1\|	2049356	g113889	i0	100	0.422131147540984	41	0	17	0	6	46	14274	14314	Monocercomonoides exilis putative Dual specificity phosphatase, catalytic domain (MONOS_8775), partial mRNA	blastn	103	76.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
19940028	19940028	PRJNA812715_P_NODE_44056_length_417_cov_2.000000_g42261_i0	PRJNA812715	44056	417	2	8.34	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	126	4.11e-34	NR	KAK2959335.1	2049346	g42261	i0	60.5	3.0863309352518	86	34	61.9	0	395	138	1	86	KAK2959335.1 putative 60S ribosomal protein L21-A [Blattamonas nauphoetae]	diamond	1287	126	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
23766058	23766058	PRJNA812715_P_NODE_50019_length_382_cov_2.268608_g48222_i0	PRJNA812715	50019	382	2.268608	8.66608256	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	67.6	1.3e-6	NTclustered	gi\|2794958030\|ref\|XM_067876128.1\|	2049356	g48222	i0	97.436	1.83507853403141	39	1	10	0	19	57	1463	1425	Monocercomonoides exilis uncharacterized protein (MONOS_5936), partial mRNA	blastn	701	67.6	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
27125887	27125887	PRJNA812715_P_NODE_50082_length_382_cov_1.495146_g48285_i0	PRJNA812715	50082	382	1.495146	5.71145772	Oxymonadida	66288	Preaxostyla	other_Eukaryota	75.1	7.19e-13	NR	KAA6391363.1	222440	g48285	i0	37.2	2.03403141361257	129	74	97.4	3	372	1	203	329	KAA6391363.1 MAG: sugar porter family MFS transporter [Streblomastix strix]	diamond	777	75.5	0.994701986754967	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
28222725	28222725	PRJNA812715_P_NODE_45026_length_411_cov_1.115385_g43230_i0	PRJNA812715	45026	411	1.115385	4.58423235	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	84	9.72e-16	NR	XP_067729148.1	2049356	g43230	i0	32	2.2992700729927	153	83	96.4	3	2	397	1046	1198	XP_067729148.1 putative myoferlin-like protein [Monocercomonoides exilis]	diamond	945	84	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
28515917	28515917	PRJNA812715_P_NODE_66587_length_316_cov_1.263374_g64787_i0	PRJNA812715	66587	316	1.263374	3.99226184	Monocercomonoides	302781	Preaxostyla	other_Eukaryota	150	2.2099999999999993e-43	NR	ABU93327.1	302782	g64787	i0	80.9	1.78481012658228	94	18	89.2	0	3	284	108	201	ABU93327.1 translation elongation factor-1 alpha, partial [Monocercomonoides sp. PA]	diamond	564	150	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides sp. PA
28665009	28665009	PRJNA812715_P_NODE_116127_length_244_cov_0.900585_g114326_i0	PRJNA812715	116127	244	0.900585	2.1974274	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	99	1.36e-22	NR	XP_067727667.1	2049356	g114326	i0	66.7	1.77049180327869	72	24	88.5	0	244	29	260	331	XP_067727667.1 putative 60S ribosomal protein L7a [Monocercomonoides exilis]	diamond	432	99	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
29738193	29738193	PRJNA812715_P_NODE_42810_length_426_cov_1.011331_g41015_i0	PRJNA812715	42810	426	1.011331	4.30827006	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	57	2.85e-6	NR	KAA6396828.1	222440	g41015	i0	37.5	1.78169014084507	88	55	62	0	148	411	635	722	KAA6396828.1 MAG: hypothetical protein EZS28_007644, partial [Streblomastix strix]	diamond	759	57	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
29769891	29769891	PRJNA812715_P_NODE_35431_length_488_cov_4.501205_g33646_i0	PRJNA812715	35431	488	4.501205	21.9658804	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	47.8	0.00435	NR	KAA6395684.1	222440	g33646	i0	39	0.473360655737705	77	32	46.1	4	179	403	36	99	KAA6395684.1 MAG: hypothetical protein EZS28_008787 [Streblomastix strix]	diamond	231	47.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
30126064	30126064	PRJNA812715_P_NODE_95332_length_260_cov_1.647059_g93531_i0	PRJNA812715	95332	260	1.647059	4.2823534	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	92.8	1.61e-22	NR	KAA6315575.1	222440	g93531	i0	54.1	4.05	74	34	85.4	0	18	239	4	77	KAA6315575.1 MAG: putative dpy-30 protein [Streblomastix strix]	diamond	1053	93.2	0.995708154506438	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
31792508	31792508	PRJNA812715_P_NODE_76057_length_291_cov_1.059633_g74257_i0	PRJNA812715	76057	291	1.059633	3.08353203	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	67	1.94e-10	NR	KAA6390727.1	222440	g74257	i0	47.1	1.56701030927835	70	34	72.2	1	278	69	896	962	KAA6390727.1 MAG: hypothetical protein EZS28_013746, partial [Streblomastix strix]	diamond	456	67	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
32267456	32267456	PRJNA812715_P_NODE_110518_length_247_cov_0.873563_g108717_i0	PRJNA812715	110518	247	0.873563	2.15770061	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	82.4	4.01e-16	NR	XP_067727099.1	2049356	g108717	i0	66.1	1.36032388663968	56	19	68	0	3	170	253	308	XP_067727099.1 putative Peptidase A22A, presenilin [Monocercomonoides exilis]	diamond	336	82.4	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
32623730	32623730	PRJNA812715_P_NODE_112180_length_246_cov_0.890173_g110379_i0	PRJNA812715	112180	246	0.890173	2.18982558	Streblomastigidae	222438	Preaxostyla	other_Eukaryota	131	1.97e-33	NR	KAA6395795.1	222440	g110379	i0	82.9	1.98780487804878	82	13	98.8	1	244	2	338	419	KAA6395795.1 MAG: putative Heat shock 70 kDa protein C, partial [Streblomastix strix]	diamond	489	131	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
32866908	32866908	PRJNA812715_P_NODE_111300_length_246_cov_0.890173_g109499_i0	PRJNA812715	111300	246	0.890173	2.18982558	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	63.9	8.81e-10	NR	KAK2964312.1	2049346	g109499	i0	53.8	1.25609756097561	52	23	63.4	1	1	156	232	282	KAK2964312.1 hypothetical protein BLNAU_843 [Blattamonas nauphoetae]	diamond	309	63.9	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae

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