metadata: contig_metadata: 5 rows where bioproject = "PRJNA879067", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA879067", 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
11060156	11060156	PRJNA879067_P_NODE_95669_length_278_cov_1.297561_g92183_i0	PRJNA879067	95669	278	1.297561	3.60721958	Haslea ostrearia	67476	SAR_Eukaryotes	SAR_Eukaryotes	95.3	4.19e-15	NTclustered	gi\|2168682389\|gb\|MW561352.1\|	67476	g92183	i0	98.182	17.6798561151079	55	0	19	1	1	54	6427	6373	Haslea ostrearia strain SZCZP1883 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence	blastn	4915	95.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Haslea	Haslea ostrearia
14881909	14881909	PRJNA879067_P_NODE_111372_length_238_cov_4.824242_g107886_i0	PRJNA879067	111372	238	4.824242	11.48169596	Sundstroemia setigera	3005	SAR_Eukaryotes	SAR_Eukaryotes	191	4.34e-44	NTclustered	gi\|2172620428\|ref\|NC_059919.1\|	3005	g107886	i0	86.441	77.4075630252101	177	21	74	3	63	237	24963	24788	Rhizosolenia setigera isolate CNS00456 mitochondrion, complete genome	blastn	18423	191	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Rhizosoleniales	Rhizosoleniaceae	Sundstroemia	Sundstroemia setigera
27852914	27852914	PRJNA879067_P_NODE_33624_length_706_cov_3.584518_g30253_i0	PRJNA879067	33624	706	3.584518	25.30669708	Cylindrotheca	2852	SAR_Eukaryotes	SAR_Eukaryotes	115	1.95e-25	NR	CAJ1922819.1	2856	g30253	i0	36.7	1.84844192634561	218	96	90.9	6	701	60	15	194	CAJ1922819.1 unnamed protein product [Cylindrotheca closterium]	diamond	1305	115	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
28792016	28792016	PRJNA879067_P_NODE_54447_length_489_cov_4.127404_g50962_i0	PRJNA879067	54447	489	4.127404	20.18300556	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	164	2.5799999999999998e-43	NR	CAB9506320.1	568900	g50962	i0	93.2	0.539877300613497	88	6	54	0	2	265	1381	1468	CAB9506320.1 chelatase subunit ChlH, chloroplastic [Seminavis robusta]	diamond	264	164	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
32268434	32268434	PRJNA879067_P_NODE_89598_length_300_cov_1.647577_g86112_i0	PRJNA879067	89598	300	1.647577	4.942731	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	53.1	1.57e-5	NR	GKZ00394.1	2872254	g86112	i0	42.6	0.61	61	34	61	1	269	87	540	599	GKZ00394.1 hypothetical protein MPSEU_000992400 [Mayamaea pseudoterrestris]	diamond	183	53.1	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);;