metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA689790" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA689790" 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
668706	668706	PRJNA689790_S_NODE_12841_length_167_cov_2.061538_g12726_i0	PRJNA689790	12841	167	2.061538	3.44276846	Auxenochlorella protothecoides	3075	Plants	Plants	119	1.36e-22	NTclustered	gi\|760446560\|ref\|XM_011402047.1\|	3075	g12726	i0	81.507	2.7185628742515	146	25	87	2	5	149	120	264	Auxenochlorella protothecoides 60S ribosomal protein L3 partial mRNA	blastn	454	119	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
668725	668725	PRJNA689790_S_NODE_16941_length_150_cov_1.035398_g16826_i0	PRJNA689790	16941	150	1.035398	1.553097	Monoraphidium neglectum	145388	Plants	Plants	128	1.97e-25	NTclustered	gi\|926789920\|ref\|XM_014047980.1\|	145388	g16826	i0	82.237	7.586666666666669	152	24	99	1	1	149	286	437	Monoraphidium neglectum peptidyl-prolyl cis-trans isomerase, cyclophilin-type mRNA	blastn	1138	128	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
1944814	1944814	PRJNA689790_S_NODE_8462_length_203_cov_1.957831_g8347_i0	PRJNA689790	8462	203	1.957831	3.97439693	Volvox carteri	3067	Plants	Plants	219	1.6499999999999996e-52	NTclustered	gi\|302833608\|ref\|XM_002948322.1\|	3068	g8347	i0	87.766	92.5960591133005	188	21	92	2	7	192	966	779	Volvox carteri f. nagariensis NADH:ubiquinone oxidoreductase 51 kDa subunit (nuo6), partial mRNA	blastn	18797	219	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
7047295	7047295	PRJNA689790_S_NODE_10386_length_184_cov_1.598639_g10271_i0	PRJNA689790	10386	184	1.598639	2.94149576	Monoraphidium neglectum	145388	Plants	Plants	108	3.3e-19	NTclustered	gi\|926774671\|ref\|XM_014040356.1\|	145388	g10271	i0	90.244	2.7554347826087	82	8	45	0	1	82	60	141	Monoraphidium neglectum molecular chaperone HtpG mRNA	blastn	507	108	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
8831090	8831090	PRJNA689790_S_NODE_3607_length_326_cov_4.702422_g3492_i0	PRJNA689790	3607	326	4.702422	15.32989572	Eukaryota	2759	Plants	Plants	287	7.72e-73	NTclustered	gi\|38195094\|gb\|AF052206.2\|	3055	g3492	i0	82.979	82.739263803681	329	44	99	9	1	323	360	38	Chlamydomonas reinhardtii cyclophilin 1 (cyp1) mRNA, complete cds	blastn	26973	287	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
13422600	13422600	PRJNA689790_S_NODE_12491_length_169_cov_1.977273_g12376_i0	PRJNA689790	12491	169	1.977273	3.34159137	Auxenochlorella protothecoides	3075	Plants	Plants	180	6.2e-41	NTclustered	gi\|760437112\|ref\|XM_011397323.1\|	3075	g12376	i0	85.882	100.934911242604	170	22	100	2	1	169	254	422	Auxenochlorella protothecoides hypothetical protein partial mRNA	blastn	17058	180	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
14697697	14697697	PRJNA689790_S_NODE_6432_length_235_cov_2.954545_g6317_i0	PRJNA689790	6432	235	2.954545	6.94318075	Chlamydomonas reinhardtii	3055	Plants	Plants	167	7.21e-37	NTclustered	gi\|2082260615\|ref\|XM_043068304.1\|	3055	g6317	i0	82.474	27.4553191489362	194	30	82	4	16	207	1648	1839	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g516200v5), mRNA	blastn	6452	167	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
19795629	19795629	PRJNA689790_S_NODE_11876_length_173_cov_1.433824_g11761_i0	PRJNA689790	11876	173	1.433824	2.48051552	Chlamydomonas reinhardtii	3055	Plants	Plants	161	2.31e-35	NTclustered	gi\|2082238343\|ref\|XM_001701633.2\|	3055	g11761	i0	85.621	81.0520231213873	153	22	88	0	8	160	573	725	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g080700v5), mRNA	blastn	14022	161	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
22855483	22855483	PRJNA689790_S_NODE_12978_length_166_cov_2.782946_g12863_i0	PRJNA689790	12978	166	2.782946	4.61969036	root	1	Root_unresolved	Root_unresolved	182	1.7e-41	NTclustered	gi\|1061214241\|gb\|KX530454.1\|	3046	g12863	i0	89.583	78.2409638554217	144	14	86	1	18	160	196016	195873	Dunaliella salina strain SQ chloroplast, complete genome	blastn	12988	183	0.994535519125683	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);;