metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA404067" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA404067" 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
27265159	27265159	PRJNA404067_P_NODE_29063_length_213_cov_1.723684_g28676_i0	PRJNA404067	29063	213	1.723684	3.67144692	Sarcinofilum mucosum	141643	Plants	Plants	68.6	2.1e-11	NR	YP_009367396.1	141643	g28676	i0	58	1.36619718309859	50	21	70.4	0	1	150	640	689	YP_009367396.1 beta'' subunit of RNA polymerase [Sarcinofilum mucosum]	diamond	291	68.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Sarcinofilaceae	Sarcinofilum	Sarcinofilum mucosum
29475086	29475086	PRJNA404067_P_NODE_21450_length_232_cov_1.947368_g21063_i0	PRJNA404067	21450	232	1.947368	4.51789376	Rhexinema sarcinoideum	43261	Plants	Plants	91.7	1.83e-19	NR	AOC61494.1	43261	g21063	i0	94.1	3.95689655172414	51	3	65.9	0	80	232	1	51	AOC61494.1 cytochrome c oxidase subunit 1 [Rhexinema sarcinoideum]	diamond	918	91.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Helicodictyaceae	Rhexinema	Rhexinema sarcinoideum
29601380	29601380	PRJNA404067_P_NODE_32850_length_207_cov_1.061644_g32463_i0	PRJNA404067	32850	207	1.061644	2.19760308	Scenedesmus sp. PABB	2909984	Plants	Plants	49.3	1.14e-4	NR	KAF8061395.1	2742167	g32463	i0	50	0.695652173913043	48	22	66.7	1	205	68	850	897	KAF8061395.1 KCS1 [Scenedesmus sp. PABB004]	diamond	144	49.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
29886050	29886050	PRJNA404067_P_NODE_31411_length_209_cov_0.864865_g31024_i0	PRJNA404067	31411	209	0.864865	1.80756785	Micractinium tetrahymenae	2728915	Plants	Plants	67	6.42e-11	NR	KAL4427737.1	2728915	g31024	i0	43.3	0.961722488038278	67	36	96.2	1	204	4	54	118	KAL4427737.1 hypothetical protein ABPG75_001826 [Micractinium tetrahymenae]	diamond	201	67	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium tetrahymenae
31324417	31324417	PRJNA404067_P_NODE_30595_length_210_cov_1.375839_g30208_i0	PRJNA404067	30595	210	1.375839	2.8892619	Picochlorum	249344	Plants	Plants	129	1.0699999999999999e-32	NR	WPT16749.1	1470871	g30208	i0	98.3	2.52857142857143	59	1	84.3	0	200	24	474	532	WPT16749.1 Long chain acyl-CoA synthetase 7, peroxisomal [Picochlorum sp. SENEW3]	diamond	531	129	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp. SENEW3
32320424	32320424	PRJNA404067_P_NODE_5219_length_606_cov_2.733945_g4862_i0	PRJNA404067	5219	606	2.733945	16.5677067	Chlamydomonas reinhardtii	3055	Plants	Plants	77.8	8.25e-13	NR	XP_042927233.1	3055	g4862	i0	55.2	0.331683168316832	67	28	32.2	1	1	195	425	491	XP_042927233.1 uncharacterized protein CHLRE_02g095139v5 [Chlamydomonas reinhardtii]	diamond	201	77.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii

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