metadata: contig_metadata: 5 rows where bioproject = "PRJNA797475" and tax

5 rows where bioproject = "PRJNA797475" 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
29327473	29327473	PRJNA797475_P_NODE_7469_length_374_cov_1.508306_g7370_i0	PRJNA797475	7469	374	1.508306	5.64106444	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	68.2	1.13e-10	NR	XP_067719831.1	2049356	g7370	i0	37.8	0.657754010695187	82	50	65	1	77	319	55	136	XP_067719831.1 putative protein YIPF1/2 [Monocercomonoides exilis]	diamond	246	68.2	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
30599991	30599991	PRJNA797475_P_NODE_13273_length_294_cov_2.000000_g13174_i0	PRJNA797475	13273	294	2	5.88	root	1	Root_unresolved	Root_unresolved	108	1.26e-28	NR	KAA6379614.1	222440	g13174	i0	57.3	3.54081632653061	89	38	90.8	0	292	26	5	93	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	1041	108	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
31918831	31918831	PRJNA797475_P_NODE_12497_length_302_cov_1.344978_g12398_i0	PRJNA797475	12497	302	1.344978	4.06183356	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	43.5	0.0421	NR	KAJ4462339.1	342808	g12398	i0	36.7	0.596026490066225	60	30	55.6	2	5	172	335	390	KAJ4462339.1 putative tenascin precursor [Paratrimastix pyriformis]	diamond	180	43.5	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
31927889	31927889	PRJNA797475_P_NODE_20477_length_255_cov_1.615385_g20378_i0	PRJNA797475	20477	255	1.615385	4.11923175	root	1	Root_unresolved	Root_unresolved	107	3.1699999999999998e-28	NR	KAA6379614.1	222440	g20378	i0	58.8	1.98823529411765	85	35	100	0	255	1	5	89	KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix]	diamond	507	108	0.990740740740741	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
32267071	32267071	PRJNA797475_P_NODE_22338_length_250_cov_0.870056_g22239_i0	PRJNA797475	22338	250	0.870056	2.17514	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	128	2.0800000000000002e-36	NR	KAK2957131.1	2049346	g22239	i0	74.7	1.884	79	20	94.8	0	247	11	32	110	KAK2957131.1 putative Peptidyl-prolyl cis-trans isomerase FKBP12 [Blattamonas nauphoetae]	diamond	471	128	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);;