metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA814235" 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
28579112	28579112	PRJNA814235_P_NODE_188467_length_151_cov_3.236842_g187072_i0	PRJNA814235	188467	151	3.236842	4.88763142	Chlorophyta	3041	Plants	Plants	47	3.44e-4	NR	WIA33976.1	3088	g187072	i0	80	1.98675496688742	25	5	49.7	0	2	76	1370	1394	WIA33976.1 hypothetical protein OEZ86_007071 [Tetradesmus obliquus]	diamond	300	47.4	0.991561181434599	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
28736889	28736889	PRJNA814235_P_NODE_182407_length_151_cov_6.201754_g181012_i0	PRJNA814235	182407	151	6.201754	9.36464854	Chlamydomonadaceae	3051	Plants	Plants	48.1	1.34e-4	NR	XP_042919674.1	3055	g181012	i0	87.5	1.90728476821192	24	3	47.7	0	73	2	217	240	XP_042919674.1 uncharacterized protein CHLRE_11g478128v5 [Chlamydomonas reinhardtii]	diamond	288	48.5	0.991752577319588	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
28958103	28958103	PRJNA814235_P_NODE_159268_length_167_cov_1.200000_g157873_i0	PRJNA814235	159268	167	1.2	2.004	root	1	Root_unresolved	Root_unresolved	41.6	0.0343	NR	KAL4419452.1	554058	g157873	i0	67.7	2.62275449101796	31	8	55.7	1	10	102	301	329	KAL4419452.1 hypothetical protein ABPG77_003565 [Micractinium sp. CCAP 211/92]	diamond	438	42	0.990476190476191	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium sp. CCAP 211/92
30189420	30189420	PRJNA814235_P_NODE_129892_length_195_cov_2.221519_g128497_i0	PRJNA814235	129892	195	2.221519	4.33196205	Eukaryota	2759	Plants	Plants	51.2	1.97e-5	NR	KAJ9523472.1	44745	g128497	i0	56.8	2.89230769230769	44	19	67.7	0	154	23	322	365	KAJ9523472.1 hypothetical protein QJQ45_007163 [Haematococcus lacustris]	diamond	564	51.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
31159853	31159853	PRJNA814235_P_NODE_199735_length_150_cov_3.070796_g198340_i0	PRJNA814235	199735	150	3.070796	4.606194	Picochlorum sp. BPE23	2696299	Plants	Plants	89	5.53e-19	NR	KAI8101159.1	2696299	g198340	i0	89.3	1.12	56	0	100	1	150	1	417	472	KAI8101159.1 hypothetical protein M9435_001267 [Picochlorum sp. BPE23]	diamond	168	89	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp. BPE23
31769796	31769796	PRJNA814235_P_NODE_100437_length_203_cov_2.427711_g99042_i0	PRJNA814235	100437	203	2.427711	4.92825333	Picochlorum	249344	Plants	Plants	53.5	3.48e-6	NR	WPT14201.1	1470871	g99042	i0	100	0.70935960591133	24	0	35.5	0	3	74	267	290	WPT14201.1 Dolichyl-diphosphooligosaccharide--protein glycosyltransferase 48 kDa subunit [Picochlorum sp. SENEW3]	diamond	144	53.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp. SENEW3
32835452	32835452	PRJNA814235_P_NODE_108400_length_203_cov_2.114458_g107005_i0	PRJNA814235	108400	203	2.114458	4.29234974	Picochlorum sp. BPE23	2696299	Plants	Plants	55.5	7.12e-7	NR	KAI8103910.1	2696299	g107005	i0	100	0.369458128078818	25	0	36.9	0	203	129	142	166	KAI8103910.1 hypothetical protein M9435_006436 [Picochlorum sp. BPE23]	diamond	75	55.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp. BPE23

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