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

9 rows where analysis = "diamond", bioproject = "PRJEB673" 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
9062218	9062218	PRJEB673_P_NODE_5688_length_371_cov_1.633929_g5339_i0	PRJEB673	5688	371	1.633929	6.06187659	Lutra lutra	9657	Chordata	Chordata	99.8	8.81e-22	NR	XP_047569650.1	9657	g5339	i0	51.4	2.54716981132075	105	44	81.7	3	367	65	221	322	XP_047569650.1 60S ribosomal protein L3-like isoform X4 [Lutra lutra]	diamond	945	99.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Lutra	Lutra lutra
24360697	24360697	PRJEB673_P_NODE_2260_length_648_cov_1.761827_g1983_i0	PRJEB673	2260	648	1.761827	11.41663896	Opisthokonta	33154	Chordata	Chordata	217	5.3399999999999985e-68	NR	AAN73380.1	7740	g1983	i0	67.4	25.6296296296296	184	51	81.9	2	3	533	12	193	AAN73380.1 ribosomal protein L19, partial [Branchiostoma lanceolatum]	diamond	16608	218	0.995412844036697	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum
26907550	26907550	PRJEB673_P_NODE_9062_length_215_cov_1.227778_g8713_i0	PRJEB673	9062	215	1.227778	2.6397227	Ovis aries	9940	Chordata	Chordata	44.3	0.00524	NR	XDA90976.1	9940	g8713	i0	50	2.4	44	22	61.4	0	134	3	96	139	XDA90976.1 hypothetical protein R6Z07_020896 [Ovis aries]	diamond	516	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
27152891	27152891	PRJEB673_P_NODE_10242_length_178_cov_0.993007_g9893_i0	PRJEB673	10242	178	0.993007	1.76755246	Chordata	7711	Chordata	Chordata	99.8	2.85e-24	NR	CAG5113179.1	34765	g9893	i0	79.7	36.7078651685393	59	12	99.4	0	1	177	69	127	CAG5113179.1 Oidioi.mRNA.OKI2018_I69.chr2.g7311.t1.cds [Oikopleura dioica]	diamond	6534	100	0.998	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
28700841	28700841	PRJEB673_P_NODE_12827_length_151_cov_1.379310_g12478_i0	PRJEB673	12827	151	1.37931	2.0827581	root	1	Root_unresolved	Root_unresolved	50.1	2.77e-5	NR	XP_032814129.1	7757	g12478	i0	71.4	1.54966887417219	28	7	53.6	1	1	81	90	117	XP_032814129.1 CUB and zona pellucida-like domain-containing protein 1 [Petromyzon marinus]	diamond	234	50.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Petromyzon	Petromyzon marinus
29907918	29907918	PRJEB673_P_NODE_6191_length_352_cov_1.473186_g5842_i0	PRJEB673	6191	352	1.473186	5.18561472	Pteruthius melanotis	357074	Chordata	Chordata	42.7	0.032	NR	NXY03596.1	357074	g5842	i0	46.8	0.767045454545455	47	22	37.5	1	308	177	1	47	NXY03596.1 PLAC8 protein [Pteruthius melanotis]	diamond	270	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Timaliidae	Pteruthius	Pteruthius melanotis
30627103	30627103	PRJEB673_P_NODE_9933_length_184_cov_1.342282_g9584_i0	PRJEB673	9933	184	1.342282	2.46979888	Metazoa	33208	Chordata	Chordata	42	0.0326	NR	XP_061277822.1	9906	g9584	i0	33.9	4.04347826086957	62	37	96.2	2	180	4	46	106	XP_061277822.1 adhesion G protein-coupled receptor E2-like isoform X3 [Bos javanicus]	diamond	744	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
32145014	32145014	PRJEB673_P_NODE_11938_length_157_cov_1.639344_g11589_i0	PRJEB673	11938	157	1.639344	2.57377008	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	57.8	4.78e-8	NR	XP_045756899.1	9716	g11589	i0	61.4	39.9363057324841	44	17	84.1	0	136	5	29	72	XP_045756899.1 proteasome subunit alpha type-3 isoform X1 [Mirounga angustirostris]	diamond	6270	58.2	0.993127147766323	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Mirounga	Mirounga angustirostris
32808162	32808162	PRJEB673_P_NODE_11200_length_164_cov_0.930233_g10851_i0	PRJEB673	11200	164	0.930233	1.52558212	root	1	Root_unresolved	Root_unresolved	66.2	6.05e-11	NR	BAU16176.1	8330	g10851	i0	59.3	10.9207317073171	54	22	98.8	0	1	162	130	183	BAU16176.1 pepsinogen A1 [Cynops pyrrhogaster]	diamond	1791	66.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Cynops	Cynops pyrrhogaster

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