metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1144090" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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
287254	287254	PRJNA1144090_P_NODE_38821_length_415_cov_1.263158_g38286_i0	PRJNA1144090	38821	415	1.263158	5.2421057	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	418	3.419999999999999e-112	NTclustered	gi\|2806461464\|ref\|XM_068504632.1\|	1144522	g38286	i0	84.892	5.48192771084337	417	59	100	4	1	415	864	450	Tritrichomonas foetus Succinyl-CoA ligase [GDP-forming] subunit beta, hydrogenosomal (TRFO_25896), partial mRNA	blastn	2275	418	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
287489	287489	PRJNA1144090_P_NODE_59981_length_328_cov_1.207843_g59446_i0	PRJNA1144090	59981	328	1.207843	3.96172504	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	374	5.8e-99	NTclustered	gi\|2806465181\|ref\|XM_068506041.1\|	1144522	g59446	i0	87.234	3.71951219512195	329	40	100	2	1	328	404	731	Tritrichomonas foetus Phosphoenolpyruvate carboxykinase [GTP] (pckG), partial mRNA	blastn	1220	374	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
2838730	2838730	PRJNA1144090_P_NODE_97043_length_254_cov_1.508287_g96508_i0	PRJNA1144090	97043	254	1.508287	3.83104898	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	209	1.29e-49	NTclustered	gi\|2806457282\|ref\|XM_068503049.1\|	1144522	g96508	i0	85.222	13.7362204724409	203	30	80	0	52	254	2609	2407	Tritrichomonas foetus pyruvate:ferredoxin oxidoreductase A (TRFO_23265), partial mRNA	blastn	3489	209	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
5390101	5390101	PRJNA1144090_P_NODE_113785_length_242_cov_1.810651_g113250_i0	PRJNA1144090	113785	242	1.810651	4.38177542	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	191	4.43e-44	NTclustered	gi\|2794870058\|ref\|XM_067918235.1\|	135588	g113250	i0	81.938	10.7231404958678	227	39	93	2	17	242	960	735	Histomonas meleagridis glyceraldehyde-3-phosphate dehydrogenase (GO595_005036), partial mRNA	blastn	2595	191	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
6665550	6665550	PRJNA1144090_P_NODE_73226_length_295_cov_2.081081_g72691_i0	PRJNA1144090	73226	295	2.081081	6.13918895	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	309	1.4700000000000002e-79	NTclustered	gi\|2806461050\|ref\|XM_068492593.1\|	1144522	g72691	i0	86.525	1.95932203389831	282	36	95	2	15	295	296	16	Tritrichomonas foetus Fructose-bisphosphate aldolase (fba), partial mRNA	blastn	578	309	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
7940512	7940512	PRJNA1144090_P_NODE_54647_length_344_cov_1.704797_g54112_i0	PRJNA1144090	54647	344	1.704797	5.86450168	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	464	3.53e-126	NTclustered	gi\|2806440582\|ref\|XM_068497248.1\|	1144522	g54112	i0	91.202	7.31976744186047	341	30	99	0	2	342	1385	1045	Tritrichomonas foetus Phosphoenolpyruvate carboxykinase [GTP] (pckG), partial mRNA	blastn	2518	464	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
10491089	10491089	PRJNA1144090_P_NODE_57129_length_336_cov_1.874525_g56594_i0	PRJNA1144090	57129	336	1.874525	6.298404	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	52.8	0.032	NTclustered	gi\|2794889849\|ref\|XM_067922471.1\|	135588	g56594	i0	100	0.0833333333333333	28	0	8	0	25	52	1480	1453	Histomonas meleagridis uncharacterized protein (GO595_008851), partial mRNA	blastn	28	52.8	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
10491534	10491534	PRJNA1144090_P_NODE_96709_length_254_cov_2.348066_g96174_i0	PRJNA1144090	96709	254	2.348066	5.96408764	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	235	2.13e-57	NTclustered	gi\|2806480089\|ref\|XM_068495024.1\|	1144522	g96174	i0	83.665	2.21653543307087	251	39	98	2	5	254	264	15	Tritrichomonas foetus glyceraldehyde-3-phosphate dehydrogenase (TRFO_09724), partial mRNA	blastn	563	235	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
14316469	14316469	PRJNA1144090_P_NODE_61932_length_322_cov_2.666667_g61397_i0	PRJNA1144090	61932	322	2.666667	8.58666774	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	237	7.770000000000001e-58	NTclustered	gi\|2806463802\|ref\|XM_068505514.1\|	1144522	g61397	i0	81.395	0.934782608695652	301	46	92	9	18	313	1394	1099	Tritrichomonas foetus Alpha-galactosidase (TRFO_27390), partial mRNA	blastn	301	237	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
16864800	16864800	PRJNA1144090_P_NODE_75814_length_290_cov_1.419355_g75279_i0	PRJNA1144090	75814	290	1.419355	4.1161295	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	54.7	0.007	NTclustered	gi\|2806466589\|ref\|XM_068506502.1\|	1144522	g75279	i0	100	0.2	29	0	10	0	216	244	639	611	Tritrichomonas foetus uncharacterized protein (TRFO_28985), partial mRNA	blastn	58	54.7	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
19413082	19413082	PRJNA1144090_P_NODE_21856_length_578_cov_2.011881_g21331_i0	PRJNA1144090	21856	578	2.011881	11.62867218	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	833	0	NTclustered	gi\|2806483296\|ref\|XM_068490526.1\|	1144522	g21331	i0	92.734	74.9515570934256	578	41	100	1	1	578	903	327	Tritrichomonas foetus actin (TRFO_02171), partial mRNA	blastn	43322	833	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
21963722	21963722	PRJNA1144090_P_NODE_117618_length_238_cov_2.175758_g117083_i0	PRJNA1144090	117618	238	2.175758	5.17830404	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	52.8	0.021	NTclustered	gi\|2806460906\|ref\|XM_068504438.1\|	1144522	g117083	i0	100	0.117647058823529	28	0	12	0	196	223	5453	5480	Tritrichomonas foetus F/Y-rich N-terminus family protein (TRFO_25561), partial mRNA	blastn	28	52.8	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
24513738	24513738	PRJNA1144090_P_NODE_91820_length_262_cov_1.222222_g91285_i0	PRJNA1144090	91820	262	1.222222	3.20222164	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	219	2.2299999999999994e-52	NTclustered	gi\|2794861428\|ref\|XM_067923167.1\|	135588	g91285	i0	81.818	1.00763358778626	264	44	100	4	1	262	406	145	Histomonas meleagridis succinate-CoA ligase (GO595_000947), partial mRNA	blastn	264	219	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis

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