metadata: contig_metadata: 13 rows where bioproject = "PRJNA980839" and tax

13 rows where bioproject = "PRJNA980839" 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
5097976	5097976	PRJNA980839_P_NODE_100204_length_362_cov_1.065744_g96420_i0	PRJNA980839	100204	362	1.065744	3.85799328	Chlamydomonas	3052	Plants	Plants	375	1.79e-99	NTclustered	gi\|2082260397\|ref\|XM_043068042.1\|	3055	g96420	i0	88.217	15.1740331491713	314	37	87	0	46	359	971	1284	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g498600v5), mRNA	blastn	5493	375	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
6062380	6062380	PRJNA980839_P_NODE_233385_length_242_cov_0.911243_g229601_i0	PRJNA980839	233385	242	0.911243	2.20520806	Dunaliella viridis	140095	Plants	Plants	309	1.17e-79	NTclustered	gi\|219563659\|gb\|FJ268732.1\|	140095	g229601	i0	89.669	2.44628099173554	242	25	100	0	1	242	63269	63028	Dunaliella viridis strain SHU clone BAC 55A01 hypothetical protein, sodium-coupled phosphate transporter protein (SPT2), and hypothetical proteins genes, complete cds	blastn	592	309	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella viridis
8611561	8611561	PRJNA980839_P_NODE_210387_length_248_cov_0.880000_g206603_i0	PRJNA980839	210387	248	0.88	2.1824	Nannochloris normandinae	926285	Plants	Plants	459	1.13e-124	NTclustered	gi\|922575245\|gb\|JQ921007.1\|	926285	g206603	i0	100	59.758064516129	248	0	100	0	1	248	801	1048	Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	14820	459	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris normandinae
11162036	11162036	PRJNA980839_P_NODE_210869_length_248_cov_0.880000_g207085_i0	PRJNA980839	210869	248	0.88	2.1824	Chlamydomonas sp. HS-5	108458	Plants	Plants	126	1.2999999999999998e-24	NTclustered	gi\|6440787\|dbj\|AU066498.1\|	108458	g207085	i0	80.357	28.4758064516129	168	31	67	2	82	248	454	288	Chlamydomonas sp. HS-5 mRNA for ribulose-bisphosphate carboxylase small chain precursor, NaCl inducible, complete cds, clone:NaEX96-11	blastn	7062	126	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. HS-5
26931373	26931373	PRJNA980839_P_NODE_238742_length_241_cov_0.916667_g234958_i0	PRJNA980839	238742	241	0.916667	2.20916747	Coccomyxa viridis	1274662	Plants	Plants	67	9.73e-11	NR	CAK0786739.1	1274662	g234958	i0	82.4	0.423236514522822	34	6	42.3	0	107	6	109	142	CAK0786739.1 hypothetical protein CVIRNUC_009953 [Coccomyxa viridis]	diamond	102	67	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
27026199	27026199	PRJNA980839_P_NODE_158382_length_280_cov_1.159420_g154598_i0	PRJNA980839	158382	280	1.15942	3.246376	Chlorella ohadii	2649997	Plants	Plants	119	4.61e-31	NR	KAI7835437.1	2649997	g154598	i0	65.3	0.803571428571429	75	26	80.4	0	225	1	1	75	KAI7835437.1 hypothetical protein COHA_010666 [Chlorella ohadii]	diamond	225	119	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella ohadii
27126687	27126687	PRJNA980839_P_NODE_224342_length_244_cov_1.543860_g220558_i0	PRJNA980839	224342	244	1.54386	3.7670184	Eukaryota	2759	Plants	Plants	94.7	9.55e-21	NR	XP_013902835.1	145388	g220558	i0	54	14.422131147541	87	33	98.4	2	3	242	162	248	XP_013902835.1 hypothetical protein MNEG_4139 [Monoraphidium neglectum]	diamond	3519	95.1	0.995793901156677	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
27253461	27253461	PRJNA980839_P_NODE_243423_length_233_cov_2.093750_g239639_i0	PRJNA980839	243423	233	2.09375	4.8784375	Eukaryota	2759	Plants	Plants	71.2	2.96e-12	NR	XP_042921747.1	3055	g239639	i0	50.6	5.04721030042918	79	35	99.1	3	2	232	464	540	XP_042921747.1 uncharacterized protein CHLRE_08g358563v5 [Chlamydomonas reinhardtii]	diamond	1176	71.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
28321076	28321076	PRJNA980839_P_NODE_133806_length_305_cov_1.327586_g130022_i0	PRJNA980839	133806	305	1.327586	4.0491373	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	60.8	3.4e-8	NR	KAH7619780.1	1650286	g130022	i0	34.5	4.27868852459016	87	52	81.6	2	48	296	727	812	KAH7619780.1 hypothetical protein NADE_008066 [Chlorella desiccata (nom. nud.)]	diamond	1305	60.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
29173854	29173854	PRJNA980839_P_NODE_210789_length_248_cov_0.880000_g207005_i0	PRJNA980839	210789	248	0.88	2.1824	Trebouxia sp. C	2796353	Plants	Plants	63.2	2.6e-9	NR	KAL3159037.1	3373145	g207005	i0	50.7	0.810483870967742	67	33	81	0	43	243	136	202	KAL3159037.1 hypothetical protein ABBQ32_011036 [Trebouxia sp. C0010 RCD-2024]	diamond	201	63.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
29394742	29394742	PRJNA980839_P_NODE_198989_length_251_cov_0.865169_g195205_i0	PRJNA980839	198989	251	0.865169	2.17157419	Chlamydomonas sp. UWO 241	1653778	Plants	Plants	59.3	6.14e-8	NR	KAG1666532.1	1653778	g195205	i0	44.6	0.884462151394422	74	36	88.4	1	244	23	1181	1249	KAG1666532.1 hypothetical protein FOA52_014429 [Chlamydomonas sp. UWO 241]	diamond	222	59.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. UWO 241
29773426	29773426	PRJNA980839_P_NODE_179891_length_263_cov_1.184211_g176107_i0	PRJNA980839	179891	263	1.184211	3.11447493	Chlorella sorokiniana	3076	Plants	Plants	62.8	4.13e-9	NR	PRW20203.1	3076	g176107	i0	46.9	0.923954372623574	81	39	92.4	2	261	19	222	298	PRW20203.1 60S ribosomal L7a [Chlorella sorokiniana]	diamond	243	62.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
32017735	32017735	PRJNA980839_P_NODE_83818_length_408_cov_0.874627_g80034_i0	PRJNA980839	83818	408	0.874627	3.56847816	Chlamydomonas reinhardtii	3055	Plants	Plants	49.3	0.0012	NR	XP_042917203.1	3055	g80034	i0	33.8	0.588235294117647	80	50	58.8	1	9	248	1093	1169	XP_042917203.1 uncharacterized protein CHLRE_13g564151v5 [Chlamydomonas reinhardtii]	diamond	240	49.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii

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