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

11 rows where analysis = "diamond", bioproject = "PRJNA608660" 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
14613854	14613854	PRJNA608660_P_NODE_5652_length_615_cov_9.572438_g5345_i0	PRJNA608660	5652	615	9.572438	58.8704937	Trebouxia sp. A1-2	2608996	Plants	Plants	175	2.96e-49	NR	KAA6425329.1	2608996	g5345	i0	93.3	1.30731707317073	89	6	43.4	0	600	334	310	398	KAA6425329.1 MAG: adenosine kinase [Trebouxia sp. A1-2]	diamond	804	175	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
24811080	24811080	PRJNA608660_P_NODE_38280_length_195_cov_1.068493_g37924_i0	PRJNA608660	38280	195	1.068493	2.08356135	Trebouxia	13786	Plants	Plants	134	1.32e-36	NR	KAL3145898.1	3373144	g37924	i0	98.4	1.96923076923077	64	1	98.5	0	2	193	222	285	KAL3145898.1 Chlorophyll a-b binding protein 6, chloroplastic [Trebouxia sp. C0009 RCD-2024]	diamond	384	134	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0009 RCD-2024
27238104	27238104	PRJNA608660_P_NODE_46963_length_167_cov_0.881356_g46606_i0	PRJNA608660	46963	167	0.881356	1.47186452	Trebouxia sp. C	2796353	Plants	Plants	89.4	5.04e-19	NR	KAL3133156.1	3373144	g46606	i0	90.4	0.934131736526946	52	4	93.4	1	167	12	754	804	KAL3133156.1 hypothetical protein ABBQ38_007050 [Trebouxia sp. C0009 RCD-2024]	diamond	156	89.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0009 RCD-2024
27396359	27396359	PRJNA608660_P_NODE_35263_length_208_cov_1.308176_g34907_i0	PRJNA608660	35263	208	1.308176	2.72100608	Trebouxia sp. C	2796353	Plants	Plants	57.8	6.23e-8	NR	KAL3147343.1	3373145	g34907	i0	76.3	0.548076923076923	38	9	54.8	0	120	7	1	38	KAL3147343.1 hypothetical protein ABBQ32_002826 [Trebouxia sp. C0010 RCD-2024]	diamond	114	57.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
27427979	27427979	PRJNA608660_P_NODE_24803_length_271_cov_1.608108_g24447_i0	PRJNA608660	24803	271	1.608108	4.35797268	Trebouxia sp. C	2796353	Plants	Plants	70.5	9.18e-12	NR	KAL0047354.1	2905655	g24447	i0	78.6	0.929889298892989	42	9	46.5	0	126	1	1	42	KAL0047354.1 hypothetical protein WJX82_001254 [Trebouxia sp. C0006]	diamond	252	70.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0006
28059162	28059162	PRJNA608660_P_NODE_8605_length_509_cov_2.826087_g8270_i0	PRJNA608660	8605	509	2.826087	14.38478283	Trebouxia sp. C	2796353	Plants	Plants	133	5.38e-37	NR	KAL3152567.1	3373145	g8270	i0	91.8	0.430255402750491	73	6	43	0	400	182	25	97	KAL3152567.1 hypothetical protein ABBQ32_001592 [Trebouxia sp. C0010 RCD-2024]	diamond	219	133	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
29038291	29038291	PRJNA608660_P_NODE_21008_length_305_cov_2.339844_g20652_i0	PRJNA608660	21008	305	2.339844	7.1365242	Trebouxia sp. C	2796353	Plants	Plants	184	1.67e-51	NR	KAL3158463.1	3373144	g20652	i0	90	1.9672131147541	100	10	98.4	0	302	3	2514	2613	KAL3158463.1 hypothetical protein ABBQ38_010696 [Trebouxia sp. C0009 RCD-2024]	diamond	600	184	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0009 RCD-2024
29543109	29543109	PRJNA608660_P_NODE_32070_length_224_cov_1.080000_g31714_i0	PRJNA608660	32070	224	1.08	2.4192	Chlamydomonas sp. ICE-L	309537	Plants	Plants	40.8	0.0165	NR	ABD64591.1	309537	g31714	i0	89.5	1.75446428571429	19	2	25.4	0	167	223	25	43	ABD64591.1 ribosomal protein S29 subunit [Chlamydomonas sp. ICE-L]	diamond	393	40.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. ICE-L
30648582	30648582	PRJNA608660_P_NODE_5393_length_628_cov_9.120898_g5090_i0	PRJNA608660	5393	628	9.120898	57.27923944	Trebouxia sp. C	2796353	Plants	Plants	104	2.45e-23	NR	KAL3152533.1	3373145	g5090	i0	77.6	0.320063694267516	67	15	32	0	599	399	190	256	KAL3152533.1 hypothetical protein ABBQ32_001562 [Trebouxia sp. C0010 RCD-2024]	diamond	201	104	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
32514893	32514893	PRJNA608660_P_NODE_22939_length_287_cov_2.000000_g22583_i0	PRJNA608660	22939	287	2	5.74	Trebouxia sp. C	2796353	Plants	Plants	125	1.28e-32	NR	KAL3146532.1	3373145	g22583	i0	70.7	0.961672473867596	92	22	96.2	1	7	282	89	175	KAL3146532.1 hypothetical protein ABBQ32_000777 [Trebouxia sp. C0010 RCD-2024]	diamond	276	125	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
32514895	32514895	PRJNA608660_P_NODE_4739_length_663_cov_11.892508_g4447_i0	PRJNA608660	4739	663	11.892508	78.84732804	Trebouxia sp. C	2796353	Plants	Plants	113	5.08e-25	NR	KAL3137028.1	3373145	g4447	i0	88.5	0.276018099547511	61	7	27.6	0	195	377	458	518	KAL3137028.1 hypothetical protein ABBQ32_006616 [Trebouxia sp. C0010 RCD-2024]	diamond	183	113	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024

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