metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1158727" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1158727" and tax_phylum = "Heterolobosea"

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
23259118	23259118	PRJNA1158727_P_NODE_96619_length_299_cov_2.309735_g89158_i0	PRJNA1158727	96619	299	2.309735	6.90610765	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	149	4.33e-44	NR	XP_044557059.1	5763	g89158	i0	71.7	9.93311036789298	99	28	99.3	0	2	298	31	129	XP_044557059.1 uncharacterized protein FDP41_009247 [Naegleria fowleri]	diamond	2970	150	0.993333333333333	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
27071905	27071905	PRJNA1158727_P_NODE_61742_length_415_cov_2.005848_g54281_i0	PRJNA1158727	61742	415	2.005848	8.3242692	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	96.3	3.95e-22	NR	KAL0476384.1	1008807	g54281	i0	43.9	0.708433734939759	98	55	70.8	0	295	2	53	150	KAL0476384.1 hypothetical protein AKO1_006315 [Acrasis kona]	diamond	294	96.3	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
29333411	29333411	PRJNA1158727_P_NODE_158149_length_243_cov_0.905882_g150687_i0	PRJNA1158727	158149	243	0.905882	2.20129326	Naegleria	5761	Heterolobosea	other_Eukaryota	108	2.65e-25	NR	CAG4717376.1	5763	g150687	i0	59.3	6	81	33	100	0	243	1	731	811	CAG4717376.1 unnamed protein product, partial [Naegleria fowleri]	diamond	1458	108	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
29522808	29522808	PRJNA1158727_P_NODE_69870_length_375_cov_1.324503_g62409_i0	PRJNA1158727	69870	375	1.324503	4.96688625	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	111	5.05e-26	NR	XP_002678194.1	5762	g62409	i0	63	3.096	81	30	64.8	0	243	1	75	155	XP_002678194.1 uncharacterized protein NAEGRDRAFT_66633 [Naegleria gruberi]	diamond	1161	111	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
30735399	30735399	PRJNA1158727_P_NODE_162834_length_241_cov_0.916667_g155372_i0	PRJNA1158727	162834	241	0.916667	2.20916747	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	84	4.63e-17	NR	KAL0491348.1	1008807	g155372	i0	62.5	0.796680497925311	64	24	79.7	0	1	192	131	194	KAL0491348.1 ubiquitin fusion degradation protein [Acrasis kona]	diamond	192	84	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
32126932	32126932	PRJNA1158727_P_NODE_43798_length_566_cov_6.308316_g36375_i0	PRJNA1158727	43798	566	6.308316	35.70506856	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	198	1.14e-61	NR	KAL0482313.1	1008807	g36375	i0	62.2	4.10777385159011	156	58	82.7	1	552	85	5	159	KAL0482313.1 peroxiredoxin [Acrasis kona]	diamond	2325	198	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
32221660	32221660	PRJNA1158727_P_NODE_112378_length_276_cov_1.985222_g104917_i0	PRJNA1158727	112378	276	1.985222	5.47921272	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	108	7.63e-26	NR	XP_044569167.1	5763	g104917	i0	61.7	0.880434782608696	81	31	88	0	31	273	231	311	XP_044569167.1 uncharacterized protein FDP41_000353 [Naegleria fowleri]	diamond	243	108	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);;