metadata: contig_metadata: 6 rows where bioproject = "PRJNA816047", tax_clade = "Amoebozoa" and tax

6 rows where bioproject = "PRJNA816047", 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
25872712	25872712	PRJNA816047d_S_NODE_100491_length_250_cov_1.203046_g98656_i0	PRJNA816047	100491	250	1.203046	3.007615	Copromyxa protea	931554	Tubulinea	other_Eukaryota	274	4.44e-69	NTclustered	gi\|1042160949\|dbj\|LC102281.1\|	931554	g98656	i0	86.454	1.784	251	32	100	2	1	250	453	702	Copromyxa protea gene for elongation factor 2 alpha, partial cds, strain: LUM	blastn	446	274	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
25873063	25873063	PRJNA816047d_S_NODE_11411_length_718_cov_5.147368_g9916_i0	PRJNA816047	11411	718	5.147368	36.95810224	Copromyxa protea	931554	Tubulinea	other_Eukaryota	749	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g9916	i0	91.155	1.51810584958217	554	45	77	4	153	704	1389	838	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	1090	749	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
25875306	25875306	PRJNA816047d_S_NODE_27971_length_403_cov_3.114286_g26140_i0	PRJNA816047	27971	403	3.114286	12.55057258	Amoeba proteus	5775	Tubulinea	other_Eukaryota	209	2.17e-49	NTclustered	gi\|2654140\|gb\|AF034789.1\|AF034789	5775	g26140	i0	84.434	65.4168734491315	212	33	74	0	1	212	232	443	Amoeba proteus polyubiquitin mRNA, complete cds	blastn	26363	209	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
26145773	26145773	PRJNA816047d_S_NODE_122853_length_239_cov_2.677419_g121018_i0	PRJNA816047	122853	239	2.677419	6.39903141	Copromyxa protea	931554	Tubulinea	other_Eukaryota	320	5.33e-83	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g121018	i0	90.795	20.0292887029289	239	22	100	0	1	239	293	55	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	4787	320	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
26147741	26147741	PRJNA816047d_S_NODE_27405_length_408_cov_0.954930_g25575_i0	PRJNA816047	27405	408	0.95493	3.8961144	Amoeba proteus	5775	Tubulinea	other_Eukaryota	242	9.29e-77	NR	AAP88974.1	5775	g25575	i0	88.8	0.985294117647059	134	15	98.5	0	407	6	234	367	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	402	242	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
26281197	26281197	PRJNA816047d_S_NODE_100310_length_250_cov_1.527919_g98475_i0	PRJNA816047	100310	250	1.527919	3.8197975	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	274	4.44e-69	NTclustered	gi\|1042160937\|dbj\|LC102275.1\|	239731	g98475	i0	95.858	58.98	169	7	68	0	68	236	787	619	Hartmannella cantabrigiensis gene for actin, partial cds, strain: ALC3_cl1	blastn	14745	274	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis

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