metadata: contig_metadata: 10 rows where bioproject = "PRJNA911178", tax_phylum = "Preaxostyla" and tax

10 rows where bioproject = "PRJNA911178", tax_phylum = "Preaxostyla" and tax_superkingdom = "Eukaryota"

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
26898019	26898019	PRJNA911178_P_NODE_295121_length_241_cov_0.910714_g292647_i0	PRJNA911178	295121	241	0.910714	2.19482074	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	49.7	8.71e-5	NR	XP_067734950.1	2049356	g292647	i0	41.2	1.71784232365145	68	35	84.6	2	9	212	32	94	XP_067734950.1 putative doublecortin domain-containing protein [Monocercomonoides exilis]	diamond	414	49.7	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
28161693	28161693	PRJNA911178_P_NODE_225785_length_258_cov_1.497297_g223311_i0	PRJNA911178	225785	258	1.497297	3.86302626	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	42.7	0.0462	NR	XP_067721850.1	2049356	g223311	i0	39.1	0.534883720930233	46	28	53.5	0	239	102	96	141	XP_067721850.1 uncharacterized protein MONOS_8462 [Monocercomonoides exilis]	diamond	138	42.7	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
28263470	28263470	PRJNA911178_P_NODE_249946_length_249_cov_1.363636_g247472_i0	PRJNA911178	249946	249	1.363636	3.39545364	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	73.6	5.59e-13	NR	KAK3118037.1	342808	g247472	i0	55	5.45783132530121	60	27	72.3	0	12	191	343	402	KAK3118037.1 AP-3 complex subunit delta [Paratrimastix pyriformis]	diamond	1359	73.6	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28761332	28761332	PRJNA911178_P_NODE_41527_length_533_cov_3.526087_g39116_i0	PRJNA911178	41527	533	3.526087	18.79404371	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	61.2	2.85e-7	NR	KAJ4462339.1	342808	g39116	i0	30.1	0.9906191369606	176	96	93.4	7	20	517	274	432	KAJ4462339.1 putative tenascin precursor [Paratrimastix pyriformis]	diamond	528	61.2	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30213934	30213934	PRJNA911178_P_NODE_295612_length_240_cov_2.766467_g293138_i0	PRJNA911178	295612	240	2.766467	6.6395208	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	80.1	2.54e-16	NR	KAJ4456542.1	342808	g293138	i0	60	1.475	60	24	75	0	189	10	39	98	KAJ4456542.1 putative dCTP deaminase [Paratrimastix pyriformis]	diamond	354	80.1	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
31098609	31098609	PRJNA911178_P_NODE_72915_length_413_cov_14.408824_g70452_i0	PRJNA911178	72915	413	14.408824	59.50844312	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	66.6	3.91e-11	NR	KAJ4453711.1	342808	g70452	i0	51.6	1.00968523002421	64	29	46.5	1	344	153	4	65	KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis]	diamond	417	66.6	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
31129980	31129980	PRJNA911178_P_NODE_16155_length_833_cov_4.344737_g14133_i0	PRJNA911178	16155	833	4.344737	36.19165921	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	50.1	0.0094	NR	KAJ4462339.1	342808	g14133	i0	24.7	0.58343337334934	162	108	58.3	2	572	87	454	601	KAJ4462339.1 putative tenascin precursor [Paratrimastix pyriformis]	diamond	486	50.1	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
32364147	32364147	PRJNA911178_P_NODE_167979_length_290_cov_1.396313_g165506_i0	PRJNA911178	167979	290	1.396313	4.0493077	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	74.3	2.15e-13	NR	XP_067735828.1	2049356	g165506	i0	55.6	0.744827586206897	72	27	74.5	2	75	290	177	243	XP_067735828.1 putative cathepsin B6 cysteine protease [Monocercomonoides exilis]	diamond	216	74.3	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
32522460	32522460	PRJNA911178_P_NODE_16279_length_830_cov_4.554822_g14254_i0	PRJNA911178	16279	830	4.554822	37.8050226	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	73.9	9.56e-11	NR	KAJ4454930.1	342808	g14254	i0	31.3	0.751807228915663	208	116	71.9	11	681	85	429	618	KAJ4454930.1 putative Ectonucleoside triphosphate diphosphohydrolase 3 [Paratrimastix pyriformis]	diamond	624	73.9	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
32805734	32805734	PRJNA911178_P_NODE_296980_length_238_cov_2.812121_g294506_i0	PRJNA911178	296980	238	2.812121	6.69284798	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	81.6	1.96e-16	NR	KAK2963470.1	2049346	g294506	i0	55.1	8.16806722689076	69	29	87	2	31	237	187	253	KAK2963470.1 putative Cathepsin B [Blattamonas nauphoetae]	diamond	1944	81.6	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae

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