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

9 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax_clade = "Metamonada"

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
10690732	10690732	PRJNA515078_P_NODE_6669_length_362_cov_2.627692_g6436_i0	PRJNA515078	6669	362	2.627692	9.51224504	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	54.7	0.01	NTclustered	gi\|2794881223\|ref\|XM_067906531.1\|	348837	g6436	i0	96.97	0.0911602209944751	33	0	9	1	135	167	1764	1795	Spironucleus salmonicida Tenascin-like protein (SS50377_22645), partial mRNA	blastn	33	54.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
11965562	11965562	PRJNA515078_P_NODE_21570_length_187_cov_1.040000_g21337_i0	PRJNA515078	21570	187	1.04	1.9448	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	73.1	1.23e-8	NTclustered	gi\|2794941302\|ref\|XM_067866739.1\|	2049356	g21337	i0	93.75	9.95187165775401	48	3	26	0	93	140	1176	1129	Monocercomonoides exilis putative Inositol hexakisphosphate and diphosphoinositol-pentakisphosphate kinase (MONOS_13981), partial mRNA	blastn	1861	73.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
12589894	12589894	PRJNA515078_P_NODE_23910_length_177_cov_2.228571_g23677_i0	PRJNA515078	23910	177	2.228571	3.94457067	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	126	8.69e-25	NTclustered	gi\|2587729139\|gb\|OR478975.1\|	56777	g23677	i0	81.29	29.5819209039548	155	29	88	0	16	170	773	619	Trichomonas gallinae elongation factor 1 alpha (EF1A) mRNA, complete cds	blastn	5236	126	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas gallinae
14515721	14515721	PRJNA515078_P_NODE_16952_length_212_cov_1.114286_g16719_i0	PRJNA515078	16952	212	1.114286	2.36228632	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	137	5e-28	NTclustered	gi\|2794959278\|ref\|XM_067867879.1\|	2049356	g16719	i0	81.988	15.3490566037736	161	29	76	0	2	162	75	235	Monocercomonoides exilis Rab11a (MONOS_1503), mRNA	blastn	3254	137	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
14515802	14515802	PRJNA515078_P_NODE_27052_length_167_cov_1.561538_g26819_i0	PRJNA515078	27052	167	1.561538	2.60776846	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	60.2	8.37e-5	NTclustered	gi\|2794953107\|ref\|XM_067865345.1\|	2049356	g26819	i0	92.857	5.65269461077844	42	2	25	1	54	95	9509	9469	Monocercomonoides exilis putative Protein kinase domain (MONOS_12703), partial mRNA	blastn	944	60.2	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
17064214	17064214	PRJNA515078_P_NODE_7454_length_340_cov_1.884488_g7221_i0	PRJNA515078	7454	340	1.884488	6.4072592	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	58.4	6.9e-4	NTclustered	gi\|2794970629\|ref\|XM_067862995.1\|	2049356	g7221	i0	88	0.370588235294118	50	5	14	1	191	239	4081	4032	Monocercomonoides exilis putative Phosphatidylinositol 3,4,5-trisphosphate 3-phosphatase (MONOS_10537), partial mRNA	blastn	126	58.4	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
19612831	19612831	PRJNA515078_P_NODE_16256_length_216_cov_1.960894_g16023_i0	PRJNA515078	16256	216	1.960894	4.23553104	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	56.5	0.001	NTclustered	gi\|2806440984\|ref\|XM_068497330.1\|	1144522	g16023	i0	100	0.138888888888889	30	0	14	0	177	206	242	213	Tritrichomonas foetus uncharacterized protein (TRFO_13569), partial mRNA	blastn	30	56.5	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
22163606	22163606	PRJNA515078_P_NODE_21758_length_186_cov_1.201342_g21525_i0	PRJNA515078	21758	186	1.201342	2.23449612	Paratrimastix eleionoma	1709329	Preaxostyla	other_Eukaryota	63.9	7.35e-6	NTclustered	gi\|2443275711\|gb\|OP718805.1\|	1709329	g21525	i0	97.297	11.9032258064516	37	1	20	0	150	186	2083	2047	Paratrimastix eleionoma DNA replication licensing factor MCM6 mRNA, partial cds	blastn	2214	63.9	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix eleionoma
22163753	22163753	PRJNA515078_P_NODE_8158_length_321_cov_2.570423_g7925_i0	PRJNA515078	8158	321	2.570423	8.25105783	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	52.8	0.03	NTclustered	gi\|2794932896\|ref\|XM_067876231.1\|	2049356	g7925	i0	96.774	0.0965732087227414	31	1	10	0	154	184	3022	2992	Monocercomonoides exilis uncharacterized protein (MONOS_6031), partial mRNA	blastn	31	52.8	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);;