metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1031674" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1031674" 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
26591654	26591654	PRJNA1031674_P_NODE_12121_length_286_cov_1.873239_g11910_i0	PRJNA1031674	12121	286	1.873239	5.35746354	Myxine glutinosa	7769	Chordata	Chordata	57.4	4.28e-7	NR	XP_067954193.1	7769	g11910	i0	59.6	2.67482517482518	47	19	49.3	0	286	146	97	143	XP_067954193.1 F-box/LRR-repeat protein 14-like [Myxine glutinosa]	diamond	765	57.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
27003280	27003280	PRJNA1031674_P_NODE_16422_length_272_cov_1.859296_g16211_i0	PRJNA1031674	16422	272	1.859296	5.05728512	Nyctereutes procyonoides	34880	Chordata	Chordata	57	4.62e-7	NR	CAD7676231.1	34880	g16211	i0	74.3	0.386029411764706	35	9	38.6	0	80	184	109	143	CAD7676231.1 unnamed protein product [Nyctereutes procyonoides]	diamond	105	57	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Nyctereutes	Nyctereutes procyonoides
27856354	27856354	PRJNA1031674_P_NODE_3405_length_431_cov_4.614525_g3195_i0	PRJNA1031674	3405	431	4.614525	19.88860275	Sus scrofa	9823	Chordata	Chordata	288	5.49e-93	NR	XP_020938199.1	9823	g3195	i0	100	1.9907192575406	143	0	99.5	0	2	430	130	272	XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa]	diamond	858	288	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
28227088	28227088	PRJNA1031674_P_NODE_19686_length_260_cov_1.620321_g19475_i0	PRJNA1031674	19686	260	1.620321	4.2128346	Chordata	7711	Chordata	Chordata	98.2	7.61e-22	NR	KAJ1132056.1	8319	g19475	i0	61.6	34.7307692307692	86	33	99.2	0	1	258	112	197	KAJ1132056.1 hypothetical protein NDU88_010386 [Pleurodeles waltl]	diamond	9030	98.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
29403568	29403568	PRJNA1031674_P_NODE_14109_length_280_cov_1.478261_g13898_i0	PRJNA1031674	14109	280	1.478261	4.1391308	Bufotes viridis	30338	Chordata	Chordata	43.5	0.021	NR	CAK8621390.1	30338	g13898	i0	44.8	0.621428571428571	58	23	52.5	2	20	166	56	113	CAK8621390.1 DEP domain-containing protein 4 [Bufotes viridis]	diamond	174	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
29932601	29932601	PRJNA1031674_P_NODE_11531_length_288_cov_1.432558_g11320_i0	PRJNA1031674	11531	288	1.432558	4.12576704	Gymnophiona	8445	Chordata	Chordata	43.9	0.0253	NR	XP_033775004.1	260995	g11320	i0	64.3	0.875	28	10	29.2	0	288	205	547	574	XP_033775004.1 signal recognition particle receptor subunit alpha isoform X2 [Geotrypetes seraphini]	diamond	252	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Dermophiidae	Geotrypetes	Geotrypetes seraphini
30667014	30667014	PRJNA1031674_P_NODE_18873_length_263_cov_1.621053_g18662_i0	PRJNA1031674	18873	263	1.621053	4.26336939	Sus scrofa	9823	Chordata	Chordata	174	4.89e-50	NR	XP_020938199.1	9823	g18662	i0	100	2.97718631178707	87	0	99.2	0	261	1	344	430	XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa]	diamond	783	174	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
32374780	32374780	PRJNA1031674_P_NODE_24959_length_246_cov_0.890173_g24748_i0	PRJNA1031674	24959	246	0.890173	2.18982558	Polypterus senegalus	55291	Chordata	Chordata	71.6	6.09e-13	NR	XP_039599867.1	55291	g24748	i0	66.7	9.45121951219512	48	16	58.5	0	3	146	139	186	XP_039599867.1 thioredoxin domain-containing protein 9 [Polypterus senegalus]	diamond	2325	72	0.994444444444444	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus

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