metadata: contig_metadata: 7 rows where bioproject = "PRJNA795983" and tax

7 rows where bioproject = "PRJNA795983" 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
5883645	5883645	PRJNA795983_S_NODE_28245_length_273_cov_2.255000_g28120_i0	PRJNA795983	28245	273	2.255	6.15615	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	135	7.65e-39	NR	KAF4705388.1	32597	g28120	i0	65.9	109.725274725275	88	30	96.7	0	6	269	19	106	KAF4705388.1 Ras- protein Rab-1A, partial [Perkinsus olseni]	diamond	29955	135	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
22457483	22457483	PRJNA795983_S_NODE_8198_length_418_cov_0.840580_g8073_i0	PRJNA795983	8198	418	0.84058	3.5136244	Perkinsus chesapeaki	330153	SAR_Eukaryotes	SAR_Eukaryotes	225	6.0599999999999985e-68	NR	KAF4672166.1	330153	g8073	i0	77	14.8995215311005	139	31	99	1	3	416	219	357	KAF4672166.1 hypothetical protein FOL47_000817 [Perkinsus chesapeaki]	diamond	6228	225	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki
25443242	25443242	PRJNA795983_S_NODE_15520_length_334_cov_1.114943_g15395_i0	PRJNA795983	15520	334	1.114943	3.72390962	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	138	2.3899999999999997e-37	NR	KAF4741851.1	32597	g15395	i0	55.4	3.99700598802395	112	48	98.8	1	4	333	31	142	KAF4741851.1 hypothetical protein FOZ62_016568, partial [Perkinsus olseni]	diamond	1335	138	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
28547537	28547537	PRJNA795983_S_NODE_42607_length_241_cov_1.833333_g42482_i0	PRJNA795983	42607	241	1.833333	4.41833253	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	91.3	2.04e-20	NR	KAF4743652.1	32597	g42482	i0	54.5	4.81742738589212	77	35	95.9	0	235	5	118	194	KAF4743652.1 hypothetical protein FOZ63_029988, partial [Perkinsus olseni]	diamond	1161	92	0.992391304347826	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
29516803	29516803	PRJNA795983_S_NODE_30910_length_265_cov_1.203125_g30785_i0	PRJNA795983	30910	265	1.203125	3.18828125	Perkinsus sp. BL_2	28001	SAR_Eukaryotes	SAR_Eukaryotes	70.5	3.53e-12	NR	TEB19254.1	2494336	g30785	i0	62	0.566037735849057	50	19	56.6	0	4	153	214	263	TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016]	diamond	150	70.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus sp. BL_2016
32434429	32434429	PRJNA795983_S_NODE_37959_length_248_cov_0.880000_g37834_i0	PRJNA795983	37959	248	0.88	2.1824	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	55.5	1.03e-6	NR	KAF4685098.1	32597	g37834	i0	39.7	4.1491935483871	68	41	82.3	0	36	239	97	164	KAF4685098.1 hypothetical protein FOZ60_006868 [Perkinsus olseni]	diamond	1029	55.5	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
32560977	32560977	PRJNA795983_S_NODE_29339_length_270_cov_1.223350_g29214_i0	PRJNA795983	29339	270	1.22335	3.303045	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	146	3.14e-41	NR	KAF4684998.1	32597	g29214	i0	73	26.5777777777778	89	24	98.9	0	269	3	74	162	KAF4684998.1 Protein phosphatase PP2A regulatory subunit B, partial [Perkinsus olseni]	diamond	7176	146	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);;