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

7 rows where analysis = "diamond", bioproject = "PRJNA1057075" and tax_clade = "Sar"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26908772	26908772	PRJNA1057075_S_NODE_1562_length_308_cov_1.779923_g1463_i0	PRJNA1057075	1562	308	1.779923	5.48216284	Symbiodinium microadriaticum	2951	SAR_Eukaryotes	SAR_Eukaryotes	108	3.59e-27	NR	CAE7473169.1	2951	g1463	i0	78.5	0.633116883116883	65	14	63.3	0	307	113	140	204	CAE7473169.1 RPS8 [Symbiodinium microadriaticum]	diamond	195	108	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
27288155	27288155	PRJNA1057075_S_NODE_4023_length_223_cov_1.965517_g3924_i0	PRJNA1057075	4023	223	1.965517	4.38310291	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	81.6	3.37e-18	NR	KAJ1419208.1	483371	g3924	i0	72.9	1.30493273542601	48	13	64.6	0	212	69	48	95	KAJ1419208.1 ribosomal protein L31e-domain-containing protein [Ochromonadaceae sp. CCMP2298]	diamond	291	81.6	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
28646091	28646091	PRJNA1057075_S_NODE_8407_length_167_cov_2.864407_g8308_i0	PRJNA1057075	8407	167	2.864407	4.78355969	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00204	NR	KAJ1421113.1	483371	g8308	i0	70	0.538922155688623	30	9	53.9	0	167	78	576	605	KAJ1421113.1 hypothetical protein B484DRAFT_433346 [Ochromonadaceae sp. CCMP2298]	diamond	90	45.1	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
30912043	30912043	PRJNA1057075_S_NODE_6754_length_180_cov_1.763359_g6655_i0	PRJNA1057075	6754	180	1.763359	3.1740462	root	1	Root_unresolved	Root_unresolved	58.2	8.72e-9	NR	KAJ1411071.1	483371	g6655	i0	80	1.23333333333333	35	7	58.3	0	180	76	96	130	KAJ1411071.1 50S ribosomal protein L30e-like protein [Ochromonadaceae sp. CCMP2298]	diamond	222	58.2	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
31140766	31140766	PRJNA1057075_S_NODE_9295_length_162_cov_1.380531_g9196_i0	PRJNA1057075	9295	162	1.380531	2.23646022	Tribonema minus	303371	SAR_Eukaryotes	SAR_Eukaryotes	72.4	3.94e-13	NR	KAG5177030.1	303371	g9196	i0	73	0.685185185185185	37	10	68.5	0	3	113	380	416	KAG5177030.1 putative cysteine protease family C01A [Tribonema minus]	diamond	111	72.4	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema minus
32026840	32026840	PRJNA1057075_S_NODE_3738_length_230_cov_3.994475_g3639_i0	PRJNA1057075	3738	230	3.994475	9.1872925	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	60.8	8.45e-10	NR	KAJ1414916.1	483371	g3639	i0	46.7	0.978260869565217	75	25	78.3	1	4	183	37	111	KAJ1414916.1 ribosomal protein L6, partial [Ochromonadaceae sp. CCMP2298]	diamond	225	60.8	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
32271936	32271936	PRJNA1057075_S_NODE_458_length_438_cov_249.344473_g370_i0	PRJNA1057075	458	438	249.344473	1092.12879174	root	1	Root_unresolved	Root_unresolved	46.6	0.0126	NR	XP_013349759.1	44415	g370	i0	87	0.349315068493151	23	3	15.8	0	419	351	116	138	XP_013349759.1 uncharacterized protein EMH_0029470 [Eimeria mitis]	diamond	153	46.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis

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