metadata: contig_metadata: 5 rows where bioproject = "PRJEB28062", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJEB28062", tax_kingdom = "Fungi" 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
2573715	2573715	PRJEB28062_P_NODE_118423_length_264_cov_4.115183_g116060_i0	PRJEB28062	118423	264	4.115183	10.86408312	Mitosporidium daphniae	1485682	Fungi	Fungi	107	8.05e-25	NR	XP_013237023.1	1485682	g116060	i0	77.8	0.715909090909091	63	14	71.6	0	190	2	180	242	XP_013237023.1 uncharacterized protein DI09_63p200 [Mitosporidium daphniae]	diamond	189	107	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
16602375	16602375	PRJEB28062_P_NODE_80594_length_375_cov_3.500000_g78232_i0	PRJEB28062	80594	375	3.5	13.125	Ecytonucleospora nucleophila	1295219	Fungi	Fungi	497	3.81e-136	NTclustered	gi\|529283990\|gb\|KF135643.1\|	1295219	g78232	i0	91.854	86.3306666666667	356	29	95	0	2	357	359	4	Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence	blastn	32374	497	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora nucleophila
25213555	25213555	PRJEB28062_P_NODE_39160_length_582_cov_4.860511_g36829_i0	PRJEB28062	39160	582	4.860511	28.28817402	Fungi	4751	Fungi	Fungi	183	1.95e-41	NTclustered	gi\|1378896647\|gb\|MF278562.1\|	1485682	g36829	i0	95.652	20.6821305841924	115	4	20	1	295	409	5537	5650	Mitosporidium daphniae strain UGP3 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	12037	183	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
26969782	26969782	PRJEB28062_P_NODE_107182_length_294_cov_2.099548_g104819_i0	PRJEB28062	107182	294	2.099548	6.17267112	Edhazardia aedis USNM 41457	1003232	Fungi	Fungi	142	9.709999999999998e-42	NR	EJW01602.1	1003232	g104819	i0	71.4	0.928571428571429	91	26	92.9	0	279	7	1	91	EJW01602.1 ribosomal protein L37a [Edhazardia aedis USNM 41457]	diamond	273	142	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
29401611	29401611	PRJEB28062_P_NODE_107389_length_293_cov_6.604545_g105026_i0	PRJEB28062	107389	293	6.604545	19.35131685	Enteropsectra breve	1912989	Fungi	Fungi	81.6	1.14e-15	NR	KAI5147993.1	1912989	g105026	i0	52.4	0.860068259385666	84	40	86	0	270	19	84	167	KAI5147993.1 STE24 endopeptidase [Enteropsectra breve]	diamond	252	81.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Enteropsectra	Enteropsectra breve

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