metadata: contig_metadata: 10 rows where bioproject = "PRJNA897077" and tax

10 rows where bioproject = "PRJNA897077" 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
2148874	2148874	PRJNA897077_P_NODE_14462_length_260_cov_1.251337_g14335_i0	PRJNA897077	14462	260	1.251337	3.2534762	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	58.4	5.09e-4	NTclustered	gi\|916499103\|ref\|XM_013494917.1\|	44415	g14335	i0	100	3.44615384615385	31	0	12	0	147	177	804	834	Eimeria mitis uncharacterized protein (EMH_0034850), partial mRNA	blastn	896	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
4702378	4702378	PRJNA897077_P_NODE_9504_length_320_cov_1.161943_g9377_i0	PRJNA897077	9504	320	1.161943	3.7182176	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|915143848\|ref\|XM_013482598.1\|	5804	g9377	i0	100	1.346875	30	0	9	0	107	136	1904	1875	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	431	56.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
8526596	8526596	PRJNA897077_P_NODE_8047_length_345_cov_1.128676_g7920_i0	PRJNA897077	8047	345	1.128676	3.8939322	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.033	NTclustered	gi\|471220273\|ref\|XM_004025160.1\|	5932	g7920	i0	100	0.0811594202898551	28	0	8	0	223	250	263	236	Ichthyophthirius multifiliis ubiquitin- hect domain protein, putative (IMG5_189580) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
23825738	23825738	PRJNA897077_P_NODE_15399_length_253_cov_0.866667_g15272_i0	PRJNA897077	15399	253	0.866667	2.19266751	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	207	4.63e-49	NTclustered	gi\|2795032822\|ref\|XM_067928242.1\|	4785	g15272	i0	81.853	52.4901185770751	259	35	100	11	1	253	92	344	Phytophthora cinnamomi serine/threonine-protein phosphatase PP2A (IUM83_04186), partial mRNA	blastn	13280	207	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
25099525	25099525	PRJNA897077_P_NODE_11080_length_297_cov_1.392857_g10953_i0	PRJNA897077	11080	297	1.392857	4.13678529	Cercomonas sp. HFCC549	458874	SAR_Eukaryotes	SAR_Eukaryotes	549	8.029999999999997e-152	NTclustered	gi\|161015714\|gb\|EF681948.1\|	458874	g10953	i0	100	42.2693602693603	297	0	100	0	1	297	529	233	Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence	blastn	12554	549	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Cercomonas	Cercomonas sp. HFCC549
28508526	28508526	PRJNA897077_P_NODE_16947_length_249_cov_0.886364_g16820_i0	PRJNA897077	16947	249	0.886364	2.20704636	Tribonema minus	303371	SAR_Eukaryotes	SAR_Eukaryotes	48.9	2.68e-4	NR	KAG5187914.1	303371	g16820	i0	39.4	3.03614457831325	66	35	79.5	1	15	212	609	669	KAG5187914.1 P-loop containing nucleoside triphosphate hydrolase protein [Tribonema minus]	diamond	756	48.9	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema minus
28516240	28516240	PRJNA897077_P_NODE_8607_length_335_cov_1.190840_g8480_i0	PRJNA897077	8607	335	1.19084	3.989314	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	120	9.3e-30	NR	KAL0583256.1	65357	g8480	i0	57.7	16.889552238806	111	44	99.4	2	1	333	90	197	KAL0583256.1 hypothetical protein ABG067_006864 [Albugo candida]	diamond	5658	120	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
29234760	29234760	PRJNA897077_P_NODE_6989_length_369_cov_0.790541_g6862_i0	PRJNA897077	6989	369	0.790541	2.91709629	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	52	9.5e-5	NR	KAL3922692.1	3061772	g6862	i0	29.4	1.02439024390244	126	71	91.9	3	342	4	1	121	KAL3922692.1 MAG: hypothetical protein SGILL_002068 [Bacillariaceae sp.]	diamond	378	52	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
31952210	31952210	PRJNA897077_P_NODE_11737_length_289_cov_1.319444_g11610_i0	PRJNA897077	11737	289	1.319444	3.81319316	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	77.4	1.68e-14	NR	CAG9334558.1	1481888	g11610	i0	42.3	2.91695501730104	97	53	97.6	2	1	282	118	214	CAG9334558.1 unnamed protein product [Blepharisma stoltei]	diamond	843	77.4	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
32647658	32647658	PRJNA897077_P_NODE_4240_length_470_cov_1.299748_g4113_i0	PRJNA897077	4240	470	1.299748	6.1088156	Hyaloperonospora brassicae	162125	SAR_Eukaryotes	SAR_Eukaryotes	139	4.0399999999999996e-38	NR	CAI5737574.1	162125	g4113	i0	43.1	17.8468085106383	160	87	99.6	3	469	2	34	193	CAI5737574.1 unnamed protein product [Hyaloperonospora brassicae]	diamond	8388	139	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora brassicae

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