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

7 rows where analysis = "diamond", bioproject = "PRJNA596870" 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
1843975	1843975	PRJNA596870_P_NODE_2562_length_725_cov_2.449387_g2439_i0	PRJNA596870	2562	725	2.449387	17.75805575	Sanguina aurantia	2578422	Plants	Plants	324	1.0100000000000001e-109	NR	MEW5302408.1	2578422	g2439	i0	77.9	5.07310344827586	204	45	84.4	0	710	99	1	204	MEW5302408.1 hypothetical protein [Sanguina aurantia]	diamond	3678	324	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Sanguina	Sanguina aurantia
6946952	6946952	PRJNA596870_P_NODE_6206_length_490_cov_2.640288_g6073_i0	PRJNA596870	6206	490	2.640288	12.9374112	Eukaryota	2759	Plants	Plants	171	3.7e-46	NR	KAL4853107.1	3077	g6073	i0	76.7	15.1163265306122	103	24	63.1	0	489	181	39	141	KAL4853107.1 40S ribosomal protein S16 [Chlorella vulgaris]	diamond	7407	171	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
15871043	15871043	PRJNA596870_P_NODE_23753_length_278_cov_1.126829_g23620_i0	PRJNA596870	23753	278	1.126829	3.13258462	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	83.6	2.06e-16	NR	XP_005646109.1	574566	g23620	i0	70.7	0.992805755395683	92	27	99.3	0	278	3	285	376	XP_005646109.1 Calreticulin/calnexin [Coccomyxa subellipsoidea C-169]	diamond	276	83.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
24092507	24092507	PRJNA596870_P_NODE_32319_length_248_cov_1.251429_g32186_i0	PRJNA596870	32319	248	1.251429	3.10354392	Haematococcus lacustris	44745	Plants	Plants	63.9	1.35e-9	NR	KAJ9519340.1	44745	g32186	i0	50.8	0.737903225806452	61	29	72.6	1	246	67	228	288	KAJ9519340.1 hypothetical protein QJQ45_023143, partial [Haematococcus lacustris]	diamond	183	63.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
27617018	27617018	PRJNA596870_P_NODE_11204_length_380_cov_1.504886_g11071_i0	PRJNA596870	11204	380	1.504886	5.7185668	Cymbomonas tetramitiformis	36881	Plants	Plants	128	1.29e-32	NR	KAK3279201.1	36881	g11071	i0	50.8	1.94210526315789	126	55	94.7	4	19	378	44	168	KAK3279201.1 hypothetical protein CYMTET_12903 [Cymbomonas tetramitiformis]	diamond	738	128	1	Eukaryota		Viridiplantae	Chlorophyta	Pyramimonadophyceae	Pyramimonadales	Pyramimonadaceae	Cymbomonas	Cymbomonas tetramitiformis
28058882	28058882	PRJNA596870_P_NODE_15345_length_334_cov_2.160920_g15212_i0	PRJNA596870	15345	334	2.16092	7.2174728	Chlamydomonas sp. UWO 241	1653778	Plants	Plants	64.3	2.85e-9	NR	KAG1679620.1	1653778	g15212	i0	41.2	0.916167664670659	102	53	87.1	3	302	12	752	851	KAG1679620.1 hypothetical protein FOA52_006137 [Chlamydomonas sp. UWO 241]	diamond	306	64.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. UWO 241
30743327	30743327	PRJNA596870_P_NODE_27714_length_257_cov_1.413043_g27581_i0	PRJNA596870	27714	257	1.413043	3.63152051	Micromonas pusilla CCMP1545	564608	Plants	Plants	54.3	1.57e-6	NR	XP_003061906.1	564608	g27581	i0	51.2	0.501945525291829	43	21	50.2	0	1	129	130	172	XP_003061906.1 uncharacterized protein MICPUCDRAFT_21075 [Micromonas pusilla CCMP1545]	diamond	129	54.3	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla

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