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

5 rows where bioproject = "PRJNA1111146" 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
2767029	2767029	PRJNA1111146_P_NODE_323183_length_184_cov_0.870229_g322045_i0	PRJNA1111146	323183	184	0.870229	1.60122136	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	340	2.99e-89	NTclustered	gi\|300078496\|gb\|GU001158.1\|	5778	g322045	i0	100	3	184	0	100	0	1	184	2460	2643	Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	552	340	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
7869459	7869459	PRJNA1111146_P_NODE_383687_length_180_cov_0.897638_g382549_i0	PRJNA1111146	383687	180	0.897638	1.6157484	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	77.8	4.91e-17	NR	PRP85004.1	1890364	g382549	i0	83.3	0.7	42	7	70	0	180	55	39	80	PRP85004.1 hypothetical protein PROFUN_07292 [Planoprotostelium fungivorum]	diamond	126	77.8	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
23169023	23169023	PRJNA1111146_P_NODE_386059_length_180_cov_0.889764_g384921_i0	PRJNA1111146	386059	180	0.889764	1.6015752	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	289	1.07e-73	NTclustered	gi\|470381213\|ref\|XM_004333714.1\|	1257118	g384921	i0	95.556	1	180	8	100	0	1	180	2667	2488	Acanthamoeba castellanii str. Neff EGFlike domain containing protein (ACA1_362110), partial mRNA	blastn	180	289	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30384180	30384180	PRJNA1111146_P_NODE_415913_length_178_cov_0.912000_g414775_i0	PRJNA1111146	415913	178	0.912	1.62336	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	42.7	0.0161	NR	XP_642434.2	352472	g414775	i0	39	0.99438202247191	59	33	96.1	2	171	1	507	564	XP_642434.2 hypothetical protein DDB_G0278703 [Dictyostelium discoideum AX4]	diamond	177	42.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
31521695	31521695	PRJNA1111146_P_NODE_339616_length_183_cov_0.869231_g338478_i0	PRJNA1111146	339616	183	0.869231	1.59069273	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	58.9	3.3e-8	NR	XP_004368209.1	1257118	g338478	i0	85.7	0.459016393442623	28	4	45.9	0	1	84	101	128	XP_004368209.1 acidstable alpha-amylase [Acanthamoeba castellanii str. Neff]	diamond	84	58.9	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);;