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

10 rows where bioproject = "PRJNA799842", 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
2070894	2070894	PRJNA799842_P_NODE_52542_length_392_cov_1.184953_g50969_i0	PRJNA799842	52542	392	1.184953	4.64501576	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	153	5.69e-42	NR	AAD37351.1	5775	g50969	i0	72.6	1.81377551020408	106	27	79.6	1	3	314	108	213	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	711	154	0.993506493506494	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
7173024	7173024	PRJNA799842_P_NODE_35406_length_483_cov_1.675610_g33836_i0	PRJNA799842	35406	483	1.67561	8.0931963	Amoeba proteus	5775	Tubulinea	other_Eukaryota	273	2.09e-88	NR	AAP88974.1	5775	g33836	i0	87.9	0.925465838509317	149	18	92.5	0	481	35	242	390	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	447	273	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
16096940	16096940	PRJNA799842_P_NODE_21633_length_644_cov_1.886165_g20115_i0	PRJNA799842	21633	644	1.886165	12.1469026	Copromyxa laresi	1789826	Tubulinea	other_Eukaryota	542	3.12e-149	NTclustered	gi\|1042160945\|dbj\|LC102279.1\|	1789826	g20115	i0	98.371	3.91614906832298	307	5	48	0	337	643	1	307	Copromyxa sp. MK-2016 gene for elongation factor 2 alpha, partial cds, strain: ZEB1	blastn	2522	542	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa laresi
16097498	16097498	PRJNA799842_P_NODE_4653_length_1403_cov_15.173684_g3955_i0	PRJNA799842	4653	1403	15.173684	212.88678652	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1574	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g3955	i0	87.365	27.4041339985745	1393	150	98	16	11	1381	1389	1	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	38448	1574	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
17374310	17374310	PRJNA799842_P_NODE_89534_length_306_cov_1.592275_g87961_i0	PRJNA799842	89534	306	1.592275	4.8723615	Copromyxa sp. PKD 2011	1215977	Tubulinea	other_Eukaryota	566	8.239999999999998e-157	NTclustered	gi\|399764167\|gb\|JQ271678.1\|	1215977	g87961	i0	100	62.6993464052288	306	0	100	0	1	306	955	650	Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence	blastn	19186	566	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa sp. PKD 2011
21198133	21198133	PRJNA799842_P_NODE_81077_length_320_cov_1.469636_g79504_i0	PRJNA799842	81077	320	1.469636	4.7028352	Amoeba proteus	5775	Tubulinea	other_Eukaryota	168	1.93e-48	NR	AAP88974.1	5775	g79504	i0	76.4	0.99375	106	25	99.4	0	320	3	147	252	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	318	168	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
22472078	22472078	PRJNA799842_P_NODE_46278_length_418_cov_1.237681_g44705_i0	PRJNA799842	46278	418	1.237681	5.17350658	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	662	0	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g44705	i0	95.215	93.822966507177	418	20	100	0	1	418	1132	715	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	39218	662	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
27148400	27148400	PRJNA799842_P_NODE_162482_length_246_cov_0.890173_g160909_i0	PRJNA799842	162482	246	0.890173	2.18982558	Amoeba proteus	5775	Tubulinea	other_Eukaryota	133	2.23e-36	NR	AKN09689.1	5775	g160909	i0	72.8	0.98780487804878	81	22	98.8	0	245	3	152	232	AKN09689.1 Tom20 [Amoeba proteus]	diamond	243	133	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
27464961	27464961	PRJNA799842_P_NODE_133543_length_252_cov_1.290503_g131970_i0	PRJNA799842	133543	252	1.290503	3.25206756	Copromyxa protea	931554	Tubulinea	other_Eukaryota	132	3.54e-36	NR	AKA62191.1	931554	g131970	i0	69.9	0.988095238095238	83	25	98.8	0	3	251	147	229	AKA62191.1 putative rhodoquinone biosynthesis methyltransferase-like protein RQUA [Copromyxa protea]	diamond	249	132	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
30812224	30812224	PRJNA799842_P_NODE_123134_length_264_cov_0.963351_g121561_i0	PRJNA799842	123134	264	0.963351	2.54324664	Amoeba proteus	5775	Tubulinea	other_Eukaryota	125	2.8399999999999997e-31	NR	AKN09691.1	5775	g121561	i0	65.5	0.988636363636364	87	28	98.9	1	263	3	726	810	AKN09691.1 Tom70 [Amoeba proteus]	diamond	261	125	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);;