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

9 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
2727819	2727819	PRJNA1059246_P_NODE_59063_length_260_cov_0.973262_g58437_i0	PRJNA1059246	59063	260	0.973262	2.5304812	Trichomonas vaginalis	5722	Parabasalia	other_Eukaryota	65.8	3.04e-6	NTclustered	gi\|2319615616\|ref\|XR_007835995.1\|	412133	g58437	i0	90.385	0.896153846153846	52	2	20	3	44	94	2561	2610	Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0034210), rRNA	blastn	233	65.8	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
9104645	9104645	PRJNA1059246_P_NODE_36128_length_358_cov_1.466667_g35502_i0	PRJNA1059246	36128	358	1.466667	5.25066786	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	76.8	2.01e-9	NTclustered	gi\|2794977061\|ref\|XM_067879212.1\|	2049356	g35502	i0	95.745	0.304469273743017	47	2	13	0	28	74	14314	14268	Monocercomonoides exilis putative Dual specificity phosphatase, catalytic domain (MONOS_8775), partial mRNA	blastn	109	76.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
10380202	10380202	PRJNA1059246_P_NODE_25049_length_447_cov_0.909091_g24425_i0	PRJNA1059246	25049	447	0.909091	4.06363677	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	62.1	7.19e-5	NTclustered	gi\|2794973403\|ref\|XM_067868234.1\|	2049356	g24425	i0	100	3.12751677852349	33	0	7	0	114	146	4429	4461	Monocercomonoides exilis putative cilia- and flagella-associated protein 61 (MONOS_15367), partial mRNA	blastn	1398	62.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
12930919	12930919	PRJNA1059246_P_NODE_51971_length_283_cov_1.466667_g51345_i0	PRJNA1059246	51971	283	1.466667	4.15066761	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	87.9	7.16e-13	NTclustered	gi\|2794934026\|ref\|XM_067868389.1\|	2049356	g51345	i0	100	16.5194346289753	47	0	17	0	129	175	3798	3752	Monocercomonoides exilis putative 200 kDa antigen p200 (MONOS_15506), partial mRNA	blastn	4675	87.9	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
12931191	12931191	PRJNA1059246_P_NODE_8391_length_838_cov_1.690196_g7880_i0	PRJNA1059246	8391	838	1.690196	14.16384248	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	60.2	5.04e-4	NTclustered	gi\|2794958551\|ref\|XM_067864120.1\|	2049356	g7880	i0	100	0.0787589498806683	32	0	4	0	574	605	516	485	Monocercomonoides exilis putative Protein kinase superfamily protein (MONOS_11579), mRNA	blastn	66	60.2	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
15479534	15479534	PRJNA1059246_P_NODE_12513_length_671_cov_2.096990_g11933_i0	PRJNA1059246	12513	671	2.09699	14.0708029	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	60.2	4e-4	NTclustered	gi\|2806485064\|ref\|XM_068512624.1\|	1144522	g11933	i0	100	0.0476900149031297	32	0	5	0	163	194	1091	1060	Tritrichomonas foetus Myb-like DNA-binding domain containing protein (TRFO_39406), partial mRNA	blastn	32	60.2	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
19302902	19302902	PRJNA1059246_P_NODE_47936_length_298_cov_1.368889_g47310_i0	PRJNA1059246	47936	298	1.368889	4.07928922	Trichomonas vaginalis	5722	Parabasalia	other_Eukaryota	67.6	9.89e-7	NTclustered	gi\|123414015\|ref\|XM_001304398.1\|	412133	g47310	i0	87.931	0.815436241610738	58	6	19	1	192	249	1323	1379	Trichomonas vaginalis G3 protein ubiquitination (TVAGG3_0883850), partial mRNA	blastn	243	67.6	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
20577776	20577776	PRJNA1059246_P_NODE_10957_length_725_cov_3.016871_g10400_i0	PRJNA1059246	10957	725	3.016871	21.87231475	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	60.2	4.34e-4	NTclustered	gi\|2794970009\|ref\|XM_067877330.1\|	2049356	g10400	i0	88.235	0.0703448275862069	51	4	7	2	253	301	3253	3203	Monocercomonoides exilis DNA repair endonuclease XPF (MONOS_7037), partial mRNA	blastn	51	60.2	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
24403371	24403371	PRJNA1059246_P_NODE_66600_length_247_cov_0.879310_g65974_i0	PRJNA1059246	66600	247	0.87931	2.1718957	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	58.4	4.8e-4	NTclustered	gi\|2794962548\|ref\|XM_067873683.1\|	2049356	g65974	i0	94.595	12.5263157894737	37	2	15	0	80	116	5209	5245	Monocercomonoides exilis putative RNA recognition motif domain containing protein (MONOS_3669), partial mRNA	blastn	3094	58.4	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);;