metadata: contig_metadata: 9 rows where bioproject = "PRJNA376117", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA376117", 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
4227339	4227339	PRJNA376117_P_NODE_7844_length_478_cov_4.422222_g7543_i0	PRJNA376117	7844	478	4.422222	21.13822116	Thalassiosira pseudonana	35128	SAR_Eukaryotes	SAR_Eukaryotes	331	5.34e-86	NTclustered	gi\|224004207\|ref\|XM_002295719.1\|	296543	g7543	i0	80.044	84.9351464435146	451	86	94	4	21	469	479	31	Thalassiosira pseudonana CCMP1335 calmodulin (CAM1), mRNA	blastn	40599	331	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana
28165888	28165888	PRJNA376117_P_NODE_41585_length_244_cov_0.900585_g41283_i0	PRJNA376117	41585	244	0.900585	2.1974274	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	102	3.72e-24	NR	KAL3802553.1	382360	g41283	i0	71.4	5.61885245901639	63	18	77.5	0	55	243	20	82	KAL3802553.1 hypothetical protein ACHAWO_002959 [Cyclotella atomus]	diamond	1371	103	0.990291262135922	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella atomus
29365711	29365711	PRJNA376117_P_NODE_31269_length_260_cov_1.647059_g30967_i0	PRJNA376117	31269	260	1.647059	4.2823534	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	116	6.339999999999999e-28	NR	KAL3797746.1	29204	g30967	i0	66.2	22.7884615384615	77	26	88.8	0	231	1	584	660	KAL3797746.1 hypothetical protein HJC23_000291 [Cyclotella cryptica]	diamond	5925	116	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
29397216	29397216	PRJNA376117_P_NODE_35589_length_249_cov_3.920455_g35287_i0	PRJNA376117	35589	249	3.920455	9.76193295	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.00218	NR	CAJ1966885.1	2856	g35287	i0	39.5	1.98795180722892	81	46	94	2	248	15	189	269	CAJ1966885.1 unnamed protein product [Cylindrotheca closterium]	diamond	495	46.6	0.991416309012876	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
29980112	29980112	PRJNA376117_P_NODE_26311_length_278_cov_1.502439_g26009_i0	PRJNA376117	26311	278	1.502439	4.17678042	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	67.8	8.47e-11	NR	CAB9504475.1	568900	g26009	i0	76.9	0.420863309352518	39	9	42.1	0	2	118	424	462	CAB9504475.1 expressed unknown protein [Seminavis robusta]	diamond	117	67.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
30801481	30801481	PRJNA376117_P_NODE_39494_length_246_cov_0.890173_g39192_i0	PRJNA376117	39494	246	0.890173	2.18982558	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	82.4	3.41e-16	NR	XP_002185385.1	556484	g39192	i0	51.3	2.92682926829268	80	30	97.6	2	6	245	257	327	XP_002185385.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	720	82.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
31971424	31971424	PRJNA376117_P_NODE_40558_length_245_cov_0.895349_g40256_i0	PRJNA376117	40558	245	0.895349	2.19360505	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	110	5.2100000000000006e-27	NR	CAJ1969338.1	2856	g40256	i0	64.2	3.95510204081633	81	29	99.2	0	2	244	201	281	CAJ1969338.1 unnamed protein product [Cylindrotheca closterium]	diamond	969	110	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
32730128	32730128	PRJNA376117_P_NODE_30680_length_262_cov_1.629630_g30378_i0	PRJNA376117	30680	262	1.62963	4.2696306	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	59.3	6.55e-8	NR	CAB9507764.1	568900	g30378	i0	44.8	1.09923664122137	96	43	98.5	4	2	259	173	268	CAB9507764.1 Cytosolic acyl coenzyme A thioester hydrolase [Seminavis robusta]	diamond	288	59.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
32887337	32887337	PRJNA376117_P_NODE_38760_length_246_cov_2.271676_g38458_i0	PRJNA376117	38760	246	2.271676	5.58832296	Discostella pseudostelligera	259834	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0279	NR	KAL3758988.1	259834	g38458	i0	45.1	0.621951219512195	51	26	62.2	1	246	94	197	245	KAL3758988.1 hypothetical protein ACHAWU_003059 [Discostella pseudostelligera]	diamond	153	43.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera

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