metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA986547" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA986547" 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
9902413	9902413	PRJNA986547_P_NODE_6448_length_265_cov_5.348958_g6366_i0	PRJNA986547	6448	265	5.348958	14.1747387	Prototheca wickerhamii	3111	Plants	Plants	67.4	1e-10	NR	KAK2080072.1	3111	g6366	i0	66	3.10188679245283	53	18	60	0	1	159	397	449	KAK2080072.1 hypothetical protein QBZ16_002468 [Prototheca wickerhamii]	diamond	822	67.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
27601293	27601293	PRJNA986547_P_NODE_15664_length_212_cov_5.532374_g15582_i0	PRJNA986547	15664	212	5.532374	11.72863288	Micractinium	126838	Plants	Plants	47.4	5.89e-4	NR	KAL4444560.1	554058	g15582	i0	67.6	0.962264150943396	34	11	48.1	0	2	103	1116	1149	KAL4444560.1 hypothetical protein ABPG77_002377 [Micractinium sp. CCAP 211/92]	diamond	204	47.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium sp. CCAP 211/92
28542597	28542597	PRJNA986547_P_NODE_2907_length_310_cov_3.493671_g2825_i0	PRJNA986547	2907	310	3.493671	10.8303801	Edaphochlamys debaryana	47281	Plants	Plants	89.4	2.94e-18	NR	KAG2496141.1	47281	g2825	i0	47.6	0.996774193548387	103	49	99.7	2	310	2	175	272	KAG2496141.1 hypothetical protein HYH03_005743 [Edaphochlamys debaryana]	diamond	309	89.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales		Edaphochlamys	Edaphochlamys debaryana
30317234	30317234	PRJNA986547_P_NODE_16512_length_204_cov_6.641221_g16430_i0	PRJNA986547	16512	204	6.641221	13.54809084	Eukaryota	2759	Plants	Plants	104	2.49e-25	NR	KAK9809117.1	41462	g16430	i0	77.9	43	68	15	100	0	1	204	160	227	KAK9809117.1 hypothetical protein WJX72_009563 [[Myrmecia] bisecta]	diamond	8772	105	0.990476190476191	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
32813584	32813584	PRJNA986547_P_NODE_16880_length_201_cov_6.140625_g16798_i0	PRJNA986547	16880	201	6.140625	12.34265625	Eukaryota	2759	Plants	Plants	65.9	1.49e-10	NR	CAD7695962.1	121088	g16798	i0	51.5	22.6567164179104	68	28	95.5	2	200	9	731	797	CAD7695962.1 unnamed protein product [Ostreobium quekettii]	diamond	4554	65.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);;