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

7 rows where analysis = "diamond", bioproject = "PRJEB50765" 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
18842924	18842924	PRJEB50765_P_NODE_895_length_350_cov_1.469649_g871_i0	PRJEB50765	895	350	1.469649	5.1437715	Vulpes vulpes	9627	Chordata	Chordata	151	2.34e-41	NR	XP_025846352.1	9627	g871	i0	63.1	79.8514285714286	111	41	95.1	0	348	16	161	271	XP_025846352.1 40S ribosomal protein S2-like [Vulpes vulpes]	diamond	27948	152	0.993421052631579	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Vulpes	Vulpes vulpes
26646695	26646695	PRJEB50765_P_NODE_1841_length_215_cov_1.612360_g1817_i0	PRJEB50765	1841	215	1.61236	3.466574	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.4	4.88e-5	NR	KAL1771500.1	42415	g1817	i0	39.3	1.6046511627907	61	37	85.1	0	3	185	297	357	KAL1771500.1 prosaposin isoform X1 [Sigmodon hispidus]	diamond	345	50.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Sigmodon	Sigmodon hispidus
26907021	26907021	PRJEB50765_P_NODE_3082_length_157_cov_0.866667_g3058_i0	PRJEB50765	3082	157	0.866667	1.36066719	Bufotes viridis	30338	Chordata	Chordata	44.7	0.00245	NR	CAK8609802.1	30338	g3058	i0	60.6	0.630573248407643	33	13	63.1	0	99	1	1	33	CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis]	diamond	99	44.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
28384834	28384834	PRJEB50765_P_NODE_1466_length_250_cov_3.258216_g1442_i0	PRJEB50765	1466	250	3.258216	8.14554	root	1	Root_unresolved	Root_unresolved	86.7	1.94e-19	NR	XP_058160539.1	9361	g1442	i0	61	29.58	77	26	90	2	226	2	1	75	XP_058160539.1 large ribosomal subunit protein eL22 isoform X1 [Dasypus novemcinctus]	diamond	7395	87.4	0.991990846681922	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Cingulata	Dasypodidae	Dasypus	Dasypus novemcinctus
28707451	28707451	PRJEB50765_P_NODE_2667_length_171_cov_1.141791_g2643_i0	PRJEB50765	2667	171	1.141791	1.95246261	Upupa epops	57439	Chordata	Chordata	87.8	1.91e-18	NR	NWU99474.1	57439	g2643	i0	64.9	6.98245614035088	57	20	100	0	1	171	266	322	NWU99474.1 PLB1 Phospholipase [Upupa epops]	diamond	1194	87.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Bucerotiformes	Upupidae	Upupa	Upupa epops
30823434	30823434	PRJEB50765_P_NODE_894_length_350_cov_1.718850_g870_i0	PRJEB50765	894	350	1.71885	6.015975	Styela clava	7725	Chordata	Chordata	75.1	3.6e-13	NR	XP_039263546.1	7725	g870	i0	39.6	0.865714285714286	101	60	86.6	1	304	2	7	106	XP_039263546.1 cathepsin B-like [Styela clava]	diamond	303	75.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
32720391	32720391	PRJEB50765_P_NODE_2480_length_179_cov_1.183099_g2456_i0	PRJEB50765	2480	179	1.183099	2.11774721	Mus musculus	10090	Chordata	Chordata	65.9	5.27e-12	NR	BAE38238.1	10090	g2456	i0	74.1	0.905027932960894	54	11	85.5	3	26	178	32	85	BAE38238.1 unnamed protein product [Mus musculus]	diamond	162	65.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus

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