metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Parabasalia"

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
26891596	26891596	PRJNA641707_P_NODE_331141_length_154_cov_2.780952_g328478_i0	PRJNA641707	331141	154	2.780952	4.28266608	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	47	3.41e-4	NR	XP_068350151.1	1144522	g328478	i0	43.1	3.25324675324675	51	28	97.4	1	3	152	182	232	XP_068350151.1 AGC family protein kinase [Tritrichomonas foetus]	diamond	501	47	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
27302615	27302615	PRJNA641707_P_NODE_64943_length_262_cov_7.399061_g62280_i0	PRJNA641707	64943	262	7.399061	19.38553982	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	51.2	3e-5	NR	XP_068348527.1	1144522	g62280	i0	36.9	2.54198473282443	65	37	69.8	1	186	4	42	106	XP_068348527.1 uncharacterized protein TRFO_10524 [Tritrichomonas foetus]	diamond	666	51.2	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
27744781	27744781	PRJNA641707_P_NODE_231584_length_189_cov_10.792857_g228921_i0	PRJNA641707	231584	189	10.792857	20.39849973	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	46.6	8.22e-4	NR	XP_068362926.1	1144522	g228921	i0	39.7	0.920634920634921	58	35	92.1	0	174	1	418	475	XP_068362926.1 uncharacterized protein TRFO_21131 [Tritrichomonas foetus]	diamond	174	46.6	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28597136	28597136	PRJNA641707_P_NODE_240187_length_186_cov_6.131387_g237524_i0	PRJNA641707	240187	186	6.131387	11.40437982	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	53.9	1.96e-6	NR	XP_067773816.1	135588	g237524	i0	42.4	1.90322580645161	59	34	95.2	0	5	181	782	840	XP_067773816.1 putative alpha-actinin [Histomonas meleagridis]	diamond	354	53.9	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
28944678	28944678	PRJNA641707_P_NODE_316628_length_159_cov_4.254545_g313965_i0	PRJNA641707	316628	159	4.254545	6.76472655	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	52.8	3.44e-6	NR	XP_001319262.1	412133	g313965	i0	49	0.924528301886792	49	25	92.5	0	153	7	143	191	XP_001319262.1 protein serine/threonine kinase protein [Trichomonas vaginalis G3]	diamond	147	52.8	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
30270890	30270890	PRJNA641707_P_NODE_143112_length_241_cov_3.635417_g140449_i0	PRJNA641707	143112	241	3.635417	8.76135497	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	46.6	0.00153	NR	XP_068360373.1	1144522	g140449	i0	73.3	1.51867219917012	30	8	37.3	0	92	3	320	349	XP_068360373.1 Copine family protein [Tritrichomonas foetus]	diamond	366	46.6	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
31661226	31661226	PRJNA641707_P_NODE_238137_length_187_cov_4.797101_g235474_i0	PRJNA641707	238137	187	4.797101	8.97057887	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	48.1	1.66e-4	NR	XP_067771334.1	135588	g235474	i0	40	1.25133689839572	45	27	72.2	0	185	51	52	96	XP_067771334.1 YEATS domain-containing protein 4 [Histomonas meleagridis]	diamond	234	48.1	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
32167741	32167741	PRJNA641707_P_NODE_181718_length_200_cov_3.364238_g179055_i0	PRJNA641707	181718	200	3.364238	6.728476	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	44.7	0.0045	NR	XP_001326806.1	412133	g179055	i0	57.9	0.57	38	16	57	0	197	84	695	732	XP_001326806.1 PHOSPHATIDYLINOSITOL KINASE family [Trichomonas vaginalis G3]	diamond	114	44.7	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
32830834	32830834	PRJNA641707_P_NODE_309820_length_161_cov_24.598214_g307157_i0	PRJNA641707	309820	161	24.598214	39.60312454	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	53.9	1.29e-6	NR	XP_068353661.1	1144522	g307157	i0	60	4.99378881987578	40	16	74.5	0	159	40	126	165	XP_068353661.1 Cell division control protein 2 like protein [Tritrichomonas foetus]	diamond	804	53.9	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus

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