metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA473641" 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
9372641	9372641	PRJNA473641_P_NODE_15328_length_265_cov_1.192708_g15245_i0	PRJNA473641	15328	265	1.192708	3.1606762	Scenedesmaceae	3086	Plants	Plants	144	7.2699999999999995e-38	NR	WIA32599.1	3088	g15245	i0	86.4	12.9283018867925	88	12	99.6	0	2	265	550	637	WIA32599.1 hypothetical protein OEZ86_003402 [Tetradesmus obliquus]	diamond	3426	144	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
19570709	19570709	PRJNA473641_P_NODE_19236_length_249_cov_0.875000_g19153_i0	PRJNA473641	19236	249	0.875	2.17875	Eukaryota	2759	Plants	Plants	98.6	1.0699999999999997e-23	NR	KXZ44232.1	33097	g19153	i0	60	14.7590361445783	80	32	96.4	0	245	6	87	166	KXZ44232.1 hypothetical protein GPECTOR_70g462 [Gonium pectorale]	diamond	3675	98.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
27092358	27092358	PRJNA473641_P_NODE_21162_length_246_cov_1.618497_g21079_i0	PRJNA473641	21162	246	1.618497	3.98150262	Chlorophyta	3041	Plants	Plants	87.4	2.78e-20	NR	KAK9820180.1	41462	g21079	i0	56.6	2.02439024390244	83	34	98.8	1	3	245	5	87	KAK9820180.1 hypothetical protein WJX72_007173 [[Myrmecia] bisecta]	diamond	498	87.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
27534749	27534749	PRJNA473641_P_NODE_9483_length_322_cov_1.112450_g9400_i0	PRJNA473641	9483	322	1.11245	3.582089	Chlorophyta	3041	Plants	Plants	109	2.01e-25	NR	GBF93667.1	307507	g9400	i0	53.8	6.68944099378882	106	49	98.8	0	2	319	358	463	GBF93667.1 histidine decarboxylase [Raphidocelis subcapitata]	diamond	2154	110	0.990909090909091	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Raphidocelis	Raphidocelis subcapitata
28260743	28260743	PRJNA473641_P_NODE_7566_length_348_cov_1.640000_g7483_i0	PRJNA473641	7566	348	1.64	5.7072	Eukaryota	2759	Plants	Plants	54.7	1.34e-6	NR	KAI3436566.1	3077	g7483	i0	33.7	3.71551724137931	101	54	80.2	5	67	345	7	102	KAI3436566.1 hypothetical protein D9Q98_005982 [Chlorella vulgaris]	diamond	1293	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
29728466	29728466	PRJNA473641_P_NODE_10050_length_315_cov_1.272727_g9967_i0	PRJNA473641	10050	315	1.272727	4.00909005	Edaphochlamys debaryana	47281	Plants	Plants	96.3	1.38e-20	NR	KAG2487020.1	47281	g9967	i0	48	0.933333333333333	98	48	93.3	1	296	3	350	444	KAG2487020.1 hypothetical protein HYH03_014390 [Edaphochlamys debaryana]	diamond	294	96.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana
32099289	32099289	PRJNA473641_P_NODE_20238_length_248_cov_0.874286_g20155_i0	PRJNA473641	20238	248	0.874286	2.16822928	Chlamydomonas sp. UWO 241	1653778	Plants	Plants	66.6	4.74e-11	NR	KAG1657223.1	1653778	g20155	i0	43.2	3.93145161290323	81	45	98	1	246	4	137	216	KAG1657223.1 hypothetical protein FOA52_011511 [Chlamydomonas sp. UWO 241]	diamond	975	66.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. UWO 241

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