metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA473641" 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
13198527	13198527	PRJNA473641_P_NODE_16531_length_255_cov_1.318681_g16448_i0	PRJNA473641	16531	255	1.318681	3.36263655	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99.8	1.73e-23	NR	QLA09579.1	3039	g16448	i0	60.2	26.3647058823529	83	31	97.6	1	2	250	20	100	QLA09579.1 40S small subunit ribosomal protein eS1 [Euglena gracilis]	diamond	6723	100	0.998	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
26649014	26649014	PRJNA473641_P_NODE_25801_length_241_cov_0.916667_g25718_i0	PRJNA473641	25801	241	0.916667	2.20916747	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	115	7.079999999999999e-31	NR	XP_044555121.1	51637	g25718	i0	81	3.149377593361	63	12	78.4	0	197	9	18	80	XP_044555121.1 uncharacterized protein C9374_009804 [Naegleria lovaniensis]	diamond	759	115	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria lovaniensis
28749957	28749957	PRJNA473641_P_NODE_14727_length_270_cov_1.548223_g14644_i0	PRJNA473641	14727	270	1.548223	4.1802021	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	47	0.00174	NR	KAJ9463902.1	91374	g14644	i0	39.7	0.644444444444444	58	35	64.4	0	97	270	515	572	KAJ9463902.1 hypothetical protein DIPPA_03282 [Diplonema papillatum]	diamond	174	47	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29665205	29665205	PRJNA473641_P_NODE_16530_length_255_cov_1.318681_g16447_i0	PRJNA473641	16530	255	1.318681	3.36263655	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	80.5	1.02e-15	NR	KAJ9463367.1	91374	g16447	i0	59.4	0.752941176470588	64	24	75.3	1	255	64	249	310	KAJ9463367.1 putative prolyl 4-hydroxylase 9 [Diplonema papillatum]	diamond	192	80.5	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
31877710	31877710	PRJNA473641_P_NODE_5257_length_399_cov_0.944785_g5174_i0	PRJNA473641	5257	399	0.944785	3.76969215	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	133	1.64e-33	NR	XP_044563768.1	5763	g5174	i0	50.8	1.95488721804511	130	62	97.7	2	399	10	282	409	XP_044563768.1 uncharacterized protein FDP41_002125 [Naegleria fowleri]	diamond	780	133	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri

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