metadata: contig_metadata: 7 rows where bioproject = "PRJNA473201" and tax

7 rows where bioproject = "PRJNA473201" 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
443971	443971	PRJNA473201_P_NODE_48621_length_295_cov_1.387387_g47879_i0	PRJNA473201	48621	295	1.387387	4.09279165	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	117	1.83e-29	NR	XP_013760592.1	461836	g47879	i0	67	1.67796610169492	91	28	90.5	1	269	3	30	120	XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062]	diamond	495	117	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
4922530	4922530	PRJNA473201_P_NODE_21924_length_421_cov_2.137931_g21182_i0	PRJNA473201	21924	421	2.137931	9.00068951	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	166	2.6199999999999996e-47	NR	XP_013760592.1	461836	g21182	i0	62.9	0.997624703087886	140	50	99.8	1	1	420	123	260	XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062]	diamond	420	166	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
10647151	10647151	PRJNA473201_P_NODE_13029_length_556_cov_2.080745_g12290_i0	PRJNA473201	13029	556	2.080745	11.5689422	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	279	2.31e-70	NTclustered	gi\|923134252\|ref\|XM_013905138.1\|	461836	g12290	i0	78.197	29.4838129496403	477	76	83	21	6	465	663	198	Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA	blastn	16393	279	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28655292	28655292	PRJNA473201_P_NODE_78327_length_245_cov_0.895349_g77585_i0	PRJNA473201	78327	245	0.895349	2.19360505	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	122	2.68e-30	NR	XP_013762071.1	461836	g77585	i0	69.1	8.9265306122449	81	23	99.2	1	243	1	634	712	XP_013762071.1 tumor necrosis factor receptor superfamily member 6B [Thecamonas trahens ATCC 50062]	diamond	2187	122	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30138984	30138984	PRJNA473201_P_NODE_76272_length_246_cov_0.890173_g75530_i0	PRJNA473201	76272	246	0.890173	2.18982558	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	125	1.3e-32	NR	XP_013757656.1	461836	g75530	i0	69.1	0.98780487804878	81	25	98.8	0	3	245	174	254	XP_013757656.1 NAD-dependent epimerase/dehydratase [Thecamonas trahens ATCC 50062]	diamond	243	125	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30392583	30392583	PRJNA473201_P_NODE_74673_length_247_cov_0.885057_g73931_i0	PRJNA473201	74673	247	0.885057	2.18609079	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	72.8	1.04e-12	NR	XP_013754467.1	461836	g73931	i0	43.4	1.77327935222672	83	41	93.5	2	2	232	339	421	XP_013754467.1 family S53 protease [Thecamonas trahens ATCC 50062]	diamond	438	72.8	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
32004437	32004437	PRJNA473201_P_NODE_40058_length_316_cov_1.267490_g39316_i0	PRJNA473201	40058	316	1.26749	4.0052684	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	96.7	5.689999999999999e-23	NR	XP_013759960.1	461836	g39316	i0	67.1	0.664556962025316	70	22	65.5	1	108	314	11	80	XP_013759960.1 40S ribosomal protein S12 [Thecamonas trahens ATCC 50062]	diamond	210	96.7	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);;