metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA498309" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA498309" 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
14508839	14508839	PRJNA498309_P_NODE_11172_length_900_cov_16.588644_g9695_i0	PRJNA498309	11172	900	16.588644	149.297796	[Myrmecia] bisecta	41462	Plants	Plants	273	5.609999999999998e-88	NR	KAK9810119.1	41462	g9695	i0	72.9	1.35666666666667	203	52	66.7	1	4	603	10	212	KAK9810119.1 hypothetical protein WJX72_005069 [[Myrmecia] bisecta]	diamond	1221	273	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
26855737	26855737	PRJNA498309_P_NODE_15381_length_751_cov_26.628852_g13728_i0	PRJNA498309	15381	751	26.628852	199.98267852	Symbiochloris irregularis	706552	Plants	Plants	119	4e-30	NR	KAK9803124.1	706552	g13728	i0	82.2	0.291611185086551	73	13	29.2	0	618	400	1	73	KAK9803124.1 hypothetical protein WJX73_007964 [Symbiochloris irregularis]	diamond	219	119	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
27171641	27171641	PRJNA498309_P_NODE_38662_length_446_cov_8.914425_g36583_i0	PRJNA498309	38662	446	8.914425	39.7583355	Coccomyxa viridis	1274662	Plants	Plants	57.8	9.09e-7	NR	CAK0779401.1	1274662	g36583	i0	53.3	0.302690582959641	45	21	30.3	0	14	148	192	236	CAK0779401.1 hypothetical protein CVIRNUC_004764 [Coccomyxa viridis]	diamond	135	57.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
27313945	27313945	PRJNA498309_S_NODE_19683_length_464_cov_6.219114_g17585_i0	PRJNA498309	19683	464	6.219114	28.85668896	root	1	Root_unresolved	Root_unresolved	121	3.61e-30	NR	AAK77552.1	3055	g17585	i0	75.2	2.6573275862069	137	33	87.9	1	24	431	123	259	AAK77552.1 LCI5 [Chlamydomonas reinhardtii]	diamond	1233	121	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
28640177	28640177	PRJNA498309_P_NODE_108327_length_176_cov_1.690647_g106178_i0	PRJNA498309	108327	176	1.690647	2.97553872	root	1	Root_unresolved	Root_unresolved	73.6	1.29e-13	NR	AAK77552.1	3055	g106178	i0	97.6	2.79545454545455	41	1	69.9	0	53	175	1	41	AAK77552.1 LCI5 [Chlamydomonas reinhardtii]	diamond	492	73.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
28719260	28719260	PRJNA498309_P_NODE_114107_length_165_cov_1.382812_g111958_i0	PRJNA498309	114107	165	1.382812	2.2816398	Chlamydomonas schloesseri	2026947	Plants	Plants	69.3	3.77e-12	NR	KAG2448775.1	2026947	g111958	i0	88.9	0.818181818181818	45	5	81.8	0	12	146	98	142	KAG2448775.1 hypothetical protein HYH02_006127 [Chlamydomonas schloesseri]	diamond	135	69.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas schloesseri
28750757	28750757	PRJNA498309_P_NODE_106707_length_179_cov_2.183099_g104558_i0	PRJNA498309	106707	179	2.183099	3.90774721	Volvox reticuliferus	1737510	Plants	Plants	58.2	2.97e-8	NR	GIM13982.1	1737510	g104558	i0	75	1.77653631284916	36	9	60.3	0	141	34	185	220	GIM13982.1 hypothetical protein Vretimale_16996, partial [Volvox reticuliferus]	diamond	318	58.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox reticuliferus
29161479	29161479	PRJNA498309_P_NODE_17829_length_692_cov_17.679389_g16084_i0	PRJNA498309	17829	692	17.679389	122.34137188	Trebouxia sp. C	2796353	Plants	Plants	244	3.5700000000000004e-79	NR	KAL3148653.1	3373144	g16084	i0	89.4	0.611271676300578	141	15	61.1	0	669	247	2	142	KAL3148653.1 hypothetical protein ABBQ38_014074 [Trebouxia sp. C0009 RCD-2024]	diamond	423	244	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0009 RCD-2024
29571599	29571599	PRJNA498309_P_NODE_39610_length_440_cov_2.935484_g37506_i0	PRJNA498309	39610	440	2.935484	12.9161296	Chlamydomonas schloesseri	2026947	Plants	Plants	107	4.85e-25	NR	KAG2448775.1	2026947	g37506	i0	80	0.784090909090909	115	22	78.4	1	1	345	88	201	KAG2448775.1 hypothetical protein HYH02_006127 [Chlamydomonas schloesseri]	diamond	345	107	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas schloesseri
30582348	30582348	PRJNA498309_P_NODE_42893_length_418_cov_3.251969_g40775_i0	PRJNA498309	42893	418	3.251969	13.59323042	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	73.6	1.88e-14	NR	XP_005648938.1	574566	g40775	i0	81.3	0.344497607655502	48	8	33.7	1	123	263	10	57	XP_005648938.1 hypothetical protein COCSUDRAFT_61819 [Coccomyxa subellipsoidea C-169]	diamond	144	73.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea

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