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

9 rows where analysis = "blastn", bioproject = "PRJNA432257" and tax_phylum = "Evosea"

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
430070	430070	PRJNA432257_S_NODE_70881_length_202_cov_65.387879_g70500_i0	PRJNA432257	70881	202	65.387879	132.08351558	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	54.7	0.005	NTclustered	gi\|66824398\|ref\|XM_640462.1\|	352472	g70500	i0	100	0.143564356435644	29	0	14	0	77	105	2113	2085	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0271610) mRNA, complete cds	blastn	29	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
1705090	1705090	PRJNA432257_S_NODE_86482_length_187_cov_2.153333_g86101_i0	PRJNA432257	86482	187	2.153333	4.02673271	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	52.8	0.016	NTclustered	gi\|470252377\|ref\|XM_004359229.1\|	261658	g86101	i0	100	0.149732620320856	28	0	15	0	84	111	251	278	Cavenderia fasciculata uncharacterized protein (DFA_01320), partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
10633335	10633335	PRJNA432257_S_NODE_27089_length_289_cov_97.015873_g26708_i0	PRJNA432257	27089	289	97.015873	280.37587297	Protostelium mycophagum	472931	Evosea	other_Eukaryota	385	2.32e-102	NTclustered	gi\|290886111\|gb\|GU477647.1\|	472931	g26708	i0	99.526	40.916955017301	211	1	73	0	79	289	151	361	Protostelium mycophagum strain ATCC PRA-128 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence	blastn	11825	385	1	Eukaryota	Amoebozoa	Evosea	Variosea	Protosteliida	Protosteliaceae	Protostelium	Protostelium mycophagum
11909156	11909156	PRJNA432257_S_NODE_97770_length_178_cov_2.212766_g97389_i0	PRJNA432257	97770	178	2.212766	3.93872348	Mastigamoeba balamuthi	108607	Evosea	other_Eukaryota	134	5.23e-27	NTclustered	gi\|13569594\|gb\|AF348478.1\|AF348478	108607	g97389	i0	90.196	49.5786516853933	102	10	57	0	77	178	1517	1416	Mastigamoeba balamuthi enolase (enol) gene, complete cds	blastn	8825	134	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Mastigamoebidae	Mastigamoeba	Mastigamoeba balamuthi
14458744	14458744	PRJNA432257_S_NODE_59512_length_216_cov_155.173184_g59131_i0	PRJNA432257	59512	216	155.173184	335.17407744	Entamoeba nuttalli	412467	Evosea	other_Eukaryota	56.5	0.001	NTclustered	gi\|672809539\|ref\|XM_008861586.1\|	1076696	g59131	i0	100	0.138888888888889	30	0	14	0	98	127	93	64	Entamoeba nuttalli P19 hypothetical protein partial mRNA	blastn	30	56.5	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba nuttalli
17007315	17007315	PRJNA432257_S_NODE_71114_length_202_cov_5.575758_g70733_i0	PRJNA432257	71114	202	5.575758	11.26303116	Protostelium mycophagum	472931	Evosea	other_Eukaryota	374	3.3e-99	NTclustered	gi\|262262917\|gb\|FJ766460.1\|	472931	g70733	i0	100	31.5594059405941	202	0	100	0	1	202	1464	1263	Protostelium mycophagum strain PRA-128 small subunit ribosomal RNA gene, partial sequence	blastn	6375	374	1	Eukaryota	Amoebozoa	Evosea	Variosea	Protosteliida	Protosteliaceae	Protostelium	Protostelium mycophagum
17666252	17666252	PRJNA432257_S_NODE_22554_length_309_cov_5.426471_g22173_i0	PRJNA432257	22554	309	5.426471	16.76779539	Dictyostelium	5782	Evosea	other_Eukaryota	56.5	0.002	NTclustered	gi\|4731866\|gb\|AF098916.1\|AF098916	44689	g22173	i0	100	10.3462783171521	30	0	10	0	225	254	135	106	Dictyostelium discoideum sterol glucosyltransferase (ugt52) mRNA, complete cds	blastn	3197	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
18940298	18940298	PRJNA432257_S_NODE_58415_length_218_cov_2.607735_g58034_i0	PRJNA432257	58415	218	2.607735	5.6848623	Eumycetozoa	142796	Evosea	other_Eukaryota	54.7	0.005	NTclustered	gi\|66801708\|ref\|XM_629777.1\|	352472	g58034	i0	96.875	0.678899082568807	32	1	15	0	127	158	2397	2428	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0292032) mRNA, complete cds	blastn	148	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
20830974	20830974	PRJNA432257_S_NODE_18217_length_332_cov_42.532203_g17836_i0	PRJNA432257	18217	332	42.532203	141.20691396	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	56.5	0.002	NTclustered	gi\|330798749\|ref\|XM_003287365.1\|	5786	g17836	i0	97.059	0.439759036144578	34	0	10	1	57	89	879	912	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_78270), partial mRNA	blastn	146	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum

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