metadata: contig_metadata: 8 rows where bioproject = "PRJNA763243" and tax

8 rows where bioproject = "PRJNA763243" 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
10946763	10946763	PRJNA763243_P_NODE_14609_length_402_cov_6.975684_g14264_i0	PRJNA763243	14609	402	6.975684	28.04224968	Trichomonas vaginalis	5722	Parabasalia	other_Eukaryota	65.8	4.95e-6	NTclustered	gi\|2319615616\|ref\|XR_007835995.1\|	412133	g14264	i0	90.385	1.95522388059702	52	2	13	3	227	277	2610	2561	Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0034210), rRNA	blastn	786	65.8	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
27369577	27369577	PRJNA763243_P_NODE_71303_length_214_cov_5.347518_g70957_i0	PRJNA763243	71303	214	5.347518	11.44368852	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	48.5	2.4e-4	NR	KAJ3449789.1	1746091	g70957	i0	44.1	0.827102803738318	59	33	82.7	0	178	2	492	550	KAJ3449789.1 alpha-actinin sarcomeric-like protein [Anaeramoeba flamelloides]	diamond	177	48.5	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
28379604	28379604	PRJNA763243_P_NODE_49566_length_255_cov_2.000000_g49220_i0	PRJNA763243	49566	255	2	5.1	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	52.8	1.24e-5	NR	KAJ3440349.1	1746091	g49220	i0	37.5	0.941176470588235	80	45	92.9	4	6	242	22	97	KAJ3440349.1 hypothetical protein M0812_16407 [Anaeramoeba flamelloides]	diamond	240	52.8	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
28505940	28505940	PRJNA763243_P_NODE_66787_length_232_cov_3.855346_g66441_i0	PRJNA763243	66787	232	3.855346	8.94440272	Kipferlia bialata	797122	Fornicata	other_Eukaryota	53.5	5.08e-6	NR	GIQ80339.1	797122	g66441	i0	52.1	0.620689655172414	48	23	62.1	0	15	158	2886	2933	GIQ80339.1 hypothetical protein KIPB_001119, partial [Kipferlia bialata]	diamond	144	53.5	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
28537706	28537706	PRJNA763243_P_NODE_47687_length_259_cov_1.655914_g47341_i0	PRJNA763243	47687	259	1.655914	4.28881726	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	110	4.23e-26	NR	KAJ3424487.1	1746091	g47341	i0	61.8	5.28185328185328	76	29	88	0	22	249	22	97	KAJ3424487.1 adp-ribosylation factor gtpase-activating protein [Anaeramoeba flamelloides]	diamond	1368	110	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29642281	29642281	PRJNA763243_P_NODE_54150_length_249_cov_0.875000_g53804_i0	PRJNA763243	54150	249	0.875	2.17875	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	122	3.3799999999999995e-31	NR	KAJ3427686.1	1746091	g53804	i0	69.6	3.87951807228916	79	24	95.2	0	243	7	105	183	KAJ3427686.1 ribosomal protein L5-RELATED [Anaeramoeba flamelloides]	diamond	966	122	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
30306426	30306426	PRJNA763243_P_NODE_57492_length_246_cov_0.890173_g57146_i0	PRJNA763243	57492	246	0.890173	2.18982558	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	58.5	1.05e-7	NR	KAJ4454715.1	342808	g57146	i0	51.9	0.658536585365854	54	26	65.9	0	245	84	188	241	KAJ4454715.1 putative protein kinase [Paratrimastix pyriformis]	diamond	162	58.5	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
32519497	32519497	PRJNA763243_P_NODE_19419_length_358_cov_1.052632_g19074_i0	PRJNA763243	19419	358	1.052632	3.76842256	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	76.6	1.8e-13	NR	KAJ5079322.1	1746090	g19074	i0	39.7	0.972067039106145	116	68	97.2	2	351	4	374	487	KAJ5079322.1 importin subunit alpha-4 [Anaeramoeba ignava]	diamond	348	76.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava

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