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

5 rows where bioproject = "PRJNA473201", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"

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_class	tax_order	tax_family	tax_genus	tax_species
2994324	2994324	PRJNA473201_P_NODE_31543_length_352_cov_1.738351_g30801_i0	PRJNA473201	31543	352	1.738351	6.11899552	Eukaryota	2759	Fungi	Fungi	115	3.39e-30	NR	KAI9221742.1	64508	g30801	i0	50.9	6.78409090909091	114	55	96.3	1	340	2	1	114	KAI9221742.1 profilin [Blastocladiella britannica]	diamond	2388	115	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
9371580	9371580	PRJNA473201_P_NODE_38568_length_322_cov_1.140562_g37826_i0	PRJNA473201	38568	322	1.140562	3.67260964	Eukaryota	2759	Fungi	Fungi	134	3.949999999999999e-37	NR	KAI9183676.1	1313167	g37826	i0	61.2	3.83850931677019	103	39	95	1	307	2	8	110	KAI9183676.1 60S ribosomal protein L9B [Blastocladiella emersonii ATCC 22665]	diamond	1236	135	0.992592592592593	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
15745945	15745945	PRJNA473201_P_NODE_11813_length_586_cov_2.058480_g11076_i0	PRJNA473201	11813	586	2.05848	12.0626928	Fungi	4751	Fungi	Fungi	197	2.78e-61	NR	ORZ32974.1	765915	g11076	i0	68.8	18.8088737201365	141	43	72.2	1	509	87	15	154	ORZ32974.1 eukaryotic translation initiation factor 5A-2, partial [Catenaria anguillulae PL171]	diamond	11022	198	0.994949494949495	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
30960957	30960957	PRJNA473201_P_NODE_45034_length_304_cov_1.333333_g44292_i0	PRJNA473201	45034	304	1.333333	4.05333232	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	149	6.429999999999998e-42	NR	KAI9189134.1	1313167	g44292	i0	79.3	2.72368421052632	92	19	90.8	0	302	27	229	320	KAI9189134.1 60S ribosomal protein L43 [Blastocladiella emersonii ATCC 22665]	diamond	828	149	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
32337245	32337245	PRJNA473201_P_NODE_64679_length_254_cov_1.237569_g63937_i0	PRJNA473201	64679	254	1.237569	3.14342526	Fungi	4751	Fungi	Fungi	58.9	6.01e-9	NR	KAI9141997.1	1500003	g63937	i0	77.1	4.16929133858268	35	8	41.3	0	227	123	73	107	KAI9141997.1 cytochrome c [Paraphysoderma sedebokerense]	diamond	1059	58.9	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense

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