metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1020641" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1020641" and tax_phylum = "Chordata"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27856111	27856111	PRJNA1020641_P_NODE_3625_length_321_cov_1.354839_g3582_i0	PRJNA1020641	3625	321	1.354839	4.34903319	Ranitomeya imitator	111125	Chordata	Chordata	62	1.59e-8	NR	CAJ0933392.1	111125	g3582	i0	62.5	0.448598130841121	48	16	43	1	142	5	53	100	CAJ0933392.1 unnamed protein product [Ranitomeya imitator]	diamond	144	62	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
29964001	29964001	PRJNA1020641_P_NODE_2691_length_373_cov_1.173333_g2648_i0	PRJNA1020641	2691	373	1.173333	4.37653209	Chordata	7711	Chordata	Chordata	115	5.7600000000000005e-27	NR	OCT97315.1	8355	g2648	i0	50.4	64.7372654155496	115	50	91.7	2	372	31	2524	2632	OCT97315.1 hypothetical protein XELAEV_18009541mg [Xenopus laevis]	diamond	24147	116	0.991379310344828	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
30571779	30571779	PRJNA1020641_P_NODE_1653_length_474_cov_1.129676_g1610_i0	PRJNA1020641	1653	474	1.129676	5.35466424	Leucoraja erinaceus	7782	Chordata	Chordata	47.8	0.00515	NR	XP_055487001.1	7782	g1610	i0	48.5	1.4746835443038	66	30	40.5	3	51	242	152	215	XP_055487001.1 E3 ubiquitin-protein ligase TRIM47-like isoform X1 [Leucoraja erinaceus]	diamond	699	47.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Leucoraja	Leucoraja erinaceus
31638821	31638821	PRJNA1020641_P_NODE_4136_length_299_cov_0.876106_g4093_i0	PRJNA1020641	4136	299	0.876106	2.61955694	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	108	4.01e-25	NR	CAG5091339.1	34765	g4093	i0	54.5	13.0234113712375	99	43	97.3	1	1	291	29	127	CAG5091339.1 Oidioi.mRNA.OKI2018_I69.PAR.g12983.t2.cds [Oikopleura dioica]	diamond	3894	109	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
32279690	32279690	PRJNA1020641_P_NODE_6919_length_244_cov_0.900585_g6876_i0	PRJNA1020641	6919	244	0.900585	2.1974274	Miniopterus natalensis	291302	Chordata	Chordata	73.9	3.55e-13	NR	XP_016074710.1	291302	g6876	i0	48	0.922131147540984	75	39	92.2	0	15	239	88	162	XP_016074710.1 PREDICTED: actin-related protein T2 [Miniopterus natalensis]	diamond	225	73.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Miniopteridae	Miniopterus	Miniopterus natalensis
32374550	32374550	PRJNA1020641_P_NODE_6459_length_246_cov_0.890173_g6416_i0	PRJNA1020641	6459	246	0.890173	2.18982558	Rousettus aegyptiacus	9407	Chordata	Chordata	76.6	4.43e-14	NR	XP_036077575.1	9407	g6416	i0	47.9	2.48780487804878	73	34	89	1	230	12	65	133	XP_036077575.1 kinesin-like protein KIF18A isoform X2 [Rousettus aegyptiacus]	diamond	612	76.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Pteropodidae	Rousettus	Rousettus aegyptiacus
32690083	32690083	PRJNA1020641_P_NODE_5380_length_254_cov_1.309392_g5337_i0	PRJNA1020641	5380	254	1.309392	3.32585568	Ranitomeya imitator	111125	Chordata	Chordata	45.4	0.00433	NR	CAJ0956274.1	111125	g5337	i0	50	0.838582677165354	34	17	40.2	0	102	1	1	34	CAJ0956274.1 unnamed protein product [Ranitomeya imitator]	diamond	213	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator

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