metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA289590" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA289590" 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
26807018	26807018	PRJNA289590_P_NODE_14721_length_235_cov_3.053763_g14497_i0	PRJNA289590	14721	235	3.053763	7.17634305	Mammalia	40674	Chordata	Chordata	98.6	4.279999999999999e-23	NR	XP_058990340.1	9666	g14497	i0	63.6	34.3914893617021	77	26	95.7	1	10	234	119	195	XP_058990340.1 large ribosomal subunit protein eL22-like [Mustela lutreola]	diamond	8082	99.4	0.991951710261569	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Mustela	Mustela lutreola
27611382	27611382	PRJNA289590_P_NODE_22144_length_188_cov_0.820144_g21920_i0	PRJNA289590	22144	188	0.820144	1.54187072	Bufotes viridis	30338	Chordata	Chordata	46.2	0.00106	NR	CAK8609802.1	30338	g21920	i0	55.9	1.6595744680851101	34	15	54.3	0	80	181	1	34	CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis]	diamond	312	46.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
28905575	28905575	PRJNA289590_P_NODE_22148_length_187_cov_7.166667_g21924_i0	PRJNA289590	22148	187	7.166667	13.40166729	Lonchura striata	40157	Chordata	Chordata	41.6	0.0473	NR	XP_031362561.1	40157	g21924	i0	44.2	0.689839572192513	43	24	69	0	163	35	78	120	XP_031362561.1 LOW QUALITY PROTEIN: lysine-specific demethylase hairless [Lonchura striata]	diamond	129	41.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Estrildidae	Lonchura	Lonchura striata
29000867	29000867	PRJNA289590_P_NODE_15308_length_231_cov_0.857143_g15084_i0	PRJNA289590	15308	231	0.857143	1.98000033	Staurois parvus	386267	Chordata	Chordata	60.1	4.84e-10	NR	CAI9620946.1	386267	g15084	i0	70.3	0.480519480519481	37	11	48.1	0	21	131	23	59	CAI9620946.1 unnamed protein product [Staurois parvus]	diamond	111	60.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
31022056	31022056	PRJNA289590_P_NODE_14735_length_235_cov_2.010753_g14511_i0	PRJNA289590	14735	235	2.010753	4.72526955	Zosterops borbonicus	364589	Chordata	Chordata	44.3	0.00425	NR	TRZ17703.1	364589	g14511	i0	34.4	0.778723404255319	61	37	74	1	211	38	32	92	TRZ17703.1 hypothetical protein HGM15179_009421 [Zosterops borbonicus]	diamond	183	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Zosteropidae	Zosterops	Zosterops borbonicus
31179662	31179662	PRJNA289590_P_NODE_12335_length_260_cov_2.194313_g12111_i0	PRJNA289590	12335	260	2.194313	5.7052138	Erpetoichthys calabaricus	27687	Chordata	Chordata	124	3.1599999999999997e-32	NR	XP_051791274.1	27687	g12111	i0	77.4	7.76538461538462	84	18	95.8	1	4	252	121	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2019	124	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);;