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

5 rows where bioproject = "PRJNA1263632", 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
1054083	1054083	PRJNA1263632_P_NODE_4421_length_297_cov_1.522321_g4403_i0	PRJNA1263632	4421	297	1.522321	4.52129337	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	65.9	5.11e-10	NR	KAK1732416.1	267567	g4403	i0	64.7	1.82828282828283	51	14	51.5	1	296	144	483	529	KAK1732416.1 DnaJ domain-containing protein [Skeletonema marinoi]	diamond	543	65.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
9291820	9291820	PRJNA1263632_P_NODE_3068_length_350_cov_1.104693_g3050_i0	PRJNA1263632	3068	350	1.104693	3.8664255	Nitzschia traheaformis	1881117	SAR_Eukaryotes	SAR_Eukaryotes	75	7.06e-9	NTclustered	gi\|2073953246\|gb\|MW849269.1\|	1881117	g3050	i0	78.014	0.951428571428571	141	15	40	7	212	350	46645	46519	Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome	blastn	333	75	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia traheaformis
26947248	26947248	PRJNA1263632_P_NODE_7622_length_245_cov_0.895349_g7604_i0	PRJNA1263632	7622	245	0.895349	2.19360505	Cyclostephanos tholiformis	382380	SAR_Eukaryotes	SAR_Eukaryotes	99.8	3.4000000000000003e-22	NR	KAL3808242.1	382380	g7604	i0	51.9	3.96734693877551	81	39	99.2	0	244	2	64	144	KAL3808242.1 hypothetical protein ACHAXA_006518 [Cyclostephanos tholiformis]	diamond	972	99.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclostephanos	Cyclostephanos tholiformis
27629006	27629006	PRJNA1263632_P_NODE_6604_length_250_cov_0.870056_g6586_i0	PRJNA1263632	6604	250	0.870056	2.17514	Naviculaceae	67474	SAR_Eukaryotes	SAR_Eukaryotes	60.5	2.33e-8	NR	GAX15681.1	1519565	g6586	i0	50.9	1.38	57	28	68.4	0	79	249	492	548	GAX15681.1 hypothetical protein FisN_3Hh155 [Fistulifera solaris]	diamond	345	60.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
30471042	30471042	PRJNA1263632_P_NODE_6053_length_258_cov_0.832432_g6035_i0	PRJNA1263632	6053	258	0.832432	2.14767456	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	151	3.3299999999999993e-43	NR	CAJ1931814.1	2856	g6035	i0	80	9.87209302325581	85	17	98.8	0	257	3	51	135	CAJ1931814.1 unnamed protein product [Cylindrotheca closterium]	diamond	2547	152	0.993421052631579	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);;