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

6 rows where analysis = "diamond", bioproject = "PRJNA835051" 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
27117626	27117626	PRJNA835051_S_NODE_65722_length_198_cov_2.064516_g65426_i0	PRJNA835051	65722	198	2.064516	4.08774168	Micractinium tetrahymenae	2728915	Plants	Plants	42	0.0376	NR	KAL4439770.1	2728915	g65426	i0	36.4	1	66	37	93.9	2	188	3	294	358	KAL4439770.1 hypothetical protein ABPG75_002771 [Micractinium tetrahymenae]	diamond	198	42	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium tetrahymenae
27591939	27591939	PRJNA835051_S_NODE_3964_length_416_cov_49.619303_g3671_i0	PRJNA835051	3964	416	49.619303	206.41630048	Chlorophyceae sp. KF-2	2589020	Plants	Plants	45.4	0.028	NR	WLG71258.1	3068301	g3671	i0	30.2	0.764423076923077	106	58	71.4	4	321	25	485	581	WLG71258.1 hypothetical chloroplast protein RF1 [Johansenicoccus eremophilus]	diamond	318	45.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales		Johansenicoccus	Johansenicoccus eremophilus
28412750	28412750	PRJNA835051_S_NODE_72106_length_192_cov_1.261745_g71810_i0	PRJNA835051	72106	192	1.261745	2.4225504	Symbiochloris irregularis	706552	Plants	Plants	41.6	0.0353	NR	KAK9808269.1	706552	g71810	i0	35.2	0.84375	54	30	76.6	1	150	4	28	81	KAK9808269.1 hypothetical protein WJX73_005405 [Symbiochloris irregularis]	diamond	162	41.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
29865044	29865044	PRJNA835051_S_NODE_107371_length_164_cov_1.950413_g107075_i0	PRJNA835051	107371	164	1.950413	3.19867732	Astrephomene gubernaculifera	47775	Plants	Plants	42.7	0.0129	NR	GFR50098.1	47775	g107075	i0	43.4	0.969512195121951	53	25	87.8	1	20	163	686	738	GFR50098.1 hypothetical protein Agub_g12243 [Astrephomene gubernaculifera]	diamond	159	42.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Astrephomenaceae	Astrephomene	Astrephomene gubernaculifera
30718029	30718029	PRJNA835051_S_NODE_103094_length_167_cov_1.879032_g102798_i0	PRJNA835051	103094	167	1.879032	3.13798344	Micractinium sp. CCAP 211/92	554058	Plants	Plants	41.6	0.0348	NR	KAL4442104.1	554058	g102798	i0	40.4	0.934131736526946	52	31	93.4	0	9	164	702	753	KAL4442104.1 hypothetical protein ABPG77_011365 [Micractinium sp. CCAP 211/92]	diamond	156	41.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium sp. CCAP 211/92
31010937	31010937	PRJNA835051_S_NODE_31734_length_246_cov_2.724138_g31438_i0	PRJNA835051	31734	246	2.724138	6.70137948	Trebouxia	13786	Plants	Plants	45.1	0.00567	NR	KAA6420057.1	2608996	g31438	i0	66.7	0.951219512195122	39	13	47.6	0	4	120	259	297	KAA6420057.1 MAG: hypothetical protein FRX49_09906 [Trebouxia sp. A1-2]	diamond	234	45.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2

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