metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA508758" and tax

9 rows where analysis = "blastn", 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

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