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

5 rows where analysis = "diamond", bioproject = "PRJNA1103784" 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
212179	212179	PRJNA1103784_P_NODE_5741_length_251_cov_0.865169_g5686_i0	PRJNA1103784	5741	251	0.865169	2.17157419	Rhineura floridana	261503	Chordata	Chordata	97.8	4.019999999999999e-23	NR	XP_061444125.1	261503	g5686	i0	61.7	4.8406374501992	81	31	96.8	0	251	9	108	188	XP_061444125.1 ras-related protein Rab-2B isoform X1 [Rhineura floridana]	diamond	1215	97.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Rhineuridae	Rhineura	Rhineura floridana
26710482	26710482	PRJNA1103784_P_NODE_7781_length_241_cov_0.916667_g7726_i0	PRJNA1103784	7781	241	0.916667	2.20916747	Crocodylia	1294634	Chordata	Chordata	77.8	1.63e-14	NR	XP_059588629.1	8496	g7726	i0	55.9	5.3402489626556	68	29	84.6	1	35	238	402	468	XP_059588629.1 fatty-acid amide hydrolase 2 [Alligator mississippiensis]	diamond	1287	78.2	0.994884910485933	Eukaryota	Opisthokonta	Metazoa	Chordata		Crocodylia	Alligatoridae	Alligator	Alligator mississippiensis
26995455	26995455	PRJNA1103784_P_NODE_7382_length_243_cov_0.905882_g7327_i0	PRJNA1103784	7382	243	0.905882	2.20129326	Petromyzontidae	7746	Chordata	Chordata	64.3	9.61e-10	NR	XP_061419102.1	7753	g7327	i0	37	7	81	51	100	0	1	243	868	948	XP_061419102.1 LOW QUALITY PROTEIN: WD repeat-containing protein 3 [Lethenteron reissneri]	diamond	1701	64.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
29783338	29783338	PRJNA1103784_P_NODE_5731_length_251_cov_0.865169_g5676_i0	PRJNA1103784	5731	251	0.865169	2.17157419	Geococcyx californianus	8947	Chordata	Chordata	82	1.35e-17	NR	NWH68592.1	8947	g5676	i0	65.4	4.37450199203187	52	18	62.2	0	14	169	93	144	NWH68592.1 DUS12 phosphatase [Geococcyx californianus]	diamond	1098	82	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Cuculiformes	Neomorphidae	Geococcyx	Geococcyx californianus
31584845	31584845	PRJNA1103784_P_NODE_3156_length_308_cov_8.361702_g3101_i0	PRJNA1103784	3156	308	8.361702	25.75404216	Rangifer tarandus platyrhynchus	3082113	Chordata	Chordata	57	7.81e-7	NR	CAI9150999.1	3082113	g3101	i0	96.7	0.292207792207792	30	1	29.2	0	3	92	500	529	CAI9150999.1 unnamed protein product, partial [Rangifer tarandus platyrhynchus]	diamond	90	57	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Rangifer	Rangifer tarandus

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