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

5 rows where analysis = "diamond", bioproject = "PRJNA685607" 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
26702192	26702192	PRJNA685607_P_NODE_27941_length_337_cov_1.750000_g27582_i0	PRJNA685607	27941	337	1.75	5.8975	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	122	1.73e-29	NR	XP_013762907.1	461836	g27582	i0	50	3.47181008902077	130	47	99.7	1	2	337	179	308	XP_013762907.1 elongation factor 2 [Thecamonas trahens ATCC 50062]	diamond	1170	122	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28850495	28850495	PRJNA685607_P_NODE_93928_length_242_cov_0.899408_g93569_i0	PRJNA685607	93928	242	0.899408	2.17656736	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	66.2	1.75e-11	NR	XP_013758370.1	461836	g93569	i0	47.8	0.830578512396694	67	35	83.1	0	16	216	78	144	XP_013758370.1 uncharacterized protein AMSG_04698 [Thecamonas trahens ATCC 50062]	diamond	201	66.2	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30113729	30113729	PRJNA685607_P_NODE_39212_length_302_cov_1.344978_g38853_i0	PRJNA685607	39212	302	1.344978	4.06183356	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	50.8	1.06e-4	NR	XP_013761313.1	461836	g38853	i0	37.2	0.854304635761589	86	50	83.4	2	258	7	10	93	XP_013761313.1 V-type H(+)-translocating pyrophosphatase, variant [Thecamonas trahens ATCC 50062]	diamond	258	50.8	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30176903	30176903	PRJNA685607_P_NODE_32952_length_320_cov_1.246964_g32593_i0	PRJNA685607	32952	320	1.246964	3.9902848	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	156	3.9e-43	NR	XP_013756098.1	461836	g32593	i0	64.2	0.99375	106	38	99.4	0	318	1	54	159	XP_013756098.1 citrate synthase [Thecamonas trahens ATCC 50062]	diamond	318	156	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
32580151	32580151	PRJNA685607_P_NODE_55599_length_267_cov_1.793814_g55240_i0	PRJNA685607	55599	267	1.793814	4.78948338	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	51.6	9.4e-6	NR	XP_013759878.1	461836	g55240	i0	42.1	2.58426966292135	57	33	64	0	175	5	6	62	XP_013759878.1 calponin [Thecamonas trahens ATCC 50062]	diamond	690	52	0.992307692307692	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);;