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

5 rows where analysis = "diamond", bioproject = "PRJNA846486" and tax_clade = "core chlorophytes"

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
2108696	2108696	PRJNA846486_P_NODE_40722_length_214_cov_1.260606_g40626_i0	PRJNA846486	40722	214	1.260606	2.69769684	[Myrmecia] bisecta	41462	Plants	Plants	105	2.12e-26	NR	KAK9811451.1	41462	g40626	i0	76.1	1.86448598130841	67	16	93.9	0	2	202	138	204	KAK9811451.1 hypothetical protein WJX72_004104 [[Myrmecia] bisecta]	diamond	399	105	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
30568398	30568398	PRJNA846486_P_NODE_88653_length_164_cov_0.904348_g88557_i0	PRJNA846486	88653	164	0.904348	1.48313072	root	1	Root_unresolved	Root_unresolved	67	3.49e-11	NR	WIA33345.1	3088	g88557	i0	60	11.1951219512195	45	18	82.3	0	163	29	1616	1660	WIA33345.1 hypothetical protein OEZ86_006482 [Tetradesmus obliquus]	diamond	1836	67.4	0.99406528189911	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
31919715	31919715	PRJNA846486_P_NODE_45917_length_204_cov_1.677419_g45821_i0	PRJNA846486	45917	204	1.677419	3.42193476	Astrephomene gubernaculifera	47775	Plants	Plants	42	0.0427	NR	GFR50714.1	47775	g45821	i0	46.2	0.764705882352941	52	23	72.1	3	170	24	203	252	GFR50714.1 hypothetical protein Agub_g12971 [Astrephomene gubernaculifera]	diamond	156	42	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Astrephomenaceae	Astrephomene	Astrephomene gubernaculifera
32457750	32457750	PRJNA846486_P_NODE_42639_length_210_cov_1.614907_g42543_i0	PRJNA846486	42639	210	1.614907	3.3913047	Chlamydomonas incerta	51695	Plants	Plants	92	1.03e-21	NR	KAG2442829.1	51695	g42543	i0	58.6	3	70	29	100	0	1	210	12	81	KAG2442829.1 hypothetical protein HXX76_002908 [Chlamydomonas incerta]	diamond	630	92	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
32835860	32835860	PRJNA846486_P_NODE_81700_length_167_cov_0.881356_g81604_i0	PRJNA846486	81700	167	0.881356	1.47186452	Scenedesmus sp. NREL 46B-D3	2650976	Plants	Plants	47.8	2.2e-4	NR	KAF6262770.1	2650976	g81604	i0	65.9	0.736526946107784	41	14	73.7	0	6	128	64	104	KAF6262770.1 hypothetical protein COO60DRAFT_571601 [Scenedesmus sp. NREL 46B-D3]	diamond	123	47.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3

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