metadata: contig_metadata: 5 rows where bioproject = "PRJNA345071", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA345071", tax_clade = "Opisthokonta" and tax_phylum = "Microsporidia"

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_kingdom	tax_phylum	tax_family	tax_genus	tax_species
27106204	27106204	PRJNA345071_P_NODE_7542_length_253_cov_1.733333_g7502_i0	PRJNA345071	7542	253	1.733333	4.38533249	Vittaforma corneae ATCC 5	42399	Fungi	Fungi	73.2	6.26e-13	NR	XP_007605348.1	993615	g7502	i0	42.7	1.05533596837945	89	43	96	1	251	9	109	197	XP_007605348.1 uncharacterized protein VICG_01903 [Vittaforma corneae ATCC 50505]	diamond	267	73.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
29569358	29569358	PRJNA345071_P_NODE_6910_length_261_cov_1.723404_g6870_i0	PRJNA345071	6910	261	1.723404	4.49808444	Pancytospora epiphaga	1938578	Fungi	Fungi	110	8.49e-27	NR	KAI5168393.1	1938578	g6870	i0	67.1	0.908045977011494	79	26	90.8	0	259	23	149	227	KAI5168393.1 UDP-N-acetylglucosamine/UDP-N-acetylgalactosamine diphosphorylase [Pancytospora epiphaga]	diamond	237	110	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora epiphaga
29569359	29569359	PRJNA345071_P_NODE_7330_length_256_cov_1.355191_g7290_i0	PRJNA345071	7330	256	1.355191	3.46928896	Pancytospora epiphaga	1938578	Fungi	Fungi	112	1.08e-27	NR	KAI5168393.1	1938578	g7290	i0	64.7	0.99609375	85	30	99.6	0	2	256	243	327	KAI5168393.1 UDP-N-acetylglucosamine/UDP-N-acetylgalactosamine diphosphorylase [Pancytospora epiphaga]	diamond	255	112	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora epiphaga
30232717	30232717	PRJNA345071_P_NODE_9592_length_246_cov_0.901734_g9552_i0	PRJNA345071	9592	246	0.901734	2.21826564	Vittaforma corneae ATCC 5	42399	Fungi	Fungi	142	2.29e-41	NR	XP_007605234.1	993615	g9552	i0	77.8	0.98780487804878	81	18	98.8	0	244	2	51	131	XP_007605234.1 ribosomal protein S19 [Vittaforma corneae ATCC 50505]	diamond	243	142	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
30359608	30359608	PRJNA345071_P_NODE_11312_length_227_cov_2.025974_g11272_i0	PRJNA345071	11312	227	2.025974	4.59896098	Pancytospora epiphaga	1938578	Fungi	Fungi	100	1.66e-22	NR	KAI5171999.1	1938578	g11272	i0	61.3	0.991189427312775	75	29	99.1	0	2	226	334	408	KAI5171999.1 ATP:ADP antiporter, AAA family [Pancytospora epiphaga]	diamond	225	100	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora epiphaga

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