metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_kingdom = "Fungi"

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
27550160	27550160	PRJNA488043_P_NODE_19264_length_179_cov_2.293333_g17022_i0	PRJNA488043	19264	179	2.293333	4.10506607	Periconia macrospinosa	97972	Fungi	Fungi	42.4	0.0218	NR	PVI07971.1	97972	g17022	i0	39.2	0.854748603351955	51	31	85.5	0	155	3	229	279	PVI07971.1 FolC bifunctional protein [Periconia macrospinosa]	diamond	153	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Periconiaceae	Periconia	Periconia macrospinosa
27865866	27865866	PRJNA488043_P_NODE_15825_length_216_cov_2.058824_g13583_i0	PRJNA488043	15825	216	2.058824	4.44705984	Lithohypha guttulata	1690604	Fungi	Fungi	42	0.0496	NR	KAK5079622.1	1690604	g13583	i0	34	0.736111111111111	53	34	73.6	1	211	53	1006	1057	KAK5079622.1 hypothetical protein LTR24_009087 [Lithohypha guttulata]	diamond	159	42	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Lithohypha	Lithohypha guttulata
29065980	29065980	PRJNA488043_P_NODE_18168_length_190_cov_2.055901_g15926_i0	PRJNA488043	18168	190	2.055901	3.9062119	Malassezia arunalokei	1514897	Fungi	Fungi	65.9	1.33e-10	NR	WFD16437.1	1514897	g15926	i0	85.4	0.647368421052632	41	6	64.7	0	189	67	979	1019	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	123	65.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
30581650	30581650	PRJNA488043_P_NODE_7493_length_440_cov_2.844282_g5342_i0	PRJNA488043	7493	440	2.844282	12.5148408	Phakopsora pachyrhizi	170000	Fungi	Fungi	42.7	0.0426	NR	KAI8449393.1	170000	g5342	i0	35.8	0.456818181818182	67	40	45.7	1	163	363	7	70	KAI8449393.1 hypothetical protein BY996DRAFT_6605057 [Phakopsora pachyrhizi]	diamond	201	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Phakopsoraceae	Phakopsora	Phakopsora pachyrhizi

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