metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB80557" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB80557" 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
26622648	26622648	PRJEB80557_S_NODE_30061_length_176_cov_3.661417_g29665_i0	PRJEB80557	30061	176	3.661417	6.44409392	Pleurodeles waltl	8319	Chordata	Chordata	45.1	0.00199	NR	KAJ1185330.1	8319	g29665	i0	48.1	0.886363636363636	52	22	80.1	1	141	1	44	95	KAJ1185330.1 hypothetical protein NDU88_002123 [Pleurodeles waltl]	diamond	156	45.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
27761141	27761141	PRJEB80557_S_NODE_34224_length_167_cov_0.881356_g33828_i0	PRJEB80557	34224	167	0.881356	1.47186452	Prionailurus bengalensis	37029	Chordata	Chordata	50.1	3.43e-5	NR	XP_043415092.1	37029	g33828	i0	61	0.736526946107784	41	16	73.7	0	3	125	296	336	XP_043415092.1 leucine-rich colipase-like protein 1 [Prionailurus bengalensis]	diamond	123	50.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Prionailurus	Prionailurus bengalensis
28329082	28329082	PRJEB80557_S_NODE_8486_length_310_cov_2.126437_g8090_i0	PRJEB80557	8486	310	2.126437	6.5919547	Bufotes viridis	30338	Chordata	Chordata	61.6	1.31e-8	NR	CAK8641272.1	30338	g8090	i0	50.9	1.01612903225806	53	26	51.3	0	105	263	221	273	CAK8641272.1 Retrovirus-related Pol polyprotein from transposon RE1 [Bufotes viridis]	diamond	315	61.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
29497385	29497385	PRJEB80557_S_NODE_13590_length_252_cov_2.931034_g13194_i0	PRJEB80557	13590	252	2.931034	7.38620568	Polypterus senegalus	55291	Chordata	Chordata	43.5	0.00916	NR	KAG2471189.1	55291	g13194	i0	57.1	0.416666666666667	35	15	41.7	0	73	177	92	126	KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	105	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
29718148	29718148	PRJEB80557_S_NODE_20930_length_208_cov_1.301887_g20534_i0	PRJEB80557	20930	208	1.301887	2.70792496	Hypanus sabinus	79690	Chordata	Chordata	42	0.0435	NR	XP_059802757.1	79690	g20534	i0	44.9	0.706730769230769	49	20	70.7	2	162	16	40	81	XP_059802757.1 V-set and transmembrane domain-containing protein 4a isoform X3 [Hypanus sabinus]	diamond	147	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
30350747	30350747	PRJEB80557_S_NODE_20152_length_211_cov_4.709877_g19756_i0	PRJEB80557	20152	211	4.709877	9.93784047	Staurois parvus	386267	Chordata	Chordata	51.6	8.19e-7	NR	CAI9581818.1	386267	g19756	i0	75.9	0.412322274881517	29	7	41.2	0	100	186	29	57	CAI9581818.1 unnamed protein product, partial [Staurois parvus]	diamond	87	51.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
31329772	31329772	PRJEB80557_S_NODE_4616_length_396_cov_2.034582_g4220_i0	PRJEB80557	4616	396	2.034582	8.05694472	Leucoraja erinaceus	7782	Chordata	Chordata	199	1.38e-59	NR	XP_055489405.1	7782	g4220	i0	79.5	0.962121212121212	127	24	94.7	1	394	20	226	352	XP_055489405.1 uncharacterized protein LOC129696011 [Leucoraja erinaceus]	diamond	381	199	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Leucoraja	Leucoraja erinaceus
31994072	31994072	PRJEB80557_S_NODE_19678_length_214_cov_1.254545_g19282_i0	PRJEB80557	19678	214	1.254545	2.6847263	Ascaphus truei	8439	Chordata	Chordata	40	0.0376	NR	MEE6521273.1	8439	g19282	i0	37.5	0.560747663551402	40	25	56.1	0	28	147	10	49	MEE6521273.1 hypothetical protein [Ascaphus truei]	diamond	120	40	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ascaphidae	Ascaphus	Ascaphus truei
32657755	32657755	PRJEB80557_S_NODE_4040_length_416_cov_10.863760_g3644_i0	PRJEB80557	4040	416	10.86376	45.1932416	Erpetoichthys calabaricus	27687	Chordata	Chordata	133	6.689999999999999e-35	NR	XP_051791274.1	27687	g3644	i0	77.8	5.89903846153846	90	19	64.2	1	402	136	115	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2454	133	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus

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