metadata: contig_metadata: 10 rows where bioproject = "PRJEB7366", tax_clade = "Amoebozoa" and tax

10 rows where bioproject = "PRJEB7366", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"

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_order	tax_family	tax_genus	tax_species
3961395	3961395	PRJEB7366_P_NODE_8404_length_293_cov_2.472868_g7970_i0	PRJEB7366	8404	293	2.472868	7.24550324	Mayorella sp. JJP-2003	242541	Discosea	other_Eukaryota	351	2.39e-92	NTclustered	gi\|33946346\|gb\|AY294152.1\|	242541	g7970	i0	93.966	89.778156996587	232	14	79	0	62	293	1134	903	Mayorella sp. JJP-2003 actin mRNA, partial cds	blastn	26305	351	1	Eukaryota	Amoebozoa	Discosea	Longamoebia		Mayorella	Mayorella sp. JJP-2003
19260868	19260868	PRJEB7366_P_NODE_7276_length_322_cov_1.393728_g6842_i0	PRJEB7366	7276	322	1.393728	4.48780416	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	56.5	0.002	NTclustered	gi\|470523679\|ref\|XM_004355001.1\|	1257118	g6842	i0	94.444	0.211180124223602	36	2	11	0	206	241	4626	4591	Acanthamoeba castellanii str. Neff Tyrosine kinase, putative (ACA1_006130), partial mRNA	blastn	68	56.5	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28202526	28202526	PRJEB7366_P_NODE_15906_length_195_cov_1.500000_g15472_i0	PRJEB7366	15906	195	1.5	2.925	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	62	2.83e-9	NR	XP_004336540.1	1257118	g15472	i0	46.9	3.89230769230769	64	29	98.5	1	2	193	227	285	XP_004336540.1 sterol 24c-methyltransferase [Acanthamoeba castellanii str. Neff]	diamond	759	62	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28708086	28708086	PRJEB7366_P_NODE_19867_length_171_cov_1.176471_g19433_i0	PRJEB7366	19867	171	1.176471	2.01176541	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	66.2	6.71e-11	NR	XP_004335206.1	1257118	g19433	i0	52.6	3	57	26	100	1	171	1	264	319	XP_004335206.1 NAD-dependent epimerase/dehydratase family protein [Acanthamoeba castellanii str. Neff]	diamond	513	66.2	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28960821	28960821	PRJEB7366_P_NODE_9048_length_280_cov_2.469388_g8614_i0	PRJEB7366	9048	280	2.469388	6.9142864	Acanthamoeba healyi	65661	Discosea	other_Eukaryota	120	1.19e-30	NR	AAL67857.1	65661	g8614	i0	61.3	2.98928571428571	93	36	99.6	0	280	2	180	272	AAL67857.1 cysteine proteinase [Acanthamoeba healyi]	diamond	837	120	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba healyi
28992404	28992404	PRJEB7366_P_NODE_15468_length_198_cov_2.153374_g15034_i0	PRJEB7366	15468	198	2.153374	4.26368052	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	73.9	8.26e-14	NR	XP_004352851.1	1257118	g15034	i0	50.7	1.01515151515152	67	31	98.5	1	2	196	25	91	XP_004352851.1 uncharacterized protein ACA1_069070 [Acanthamoeba castellanii str. Neff]	diamond	201	73.9	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29465315	29465315	PRJEB7366_P_NODE_11150_length_245_cov_1.142857_g10716_i0	PRJEB7366	11150	245	1.142857	2.79999965	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	74.7	2.04e-13	NR	XP_004339374.1	1257118	g10716	i0	46.3	0.979591836734694	80	37	94.3	3	13	243	120	196	XP_004339374.1 Ser/Thr phosphatase family superfamily protein [Acanthamoeba castellanii str. Neff]	diamond	240	74.7	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30469536	30469536	PRJEB7366_P_NODE_14953_length_203_cov_1.190476_g14519_i0	PRJEB7366	14953	203	1.190476	2.41666628	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	94.7	1.08e-20	NR	XP_004367478.1	1257118	g14519	i0	71.6	2.97044334975369	67	19	99	0	1	201	502	568	XP_004367478.1 heat shock protein 90 alpha, putative [Acanthamoeba castellanii str. Neff]	diamond	603	94.7	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31772459	31772459	PRJEB7366_P_NODE_9317_length_275_cov_3.870833_g8883_i0	PRJEB7366	9317	275	3.870833	10.64479075	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	88.6	3.5e-20	NR	XP_004349605.1	1257118	g8883	i0	45.7	1.00363636363636	92	49	99.3	1	273	1	27	118	XP_004349605.1 uncharacterized protein ACA1_142080 [Acanthamoeba castellanii str. Neff]	diamond	276	88.6	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31867259	31867259	PRJEB7366_P_NODE_6897_length_333_cov_2.013423_g6463_i0	PRJEB7366	6897	333	2.013423	6.70469859	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	115	1.34e-30	NR	7SOG_A	5755	g6463	i0	53.7	0.972972972972973	108	48	95.5	2	16	333	4	111	7SOG_A Chain A, Actophorin [Acanthamoeba castellanii]	diamond	324	115	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);;