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

7 rows where analysis = "diamond", bioproject = "PRJNA793147" 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
26958649	26958649	PRJNA793147_P_NODE_15662_length_428_cov_1.782730_g15396_i0	PRJNA793147	15662	428	1.78273	7.6300844	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	84.7	4.61e-16	NR	XP_005651189.1	574566	g15396	i0	44.1	4.51401869158879	102	47	64.5	3	148	423	59	160	XP_005651189.1 cell division cycle 20 [Coccomyxa subellipsoidea C-169]	diamond	1932	84.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
27179958	27179958	PRJNA793147_P_NODE_31922_length_296_cov_1.872247_g31656_i0	PRJNA793147	31922	296	1.872247	5.54185112	Bryopsis sp. KO-2	3115439	Plants	Plants	48.9	3.74e-4	NR	GMH34431.1	3041901	g31656	i0	32.8	0.587837837837838	58	39	58.8	0	8	181	182	239	GMH34431.1 hypothetical protein BSKO_02265 [Bryopsis sp. KO-2023]	diamond	174	48.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
29936674	29936674	PRJNA793147_P_NODE_60171_length_227_cov_1.822785_g59905_i0	PRJNA793147	60171	227	1.822785	4.13772195	Eukaryota	2759	Plants	Plants	78.6	2.9e-16	NR	KAI8475133.1	39955	g59905	i0	52	241.876651982379	75	36	99.1	0	227	3	5	79	KAI8475133.1 MAG: vacuolar type H+-ATPase proteolipid subunit [Monoraphidium minutum]	diamond	54906	78.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium minutum
31001745	31001745	PRJNA793147_P_NODE_54674_length_232_cov_0.883436_g54408_i0	PRJNA793147	54674	232	0.883436	2.04957152	Ostreobium quekettii	121088	Plants	Plants	60.1	2.41e-8	NR	CAD7700239.1	121088	g54408	i0	38.2	2.08189655172414	76	41	93.1	2	9	224	148	221	CAD7700239.1 unnamed protein product [Ostreobium quekettii]	diamond	483	60.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Ostreobiaceae	Ostreobium	Ostreobium quekettii
31222629	31222629	PRJNA793147_P_NODE_41775_length_261_cov_1.255208_g41509_i0	PRJNA793147	41775	261	1.255208	3.27609288	Micractinium tetrahymenae	2728915	Plants	Plants	46.2	0.00263	NR	KAL4459056.1	2728915	g41509	i0	56.1	2.32183908045977	41	18	47.1	0	124	2	138	178	KAL4459056.1 hypothetical protein ABPG75_013921 [Micractinium tetrahymenae]	diamond	606	46.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium tetrahymenae
31823675	31823675	PRJNA793147_P_NODE_44817_length_252_cov_1.092896_g44551_i0	PRJNA793147	44817	252	1.092896	2.75409792	Symbiochloris irregularis	706552	Plants	Plants	64.3	5.12e-11	NR	KAK9785519.1	706552	g44551	i0	66.7	1.04761904761905	42	14	50	0	1	126	23	64	KAK9785519.1 hypothetical protein WJX73_001099 [Symbiochloris irregularis]	diamond	264	64.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
32181161	32181161	PRJNA793147_P_NODE_15598_length_429_cov_1.988889_g15332_i0	PRJNA793147	15598	429	1.988889	8.53233381	Scenedesmaceae	3086	Plants	Plants	79.3	1.2e-14	NR	WIA14208.1	3088	g15332	i0	40.2	1.3006993006993	92	55	64.3	0	423	148	131	222	WIA14208.1 hypothetical protein OEZ85_002747 [Tetradesmus obliquus]	diamond	558	79.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus

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