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

4 rows where analysis = "diamond", bioproject = "PRJNA798511" 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
28506752	28506752	PRJNA798511_P_NODE_98567_length_244_cov_0.900585_g94301_i0	PRJNA798511	98567	244	0.900585	2.1974274	Chlorella vulgaris	3077	Plants	Plants	50.1	9.88e-5	NR	KAL4853763.1	3077	g94301	i0	35.3	4.79508196721311	85	48	95.9	1	236	3	917	1001	KAL4853763.1 Metal transporter Nramp2 [Chlorella vulgaris]	diamond	1170	50.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
28601523	28601523	PRJNA798511_P_NODE_80427_length_266_cov_1.077720_g76161_i0	PRJNA798511	80427	266	1.07772	2.8667352	Chlamydomonas incerta	51695	Plants	Plants	53.9	5.8e-6	NR	KAG2428416.1	51695	g76161	i0	40.5	1.89473684210526	84	47	93.6	2	2	250	766	847	KAG2428416.1 hypothetical protein HXX76_011536 [Chlamydomonas incerta]	diamond	504	53.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
30821304	30821304	PRJNA798511_P_NODE_84014_length_258_cov_2.081081_g79748_i0	PRJNA798511	84014	258	2.081081	5.36918898	Eukaryota	2759	Plants	Plants	134	2.46e-38	NR	CAD7702209.1	121088	g79748	i0	78.3	63.5	83	18	96.5	0	256	8	38	120	CAD7702209.1 unnamed protein product [Ostreobium quekettii]	diamond	16383	135	0.992592592592593	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii
32812590	32812590	PRJNA798511_P_NODE_59520_length_319_cov_1.504065_g55254_i0	PRJNA798511	59520	319	1.504065	4.79796735	Eukaryota	2759	Plants	Plants	167	1.34e-45	NR	KAL4853107.1	3077	g55254	i0	79.6	32.9153605015674	103	21	96.9	0	319	11	39	141	KAL4853107.1 40S ribosomal protein S16 [Chlorella vulgaris]	diamond	10500	168	0.994047619047619	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris

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