metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB1404" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB1404" and tax_superkingdom = "Eukaryota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
22973067	22973067	PRJEB1404_P_NODE_919_length_332_cov_2.913621_g894_i0	PRJEB1404	919	332	2.913621	9.67322172	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	138	8.32e-38	NR	NP_066520.1	5762	g894	i0	95.7	0.632530120481928	70	3	63.3	0	330	121	196	265	NP_066520.1 ribosomal protein L2 [Naegleria gruberi]	diamond	210	138	1	Eukaryota	Discoba		Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
27412535	27412535	PRJEB1404_P_NODE_4703_length_157_cov_2.492063_g4677_i0	PRJEB1404	4703	157	2.492063	3.91253891	Macrosiphum euphorbiae	13131	Arthropoda	Arthropoda	41.2	0.035	NR	CAI6376859.1	13131	g4677	i0	40.4	0.993630573248408	52	25	87.9	1	157	20	136	187	CAI6376859.1 unnamed protein product [Macrosiphum euphorbiae]	diamond	156	41.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Macrosiphum	Macrosiphum euphorbiae
28043790	28043790	PRJEB1404_S_NODE_2145_length_218_cov_1.748634_g2125_i0	PRJEB1404	2145	218	1.748634	3.81202212	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	79.7	4.84e-16	NR	KAF0724285.1	100861	g2125	i0	70.7	0.798165137614679	58	17	79.8	0	45	218	14	71	KAF0724285.1 hypothetical protein Ae201684_016950 [Aphanomyces euteiches]	diamond	174	79.7	1	Eukaryota	Sar		Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
28170088	28170088	PRJEB1404_S_NODE_2446_length_206_cov_0.935673_g2426_i0	PRJEB1404	2446	206	0.935673	1.92748638	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	98.6	5e-22	NR	XP_012653068.1	312017	g2426	i0	90.4	0.757281553398058	52	5	75.7	0	195	40	431	482	XP_012653068.1 AAA family ATPase [Tetrahymena thermophila SB210]	diamond	156	98.6	1	Eukaryota	Sar		Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
28485845	28485845	PRJEB1404_P_NODE_3867_length_179_cov_2.554054_g3841_i0	PRJEB1404	3867	179	2.554054	4.57175666	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	106	7.35e-28	NR	NP_066524.1	5762	g3841	i0	87.7	1.08938547486034	65	0	95.5	1	172	2	1	65	NP_066524.1 ribosomal protein L14 [Naegleria gruberi]	diamond	195	106	1	Eukaryota	Discoba		Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
28991323	28991323	PRJEB1404_P_NODE_3668_length_186_cov_1.322581_g3642_i0	PRJEB1404	3668	186	1.322581	2.46000066	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	54.3	1.16e-7	NR	XP_044568952.1	5763	g3642	i0	55.3	0.758064516129032	47	20	74.2	1	184	47	46	92	XP_044568952.1 uncharacterized protein FDP41_007416 [Naegleria fowleri]	diamond	141	54.3	1	Eukaryota	Discoba		Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
29117488	29117488	PRJEB1404_S_NODE_4749_length_150_cov_3.478261_g4729_i0	PRJEB1404	4749	150	3.478261	5.2173915	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	41.6	0.0265	NR	XP_001027976.1	312017	g4729	i0	90.5	0.42	21	2	42	0	2	64	371	391	XP_001027976.1 60S ribosomal protein L3, putative [Tetrahymena thermophila SB210]	diamond	63	41.6	1	Eukaryota	Sar		Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29338389	29338389	PRJEB1404_S_NODE_3669_length_169_cov_1.738806_g3649_i0	PRJEB1404	3669	169	1.738806	2.93858214	Aphanomyces cochlioides	112091	SAR_Eukaryotes	SAR_Eukaryotes	85.5	3.11e-18	NR	KAG9410527.1	112091	g3649	i0	93.2	1.56213017751479	44	3	78.1	0	2	133	247	290	KAG9410527.1 hypothetical protein AC1031_018567 [Aphanomyces cochlioides]	diamond	264	85.5	1	Eukaryota	Sar		Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides
29496169	29496169	PRJEB1404_S_NODE_3710_length_168_cov_1.804511_g3690_i0	PRJEB1404	3710	168	1.804511	3.03157848	Aphanomyces cochlioides	112091	SAR_Eukaryotes	SAR_Eukaryotes	58.2	1.36e-8	NR	KAG9399323.1	112091	g3690	i0	69.6	0.821428571428571	46	12	78.6	1	168	37	125	170	KAG9399323.1 hypothetical protein AC1031_011670 [Aphanomyces cochlioides]	diamond	138	58.2	1	Eukaryota	Sar		Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides
32751348	32751348	PRJEB1404_S_NODE_3520_length_172_cov_1.131387_g3500_i0	PRJEB1404	3520	172	1.131387	1.94598564	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.00354	NR	KAF0740007.1	100861	g3500	i0	76	0.872093023255814	25	5	43.6	1	1	75	73	96	KAF0740007.1 hypothetical protein Ae201684_004452 [Aphanomyces euteiches]	diamond	150	42.7	1	Eukaryota	Sar		Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches

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