metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA799842" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA799842" 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
2070894	2070894	PRJNA799842_P_NODE_52542_length_392_cov_1.184953_g50969_i0	PRJNA799842	52542	392	1.184953	4.64501576	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	153	5.69e-42	NR	AAD37351.1	5775	g50969	i0	72.6	1.81377551020408	106	27	79.6	1	3	314	108	213	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	711	154	0.993506493506494	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
7173024	7173024	PRJNA799842_P_NODE_35406_length_483_cov_1.675610_g33836_i0	PRJNA799842	35406	483	1.67561	8.0931963	Amoeba proteus	5775	Tubulinea	other_Eukaryota	273	2.09e-88	NR	AAP88974.1	5775	g33836	i0	87.9	0.925465838509317	149	18	92.5	0	481	35	242	390	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	447	273	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
21198133	21198133	PRJNA799842_P_NODE_81077_length_320_cov_1.469636_g79504_i0	PRJNA799842	81077	320	1.469636	4.7028352	Amoeba proteus	5775	Tubulinea	other_Eukaryota	168	1.93e-48	NR	AAP88974.1	5775	g79504	i0	76.4	0.99375	106	25	99.4	0	320	3	147	252	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	318	168	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
27148400	27148400	PRJNA799842_P_NODE_162482_length_246_cov_0.890173_g160909_i0	PRJNA799842	162482	246	0.890173	2.18982558	Amoeba proteus	5775	Tubulinea	other_Eukaryota	133	2.23e-36	NR	AKN09689.1	5775	g160909	i0	72.8	0.98780487804878	81	22	98.8	0	245	3	152	232	AKN09689.1 Tom20 [Amoeba proteus]	diamond	243	133	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
27464961	27464961	PRJNA799842_P_NODE_133543_length_252_cov_1.290503_g131970_i0	PRJNA799842	133543	252	1.290503	3.25206756	Copromyxa protea	931554	Tubulinea	other_Eukaryota	132	3.54e-36	NR	AKA62191.1	931554	g131970	i0	69.9	0.988095238095238	83	25	98.8	0	3	251	147	229	AKA62191.1 putative rhodoquinone biosynthesis methyltransferase-like protein RQUA [Copromyxa protea]	diamond	249	132	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
30812224	30812224	PRJNA799842_P_NODE_123134_length_264_cov_0.963351_g121561_i0	PRJNA799842	123134	264	0.963351	2.54324664	Amoeba proteus	5775	Tubulinea	other_Eukaryota	125	2.8399999999999997e-31	NR	AKN09691.1	5775	g121561	i0	65.5	0.988636363636364	87	28	98.9	1	263	3	726	810	AKN09691.1 Tom70 [Amoeba proteus]	diamond	261	125	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);;