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

5 rows where analysis = "blastn", bioproject = "PRJNA966993" 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
942331	942331	PRJNA966993_P_NODE_67621_length_274_cov_0.860697_g67169_i0	PRJNA966993	67621	274	0.860697	2.35830978	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	89.8	1.92e-13	NTclustered	gi\|923129792\|ref\|XM_013902908.1\|	461836	g67169	i0	86.047	1.20802919708029	86	8	31	3	30	113	450	533	Thecamonas trahens ATCC 50062 Ras-like C3 botulinum toxin substrate 1 (AMSG_04690), mRNA	blastn	331	89.8	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
942420	942420	PRJNA966993_P_NODE_78961_length_256_cov_1.398907_g78509_i0	PRJNA966993	78961	256	1.398907	3.58120192	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	54.7	0.006	NTclustered	gi\|923131822\|ref\|XM_013903923.1\|	461836	g78509	i0	92.308	0.15234375	39	1	15	2	159	197	554	590	Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_02458), partial mRNA	blastn	39	54.7	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
2217605	2217605	PRJNA966993_P_NODE_56102_length_290_cov_1.419355_g55650_i0	PRJNA966993	56102	290	1.419355	4.1161295	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	172	1.98e-38	NTclustered	gi\|923134252\|ref\|XM_013905138.1\|	461836	g55650	i0	81.223	34.9620689655172	229	29	76	10	64	282	422	198	Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA	blastn	10139	172	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
12421421	12421421	PRJNA966993_P_NODE_61030_length_283_cov_1.771429_g60578_i0	PRJNA966993	61030	283	1.771429	5.01314407	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	254	6.67e-63	NTclustered	gi\|923130274\|ref\|XM_013903149.1\|	461836	g60578	i0	88.942	76.0636042402827	208	19	73	4	28	233	258	53	Thecamonas trahens ATCC 50062 14-3-3 family protein epsilon (AMSG_04940), partial mRNA	blastn	21526	254	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
17520268	17520268	PRJNA966993_P_NODE_51014_length_303_cov_2.939130_g50562_i0	PRJNA966993	51014	303	2.93913	8.9055639	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	209	1.58e-49	NTclustered	gi\|923122580\|ref\|XM_013899306.1\|	461836	g50562	i0	84.507	46.1287128712871	213	31	70	2	89	300	113	324	Thecamonas trahens ATCC 50062 heat shock protein 90A (AMSG_09389), mRNA	blastn	13977	209	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);;