metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA770826" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA770826" 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
3298099	3298099	PRJNA770826_P_NODE_2503_length_549_cov_4.370000_g2336_i0	PRJNA770826	2503	549	4.37	23.9913	Amoeba proteus	5775	Tubulinea	other_Eukaryota	288	3.64e-97	NR	AAW58116.1	5775	g2336	i0	80.2	0.885245901639344	162	32	88.5	0	64	549	1	162	AAW58116.1 peroxiredoxin, partial [Amoeba proteus]	diamond	486	288	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
17325302	17325302	PRJNA770826_P_NODE_694_length_980_cov_2.987111_g589_i0	PRJNA770826	694	980	2.987111	29.2736878	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	441	1.8699999999999994e-153	NR	AFX73090.1	160823	g589	i0	92.3	2.75510204081633	234	18	71.6	0	703	2	1	234	AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense]	diamond	2700	445	0.991011235955056	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Chaos	Chaos carolinense
21608888	21608888	PRJNA770826_P_NODE_857_length_901_cov_2.095070_g744_i0	PRJNA770826	857	901	2.09507	18.8765807	Amoeba proteus	5775	Tubulinea	other_Eukaryota	546	1.0899999999999999e-193	NR	AAP88974.1	5775	g744	i0	87.8	0.985571587125416	296	36	98.6	0	12	899	91	386	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	888	546	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
26831812	26831812	PRJNA770826_P_NODE_18161_length_190_cov_1.106383_g17990_i0	PRJNA770826	18161	190	1.106383	2.1021277	Amoeba proteus	5775	Tubulinea	other_Eukaryota	102	9.92e-24	NR	AOW71840.1	5775	g17990	i0	75.8	0.978947368421053	62	15	97.9	0	188	3	99	160	AOW71840.1 bacterial recombinase A, partial [Amoeba proteus]	diamond	186	102	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
30338107	30338107	PRJNA770826_P_NODE_6232_length_335_cov_0.909091_g6061_i0	PRJNA770826	6232	335	0.909091	3.04545485	Amoeba proteus	5775	Tubulinea	other_Eukaryota	199	1.3999999999999997e-56	NR	AAD33718.1	5775	g6061	i0	90.1	0.994029850746269	111	11	99.4	0	1	333	730	840	AAD33718.1 myosin heavy chain [Amoeba proteus]	diamond	333	199	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
31105348	31105348	PRJNA770826_P_NODE_11715_length_235_cov_2.602151_g11544_i0	PRJNA770826	11715	235	2.602151	6.11505485	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	73.9	1.25e-13	NR	AFX73093.1	5778	g11544	i0	54.5	4.16170212765957	66	17	84.3	1	198	1	39	91	AFX73093.1 elongation factor 2 alpha, partial [Vermamoeba vermiformis]	diamond	978	73.9	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
31570470	31570470	PRJNA770826_P_NODE_12956_length_223_cov_2.011494_g12785_i0	PRJNA770826	12956	223	2.011494	4.48563162	Amoeba proteus	5775	Tubulinea	other_Eukaryota	143	3.24e-39	NR	AAP88974.1	5775	g12785	i0	89	0.982062780269058	73	8	98.2	0	4	222	1	73	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	219	143	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
31949713	31949713	PRJNA770826_P_NODE_36017_length_165_cov_0.896552_g35846_i0	PRJNA770826	36017	165	0.896552	1.4793108	Chaos carolinense	160823	Tubulinea	other_Eukaryota	107	3.36e-28	NR	AFX73078.1	160823	g35846	i0	90.9	1	55	5	100	0	1	165	81	135	AFX73078.1 beta-tubulin, partial [Chaos carolinense]	diamond	165	107	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Chaos	Chaos carolinense
31981323	31981323	PRJNA770826_P_NODE_11138_length_241_cov_1.895833_g10967_i0	PRJNA770826	11138	241	1.895833	4.56895753	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	100	4.96e-24	NR	AAY21191.1	5778	g10967	i0	63.6	1.91701244813278	77	28	95.9	0	239	9	145	221	AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis]	diamond	462	100	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
32013141	32013141	PRJNA770826_P_NODE_6338_length_332_cov_1.102473_g6167_i0	PRJNA770826	6338	332	1.102473	3.66021036	Amoeba proteus	5775	Tubulinea	other_Eukaryota	206	4.86e-64	NR	AFX84537.1	5775	g6167	i0	86.2	0.984939759036145	109	15	98.5	0	331	5	146	254	AFX84537.1 alpha tubulin, partial [Amoeba proteus]	diamond	327	206	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
32361407	32361407	PRJNA770826_P_NODE_25359_length_168_cov_1.310924_g25188_i0	PRJNA770826	25359	168	1.310924	2.20235232	Amoeba proteus	5775	Tubulinea	other_Eukaryota	77	9.73e-15	NR	AAD37351.1	5775	g25188	i0	63	0.964285714285714	54	20	96.4	0	2	163	99	152	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	162	77	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
32676829	32676829	PRJNA770826_P_NODE_36220_length_164_cov_1.356522_g36049_i0	PRJNA770826	36220	164	1.356522	2.22469608	Amoeba proteus	5775	Tubulinea	other_Eukaryota	88.6	6.47e-19	NR	AAD37351.1	5775	g36049	i0	79.6	0.98780487804878	54	11	98.8	0	164	3	115	168	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	162	88.6	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);;