metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB75230" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB75230" and tax_phylum = "Preaxostyla"

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
3963514	3963514	PRJEB75230_P_NODE_5064_length_613_cov_5.055556_g4883_i0	PRJEB75230	5064	613	5.055556	30.99055828	Oxymonadida	66288	Preaxostyla	other_Eukaryota	149	6.75e-39	NR	KAA6395931.1	222440	g4883	i0	56.4	5.18270799347471	140	57	67	2	601	191	296	434	KAA6395931.1 MAG: putative Eukaryotic translation initiation factor 1A [Streblomastix strix]	diamond	3177	150	0.993333333333333	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
9063441	9063441	PRJEB75230_P_NODE_133648_length_249_cov_0.875000_g133466_i0	PRJEB75230	133648	249	0.875	2.17875	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	135	7.059999999999998e-35	NR	KAJ4455623.1	342808	g133466	i0	73.8	2.91566265060241	80	21	96.4	0	248	9	603	682	KAJ4455623.1 putative Serine/threonine-protein kinase ppk5 [Paratrimastix pyriformis]	diamond	726	136	0.992647058823529	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
26615247	26615247	PRJEB75230_P_NODE_1601_length_1023_cov_6.140000_g1466_i0	PRJEB75230	1601	1023	6.14	62.8122	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.5	0.00103	NR	KAJ4458064.1	342808	g1466	i0	27.1	1.55131964809384	236	130	59.2	10	969	364	417	644	KAJ4458064.1 putative nucleoside phosphatase GDA1/CD39 [Paratrimastix pyriformis]	diamond	1587	53.9	0.992578849721707	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
27223655	27223655	PRJEB75230_P_NODE_21963_length_376_cov_1.158416_g21781_i0	PRJEB75230	21963	376	1.158416	4.35564416	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	85.5	1.75e-16	NR	KAJ4461062.1	342808	g21781	i0	33.1	2.02659574468085	127	77	98.9	3	375	4	194	315	KAJ4461062.1 putative Dynein heavy chain 6; axonemal [Paratrimastix pyriformis]	diamond	762	85.5	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28202610	28202610	PRJEB75230_P_NODE_4106_length_674_cov_2.537438_g3930_i0	PRJEB75230	4106	674	2.537438	17.10233212	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	62.4	1.45e-7	NR	ABW76113.1	342808	g3930	i0	27.4	0.79673590504451	179	119	77.9	3	546	22	28	199	ABW76113.1 TOM40, partial [Paratrimastix pyriformis]	diamond	537	62.4	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28234150	28234150	PRJEB75230_P_NODE_8666_length_495_cov_1.490521_g8484_i0	PRJEB75230	8666	495	1.490521	7.37807895	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	134	6.51e-33	NR	XP_067734356.1	2049356	g8484	i0	42.6	3.72121212121212	148	85	89.7	0	494	51	148	295	XP_067734356.1 putative dual specificity protein phosphatase 1 [Monocercomonoides exilis]	diamond	1842	134	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
28360568	28360568	PRJEB75230_P_NODE_70666_length_288_cov_1.306977_g70484_i0	PRJEB75230	70666	288	1.306977	3.76409376	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	43.9	0.0258	NR	XP_067730825.1	2049356	g70484	i0	34.4	0.635416666666667	61	38	63.5	1	54	236	116	174	XP_067730825.1 uncharacterized protein MONOS_3557fu3558 [Monocercomonoides exilis]	diamond	183	43.9	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
30002772	30002772	PRJEB75230_P_NODE_128011_length_250_cov_0.870056_g127829_i0	PRJEB75230	128011	250	0.870056	2.17514	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	48.1	2.28e-4	NR	XP_067730312.1	2049356	g127829	i0	42	1.944	81	44	96	2	242	3	51	129	XP_067730312.1 putative translationally controlled tumor protein [Monocercomonoides exilis]	diamond	486	48.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
32563806	32563806	PRJEB75230_P_NODE_140599_length_247_cov_2.655172_g140417_i0	PRJEB75230	140599	247	2.655172	6.55827484	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	65.1	4.17e-10	NR	XP_067725621.1	2049356	g140417	i0	48.5	0.825910931174089	68	33	82.6	1	9	212	15	80	XP_067725621.1 putative methionyl-tRNA synthetase [Monocercomonoides exilis]	diamond	204	65.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
32588049	32588049	PRJEB75230_P_NODE_26559_length_360_cov_0.926829_g26377_i0	PRJEB75230	26559	360	0.926829	3.3365844	root	1	Root_unresolved	Root_unresolved	49.3	5.85e-4	NR	KAJ4460305.1	342808	g26377	i0	54.1	2.75	37	15	29.2	1	355	251	210	246	KAJ4460305.1 hypothetical protein PAPYR_3312 [Paratrimastix pyriformis]	diamond	990	49.3	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis

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