metadata: contig_metadata: 4 rows where bioproject = "PRJNA532380" and tax

4 rows where bioproject = "PRJNA532380" 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
1779050	1779050	PRJNA532380_P_NODE_19962_length_201_cov_1.710526_g19637_i0	PRJNA532380	19962	201	1.710526	3.43815726	Haematococcus lacustris	44745	Plants	Plants	239	1.25e-58	NTclustered	gi\|1279575454\|gb\|MF683078.1\|	44745	g19637	i0	88.832	196.965174129353	197	18	97	3	2	196	2837	2643	Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast	blastn	39590	239	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
27741292	27741292	PRJNA532380_P_NODE_32404_length_163_cov_0.912281_g32079_i0	PRJNA532380	32404	163	0.912281	1.48701803	Auxenochlorella protothecoides	3075	Plants	Plants	72.4	5.66e-14	NR	XP_011401207.1	3075	g32079	i0	66.7	1.98773006134969	54	17	97.5	1	161	3	89	142	XP_011401207.1 60S ribosomal protein L17-2 [Auxenochlorella protothecoides]	diamond	324	72.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
28467319	28467319	PRJNA532380_P_NODE_28626_length_168_cov_0.873950_g28301_i0	PRJNA532380	28626	168	0.87395	1.468236	Chlamydomonas incerta	51695	Plants	Plants	41.6	0.035	NR	KAG2428221.1	51695	g28301	i0	48.9	0.803571428571429	45	20	76.8	2	161	33	231	274	KAG2428221.1 hypothetical protein HXX76_011900 [Chlamydomonas incerta]	diamond	135	41.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
30882503	30882503	PRJNA532380_P_NODE_10074_length_293_cov_1.278689_g9749_i0	PRJNA532380	10074	293	1.278689	3.74655877	Chlamydomonadales	3042	Plants	Plants	87.4	8.89e-18	NR	KAF5829124.1	3046	g9749	i0	48.7	3.19453924914676	78	40	79.9	0	3	236	109	186	KAF5829124.1 hypothetical protein DUNSADRAFT_16524 [Dunaliella salina]	diamond	936	87.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina

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