metadata: contig_metadata: 4 rows where bioproject = "PRJNA401346", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA401346", 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
20815805	20815805	PRJNA401346_P_NODE_1417_length_401_cov_0.882353_g1396_i0	PRJNA401346	1417	401	0.882353	3.53823553	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	505	2.4499999999999995e-138	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g1396	i0	90.576	88.1795511221945	382	34	95	2	18	398	390	10	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	35360	505	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
26726861	26726861	PRJNA401346_P_NODE_3541_length_278_cov_0.884793_g3520_i0	PRJNA401346	3541	278	0.884793	2.45972454	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	96.3	8.52e-21	NR	XP_002183861.1	556484	g3520	i0	59.3	1.97482014388489	91	36	98.2	1	274	2	305	394	XP_002183861.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1]	diamond	549	96.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
27328418	27328418	PRJNA401346_P_NODE_3403_length_282_cov_1.447964_g3382_i0	PRJNA401346	3403	282	1.447964	4.08325848	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	108	2.05e-28	NR	EJK75259.1	159749	g3382	i0	64.6	0.872340425531915	82	28	86.2	1	282	40	30	111	EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica]	diamond	246	108	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
27408450	27408450	PRJNA401346_P_NODE_2943_length_299_cov_1.075630_g2922_i0	PRJNA401346	2943	299	1.07563	3.2161337	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00488	NR	KAI2501740.1	210448	g2922	i0	51.2	1.28428093645485	43	16	38.1	1	292	179	112	154	KAI2501740.1 Ribosomal L27e protein family [Fragilaria crotonensis]	diamond	384	45.1	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis

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