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

7 rows where analysis = "diamond", bioproject = "PRJNA800053" 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
19923066	19923066	PRJNA800053_P_NODE_4376_length_430_cov_1.112045_g4213_i0	PRJNA800053	4376	430	1.112045	4.7817935	Latimeria chalumnae	7897	Chordata	Chordata	53.9	1.62e-5	NR	XP_014347982.1	7897	g4213	i0	55.9	1.26976744186047	34	15	23.7	0	184	285	67	100	XP_014347982.1 vitelline membrane outer layer protein 1 homolog [Latimeria chalumnae]	diamond	546	53.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
27527975	27527975	PRJNA800053_P_NODE_1723_length_633_cov_3.546429_g1570_i0	PRJNA800053	1723	633	3.546429	22.44889557	Branchiostoma floridae	7739	Chordata	Chordata	52.8	4.65e-4	NR	XP_035661289.1	7739	g1570	i0	42	0.824644549763033	174	69	71.1	7	625	176	3331	3496	XP_035661289.1 neuroblast differentiation-associated protein AHNAK-like [Branchiostoma floridae]	diamond	522	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma floridae
28633314	28633314	PRJNA800053_P_NODE_23607_length_241_cov_0.916667_g23443_i0	PRJNA800053	23607	241	0.916667	2.20916747	Ranitomeya imitator	111125	Chordata	Chordata	55.5	1.21e-6	NR	CAJ0945989.1	111125	g23443	i0	43.6	12.5850622406639	55	31	68.5	0	198	34	617	671	CAJ0945989.1 unnamed protein product, partial [Ranitomeya imitator]	diamond	3033	55.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
29327658	29327658	PRJNA800053_P_NODE_5169_length_400_cov_1.541284_g5006_i0	PRJNA800053	5169	400	1.541284	6.165136	Erpetoichthys calabaricus	27687	Chordata	Chordata	131	3.0599999999999993e-34	NR	XP_051791274.1	27687	g5006	i0	76.7	6.135	90	20	66.8	1	23	289	115	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2454	131	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
30527939	30527939	PRJNA800053_P_NODE_22393_length_243_cov_0.905882_g22229_i0	PRJNA800053	22393	243	0.905882	2.20129326	Gavia stellata	37040	Chordata	Chordata	51.6	9.89e-7	NR	KFV54441.1	37040	g22229	i0	47.9	0.592592592592593	48	25	59.3	0	21	164	1	48	KFV54441.1 Zinc finger protein 316, partial [Gavia stellata]	diamond	144	51.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Gaviiformes	Gaviidae	Gavia	Gavia stellata
31002033	31002033	PRJNA800053_P_NODE_20254_length_246_cov_5.826590_g20090_i0	PRJNA800053	20254	246	5.82659	14.3334114	Polypterus senegalus	55291	Chordata	Chordata	43.5	0.0177	NR	XP_039600437.1	55291	g20090	i0	70.4	0.329268292682927	27	8	32.9	0	158	238	18	44	XP_039600437.1 protein FAM3B-like isoform X2 [Polypterus senegalus]	diamond	81	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
32835189	32835189	PRJNA800053_P_NODE_20860_length_245_cov_2.581395_g20696_i0	PRJNA800053	20860	245	2.581395	6.32441775	Clavelina lepadiformis	159417	Chordata	Chordata	77.8	5.82e-16	NR	CAK8683321.1	159417	g20696	i0	58.5	0.795918367346939	65	27	79.6	0	243	49	64	128	CAK8683321.1 unnamed protein product [Clavelina lepadiformis]	diamond	195	77.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Aplousobranchia	Clavelinidae	Clavelina	Clavelina lepadiformis

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