metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax_phylum = "Chlorophyta"

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
335702	335702	PRJNA1233317_S_NODE_8621_length_263_cov_3.186275_g8585_i0	PRJNA1233317	8621	263	3.186275	8.37990325	Viridiplantae	33090	Plants	Plants	57	1.94e-7	NR	KDD75683.1	1291522	g8585	i0	100	2.36121673003802	26	0	29.7	0	1	78	165	190	KDD75683.1 hypothetical protein H632_c551p0 [Helicosporidium sp. ATCC 50920]	diamond	621	57	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Helicosporidium	Helicosporidium sp. ATCC 50920
27389026	27389026	PRJNA1233317_S_NODE_2083_length_389_cov_2.469697_g2047_i0	PRJNA1233317	2083	389	2.469697	9.60712133	Chlamydomonas eustigma	1157962	Plants	Plants	52	9.6e-5	NR	GAX76654.1	1157962	g2047	i0	46.7	0.694087403598972	90	41	68.6	3	121	387	124	207	GAX76654.1 hypothetical protein CEUSTIGMA_g4100.t1 [Chlamydomonas eustigma]	diamond	270	52	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
28575759	28575759	PRJNA1233317_S_NODE_3047_length_359_cov_9.760000_g3011_i0	PRJNA1233317	3047	359	9.76	35.0384	Trebouxia	13786	Plants	Plants	65.9	9.91e-10	NR	KAL0029491.1	2905653	g3011	i0	57.1	1.22841225626741	49	21	40.9	0	2	148	350	398	KAL0029491.1 hypothetical protein WJX77_011613 [Trebouxia sp. C0004]	diamond	441	65.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0004
30326067	30326067	PRJNA1233317_S_NODE_13632_length_209_cov_1.626667_g13596_i0	PRJNA1233317	13632	209	1.626667	3.39973403	Micractinium conductrix	554055	Plants	Plants	58.5	6.42e-8	NR	PSC69493.1	554055	g13596	i0	49.2	0.933014354066986	65	33	93.3	0	13	207	809	873	PSC69493.1 Acyl-coenzyme A thioesterase mitochondrial [Micractinium conductrix]	diamond	195	58.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium conductrix
30641326	30641326	PRJNA1233317_S_NODE_9113_length_257_cov_2.646465_g9077_i0	PRJNA1233317	9113	257	2.646465	6.80141505	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	93.2	2.38e-22	NR	XP_005649206.1	574566	g9077	i0	79.2	1.23735408560311	53	11	61.9	0	255	97	13	65	XP_005649206.1 ribosomal protein 60S [Coccomyxa subellipsoidea C-169]	diamond	318	93.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea

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