metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB75230" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB75230" 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
12889905	12889905	PRJEB75230_P_NODE_145611_length_247_cov_0.885057_g145429_i0	PRJEB75230	145611	247	0.885057	2.18609079	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	63.9	1.03e-5	NTclustered	gi\|923133514\|ref\|XM_013904769.1\|	461836	g145429	i0	95	0.161943319838057	40	2	16	0	162	201	1888	1927	Thecamonas trahens ATCC 50062 NRF-6 protein (AMSG_03385), partial mRNA	blastn	40	63.9	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
15440437	15440437	PRJEB75230_P_NODE_9213_length_484_cov_7.401460_g9031_i0	PRJEB75230	9213	484	7.40146	35.8230664	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	207	9.51e-49	NTclustered	gi\|923125359\|ref\|XM_013900694.1\|	461836	g9031	i0	81.712	31.8636363636364	257	39	52	6	37	289	529	277	Thecamonas trahens ATCC 50062 calmodulin (AMSG_07687), mRNA	blastn	15422	207	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
17988819	17988819	PRJEB75230_P_NODE_46055_length_318_cov_1.232653_g45873_i0	PRJEB75230	46055	318	1.232653	3.91983654	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	139	2.22e-28	NTclustered	gi\|923119488\|ref\|XM_013897764.1\|	461836	g45873	i0	76.471	27.8805031446541	272	55	85	6	41	309	851	586	Thecamonas trahens ATCC 50062 malic enzyme (AMSG_10776), partial mRNA	blastn	8866	139	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
20537173	20537173	PRJEB75230_P_NODE_1417_length_1076_cov_12.997009_g1287_i0	PRJEB75230	1417	1076	12.997009	139.84781684	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	431	1.1999999999999999e-115	NTclustered	gi\|923134252\|ref\|XM_013905138.1\|	461836	g1287	i0	77.007	15.6542750929368	822	145	74	31	165	964	997	198	Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA	blastn	16844	431	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
24362776	24362776	PRJEB75230_P_NODE_2800_length_805_cov_4.091530_g2642_i0	PRJEB75230	2800	805	4.09153	32.9368165	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	359	4.25e-94	NTclustered	gi\|923133140\|ref\|XM_013904582.1\|	461836	g2642	i0	79.757	40.8857142857143	494	100	61	0	190	683	494	1	Thecamonas trahens ATCC 50062 Ras-like protein rasG (AMSG_03185), partial mRNA	blastn	32913	359	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);;