metadata: contig_metadata: 10 rows where bioproject = "PRJNA983838" and tax

10 rows where bioproject = "PRJNA983838" 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
25192216	25192216	PRJNA983838_P_NODE_93600_length_271_cov_1.525253_g91233_i0	PRJNA983838	93600	271	1.525253	4.13343563	Chlorophyta	3041	Plants	Plants	138	9.21e-38	NR	CAG9462523.1	765719	g91233	i0	72.2	72.7306273062731	90	25	99.6	0	2	271	152	241	CAG9462523.1 unnamed protein product [Pedinophyceae sp. YPF-701]	diamond	19710	138	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae				Pedinophyceae sp. YPF-701
28990598	28990598	PRJNA983838_P_NODE_83588_length_291_cov_1.431193_g81221_i0	PRJNA983838	83588	291	1.431193	4.16477163	Chlorophyta	3041	Plants	Plants	120	3.24e-29	NR	KAL4853064.1	3077	g81221	i0	62.9	19.0721649484536	89	33	91.8	0	289	23	1390	1478	KAL4853064.1 Proteasome subunit alpha type-2 [Chlorella vulgaris]	diamond	5550	121	0.991735537190083	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
29363264	29363264	PRJNA983838_P_NODE_104429_length_253_cov_0.866667_g102062_i0	PRJNA983838	104429	253	0.866667	2.19266751	Volvox reticuliferus	1737510	Plants	Plants	58.5	1.14e-7	NR	GIL88831.1	1737510	g102062	i0	37	1.92094861660079	81	50	94.9	1	249	10	459	539	GIL88831.1 hypothetical protein Vretifemale_16749 [Volvox reticuliferus]	diamond	486	58.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox reticuliferus
30380262	30380262	PRJNA983838_P_NODE_26312_length_745_cov_7.004464_g24058_i0	PRJNA983838	26312	745	7.004464	52.1832568	Eukaryota	2759	Plants	Plants	165	5.79e-45	NR	WIA40358.1	3088	g24058	i0	45.5	7.40134228187919	189	99	74.5	3	4	558	202	390	WIA40358.1 hypothetical protein OEZ86_013722 [Tetradesmus obliquus]	diamond	5514	166	0.993975903614458	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
30911158	30911158	PRJNA983838_P_NODE_71794_length_325_cov_1.238095_g69427_i0	PRJNA983838	71794	325	1.238095	4.02380875	Chlamydomonas sp. UWO 241	1653778	Plants	Plants	51.2	9.29e-5	NR	KAG1665159.1	1653778	g69427	i0	56.9	0.470769230769231	51	21	47.1	1	6	158	292	341	KAG1665159.1 hypothetical protein FOA52_005540 [Chlamydomonas sp. UWO 241]	diamond	153	51.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. UWO 241
31106453	31106453	PRJNA983838_P_NODE_117115_length_243_cov_1.270588_g114748_i0	PRJNA983838	117115	243	1.270588	3.08752884	Chlamydomonadales	3042	Plants	Plants	109	1.41e-29	NR	XP_042924859.1	3055	g114748	i0	82	2.2962962962963	61	11	75.3	0	6	188	1	61	XP_042924859.1 uncharacterized protein CHLRE_05g237700v5 [Chlamydomonas reinhardtii]	diamond	558	110	0.990909090909091	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
31194966	31194966	PRJNA983838_P_NODE_108115_length_250_cov_0.881356_g105748_i0	PRJNA983838	108115	250	0.881356	2.20339	Scenedesmus sp. PABB	2909984	Plants	Plants	49.3	1.93e-4	NR	KAF8055395.1	2742167	g105748	i0	73.3	0.36	30	8	36	0	236	147	134	163	KAF8055395.1 XBAT31 [Scenedesmus sp. PABB004]	diamond	90	49.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
31290133	31290133	PRJNA983838_P_NODE_105235_length_252_cov_1.743017_g102868_i0	PRJNA983838	105235	252	1.743017	4.39240284	Coccomyxa elongata	1965095	Plants	Plants	84	1.29e-16	NR	CAL8466735.1	1965095	g102868	i0	54.1	0.880952380952381	74	34	88.1	0	238	17	696	769	CAL8466735.1 g6271 [Coccomyxa elongata]	diamond	222	84	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa elongata
31448467	31448467	PRJNA983838_P_NODE_122016_length_231_cov_2.803797_g119649_i0	PRJNA983838	122016	231	2.803797	6.47677107	Symbiochloris irregularis	706552	Plants	Plants	100	5.04e-23	NR	KAK9807924.1	706552	g119649	i0	56.6	0.987012987012987	76	30	97.4	2	1	225	80	153	KAK9807924.1 hypothetical protein WJX73_002821 [Symbiochloris irregularis]	diamond	228	100	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
32750651	32750651	PRJNA983838_P_NODE_107520_length_250_cov_2.508475_g105153_i0	PRJNA983838	107520	250	2.508475	6.2711875	Eukaryota	2759	Plants	Plants	138	8.64e-39	NR	XP_011401684.1	3075	g105153	i0	84.3	1776.804	83	13	99.6	0	249	1	12	94	XP_011401684.1 Histone H3.1 [Auxenochlorella protothecoides]	diamond	444201	139	0.992805755395683	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides

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