metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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
1419865	1419865	PRJNA1000943_P_NODE_3222_length_431_cov_1.865922_g3085_i0	PRJNA1000943	3222	431	1.865922	8.04212382	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	508	2.05e-139	NTclustered	gi\|66821326\|ref\|XM_639065.1\|	352472	g3085	i0	87.935	98.07656612529	431	52	100	0	1	431	1006	576	Dictyostelium discoideum AX4 hypothetical protein (act13) mRNA, complete cds	blastn	42271	508	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
6523481	6523481	PRJNA1000943_P_NODE_2726_length_465_cov_1.872449_g2589_i0	PRJNA1000943	2726	465	1.872449	8.70688785	Entamoeba histolytica	5759	Evosea	other_Eukaryota	287	1.14e-72	NTclustered	gi\|183234457\|ref\|XM_645739.2\|	294381	g2589	i0	79.481	30.8322580645161	424	71	89	14	46	461	3	418	Entamoeba histolytica HM-1:IMSS Rho family GTPase (EHI_197840), mRNA	blastn	14337	287	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
6523524	6523524	PRJNA1000943_P_NODE_6566_length_317_cov_1.762295_g6428_i0	PRJNA1000943	6566	317	1.762295	5.58647515	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	268	2.7099999999999998e-67	NTclustered	gi\|330842214\|ref\|XM_003293030.1\|	5786	g6428	i0	86.056	48.3186119873817	251	33	79	2	53	302	395	146	Dictyostelium purpureum uncharacterized protein (rac1A), mRNA	blastn	15317	268	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
16722000	16722000	PRJNA1000943_P_NODE_1714_length_579_cov_3.233202_g1578_i0	PRJNA1000943	1714	579	3.233202	18.72023958	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	320	1.4199999999999995e-82	NTclustered	gi\|831754130\|ref\|XM_012892568.1\|	1410327	g1578	i0	81.89	49.1778929188256	381	67	66	2	135	514	62	441	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	28474	320	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
17577128	17577128	PRJNA1000943_P_NODE_7634_length_298_cov_1.315556_g7496_i0	PRJNA1000943	7634	298	1.315556	3.92035688	Dictyostelium	5782	Evosea	other_Eukaryota	222	1.99e-53	NTclustered	gi\|414966\|gb\|U02926.1\|DDU02926	44689	g7496	i0	81.227	13.6073825503356	277	50	93	2	23	298	333	58	Dictyostelium discoideum Ax3 Rab2 mRNA, partial cds	blastn	4055	222	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
17996863	17996863	PRJNA1000943_P_NODE_4715_length_365_cov_2.369863_g4578_i0	PRJNA1000943	4715	365	2.369863	8.64999995	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	235	3.1999999999999995e-57	NTclustered	gi\|66806816\|ref\|XM_632039.1\|	352472	g4578	i0	87.037	17.4821917808219	216	19	58	5	154	365	45	255	Dictyostelium discoideum AX4 hypothetical protein (rbx1) mRNA, complete cds	blastn	6381	235	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
19270691	19270691	PRJNA1000943_P_NODE_15936_length_229_cov_3.000000_g15798_i0	PRJNA1000943	15936	229	3	6.87	Cribraria violacea	1334538	Evosea	other_Eukaryota	211	3.19e-50	NTclustered	gi\|501417113\|gb\|JX481322.1\|	1334538	g15798	i0	84.071	24.3100436681223	226	28	97	7	8	229	763	542	Cribraria violacea voucher AMFD172 elongation factor 1A (EF1A) gene, partial cds	blastn	5567	211	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Liceales	Cribrariaceae	Cribraria	Cribraria violacea

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