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

5 rows where analysis = "blastn", bioproject = "PRJNA884104" 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
7239578	7239578	PRJNA884104_S_NODE_76106_length_247_cov_0.885057_g75363_i0	PRJNA884104	76106	247	0.885057	2.18609079	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	52.8	0.022	NTclustered	gi\|923131822\|ref\|XM_013903923.1\|	461836	g75363	i0	100	0.11336032388664	28	0	11	0	158	185	590	563	Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_02458), partial mRNA	blastn	28	52.8	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
13614313	13614313	PRJNA884104_S_NODE_39591_length_328_cov_3.184314_g38848_i0	PRJNA884104	39591	328	3.184314	10.44454992	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	195	4.84e-45	NTclustered	gi\|923133140\|ref\|XM_013904582.1\|	461836	g38848	i0	84.896	60.984756097561	192	29	59	0	8	199	192	1	Thecamonas trahens ATCC 50062 Ras-like protein rasG (AMSG_03185), partial mRNA	blastn	20003	195	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
16163328	16163328	PRJNA884104_S_NODE_3373_length_1092_cov_18.047105_g2946_i0	PRJNA884104	3373	1092	18.047105	197.0743866	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	431	1.2199999999999999e-115	NTclustered	gi\|923134252\|ref\|XM_013905138.1\|	461836	g2946	i0	77.035	15.9413919413919	823	143	73	33	195	994	997	198	Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA	blastn	17408	431	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
18711547	18711547	PRJNA884104_S_NODE_11895_length_585_cov_15.732422_g11169_i0	PRJNA884104	11895	585	15.732422	92.0346687	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	219	5.39e-52	NTclustered	gi\|923125359\|ref\|XM_013900694.1\|	461836	g11169	i0	82.49	11.3897435897436	257	37	43	6	200	452	277	529	Thecamonas trahens ATCC 50062 calmodulin (AMSG_07687), mRNA	blastn	6663	219	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
21262122	21262122	PRJNA884104_S_NODE_10517_length_622_cov_2.564663_g9800_i0	PRJNA884104	10517	622	2.564663	15.95220386	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	198	7.49e-46	NTclustered	gi\|923135134\|ref\|XM_013905579.1\|	461836	g9800	i0	85.34	18.1929260450161	191	28	31	0	34	224	10	200	Thecamonas trahens ATCC 50062 60S ribosomal protein L27a (AMSG_02000), mRNA	blastn	11316	198	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);;