metadata: contig_metadata: 11 rows where bioproject = "PRJNA615351", tax_clade = "Amoebozoa" and tax

11 rows where bioproject = "PRJNA615351", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"

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
4423566	4423566	PRJNA615351_P_NODE_95344_length_338_cov_4.267327_g81252_i0	PRJNA615351	95344	338	4.267327	14.42356526	Copromyxa sp. PKD 2011	1215977	Tubulinea	other_Eukaryota	623	5.389999999999999e-174	NTclustered	gi\|399764167\|gb\|JQ271678.1\|	1215977	g81252	i0	100	80.6538461538462	337	0	99	0	2	338	1718	1382	Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence	blastn	27261	623	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa sp. PKD 2011
6974122	6974122	PRJNA615351_P_NODE_20366_length_1449_cov_19.948373_g14792_i0	PRJNA615351	20366	1449	19.948373	289.05192477	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1563	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g14792	i0	87.222	25.6894409937888	1393	152	95	16	28	1398	1	1389	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	37224	1563	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
15898631	15898631	PRJNA615351_P_NODE_26873_length_1223_cov_4.845960_g19562_i0	PRJNA615351	26873	1223	4.84596	59.2660908	Amoeba proteus	5775	Tubulinea	other_Eukaryota	688	7.32e-248	NR	AAP88974.1	5775	g19562	i0	84.4	0.956663941128373	390	61	95.7	0	16	1185	1	390	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	1170	688	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
16452761	16452761	PRJNA615351_P_NODE_166453_length_169_cov_1.492537_g152353_i0	PRJNA615351	166453	169	1.492537	2.52238753	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99	1.79e-16	NTclustered	gi\|61655688\|gb\|AY848964.1\|	318526	g152353	i0	87.209	49.7573964497041	86	11	51	0	51	136	1958	2043	Heleopera sphagni small subunit ribosomal RNA gene, partial sequence	blastn	8409	100	0.99	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Heleoperidae	Heleopera	Heleopera sphagni
26890760	26890760	PRJNA615351_P_NODE_132541_length_220_cov_3.870270_g118441_i0	PRJNA615351	132541	220	3.87027	8.514594	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	59.3	2.36e-8	NR	AAY21191.1	5778	g118441	i0	43.8	1.74545454545455	64	36	87.3	0	218	27	179	242	AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis]	diamond	384	59.3	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
27901444	27901444	PRJNA615351_P_NODE_145905_length_196_cov_1.739130_g131805_i0	PRJNA615351	145905	196	1.73913	3.4086948	Amoeba proteus	5775	Tubulinea	other_Eukaryota	118	5.44e-29	NR	AAD33718.1	5775	g131805	i0	84.4	0.979591836734694	64	10	98	0	3	194	82	145	AAD33718.1 myosin heavy chain [Amoeba proteus]	diamond	192	118	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
30111898	30111898	PRJNA615351_P_NODE_164032_length_172_cov_1.167883_g149932_i0	PRJNA615351	164032	172	1.167883	2.00875876	Amoeba proteus	5775	Tubulinea	other_Eukaryota	55.5	4.74e-7	NR	AAD33718.1	5775	g149932	i0	62.8	0.75	43	16	75	0	172	44	886	928	AAD33718.1 myosin heavy chain [Amoeba proteus]	diamond	129	55.5	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
30143184	30143184	PRJNA615351_P_NODE_137792_length_210_cov_1.942857_g123692_i0	PRJNA615351	137792	210	1.942857	4.0799997	Amoeba proteus	5775	Tubulinea	other_Eukaryota	114	2.94e-30	NR	AAW58116.1	5775	g123692	i0	76.8	0.985714285714286	69	16	98.6	0	3	209	74	142	AAW58116.1 peroxiredoxin, partial [Amoeba proteus]	diamond	207	114	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
30617384	30617384	PRJNA615351_P_NODE_138813_length_208_cov_2.450867_g124713_i0	PRJNA615351	138813	208	2.450867	5.09780336	Amoeba proteus	5775	Tubulinea	other_Eukaryota	84.3	5.12e-17	NR	AAD33718.1	5775	g124713	i0	69.1	0.980769230769231	68	20	96.6	1	203	3	373	440	AAD33718.1 myosin heavy chain [Amoeba proteus]	diamond	204	84.3	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
31122679	31122679	PRJNA615351_P_NODE_166575_length_169_cov_1.455224_g152475_i0	PRJNA615351	166575	169	1.455224	2.45932856	Chaos carolinense	160823	Tubulinea	other_Eukaryota	93.2	2.54e-22	NR	AFX73058.1	160823	g152475	i0	78.6	0.994082840236686	56	12	99.4	0	168	1	46	101	AFX73058.1 14-3-3 protein, partial [Chaos carolinense]	diamond	168	93.2	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Chaos	Chaos carolinense
31787007	31787007	PRJNA615351_P_NODE_184897_length_152_cov_1.316239_g170797_i0	PRJNA615351	184897	152	1.316239	2.00068328	Amoeba proteus	5775	Tubulinea	other_Eukaryota	59.3	1.52e-8	NR	AAD33718.1	5775	g170797	i0	60	0.888157894736842	45	18	88.8	0	152	18	588	632	AAD33718.1 myosin heavy chain [Amoeba proteus]	diamond	135	59.3	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus

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