metadata: contig_metadata: 7 rows where bioproject = "PRJNA683902", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA683902", 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
2450823	2450823	PRJNA683902_S_NODE_29322_length_181_cov_1.798611_g28878_i0	PRJNA683902	29322	181	1.798611	3.25548591	Phaeodactylum	2849	SAR_Eukaryotes	SAR_Eukaryotes	82.4	1.96e-11	NTclustered	gi\|58000531\|gb\|AC151918.2\|	2850	g28878	i0	82.105	1.04972375690608	95	17	52	0	18	112	25639	25545	Phaeodactylum tricornutum clone JGIAHOK-13P10, complete sequence	blastn	190	82.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
4493107	4493107	PRJNA683902_S_NODE_13484_length_338_cov_1.750831_g13040_i0	PRJNA683902	13484	338	1.750831	5.91780878	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	159	9.14e-47	NR	CAJ1966769.1	2856	g13040	i0	85.1	42.5502958579882	94	14	83.4	0	1	282	117	210	CAJ1966769.1 unnamed protein product [Cylindrotheca closterium]	diamond	14382	159	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
7553201	7553201	PRJNA683902_S_NODE_19866_length_239_cov_10.905941_g19422_i0	PRJNA683902	19866	239	10.905941	26.06519899	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	401	1.8499999999999992e-107	NTclustered	gi\|1783235058\|gb\|MN276191.1\|	210602	g19422	i0	97.071	198.970711297071	239	6	99	1	1	238	97316	97554	Nanofrustulum shiloi strain SZCZM404 chloroplast, complete genome	blastn	47554	401	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Staurosiraceae	Nanofrustulum	Nanofrustulum shiloi
19027057	19027057	PRJNA683902_S_NODE_21815_length_223_cov_2.290323_g21371_i0	PRJNA683902	21815	223	2.290323	5.10742029	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	129	2.77e-35	NR	KAI2502075.1	210448	g21371	i0	79.5	6.87443946188341	73	15	98.2	0	222	4	71	143	KAI2502075.1 ribosomal uS7-like protein [Fragilaria crotonensis]	diamond	1533	129	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
27808948	27808948	PRJNA683902_S_NODE_23144_length_214_cov_1.723164_g22700_i0	PRJNA683902	23144	214	1.723164	3.68757096	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.00747	NR	EJK53834.1	159749	g22700	i0	39.7	1.71028037383178	63	38	88.3	0	14	202	91	153	EJK53834.1 hypothetical protein THAOC_26649 [Thalassiosira oceanica]	diamond	366	43.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
29450316	29450316	PRJNA683902_S_NODE_19270_length_246_cov_1.559809_g18826_i0	PRJNA683902	19270	246	1.559809	3.83713014	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	72.8	3.19e-13	NR	KAL3780735.1	29204	g18826	i0	42.7	2.98780487804878	82	45	98.8	2	2	244	8	88	KAL3780735.1 hypothetical protein HJC23_001017 [Cyclotella cryptica]	diamond	735	72.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
31757325	31757325	PRJNA683902_S_NODE_30737_length_176_cov_1.100719_g30293_i0	PRJNA683902	30737	176	1.100719	1.93726544	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	98.2	4.46e-22	NR	GKY94373.1	2872254	g30293	i0	79.3	1.97727272727273	58	12	98.9	0	174	1	2033	2090	GKY94373.1 hypothetical protein MPSEU_000403200 [Mayamaea pseudoterrestris]	diamond	348	98.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris

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