metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB673" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB673" 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
134925	134925	PRJEB673_P_NODE_3841_length_506_cov_2.033970_g3511_i0	PRJEB673	3841	506	2.03397	10.2918882	Monoraphidium neglectum	145388	Plants	Plants	169	4.71e-37	NTclustered	gi\|926787363\|ref\|XM_014046702.1\|	145388	g3511	i0	83.889	4.91106719367589	180	25	35	4	58	235	870	693	Monoraphidium neglectum Calreticulin Flags: Precursor mRNA	blastn	2485	169	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
10338015	10338015	PRJEB673_P_NODE_9769_length_187_cov_3.355263_g9420_i0	PRJEB673	9769	187	3.355263	6.27434181	Chlamydomonas reinhardtii	3055	Plants	Plants	58.4	3.44e-4	NTclustered	gi\|2082237163\|ref\|XM_043058766.1\|	3055	g9420	i0	100	0.561497326203209	31	0	17	0	146	176	198	228	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g039250v5), mRNA	blastn	105	58.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
14163276	14163276	PRJEB673_P_NODE_13052_length_150_cov_1.043478_g12703_i0	PRJEB673	13052	150	1.043478	1.565217	Chlorella variabilis	554065	Plants	Plants	122	9.18e-24	NTclustered	gi\|552813385\|ref\|XM_005843877.1\|	554065	g12703	i0	82.857	2.53333333333333	140	21	93	2	1	140	1233	1369	Chlorella variabilis hypothetical protein (CHLNCDRAFT_59785) mRNA, complete cds	blastn	380	122	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
17573194	17573194	PRJEB673_P_NODE_12314_length_154_cov_2.210084_g11965_i0	PRJEB673	12314	154	2.210084	3.40352936	Eukaryota	2759	Plants	Plants	110	7.39e-20	NTclustered	gi\|760450068\|ref\|XM_011403801.1\|	3075	g11965	i0	90.361	55.5974025974026	83	8	54	0	1	83	322	404	Auxenochlorella protothecoides Peptidyl-prolyl cis-trans isomerase CYP18-4 partial mRNA	blastn	8562	110	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
24360738	24360738	PRJEB673_P_NODE_6120_length_354_cov_1.645768_g5771_i0	PRJEB673	6120	354	1.645768	5.82601872	Monoraphidium neglectum	145388	Plants	Plants	178	5.289999999999999e-40	NTclustered	gi\|926781811\|ref\|XM_014043926.1\|	145388	g5771	i0	89.855	44.0988700564972	138	14	39	0	216	353	225	88	Monoraphidium neglectum peptidyl-prolyl cis-trans isomerase, cyclophilin-type mRNA	blastn	15611	178	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum

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