metadata: contig_metadata: 8 rows where bioproject = "PRJNA1164198" and tax

8 rows where bioproject = "PRJNA1164198" 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
13065609	13065609	PRJNA1164198_P_NODE_30991_length_242_cov_0.923077_g30722_i0	PRJNA1164198	30991	242	0.923077	2.23384634	root	1	Root_unresolved	Root_unresolved	127	3.4399999999999993e-34	NR	KAI2505670.1	210448	g30722	i0	75	3.96694214876033	80	20	99.2	0	242	3	19	98	KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis]	diamond	960	128	0.9921875	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
20713381	20713381	PRJNA1164198_P_NODE_7997_length_442_cov_1.460705_g7735_i0	PRJNA1164198	7997	442	1.460705	6.4563161	Cyclotella	29203	SAR_Eukaryotes	SAR_Eukaryotes	271	7.299999999999999e-89	NR	AAX09600.1	29204	g7735	i0	87.7	1.98190045248869	146	18	99.1	0	3	440	174	319	AAX09600.1 elongation factor 1 alpha, partial [Cyclotella cryptica]	diamond	876	272	0.996323529411765	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
27281072	27281072	PRJNA1164198_P_NODE_12443_length_352_cov_1.340502_g12175_i0	PRJNA1164198	12443	352	1.340502	4.71856704	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	48.9	8.28e-4	NR	OEU15519.1	635003	g12175	i0	32.9	2.44602272727273	73	43	61.4	2	11	226	89	156	OEU15519.1 eIF-5_eIF-2B-domain-containing protein [Fragilariopsis cylindrus CCMP1102]	diamond	861	49.3	0.991886409736308	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
27767250	27767250	PRJNA1164198_P_NODE_31344_length_236_cov_2.263804_g31075_i0	PRJNA1164198	31344	236	2.263804	5.34257744	Discostella pseudostelligera	259834	SAR_Eukaryotes	SAR_Eukaryotes	120	2.1e-29	NR	KAL3771149.1	259834	g31075	i0	65.8	1.93220338983051	76	26	96.6	0	3	230	2170	2245	KAL3771149.1 hypothetical protein ACHAWU_004772 [Discostella pseudostelligera]	diamond	456	120	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera
28208881	28208881	PRJNA1164198_P_NODE_27426_length_247_cov_3.252874_g27157_i0	PRJNA1164198	27426	247	3.252874	8.03459878	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	132	3.56e-35	NR	CAJ1937478.1	2856	g27157	i0	77.8	1.97975708502024	81	18	98.4	0	244	2	249	329	CAJ1937478.1 unnamed protein product [Cylindrotheca closterium]	diamond	489	132	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
30134900	30134900	PRJNA1164198_P_NODE_16232_length_307_cov_1.504274_g15963_i0	PRJNA1164198	16232	307	1.5042739999999999	4.61812118	Pseudo-nitzschia multistriata	183589	SAR_Eukaryotes	SAR_Eukaryotes	157	4.969999999999999e-42	NR	VEU42420.1	183589	g15963	i0	71	3.85016286644951	100	29	97.7	0	300	1	649	748	VEU42420.1 unnamed protein product [Pseudo-nitzschia multistriata]	diamond	1182	157	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia multistriata
31513681	31513681	PRJNA1164198_P_NODE_17936_length_292_cov_1.283105_g17667_i0	PRJNA1164198	17936	292	1.283105	3.7466666	root	1	Root_unresolved	Root_unresolved	103	2.1099999999999998e-23	NR	KAL3760403.1	259834	g17667	i0	60	1.96232876712329	95	33	97.6	2	2	286	556	645	KAL3760403.1 hypothetical protein ACHAWU_005938 [Discostella pseudostelligera]	diamond	573	103	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera
32285384	32285384	PRJNA1164198_P_NODE_18739_length_286_cov_1.830986_g18470_i0	PRJNA1164198	18739	286	1.830986	5.23661996	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	154	9.57e-44	NR	CAJ1937478.1	2856	g18470	i0	81.5	0.965034965034965	92	17	96.5	0	3	278	151	242	CAJ1937478.1 unnamed protein product [Cylindrotheca closterium]	diamond	276	154	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium

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