metadata: contig_metadata: 8 rows where bioproject = "PRJNA559720" and tax

8 rows where bioproject = "PRJNA559720" 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
26825966	26825966	PRJNA559720_P_NODE_12421_length_267_cov_1.340206_g12282_i0	PRJNA559720	12421	267	1.340206	3.57835002	Chlorella sorokiniana	3076	Plants	Plants	67.8	7.39e-11	NR	PRW58820.1	3076	g12282	i0	53.8	3.44943820224719	52	23	58.4	1	251	96	89	139	PRW58820.1 eukaryotic translation initiation factor 3 subunit L-like [Chlorella sorokiniana]	diamond	921	67.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
27141790	27141790	PRJNA559720_P_NODE_3402_length_562_cov_1.290389_g3276_i0	PRJNA559720	3402	562	1.290389	7.25198618	Ostreobium quekettii	121088	Plants	Plants	126	7.549999999999998e-30	NR	CAD7700543.1	121088	g3276	i0	37.9	0.859430604982206	161	100	85.9	0	1	483	402	562	CAD7700543.1 unnamed protein product, partial [Ostreobium quekettii]	diamond	483	126	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii
27141793	27141793	PRJNA559720_P_NODE_6682_length_395_cov_3.232919_g6543_i0	PRJNA559720	6682	395	3.232919	12.77003005	Elliptochloris bilobata	381761	Plants	Plants	63.5	9.92e-9	NR	KAK9819162.1	381761	g6543	i0	37.2	2.50632911392405	86	53	64.6	1	338	84	7	92	KAK9819162.1 hypothetical protein WJX81_005513 [Elliptochloris bilobata]	diamond	990	63.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Elliptochloris	Elliptochloris bilobata
27458368	27458368	PRJNA559720_P_NODE_6823_length_391_cov_1.257862_g6684_i0	PRJNA559720	6823	391	1.257862	4.91824042	Haematococcus lacustris	44745	Plants	Plants	171	2e-46	NR	KAJ9510293.1	44745	g6684	i0	63.1	99.7442455242967	130	48	99.7	0	1	390	842	971	KAJ9510293.1 hypothetical protein QJQ45_015750 [Haematococcus lacustris]	diamond	39000	171	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
30300570	30300570	PRJNA559720_P_NODE_9672_length_315_cov_1.260331_g9533_i0	PRJNA559720	9672	315	1.260331	3.97004265	Volvox africanus	51714	Plants	Plants	43.5	0.0444	NR	GIL63063.1	51714	g9533	i0	37.5	0.60952380952381	64	36	59	2	302	117	288	349	GIL63063.1 hypothetical protein Vafri_17030 [Volvox africanus]	diamond	192	43.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox africanus
30489751	30489751	PRJNA559720_P_NODE_7813_length_360_cov_4.442509_g7674_i0	PRJNA559720	7813	360	4.442509	15.9930324	Trebouxia sp. C	2796353	Plants	Plants	100	1.31e-24	NR	KAL3152508.1	3373145	g7674	i0	66.2	0.641666666666667	77	26	64.2	0	303	73	41	117	KAL3152508.1 60S ribosomal protein L38 [Trebouxia sp. C0010 RCD-2024]	diamond	231	100	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
31659035	31659035	PRJNA559720_P_NODE_4617_length_485_cov_2.055825_g4479_i0	PRJNA559720	4617	485	2.055825	9.97075125	[Myrmecia] bisecta	41462	Plants	Plants	83.2	4.11e-15	NR	KAK9814633.1	41462	g4479	i0	41.5	2.52371134020619	123	67	73.6	3	2	358	804	925	KAK9814633.1 hypothetical protein WJX72_009077 [[Myrmecia] bisecta]	diamond	1224	83.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
31957866	31957866	PRJNA559720_P_NODE_917_length_956_cov_3.199320_g850_i0	PRJNA559720	917	956	3.19932	30.5854992	Eukaryota	2759	Plants	Plants	85.9	2.34e-14	NR	KAJ9510115.1	44745	g850	i0	46.7	1.63807531380753	75	40	23.5	0	431	207	80	154	KAJ9510115.1 hypothetical protein QJQ45_015595 [Haematococcus lacustris]	diamond	1566	86.7	0.990772779700115	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris

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