metadata: contig_metadata: 8 rows where bioproject = "PRJNA1249535", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA1249535", 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
9980443	9980443	PRJNA1249535_S_NODE_101508_length_373_cov_4.323333_g98125_i0	PRJNA1249535	101508	373	4.323333	16.12603209	Guinardia	216800	SAR_Eukaryotes	SAR_Eukaryotes	206	2.5699999999999997e-48	NTclustered	gi\|2074156200\|gb\|MW413905.1\|	216802	g98125	i0	78.443	69.2734584450402	334	59	88	11	46	373	24795	24469	Guinardia delicatula mitochondrion, complete genome	blastn	25839	207	0.995169082125604	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Rhizosoleniales	Rhizosoleniaceae	Guinardia	Guinardia delicatula
11837082	11837082	PRJNA1249535_S_NODE_51910_length_471_cov_4.924623_g48558_i0	PRJNA1249535	51910	471	4.924623	23.19497433	Fragilariopsis cylindrus	186039	SAR_Eukaryotes	SAR_Eukaryotes	58.4	0.001	NTclustered	gi\|1191023013\|gb\|AC275650.1\|	186039	g48558	i0	100	0.0658174097664544	31	0	7	0	299	329	28062	28092	Fragilariopsis cylindrus clone JGIFOGY-41D18, complete sequence	blastn	31	58.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
23310044	23310044	PRJNA1249535_S_NODE_315839_length_244_cov_4.304094_g312456_i0	PRJNA1249535	315839	244	4.304094	10.50198936	Skeletonema ardens	371682	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|2739942899\|dbj\|LC814759.1\|	371682	g312456	i0	100	0.114754098360656	28	0	11	0	69	96	63935	63962	Skeletonema ardens NIES-2837 chloroplast DNA, complete genome	blastn	28	52.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema ardens
27136545	27136545	PRJNA1249535_S_NODE_315822_length_244_cov_4.426901_g312439_i0	PRJNA1249535	315822	244	4.426901	10.80163844	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.00794	NR	CAB9522350.1	568900	g312439	i0	33.8	0.799180327868853	65	38	79.9	1	29	223	188	247	CAB9522350.1 expressed unknown protein [Seminavis robusta]	diamond	195	44.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
27313170	27313170	PRJNA1249535_S_NODE_320283_length_242_cov_2.556213_g316900_i0	PRJNA1249535	320283	242	2.556213	6.18603546	root	1	Root_unresolved	Root_unresolved	43.9	0.0142	NR	WPV76434.1	2126271	g316900	i0	38.6	2.14462809917355	44	27	54.5	0	43	174	264	307	WPV76434.1 RT-like putative protein [Naviculales sp.]	diamond	519	43.9	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales			Naviculales sp.
27692215	27692215	PRJNA1249535_S_NODE_266124_length_271_cov_3.232323_g262741_i0	PRJNA1249535	266124	271	3.232323	8.75959533	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0199	NR	YP_010277180.1	33649	g262741	i0	60.6	1.46125461254613	33	13	36.5	0	254	156	326	358	YP_010277180.1 Hsp70-type chaperone [Thalassionema nitzschioides]	diamond	396	43.9	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Thalassionemales	Thalassionemataceae	Thalassionema	Thalassionema nitzschioides
27989778	27989778	PRJNA1249535_S_NODE_190785_length_311_cov_3.533613_g187402_i0	PRJNA1249535	190785	311	3.533613	10.98953643	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0317	NR	GFH54937.1	426638	g187402	i0	42.9	0.472668810289389	49	25	44.4	1	273	136	230	278	GFH54937.1 hypothetical protein CTEN210_11413 [Chaetoceros tenuissimus]	diamond	147	43.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
31766767	31766767	PRJNA1249535_S_NODE_244337_length_283_cov_1.857143_g240954_i0	PRJNA1249535	244337	283	1.857143	5.25571469	root	1	Root_unresolved	Root_unresolved	56.6	8.05e-7	NR	KAL3781033.1	29204	g240954	i0	36.6	14.5017667844523	82	45	86.9	2	11	256	202	276	KAL3781033.1 hypothetical protein HJC23_007929 [Cyclotella cryptica]	diamond	4104	57	0.992982456140351	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica

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