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

5 rows where bioproject = "PRJNA339266" 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
391464	391464	PRJNA339266_S_NODE_14121_length_164_cov_2.661417_g14110_i0	PRJNA339266	14121	164	2.661417	4.36472388	Myrmecia israelensis	3171	Plants	Plants	292	7.41e-75	NTclustered	gi\|723456786\|ref\|NC_025525.1\|	3171	g14110	i0	98.78	1	164	2	100	0	1	164	66562	66725	Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome	blastn	164	292	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	Myrmecia israelensis
17647453	17647453	PRJNA339266_P_NODE_1034_length_272_cov_2.161702_g1004_i0	PRJNA339266	1034	272	2.161702	5.87982944	Chlorophyta	3041	Plants	Plants	281	2.92e-71	NTclustered	gi\|746948124\|ref\|NC_025531.1\|	33092	g1004	i0	94.054	66.6470588235294	185	11	68	0	2	186	5127	4943	Koliella longiseta culture-collection UTEX:339 chloroplast, complete genome	blastn	18128	281	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Koliellaceae	Koliella	Koliella longiseta
20792704	20792704	PRJNA339266_P_NODE_3797_length_195_cov_3.734177_g3767_i0	PRJNA339266	3797	195	3.734177	7.28164515	Diplosphaera sundellii	3135960	Plants	Plants	217	5.649999999999999e-52	NTclustered	gi\|2878821371\|gb\|PQ563290.1\|	3135960	g3767	i0	85.859	7.91794871794872	198	14	94	2	1	184	57632	57435	Diplosphaera sundellii mitochondrion, complete genome	blastn	1544	217	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Stichococcaceae	Diplosphaera	Diplosphaera sundellii
21471562	21471562	PRJNA339266_P_NODE_3677_length_197_cov_2.287500_g3647_i0	PRJNA339266	3677	197	2.2875	4.506375	Chlorophyta	3041	Plants	Plants	78.7	2.81e-10	NTclustered	gi\|2064311657\|gb\|MZ158703.1\|	3116	g3647	i0	94.118	11.7969543147208	51	3	26	0	124	174	54350	54400	Ulva intestinalis isolate CNS00531 chloroplast, complete genome	blastn	2324	78.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Ulvaceae	Ulva	Ulva intestinalis
29316747	29316747	PRJNA339266_P_NODE_7109_length_164_cov_5.125984_g7079_i0	PRJNA339266	7109	164	5.125984	8.40661376	Neocystis brevis	1065496	Plants	Plants	47	2.51e-4	NR	YP_009105684.1	1065496	g7079	i0	81.5	1.92073170731707	27	5	49.4	0	163	83	36	62	YP_009105684.1 CF0 subunit I of ATP synthase [Neocystis brevis]	diamond	315	47	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Radiococcaceae	Neocystis	Neocystis brevis

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