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

5 rows where bioproject = "PRJNA938397", tax_clade = "Opisthokonta" 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
11117106	11117106	PRJNA938397_S_NODE_39169_length_175_cov_19.159420_g38928_i0	PRJNA938397	39169	175	19.15942	33.528985	Serpula lacrymans	85982	Fungi	Fungi	287	3.71e-73	NTclustered	gi\|27529064\|emb\|AJ536022.1\|	85982	g38928	i0	100	88.6457142857143	155	0	89	0	4	158	967	1121	Serpula lacrymans 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate S7	blastn	15513	287	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Serpulaceae	Serpula	Serpula lacrymans
18764863	18764863	PRJNA938397_S_NODE_31795_length_195_cov_11.594937_g31554_i0	PRJNA938397	31795	195	11.594937	22.61012715	Eukaryota	2759	Fungi	Fungi	98.2	9.44e-24	NR	KAH9818285.1	2182807	g31554	i0	75.4	11.4	57	14	87.7	0	193	23	138	194	KAH9818285.1 peptidyl-prolyl cis-trans isomerase [Melampsora americana]	diamond	2223	99	0.991919191919192	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Melampsoraceae	Melampsora	Melampsora americana
26866988	26866988	PRJNA938397_S_NODE_16341_length_271_cov_37.897436_g16100_i0	PRJNA938397	16341	271	37.897436	102.70205156	Taiwanofungus camphoratus	2696576	Fungi	Fungi	75.1	2.16e-13	NR	KAI0940986.1	2696576	g16100	i0	51.7	9.03321033210332	60	28	65.3	1	4	180	571	630	KAI0940986.1 hypothetical protein AcV7_003214 [Taiwanofungus camphoratus]	diamond	2448	75.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Taiwanofungaceae	Taiwanofungus	Taiwanofungus camphoratus
26961539	26961539	PRJNA938397_S_NODE_19362_length_250_cov_377.169014_g19121_i0	PRJNA938397	19362	250	377.169014	942.922535	Puccinia striiformis f. sp. tritici	168172	Fungi	Fungi	47.4	1.05e-4	NR	XP_047797933.1	168172	g19121	i0	82.1	0.672	28	5	33.6	0	190	107	54	81	XP_047797933.1 hypothetical protein Pst134EA_028829 [Puccinia striiformis f. sp. tritici]	diamond	168	47.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia striiformis
27474428	27474428	PRJNA938397_S_NODE_25403_length_219_cov_3.736264_g25162_i0	PRJNA938397	25403	219	3.736264	8.18241816	Opisthokonta	33154	Fungi	Fungi	64.3	6.28e-10	NR	KAJ7756794.1	230809	g25162	i0	49	10.3013698630137	49	25	67.1	0	203	57	347	395	KAJ7756794.1 hypothetical protein DFH07DRAFT_742478 [Mycena maculata]	diamond	2256	64.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena maculata

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