metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA188516" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA188516" 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
5469136	5469136	PRJNA188516_P_NODE_3305_length_187_cov_1.311594_g3255_i0	PRJNA188516	3305	187	1.311594	2.45268078	Stemonaria longa	1258717	Evosea	other_Eukaryota	152	1.5299999999999998e-32	NTclustered	gi\|2714663874\|gb\|OR759949.1\|	1258717	g3255	i0	89.256	68.0106951871658	121	13	65	0	67	187	589	469	Stemonaria longa translation elongation factor EF-1 subunit alpha (EF1A) gene, partial cds	blastn	12718	152	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Stemonitida	Stemonitidae	Stemonaria	Stemonaria longa
9293849	9293849	PRJNA188516_P_NODE_1668_length_276_cov_0.938326_g1618_i0	PRJNA188516	1668	276	0.938326	2.58977976	Paramoeba branchiphila	308475	Discosea	other_Eukaryota	313	1.05e-80	NTclustered	gi\|226347442\|gb\|FJ807261.1\|	308475	g1618	i0	87.319	100.79347826087	276	31	99	4	1	274	738	1011	Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds	blastn	27819	313	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba branchiphila
10569871	10569871	PRJNA188516_P_NODE_3689_length_176_cov_1.228346_g3639_i0	PRJNA188516	3689	176	1.228346	2.16188896	Thecamoeba sp. JRG-2011	1078868	Discosea	other_Eukaryota	248	1.7599999999999998e-61	NTclustered	gi\|345452609\|gb\|JF694323.1\|	1078868	g3639	i0	92.045	98.4772727272727	176	14	100	0	1	176	161	336	Thecamoeba sp. JRG-2011 strain ATCC 50185 clone 1 actin gene, partial cds	blastn	17332	248	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Thecamoebida	Thecamoeba	Thecamoeba sp. JRG-2011
10569906	10569906	PRJNA188516_P_NODE_5389_length_164_cov_0.904348_g5339_i0	PRJNA188516	5389	164	0.904348	1.48313072	Arcyria cinerea	137621	Evosea	other_Eukaryota	198	1.66e-46	NTclustered	gi\|2772191589\|gb\|PQ014972.1\|	137621	g5339	i0	91.608	68	143	12	87	0	15	157	126	268	Arcyria cinerea voucher sc32852 translation elongation factor 1-alpha (EF1a) gene, partial cds	blastn	11152	198	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Arcyria	Arcyria cinerea
13119558	13119558	PRJNA188516_P_NODE_2391_length_222_cov_1.335260_g2341_i0	PRJNA188516	2391	222	1.33526	2.9642772	Rhizamoeba sp. ATCC 50933	497999	Tubulinea	other_Eukaryota	233	6.549999999999999e-57	NTclustered	gi\|167859754\|gb\|EU273459.1\|	497999	g2341	i0	85.778	92.4864864864865	225	26	100	6	1	222	515	294	Rhizamoeba sp. ATCC 50933 actin gene, partial cds	blastn	20532	233	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae	Rhizamoeba	Rhizamoeba sp. ATCC 50933
15668576	15668576	PRJNA188516_P_NODE_2373_length_223_cov_1.086207_g2323_i0	PRJNA188516	2373	223	1.086207	2.42224161	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	99	2.51e-16	NTclustered	gi\|831770523\|ref\|XM_012897573.1\|	1410327	g2323	i0	88.889	1.00896860986547	81	7	36	2	43	122	431	352	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	225	99	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
19491776	19491776	PRJNA188516_P_NODE_2476_length_218_cov_1.230769_g2426_i0	PRJNA188516	2476	218	1.230769	2.68307642	Glaeseria mira	242547	Tubulinea	other_Eukaryota	121	5.209999999999999e-23	NTclustered	gi\|33946352\|gb\|AY294155.1\|	242547	g2426	i0	80.921	14.5412844036697	152	29	70	0	2	153	202	51	Glaeseria mira actin mRNA, partial cds	blastn	3170	121	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Glaeseria	Glaeseria mira
22042467	22042467	PRJNA188516_P_NODE_5798_length_163_cov_0.912281_g5748_i0	PRJNA188516	5798	163	0.912281	1.48701803	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	147	6.0599999999999996e-31	NTclustered	gi\|831760979\|ref\|XM_012894664.1\|	1410327	g5748	i0	84.106	37.8036809815951	151	24	93	0	1	151	195	345	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	6162	147	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum

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