metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA446034" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA446034" 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
6194897	6194897	PRJNA446034_S_NODE_100365_length_155_cov_2.957627_g100328_i0	PRJNA446034	100365	155	2.957627	4.58432185	root	1	Root_unresolved	Root_unresolved	54.3	5.68e-7	NR	KAG2426943.1	51695	g100328	i0	72.4	2.74838709677419	29	8	56.1	0	3	89	188	216	KAG2426943.1 hypothetical protein HXX76_012728 [Chlamydomonas incerta]	diamond	426	54.7	0.992687385740402	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
6815763	6815763	PRJNA446034_S_NODE_12006_length_252_cov_3.455814_g11969_i0	PRJNA446034	12006	252	3.455814	8.70865128	Symbiochloris irregularis	706552	Plants	Plants	96.3	4.179999999999999e-23	NR	KAK9798558.1	706552	g11969	i0	74.5	4.82142857142857	55	14	65.5	0	250	86	98	152	KAK9798558.1 hypothetical protein WJX73_004706 [Symbiochloris irregularis]	diamond	1215	96.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
19564076	19564076	PRJNA446034_S_NODE_49296_length_184_cov_3.190476_g49259_i0	PRJNA446034	49296	184	3.190476	5.87047584	[Myrmecia] bisecta	41462	Plants	Plants	102	2.02e-26	NR	KAK9820180.1	41462	g49259	i0	88.5	1.98913043478261	61	7	99.5	0	1	183	27	87	KAK9820180.1 hypothetical protein WJX72_007173 [[Myrmecia] bisecta]	diamond	366	102	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
27834059	27834059	PRJNA446034_S_NODE_66124_length_172_cov_1.422222_g66087_i0	PRJNA446034	66124	172	1.422222	2.44622184	Edaphochlorella mirabilis	3083	Plants	Plants	68.9	8.37e-12	NR	YP_009105144.1	3083	g66087	i0	55.4	2.77325581395349	56	25	97.7	0	1	168	1928	1983	YP_009105144.1 cell division protein [Edaphochlorella mirabilis]	diamond	477	68.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Prasiolaceae	Edaphochlorella	Edaphochlorella mirabilis
27897184	27897184	PRJNA446034_S_NODE_97705_length_156_cov_3.193277_g97668_i0	PRJNA446034	97705	156	3.193277	4.98151212	Chlorella sorokiniana	3076	Plants	Plants	90.1	2.14e-19	NR	YP_009049997.1	3076	g97668	i0	75	3	52	13	100	0	1	156	384	435	YP_009049997.1 NADH dehydrogenase subunit 4 [Chlorella sorokiniana]	diamond	468	90.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
28402488	28402488	PRJNA446034_S_NODE_67486_length_171_cov_2.149254_g67449_i0	PRJNA446034	67486	171	2.149254	3.67522434	Trebouxia sp. C	2796353	Plants	Plants	104	2.73e-24	NR	KAL3136501.1	3373144	g67449	i0	89.3	1.96491228070175	56	6	98.2	0	170	3	577	632	KAL3136501.1 hypothetical protein ABBQ38_005752 [Trebouxia sp. C0009 RCD-2024]	diamond	336	104	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0009 RCD-2024
28718287	28718287	PRJNA446034_S_NODE_18307_length_230_cov_2.222798_g18270_i0	PRJNA446034	18307	230	2.222798	5.1124354	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	84	1.78e-19	NR	XP_005650138.1	574566	g18270	i0	89.4	0.61304347826087	47	5	61.3	0	230	90	14	60	XP_005650138.1 putative 40S ribosomal protein S30 [Coccomyxa subellipsoidea C-169]	diamond	141	84	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
29208284	29208284	PRJNA446034_S_NODE_74169_length_167_cov_2.538462_g74132_i0	PRJNA446034	74169	167	2.538462	4.23923154	Trebouxiaceae	2507902	Plants	Plants	59.7	5.55e-9	NR	YP_009138106.1	312850	g74132	i0	84.8	1.76047904191617	33	5	59.3	0	166	68	171	203	YP_009138106.1 NADH dehydrogenase subunit 6 [Lobosphaera incisa]	diamond	294	59.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Lobosphaera	Lobosphaera incisa
30945508	30945508	PRJNA446034_S_NODE_36694_length_197_cov_3.462500_g36657_i0	PRJNA446034	36694	197	3.4625	6.821125	Chlorellales	35460	Plants	Plants	95.9	3.88e-21	NR	XP_011396515.1	3075	g36657	i0	69.2	7.91878172588832	65	20	99	0	2	196	636	700	XP_011396515.1 Transketolase, chloroplastic [Auxenochlorella protothecoides]	diamond	1560	96.7	0.991726990692865	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
30992398	30992398	PRJNA446034_S_NODE_39554_length_194_cov_1.165605_g39517_i0	PRJNA446034	39554	194	1.165605	2.2612737	Trebouxia sp. C	2796353	Plants	Plants	114	5.36e-28	NR	KAL3149488.1	3373145	g39517	i0	95.2	0.974226804123711	63	3	97.4	0	3	191	318	380	KAL3149488.1 hypothetical protein ABBQ32_002271 [Trebouxia sp. C0010 RCD-2024]	diamond	189	114	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
31213031	31213031	PRJNA446034_S_NODE_66055_length_172_cov_1.688889_g66018_i0	PRJNA446034	66055	172	1.688889	2.90488908	Symbiochloris irregularis	706552	Plants	Plants	54.3	1.04e-6	NR	KAK9810808.1	706552	g66018	i0	61.5	2.07558139534884	39	11	68	1	119	3	198	232	KAK9810808.1 hypothetical protein WJX73_009069 [Symbiochloris irregularis]	diamond	357	54.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis

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