metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB58983" 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
1399265	1399265	PRJEB58983_P_NODE_20902_length_285_cov_1.452830_g20487_i0	PRJEB58983	20902	285	1.45283	4.1405655	Chlorophyceae	3166	Plants	Plants	81.3	4.23e-17	NR	GFR49314.1	47775	g20487	i0	53.8	8.8	93	41	97.9	1	280	2	43	133	GFR49314.1 hypothetical protein Agub_g11337, partial [Astrephomene gubernaculifera]	diamond	2508	81.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Astrephomenaceae	Astrephomene	Astrephomene gubernaculifera
2675075	2675075	PRJEB58983_P_NODE_29863_length_248_cov_0.891429_g29448_i0	PRJEB58983	29863	248	0.891429	2.21074392	Pedinophyceae sp. YPF-7	765719	Plants	Plants	105	2.5e-27	NR	CAG9462952.1	765719	g29448	i0	80	36.5443548387097	60	12	72.6	0	247	68	48	107	CAG9462952.1 unnamed protein product [Pedinophyceae sp. YPF-701]	diamond	9063	105	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae				Pedinophyceae sp. YPF-701
11603731	11603731	PRJEB58983_P_NODE_9830_length_398_cov_2.360000_g9416_i0	PRJEB58983	9830	398	2.36	9.3928	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	166	1.6299999999999998e-48	NR	XP_005643653.1	574566	g9416	i0	65.5	4.46984924623116	119	41	89.7	0	396	40	129	247	XP_005643653.1 60S ribosomal protein L7 [Coccomyxa subellipsoidea C-169]	diamond	1779	166	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
12471079	12471079	PRJEB58983_P_NODE_22790_length_275_cov_2.405941_g22375_i0	PRJEB58983	22790	275	2.405941	6.61633775	Eukaryota	2759	Plants	Plants	108	2.1899999999999998e-25	NR	XP_011395806.1	3075	g22375	i0	61.2	11.6945454545455	85	33	92.7	0	256	2	351	435	XP_011395806.1 2-Cys peroxiredoxin BAS1, chloroplastic [Auxenochlorella protothecoides]	diamond	3216	109	0.990825688073395	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
12471166	12471166	PRJEB58983_P_NODE_7430_length_453_cov_5.028947_g7016_i0	PRJEB58983	7430	453	5.028947	22.78112991	Eukaryota	2759	Plants	Plants	157	5.73e-46	NR	CAD7703578.1	121088	g7016	i0	52.7	15.8079470198675	146	67	95.4	1	439	8	7	152	CAD7703578.1 unnamed protein product [Ostreobium quekettii]	diamond	7161	157	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii
12878506	12878506	PRJEB58983_P_NODE_23731_length_271_cov_1.444444_g23316_i0	PRJEB58983	23731	271	1.444444	3.91444324	Pedinophyceae sp. YPF-7	765719	Plants	Plants	107	7.9799999999999985e-25	NR	CAG9463295.1	765719	g23316	i0	55.6	4.81549815498155	90	34	93	2	269	18	264	353	CAG9463295.1 unnamed protein product [Pedinophyceae sp. YPF-701]	diamond	1305	107	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae				Pedinophyceae sp. YPF-701
26805217	26805217	PRJEB58983_P_NODE_5321_length_533_cov_1.491304_g4908_i0	PRJEB58983	5321	533	1.491304	7.94865032	Eukaryota	2759	Plants	Plants	241	1.0999999999999999e-73	NR	KAL4856475.1	3077	g4908	i0	69.3	15.8893058161351	176	53	98.5	1	528	4	1	176	KAL4856475.1 40S ribosomal protein S3a [Chlorella vulgaris]	diamond	8469	243	0.991769547325103	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
27248085	27248085	PRJEB58983_P_NODE_5443_length_526_cov_3.701987_g5030_i0	PRJEB58983	5443	526	3.701987	19.47245162	Eukaryota	2759	Plants	Plants	131	1.82e-35	NR	XP_011396880.1	3075	g5030	i0	45.4	11.3897338403042	152	67	85.6	2	504	55	14	151	XP_011396880.1 40S ribosomal protein S19-1 [Auxenochlorella protothecoides]	diamond	5991	132	0.992424242424242	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
27444720	27444720	PRJEB58983_P_NODE_20563_length_287_cov_1.084112_g20148_i0	PRJEB58983	20563	287	1.084112	3.11140144	Chlamydomonas schloesseri	2026947	Plants	Plants	64.7	1.26e-9	NR	KAG2435551.1	2026947	g20148	i0	40.4	3.66898954703833	89	48	93	1	280	14	3435	3518	KAG2435551.1 hypothetical protein HYH02_011845 [Chlamydomonas schloesseri]	diamond	1053	64.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas schloesseri
28290009	28290009	PRJEB58983_P_NODE_35606_length_199_cov_4.095238_g35191_i0	PRJEB58983	35606	199	4.095238	8.14952362	Eukaryota	2759	Plants	Plants	46.6	9.39e-4	NR	PRW60009.1	3076	g35191	i0	45.1	1.55276381909548	51	28	76.9	0	196	44	170	220	PRW60009.1 GTP-binding nuclear Ran [Chlorella sorokiniana]	diamond	309	47	0.991489361702128	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
29559745	29559745	PRJEB58983_P_NODE_22070_length_279_cov_1.393204_g21655_i0	PRJEB58983	22070	279	1.393204	3.88703916	Chlamydomonas sp. UWO 241	1653778	Plants	Plants	43.1	0.041	NR	KAG1662144.1	1653778	g21655	i0	30.3	0.817204301075269	76	44	72	2	2	202	370	445	KAG1662144.1 hypothetical protein FOA52_011017 [Chlamydomonas sp. UWO 241]	diamond	228	43.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. UWO 241
30343313	30343313	PRJEB58983_P_NODE_32412_length_242_cov_0.923077_g31997_i0	PRJEB58983	32412	242	0.923077	2.23384634	Eukaryota	2759	Plants	Plants	74.7	1.04e-13	NR	KAI3434606.1	3077	g31997	i0	44.9	3	78	40	93	2	231	7	104	181	KAI3434606.1 hypothetical protein D9Q98_002674 [Chlorella vulgaris]	diamond	726	75.1	0.994673768308922	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
30602188	30602188	PRJEB58983_P_NODE_30213_length_247_cov_1.362069_g29798_i0	PRJEB58983	30213	247	1.362069	3.36431043	Chlamydomonas sp. HS-5	108458	Plants	Plants	95.9	1.9799999999999998e-23	NR	BAA78583.1	108458	g29798	i0	66.2	1.67611336032389	71	24	86.2	0	214	2	7	77	BAA78583.1 60S ribosomal protein L31 [Chlamydomonas sp. HS-5]	diamond	414	95.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. HS-5
30848331	30848331	PRJEB58983_P_NODE_13114_length_349_cov_3.807971_g12699_i0	PRJEB58983	13114	349	3.807971	13.28981879	Chlamydomonadales	3042	Plants	Plants	160	4.47e-47	NR	GFH24947.1	44745	g12699	i0	70.6	6.55014326647564	109	32	93.7	0	348	22	96	204	GFH24947.1 ribosomal protein L15, partial [Haematococcus lacustris]	diamond	2286	161	0.993788819875776	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris

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