metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA415856" 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
1694304	1694304	PRJNA415856_P_NODE_5462_length_410_cov_9.163435_g5201_i0	PRJNA415856	5462	410	9.163435	37.5700835	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	597	4.029999999999999e-166	NTclustered	gi\|325195057\|emb\|FR825852.1\|	890382	g5201	i0	93.596	86.6243902439024	406	16	98	7	11	410	90	491	Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391	blastn	35516	597	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
4246322	4246322	PRJNA415856_P_NODE_25824_length_182_cov_1.165414_g25563_i0	PRJNA415856	25824	182	1.165414	2.12105348	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	58.4	3.33e-4	NTclustered	gi\|695463676\|ref\|XM_009540482.1\|	67593	g25563	i0	100	0.17032967032967	31	0	17	0	18	48	1695	1725	Phytophthora sojae hypothetical protein partial mRNA	blastn	31	58.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
4246392	4246392	PRJNA415856_P_NODE_34584_length_167_cov_1.728814_g34323_i0	PRJNA415856	34584	167	1.728814	2.88711938	Cryptosporidium bovis	310047	SAR_Eukaryotes	SAR_Eukaryotes	93.5	8.25e-15	NTclustered	gi\|2787671673\|ref\|XM_067327630.1\|	310047	g34323	i0	80.328	1.51497005988024	122	24	73	0	45	166	232	353	Cryptosporidium bovis ribosomal S23 (FG379_002027), partial mRNA	blastn	253	93.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium bovis
6186339	6186339	PRJNA415856_P_NODE_12285_length_249_cov_1.840000_g12024_i0	PRJNA415856	12285	249	1.84	4.5816	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	433	6.89e-117	NTclustered	gi\|2316773050\|gb\|OP642369.1\|	291622	g12024	i0	98.374	98.7068273092369	246	4	99	0	1	246	618	863	Pseudoperonospora cannabina strain 06032022-5043 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	24578	433	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Pseudoperonospora	Pseudoperonospora cannabina
8736274	8736274	PRJNA415856_P_NODE_24867_length_183_cov_4.514925_g24606_i0	PRJNA415856	24867	183	4.514925	8.26231275	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	339	1.07e-88	NTclustered	gi\|2288302438\|gb\|OP269656.1\|	4784	g24606	i0	100	100	183	0	100	0	1	183	1114	1296	Phytophthora capsici isolate D3 large subunit ribosomal RNA gene, partial sequence	blastn	18300	339	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
13173216	13173216	PRJNA415856_P_NODE_51211_length_161_cov_1.562500_g50950_i0	PRJNA415856	51211	161	1.5625	2.515625	Peronospora calotheca	162108	SAR_Eukaryotes	SAR_Eukaryotes	246	5.7199999999999986e-61	NTclustered	gi\|33520215\|gb\|AY273960.1\|	162108	g50950	i0	94.375	99.3788819875776	160	9	99	0	2	161	575	734	Peronospora calotheca large subunit ribosomal RNA gene, partial sequence	blastn	16000	246	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora calotheca
13173240	13173240	PRJNA415856_P_NODE_53671_length_160_cov_2.657658_g53410_i0	PRJNA415856	53671	160	2.657658	4.2522528	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	139	9.9e-29	NTclustered	gi\|151368176\|gb\|EF661646.1\|	4785	g53410	i0	82.822	4.9875	163	20	99	6	2	160	756	914	Phytophthora cinnamomi strain 20080 28S ribosomal RNA, partial sequence; intergenic spacer, complete sequence; and 18S ribosomal RNA, partial sequence	blastn	798	139	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
15111061	15111061	PRJNA415856_P_NODE_16472_length_214_cov_2.812121_g16211_i0	PRJNA415856	16472	214	2.812121	6.01793894	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	396	7.559999999999996e-106	NTclustered	gi\|1238675774\|gb\|MF783088.1\|	4784	g16211	i0	100	100	214	0	100	0	1	214	972	759	Phytophthora capsici isolate CACAO small subunit ribosomal RNA gene, partial sequence	blastn	21400	396	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
18270908	18270908	PRJNA415856_P_NODE_29695_length_175_cov_1.396825_g29434_i0	PRJNA415856	29695	175	1.396825	2.44444375	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	287	3.71e-73	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g29434	i0	96.045	82.5542857142857	177	5	100	1	1	175	1545	1369	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	14447	287	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
19545071	19545071	PRJNA415856_P_NODE_23856_length_185_cov_4.183824_g23595_i0	PRJNA415856	23856	185	4.183824	7.7400744	Plasmodium reichenowi	5854	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.016	NTclustered	gi\|1145261764\|ref\|XM_012908954.2\|	5854	g23595	i0	100	0.151351351351351	28	0	15	0	8	35	2499	2526	Plasmodium reichenowi DEAD/DEAH box ATP-dependent RNA helicase, putative partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
20820871	20820871	PRJNA415856_P_NODE_12657_length_245_cov_0.984694_g12396_i0	PRJNA415856	12657	245	0.984694	2.4125003	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	364	2.5e-96	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g12396	i0	93.802	53.2326530612245	242	15	100	0	1	242	116099	116340	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	13042	364	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20820884	20820884	PRJNA415856_P_NODE_13717_length_234_cov_2.205405_g13456_i0	PRJNA415856	13717	234	2.205405	5.1606477	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	158	4.32e-34	NTclustered	gi\|219118139\|ref\|XM_002179815.1\|	556484	g13456	i0	88.976	81.9017094017094	127	14	54	0	1	127	251	377	Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 3 (UBI3), mRNA	blastn	19165	158	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
21485240	21485240	PRJNA415856_P_NODE_42017_length_165_cov_0.879310_g41756_i0	PRJNA415856	42017	165	0.87931	1.4508615	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	294	2.08e-75	NTclustered	gi\|2127884593\|ref\|NC_058877.1\|	83372	g41756	i0	98.795	199.2	166	1	100	1	1	165	14322	14157	Thalassiosira nordenskioeldii isolate CNS00052 chloroplast, complete genome	blastn	32868	294	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira nordenskioeldii

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