metadata: contig_metadata: 5 rows where bioproject = "PRJNA1160211", tax_clade = "Apusozoa" and tax

5 rows where bioproject = "PRJNA1160211", tax_clade = "Apusozoa" and tax_superkingdom = "Eukaryota"

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
11242072	11242072	PRJNA1160211_S_NODE_301009_length_198_cov_5.936000_g299776_i0	PRJNA1160211	301009	198	5.936	11.75328	Apusomonadidae	172820	Root_unresolved	Root_unresolved	124	3.59e-24	NTclustered	gi\|2206682162\|gb\|OM966635.1\|	1314681	g299776	i0	80	21.6919191919192	180	26	87	9	26	198	5712	5536	Mylnikovia oxoniensis strain CCAP19012 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	4295	124	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Mylnikovia	Mylnikovia oxoniensis
15612815	15612815	PRJNA1160211_S_NODE_245713_length_265_cov_4.098958_g244480_i0	PRJNA1160211	245713	265	4.098958	10.8622387	Thecamonas trahens	529818	Root_unresolved	Root_unresolved	93.5	1.43e-14	NTclustered	gi\|923122628\|ref\|XM_013899330.1\|	461836	g244480	i0	92.308	0.422641509433962	65	5	25	0	164	228	2585	2521	Thecamonas trahens ATCC 50062 major vault protein (AMSG_09422), mRNA	blastn	112	93.5	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
28670462	28670462	PRJNA1160211_S_NODE_279667_length_243_cov_0.858824_g278434_i0	PRJNA1160211	279667	243	0.858824	2.08694232	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	62.4	4.53e-9	NR	XP_013762398.1	461836	g278434	i0	57.8	1.20987654320988	45	19	55.6	0	43	177	558	602	XP_013762398.1 uncharacterized protein AMSG_00666 [Thecamonas trahens ATCC 50062]	diamond	294	62.4	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29661006	29661006	PRJNA1160211_S_NODE_251950_length_260_cov_2.438503_g250717_i0	PRJNA1160211	251950	260	2.438503	6.3401078	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	50.8	3.95e-6	NR	XP_013757852.1	461836	g250717	i0	76.9	0.3	26	6	30	0	255	178	45	70	XP_013757852.1 uncharacterized protein AMSG_05436 [Thecamonas trahens ATCC 50062]	diamond	78	50.8	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
30767110	30767110	PRJNA1160211_S_NODE_120014_length_421_cov_3.936782_g118785_i0	PRJNA1160211	120014	421	3.936782	16.57385222	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	70.5	1.9e-11	NR	XP_013754585.1	461836	g118785	i0	52.5	2.40855106888361	59	28	42	0	114	290	201	259	XP_013754585.1 uncharacterized protein AMSG_08826 [Thecamonas trahens ATCC 50062]	diamond	1014	70.5	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);;