metadata: contig_metadata: 11 rows where bioproject = "PRJNA857857", tax_clade = "Sar" and tax

11 rows where bioproject = "PRJNA857857", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

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
8497933	8497933	PRJNA857857_P_NODE_32607_length_269_cov_1.178571_g32158_i0	PRJNA857857	32607	269	1.178571	3.17035599	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	159	1.27e-44	NR	KAL3773012.1	382360	g32158	i0	86.9	6.52416356877323	84	11	93.7	0	252	1	1	84	KAL3773012.1 hypothetical protein ACHAWO_003967 [Cyclotella atomus]	diamond	1755	159	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella atomus
8498159	8498159	PRJNA857857_P_NODE_42147_length_247_cov_1.327586_g41698_i0	PRJNA857857	42147	247	1.327586	3.27913742	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	89.4	1.55e-18	NR	GKY90838.1	2872254	g41698	i0	52.3	5.79352226720648	88	34	97.2	1	5	244	392	479	GKY90838.1 hypothetical protein MPSEU_000056600 [Mayamaea pseudoterrestris]	diamond	1431	89.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
15263753	15263753	PRJNA857857_P_NODE_43692_length_246_cov_0.890173_g43243_i0	PRJNA857857	43692	246	0.890173	2.18982558	Chaetoceros	49237	SAR_Eukaryotes	SAR_Eukaryotes	357	4.1999999999999997e-94	NTclustered	gi\|700082471\|ref\|NC_025310.1\|	156587	g43243	i0	93.033	97.2764227642276	244	17	99	0	1	244	34301	34058	Chaetoceros simplex chloroplast, complete genome	blastn	23930	357	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros simplex
27189546	27189546	PRJNA857857_P_NODE_13902_length_422_cov_1.765043_g13456_i0	PRJNA857857	13902	422	1.765043	7.44848146	root	1	Root_unresolved	Root_unresolved	173	1.02e-48	NR	CAB9508152.1	568900	g13456	i0	77.6	6.88862559241706	107	24	76.1	0	321	1	80	186	CAB9508152.1 sulfoquinovose synthase, chloroplastic [Seminavis robusta]	diamond	2907	173	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
27244698	27244698	PRJNA857857_P_NODE_32083_length_272_cov_0.819095_g31634_i0	PRJNA857857	32083	272	0.819095	2.2279384	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	71.2	5.01e-12	NR	KAG7339396.1	303405	g31634	i0	46.3	2.32720588235294	80	36	88.2	2	17	256	533	605	KAG7339396.1 DUF3689 domain containing protein [Nitzschia inconspicua]	diamond	633	71.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
28950097	28950097	PRJNA857857_P_NODE_7668_length_561_cov_1.420082_g7240_i0	PRJNA857857	7668	561	1.420082	7.96666002	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	94.4	1.08e-18	NR	GFH58912.1	426638	g7240	i0	37.4	0.657754010695187	123	75	65.2	2	398	33	81	202	GFH58912.1 hypothetical protein CTEN210_15388 [Chaetoceros tenuissimus]	diamond	369	94.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
31034874	31034874	PRJNA857857_P_NODE_8675_length_528_cov_5.648352_g8244_i0	PRJNA857857	8675	528	5.648352	29.82329856	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	73.6	1.48e-11	NR	KAK1748286.1	267567	g8244	i0	42.2	1.74431818181818	90	49	49.4	2	379	119	907	996	KAK1748286.1 vacuolar protein sorting-associated protein 54 [Skeletonema marinoi]	diamond	921	73.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
31413943	31413943	PRJNA857857_P_NODE_16816_length_383_cov_1.241935_g16369_i0	PRJNA857857	16816	383	1.241935	4.75661105	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	55.8	4.79e-6	NR	CAB9513913.1	568900	g16369	i0	26.4	0.947780678851175	121	85	92.4	3	377	24	601	720	CAB9513913.1 armadillo repeat containing 6 [Seminavis robusta]	diamond	363	55.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
31643304	31643304	PRJNA857857_P_NODE_26656_length_300_cov_1.696035_g26207_i0	PRJNA857857	26656	300	1.696035	5.088105	Coscinodiscophyceae	33836	SAR_Eukaryotes	SAR_Eukaryotes	124	1.68e-30	NR	EJK67695.1	159749	g26207	i0	70.8	2.74	89	25	89	1	4	270	803	890	EJK67695.1 hypothetical protein THAOC_11241 [Thalassiosira oceanica]	diamond	822	124	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
32718505	32718505	PRJNA857857_P_NODE_22140_length_332_cov_1.559846_g21691_i0	PRJNA857857	22140	332	1.559846	5.17868872	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	122	1.43e-29	NR	KAI2503821.1	210448	g21691	i0	65.5	8.83734939759036	87	29	77.7	1	75	332	21	107	KAI2503821.1 C-terminal domain of Poly(A)-binding protein [Fragilaria crotonensis]	diamond	2934	122	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
32773197	32773197	PRJNA857857_P_NODE_45620_length_245_cov_0.895349_g45171_i0	PRJNA857857	45620	245	0.895349	2.19360505	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	57.4	2.6e-7	NR	KAI2493888.1	210448	g45171	i0	49.1	1.29795918367347	53	27	64.9	0	218	60	339	391	KAI2493888.1 PIF1-like helicase [Fragilaria crotonensis]	diamond	318	57.4	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis

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