metadata: contig_metadata: 6 rows where bioproject = "PRJNA853203", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA853203", 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
13595299	13595299	PRJNA853203_P_NODE_44751_length_243_cov_1.611765_g44602_i0	PRJNA853203	44751	243	1.611765	3.91658895	Nitzschia sp. DOCU1	3041873	SAR_Eukaryotes	SAR_Eukaryotes	377	3.18e-100	NTclustered	gi\|2504366779\|emb\|OX596002.1\|	3041873	g44602	i0	94.694	106.17695473251	245	9	100	4	1	243	31785	31543	Nitzschia sp. DOCU1 genome assembly, organelle: mitochondrion	blastn	25801	377	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia sp. DOCU1
27212895	27212895	PRJNA853203_P_NODE_45042_length_243_cov_0.917647_g44893_i0	PRJNA853203	45042	243	0.917647	2.22988221	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	72.8	1e-12	NR	KAL3801545.1	29204	g44893	i0	82.3	1.95061728395062	79	14	97.5	0	1	237	564	642	KAL3801545.1 hypothetical protein HJC23_000983 [Cyclotella cryptica]	diamond	474	72.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
28286533	28286533	PRJNA853203_P_NODE_13986_length_279_cov_1.728155_g13837_i0	PRJNA853203	13986	279	1.728155	4.82155245	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	69.7	1.93e-11	NR	KAL3780888.1	29204	g13837	i0	47.4	0.838709677419355	78	41	83.9	0	277	44	824	901	KAL3780888.1 hypothetical protein HJC23_009934 [Cyclotella cryptica]	diamond	234	69.7	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
29202541	29202541	PRJNA853203_P_NODE_43429_length_244_cov_0.912281_g43280_i0	PRJNA853203	43429	244	0.912281	2.22596564	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0183	NR	KAL3783202.1	29204	g43280	i0	68.8	0.39344262295082	32	9	38.1	1	93	1	1	32	KAL3783202.1 hypothetical protein HJC23_013545 [Cyclotella cryptica]	diamond	96	43.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
31034801	31034801	PRJNA853203_P_NODE_28895_length_252_cov_0.871508_g28746_i0	PRJNA853203	28895	252	0.871508	2.19620016	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.00866	NR	KAL3776596.1	29204	g28746	i0	86.4	0.523809523809524	22	3	26.2	0	251	186	38	59	KAL3776596.1 hypothetical protein HJC23_005796 [Cyclotella cryptica]	diamond	132	44.7	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
31508900	31508900	PRJNA853203_P_NODE_18736_length_269_cov_1.224490_g18587_i0	PRJNA853203	18736	269	1.22449	3.2938781	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	48.9	3.38e-4	NR	KAL3792175.1	29204	g18587	i0	53.7	0.45724907063197	41	19	45.7	0	124	2	37	77	KAL3792175.1 hypothetical protein HJC23_009639 [Cyclotella cryptica]	diamond	123	48.9	1	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);;