metadata: contig_metadata: 10 rows where bioproject = "PRJNA638138", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJNA638138", tax_kingdom = "Fungi" 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
7533024	7533024	PRJNA638138_P_NODE_11886_length_310_cov_1.502110_g11671_i0	PRJNA638138	11886	310	1.50211	4.656541	Peniophora	40463	Fungi	Fungi	556	5.03e-154	NTclustered	gi\|480327002\|gb\|JX507725.1\|	1321910	g11671	i0	99.032	104.98064516129	310	3	100	0	1	310	1834	1525	Peniophora sp. 213 OA-2013 large subunit ribosomal RNA gene, partial sequence	blastn	32544	556	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Peniophoraceae	Peniophora	Peniophora sp. 213 OA-2013
10083711	10083711	PRJNA638138_P_NODE_16608_length_269_cov_2.617347_g16393_i0	PRJNA638138	16608	269	2.617347	7.04066343	Opisthokonta	33154	Fungi	Fungi	497	2.63e-136	NTclustered	gi\|915512607\|gb\|KP825390.1\|	76775	g16393	i0	100	100.211895910781	269	0	100	0	1	269	246	514	Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence	blastn	26957	497	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
12088913	12088913	PRJNA638138_P_NODE_35270_length_241_cov_0.916667_g35055_i0	PRJNA638138	35270	241	0.916667	2.20916747	Stereum hirsutum	40492	Fungi	Fungi	196	9.47e-46	NTclustered	gi\|618815844\|ref\|XM_007310458.1\|	721885	g35055	i0	81.526	1.03319502074689	249	37	99	7	1	240	1165	917	Stereum hirsutum FP-91666 SS1 uncharacterized protein (STEHIDRAFT_125940), mRNA	blastn	249	196	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
19736172	19736172	PRJNA638138_P_NODE_28416_length_245_cov_0.895349_g28201_i0	PRJNA638138	28416	245	0.895349	2.19360505	Puccinia striiformis	27350	Fungi	Fungi	448	2.41e-121	NTclustered	gi\|2234886149\|ref\|XM_047944131.1\|	168172	g28201	i0	99.592	1	245	1	100	0	1	245	1375	1131	Puccinia striiformis f. sp. tritici uncharacterized protein (Pst134EA_007722), mRNA	blastn	245	448	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia striiformis
20281610	20281610	PRJNA638138_P_NODE_12356_length_305_cov_3.025862_g12141_i0	PRJNA638138	12356	305	3.025862	9.2288791	Malassezia	55193	Fungi	Fungi	564	2.95e-156	NTclustered	gi\|915512619\|gb\|KP825402.1\|	76775	g12141	i0	100	97.3606557377049	305	0	100	0	1	305	311	7	Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence	blastn	29695	564	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
22832693	22832693	PRJNA638138_P_NODE_33558_length_242_cov_0.911243_g33343_i0	PRJNA638138	33558	242	0.911243	2.20520806	Malassezia	55193	Fungi	Fungi	448	2.3799999999999995e-121	NTclustered	gi\|1321659621\|gb\|KY911094.1\|	76775	g33343	i0	100	91.3347107438017	242	0	100	0	1	242	774	533	Malassezia restricta mitochondrion, complete genome	blastn	22103	448	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
24107133	24107133	PRJNA638138_P_NODE_12499_length_304_cov_1.194805_g12284_i0	PRJNA638138	12499	304	1.194805	3.6322072	Basidiomycota	5204	Fungi	Fungi	556	4.919999999999999e-154	NTclustered	gi\|406205\|dbj\|D12803.1\|ERHSSRD3	5414	g12284	i0	99.671	99.9934210526316	304	1	100	0	1	304	1115	812	Erythrobasidium hasegawianum gene for small subunit ribosomal RNA	blastn	30398	556	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Erythrobasidiales	Erythrobasidiaceae	Erythrobasidium	Erythrobasidium hasegawianum
27143802	27143802	PRJNA638138_P_NODE_14202_length_289_cov_0.912037_g13987_i0	PRJNA638138	14202	289	0.912037	2.63578693	Sphagnurus paluster	117069	Fungi	Fungi	44.3	0.0186	NR	KAG5653515.1	117069	g13987	i0	35.6	0.757785467128028	73	45	75.8	1	257	39	599	669	KAG5653515.1 hypothetical protein H0H81_012588 [Sphagnurus paluster]	diamond	219	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Lyophyllaceae	Sphagnurus	Sphagnurus paluster
27681567	27681567	PRJNA638138_P_NODE_26624_length_247_cov_0.885057_g26409_i0	PRJNA638138	26624	247	0.885057	2.18609079	Rhizoctonia solani	456999	Fungi	Fungi	55.1	1.77e-6	NR	CAE6460460.1	456999	g26409	i0	37.9	1.59109311740891	58	35	69.2	1	208	38	540	597	CAE6460460.1 unnamed protein product [Rhizoctonia solani]	diamond	393	55.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
31692851	31692851	PRJNA638138_P_NODE_32677_length_243_cov_0.905882_g32462_i0	PRJNA638138	32677	243	0.905882	2.20129326	Austropuccinia psidii	181123	Fungi	Fungi	45.8	0.00308	NR	MBW0524523.1	1389203	g32462	i0	52.9	0.827160493827161	34	16	42	0	3	104	1402	1435	MBW0524523.1 hypothetical protein [Austropuccinia psidii MF-1]	diamond	201	45.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Sphaerophragmiaceae	Austropuccinia	Austropuccinia psidii

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