metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA407886" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA407886" and tax_phylum = "Fornicata"

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
28292153	28292153	PRJNA407886_P_NODE_26686_length_455_cov_1.410995_g24994_i0	PRJNA407886	26686	455	1.410995	6.42002725	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	46.2	0.0198	NR	ESU41363.1	5741	g24994	i0	48.7	1.3978021978022	39	20	25.7	0	335	451	700	738	ESU41363.1 Variant-specific surface protein [Giardia intestinalis]	diamond	636	46.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29349240	29349240	PRJNA407886_P_NODE_52289_length_296_cov_3.022422_g50595_i0	PRJNA407886	52289	296	3.022422	8.94636912	Giardia muris	5742	Fornicata	other_Eukaryota	52.4	2.74e-5	NR	TNJ26365.1	5742	g50595	i0	67.7	0.314189189189189	31	10	31.4	0	1	93	408	438	TNJ26365.1 Ornithine decarboxylase [Giardia muris]	diamond	93	52.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
29349241	29349241	PRJNA407886_P_NODE_53889_length_291_cov_2.761468_g52195_i0	PRJNA407886	53889	291	2.761468	8.03587188	Kipferlia bialata	797122	Fornicata	other_Eukaryota	102	4.3e-23	NR	GIQ81893.1	797122	g52195	i0	55.6	0.927835051546392	90	40	92.8	0	2	271	221	310	GIQ81893.1 ornithine decarboxylase, partial [Kipferlia bialata]	diamond	270	102	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
30012487	30012487	PRJNA407886_P_NODE_78291_length_244_cov_0.900585_g76597_i0	PRJNA407886	78291	244	0.900585	2.1974274	Giardia intestinalis	5741	Fornicata	other_Eukaryota	43.5	0.0191	NR	ESU42997.1	5741	g76597	i0	60.6	0.405737704918033	33	12	39.3	1	239	144	208	240	ESU42997.1 Variant-specific surface protein [Giardia intestinalis]	diamond	99	43.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30360323	30360323	PRJNA407886_P_NODE_25532_length_471_cov_1.507538_g23841_i0	PRJNA407886	25532	471	1.507538	7.10050398	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	94.4	4.15e-21	NR	KAG9392754.1	201153	g23841	i0	38.6	1.78980891719745	132	74	82.8	3	440	51	37	163	KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera]	diamond	843	94.4	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
31529378	31529378	PRJNA407886_P_NODE_27016_length_450_cov_17.745358_g25323_i0	PRJNA407886	27016	450	17.745358	79.854111	Giardia intestinalis assemblage B	1394984	Fornicata	other_Eukaryota	47.8	0.00563	NR	KWX13038.1	1394984	g25323	i0	37	0.486666666666667	73	42	46	2	337	131	103	175	KWX13038.1 Variant-specific surface protein [Giardia intestinalis assemblage B]	diamond	219	47.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
32162080	32162080	PRJNA407886_P_NODE_23458_length_503_cov_2.651163_g21767_i0	PRJNA407886	23458	503	2.651163	13.33534989	Giardia muris	5742	Fornicata	other_Eukaryota	63.2	4.55e-8	NR	TNJ29110.1	5742	g21767	i0	49.2	0.351888667992048	59	27	33.4	2	386	219	1314	1372	TNJ29110.1 High cysteine membrane protein [Giardia muris]	diamond	177	63.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
32730775	32730775	PRJNA407886_P_NODE_80160_length_242_cov_0.911243_g78466_i0	PRJNA407886	80160	242	0.911243	2.20520806	Hexamita inflata	28002	Fornicata	other_Eukaryota	48.9	2.36e-4	NR	CAK8746233.1	28002	g78466	i0	48	0.619834710743802	50	25	60.7	1	191	45	320	369	CAK8746233.1 HINF_020048 [Hexamita inflata]	diamond	150	48.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata

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