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

5 rows where bioproject = "PRJNA825466" and tax_clade = "Discoba"

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
2095951	2095951	PRJNA825466_P_NODE_19342_length_249_cov_0.875000_g19241_i0	PRJNA825466	19342	249	0.875	2.17875	Tsukubamonas globosa	875863	Root_unresolved	Root_unresolved	200	7.61e-47	NTclustered	gi\|323575411\|dbj\|AB576859.1\|	875863	g19241	i0	82.008	32.3534136546185	239	39	95	4	1	237	1893	1657	Tsukubamonas globosa EF2 mRNA for elongation factor 2, partial cds	blastn	8056	200	1	Eukaryota	Discoba			Tsukubamonadida	Tsukubamonadidae	Tsukubamonas	Tsukubamonas globosa
27339058	27339058	PRJNA825466_P_NODE_7923_length_308_cov_1.310638_g7822_i0	PRJNA825466	7923	308	1.310638	4.03676504	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	96.3	2.3699999999999998e-23	NR	KAL0482349.1	1008807	g7822	i0	40.8	0.954545454545455	98	56	93.5	1	303	16	7	104	KAL0482349.1 thioredoxin [Acrasis kona]	diamond	294	96.3	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
27442634	27442634	PRJNA825466_P_NODE_12803_length_270_cov_3.360406_g12702_i0	PRJNA825466	12803	270	3.360406	9.0730962	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	114	5.790000000000001e-29	NR	XP_002680196.1	5762	g12702	i0	64	3.6	86	29	94.4	2	269	15	176	260	XP_002680196.1 60S ribosomal protein L2 [Naegleria gruberi]	diamond	972	115	0.991304347826087	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
30275901	30275901	PRJNA825466_P_NODE_16312_length_251_cov_0.865169_g16211_i0	PRJNA825466	16312	251	0.865169	2.17157419	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	52.4	1.65e-5	NR	KAL0486421.1	1008807	g16211	i0	37.9	5.85657370517928	66	41	78.9	0	38	235	403	468	KAL0486421.1 ATP-binding cassette, subfamily G [Acrasis kona]	diamond	1470	52.4	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
31002412	31002412	PRJNA825466_P_NODE_13854_length_264_cov_2.445026_g13753_i0	PRJNA825466	13854	264	2.445026	6.45486864	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	62	8.09e-9	NR	KAJ9445139.1	91374	g13753	i0	42.7	0.852272727272727	75	43	85.2	0	252	28	544	618	KAJ9445139.1 hypothetical protein DIPPA_19525 [Diplonema papillatum]	diamond	225	62	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum

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