metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB9859" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB9859" 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
1419613	1419613	PRJEB9859_P_NODE_2202_length_311_cov_1.556738_g2167_i0	PRJEB9859	2202	311	1.556738	4.84145518	[Myrmecia] bisecta	41462	Plants	Plants	86.3	2.78e-18	NR	KAK9817689.1	41462	g2167	i0	83.7	3.80064308681672	49	8	47.3	0	306	160	160	208	KAK9817689.1 hypothetical protein WJX72_000657 [[Myrmecia] bisecta]	diamond	1182	86.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
26812855	26812855	PRJEB9859_P_NODE_3821_length_259_cov_5.195652_g3786_i0	PRJEB9859	3821	259	5.195652	13.45673868	Monoraphidium minutum	39955	Plants	Plants	90.5	6.99e-19	NR	KAI8476985.1	39955	g3786	i0	64.2	0.776061776061776	67	23	77.6	1	257	57	780	845	KAI8476985.1 MAG: elongation factor 2 [Monoraphidium minutum]	diamond	201	90.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium minutum
27438089	27438089	PRJEB9859_P_NODE_423_length_507_cov_5.924686_g399_i0	PRJEB9859	423	507	5.924686	30.03815802	Chlorophyta	3041	Plants	Plants	99	1.2300000000000002e-21	NR	GBF95511.1	307507	g399	i0	38.3	1.65680473372781	141	80	82.2	3	505	89	141	276	GBF95511.1 60S ribosomal protein L18a-2 [Raphidocelis subcapitata]	diamond	840	100	0.99	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Raphidocelis	Raphidocelis subcapitata
28045049	28045049	PRJEB9859_P_NODE_6405_length_225_cov_4.581633_g6370_i0	PRJEB9859	6405	225	4.581633	10.30867425	Scenedesmus sp. PABB	2909984	Plants	Plants	66.2	1.56e-10	NR	KAF8058473.1	2742167	g6370	i0	84.2	4.74666666666667	38	6	50.7	0	225	112	574	611	KAF8058473.1 RpL37a [Scenedesmus sp. PABB004]	diamond	1068	66.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
28069305	28069305	PRJEB9859_P_NODE_1125_length_379_cov_6.782857_g1091_i0	PRJEB9859	1125	379	6.782857	25.70702803	Eukaryota	2759	Plants	Plants	117	1.4399999999999998e-30	NR	ADB77798.1	34128	g1091	i0	57.1	26.6200527704485	98	42	77.6	0	376	83	77	174	ADB77798.1 40S ribosomal protein S9, partial [Cladophora coelothrix]	diamond	10089	117	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Cladophorales	Cladophoraceae	Cladophora	Cladophora coelothrix
28290180	28290180	PRJEB9859_P_NODE_966_length_396_cov_9.528610_g932_i0	PRJEB9859	966	396	9.52861	37.7332956	Chlamydomonadaceae	3051	Plants	Plants	164	1.74e-48	NR	GAX77325.1	1157962	g932	i0	70.8	5.98484848484848	113	33	85.6	0	388	50	92	204	GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma]	diamond	2370	164	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
30413784	30413784	PRJEB9859_P_NODE_2993_length_282_cov_2.039526_g2958_i0	PRJEB9859	2993	282	2.039526	5.75146332	Tetradesmus obliquus	3088	Plants	Plants	72.4	1.64e-12	NR	WIA20814.1	3088	g2958	i0	54.4	0.723404255319149	68	31	72.3	0	276	73	277	344	WIA20814.1 hypothetical protein OEZ85_005170 [Tetradesmus obliquus]	diamond	204	72.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
32437417	32437417	PRJEB9859_P_NODE_4299_length_250_cov_2.185520_g4264_i0	PRJEB9859	4299	250	2.18552	5.4638	[Myrmecia] bisecta	41462	Plants	Plants	43.1	0.0297	NR	KAK9813021.1	41462	g4264	i0	71.4	0.336	28	8	33.6	0	246	163	508	535	KAK9813021.1 hypothetical protein WJX72_007639 [[Myrmecia] bisecta]	diamond	84	43.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta

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