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

14 rows where analysis = "diamond", bioproject = "PRJEB3181" 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
2264105	2264105	PRJEB3181_P_NODE_11042_length_256_cov_1.835556_g10778_i0	PRJEB3181	11042	256	1.835556	4.69902336	root	1	Root_unresolved	Root_unresolved	132	1.38e-37	NR	8A22_Bl	353565	g10778	i0	75	14.15625	80	20	93.8	0	246	7	41	120	8A22_Bl Chain Bl, uS12m [Polytomella magna]	diamond	3624	133	0.992481203007519	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella magna
3882194	3882194	PRJEB3181_S_NODE_1824_length_381_cov_54.352601_g1532_i0	PRJEB3181	1824	381	54.352601	207.08340981	Monoraphidium neglectum	145388	Plants	Plants	85.1	1.35e-17	NR	XP_013899290.1	145388	g1532	i0	54.8	0.574803149606299	73	33	57.5	0	380	162	120	192	XP_013899290.1 hypothetical protein MNEG_7690 [Monoraphidium neglectum]	diamond	219	85.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
5158339	5158339	PRJEB3181_P_NODE_5485_length_348_cov_7.678233_g5232_i0	PRJEB3181	5485	348	7.678233	26.72025084	Edaphochlamys debaryana	47281	Plants	Plants	122	8.799999999999999e-32	NR	KAG2490121.1	47281	g5232	i0	58.9	3.25862068965517	95	39	81.9	0	347	63	113	207	KAG2490121.1 hypothetical protein HYH03_011427 [Edaphochlamys debaryana]	diamond	1134	122	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana
14084242	14084242	PRJEB3181_P_NODE_23552_length_167_cov_1.389706_g23287_i0	PRJEB3181	23552	167	1.389706	2.32080902	Sanguina aurantia	2578422	Plants	Plants	64.7	2.37e-10	NR	MEW5303513.1	2578422	g23287	i0	70.7	4.43712574850299	41	12	73.7	0	159	37	689	729	MEW5303513.1 hypothetical protein [Sanguina aurantia]	diamond	741	64.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Sanguina	Sanguina aurantia
17566662	17566662	PRJEB3181_P_NODE_8514_length_290_cov_4.393822_g8251_i0	PRJEB3181	8514	290	4.393822	12.7420838	Prototheca wickerhamii	3111	Plants	Plants	115	1.94e-30	NR	KAK2076719.1	3111	g8251	i0	67.5	7.62413793103448	83	24	83.8	2	286	44	75	156	KAK2076719.1 30S ribosomal protein S11, chloroplastic [Prototheca wickerhamii]	diamond	2211	115	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
27096470	27096470	PRJEB3181_S_NODE_12722_length_181_cov_2.445205_g12429_i0	PRJEB3181	12722	181	2.445205	4.42582105	Auxenochlorella protothecoides	3075	Plants	Plants	42.7	0.00172	NR	ARV87666.1	3075	g12429	i0	55.6	0.596685082872928	36	16	59.7	0	32	139	7	42	ARV87666.1 hypothetical protein BW920_0084 [Auxenochlorella protothecoides]	diamond	108	42.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
27980946	27980946	PRJEB3181_P_NODE_19045_length_189_cov_2.651899_g18781_i0	PRJEB3181	19045	189	2.651899	5.01208911	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	46.2	0.00113	NR	KAG7670944.1	1650286	g18781	i0	66.7	1.23809523809524	39	13	61.9	0	153	37	951	989	KAG7670944.1 hypothetical protein KSW81_004372 [Chlorella desiccata (nom. nud.)]	diamond	234	46.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
28454686	28454686	PRJEB3181_P_NODE_10506_length_262_cov_1.445887_g10242_i0	PRJEB3181	10506	262	1.445887	3.78822394	Gonium pectorale	33097	Plants	Plants	142	3.9e-41	NR	KXZ52281.1	33097	g10242	i0	76.5	4.67175572519084	81	19	92.7	0	247	5	26	106	KXZ52281.1 hypothetical protein GPECTOR_10g913 [Gonium pectorale]	diamond	1224	142	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
28637609	28637609	PRJEB3181_P_NODE_15767_length_211_cov_4.333333_g15503_i0	PRJEB3181	15767	211	4.333333	9.14333263	Picochlorum	249344	Plants	Plants	53.5	6.63e-7	NR	WPT16014.1	1470871	g15503	i0	64.4	1.90521327014218	45	16	64	0	211	77	81	125	WPT16014.1 60S ribosomal protein L36-3 [Picochlorum sp. SENEW3]	diamond	402	53.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp. SENEW3
30412755	30412755	PRJEB3181_P_NODE_28253_length_150_cov_1.554622_g27988_i0	PRJEB3181	28253	150	1.554622	2.331933	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	84.7	1.25e-17	NR	KAL4522675.1	1650286	g27988	i0	74	1	50	13	100	0	150	1	354	403	KAL4522675.1 hypothetical protein Ndes2437A_g07435 [Chlorella desiccata (nom. nud.)]	diamond	150	84.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
30563568	30563568	PRJEB3181_P_NODE_27053_length_154_cov_1.317073_g26788_i0	PRJEB3181	27053	154	1.317073	2.02829242	Chlorophyta	3041	Plants	Plants	49.7	3.8e-5	NR	PRW58830.1	3076	g26788	i0	62.5	3.8961038961039	40	15	77.9	0	3	122	397	436	PRW58830.1 hydrogenase assembly factor [Chlorella sorokiniana]	diamond	600	49.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
30791563	30791563	PRJEB3181_P_NODE_15554_length_213_cov_1.241758_g15290_i0	PRJEB3181	15554	213	1.241758	2.64494454	Chlamydomonas eustigma	1157962	Plants	Plants	122	1.08e-33	NR	GAX78121.1	1157962	g15290	i0	81.4	4.92957746478873	70	13	98.6	0	2	211	13	82	GAX78121.1 hypothetical protein CEUSTIGMA_g5563.t1 [Chlamydomonas eustigma]	diamond	1050	122	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
31259062	31259062	PRJEB3181_P_NODE_5955_length_337_cov_4.575163_g5699_i0	PRJEB3181	5955	337	4.575163	15.41829931	Eukaryota	2759	Plants	Plants	83.2	7.99e-18	NR	WIA17024.1	3088	g5699	i0	97.6	218.964391691395	41	1	36.5	0	335	213	62	102	WIA17024.1 hypothetical protein OEZ85_013933 [Tetradesmus obliquus]	diamond	73791	84	0.990476190476191	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
32846010	32846010	PRJEB3181_P_NODE_2340_length_464_cov_2.799076_g2147_i0	PRJEB3181	2340	464	2.799076	12.98771264	Chlamydomonas eustigma	1157962	Plants	Plants	188	1.18e-57	NR	GAX77325.1	1157962	g2147	i0	67.6	3.67241379310345	142	46	91.8	0	462	37	63	204	GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma]	diamond	1704	188	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma

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