metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA229468" 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
27042401	27042401	PRJNA229468_S_NODE_282_length_296_cov_1.238866_g269_i0	PRJNA229468	282	296	1.238866	3.66704336	Sistotremastrum suecicum HHB1	467971	Fungi	Fungi	127	4.48e-33	NR	KZT36194.1	1314776	g269	i0	59.4	0.972972972972973	96	37	97.3	1	290	3	29	122	KZT36194.1 GroES-like protein [Sistotremastrum suecicum HHB10207 ss-3]	diamond	288	127	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Sistotremastrales	Sistotremastraceae	Sistotremastrum	Sistotremastrum suecicum
27154543	27154543	PRJNA229468_S_NODE_762_length_189_cov_1.092857_g749_i0	PRJNA229468	762	189	1.092857	2.06549973	Agaricomycetes	155619	Fungi	Fungi	45.1	0.00227	NR	KIY50769.1	1128425	g749	i0	56.8	2.19047619047619	44	19	69.8	0	56	187	14	57	KIY50769.1 Lumazine synthase [Fistulina hepatica ATCC 64428]	diamond	414	45.4	0.993392070484582	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Fistulinaceae	Fistulina	Fistulina hepatica
30060010	30060010	PRJNA229468_S_NODE_1051_length_167_cov_1.296610_g1038_i0	PRJNA229468	1051	167	1.29661	2.1653387	Basidiomycota	5204	Fungi	Fungi	45.8	0.00107	NR	KNZ45269.1	27349	g1038	i0	44.6	4.92215568862275	56	30	98.8	1	167	3	60	115	KNZ45269.1 ribosomal protein S5 [Puccinia sorghi]	diamond	822	45.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia sorghi
32603224	32603224	PRJNA229468_S_NODE_800_length_185_cov_1.500000_g787_i0	PRJNA229468	800	185	1.5	2.775	Mycena floridula	1033242	Fungi	Fungi	43.1	0.0126	NR	KAJ7597478.1	1033242	g787	i0	44.4	0.72972972972973	45	25	73	0	156	22	127	171	KAJ7597478.1 hypothetical protein C8J56DRAFT_1108633 [Mycena floridula]	diamond	135	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena floridula
32666112	32666112	PRJNA229468_S_NODE_1260_length_161_cov_0.901786_g1247_i0	PRJNA229468	1260	161	0.901786	1.45187546	Meira miltonrushii	1280837	Fungi	Fungi	89	6.29e-19	NR	XP_025355750.1	1280837	g1247	i0	75	3.85714285714286	52	13	96.9	0	160	5	305	356	XP_025355750.1 putative OSM1-fumarate reductase [Meira miltonrushii]	diamond	621	89	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Exobasidiales	Brachybasidiaceae	Meira	Meira miltonrushii

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