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

8 rows where bioproject = "PRJNA674048" 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
8296502	8296502	PRJNA674048_P_NODE_7067_length_373_cov_46.925926_g6864_i0	PRJNA674048	7067	373	46.925926	175.03370398	Trichomonas vaginalis	5722	Parabasalia	other_Eukaryota	65.8	4.56e-6	NTclustered	gi\|2319615616\|ref\|XR_007835995.1\|	412133	g6864	i0	90.385	0.624664879356568	52	2	14	3	224	274	2610	2561	Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0034210), rRNA	blastn	233	65.8	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
26638510	26638510	PRJNA674048_P_NODE_28581_length_167_cov_0.881356_g28378_i0	PRJNA674048	28581	167	0.881356	1.47186452	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	48.9	8.89e-5	NR	KAJ5068815.1	1746090	g28378	i0	48.9	0.808383233532934	45	23	80.8	0	8	142	667	711	KAJ5068815.1 villin [Anaeramoeba ignava]	diamond	135	48.9	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
27966106	27966106	PRJNA674048_P_NODE_30165_length_165_cov_0.896552_g29962_i0	PRJNA674048	30165	165	0.896552	1.4793108	Giardia intestinalis	5741	Fornicata	other_Eukaryota	46.6	5.63e-4	NR	ESU39526.1	5741	g29962	i0	54.3	0.636363636363636	35	13	58.2	1	103	8	14	48	ESU39526.1 Hypothetical protein DHA2_151120 [Giardia intestinalis]	diamond	105	46.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28502947	28502947	PRJNA674048_P_NODE_15407_length_228_cov_1.000000_g15204_i0	PRJNA674048	15407	228	1	2.28	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	42.4	0.0432	NR	KAG9392170.1	201153	g15204	i0	52.3	0.578947368421053	44	20	56.6	1	193	65	3829	3872	KAG9392170.1 FG-GAP repeat [Carpediemonas membranifera]	diamond	132	42.4	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
28692579	28692579	PRJNA674048_P_NODE_10587_length_288_cov_1.234310_g10384_i0	PRJNA674048	10587	288	1.23431	3.5548128	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	46.6	0.00284	NR	KAJ3437848.1	1746091	g10384	i0	48.8	0.447916666666667	43	22	44.8	0	14	142	216	258	KAJ3437848.1 insulin-like growth factor binding proteinn-terminal [Anaeramoeba flamelloides]	diamond	129	46.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29260495	29260495	PRJNA674048_P_NODE_7729_length_352_cov_1.359736_g7526_i0	PRJNA674048	7729	352	1.359736	4.78627072	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	156	3.8599999999999996e-43	NR	KAJ3444938.1	1746091	g7526	i0	62.9	0.988636363636364	116	43	98.9	0	3	350	8	123	KAJ3444938.1 coronin [Anaeramoeba flamelloides]	diamond	348	156	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29481394	29481394	PRJNA674048_P_NODE_28090_length_168_cov_0.873950_g27887_i0	PRJNA674048	28090	168	0.87395	1.468236	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	50.1	3.49e-5	NR	KAG9396990.1	201153	g27887	i0	52.2	0.821428571428571	46	20	78.6	2	167	36	759	804	KAG9396990.1 ABC transporter substrate-binding protein [Carpediemonas membranifera]	diamond	138	50.1	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
30303399	30303399	PRJNA674048_P_NODE_27532_length_168_cov_1.747899_g27329_i0	PRJNA674048	27532	168	1.747899	2.93647032	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	85.5	4.01e-18	NR	KAK2956056.1	2049346	g27329	i0	69.4	4.51785714285714	49	14	87.5	1	11	157	236	283	KAK2956056.1 putative Gut-specific cysteine proteinase [Blattamonas nauphoetae]	diamond	759	85.5	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);;