metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1240805" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1240805" 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
15652435	15652435	PRJNA1240805_P_NODE_4653_length_212_cov_5.312883_g4604_i0	PRJNA1240805	4653	212	5.312883	11.26331196	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	73.9	2.12e-13	NR	XP_003293643.1	5786	g4604	i0	57.1	1.85377358490566	63	25	89.2	1	190	2	199	259	XP_003293643.1 UDP-N-acetylglucosamine-dolichyl-phosphate N-acetylglucosaminephosphotransferase [Dictyostelium purpureum]	diamond	393	73.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
24002516	24002516	PRJNA1240805_P_NODE_3299_length_256_cov_10.797101_g3250_i0	PRJNA1240805	3299	256	10.797101	27.64057856	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	91.3	3.69e-19	NR	PRP86239.1	1890364	g3250	i0	55.7	0.92578125	79	35	92.6	0	251	15	1903	1981	PRP86239.1 vacuolar protein sorting-associated protein 13 family protein, partial [Planoprotostelium fungivorum]	diamond	237	91.3	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
28115724	28115724	PRJNA1240805_P_NODE_7125_length_172_cov_5.642276_g7076_i0	PRJNA1240805	7125	172	5.642276	9.70471472	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	58.9	2.82e-8	NR	KYQ94461.1	361077	g7076	i0	81.3	1.11627906976744	32	6	55.8	0	23	118	284	315	KYQ94461.1 2-oxoglutarate dehydrogenase [Tieghemostelium lacteum]	diamond	192	58.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
29694193	29694193	PRJNA1240805_P_NODE_4270_length_222_cov_2.086705_g4221_i0	PRJNA1240805	4270	222	2.086705	4.6324851	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	85.5	7.34e-18	NR	XP_004344643.1	1257118	g4221	i0	72.5	0.689189189189189	51	14	68.9	0	200	48	252	302	XP_004344643.1 MC family transporter: phosphate, putative [Acanthamoeba castellanii str. Neff]	diamond	153	85.5	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31179100	31179100	PRJNA1240805_P_NODE_2055_length_337_cov_3.642361_g2006_i0	PRJNA1240805	2055	337	3.642361	12.27475657	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	81.3	8.66e-16	NR	KYQ89350.1	361077	g2006	i0	58.9	1.83382789317507	73	26	64.1	3	221	6	22	91	KYQ89350.1 hypothetical protein DLAC_11801 [Tieghemostelium lacteum]	diamond	618	81.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum

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