metadata: contig_metadata: 15 rows where bioproject = "PRJNA576995", tax_clade = "Sar" and tax

15 rows where bioproject = "PRJNA576995", 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
1136927	1136927	PRJNA576995_P_NODE_13681_length_406_cov_3.042042_g13089_i0	PRJNA576995	13681	406	3.042042	12.35069052	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	92.8	1.87e-20	NR	XP_002293544.1	296543	g13089	i0	57.3	6.37684729064039	82	31	57.6	1	165	398	69	150	XP_002293544.1 RS8, ribosomal protein 8 [Thalassiosira pseudonana CCMP1335]	diamond	2589	92.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana
5664229	5664229	PRJNA576995_P_NODE_18085_length_353_cov_1.060714_g17493_i0	PRJNA576995	18085	353	1.060714	3.74432042	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	126	2.0299999999999993e-34	NR	XP_002180336.1	556484	g17493	i0	53.5	0.858356940509915	101	47	85.8	0	1	303	47	147	XP_002180336.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	303	126	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
6938786	6938786	PRJNA576995_P_NODE_25126_length_305_cov_0.853448_g24534_i0	PRJNA576995	25126	305	0.853448	2.6030164	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	156	1.03e-46	NR	VEU44507.1	183589	g24534	i0	72	14.7540983606557	100	28	98.4	0	302	3	2	101	VEU44507.1 unnamed protein product [Pseudo-nitzschia multistriata]	diamond	4500	157	0.993630573248408	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia multistriata
11340265	11340265	PRJNA576995_P_NODE_42769_length_242_cov_0.869822_g42177_i0	PRJNA576995	42769	242	0.869822	2.10496924	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	154	5.44e-44	NR	AAX09600.1	29204	g42177	i0	90	2.97520661157025	80	8	99.2	0	240	1	103	182	AAX09600.1 elongation factor 1 alpha, partial [Cyclotella cryptica]	diamond	720	154	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
26840261	26840261	PRJNA576995_P_NODE_40361_length_245_cov_0.895349_g39769_i0	PRJNA576995	40361	245	0.895349	2.19360505	Bacillariaceae	33852	SAR_Eukaryotes	SAR_Eukaryotes	45.8	0.00318	NR	CAJ1953877.1	2856	g39769	i0	28.9	2.03265306122449	83	53	94.3	1	5	235	963	1045	CAJ1953877.1 unnamed protein product [Cylindrotheca closterium]	diamond	498	45.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
26984598	26984598	PRJNA576995_P_NODE_34862_length_251_cov_0.865169_g34270_i0	PRJNA576995	34862	251	0.865169	2.17157419	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	117	1.47e-28	NR	KAG7338941.1	303405	g34270	i0	67.1	0.9800796812749	82	27	98	0	1	246	158	239	KAG7338941.1 ATP synthase F1 subcomplex delta subunit [Nitzschia inconspicua]	diamond	246	117	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
28279529	28279529	PRJNA576995_P_NODE_35066_length_251_cov_0.865169_g34474_i0	PRJNA576995	35066	251	0.865169	2.17157419	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	105	1.23e-24	NR	KAI2491713.1	210448	g34474	i0	52.7	1.11155378486056	93	33	99.2	3	1	249	208	299	KAI2491713.1 methyltransferase domain-containing protein [Fragilaria crotonensis]	diamond	279	105	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
28798269	28798269	PRJNA576995_P_NODE_43487_length_241_cov_0.916667_g42895_i0	PRJNA576995	43487	241	0.916667	2.20916747	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	66.6	1.38e-10	NR	XP_002180686.1	556484	g42895	i0	44.4	13.9917012448133	72	38	89.6	2	16	231	165	234	XP_002180686.1 GrpE protein, HSP90 cofactor, chloroplast targeted, partial [Phaeodactylum tricornutum CCAP 1055/1]	diamond	3372	66.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
29353364	29353364	PRJNA576995_P_NODE_26549_length_296_cov_1.381166_g25957_i0	PRJNA576995	26549	296	1.381166	4.08825136	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	107	1.19e-24	NR	KAL3923689.1	3061772	g25957	i0	53.4	1.71283783783784	88	41	89.2	0	288	25	60	147	KAL3923689.1 MAG: hypothetical protein SGILL_001510 [Bacillariaceae sp.]	diamond	507	107	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
29479253	29479253	PRJNA576995_P_NODE_38050_length_248_cov_0.880000_g37458_i0	PRJNA576995	38050	248	0.88	2.1824	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	57	3.78e-7	NR	GFH52008.1	426638	g37458	i0	42.3	3.52016129032258	71	38	85.9	1	221	9	843	910	GFH52008.1 peptidase M16-domain-containing protein [Chaetoceros tenuissimus]	diamond	873	57	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
29542558	29542558	PRJNA576995_P_NODE_20970_length_330_cov_1.797665_g20378_i0	PRJNA576995	20970	330	1.797665	5.9322945	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	52.4	4.22e-5	NR	KAK1735154.1	267567	g20378	i0	44.6	0.509090909090909	56	30	50	1	37	201	500	555	KAK1735154.1 hypothetical protein QTG54_014220 [Skeletonema marinoi]	diamond	168	52.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
31849553	31849553	PRJNA576995_P_NODE_37777_length_248_cov_0.880000_g37185_i0	PRJNA576995	37777	248	0.88	2.1824	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	51.6	2.78e-5	NR	KAK1747590.1	267567	g37185	i0	36.6	1.56048387096774	82	39	84.7	2	31	240	40	120	KAK1747590.1 phytanoyl-CoA dioxygenase family protein [Skeletonema marinoi]	diamond	387	51.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
31862978	31862978	PRJNA576995_P_NODE_35177_length_251_cov_0.865169_g34585_i0	PRJNA576995	35177	251	0.865169	2.17157419	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	47.4	9.55e-4	NR	KAK1736995.1	267567	g34585	i0	43.4	3.03585657370518	53	29	62.2	1	94	249	159	211	KAK1736995.1 calcium-dependent protein kinase [Skeletonema marinoi]	diamond	762	47.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
32166197	32166197	PRJNA576995_P_NODE_1118_length_1419_cov_2.208024_g911_i0	PRJNA576995	1118	1419	2.208024	31.33186056	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	148	2.14e-35	NR	CAB9518259.1	568900	g911	i0	40.8	0.492600422832981	233	127	49	5	216	911	33	255	CAB9518259.1 protocatechuate 3,4-dioxygenase [Seminavis robusta]	diamond	699	148	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
32292952	32292952	PRJNA576995_P_NODE_13119_length_416_cov_1.775510_g12527_i0	PRJNA576995	13119	416	1.77551	7.3861216	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.0293	NR	KAL3902955.1	3061772	g12527	i0	36.4	0.396634615384615	55	35	39.7	0	343	179	94	148	KAL3902955.1 MAG: hypothetical protein SGILL_010631, partial [Bacillariaceae sp.]	diamond	165	44.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.

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