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

10 rows where analysis = "diamond", bioproject = "PRJNA846486" 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
22908968	22908968	PRJNA846486_P_NODE_84498_length_166_cov_0.888889_g84402_i0	PRJNA846486	84498	166	0.888889	1.47555574	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	98.6	2.86e-22	NR	XP_012748529.1	1410327	g84402	i0	72.7	2.98192771084337	55	15	99.4	0	166	2	372	426	XP_012748529.1 hypothetical protein SAMD00019534_116660, partial [Acytostelium subglobosum LB1]	diamond	495	98.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
26991242	26991242	PRJNA846486_P_NODE_19682_length_288_cov_1.305439_g19586_i0	PRJNA846486	19682	288	1.305439	3.75966432	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	73.6	9.13e-13	NR	XP_003290724.1	5786	g19586	i0	49.5	0.989583333333333	95	48	99	0	287	3	528	622	XP_003290724.1 uncharacterized protein DICPUDRAFT_155256 [Dictyostelium purpureum]	diamond	285	73.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
28034058	28034058	PRJNA846486_P_NODE_83625_length_166_cov_0.888889_g83529_i0	PRJNA846486	83625	166	0.888889	1.47555574	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	58.9	2.54e-8	NR	KYQ88531.1	361077	g83529	i0	46.3	1.89759036144578	54	28	97.6	1	1	162	353	405	KYQ88531.1 glutathione S-transferase domain-containing protein [Tieghemostelium lacteum]	diamond	315	58.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
28981328	28981328	PRJNA846486_P_NODE_54388_length_192_cov_1.090909_g54292_i0	PRJNA846486	54388	192	1.090909	2.09454528	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	59.3	1.49e-8	NR	XP_004341506.1	1257118	g54292	i0	42.9	0.984375	63	36	98.4	0	2	190	67	129	XP_004341506.1 prolyl 4hydroxylase, alpha subunit [Acanthamoeba castellanii str. Neff]	diamond	189	59.3	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29139283	29139283	PRJNA846486_P_NODE_60629_length_184_cov_1.466667_g60533_i0	PRJNA846486	60629	184	1.466667	2.69866728	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	46.2	0.00102	NR	XP_012753936.1	1410327	g60533	i0	55.8	3.66847826086957	43	19	70.1	0	133	5	267	309	XP_012753936.1 hypothetical protein SAMD00019534_058840 [Acytostelium subglobosum LB1]	diamond	675	46.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
29801986	29801986	PRJNA846486_P_NODE_94851_length_160_cov_3.414414_g94755_i0	PRJNA846486	94851	160	3.414414	5.4630624	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	64.7	1.88e-10	NR	KAF2075829.1	133409	g94755	i0	64.4	4.18125	45	16	84.4	0	143	9	204	248	KAF2075829.1 hypothetical protein CYY_002863 [Polysphondylium violaceum]	diamond	669	64.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
29896936	29896936	PRJNA846486_P_NODE_82551_length_166_cov_1.777778_g82455_i0	PRJNA846486	82551	166	1.777778	2.95111148	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	59.3	1.2e-8	NR	XP_020433716.1	670386	g82455	i0	46.3	1.89759036144578	54	29	97.6	0	165	4	122	175	XP_020433716.1 component of the counting factor complex [Heterostelium album PN500]	diamond	315	59.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
30654948	30654948	PRJNA846486_P_NODE_24013_length_265_cov_0.962963_g23917_i0	PRJNA846486	24013	265	0.962963	2.55185195	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	65.1	6.9e-10	NR	KAF2073775.1	133409	g23917	i0	50	2.77358490566038	82	39	92.8	2	261	16	1301	1380	KAF2073775.1 hypothetical protein CYY_004909 [Polysphondylium violaceum]	diamond	735	65.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
32646654	32646654	PRJNA846486_P_NODE_48080_length_201_cov_1.250000_g47984_i0	PRJNA846486	48080	201	1.25	2.5125	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	44.7	0.00441	NR	KAH3766834.1	1580589	g47984	i0	42.3	0.776119402985075	52	29	77.6	1	21	176	424	474	KAH3766834.1 hypothetical protein Pelo_1297 [Pelomyxa schiedti]	diamond	156	44.7	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
32844253	32844253	PRJNA846486_P_NODE_89020_length_164_cov_0.904348_g88924_i0	PRJNA846486	89020	164	0.904348	1.48313072	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	85.9	2.91e-18	NR	ABD46596.1	5778	g88924	i0	72.2	1.97560975609756	54	15	98.8	0	164	3	34	87	ABD46596.1 unknown, partial [Vermamoeba vermiformis]	diamond	324	85.9	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis

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