metadata: contig_metadata: 18 rows where bioproject = "PRJNA508758" and tax

18 rows where bioproject = "PRJNA508758" 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
1110709	1110709	PRJNA508758_P_NODE_9521_length_703_cov_19.922222_g8570_i0	PRJNA508758	9521	703	19.922222	140.05322066	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	239	5.02e-58	NTclustered	gi\|2795048880\|ref\|XM_067943659.1\|	4785	g8570	i0	77.694	6.425320056899	399	84	56	4	251	645	42	439	Phytophthora cinnamomi Calmodulin (IUM83_18649), partial mRNA	blastn	4517	239	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
3661888	3661888	PRJNA508758_P_NODE_32303_length_359_cov_1.615385_g31255_i0	PRJNA508758	32303	359	1.615385	5.79923215	Synurales	420622	SAR_Eukaryotes	SAR_Eukaryotes	200	1.15e-46	NTclustered	gi\|407079770\|gb\|JQ281513.1\|	2989	g31255	i0	91.667	40.116991643454	144	12	40	0	216	359	702	845	Mallomonas papillosa strain CCMP476 28S ribosomal RNA gene, partial sequence	blastn	14402	200	1	Eukaryota	Sar		Synurophyceae	Synurales	Mallomonadaceae	Mallomonas	Mallomonas papillosa
10039132	10039132	PRJNA508758_P_NODE_18408_length_470_cov_1.551637_g17361_i0	PRJNA508758	18408	470	1.551637	7.2926939	Dinophyceae	2864	SAR_Eukaryotes	SAR_Eukaryotes	124	9.549999999999999e-24	NTclustered	gi\|398372891\|gb\|JX402086.1\|	39449	g17361	i0	86.207	12.2127659574468	116	15	25	1	279	394	5216	5330	Prorocentrum minimum strain D-127 intergenic spacer, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence	blastn	5740	124	1	Eukaryota	Sar		Dinophyceae	Prorocentrales	Prorocentraceae	Prorocentrum	Prorocentrum minimum
12589577	12589577	PRJNA508758_P_NODE_14410_length_541_cov_2.284188_g13388_i0	PRJNA508758	14410	541	2.284188	12.35745708	root	1	Root_unresolved	Root_unresolved	54.7	0.015	NTclustered	gi\|921121930\|ref\|XM_013580129.1\|	51315	g13388	i0	100	0.171903881700555	29	0	5	0	171	199	1608	1636	Eimeria necatrix hypothetical protein, conserved partial mRNA	blastn	93	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
13238778	13238778	PRJNA508758_P_NODE_7411_length_843_cov_5.594805_g6548_i0	PRJNA508758	7411	843	5.594805	47.16420615	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.024	NTclustered	gi\|124506116\|ref\|XM_001351620.1\|	36329	g6548	i0	100	0.0344009489916963	29	0	3	0	297	325	3114	3142	Plasmodium falciparum 3D7 phosphatidylinositol 4-kinase (PF3D7_0509800), partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
23436811	23436811	PRJNA508758_P_NODE_16119_length_507_cov_1.698157_g15074_i0	PRJNA508758	16119	507	1.698157	8.60965599	Eimeria necatrix	51315	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.05	NTclustered	gi\|921132605\|ref\|XM_013585384.1\|	51315	g15074	i0	100	0.0552268244575937	28	0	6	0	420	447	655	628	Eimeria necatrix hypothetical protein, conserved partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
23436858	23436858	PRJNA508758_P_NODE_19659_length_454_cov_2.293963_g18612_i0	PRJNA508758	19659	454	2.293963	10.41459202	Cryptosporidium ubiquitum	857276	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.044	NTclustered	gi\|1624735482\|ref\|XM_029020510.1\|	857276	g18612	i0	100	0.0616740088105727	28	0	6	0	24	51	4444	4417	Cryptosporidium ubiquitum chromatinic protein (cubi_03497), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ubiquitum
23437021	23437021	PRJNA508758_P_NODE_38799_length_333_cov_1.769231_g37751_i0	PRJNA508758	38799	333	1.769231	5.89153923	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	58.4	6.74e-4	NTclustered	gi\|325194640\|emb\|FR825452.1\|	890382	g37751	i0	100	0.0930930930930931	31	0	9	0	96	126	304	274	Albugo laibachii Nc14, genomic contig CONTIG_2296_NC14_v4_898_20	blastn	31	58.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
25337088	25337088	PRJNA508758_P_NODE_57940_length_282_cov_1.416268_g56892_i0	PRJNA508758	57940	282	1.416268	3.99387576	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	100	9.16e-17	NTclustered	gi\|1843572816\|ref\|XM_034566237.1\|	5823	g56892	i0	92.754	23.7234042553191	69	5	24	0	214	282	425	357	Plasmodium berghei ANKA histone H2A.Z, putative (PBANKA_1217600), partial mRNA	blastn	6690	100	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
26665364	26665364	PRJNA508758_P_NODE_28441_length_379_cov_2.810458_g27393_i0	PRJNA508758	28441	379	2.810458	10.65163582	Chrysophaeum taylorii	2483200	SAR_Eukaryotes	SAR_Eukaryotes	70.9	2.26e-11	NR	KAJ8601885.1	2483200	g27393	i0	62.7	0.467018469656992	59	22	46.7	0	63	239	416	474	KAJ8601885.1 hypothetical protein CTAYLR_002641 [Chrysophaeum taylorii]	diamond	177	70.9	1	Eukaryota	Sar		Pelagophyceae	Pelagomonadales	Pelagomonadaceae	Chrysophaeum	Chrysophaeum taylorii
27614378	27614378	PRJNA508758_P_NODE_51164_length_297_cov_1.375000_g50116_i0	PRJNA508758	51164	297	1.375	4.08375	Saprolegnia diclina VS2	112098	SAR_Eukaryotes	SAR_Eukaryotes	58.9	1.43e-7	NR	XP_008605336.1	1156394	g50116	i0	33.6	3.12121212121212	107	60	97	2	294	7	158	264	XP_008605336.1 CK1/TTBK protein kinase [Saprolegnia diclina VS20]	diamond	927	58.9	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
28277141	28277141	PRJNA508758_P_NODE_90126_length_227_cov_3.077922_g89078_i0	PRJNA508758	90126	227	3.077922	6.98688294	Symbiodinium natans	878477	SAR_Eukaryotes	SAR_Eukaryotes	48.1	3.89e-4	NR	CAE7495486.1	878477	g89078	i0	33.3	0.951541850220264	72	42	93.8	3	226	14	399	465	CAE7495486.1 gefF [Symbiodinium natans]	diamond	216	48.1	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium natans
28387356	28387356	PRJNA508758_P_NODE_34626_length_349_cov_1.242754_g33578_i0	PRJNA508758	34626	349	1.242754	4.33721146	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	68.9	7.17e-11	NR	XP_012899324.1	12968	g33578	i0	46.8	3.49856733524355	79	42	67.9	0	262	26	66	144	XP_012899324.1 uncharacterized protein [Blastocystis hominis]	diamond	1221	69.3	0.994227994227994	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis hominis
28624805	28624805	PRJNA508758_P_NODE_7787_length_812_cov_2.834912_g6897_i0	PRJNA508758	7787	812	2.834912	23.01948544	Nannochloropsis gaditana	72520	SAR_Eukaryotes	SAR_Eukaryotes	86.7	4.04e-15	NR	EWM30533.1	72520	g6897	i0	44.3	0.358374384236453	97	53	35.5	1	10	297	361	457	EWM30533.1 transcription initiation factor tfiid subunit 5 [Nannochloropsis gaditana]	diamond	291	86.7	1	Eukaryota	Sar		Eustigmatophyceae	Eustigmatales	Monodopsidaceae	Nannochloropsis	Nannochloropsis gaditana
29193082	29193082	PRJNA508758_P_NODE_43589_length_318_cov_1.257143_g42541_i0	PRJNA508758	43589	318	1.257143	3.99771474	Blastocystis hominis	12968	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0493	NR	XP_012897472.1	12968	g42541	i0	34.5	0.547169811320755	58	33	50	1	195	37	10	67	XP_012897472.1 uncharacterized protein [Blastocystis hominis]	diamond	174	42.7	1	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis hominis
29950811	29950811	PRJNA508758_P_NODE_88591_length_241_cov_0.916667_g87543_i0	PRJNA508758	88591	241	0.916667	2.20916747	Symbiodinium sp. CCMP2592	631055	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0485	NR	CAE7251447.1	631055	g87543	i0	34.3	0.83402489626556	67	43	82.2	1	217	20	285	351	CAE7251447.1 unnamed protein product [Symbiodinium sp. CCMP2592]	diamond	201	42.4	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium sp. CCMP2592
32005422	32005422	PRJNA508758_P_NODE_40618_length_327_cov_1.311024_g39570_i0	PRJNA508758	40618	327	1.311024	4.28704848	Symbiodinium microadriaticum	2951	SAR_Eukaryotes	SAR_Eukaryotes	62.8	8.52e-9	NR	CAE7489375.1	2951	g39570	i0	36.1	0.889908256880734	97	61	88.1	1	11	298	157	253	CAE7489375.1 POLA2, partial [Symbiodinium microadriaticum]	diamond	291	62.8	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
32369075	32369075	PRJNA508758_P_NODE_18379_length_470_cov_2.236776_g17332_i0	PRJNA508758	18379	470	2.236776	10.5128472	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	73.6	1.8e-12	NR	KAH9183547.1	100861	g17332	i0	39.4	4.5	104	59	66.4	2	109	420	103	202	KAH9183547.1 hypothetical protein AeNC1_014477 [Aphanomyces euteiches]	diamond	2115	74.3	0.990578734858681	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches

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