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

5 rows where analysis = "diamond", bioproject = "PRJNA1249535" 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
28337048	28337048	PRJNA1249535_S_NODE_228066_length_291_cov_4.885321_g224683_i0	PRJNA1249535	228066	291	4.885321	14.21628411	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	48.9	4.33e-4	NR	KAL4519572.1	1650286	g224683	i0	45.2	0.639175257731959	62	33	63.9	1	275	90	225	285	KAL4519572.1 hypothetical protein Ndes2437A_g07762 [Chlorella desiccata (nom. nud.)]	diamond	186	48.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
28512831	28512831	PRJNA1249535_S_NODE_147667_length_337_cov_1.181818_g144284_i0	PRJNA1249535	147667	337	1.181818	3.98272666	root	1	Root_unresolved	Root_unresolved	45.8	0.00917	NR	KAK9815815.1	41462	g144284	i0	56	1.68249258160237	25	11	22.3	0	126	200	1074	1098	KAK9815815.1 hypothetical protein WJX72_010117 [[Myrmecia] bisecta]	diamond	567	46.2	0.991341991341991	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
28778902	28778902	PRJNA1249535_S_NODE_188007_length_313_cov_1.812500_g184624_i0	PRJNA1249535	188007	313	1.8125	5.673125	Pleodorina starrii	330485	Plants	Plants	47.8	0.00155	NR	GLC76333.1	330485	g184624	i0	50	1.35143769968051	48	23	45	1	198	58	590	637	GLC76333.1 hypothetical protein PLESTF_001768400 [Pleodorina starrii]	diamond	423	47.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Pleodorina	Pleodorina starrii
30895341	30895341	PRJNA1249535_S_NODE_129794_length_349_cov_2.514493_g126411_i0	PRJNA1249535	129794	349	2.514493	8.77558057	Scenedesmus sp. PABB	2909984	Plants	Plants	44.7	0.0275	NR	KAF8072686.1	2742167	g126411	i0	44.4	0.541547277936963	63	31	51.6	3	180	1	1008	1069	KAF8072686.1 DEGP8 [Scenedesmus sp. PABB004]	diamond	189	44.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
32508472	32508472	PRJNA1249535_S_NODE_280519_length_263_cov_4.026316_g277136_i0	PRJNA1249535	280519	263	4.026316	10.58921108	Coccomyxa sp. Obi	2315456	Plants	Plants	45.4	0.00534	NR	BDA44396.1	2315456	g277136	i0	61.3	2.79467680608365	31	12	35.4	0	93	1	138	168	BDA44396.1 probable LINE-1 retrotransposable element ORF2 protein at N-terminal half [Coccomyxa sp. Obi]	diamond	735	45.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa sp. Obi

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