metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA855894" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA855894" 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
26746352	26746352	PRJNA855894_P_NODE_32821_length_245_cov_0.895349_g32699_i0	PRJNA855894	32821	245	0.895349	2.19360505	Phasianidae	9005	Chordata	Chordata	107	5.22e-25	NR	XP_042665123.1	9002	g32699	i0	59.8	2.00816326530612	82	32	99.2	1	1	243	26	107	XP_042665123.1 intercellular adhesion molecule 5-like, partial [Centrocercus urophasianus]	diamond	492	107	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Centrocercus	Centrocercus urophasianus
26897020	26897020	PRJNA855894_P_NODE_31861_length_247_cov_0.885057_g31739_i0	PRJNA855894	31861	247	0.885057	2.18609079	Polypterus senegalus	55291	Chordata	Chordata	154	8.929999999999999e-45	NR	KAG2468629.1	55291	g31739	i0	97.6	44.8178137651822	82	2	99.6	0	247	2	161	242	KAG2468629.1 RS7 protein, partial [Polypterus senegalus]	diamond	11070	155	0.993548387096774	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
27568674	27568674	PRJNA855894_P_NODE_24684_length_291_cov_1.059633_g24562_i0	PRJNA855894	24684	291	1.059633	3.08353203	Chordata	7711	Chordata	Chordata	155	6.39e-44	NR	ADZ28615.1	7830	g24562	i0	80.6	268.432989690722	93	18	95.9	0	291	13	192	284	ADZ28615.1 cytochrome c oxidase subunit I, partial [Scyliorhinus canicula]	diamond	78114	155	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Carcharhiniformes	Scyliorhinidae	Scyliorhinus	Scyliorhinus canicula
28097302	28097302	PRJNA855894_P_NODE_30065_length_250_cov_0.870056_g29943_i0	PRJNA855894	30065	250	0.870056	2.17514	Catharus ustulatus	91951	Chordata	Chordata	63.2	2.42e-9	NR	XP_032909308.1	91951	g29943	i0	68.4	0.792	38	12	45.6	0	3	116	304	341	XP_032909308.1 nucleoside diphosphate kinase 7 isoform X2 [Catharus ustulatus]	diamond	198	63.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Turdidae	Catharus	Catharus ustulatus
29242218	29242218	PRJNA855894_P_NODE_31809_length_247_cov_0.885057_g31687_i0	PRJNA855894	31809	247	0.885057	2.18609079	Squamata	8509	Chordata	Chordata	43.1	0.025	NR	XP_042313871.1	8520	g31687	i0	28.6	1.80971659919028	84	51	96	3	7	243	118	197	XP_042313871.1 cysteine-rich venom protein piscivorin-like [Sceloporus undulatus]	diamond	447	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Phrynosomatidae	Sceloporus	Sceloporus undulatus

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