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

4 rows where analysis = "diamond", bioproject = "PRJNA1123686" 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
27702402	27702402	PRJNA1123686_S_NODE_16904_length_162_cov_5.218045_g16872_i0	PRJNA1123686	16904	162	5.218045	8.4532329	Amylostereum chailletii	55340	Fungi	Fungi	82	8.54e-17	NR	KAI0316275.1	55340	g16872	i0	82.7	0.962962962962963	52	9	96.3	0	158	3	253	304	KAI0316275.1 hypothetical protein OF83DRAFT_263040 [Amylostereum chailletii]	diamond	156	82	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Amylostereum	Amylostereum chailletii
31007277	31007277	PRJNA1123686_S_NODE_714_length_359_cov_9.866667_g683_i0	PRJNA1123686	714	359	9.866667	35.42133453	Agaricomycetes	155619	Fungi	Fungi	42.4	0.0411	NR	KAF8885082.1	109634	g683	i0	37.7	1.16155988857939	69	39	55.2	2	349	152	30	97	KAF8885082.1 fungal hydrophobin [Gymnopilus junonius]	diamond	417	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Hymenogastraceae	Gymnopilus	Gymnopilus junonius
31302562	31302562	PRJNA1123686_S_NODE_19635_length_155_cov_2.619048_g19603_i0	PRJNA1123686	19635	155	2.619048	4.0595244	Phakopsora pachyrhizi	170000	Fungi	Fungi	44.7	0.00212	NR	CAH7685547.1	170000	g19603	i0	48.8	2.38064516129032	41	21	79.4	0	155	33	162	202	CAH7685547.1 expressed protein [Phakopsora pachyrhizi]	diamond	369	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Phakopsoraceae	Phakopsora	Phakopsora pachyrhizi
31366023	31366023	PRJNA1123686_S_NODE_2396_length_274_cov_5.387755_g2364_i0	PRJNA1123686	2396	274	5.387755	14.7624487	Stereum hirsutum FP-91666 SS1	721885	Fungi	Fungi	52.4	1.28e-5	NR	XP_007301349.1	721885	g2364	i0	86.2	0.317518248175182	29	4	31.8	0	3	89	187	215	XP_007301349.1 uncharacterized protein STEHIDRAFT_137827 [Stereum hirsutum FP-91666 SS1]	diamond	87	52.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum

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