metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB12366" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB12366" and tax_clade = "Discoba"

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_class	tax_order	tax_family	tax_genus	tax_species
2570631	2570631	PRJEB12366_P_NODE_13383_length_198_cov_1.208589_g13193_i0	PRJEB12366	13383	198	1.208589	2.39300622	Bodo saltans	75058	Euglenozoa	other_Eukaryota	119	2.03e-32	NR	CUG83124.1	75058	g13193	i0	84.6	1.96969696969697	65	10	98.5	0	197	3	41	105	CUG83124.1 40S ribosomal protein S13, putative [Bodo saltans]	diamond	390	119	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
15322959	15322959	PRJEB12366_P_NODE_20433_length_150_cov_0.895652_g20243_i0	PRJEB12366	20433	150	0.895652	1.343478	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	83.6	3.01e-18	NR	KAL0480790.1	1008807	g20243	i0	87.2	0.94	47	6	94	0	143	3	115	161	KAL0480790.1 ribosomal protein L19 [Acrasis kona]	diamond	141	83.6	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
17872378	17872378	PRJEB12366_P_NODE_19255_length_155_cov_1.991667_g19065_i0	PRJEB12366	19255	155	1.991667	3.08708385	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	99.4	1.08e-22	NR	KAJ9464344.1	91374	g19065	i0	92.2	0.987096774193548	51	4	98.7	0	153	1	108	158	KAJ9464344.1 putative succinyl-CoA:3-ketoacid coenzyme A transferase [Diplonema papillatum]	diamond	153	99.4	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29559199	29559199	PRJEB12366_P_NODE_20130_length_151_cov_1.379310_g19940_i0	PRJEB12366	20130	151	1.37931	2.0827581	Trypanosoma melophagium	715481	Euglenozoa	other_Eukaryota	72.4	1.34e-13	NR	XP_067190936.1	715481	g19940	i0	68	0.993377483443709	50	16	99.3	0	150	1	50	99	XP_067190936.1 Ribosomal protein S3Ae [Trypanosoma melophagium]	diamond	150	72.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma melophagium
31392003	31392003	PRJEB12366_P_NODE_19576_length_154_cov_1.058824_g19386_i0	PRJEB12366	19576	154	1.058824	1.63058896	Bodo saltans	75058	Euglenozoa	other_Eukaryota	101	2.06e-25	NR	CUI15204.1	75058	g19386	i0	90.2	0.993506493506494	51	5	99.4	0	2	154	29	79	CUI15204.1 ADP-ribosylation factor 1, putative [Bodo saltans]	diamond	153	101	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32182772	32182772	PRJEB12366_P_NODE_14298_length_190_cov_0.954839_g14108_i0	PRJEB12366	14298	190	0.954839	1.8141941	Leishmania mexicana MHOM/GT/2	5665	Euglenozoa	other_Eukaryota	45.4	0.00204	NR	XP_003876670.1	929439	g14108	i0	46.6	0.91578947368421	58	29	88.4	2	188	21	1444	1501	XP_003876670.1 putative ABC transporter [Leishmania mexicana MHOM/GT/2001/U1103]	diamond	174	45.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania mexicana

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