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

5 rows where bioproject = "PRJNA672101", 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
5745285	5745285	PRJNA672101_S_NODE_16245_length_304_cov_3.463203_g16214_i0	PRJNA672101	16245	304	3.463203	10.52813712	Guinardia delicatula	1244696	SAR_Eukaryotes	SAR_Eukaryotes	145	4.54e-30	NTclustered	gi\|2074156200\|gb\|MW413905.1\|	216802	g16214	i0	79.439	43.4703947368421	214	36	69	6	77	285	24392	24602	Guinardia delicatula mitochondrion, complete genome	blastn	13215	145	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Rhizosoleniales	Rhizosoleniaceae	Guinardia	Guinardia delicatula
6269376	6269376	PRJNA672101_S_NODE_205_length_875_cov_6.735661_g188_i0	PRJNA672101	205	875	6.735661	58.93703375	Pseudo-nitzschia	41953	SAR_Eukaryotes	SAR_Eukaryotes	86.1	8.7e-12	NTclustered	gi\|2852238308\|gb\|PQ498360.1\|	189737	g188	i0	97.959	4.06514285714286	49	1	6	0	415	463	33790	33838	Pseudo-nitzschia galaxiae isolate CNS01103 mitochondrion, complete genome	blastn	3557	86.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia galaxiae
29323738	29323738	PRJNA672101_S_NODE_7429_length_373_cov_5.830000_g7398_i0	PRJNA672101	7429	373	5.83	21.7459	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.0174	NR	KAK1739094.1	267567	g7398	i0	30.8	0.522788203753351	65	44	52.3	1	261	67	525	588	KAK1739094.1 hypothetical protein QTG54_010410 [Skeletonema marinoi]	diamond	195	45.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
29449877	29449877	PRJNA672101_S_NODE_6670_length_382_cov_5.482201_g6639_i0	PRJNA672101	6670	382	5.482201	20.94200782	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	56.6	1.94e-6	NR	GKY93150.1	2872254	g6639	i0	52	0.392670157068063	50	21	36.9	2	207	67	224	273	GKY93150.1 hypothetical protein MPSEU_000283000 [Mayamaea pseudoterrestris]	diamond	150	56.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
31567332	31567332	PRJNA672101_S_NODE_22476_length_274_cov_2.512438_g22445_i0	PRJNA672101	22476	274	2.512438	6.88408012	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	62.8	4.92e-9	NR	KAL3791744.1	29204	g22445	i0	35.2	0.996350364963504	91	58	98.5	1	1	270	767	857	KAL3791744.1 hypothetical protein HJC23_007511 [Cyclotella cryptica]	diamond	273	62.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica

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