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

7 rows where analysis = "diamond", bioproject = "PRJNA1245487" 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
4178258	4178258	PRJNA1245487_P_NODE_13324_length_315_cov_1.933884_g12986_i0	PRJNA1245487	13324	315	1.933884	6.0917346	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	64.7	7.45e-10	NR	XP_019641702.1	7741	g12986	i0	43.3	3.67619047619048	97	54	92.4	1	299	9	6	101	XP_019641702.1 PREDICTED: 60S ribosomal protein L7-like [Branchiostoma belcheri]	diamond	1158	65.1	0.993855606758833	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
27610766	27610766	PRJNA1245487_P_NODE_23344_length_210_cov_30.408759_g23006_i0	PRJNA1245487	23344	210	30.408759	63.8583939	Pleurodeles waltl	8319	Chordata	Chordata	53.5	2.42e-6	NR	KAJ1185330.1	8319	g23006	i0	52.7	0.785714285714286	55	21	71.4	1	152	3	44	98	KAJ1185330.1 hypothetical protein NDU88_002123 [Pleurodeles waltl]	diamond	165	53.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
28021300	28021300	PRJNA1245487_P_NODE_21245_length_245_cov_0.906977_g20907_i0	PRJNA1245487	21245	245	0.906977	2.22209365	Staurois parvus	386267	Chordata	Chordata	68.2	1.13e-12	NR	CAI9618505.1	386267	g20907	i0	62.2	1.10204081632653	45	17	55.1	0	211	77	7	51	CAI9618505.1 unnamed protein product, partial [Staurois parvus]	diamond	270	68.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
28260059	28260059	PRJNA1245487_P_NODE_13466_length_313_cov_1.583333_g13128_i0	PRJNA1245487	13466	313	1.583333	4.95583229	Metazoa	33208	Chordata	Chordata	159	4.09e-46	NR	XP_039261694.1	7725	g13128	i0	76.7	51.3354632587859	103	24	98.7	0	3	311	49	151	XP_039261694.1 40S ribosomal protein S2 [Styela clava]	diamond	16068	159	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
28273597	28273597	PRJNA1245487_P_NODE_20406_length_248_cov_0.891429_g20068_i0	PRJNA1245487	20406	248	0.891429	2.21074392	Bufotes viridis	30338	Chordata	Chordata	48.5	3.46e-4	NR	CAK8629749.1	30338	g20068	i0	67.9	0.338709677419355	28	9	33.9	0	114	197	337	364	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	84	48.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
30199726	30199726	PRJNA1245487_P_NODE_21012_length_246_cov_0.872832_g20674_i0	PRJNA1245487	21012	246	0.872832	2.14716672	Oikopleura dioica	34765	Chordata	Chordata	91.3	2.92e-19	NR	CAG5106530.1	34765	g20674	i0	56.3	1.96341463414634	80	33	97.6	1	5	244	364	441	CAG5106530.1 Oidioi.mRNA.OKI2018_I69.chr1.g2885.t1.cds [Oikopleura dioica]	diamond	483	91.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
30800133	30800133	PRJNA1245487_P_NODE_21474_length_244_cov_0.912281_g21136_i0	PRJNA1245487	21474	244	0.912281	2.22596564	Engystomops pustulosus	76066	Chordata	Chordata	76.3	6.1e-14	NR	KAG8571490.1	76066	g21136	i0	60	2.68032786885246	55	22	67.6	0	32	196	976	1030	KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus]	diamond	654	76.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus

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