metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA662254" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA662254" 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
3179334	3179334	PRJNA662254_P_NODE_9903_length_529_cov_1.432018_g9255_i0	PRJNA662254	9903	529	1.432018	7.57537522	Amoeba proteus	5775	Tubulinea	other_Eukaryota	194	4.33e-57	NR	AAD37351.1	5775	g9255	i0	76.4	0.720226843100189	127	28	72	2	436	56	86	210	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	381	194	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
8281390	8281390	PRJNA662254_P_NODE_1187_length_1605_cov_7.834204_g939_i0	PRJNA662254	1187	1605	7.834204	125.7389742	Copromyxa protea	931554	Tubulinea	other_Eukaryota	769	1.6300000000000002e-276	NR	BAN33737.1	931554	g939	i0	81.3	3.42803738317757	464	81	85.6	1	39	1412	1	464	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	5502	769	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
9556827	9556827	PRJNA662254_P_NODE_4768_length_800_cov_1.415406_g4208_i0	PRJNA662254	4768	800	1.415406	11.323248	Copromyxa protea	931554	Tubulinea	other_Eukaryota	404	4.09e-137	NR	BAN33737.1	931554	g4208	i0	72	2.01375	271	71	99.8	1	2	799	173	443	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	1611	404	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
13382313	13382313	PRJNA662254_P_NODE_2691_length_1087_cov_3.196252_g2274_i0	PRJNA662254	2691	1087	3.196252	34.74325924	Amoeba proteus	5775	Tubulinea	other_Eukaryota	555	2.949999999999999e-196	NR	AAP88974.1	5775	g2274	i0	76.7	0.97148114075437	352	80	97.1	1	1087	32	40	389	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	1056	555	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
18480736	18480736	PRJNA662254_P_NODE_54535_length_246_cov_1.780347_g53884_i0	PRJNA662254	54535	246	1.780347	4.37965362	Euamoebida	180229	Tubulinea	other_Eukaryota	121	1.22e-31	NR	AFX73090.1	160823	g53884	i0	70	2.9390243902439	80	24	97.6	0	245	6	170	249	AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense]	diamond	723	121	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Chaos	Chaos carolinense
19755155	19755155	PRJNA662254_P_NODE_1196_length_1601_cov_8.021597_g939_i1	PRJNA662254	1196	1601	8.021597	128.42576797	Copromyxa protea	931554	Tubulinea	other_Eukaryota	769	1.1e-276	NR	BAN33737.1	931554	g939	i1	81.3	3.4366021236727	464	81	85.8	1	35	1408	1	464	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	5502	769	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
22305525	22305525	PRJNA662254_P_NODE_26978_length_318_cov_1.885714_g26327_i0	PRJNA662254	26978	318	1.885714	5.99657052	Arcella hemisphaerica	497998	Tubulinea	other_Eukaryota	199	7.97e-62	NR	ACA04822.1	497998	g26327	i0	90.6	1	106	10	100	0	1	318	96	201	ACA04822.1 alpha-tubulin, partial [Arcella hemisphaerica]	diamond	318	199	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Arcellidae	Arcella	Arcella hemisphaerica
27334454	27334454	PRJNA662254_P_NODE_25183_length_329_cov_1.296875_g24532_i0	PRJNA662254	25183	329	1.296875	4.26671875	Amoeba proteus	5775	Tubulinea	other_Eukaryota	135	2.7899999999999997e-35	NR	AAD37351.1	5775	g24532	i0	82.3	0.720364741641337	79	14	72	0	4	240	132	210	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	237	135	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
32906041	32906041	PRJNA662254_P_NODE_25540_length_327_cov_1.161417_g24889_i0	PRJNA662254	25540	327	1.161417	3.79783359	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	112	1.37e-26	NR	AAD37351.1	5775	g24889	i0	74.3	2.6697247706422	74	19	67.9	0	222	1	275	348	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	873	112	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);;