metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Euglenozoa"

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
28244244	28244244	PRJNA436017_P_NODE_3166_length_526_cov_2.370143_g2890_i0	PRJNA436017	3166	526	2.370143	12.46695218	Leishmania tarentolae	5689	Euglenozoa	other_Eukaryota	59.7	4.86e-7	NR	GET93831.1	5689	g2890	i0	32.8	2.15589353612167	125	76	66.7	4	159	509	50	174	GET93831.1 elongation factor 1-gamma, putative [Leishmania tarentolae]	diamond	1134	59.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania tarentolae
28781019	28781019	PRJNA436017_P_NODE_21847_length_175_cov_1.130435_g21549_i0	PRJNA436017	21847	175	1.130435	1.97826125	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	87	1.19e-20	NR	KAJ9458068.1	91374	g21549	i0	86	0.737142857142857	43	6	73.7	0	173	45	49	91	KAJ9458068.1 60S ribosomal protein L37a [Diplonema papillatum]	diamond	129	87	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29791344	29791344	PRJNA436017_P_NODE_15771_length_208_cov_1.584795_g15473_i0	PRJNA436017	15771	208	1.584795	3.2963736	Porcisia hertigi	2761500	Euglenozoa	other_Eukaryota	76.6	2.72e-14	NR	XP_067753604.1	2761500	g15473	i0	49.3	1.97596153846154	69	35	99.5	0	2	208	137	205	XP_067753604.1 hypothetical protein JKF63_01400 [Porcisia hertigi]	diamond	411	76.6	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Porcisia	Porcisia hertigi
31324525	31324525	PRJNA436017_P_NODE_16735_length_201_cov_1.658537_g16437_i0	PRJNA436017	16735	201	1.658537	3.33365937	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	78.6	2.58e-15	NR	XP_011776787.1	679716	g16437	i0	66.7	1.46268656716418	48	16	71.6	0	144	1	2	49	XP_011776787.1 mitochondrial carrier protein, putative [Trypanosoma brucei gambiense DAL972]	diamond	294	79.3	0.991172761664565	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei

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