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

8 rows where analysis = "diamond", bioproject = "PRJNA986481" 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
4801319	4801319	PRJNA986481_P_NODE_26284_length_320_cov_1.981550_g25759_i0	PRJNA986481	26284	320	1.98155	6.34096	Giardia	5740	Fornicata	other_Eukaryota	105	2.12e-24	NR	ESU37416.1	5741	g25759	i0	55.8	4.33125	86	36	78.8	1	65	316	17	102	ESU37416.1 Protein disulfide isomerase [Giardia intestinalis]	diamond	1386	105	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
26715390	26715390	PRJNA986481_P_NODE_12601_length_462_cov_1.709443_g12077_i0	PRJNA986481	12601	462	1.709443	7.89762666	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	89.7	7.88e-18	NR	CAK8746233.1	28002	g12077	i0	60.8	1.81168831168831	79	20	51.3	1	88	324	177	244	CAK8746233.1 HINF_020048 [Hexamita inflata]	diamond	837	89.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
27468929	27468929	PRJNA986481_P_NODE_13983_length_438_cov_3.732648_g13459_i0	PRJNA986481	13983	438	3.732648	16.34899824	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	82.4	2.5e-15	NR	KAG9394805.1	201153	g13459	i0	34.8	1.96575342465753	141	87	95.2	3	428	12	12	149	KAG9394805.1 Chromo (CHRromatin Organization MOdifier) domain [Carpediemonas membranifera]	diamond	861	82.4	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
27910602	27910602	PRJNA986481_P_NODE_34065_length_280_cov_1.653680_g33540_i0	PRJNA986481	34065	280	1.65368	4.630304	Kipferlia bialata	797122	Fornicata	other_Eukaryota	118	6.59e-31	NR	GIQ90154.1	797122	g33540	i0	61.3	0.996428571428571	93	35	98.6	1	3	278	114	206	GIQ90154.1 hypothetical protein KIPB_012838, partial [Kipferlia bialata]	diamond	279	118	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
29615505	29615505	PRJNA986481_P_NODE_36690_length_269_cov_1.650000_g36165_i0	PRJNA986481	36690	269	1.65	4.4385	Kipferlia bialata	797122	Fornicata	other_Eukaryota	78.6	8.66e-15	NR	GIQ82827.1	797122	g36165	i0	44.6	4.09293680297398	92	48	99.3	1	269	3	125	216	GIQ82827.1 ADP-ribosylation/Crystallin J1 [Kipferlia bialata]	diamond	1101	78.6	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
29678647	29678647	PRJNA986481_P_NODE_22090_length_349_cov_1.683333_g21565_i0	PRJNA986481	22090	349	1.683333	5.87483217	Giardia intestinalis	5741	Fornicata	other_Eukaryota	48.1	0.00157	NR	ESU38684.1	5741	g21565	i0	49	0.421203438395415	49	21	38.7	1	344	210	530	578	ESU38684.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	147	48.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30121057	30121057	PRJNA986481_P_NODE_52552_length_249_cov_1.515000_g52027_i0	PRJNA986481	52552	249	1.515	3.77235	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	49.3	2e-4	NR	KAG9396990.1	201153	g52027	i0	52.2	1.68674698795181	46	20	53	2	30	161	759	804	KAG9396990.1 ABC transporter substrate-binding protein [Carpediemonas membranifera]	diamond	420	49.3	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
32870668	32870668	PRJNA986481_P_NODE_50760_length_251_cov_1.574257_g50235_i0	PRJNA986481	50760	251	1.574257	3.95138507	Giardia lamblia P15	658858	Fornicata	other_Eukaryota	45.8	0.00337	NR	EFO62016.1	658858	g50235	i0	70	0.358565737051793	30	8	35.9	1	241	152	403	431	EFO62016.1 VSP with INR [Giardia lamblia P15]	diamond	90	45.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis

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