metadata: contig_metadata: 5 rows where bioproject = "PRJNA597223" and tax

5 rows where bioproject = "PRJNA597223" 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
5673010	5673010	PRJNA597223_P_NODE_51805_length_193_cov_3.360759_g49959_i0	PRJNA597223	51805	193	3.360759	6.48626487	Nitzschia dissipatoides	3068544	SAR_Eukaryotes	SAR_Eukaryotes	263	7.059999999999999e-66	NTclustered	gi\|2721954655\|gb\|OR464351.1\|	3068544	g49959	i0	90.206	134.466321243523	194	15	100	2	1	193	91124	91314	Nitzschia dissipatoides plastid, complete genome	blastn	25952	263	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia dissipatoides
10069421	10069421	PRJNA597223_P_NODE_78168_length_160_cov_1.328000_g76322_i0	PRJNA597223	78168	160	1.328	2.1248	Chaetoceros	49237	SAR_Eukaryotes	SAR_Eukaryotes	84.2	4.71e-12	NTclustered	gi\|2862228897\|gb\|PQ645531.1\|	240364	g76322	i0	94.444	33.28125	54	3	34	0	1	54	2660	2713	Chaetoceros neogracilis isolate AGSB0402 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	5325	84.2	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros neogracilis
23521929	23521929	PRJNA597223_P_NODE_86139_length_151_cov_3.844828_g84293_i0	PRJNA597223	86139	151	3.844828	5.80569028	Chaetoceros curvisetus	230516	SAR_Eukaryotes	SAR_Eukaryotes	200	4.16e-47	NTclustered	gi\|2043890832\|gb\|MZ267687.1\|	230516	g84293	i0	91.724	96.4172185430464	145	10	96	1	7	151	2729	2587	Chaetoceros curvisetus isolate CNS00516 large subunit ribosomal RNA gene, partial sequence	blastn	14559	200	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros curvisetus
30553630	30553630	PRJNA597223_P_NODE_85953_length_152_cov_1.025641_g84107_i0	PRJNA597223	85953	152	1.025641	1.55897432	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	48.5	9.68e-5	NR	KAL3913291.1	3061772	g84107	i0	64.9	1.46052631578947	37	13	73	0	6	116	162	198	KAL3913291.1 MAG: hypothetical protein SGILL_006552, partial [Bacillariaceae sp.]	diamond	222	48.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
31944605	31944605	PRJNA597223_P_NODE_29637_length_278_cov_1.609053_g27791_i0	PRJNA597223	29637	278	1.609053	4.47316734	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	79.7	5.53e-15	NR	GKY97261.1	2872254	g27791	i0	66.1	0.636690647482014	59	20	63.7	0	276	100	412	470	GKY97261.1 hypothetical protein MPSEU_000684500 [Mayamaea pseudoterrestris]	diamond	177	79.7	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);;