metadata: contig_metadata: 11 rows where bioproject = "PRJNA1139127" and tax

11 rows where bioproject = "PRJNA1139127" 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
4111990	4111990	PRJNA1139127_P_NODE_13984_length_546_cov_1.564482_g13503_i0	PRJNA1139127	13984	546	1.564482	8.54207172	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	662	0	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g13503	i0	89.655	1.5952380952381	522	50	95	3	1	520	1531	1012	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	871	662	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
13785624	13785624	PRJNA1139127_P_NODE_26251_length_351_cov_1.111511_g25759_i0	PRJNA1139127	26251	351	1.111511	3.90140361	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.98e-4	NTclustered	gi\|915002776\|ref\|XM_013393443.1\|	5801	g25759	i0	94.872	9.49287749287749	39	1	11	1	286	323	11084	11046	Eimeria acervulina UBA/TS-N domain-containing protein, putative partial mRNA	blastn	3332	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
15060003	15060003	PRJNA1139127_P_NODE_43732_length_250_cov_0.875706_g43239_i0	PRJNA1139127	43732	250	0.875706	2.189265	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	451	1.91e-122	NTclustered	gi\|1837628855\|gb\|MN158348.1\|	5909	g43239	i0	99.2	92.464	250	2	100	0	1	250	2607	2856	Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	23116	451	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena rostrata
15588214	15588214	PRJNA1139127_P_NODE_47213_length_245_cov_0.889535_g46720_i0	PRJNA1139127	47213	245	0.889535	2.17936075	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	355	1.51e-93	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g46720	i0	93.004	42.8	243	17	99	0	3	245	116359	116601	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	10486	355	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
18137056	18137056	PRJNA1139127_P_NODE_46555_length_245_cov_2.482558_g46062_i0	PRJNA1139127	46555	245	2.482558	6.0822671	Synura synuroidea	47573	SAR_Eukaryotes	SAR_Eukaryotes	189	1.62e-43	NTclustered	gi\|11466457\|ref\|NC_002174.1\|	47573	g46062	i0	82.87	21.9632653061224	216	32	87	5	22	235	815	1027	Chrysodidymus synuroideus mitochondrion, complete genome	blastn	5381	189	1	Eukaryota	Sar		Synurophyceae	Synurales	Mallomonadaceae	Synura	Synura synuroidea
24511059	24511059	PRJNA1139127_P_NODE_30700_length_315_cov_1.285124_g30208_i0	PRJNA1139127	30700	315	1.285124	4.0481406	Durusdinium trenchii	1381693	SAR_Eukaryotes	SAR_Eukaryotes	122	5.26e-33	NR	CAK9114403.1	1381693	g30208	i0	63.5	3.54285714285714	96	33	89.5	1	282	1	6	101	CAK9114403.1 40S ribosomal protein S11-2 [Durusdinium trenchii]	diamond	1116	122	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Durusdinium	Durusdinium trenchii
26658643	26658643	PRJNA1139127_P_NODE_36001_length_282_cov_1.110048_g35508_i0	PRJNA1139127	36001	282	1.110048	3.13033536	Pseudo-nitzschia multistriata	183589	SAR_Eukaryotes	SAR_Eukaryotes	52.8	1.87e-5	NR	VEU37424.1	183589	g35508	i0	56.3	0.51063829787234	48	17	51.1	1	1	144	1227	1270	VEU37424.1 unnamed protein product [Pseudo-nitzschia multistriata]	diamond	144	52.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia multistriata
30228292	30228292	PRJNA1139127_P_NODE_37372_length_274_cov_2.776119_g36879_i0	PRJNA1139127	37372	274	2.776119	7.60656606	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	63.5	7.66e-10	NR	KAJ1389255.1	483371	g36879	i0	46.7	0.656934306569343	60	32	65.7	0	270	91	143	202	KAJ1389255.1 hypothetical protein B484DRAFT_459702 [Ochromonadaceae sp. CCMP2298]	diamond	180	63.5	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
30860309	30860309	PRJNA1139127_P_NODE_32974_length_299_cov_3.296460_g32481_i0	PRJNA1139127	32974	299	3.29646	9.8564154	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	49.7	2.74e-4	NR	GFH58591.1	426638	g32481	i0	34.9	0.632107023411371	63	41	63.2	0	194	6	10	72	GFH58591.1 hypothetical protein CTEN210_15067 [Chaetoceros tenuissimus]	diamond	189	49.7	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
31397736	31397736	PRJNA1139127_P_NODE_20756_length_413_cov_1.588235_g20265_i0	PRJNA1139127	20756	413	1.588235	6.55941055	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	232	1.17e-69	NR	XP_001033325.2	312017	g20265	i0	98.3	0.835351089588378	115	2	83.5	0	69	413	262	376	XP_001033325.2 kinesin motor catalytic domain protein [Tetrahymena thermophila SB210]	diamond	345	232	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31461101	31461101	PRJNA1139127_P_NODE_41916_length_253_cov_1.011111_g41423_i0	PRJNA1139127	41916	253	1.011111	2.55811083	Globisporangium splendens	82926	SAR_Eukaryotes	SAR_Eukaryotes	104	2.34e-24	NR	KAF1330494.1	82926	g41423	i0	59	1.96837944664032	83	34	98.4	0	5	253	291	373	KAF1330494.1 Adenosine kinase, partial [Globisporangium splendens]	diamond	498	104	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens

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