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

5 rows where bioproject = "PRJEB75017", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"

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_order	tax_family	tax_genus	tax_species
5237895	5237895	PRJEB75017_P_NODE_15665_length_248_cov_2.754286_g15536_i0	PRJEB75017	15665	248	2.754286	6.83062928	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	137	5.89e-38	NR	TEB14745.1	2494336	g15536	i0	78	4.95967741935484	82	18	99.2	0	248	3	154	235	TEB14745.1 ribosomal protein L2 [Perkinsus sp. BL_2016]	diamond	1230	137	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
27318738	27318738	PRJEB75017_P_NODE_10803_length_281_cov_1.307692_g10674_i0	PRJEB75017	10803	281	1.307692	3.67461452	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	69.7	1.89e-11	NR	KAF4742393.1	32597	g10674	i0	42.5	5.97864768683274	80	44	83.3	1	16	249	246	325	KAF4742393.1 U5 small nuclear ribonucleoprotein, partial [Perkinsus olseni]	diamond	1680	69.7	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29529010	29529010	PRJEB75017_P_NODE_9550_length_294_cov_1.018100_g9421_i0	PRJEB75017	9550	294	1.0181	2.993214	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.00418	NR	KAF4721390.1	32597	g9421	i0	61.3	0.63265306122449	31	12	31.6	0	6	98	163	193	KAF4721390.1 hypothetical protein FOZ63_016457, partial [Perkinsus olseni]	diamond	186	46.2	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
31164065	31164065	PRJEB75017_P_NODE_9655_length_292_cov_1.872146_g9526_i0	PRJEB75017	9655	292	1.872146	5.46666632	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	67.8	3.4e-11	NR	XP_002778404.1	423536	g9526	i0	72.3	3.40068493150685	47	13	48.3	0	291	151	176	222	XP_002778404.1 ribosomal protein L3, putative [Perkinsus marinus ATCC 50983]	diamond	993	68.2	0.994134897360704	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
31607157	31607157	PRJEB75017_P_NODE_11436_length_275_cov_1.158416_g11307_i0	PRJEB75017	11436	275	1.158416	3.185644	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	114	5.37e-29	NR	KAF4756788.1	32597	g11307	i0	65.9	10.9090909090909	91	28	99.3	2	1	273	45	132	KAF4756788.1 hypothetical protein FOZ63_001655, partial [Perkinsus olseni]	diamond	3000	114	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni

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