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

7 rows where analysis = "diamond", bioproject = "PRJNA1188114" 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
28418051	28418051	PRJNA1188114_P_NODE_6126_length_191_cov_1.436620_g6074_i0	PRJNA1188114	6126	191	1.43662	2.7439442	root	1	Root_unresolved	Root_unresolved	133	1.13e-35	NR	XP_036010302.1	10090	g6074	i0	100	13.8534031413613	63	0	99	0	190	2	48	110	XP_036010302.1 uncharacterized protein Gm53410 [Mus musculus]	diamond	2646	133	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
30976182	30976182	PRJNA1188114_P_NODE_7474_length_185_cov_3.000000_g7422_i0	PRJNA1188114	7474	185	3	5.55	root	1	Root_unresolved	Root_unresolved	113	2.7200000000000004e-27	NR	XP_060232834.1	10047	g7422	i0	95.1	29.6756756756757	61	3	98.9	0	2	184	687	747	XP_060232834.1 LOW QUALITY PROTEIN: uncharacterized protein LOC132651899 [Meriones unguiculatus]	diamond	5490	114	0.991228070175439	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Meriones	Meriones unguiculatus
31368159	31368159	PRJNA1188114_P_NODE_1976_length_304_cov_1.400000_g1924_i0	PRJNA1188114	1976	304	1.4	4.256	Gracilinanus agilis	191870	Chordata	Chordata	97.4	2.4299999999999994e-24	NR	XP_044523559.1	191870	g1924	i0	75.8	1.91447368421053	62	15	61.2	0	47	232	1	62	XP_044523559.1 stress-associated endoplasmic reticulum protein 1 isoform X2 [Gracilinanus agilis]	diamond	582	97.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Didelphimorphia	Didelphidae	Gracilinanus	Gracilinanus agilis
31861289	31861289	PRJNA1188114_P_NODE_8337_length_182_cov_1.533835_g8285_i0	PRJNA1188114	8337	182	1.533835	2.7915797	Metazoa	33208	Chordata	Chordata	68.2	1.73e-11	NR	OCT71291.1	8355	g8285	i0	51.8	3.70879120879121	56	27	92.3	0	170	3	1	56	OCT71291.1 hypothetical protein XELAEV_18034269mg [Xenopus laevis]	diamond	675	68.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
32431059	32431059	PRJNA1188114_P_NODE_9179_length_178_cov_2.364341_g9127_i0	PRJNA1188114	9179	178	2.364341	4.20852698	root	1	Root_unresolved	Root_unresolved	120	5.9899999999999995e-30	NR	XP_030110853.2	10090	g9127	i0	98.3	13.8876404494382	59	1	99.4	0	1	177	109	167	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	2472	121	0.991735537190083	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
32601620	32601620	PRJNA1188114_P_NODE_9080_length_179_cov_1.338462_g9028_i0	PRJNA1188114	9080	179	1.338462	2.39584698	Gekko japonicus	146911	Chordata	Chordata	81.6	1.46e-17	NR	XP_015261348.1	146911	g9028	i0	70.7	2.93296089385475	58	17	97.2	0	1	174	112	169	XP_015261348.1 PREDICTED: ribonuclease UK114 isoform X2 [Gekko japonicus]	diamond	525	81.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Gekkonidae	Gekko	Gekko japonicus
32620511	32620511	PRJNA1188114_P_NODE_4980_length_205_cov_1.307692_g4928_i0	PRJNA1188114	4980	205	1.307692	2.6807686	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	69.3	2.01e-13	NR	CAH1229496.1	7740	g4928	i0	60.3	2.54634146341463	63	24	90.7	1	199	14	1	63	CAH1229496.1 PFN4 [Branchiostoma lanceolatum]	diamond	522	69.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum

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