metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA664479" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA664479" 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
4457077	4457077	PRJNA664479_S_NODE_17444_length_163_cov_0.894737_g17368_i0	PRJNA664479	17444	163	0.894737	1.45842131	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	58.4	2.92e-4	NTclustered	gi\|916502996\|ref\|XM_013496795.1\|	44415	g17368	i0	97.059	1.13496932515337	34	1	21	0	1	34	1798	1831	Eimeria mitis phosphoserine phosphatase, putative (EMH_0004480), partial mRNA	blastn	185	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
10833276	10833276	PRJNA664479_S_NODE_16229_length_164_cov_1.773913_g16153_i0	PRJNA664479	16229	164	1.773913	2.90921732	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	104	3.73e-18	NTclustered	gi\|829196136\|ref\|XM_001025866.3\|	312017	g16153	i0	91.892	0.451219512195122	74	6	45	0	91	164	510	437	Tetrahymena thermophila SB210 translationally-controlled tumor-like protein partial mRNA	blastn	74	104	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
12108493	12108493	PRJNA664479_S_NODE_7970_length_202_cov_1.235294_g7894_i0	PRJNA664479	7970	202	1.235294	2.49529388	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	248	2.09e-61	NTclustered	gi\|829194717\|ref\|XM_001025217.3\|	312017	g7894	i0	88.78	1.01485148514851	205	20	100	1	1	202	349	553	Tetrahymena thermophila SB210 ubiquitin-40S ribosomal protein S27a partial mRNA	blastn	205	248	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
12641471	12641471	PRJNA664479_S_NODE_15050_length_166_cov_0.871795_g14974_i0	PRJNA664479	15050	166	0.871795	1.4471797	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	178	2.2e-40	NTclustered	gi\|2301269116\|ref\|NC_066077.1\|	197753	g14974	i0	87.179	33.2289156626506	156	20	94	0	3	158	151744	151589	Pleurosigma intermedium isolate Jiaozhou Bay in China chloroplast, complete genome	blastn	5516	178	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Pleurosigmataceae	Pleurosigma	Pleurosigma intermedium
19756080	19756080	PRJNA664479_S_NODE_4696_length_243_cov_1.634021_g4620_i0	PRJNA664479	4696	243	1.634021	3.97067103	Plasmodium inui	52288	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|672184987\|ref\|XM_008815718.1\|	1237626	g4620	i0	96.875	0.131687242798354	32	0	13	1	125	155	8920	8951	Plasmodium inui San Antonio 1 hypothetical protein partial mRNA	blastn	32	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium inui

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