metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA977246" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA977246" 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
6372780	6372780	PRJNA977246_S_NODE_14605_length_384_cov_5158.016901_g13616_i0	PRJNA977246	14605	384	5158.016901	19806.78489984	Chlamydomonas eustigma	1157962	Plants	Plants	120	6.86e-30	NR	GAX81867.1	1157962	g13616	i0	65.9	1.953125	91	27	71.1	1	366	94	266	352	GAX81867.1 hypothetical protein CEUSTIGMA_g9295.t1 [Chlamydomonas eustigma]	diamond	750	120	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
7329207	7329207	PRJNA977246_S_NODE_35326_length_200_cov_2.403509_g34334_i0	PRJNA977246	35326	200	2.403509	4.807018	Scenedesmus sp. NREL 46B-D3	2650976	Plants	Plants	129	7.400000000000001e-34	NR	KAF6254444.1	2650976	g34334	i0	98.5	1.965	66	1	99	0	1	198	283	348	KAF6254444.1 sedoheptulose-1,7-biphosphatase [Scenedesmus sp. NREL 46B-D3]	diamond	393	129	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3
12430122	12430122	PRJNA977246_S_NODE_14590_length_385_cov_2.140449_g13602_i0	PRJNA977246	14590	385	2.140449	8.24072865	Chlorophyta	3041	Plants	Plants	189	1.89e-59	NR	XP_005645013.1	574566	g13602	i0	91	9.35064935064935	100	9	77.9	0	3	302	31	130	XP_005645013.1 ribosomal protein S15a component of cytosolic 80S ribosome and 40S small subunit [Coccomyxa subellipsoidea C-169]	diamond	3600	189	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
15296603	15296603	PRJNA977246_S_NODE_10012_length_484_cov_4190.692308_g9089_i0	PRJNA977246	10012	484	4190.692308	20282.95077072	Coccomyxa viridis	1274662	Plants	Plants	144	2.09e-39	NR	CAL5220391.1	1274662	g9089	i0	88.8	0.495867768595041	80	9	49.6	0	317	78	50	129	CAL5220391.1 g2398 [Coccomyxa viridis]	diamond	240	144	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
15296868	15296868	PRJNA977246_S_NODE_34692_length_202_cov_10924.005780_g33700_i0	PRJNA977246	34692	202	10924.00578	22066.4916756	Coccomyxa viridis	1274662	Plants	Plants	70.5	2.49e-12	NR	CAL5219012.1	1274662	g33700	i0	84.1	0.653465346534653	44	6	63.9	1	51	179	283	326	CAL5219012.1 g768 [Coccomyxa viridis]	diamond	132	70.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
26899651	26899651	PRJNA977246_S_NODE_28461_length_236_cov_3.444444_g27469_i0	PRJNA977246	28461	236	3.444444	8.12888784	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	103	5.99e-25	NR	KAL4519373.1	1650286	g27469	i0	83	2.02118644067797	53	9	67.4	0	25	183	210	262	KAL4519373.1 hypothetical protein Ndes2526A_g00461 [Chlorella desiccata (nom. nud.)]	diamond	477	103	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
26899659	26899659	PRJNA977246_S_NODE_43201_length_171_cov_2.922535_g42209_i0	PRJNA977246	43201	171	2.922535	4.99753485	Coccomyxa viridis	1274662	Plants	Plants	60.1	3.07e-10	NR	CAK0753880.1	1274662	g42209	i0	71.2	0.912280701754386	52	14	89.5	1	7	159	5	56	CAK0753880.1 hypothetical protein CVIRNUC_002254 [Coccomyxa viridis]	diamond	156	60.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
27089464	27089464	PRJNA977246_S_NODE_44202_length_168_cov_3.294964_g43210_i0	PRJNA977246	44202	168	3.294964	5.53553952	Coccomyxa viridis	1274662	Plants	Plants	97.1	9.9e-22	NR	CAL5229584.1	1274662	g43210	i0	93	1.53571428571429	43	3	76.8	0	166	38	635	677	CAL5229584.1 g12940 [Coccomyxa viridis]	diamond	258	97.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
28194555	28194555	PRJNA977246_S_NODE_46946_length_161_cov_2.401515_g45954_i0	PRJNA977246	46946	161	2.401515	3.86643915	Chlorella variabilis	554065	Plants	Plants	71.6	7.23e-13	NR	XP_005851505.1	554065	g45954	i0	73.1	1.93788819875776	52	14	96.9	0	2	157	336	387	XP_005851505.1 hypothetical protein CHLNCDRAFT_33857 [Chlorella variabilis]	diamond	312	71.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
29116713	29116713	PRJNA977246_S_NODE_49928_length_154_cov_2.336000_g48936_i0	PRJNA977246	49928	154	2.336	3.59744	Scenedesmaceae	3086	Plants	Plants	92.8	1.27e-21	NR	8CMO_6	75800	g48936	i0	86	2.92207792207792	50	7	97.4	0	3	152	50	99	8CMO_6 Chain 6, Light-harvesting protein of photosystem I Lhca6 [Coelastrella]	diamond	450	93.2	0.995708154506438	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Coelastrella
29211437	29211437	PRJNA977246_S_NODE_10369_length_474_cov_3.723596_g9440_i0	PRJNA977246	10369	474	3.723596	17.64984504	Trebouxia	13786	Plants	Plants	92.4	1.18e-18	NR	KAA6423678.1	2608996	g9440	i0	79.6	2.0253164556962	54	11	34.2	0	108	269	361	414	KAA6423678.1 MAG: phosphoribulokinase precursor [Trebouxia sp. A1-2]	diamond	960	92.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
29211439	29211439	PRJNA977246_S_NODE_46649_length_162_cov_1.556391_g45657_i0	PRJNA977246	46649	162	1.556391	2.52135342	Selenastraceae	35466	Plants	Plants	88.2	1.55e-19	NR	KAI8462589.1	39955	g45657	i0	76	2.77777777777778	50	12	92.6	0	3	152	127	176	KAI8462589.1 MAG: light-harvesting chlorophyll a/b-binding protein Lhca5 [Monoraphidium minutum]	diamond	450	88.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium minutum
29299847	29299847	PRJNA977246_S_NODE_21869_length_290_cov_4.007663_g20877_i0	PRJNA977246	21869	290	4.007663	11.6222227	Gonium pectorale	33097	Plants	Plants	43.5	0.0202	NR	KXZ45670.1	33097	g20877	i0	87	0.941379310344828	23	3	23.8	0	21	89	150	172	KXZ45670.1 hypothetical protein GPECTOR_52g68 [Gonium pectorale]	diamond	273	43.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
30190166	30190166	PRJNA977246_S_NODE_39652_length_183_cov_1.805195_g38660_i0	PRJNA977246	39652	183	1.805195	3.30350685	Trebouxiales	2507901	Plants	Plants	103	4.5e-24	NR	XP_005650521.1	574566	g38660	i0	83.3	3.9344262295082	60	10	98.4	0	3	182	559	618	XP_005650521.1 hypothetical protein COCSUDRAFT_22213 [Coccomyxa subellipsoidea C-169]	diamond	720	103	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
31258409	31258409	PRJNA977246_S_NODE_13395_length_406_cov_4.405836_g12415_i0	PRJNA977246	13395	406	4.405836	17.88769416	Coccomyxa viridis	1274662	Plants	Plants	80.9	2.32e-15	NR	CAL5220391.1	1274662	g12415	i0	86	0.369458128078818	50	7	36.9	0	228	377	1	50	CAL5220391.1 g2398 [Coccomyxa viridis]	diamond	150	80.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
31802093	31802093	PRJNA977246_S_NODE_39037_length_185_cov_2.519231_g38045_i0	PRJNA977246	39037	185	2.519231	4.66057735	Volvox	3066	Plants	Plants	46.2	4.02e-4	NR	XP_002945815.1	3068	g38045	i0	92	1.21621621621622	25	2	40.5	0	2	76	117	141	XP_002945815.1 uncharacterized protein VOLCADRAFT_109549 [Volvox carteri f. nagariensis]	diamond	225	46.6	0.991416309012876	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri

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