metadata: contig_metadata: 5 rows where bioproject = "PRJEB55250", tax_clade = "core chlorophytes" and tax

5 rows where bioproject = "PRJEB55250", tax_clade = "core chlorophytes" 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
7774057	7774057	PRJEB55250_P_NODE_10347_length_258_cov_4.994595_g10223_i0	PRJEB55250	10347	258	4.994595	12.8860551	Desmochloris halophila	138176	Plants	Plants	422	1.55e-113	NTclustered	gi\|371782086\|emb\|HE610118.1\|	138176	g10223	i0	96.139	67.4496124031008	259	9	100	1	1	258	3715	3973	Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073	blastn	17402	422	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Chlorocystidales	Chlorocystidaceae	Desmochloris	Desmochloris halophila
10324654	10324654	PRJEB55250_P_NODE_10849_length_255_cov_1.659341_g10725_i0	PRJEB55250	10849	255	1.659341	4.23131955	Chlamydomonas reinhardtii	3055	Plants	Plants	54.7	0.006	NTclustered	gi\|2082239373\|ref\|XM_001699987.2\|	3055	g10725	i0	96.97	0.129411764705882	33	0	13	1	57	89	138	107	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g097900v5), mRNA	blastn	33	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
29023475	29023475	PRJEB55250_P_NODE_11768_length_251_cov_0.865169_g11644_i0	PRJEB55250	11768	251	0.865169	2.17157419	Scenedesmus sp. PABB	2909984	Plants	Plants	62.4	4.91e-9	NR	KAF8058474.1	2742167	g11644	i0	46.5	0.848605577689243	71	34	82.5	2	247	41	116	184	KAF8058474.1 hypothetical protein HT031_005598 [Scenedesmus sp. PABB004]	diamond	213	62.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
31448962	31448962	PRJEB55250_P_NODE_6136_length_291_cov_2.128440_g6012_i0	PRJEB55250	6136	291	2.12844	6.1937604	Chlorellales	35460	Plants	Plants	135	9.19e-39	NR	KAI3426859.1	3077	g6012	i0	78.4	7.21649484536082	88	16	89.7	2	290	30	38	123	KAI3426859.1 hypothetical protein D9Q98_006805 [Chlorella vulgaris]	diamond	2100	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
32681894	32681894	PRJEB55250_P_NODE_16380_length_241_cov_1.375000_g16256_i0	PRJEB55250	16380	241	1.375	3.31375	Viridiplantae	33090	Plants	Plants	91.7	1.59e-19	NR	CAK0785623.1	1274662	g16256	i0	63.5	8.39004149377593	74	25	92.1	2	223	2	4	75	CAK0785623.1 hypothetical protein CVIRNUC_008834 [Coccomyxa viridis]	diamond	2022	91.7	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);;