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

4 rows where bioproject = "PRJNA602115" 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
17720784	17720784	PRJNA602115_P_NODE_7814_length_225_cov_1.195122_g7789_i0	PRJNA602115	7814	225	1.195122	2.6890245	Eukaryota	2759	Plants	Plants	114	2.6600000000000003e-27	NR	KAK9796680.1	706552	g7789	i0	72	6.97333333333333	75	21	100	0	1	225	437	511	KAK9796680.1 hypothetical protein WJX73_008232 [Symbiochloris irregularis]	diamond	1569	114	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
28122206	28122206	PRJNA602115_P_NODE_9225_length_208_cov_0.870748_g9200_i0	PRJNA602115	9225	208	0.870748	1.81115584	Chlamydomonas eustigma	1157962	Plants	Plants	72	3.88e-13	NR	GAX76853.1	1157962	g9200	i0	54.4	2.85576923076923	68	29	96.6	2	205	5	23	89	GAX76853.1 hypothetical protein CEUSTIGMA_g4299.t1 [Chlamydomonas eustigma]	diamond	594	72	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
29271943	29271943	PRJNA602115_P_NODE_11569_length_202_cov_0.872340_g11544_i0	PRJNA602115	11569	202	0.87234	1.7621268	Eukaryota	2759	Plants	Plants	44.3	0.00282	NR	PRW34016.1	3076	g11544	i0	79.2	4.26237623762376	24	5	35.6	0	201	130	120	143	PRW34016.1 60S ribosomal L23A [Chlorella sorokiniana]	diamond	861	44.7	0.991051454138702	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
31438694	31438694	PRJNA602115_P_NODE_11316_length_202_cov_0.907801_g11291_i0	PRJNA602115	11316	202	0.907801	1.83375802	Coccomyxa viridis	1274662	Plants	Plants	74.3	1.63e-13	NR	CAK0736545.1	1274662	g11291	i0	54.5	2.94059405940594	66	30	98	0	1	198	572	637	CAK0736545.1 hypothetical protein CVIRNUC_000763 [Coccomyxa viridis]	diamond	594	74.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis

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