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

7 rows where analysis = "diamond", bioproject = "PRJNA600413" 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
3126115	3126115	PRJNA600413_P_NODE_82103_length_178_cov_2.093023_g81402_i0	PRJNA600413	82103	178	2.093023	3.72558094	Prototheca wickerhamii	3111	Plants	Plants	107	2.6600000000000003e-27	NR	KAK2077382.1	3111	g81402	i0	100	0.960674157303371	57	0	96.1	0	2	172	169	225	KAK2077382.1 hypothetical protein QBZ16_004227 [Prototheca wickerhamii]	diamond	171	107	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
28577534	28577534	PRJNA600413_P_NODE_117707_length_165_cov_0.879310_g117006_i0	PRJNA600413	117707	165	0.87931	1.4508615	Ostreococcus	70447	Plants	Plants	74.7	5.78e-14	NR	XP_022841041.1	70448	g117006	i0	70.4	1.96363636363636	54	16	98.2	0	2	163	156	209	XP_022841041.1 Ribonuclease H1, N-terminal [Ostreococcus tauri]	diamond	324	75.1	0.994673768308922	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus tauri
28722189	28722189	PRJNA600413_P_NODE_14247_length_386_cov_1.824926_g13547_i0	PRJNA600413	14247	386	1.824926	7.04421436	Cymbomonas tetramitiformis	36881	Plants	Plants	48.9	0.00116	NR	KAK3262376.1	36881	g13547	i0	29.9	0.83160621761658	107	65	78.5	5	368	66	214	316	KAK3262376.1 hypothetical protein CYMTET_28764 [Cymbomonas tetramitiformis]	diamond	321	48.9	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
29479562	29479562	PRJNA600413_P_NODE_66430_length_189_cov_1.092857_g65729_i0	PRJNA600413	66430	189	1.092857	2.06549973	Chlamydomonas eustigma	1157962	Plants	Plants	49.3	8.99e-5	NR	GAX78925.1	1157962	g65729	i0	42.3	0.825396825396825	52	24	73	2	138	1	396	447	GAX78925.1 hypothetical protein CEUSTIGMA_g6364.t1 [Chlamydomonas eustigma]	diamond	156	49.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
30743413	30743413	PRJNA600413_P_NODE_126554_length_164_cov_0.886957_g125853_i0	PRJNA600413	126554	164	0.886957	1.45460948	Coccomyxa elongata	1965095	Plants	Plants	50.1	3.3e-5	NR	CAL8465704.1	1965095	g125853	i0	78.6	0.51219512195122	28	6	51.2	0	2	85	440	467	CAL8465704.1 g5240 [Coccomyxa elongata]	diamond	84	50.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa elongata
31280565	31280565	PRJNA600413_P_NODE_148515_length_161_cov_0.910714_g147814_i0	PRJNA600413	148515	161	0.910714	1.46624954	Cymbomonas tetramitiformis	36881	Plants	Plants	41.2	0.0438	NR	KAK3251935.1	36881	g147814	i0	45.2	0.782608695652174	42	21	74.5	1	147	28	1085	1126	KAK3251935.1 hypothetical protein CYMTET_38748 [Cymbomonas tetramitiformis]	diamond	126	41.2	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
32261600	32261600	PRJNA600413_P_NODE_73758_length_184_cov_1.133333_g73057_i0	PRJNA600413	73758	184	1.133333	2.08533272	Cymbomonas tetramitiformis	36881	Plants	Plants	60.1	1.24e-8	NR	KAK3258945.1	36881	g73057	i0	56.9	1.66304347826087	51	13	76.6	2	179	39	252	297	KAK3258945.1 hypothetical protein CYMTET_32034 [Cymbomonas tetramitiformis]	diamond	306	60.1	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis

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