metadata: contig_metadata: 14 rows where bioproject = "PRJNA994052", tax_clade = "Sar" and tax

14 rows where bioproject = "PRJNA994052", 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
2251570	2251570	PRJNA994052_P_NODE_30862_length_279_cov_90.140777_g29618_i0	PRJNA994052	30862	279	90.140777	251.49276783	Encyonema minutum	431330	SAR_Eukaryotes	SAR_Eukaryotes	483	7.689999999999998e-132	NTclustered	gi\|168145881\|emb\|AM710515.1\|	431330	g29618	i0	99.621	95.2974910394265	264	1	95	0	1	264	49	312	Encyonema minutum partial 28S rRNA gene, strain AT-137.13	blastn	26588	483	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Cymbellales	Cymbellaceae	Encyonema	Encyonema minutum
3526665	3526665	PRJNA994052_P_NODE_11403_length_327_cov_31.460630_g10187_i0	PRJNA994052	11403	327	31.46063	102.8762601	Asterionellopsis glacialis	33640	SAR_Eukaryotes	SAR_Eukaryotes	202	2.8899999999999996e-47	NTclustered	gi\|2202538972\|gb\|OM891878.1\|	33640	g10187	i0	91.781	84.7584097859327	146	10	86	1	184	327	4369	4224	Asterionellopsis glacialis small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	27716	202	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Asterionellopsis	Asterionellopsis glacialis
16575901	16575901	PRJNA994052_P_NODE_80493_length_200_cov_26.102362_g79236_i0	PRJNA994052	80493	200	26.102362	52.204724	Navicula	50949	SAR_Eukaryotes	SAR_Eukaryotes	339	1.19e-88	NTclustered	gi\|168145917\|emb\|AM710568.1\|	431397	g79236	i0	99.462	92.22	186	1	93	0	14	199	313	128	Navicula capitatoradiata partial 28S rRNA gene, strain AT-212Gel07	blastn	18444	339	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Navicula	Navicula capitatoradiata
17554451	17554451	PRJNA994052_P_NODE_51834_length_238_cov_33.024242_g50579_i0	PRJNA994052	51834	238	33.024242	78.59769596	Nitzschia cf. pusilla	185983	SAR_Eukaryotes	SAR_Eukaryotes	185	2.0199999999999998e-42	NTclustered	gi\|1891520127\|gb\|MN696717.1\|	185983	g50579	i0	97.248	85.1848739495798	109	3	92	0	1	109	590	698	Nitzschia cf. pusilla culture TCC:586 small subunit ribosomal RNA gene, partial sequence	blastn	20274	185	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia cf. pusilla
19124516	19124516	PRJNA994052_P_NODE_56735_length_231_cov_5.607595_g55480_i0	PRJNA994052	56735	231	5.607595	12.95354445	Ulnaria	426668	SAR_Eukaryotes	SAR_Eukaryotes	196	9.01e-46	NTclustered	gi\|187957792\|emb\|AM497727.1\|	426669	g55480	i0	97.414	95.025974025974	116	2	95	1	116	231	962	848	Synedra ulna 18S rRNA gene, strain AtFULN1	blastn	21951	196	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Licmophorales	Ulnariaceae	Ulnaria	Ulnaria ulna
22653755	22653755	PRJNA994052_P_NODE_60658_length_225_cov_16.796053_g59402_i0	PRJNA994052	60658	225	16.796053	37.79111925	Brebissonia lanceolata	487518	SAR_Eukaryotes	SAR_Eukaryotes	387	4.829999999999998e-103	NTclustered	gi\|168145930\|emb\|AM710582.1\|	487518	g59402	i0	99.528	57.2133333333333	212	1	94	0	14	225	310	99	Cymbella lanceolata partial 28S rRNA gene, strain AT-194Gel07	blastn	12873	387	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Cymbellales	Cymbellaceae	Brebissonia	Brebissonia lanceolata
24224935	24224935	PRJNA994052_P_NODE_78459_length_202_cov_57.883721_g77202_i0	PRJNA994052	78459	202	57.883721	116.92511642	Fragilariophyceae	33853	SAR_Eukaryotes	SAR_Eukaryotes	152	1.6899999999999998e-32	NTclustered	gi\|215400920\|gb\|EU883365.1\|	232514	g77202	i0	100	40.5940594059406	82	0	41	0	115	196	93	12	Tabularia tabulata strain 421D 5.8S ribosomal RNA gene and internal transcribed spacer 2, partial sequence	blastn	8200	152	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Licmophorales	Ulnariaceae	Tabularia	Tabularia tabulata
28132112	28132112	PRJNA994052_P_NODE_43445_length_252_cov_26.586592_g42197_i0	PRJNA994052	43445	252	26.586592	66.99821184	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	48.5	3.82e-4	NR	KAI2513306.1	210448	g42197	i0	42	1.19047619047619	50	29	59.5	0	2	151	617	666	KAI2513306.1 ubiquitin-specific protease [Fragilaria crotonensis]	diamond	300	48.5	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
28731912	28731912	PRJNA994052_P_NODE_29467_length_283_cov_29.914286_g28225_i0	PRJNA994052	29467	283	29.914286	84.65742938	Stephanodiscus triporus	2934178	SAR_Eukaryotes	SAR_Eukaryotes	52	1.32e-5	NR	KAL3770480.1	2934178	g28225	i0	74.2	0.328621908127208	31	8	32.9	0	201	109	28	58	KAL3770480.1 hypothetical protein ACHAW5_001493 [Stephanodiscus triporus]	diamond	93	52	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Stephanodiscus	Stephanodiscus triporus
29274330	29274330	PRJNA994052_P_NODE_56489_length_231_cov_27.449367_g55234_i0	PRJNA994052	56489	231	27.449367	63.40803777	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	48.1	3.77e-4	NR	KAL3790979.1	382360	g55234	i0	45.2	2.18181818181818	62	21	80.5	2	191	6	41	89	KAL3790979.1 hypothetical protein ACHAWO_000139 [Cyclotella atomus]	diamond	504	48.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella atomus
29305975	29305975	PRJNA994052_P_NODE_58189_length_228_cov_273.703226_g56933_i0	PRJNA994052	58189	228	273.703226	624.04335528	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	45.1	8.35e-4	NR	EJK58441.1	159749	g56933	i0	73.1	0.697368421052632	26	7	34.2	0	2	79	7	32	EJK58441.1 hypothetical protein THAOC_21443 [Thalassiosira oceanica]	diamond	159	45.4	0.993392070484582	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
29647121	29647121	PRJNA994052_P_NODE_40650_length_257_cov_56.989130_g39403_i0	PRJNA994052	40650	257	56.98913	146.4620641	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	96.7	4.77e-21	NR	GFH43592.1	426638	g39403	i0	88.7	0.618677042801556	53	6	61.9	0	255	97	658	710	GFH43592.1 transketolase [Chaetoceros tenuissimus]	diamond	159	96.7	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
31258781	31258781	PRJNA994052_P_NODE_61135_length_224_cov_40.986755_g59879_i0	PRJNA994052	61135	224	40.986755	91.8103312	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	62.8	7.64e-10	NR	GAX14273.1	1519565	g59879	i0	73.5	1.3125	49	13	65.6	0	221	75	153	201	GAX14273.1 large subunit ribosomal protein L13Ae [Fistulifera solaris]	diamond	294	62.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
31512017	31512017	PRJNA994052_P_NODE_67936_length_215_cov_21.471831_g66680_i0	PRJNA994052	67936	215	21.471831	46.16443665	Cyclotella atomus	382360	SAR_Eukaryotes	SAR_Eukaryotes	59.3	3.33e-8	NR	KAL3794969.1	382360	g66680	i0	90	0.418604651162791	30	3	41.9	0	213	124	303	332	KAL3794969.1 hypothetical protein ACHAWO_009928 [Cyclotella atomus]	diamond	90	59.3	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella atomus

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