metadata: contig_metadata: 6 rows where bioproject = "PRJNA596870" and tax

6 rows where bioproject = "PRJNA596870" 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
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
22245561	22245561	PRJNA596870_P_NODE_28938_length_251_cov_1.297753_g28805_i0	PRJNA596870	28938	251	1.297753	3.25736003	Volvox carteri	3067	Plants	Plants	54.7	0.006	NTclustered	gi\|302854816\|ref\|XM_002958867.1\|	3068	g28805	i0	92.308	0.155378486055777	39	2	15	1	21	58	3166	3128	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_100238), partial mRNA	blastn	39	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
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
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

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