metadata: contig_metadata: 5 rows where bioproject = "PRJNA1249042" and tax

5 rows where bioproject = "PRJNA1249042" 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
2905272	2905272	PRJNA1249042_S_NODE_42803_length_220_cov_1.355932_g42589_i0	PRJNA1249042	42803	220	1.355932	2.9830504	root	1	Root_unresolved	Root_unresolved	119	3.15e-32	NR	WIA14882.1	3088	g42589	i0	83.8	63.9545454545455	68	11	92.7	0	215	12	114	181	WIA14882.1 hypothetical protein OEZ85_001599 [Tetradesmus obliquus]	diamond	14070	119	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
18903847	18903847	PRJNA1249042_S_NODE_6875_length_342_cov_3.993311_g6661_i0	PRJNA1249042	6875	342	3.993311	13.65712362	Chlorellaceae	35461	Plants	Plants	529	1.2299999999999994e-145	NTclustered	gi\|254798615\|ref\|NC_012978.1\|	3074	g6661	i0	94.477	89.8011695906433	344	17	100	2	1	342	93339	93682	Parachlorella kessleri chloroplast, complete genome	blastn	30712	531	0.99623352165725	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Parachlorella	Parachlorella kessleri
20178449	20178449	PRJNA1249042_S_NODE_66716_length_191_cov_1.439189_g66502_i0	PRJNA1249042	66716	191	1.439189	2.74885099	Chlorellaceae	35461	Plants	Plants	311	2.45e-80	NTclustered	gi\|1768906865\|gb\|MN128434.1\|	3078	g66502	i0	100	109.795811518325	168	0	88	0	24	191	48463	48630	Auxenochlorella pyrenoidosa isolate FACHB-5 chloroplast, complete genome	blastn	20971	311	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella pyrenoidosa
27989731	27989731	PRJNA1249042_S_NODE_93865_length_166_cov_1.560976_g93651_i0	PRJNA1249042	93865	166	1.560976	2.59122016	Haematococcus lacustris	44745	Plants	Plants	41.6	0.0308	NR	GFH13026.1	44745	g93651	i0	54.5	0.596385542168675	33	11	52.4	1	165	79	161	193	GFH13026.1 hypothetical protein HaLaN_08825 [Haematococcus lacustris]	diamond	99	41.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
30990075	30990075	PRJNA1249042_S_NODE_38014_length_227_cov_2.195652_g37800_i0	PRJNA1249042	38014	227	2.195652	4.98413004	Chlamydomonas reinhardtii	3055	Plants	Plants	42.7	0.0262	NR	XP_001699803.1	3055	g37800	i0	45.5	0.581497797356828	44	22	55.5	1	203	78	81	124	XP_001699803.1 uncharacterized protein CHLRE_02g101700v5 [Chlamydomonas reinhardtii]	diamond	132	42.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii

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