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

10 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax_clade = "Amoebozoa"

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
6819663	6819663	PRJNA454503_P_NODE_11006_length_339_cov_1.169065_g10677_i0	PRJNA454503	11006	339	1.169065	3.96313035	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	122	8.05e-33	NR	KAH3766405.1	1580589	g10677	i0	73.8	0.707964601769911	80	21	70.8	0	98	337	37	116	KAH3766405.1 histone H2B [Pelomyxa schiedti]	diamond	240	122	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
14471610	14471610	PRJNA454503_P_NODE_85812_length_202_cov_0.921986_g85483_i0	PRJNA454503	85812	202	0.921986	1.86241172	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	134	7.259999999999999e-38	NR	XP_003284688.1	5786	g85483	i0	98.5	13.9306930693069	67	1	99.5	0	202	2	2	68	XP_003284688.1 uncharacterized protein DICPUDRAFT_91367 [Dictyostelium purpureum]	diamond	2814	134	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
17019832	17019832	PRJNA454503_P_NODE_44094_length_222_cov_1.540373_g43765_i0	PRJNA454503	44094	222	1.540373	3.41962806	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	80.9	8.89e-16	NR	XP_004358356.1	261658	g43765	i0	68	2.08108108108108	50	16	67.6	0	221	72	48	97	XP_004358356.1 LIM-type zinc finger-containing protein [Cavenderia fasciculata]	diamond	462	80.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
27012801	27012801	PRJNA454503_P_NODE_41722_length_225_cov_1.189024_g41393_i0	PRJNA454503	41722	225	1.189024	2.675304	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	87.8	3.1e-18	NR	KAH3764858.1	1580589	g41393	i0	51.4	1.97333333333333	74	35	97.3	1	221	3	286	359	KAH3764858.1 penicillin-binding protein 4* [Pelomyxa schiedti]	diamond	444	87.8	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
27771303	27771303	PRJNA454503_P_NODE_71784_length_206_cov_0.896552_g71455_i0	PRJNA454503	71784	206	0.896552	1.84689712	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	100	9.499999999999999e-24	NR	XP_004357676.1	261658	g71455	i0	57.4	1.98058252427184	68	29	99	0	204	1	166	233	XP_004357676.1 ankyrin repeat-containing protein [Cavenderia fasciculata]	diamond	408	100	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
28212873	28212873	PRJNA454503_P_NODE_27286_length_243_cov_1.802198_g26957_i0	PRJNA454503	27286	243	1.802198	4.37934114	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	50.1	1.01e-5	NR	XP_004333525.1	1257118	g26957	i0	65.9	0.506172839506173	41	14	50.6	0	234	112	2	42	XP_004333525.1 Actobindin, putative [Acanthamoeba castellanii str. Neff]	diamond	123	50.1	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29602060	29602060	PRJNA454503_P_NODE_52970_length_212_cov_1.721854_g52641_i0	PRJNA454503	52970	212	1.721854	3.65033048	Vannella simplex	197532	Discosea	other_Eukaryota	65.1	7.51e-12	NR	AUO29176.1	197532	g52641	i0	54.9	0.721698113207547	51	23	72.2	0	158	6	1	51	AUO29176.1 H(+)-transporting ATPase subunit 9 [Vannella simplex]	diamond	153	65.1	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella simplex
29997718	29997718	PRJNA454503_P_NODE_52611_length_213_cov_1.282895_g52282_i0	PRJNA454503	52611	213	1.282895	2.73256635	Eumycetozoa	142796	Evosea	other_Eukaryota	115	1.47e-29	NR	XP_003287614.1	5786	g52282	i0	85.9	5	71	9	100	1	213	1	143	212	XP_003287614.1 calcium-regulated actin-bundling protein [Dictyostelium purpureum]	diamond	1065	116	0.991379310344828	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
31530053	31530053	PRJNA454503_P_NODE_81056_length_203_cov_0.915493_g80727_i0	PRJNA454503	81056	203	0.915493	1.85845079	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	63.2	8.36e-10	NR	PRP76942.1	1890364	g80727	i0	54	0.931034482758621	63	27	90.1	1	201	19	162	224	PRP76942.1 hypothetical protein PROFUN_06220 [Planoprotostelium fungivorum]	diamond	189	63.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
32794037	32794037	PRJNA454503_P_NODE_27200_length_243_cov_2.126374_g26871_i0	PRJNA454503	27200	243	2.126374	5.16708882	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	45.4	9.76e-4	NR	XP_004338297.1	1257118	g26871	i0	46.2	0.641975308641975	52	27	63	1	28	180	4	55	XP_004338297.1 uncharacterized protein ACA1_202670 [Acanthamoeba castellanii str. Neff]	diamond	156	45.4	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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