metadata: contig_metadata: 8 rows where bioproject = "PRJNA645397" and tax

8 rows where bioproject = "PRJNA645397" and tax_phylum = "Basidiomycota"

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
4447333	4447333	PRJNA645397_P_NODE_4504_length_250_cov_1.034826_g4431_i0	PRJNA645397	4504	250	1.034826	2.587065	Malassezia restricta	76775	Fungi	Fungi	403	5.43e-108	NTclustered	gi\|1546631533\|ref\|XM_027627427.1\|	76775	g4431	i0	99.107	1.124	224	2	90	0	27	250	1089	1312	Malassezia restricta carbamoyl-phosphate synthase small subunit (MRET_0800), partial mRNA	blastn	281	403	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
4987460	4987460	PRJNA645397_P_NODE_10904_length_162_cov_1.601770_g10831_i0	PRJNA645397	10904	162	1.60177	2.5948674	Basidiomycota	5204	Fungi	Fungi	243	7.45e-60	NTclustered	gi\|92111142\|gb\|DQ459616.1\|	5003	g10831	i0	99.254	82.7160493827161	134	1	83	0	1	134	210	77	Sporidiobolus pararoseus isolate C44 18S small subunit ribosomal RNA gene, partial sequence	blastn	13400	243	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces pararoseus
8272830	8272830	PRJNA645397_P_NODE_10487_length_164_cov_0.904348_g10414_i0	PRJNA645397	10487	164	0.904348	1.48313072	Schizophyllum commune	5334	Fungi	Fungi	224	2.74e-54	NTclustered	gi\|10179764\|gb\|AF249362.1\|AF249362	5334	g10414	i0	97.692	4.05487804878049	130	3	79	0	34	163	8	137	Schizophyllum commune strain 1-82 intergenic spacer 2, partial sequence	blastn	665	224	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Schizophyllaceae	Schizophyllum	Schizophyllum commune
10823836	10823836	PRJNA645397_P_NODE_5889_length_215_cov_0.939759_g5816_i0	PRJNA645397	5889	215	0.939759	2.02048185	Malassezia restricta	76775	Fungi	Fungi	152	1.82e-32	NTclustered	gi\|1546632462\|ref\|XM_027627891.1\|	76775	g5816	i0	98.824	0.395348837209302	85	1	40	0	131	215	1917	1833	Malassezia restricta heat shock 70kDa protein 1/2/6/8 (MRET_1264), partial mRNA	blastn	85	152	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
13373641	13373641	PRJNA645397_P_NODE_10971_length_162_cov_0.920354_g10898_i0	PRJNA645397	10971	162	0.920354	1.49097348	Schizophyllum commune Loenen D	1314666	Fungi	Fungi	56.2	2.12e-7	NR	KAI4524343.1	1314666	g10898	i0	86.7	0.555555555555556	30	4	55.6	0	27	116	1101	1130	KAI4524343.1 hypothetical protein K525DRAFT_194188 [Schizophyllum commune Loenen D]	diamond	90	56.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Schizophyllaceae	Schizophyllum	Schizophyllum commune
28565578	28565578	PRJNA645397_P_NODE_10547_length_164_cov_0.904348_g10474_i0	PRJNA645397	10547	164	0.904348	1.48313072	Ceratobasidium sp. 414	2600205	Fungi	Fungi	62.4	1.48e-9	NR	KAG8739150.1	2600205	g10474	i0	56.6	0.969512195121951	53	23	97	0	4	162	61	113	KAG8739150.1 hypothetical protein FRC10_006097 [Ceratobasidium sp. 414]	diamond	159	62.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Ceratobasidium	Ceratobasidium sp. 414
28597314	28597314	PRJNA645397_P_NODE_8507_length_176_cov_1.338583_g8434_i0	PRJNA645397	8507	176	1.338583	2.35590608	Irpex rosettiformis	378272	Fungi	Fungi	50.8	2.09e-5	NR	KAI0085989.1	378272	g8434	i0	91.3	1.3125	23	2	39.2	0	31	99	285	307	KAI0085989.1 general substrate transporter [Irpex rosettiformis]	diamond	231	50.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Irpicaceae	Irpex	Irpex rosettiformis
29260038	29260038	PRJNA645397_P_NODE_9389_length_168_cov_1.084034_g9316_i0	PRJNA645397	9389	168	1.084034	1.82117712	Phenoliferia sp. Uapishka_3	3038894	Fungi	Fungi	62.4	1.54e-9	NR	KAK4702147.1	3038894	g9316	i0	56.4	0.982142857142857	55	3	98.2	1	2	166	394	427	KAK4702147.1 amidase, partial [Phenoliferia sp. Uapishka_3]	diamond	165	62.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Kriegeriales	Kriegeriaceae	Phenoliferia	Phenoliferia sp. Uapishka_3

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