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

6 rows where analysis = "diamond", bioproject = "PRJNA879067" 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_family	tax_genus	tax_species
5957036	5957036	PRJNA879067_P_NODE_10405_length_1527_cov_11.620358_g8262_i0	PRJNA879067	10405	1527	11.620358	177.44286666	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	140	6.64e-32	NR	KAL0485330.1	1008807	g8262	i0	29.6	0.717092337917485	365	176	70.3	11	32	1105	169	459	KAL0485330.1 hypothetical protein AKO1_002927 [Acrasis kona]	diamond	1095	140	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
9782583	9782583	PRJNA879067_P_NODE_32308_length_726_cov_2.678407_g28956_i0	PRJNA879067	32308	726	2.678407	19.44523482	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	116	8.79e-28	NR	KAL0487086.1	1008807	g28956	i0	45.5	0.508264462809917	123	46	50.8	1	276	644	118	219	KAL0487086.1 alpha-ketoglutarate-dependent dioxygenase [Acrasis kona]	diamond	369	116	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
18706446	18706446	PRJNA879067_P_NODE_41055_length_611_cov_2.421933_g37603_i0	PRJNA879067	41055	611	2.421933	14.79801063	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	116	3.95e-26	NR	CAG4719018.1	5763	g37603	i0	45.5	2.25859247135843	156	67	76.6	5	576	109	511	648	CAG4719018.1 unnamed protein product [Naegleria fowleri]	diamond	1380	117	0.991452991452991	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
27695416	27695416	PRJNA879067_P_NODE_67244_length_403_cov_3.681818_g63759_i0	PRJNA879067	67244	403	3.681818	14.83772654	Naegleria	5761	Heterolobosea	other_Eukaryota	83.6	1.15e-15	NR	CAG4714578.1	5763	g63759	i0	48.1	3.59553349875931	79	39	58.8	2	5	241	555	631	CAG4714578.1 unnamed protein product [Naegleria fowleri]	diamond	1449	83.6	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
28792017	28792017	PRJNA879067_P_NODE_6567_length_1964_cov_9.224749_g4898_i1	PRJNA879067	6567	1964	9.224749	181.17407036	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	80.1	1.37e-11	NR	KAL0487771.1	1008807	g4898	i1	21.2	0.879837067209776	576	382	84.5	23	181	1839	19	545	KAL0487771.1 DNA-directed RNA polymerase subunit omega [Acrasis kona]	diamond	1728	80.1	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
29234309	29234309	PRJNA879067_P_NODE_6549_length_1967_cov_8.031679_g4898_i0	PRJNA879067	6549	1967	8.031679	157.98312593	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	80.5	1.04e-11	NR	KAL0487771.1	1008807	g4898	i0	21.5	0.88002033553635	577	380	84.5	23	1787	126	19	545	KAL0487771.1 DNA-directed RNA polymerase subunit omega [Acrasis kona]	diamond	1731	80.5	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona

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