metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA520845" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA520845" and tax_phylum = "Preaxostyla"

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_phylum	tax_order	tax_family	tax_genus	tax_species
492509	492509	PRJNA520845_P_NODE_63741_length_466_cov_2.081425_g62242_i0	PRJNA520845	63741	466	2.081425	9.6994405	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	141	9.39e-29	NTclustered	gi\|2794957249\|ref\|XM_067872345.1\|	2049356	g62242	i0	79.126	1.15021459227468	206	41	44	2	261	465	294	498	Monocercomonoides exilis Centrin (MONOS_2427), mRNA	blastn	536	141	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
1764024	1764024	PRJNA520845_P_NODE_159462_length_295_cov_1.193694_g157963_i0	PRJNA520845	159462	295	1.193694	3.5213973	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	58.4	5.88e-4	NTclustered	gi\|2794956677\|ref\|XM_067865043.1\|	2049356	g157963	i0	100	0.105084745762712	31	0	11	0	130	160	4759	4789	Monocercomonoides exilis uncharacterized protein (MONOS_12422), partial mRNA	blastn	31	58.4	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
8142469	8142469	PRJNA520845_P_NODE_183887_length_275_cov_0.945545_g182388_i0	PRJNA520845	183887	275	0.945545	2.60024875	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	54.7	0.007	NTclustered	gi\|2794960548\|ref\|XM_067880525.1\|	2049356	g182388	i0	100	0.207272727272727	29	0	11	0	247	275	3495	3467	Monocercomonoides exilis putative Activating signal cointegrator 1 complex subunit 3 (MONOS_9978), partial mRNA	blastn	57	54.7	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
9418591	9418591	PRJNA520845_P_NODE_219948_length_250_cov_0.870056_g218449_i0	PRJNA520845	219948	250	0.870056	2.17514	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	56.5	0.002	NTclustered	gi\|2794952709\|ref\|XM_067873955.1\|	2049356	g218449	i0	100	0.12	30	0	12	0	1	30	10140	10111	Monocercomonoides exilis uncharacterized protein (MONOS_3924), partial mRNA	blastn	30	56.5	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
9420151	9420151	PRJNA520845_P_NODE_36328_length_629_cov_1.311151_g34868_i0	PRJNA520845	36328	629	1.311151	8.24713979	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	60.2	3.73e-4	NTclustered	gi\|2794970009\|ref\|XM_067877330.1\|	2049356	g34868	i0	88.235	0.0810810810810811	51	4	8	2	460	508	3203	3253	Monocercomonoides exilis DNA repair endonuclease XPF (MONOS_7037), partial mRNA	blastn	51	60.2	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
10694324	10694324	PRJNA520845_P_NODE_223889_length_249_cov_0.875000_g222390_i0	PRJNA520845	223889	249	0.875	2.17875	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	52.8	0.023	NTclustered	gi\|2794960456\|ref\|XM_067871878.1\|	2049356	g222390	i0	100	0.112449799196787	28	0	11	0	187	214	1812	1839	Monocercomonoides exilis Sly1 (MONOS_199), mRNA	blastn	28	52.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
14517953	14517953	PRJNA520845_P_NODE_168192_length_287_cov_1.364486_g166693_i0	PRJNA520845	168192	287	1.364486	3.91607482	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	52.8	0.027	NTclustered	gi\|2794942787\|ref\|XM_067876759.1\|	2049356	g166693	i0	100	0.195121951219512	28	0	10	0	4	31	3686	3713	Monocercomonoides exilis putative Ribonuclease 2-5A (MONOS_652), mRNA	blastn	56	52.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
19615693	19615693	PRJNA520845_P_NODE_192676_length_268_cov_1.087179_g191177_i0	PRJNA520845	192676	268	1.087179	2.91363972	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	62.1	4.08e-5	NTclustered	gi\|2794964845\|ref\|XM_067876140.1\|	2049356	g191177	i0	100	7.91791044776119	33	0	12	0	65	97	1463	1495	Monocercomonoides exilis putative ubiquitin carboxyl-terminal hydrolase 16/45 (MONOS_5949), partial mRNA	blastn	2122	62.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
24713469	24713469	PRJNA520845_P_NODE_109740_length_355_cov_1.634752_g108241_i0	PRJNA520845	109740	355	1.634752	5.8033696	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	259	1.84e-64	NTclustered	gi\|2794958074\|ref\|XM_067863495.1\|	2049356	g108241	i0	80.282	66.9098591549296	355	60	99	10	1	350	75	424	Monocercomonoides exilis putative 60S ribosomal protein L40, ubiquitin fusion protein (MONOS_11000), mRNA	blastn	23753	259	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis

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);;