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

8 rows where analysis = "diamond", bioproject = "PRJNA309466" 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
26933622	26933622	PRJNA309466_P_NODE_9302_length_204_cov_98605.690323_g9245_i0	PRJNA309466	9302	204	98605.690323	201155.60825892	root	1	Root_unresolved	Root_unresolved	42	0.0431	NR	CAL5943243.1	7750	g9245	i0	95	1.17647058823529	20	1	29.4	0	159	100	276	295	CAL5943243.1 unnamed protein product [Lampetra planeri]	diamond	240	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra planeri
27281599	27281599	PRJNA309466_P_NODE_16963_length_165_cov_0.896552_g16906_i0	PRJNA309466	16963	165	0.896552	1.4793108	Cricetidae	337677	Chordata	Chordata	60.1	3.61e-10	NR	XP_007619693.1	10029	g16906	i0	66	3.63636363636364	50	17	90.9	0	159	10	29	78	XP_007619693.1 huntingtin-interacting protein K isoform X2 [Cricetulus griseus]	diamond	600	60.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
28621846	28621846	PRJNA309466_P_NODE_10587_length_195_cov_52946.842466_g10530_i0	PRJNA309466	10587	195	52946.842466	103246.3428087	Gekko subpalmatus	515999	Chordata	Chordata	42.7	0.0181	NR	YP_009992303.1	515999	g10530	i0	49.1	2.52307692307692	55	21	73.8	1	31	174	71	125	YP_009992303.1 cytochrome c oxidase subunit II [Gekko subpalmatus]	diamond	492	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Gekkonidae	Gekko	Gekko subpalmatus
30755384	30755384	PRJNA309466_P_NODE_9294_length_204_cov_277485.374194_g9237_i0	PRJNA309466	9294	204	277485.374194	566070.16335576	Chordata	7711	Chordata	Chordata	42.4	0.0315	NR	XP_069099310.1	8319	g9237	i0	95	3.52941176470588	20	1	29.4	0	102	43	289	308	XP_069099310.1 stress-induced-phosphoprotein 1 [Pleurodeles waltl]	diamond	720	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
30927515	30927515	PRJNA309466_P_NODE_13194_length_180_cov_1.473282_g13137_i0	PRJNA309466	13194	180	1.473282	2.6519076	Mus musculus	10090	Chordata	Chordata	73.2	2.36e-13	NR	AAH21868.1	10090	g13137	i0	88.4	1.43333333333333	43	5	71.7	0	178	50	317	359	AAH21868.1 LOC72520 protein, partial [Mus musculus]	diamond	258	73.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
31433041	31433041	PRJNA309466_P_NODE_12256_length_185_cov_1.389706_g12199_i0	PRJNA309466	12256	185	1.389706	2.5709561	Staurois parvus	386267	Chordata	Chordata	42	0.00921	NR	CAI9547784.1	386267	g12199	i0	62.1	0.47027027027027	29	11	47	0	75	161	50	78	CAI9547784.1 unnamed protein product, partial [Staurois parvus]	diamond	87	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
31608847	31608847	PRJNA309466_P_NODE_18576_length_159_cov_139825.909091_g18519_i0	PRJNA309466	18576	159	139825.909091	222323.19545469	root	1	Root_unresolved	Root_unresolved	43.1	0.00901	NR	CAL5943243.1	7750	g18519	i0	81.8	1.84905660377358	22	4	41.5	0	108	43	271	292	CAL5943243.1 unnamed protein product [Lampetra planeri]	diamond	294	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra planeri
32350722	32350722	PRJNA309466_P_NODE_17459_length_163_cov_7.947368_g17402_i0	PRJNA309466	17459	163	7.947368	12.95420984	Staurois parvus	386267	Chordata	Chordata	41.6	0.0095	NR	CAI9547784.1	386267	g17402	i0	42	0.920245398773006	50	29	92	0	12	161	23	72	CAI9547784.1 unnamed protein product, partial [Staurois parvus]	diamond	150	41.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus

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