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

7 rows where analysis = "diamond", bioproject = "PRJNA641991" 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
29670283	29670283	PRJNA641991_S_NODE_4350_length_256_cov_1.410628_g4231_i0	PRJNA641991	4350	256	1.410628	3.61120768	Trebouxia sp. C	2796353	Plants	Plants	149	8e-43	NR	KAL0019246.1	2905654	g4231	i0	83.1	2.91796875	83	14	97.3	0	251	3	1	83	KAL0019246.1 hypothetical protein WJX79_009739 [Trebouxia sp. C0005]	diamond	747	149	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0005
30820301	30820301	PRJNA641991_S_NODE_7894_length_198_cov_1.449664_g7775_i0	PRJNA641991	7894	198	1.449664	2.87033472	Chlorellaceae	35461	Plants	Plants	43.1	0.0152	NR	PRW59214.1	3076	g7775	i0	54.3	6.89393939393939	46	14	68.2	2	24	158	489	528	PRW59214.1 NADH:ubiquinone oxidoreductase 76 kDa subunit [Chlorella sorokiniana]	diamond	1365	43.5	0.990804597701149	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
31294213	31294213	PRJNA641991_P_NODE_1575_length_250_cov_1.014925_g1534_i0	PRJNA641991	1575	250	1.014925	2.5373125	Eukaryota	2759	Plants	Plants	77.4	2.55e-14	NR	PRW45211.1	3076	g1534	i0	47	11.712	83	43	99.6	1	250	2	229	310	PRW45211.1 mitogen-activated kinase 3 [Chlorella sorokiniana]	diamond	2928	77.8	0.994858611825193	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
31452570	31452570	PRJNA641991_S_NODE_6596_length_214_cov_1.436364_g6477_i0	PRJNA641991	6596	214	1.436364	3.07381896	Eukaryota	2759	Plants	Plants	104	1.53e-26	NR	KAK2077587.1	3111	g6477	i0	65.7	42.2102803738318	70	24	98.1	0	213	4	7	76	KAK2077587.1 60S ribosomal protein L21A [Prototheca wickerhamii]	diamond	9033	105	0.990476190476191	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
31547494	31547494	PRJNA641991_P_NODE_3556_length_165_cov_0.879310_g3515_i0	PRJNA641991	3556	165	0.87931	1.4508615	Eukaryota	2759	Plants	Plants	109	4.38e-26	NR	PRW33236.1	3076	g3515	i0	94.4	61.8545454545455	54	3	98.2	0	2	163	193	246	PRW33236.1 nucleolar GTP-binding isoform A [Chlorella sorokiniana]	diamond	10206	110	0.990909090909091	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
31882820	31882820	PRJNA641991_S_NODE_13817_length_163_cov_0.894737_g13698_i0	PRJNA641991	13817	163	0.894737	1.45842131	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	67.8	1.86e-11	NR	XP_005642775.1	574566	g13698	i0	57.4	0.993865030674847	54	22	99.4	1	163	2	217	269	XP_005642775.1 heat shock protein 70E [Coccomyxa subellipsoidea C-169]	diamond	162	67.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
32211736	32211736	PRJNA641991_S_NODE_12798_length_165_cov_1.318966_g12679_i0	PRJNA641991	12798	165	1.318966	2.1762939	Chlorophyta	3041	Plants	Plants	80.9	3.73e-17	NR	CAD7702270.1	121088	g12679	i0	75.5	4.89090909090909	53	13	96.4	0	163	5	29	81	CAD7702270.1 unnamed protein product [Ostreobium quekettii]	diamond	807	80.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii

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