metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax_clade = "Amoebozoa"

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
25734158	25734158	PRJNA816047b_S_NODE_24114_length_332_cov_6.563707_g21802_i0	PRJNA816047	24114	332	6.563707	21.79150724	Platyamoeba sp. strain CAZ7/I	325065	Discosea	other_Eukaryota	586	6.929999999999998e-163	NTclustered	gi\|62865947\|gb\|AY929922.1\|	325065	g21802	i0	99.381	96.1325301204819	323	2	97	0	10	332	13	335	Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence	blastn	31916	586	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Platyamoeba	Platyamoeba sp. strain CAZ7/I
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
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
26286410	26286410	PRJNA816047d_S_NODE_74774_length_267_cov_2.415888_g72939_i0	PRJNA816047	74774	267	2.415888	6.45042096	Acytostelium leptosomum	133408	Evosea	other_Eukaryota	363	9.939999999999997e-96	NTclustered	gi\|1057487862\|gb\|KX539491.1\|	133408	g72939	i0	95.964	61.8801498127341	223	9	84	0	1	223	2784	2562	Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds	blastn	16522	363	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium leptosomum
26411940	26411940	PRJNA816047a_S_NODE_71071_length_252_cov_2.849162_g68411_i0	PRJNA816047	71071	252	2.849162	7.17988824	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	56.5	0.002	NTclustered	gi\|470260152\|ref\|XM_004359975.1\|	261658	g68411	i0	100	1.04365079365079	30	0	12	0	119	148	5060	5031	Cavenderia fasciculata armadillo-like helical domain-containing protein (DFA_04299), partial mRNA	blastn	263	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
26556889	26556889	PRJNA816047d_S_NODE_47832_length_318_cov_1.249057_g45997_i0	PRJNA816047	47832	318	1.249057	3.97200126	Arcyria fasciculata	3129285	Evosea	other_Eukaryota	370	7.24e-98	NTclustered	gi\|2772191641\|gb\|PQ014998.1\|	3129285	g45997	i0	89.226	96.314465408805	297	30	93	2	18	313	709	414	Arcyria fasciculata voucher TUF132142 translation elongation factor 1-alpha (EF1a) gene, partial cds	blastn	30628	370	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Arcyria	Arcyria fasciculata

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