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

5 rows where bioproject = "PRJNA760976" and tax_clade = "Apusozoa"

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_order	tax_family	tax_genus	tax_species
10946454	10946454	PRJNA760976_P_NODE_2729_length_778_cov_6.031206_g2439_i0	PRJNA760976	2729	778	6.031206	46.92278268	Catacumbia lutetiensis	2925415	Root_unresolved	Root_unresolved	154	2.08e-32	NTclustered	gi\|2206682166\|gb\|OM966639.1\|	2925415	g2439	i0	88.8	27.512853470437	125	14	16	0	156	280	5302	5178	Catacumbia lutetiensis strain ORSAYFEB19APU2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	21405	154	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Catacumbia	Catacumbia lutetiensis
17320641	17320641	PRJNA760976_P_NODE_18194_length_360_cov_1.599303_g17873_i0	PRJNA760976	18194	360	1.599303	5.7574908	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	254	8.710000000000001e-63	NTclustered	gi\|923130274\|ref\|XM_013903149.1\|	461836	g17873	i0	88.942	76.0222222222222	208	19	57	4	122	327	258	53	Thecamonas trahens ATCC 50062 14-3-3 family protein epsilon (AMSG_04940), partial mRNA	blastn	27368	254	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28411277	28411277	PRJNA760976_P_NODE_35646_length_284_cov_1.071090_g35325_i0	PRJNA760976	35646	284	1.07109	3.0418956	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	113	5.59e-27	NR	XP_013759182.1	461836	g35325	i0	56.5	0.971830985915493	92	38	97.2	1	8	283	288	377	XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062]	diamond	276	113	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30210896	30210896	PRJNA760976_P_NODE_21812_length_338_cov_3.120755_g21491_i0	PRJNA760976	21812	338	3.120755	10.5481519	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	63.9	4.25e-10	NR	XP_013758370.1	461836	g21491	i0	38.1	0.86094674556213	97	56	85.2	2	314	27	9	102	XP_013758370.1 uncharacterized protein AMSG_04698 [Thecamonas trahens ATCC 50062]	diamond	291	63.9	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30379140	30379140	PRJNA760976_P_NODE_27692_length_311_cov_1.567227_g27371_i0	PRJNA760976	27692	311	1.567227	4.87407597	root	1	Root_unresolved	Root_unresolved	143	4.489999999999999e-37	NR	XP_013754784.1	461836	g27371	i0	66	31.8327974276527	103	35	99.4	0	309	1	494	596	XP_013754784.1 major vault protein [Thecamonas trahens ATCC 50062]	diamond	9900	143	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens

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