metadata: contig_metadata: 10 rows where bioproject = "PRJNA533114" and tax

10 rows where bioproject = "PRJNA533114" 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
504908	504908	PRJNA533114_P_NODE_25381_length_451_cov_2.441799_g25131_i0	PRJNA533114	25381	451	2.441799	11.01251349	Copromyxa protea	931554	Tubulinea	other_Eukaryota	507	7.76e-139	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g25131	i0	88.056	21.5410199556541	427	51	95	0	1	427	427	1	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	9715	507	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
1780241	1780241	PRJNA533114_P_NODE_28382_length_428_cov_2.233803_g28130_i0	PRJNA533114	28382	428	2.233803	9.56067684	Nolandella sp. LAK-2	1908693	Tubulinea	other_Eukaryota	182	1.01e-54	NR	AFX73095.1	1260117	g28130	i0	64.1	1.99065420560748	142	51	99.5	0	426	1	82	223	AFX73095.1 elongation factor 2 alpha, partial [Nolandella sp. LAK-2012]	diamond	852	182	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Nolandella	Nolandella sp. LAK-2012
5609264	5609264	PRJNA533114_P_NODE_7445_length_816_cov_3.896366_g7247_i0	PRJNA533114	7445	816	3.896366	31.79434656	Amoeba proteus	5775	Tubulinea	other_Eukaryota	826	0	NTclustered	gi\|844573744\|gb\|KP411223.1\|	5775	g7247	i0	85.272	0.990196078431373	808	112	98	4	11	813	14	819	Amoeba proteus Tom40 mRNA, complete cds	blastn	808	826	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
6883233	6883233	PRJNA533114_P_NODE_83806_length_265_cov_1.630208_g83554_i0	PRJNA533114	83806	265	1.630208	4.3200512	Copromyxa protea	931554	Tubulinea	other_Eukaryota	191	4.92e-44	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g83554	i0	80	1	265	47	99	5	4	265	648	387	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	265	191	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
13258754	13258754	PRJNA533114_P_NODE_33471_length_397_cov_1.154321_g33219_i0	PRJNA533114	33471	397	1.154321	4.58265437	Copromyxa protea	931554	Tubulinea	other_Eukaryota	394	5.48e-105	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g33219	i0	87.246	0.869017632241814	345	44	87	0	1	345	1045	1389	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	345	394	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
18356360	18356360	PRJNA533114_P_NODE_30395_length_414_cov_3.231672_g30143_i0	PRJNA533114	30395	414	3.231672	13.37912208	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	194	3.18e-57	NR	BAN33737.1	931554	g30143	i0	77.2	27.695652173913	123	28	89.1	0	369	1	4	126	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	11466	194	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
26807995	26807995	PRJNA533114_P_NODE_61421_length_304_cov_1.398268_g61169_i0	PRJNA533114	61421	304	1.398268	4.25073472	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	103	3.92e-25	NR	ABD46563.1	5778	g61169	i0	58.7	3.19736842105263	75	31	74	0	225	1	2	76	ABD46563.1 succinyl-diaminopimelate desuccinylase-like protein A, partial [Vermamoeba vermiformis]	diamond	972	103	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
29698174	29698174	PRJNA533114_P_NODE_113450_length_244_cov_0.877193_g113198_i0	PRJNA533114	113450	244	0.877193	2.14035092	Saccamoeba lacustris	704142	Tubulinea	other_Eukaryota	106	7.54e-26	NR	AFX73097.1	704142	g113198	i0	64.2	3.98360655737705	81	25	99.6	1	1	243	124	200	AFX73097.1 elongation factor 2 alpha, partial [Saccamoeba lacustris]	diamond	972	106	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba lacustris
30488380	30488380	PRJNA533114_P_NODE_11993_length_652_cov_1.770294_g11753_i0	PRJNA533114	11993	652	1.770294	11.54231688	Amoeba proteus	5775	Tubulinea	other_Eukaryota	58.9	2.09e-6	NR	AKN09692.1	5775	g11753	i0	27.6	0.800613496932515	174	119	77.8	3	635	129	3	174	AKN09692.1 Tom40 [Amoeba proteus]	diamond	522	58.9	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
32147585	32147585	PRJNA533114_P_NODE_51178_length_330_cov_1.147860_g50926_i0	PRJNA533114	51178	330	1.14786	3.787938	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	77.4	5.89e-14	NR	AAD37351.1	5775	g50926	i0	45.4	1.74545454545455	97	51	88.2	1	314	24	99	193	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	576	77.4	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);;