metadata: contig_metadata: 5 rows where bioproject = "PRJNA564810" and tax

5 rows where bioproject = "PRJNA564810" and tax_phylum = "Discosea"

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_order	tax_family	tax_genus	tax_species
13308230	13308230	PRJNA564810_S_NODE_2671_length_309_cov_3.270492_g2649_i0	PRJNA564810	2671	309	3.270492	10.10582028	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	144	1.06e-38	NR	P53490.1	5755	g2649	i0	62.3	8.85436893203883	114	32	100	1	309	1	303	416	P53490.1 RecName: Full=Actin-related protein 3; AltName: Full=Actin-like protein 3 [Acanthamoeba castellanii]	diamond	2736	144	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
20956281	20956281	PRJNA564810_S_NODE_717_length_445_cov_7.473684_g695_i0	PRJNA564810	717	445	7.473684	33.2578938	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	172	3.8e-49	NR	XP_004358308.1	1257118	g695	i0	68.2	2.2247191011236	110	34	73.5	1	443	117	274	383	XP_004358308.1 papain family cysteine protease subfamily protein [Acanthamoeba castellanii str. Neff]	diamond	990	172	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31533266	31533266	PRJNA564810_S_NODE_1236_length_382_cov_1.570978_g1214_i0	PRJNA564810	1236	382	1.570978	6.00113596	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	62.8	1.5e-8	NR	XP_004336070.1	1257118	g1214	i0	62.8	0.675392670157068	43	16	33.8	0	2	130	329	371	XP_004336070.1 aspartyl aminopeptidase [Acanthamoeba castellanii str. Neff]	diamond	258	62.8	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31533267	31533267	PRJNA564810_S_NODE_2456_length_317_cov_1.619048_g2434_i0	PRJNA564810	2456	317	1.619048	5.13238216	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	87.4	1.91e-17	NR	XP_004345363.1	1257118	g2434	i0	52.6	0.738170347003155	78	37	73.8	0	315	82	1292	1369	XP_004345363.1 myosin1, putative [Acanthamoeba castellanii str. Neff]	diamond	234	87.4	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32039234	32039234	PRJNA564810_S_NODE_4978_length_254_cov_2.518519_g4956_i0	PRJNA564810	4978	254	2.518519	6.39703826	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	48.1	5.34e-4	NR	XP_004335175.1	1257118	g4956	i0	56.3	0.377952755905512	32	14	37.8	0	252	157	581	612	XP_004335175.1 HECTdomain (ubiquitin-transferase) domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	96	48.1	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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