metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA597223" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA597223" 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
4397299	4397299	PRJNA597223_S_NODE_444_length_405_cov_1.800546_g387_i0	PRJNA597223	444	405	1.800546	7.2922113	Chlorellaceae	35461	Plants	Plants	249	1.08e-81	NR	PSC76847.1	554055	g387	i0	89.6	4.99259259259259	134	14	99.3	0	2	403	17	150	PSC76847.1 mitochondrial import inner membrane translocase subunit TIM17-2-like [Micractinium conductrix]	diamond	2022	251	0.99203187250996006	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium conductrix
20971300	20971300	PRJNA597223_P_NODE_35897_length_243_cov_1.524038_g34051_i0	PRJNA597223	35897	243	1.524038	3.70341234	Eukaryota	2759	Plants	Plants	120	4.06e-32	NR	CAD7699794.1	121088	g34051	i0	67.5	3.91358024691358	80	26	98.8	0	242	3	98	177	CAD7699794.1 unnamed protein product [Ostreobium quekettii]	diamond	951	121	0.991735537190083	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii
24795775	24795775	PRJNA597223_S_NODE_2600_length_191_cov_1.447368_g2543_i0	PRJNA597223	2600	191	1.447368	2.76447288	Coccomyxa sp. Obi	2315456	Plants	Plants	112	3.03e-28	NR	BDA46065.1	2315456	g2543	i0	88.9	1.96335078534031	63	7	99	0	189	1	78	140	BDA46065.1 40S ribosomal protein S8 [Coccomyxa sp. Obi]	diamond	375	112	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa sp. Obi
28248212	28248212	PRJNA597223_P_NODE_45246_length_209_cov_2.494253_g43400_i0	PRJNA597223	45246	209	2.494253	5.21298877	Myrmecia israelensis	3171	Plants	Plants	45.8	8.09e-4	NR	XAI67159.1	3171	g43400	i0	48.4	2.09569377990431	62	26	87.6	3	203	21	14	70	XAI67159.1 ribosomal protein S10 [Myrmecia israelensis]	diamond	438	45.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	Myrmecia israelensis
28248219	28248219	PRJNA597223_P_NODE_55086_length_189_cov_2.181818_g53240_i0	PRJNA597223	55086	189	2.181818	4.12363602	Ostreobium quekettii	121088	Plants	Plants	59.7	2.53e-9	NR	YP_009720773.1	121088	g53240	i0	47.1	0.80952380952381	51	27	81	0	2	154	36	86	YP_009720773.1 putative LAGLIDADG endonuclease [Ostreobium quekettii]	diamond	153	59.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii
30711727	30711727	PRJNA597223_S_NODE_5014_length_152_cov_1.654867_g4957_i0	PRJNA597223	5014	152	1.654867	2.51539784	Chlorella vulgaris	3077	Plants	Plants	40.8	0.0498	NR	KAI3433415.1	3077	g4957	i0	77.3	0.434210526315789	22	5	43.4	0	87	152	1	22	KAI3433415.1 hypothetical protein D9Q98_003230 [Chlorella vulgaris]	diamond	66	40.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
30964658	30964658	PRJNA597223_S_NODE_2774_length_186_cov_2.333333_g2717_i0	PRJNA597223	2774	186	2.333333	4.33999938	Prototheca wickerhamii	3111	Plants	Plants	63.2	2.45e-10	NR	KAK2075825.1	3111	g2717	i0	100	0.467741935483871	29	0	46.8	0	1	87	152	180	KAK2075825.1 hypothetical protein QBZ16_001566 [Prototheca wickerhamii]	diamond	87	63.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
32229745	32229745	PRJNA597223_P_NODE_46498_length_206_cov_1.730994_g44652_i0	PRJNA597223	46498	206	1.730994	3.56584764	Chlorella vulgaris	3077	Plants	Plants	80.5	1.15e-15	NR	KAI3429398.1	3077	g44652	i0	56.7	2.92718446601942	67	27	94.7	1	195	1	136	202	KAI3429398.1 hypothetical protein D9Q98_005493 [Chlorella vulgaris]	diamond	603	80.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
32261475	32261475	PRJNA597223_P_NODE_26698_length_299_cov_0.981061_g24853_i0	PRJNA597223	26698	299	0.981061	2.93337239	Ostreobium quekettii	121088	Plants	Plants	49.7	4.04e-5	NR	YP_009720772.1	121088	g24853	i0	38.5	0.782608695652174	78	42	74.2	2	298	77	6	81	YP_009720772.1 putative LAGLIDADG DNA endonuclease [Ostreobium quekettii]	diamond	234	49.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii
32609065	32609065	PRJNA597223_P_NODE_36380_length_241_cov_1.067961_g34534_i0	PRJNA597223	36380	241	1.067961	2.57378601	Edaphochlamys debaryana	47281	Plants	Plants	57	1.03e-7	NR	KAG2497223.1	47281	g34534	i0	34.1	2.19087136929461	88	49	98.3	1	3	239	1	88	KAG2497223.1 hypothetical protein HYH03_004812 [Edaphochlamys debaryana]	diamond	528	57	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana

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