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

7 rows where analysis = "diamond", bioproject = "PRJNA1004255" and tax_phylum = "Chlorophyta"

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
3979677	3979677	PRJNA1004255_S_NODE_5884_length_248_cov_4.585366_g5676_i0	PRJNA1004255	5884	248	4.585366	11.37170768	[Myrmecia] bisecta	41462	Plants	Plants	61.6	8.68e-9	NR	KAK9814170.1	41462	g5676	i0	72.9	0.580645161290323	48	12	58.1	1	1	144	162	208	KAK9814170.1 hypothetical protein WJX72_001591 [[Myrmecia] bisecta]	diamond	144	61.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
28037853	28037853	PRJNA1004255_S_NODE_14245_length_172_cov_1.821705_g14037_i0	PRJNA1004255	14245	172	1.821705	3.1333326	Trebouxia	13786	Plants	Plants	80.5	1e-17	NR	KAA6418825.1	2608996	g14037	i0	88	1.74418604651163	50	6	87.2	0	3	152	35	84	KAA6418825.1 MAG: hypothetical protein FRX49_11182 [Trebouxia sp. A1-2]	diamond	300	80.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
30508420	30508420	PRJNA1004255_S_NODE_3733_length_290_cov_5.242915_g3525_i0	PRJNA1004255	3733	290	5.242915	15.2044535	Coccomyxa viridis	1274662	Plants	Plants	47.8	0.00111	NR	CAL5221193.1	1274662	g3525	i0	46.5	1.31379310344828	43	23	44.5	0	12	140	552	594	CAL5221193.1 g3341 [Coccomyxa viridis]	diamond	381	47.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
31677841	31677841	PRJNA1004255_S_NODE_1037_length_444_cov_7.835411_g829_i0	PRJNA1004255	1037	444	7.835411	34.78922484	Trebouxia sp. A1-2	2608996	Plants	Plants	94.7	1.64e-20	NR	KAA6427519.1	2608996	g829	i0	100	0.304054054054054	45	0	30.4	0	443	309	211	255	KAA6427519.1 MAG: peptidyl-prolyl cis-trans isomerase chloroplastic-like [Trebouxia sp. A1-2]	diamond	135	94.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
32120992	32120992	PRJNA1004255_S_NODE_1798_length_370_cov_3.498471_g1590_i0	PRJNA1004255	1798	370	3.498471	12.9443427	Micractinium sp. CCAP 211/92	554058	Plants	Plants	90.5	2.15e-18	NR	KAL4444897.1	554058	g1590	i0	69.7	0.721621621621622	89	26	71.4	1	368	105	361	449	KAL4444897.1 hypothetical protein ABPG77_003947 [Micractinium sp. CCAP 211/92]	diamond	267	90.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium sp. CCAP 211/92
32405707	32405707	PRJNA1004255_S_NODE_13999_length_173_cov_3.976923_g13791_i0	PRJNA1004255	13999	173	3.976923	6.88007679	Trebouxia sp. C	2796353	Plants	Plants	43.9	0.00573	NR	KAL0043463.1	2905654	g13791	i0	48.6	1.26589595375723	37	19	64.2	0	61	171	1	37	KAL0043463.1 hypothetical protein WJX79_005318 [Trebouxia sp. C0005]	diamond	219	43.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0005
32902624	32902624	PRJNA1004255_S_NODE_2140_length_348_cov_3.236066_g1932_i0	PRJNA1004255	2140	348	3.236066	11.26150968	Trebouxia	13786	Plants	Plants	60.1	9.93e-8	NR	KAA6420460.1	2608996	g1932	i0	44.8	1	58	32	50	0	2	175	499	556	KAA6420460.1 MAG: hypothetical protein FRX49_09621, partial [Trebouxia sp. A1-2]	diamond	348	60.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2

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