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

7 rows where analysis = "diamond", bioproject = "PRJEB73599" 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
9062431	9062431	PRJEB73599_P_NODE_2428_length_473_cov_2.157658_g2161_i0	PRJEB73599	2428	473	2.157658	10.20572234	Symbiochloris irregularis	706552	Plants	Plants	188	4.82e-52	NR	KAK9789544.1	706552	g2161	i0	69.9	0.780126849894292	123	37	78	0	2	370	932	1054	KAK9789544.1 hypothetical protein WJX73_004313 [Symbiochloris irregularis]	diamond	369	188	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
27627367	27627367	PRJEB73599_P_NODE_7224_length_212_cov_2.398907_g6937_i0	PRJEB73599	7224	212	2.398907	5.08568284	root	1	Root_unresolved	Root_unresolved	76.3	3.83e-14	NR	XP_002954858.1	3068	g6937	i0	65.4	50.1367924528302	52	18	73.6	0	212	57	702	753	XP_002954858.1 uncharacterized protein VOLCADRAFT_76494 [Volvox carteri f. nagariensis]	diamond	10629	76.6	0.996083550913838	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
27816861	27816861	PRJEB73599_P_NODE_5184_length_284_cov_1.898039_g4897_i0	PRJEB73599	5184	284	1.898039	5.39043076	Eukaryota	2759	Plants	Plants	96.3	9.53e-21	NR	PRW20411.1	3076	g4897	i0	70.7	11.0492957746479	58	17	61.3	0	176	3	648	705	PRW20411.1 elongation factor EF-3 isoform B [Chlorella sorokiniana]	diamond	3138	97.1	0.991761071060762	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
28581781	28581781	PRJEB73599_P_NODE_7067_length_217_cov_1.936170_g6780_i0	PRJEB73599	7067	217	1.93617	4.2014889	Cymbomonas tetramitiformis	36881	Plants	Plants	69.3	2.8e-12	NR	KAK3256391.1	36881	g6780	i0	57.4	0.746543778801843	54	22	74.7	1	1	162	54	106	KAK3256391.1 hypothetical protein CYMTET_34473 [Cymbomonas tetramitiformis]	diamond	162	69.3	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
29869005	29869005	PRJEB73599_P_NODE_2851_length_431_cov_2.223881_g2572_i0	PRJEB73599	2851	431	2.223881	9.58492711	Eukaryota	2759	Plants	Plants	114	2.82e-26	NR	KAI3438154.1	3077	g2572	i0	52.3	2.26914153132251	109	51	75.2	1	326	3	313	421	KAI3438154.1 hypothetical protein D9Q98_000592 [Chlorella vulgaris]	diamond	978	114	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
30350615	30350615	PRJEB73599_P_NODE_7372_length_207_cov_2.882022_g7085_i0	PRJEB73599	7372	207	2.882022	5.96578554	Cymbomonas tetramitiformis	36881	Plants	Plants	62	3.5e-10	NR	KAK3254765.1	36881	g7085	i0	58.1	0.898550724637681	62	25	88.4	1	185	3	7	68	KAK3254765.1 hypothetical protein CYMTET_36031 [Cymbomonas tetramitiformis]	diamond	186	62	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
31297989	31297989	PRJEB73599_P_NODE_7395_length_207_cov_1.325843_g7108_i0	PRJEB73599	7395	207	1.325843	2.74449501	Trebouxia sp. C	2796353	Plants	Plants	99.8	5.68e-23	NR	KAL0049813.1	2905655	g7108	i0	62.7	1.94202898550725	67	25	97.1	0	203	3	207	273	KAL0049813.1 hypothetical protein WJX82_010375 [Trebouxia sp. C0006]	diamond	402	99.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0006

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