metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA849646" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA849646" 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
14866266	14866266	PRJNA849646_P_NODE_32252_length_248_cov_0.880000_g32134_i0	PRJNA849646	32252	248	0.88	2.1824	Evosea	2605435	Evosea	other_Eukaryota	134	3.89e-36	NR	KYQ96759.1	361077	g32134	i0	74.4	19.8387096774194	82	21	99.2	0	248	3	186	267	KYQ96759.1 delta-aminolevulinate dehydratase [Tieghemostelium lacteum]	diamond	4920	134	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
29391839	29391839	PRJNA849646_P_NODE_35609_length_244_cov_1.736842_g35491_i0	PRJNA849646	35609	244	1.736842	4.23789448	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	144	1.47e-40	NR	XP_004335792.1	1257118	g35491	i0	94.6	0.909836065573771	74	4	91	0	244	23	46	119	XP_004335792.1 CBS domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	222	144	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30474092	30474092	PRJNA849646_P_NODE_29333_length_251_cov_0.865169_g29215_i0	PRJNA849646	29333	251	0.865169	2.17157419	Acytosteliales	2058181	Evosea	other_Eukaryota	55.8	1.02e-6	NR	XP_004358157.1	261658	g29215	i0	38.6	1.9601593625498	83	46	93.2	2	18	251	178	260	XP_004358157.1 neurofibromin [Cavenderia fasciculata]	diamond	492	55.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
31350576	31350576	PRJNA849646_P_NODE_27916_length_253_cov_2.111111_g27798_i0	PRJNA849646	27916	253	2.111111	5.34111083	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	59.3	6.24e-8	NR	XP_004337728.1	1257118	g27798	i0	41.4	0.687747035573123	58	34	68.8	0	2	175	236	293	XP_004337728.1 uncharacterized protein ACA1_378750 [Acanthamoeba castellanii str. Neff]	diamond	174	59.3	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32078005	32078005	PRJNA849646_P_NODE_25978_length_257_cov_1.673913_g25860_i0	PRJNA849646	25978	257	1.673913	4.30195641	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	61.2	1.36e-8	NR	PRP80583.1	1890364	g25860	i0	33.7	1.07392996108949	92	52	96.9	2	257	9	102	193	PRP80583.1 hypothetical protein PROFUN_12345 [Planoprotostelium fungivorum]	diamond	276	61.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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