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

5 rows where bioproject = "PRJNA881257" and tax_clade = "Sar"

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
21260604	21260604	PRJNA881257_P_NODE_9357_length_220_cov_1.105263_g9112_i0	PRJNA881257	9357	220	1.105263	2.4315786	Tribonema minus	303371	SAR_Eukaryotes	SAR_Eukaryotes	101	1.9e-25	NR	KAG5183035.1	303371	g9112	i0	74	0.995454545454545	73	13	99.5	1	1	219	44	110	KAG5183035.1 histone-fold-containing protein, partial [Tribonema minus]	diamond	219	101	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema minus
22535324	22535324	PRJNA881257_P_NODE_7898_length_250_cov_1.034826_g7653_i0	PRJNA881257	7898	250	1.034826	2.587065	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	278	3.43e-70	NTclustered	gi\|325194423\|emb\|FR825253.1\|	890382	g7653	i0	86.719	99.084	256	26	100	6	1	250	400	653	Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758	blastn	24771	278	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
26991847	26991847	PRJNA881257_P_NODE_17602_length_163_cov_0.912281_g17357_i0	PRJNA881257	17602	163	0.912281	1.48701803	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	99.8	1.0300000000000001e-22	NR	KAL3781033.1	29204	g17357	i0	86.8	2.92638036809816	53	7	97.5	0	3	161	269	321	KAL3781033.1 hypothetical protein HJC23_007929 [Cyclotella cryptica]	diamond	477	99.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
28192085	28192085	PRJNA881257_P_NODE_16946_length_164_cov_0.904348_g16701_i0	PRJNA881257	16946	164	0.904348	1.48313072	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	98.6	2.74e-22	NR	KAL3784137.1	29204	g16701	i0	92	0.914634146341463	50	4	91.5	0	152	3	657	706	KAL3784137.1 hypothetical protein HJC23_005795 [Cyclotella cryptica]	diamond	150	98.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
29739178	29739178	PRJNA881257_P_NODE_17930_length_162_cov_0.920354_g17685_i0	PRJNA881257	17930	162	0.920354	1.49097348	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	46.2	7.38e-4	NR	KAL3803357.1	29204	g17685	i0	46.7	1.64814814814815	45	24	83.3	0	23	157	430	474	KAL3803357.1 hypothetical protein HJC23_009321 [Cyclotella cryptica]	diamond	267	46.2	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);;