metadata: contig_metadata: 7 rows where bioproject = "PRJNA807836" and tax

7 rows where bioproject = "PRJNA807836" 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
807124	807124	PRJNA807836_S_NODE_23761_length_275_cov_1.826733_g23485_i0	PRJNA807836	23761	275	1.826733	5.02351575	Sporisorium graminicola	280036	Fungi	Fungi	60.2	1.51e-4	NTclustered	gi\|1701856799\|ref\|XM_029886318.1\|	280036	g23485	i0	100	8.21090909090909	32	0	12	0	130	161	2293	2324	Sporisorium graminicola uncharacterized protein (EX895_005726), partial mRNA	blastn	2258	60.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Sporisorium	Sporisorium graminicola
2082956	2082956	PRJNA807836_S_NODE_27802_length_250_cov_0.870056_g27526_i0	PRJNA807836	27802	250	0.870056	2.17514	Melampsora laricis-populina	203908	Fungi	Fungi	444	3.1999999999999986e-120	NTclustered	gi\|599373429\|ref\|XM_007407306.1\|	747676	g27526	i0	98.8	1	250	2	100	1	1	250	1420	1172	Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_47456), partial mRNA	blastn	250	444	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Melampsoraceae	Melampsora	Melampsora laricis-populina
13560764	13560764	PRJNA807836_S_NODE_23091_length_280_cov_1.483092_g22815_i0	PRJNA807836	23091	280	1.483092	4.1526576	Heterobasidion irregulare	984962	Fungi	Fungi	65.8	3.31e-6	NTclustered	gi\|695572815\|ref\|XM_009553142.1\|	747525	g22815	i0	100	20.9642857142857	35	0	13	0	192	226	701	735	Heterobasidion irregulare TC 32-1 glyoxal oxidase 5 (glox5), partial mRNA	blastn	5870	65.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Bondarzewiaceae	Heterobasidion	Heterobasidion irregulare
25033606	25033606	PRJNA807836_S_NODE_23860_length_274_cov_2.288557_g23584_i0	PRJNA807836	23860	274	2.288557	6.27064618	Rhodotorula toruloides	5286	Fungi	Fungi	58.4	5.41e-4	NTclustered	gi\|1022851889\|ref\|XM_016415630.1\|	1130832	g23584	i0	97.059	0.124087591240876	34	1	12	0	136	169	446	479	Rhodotorula toruloides NP11 RNA recognition motif domain containing protein (RHTO_01951), partial mRNA	blastn	34	58.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula toruloides
28222605	28222605	PRJNA807836_S_NODE_15686_length_353_cov_1.560714_g15410_i0	PRJNA807836	15686	353	1.560714	5.50932042	Puccinia striiformis	27350	Fungi	Fungi	66.2	7.18e-10	NR	POW19195.1	27350	g15410	i0	47.9	1.19830028328612	71	36	59.5	1	211	2	112	182	POW19195.1 hypothetical protein PSHT_04931 [Puccinia striiformis]	diamond	423	66.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia striiformis
28443972	28443972	PRJNA807836_S_NODE_26946_length_253_cov_1.333333_g26670_i0	PRJNA807836	26946	253	1.333333	3.37333249	Piloderma croceum F 1598	765440	Fungi	Fungi	44.3	0.0122	NR	KIM73463.1	765440	g26670	i0	33.8	0.806324110671937	68	44	80.6	1	25	228	376	442	KIM73463.1 hypothetical protein PILCRDRAFT_15204 [Piloderma croceum F 1598]	diamond	204	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Atheliales	Atheliaceae	Piloderma	Piloderma croceum
30157605	30157605	PRJNA807836_S_NODE_21492_length_293_cov_1.050000_g21216_i0	PRJNA807836	21492	293	1.05	3.0765	Russulales	452342	Fungi	Fungi	48.9	4.21e-4	NR	KAI0060165.1	48021	g21216	i0	46.7	9.48122866894198	75	30	66.6	2	40	234	126	200	KAI0060165.1 NAD-malate dehydrogenase [Artomyces pyxidatus]	diamond	2778	48.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Auriscalpiaceae	Artomyces	Artomyces pyxidatus

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