metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA493828" 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
26760261	26760261	PRJNA493828_P_NODE_36841_length_244_cov_3.771930_g36422_i0	PRJNA493828	36841	244	3.77193	9.2035092	Chlorella vulgaris	3077	Plants	Plants	70.5	6.58e-12	NR	KAL4853478.1	3077	g36422	i0	43.1	1.77049180327869	72	38	87.3	2	228	16	287	356	KAL4853478.1 Pre-mRNA-processing factor 19 [Chlorella vulgaris]	diamond	432	70.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
26981972	26981972	PRJNA493828_P_NODE_19602_length_289_cov_1.384259_g19183_i0	PRJNA493828	19602	289	1.384259	4.00050851	Scenedesmus sp. PABB	2909984	Plants	Plants	132	2.12e-33	NR	KAF8073244.1	2742167	g19183	i0	63.9	1.85813148788927	83	30	86.2	0	1	249	251	333	KAF8073244.1 coatomer subunit beta-1 [Scenedesmus sp. PABB004]	diamond	537	132	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
27961290	27961290	PRJNA493828_P_NODE_34305_length_248_cov_0.880000_g33886_i0	PRJNA493828	34305	248	0.88	2.1824	Bryopsis sp. KO-2	3115439	Plants	Plants	53.5	3.5e-6	NR	GMH36766.1	3041901	g33886	i0	51	0.592741935483871	49	22	56.9	1	166	26	12	60	GMH36766.1 hypothetical protein BSKO_04639 [Bryopsis sp. KO-2023]	diamond	147	53.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
28450683	28450683	PRJNA493828_P_NODE_40966_length_237_cov_2.817073_g40547_i0	PRJNA493828	40966	237	2.817073	6.67646301	Chlamydomonadales	3042	Plants	Plants	90.5	5.34e-19	NR	KAJ9525669.1	44745	g40547	i0	63.6	10.5443037974684	66	24	83.5	0	227	30	1290	1355	KAJ9525669.1 hypothetical protein QJQ45_003499 [Haematococcus lacustris]	diamond	2499	90.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
32448340	32448340	PRJNA493828_P_NODE_32159_length_251_cov_0.865169_g31740_i0	PRJNA493828	32159	251	0.865169	2.17157419	Coccomyxa viridis	1274662	Plants	Plants	55.1	2.87e-7	NR	CAK0782895.1	1274662	g31740	i0	50	0.669322709163347	56	24	62.2	1	5	160	53	108	CAK0782895.1 40S ribosomal protein S25-4 [Coccomyxa viridis]	diamond	168	55.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
32479918	32479918	PRJNA493828_P_NODE_12139_length_333_cov_1.480769_g11720_i0	PRJNA493828	12139	333	1.480769	4.93096077	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	143	5.27e-38	NR	KAH7624923.1	1650286	g11720	i0	63.4	2.01801801801802	112	37	99.1	3	332	3	160	269	KAH7624923.1 putative Elongation factor 1-alpha [Chlorella desiccata (nom. nud.)]	diamond	672	143	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'

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