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

9 rows where analysis = "diamond", bioproject = "PRJNA608660" 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
27048544	27048544	PRJNA608660_P_NODE_16082_length_362_cov_3.884984_g15728_i0	PRJNA608660	16082	362	3.884984	14.06364208	Erpetoichthys calabaricus	27687	Chordata	Chordata	135	8.61e-36	NR	XP_051791274.1	27687	g15728	i0	78.9	6.77900552486188	90	18	73.8	1	325	59	115	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2454	135	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
27333158	27333158	PRJNA608660_P_NODE_42163_length_180_cov_1.587786_g41806_i0	PRJNA608660	42163	180	1.587786	2.8580148	Staurois parvus	386267	Chordata	Chordata	66.6	1.95e-12	NR	CAI9547784.1	386267	g41806	i0	58.1	1.43333333333333	43	18	71.7	0	52	180	6	48	CAI9547784.1 unnamed protein product, partial [Staurois parvus]	diamond	258	66.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
27522404	27522404	PRJNA608660_P_NODE_27923_length_248_cov_2.351759_g27567_i0	PRJNA608660	27923	248	2.351759	5.83236232	Staurois parvus	386267	Chordata	Chordata	68.9	5.85e-13	NR	CAI9618505.1	386267	g27567	i0	53.2	0.568548387096774	47	22	56.9	0	15	155	5	51	CAI9618505.1 unnamed protein product, partial [Staurois parvus]	diamond	141	68.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
28482860	28482860	PRJNA608660_P_NODE_16146_length_361_cov_3.692308_g15792_i0	PRJNA608660	16146	361	3.692308	13.32923188	Diprotodontia	38609	Chordata	Chordata	45.4	0.0162	NR	XP_027707621.1	29139	g15792	i0	29.1	2.56786703601108	103	58	84.8	2	328	23	621	709	XP_027707621.1 E3 ubiquitin-protein ligase Arkadia isoform X4 [Vombatus ursinus]	diamond	927	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Diprotodontia	Vombatidae	Vombatus	Vombatus ursinus
28501361	28501361	PRJNA608660_P_NODE_23687_length_280_cov_2.701299_g23331_i0	PRJNA608660	23687	280	2.701299	7.5636372	Bufo gargarizans	30331	Chordata	Chordata	48.9	4.06e-4	NR	XP_044136063.1	30331	g23331	i0	57.1	0.45	42	15	45	1	169	44	20	58	XP_044136063.1 transmembrane channel-like protein 2-A [Bufo gargarizans]	diamond	126	48.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufo	Bufo gargarizans
28596149	28596149	PRJNA608660_P_NODE_38687_length_193_cov_1.798611_g38331_i0	PRJNA608660	38687	193	1.798611	3.47131923	Polypterus senegalus	55291	Chordata	Chordata	63.5	7.86e-10	NR	KAG2464487.1	55291	g38331	i0	55.6	2.90673575129534	63	28	97.9	0	192	4	189	251	KAG2464487.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	561	63.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
32514894	32514894	PRJNA608660_P_NODE_33319_length_217_cov_1.857143_g32963_i0	PRJNA608660	33319	217	1.857143	4.03000031	Polypterus senegalus	55291	Chordata	Chordata	62	3.81e-9	NR	KAG2456618.1	55291	g32963	i0	53.2	4.31336405529954	77	31	99.5	1	2	217	34	110	KAG2456618.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	936	62	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
32528006	32528006	PRJNA608660_P_NODE_16959_length_351_cov_3.238411_g16605_i0	PRJNA608660	16959	351	3.238411	11.36682261	Aves	8782	Chordata	Chordata	42	0.0334	NR	NWV24329.1	720586	g16605	i0	60.7	0.700854700854701	28	11	23.9	0	12	95	25	52	NWV24329.1 ZN467 protein [Origma solitaria]	diamond	246	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Acanthizidae	Origma	Origma solitaria
32861181	32861181	PRJNA608660_P_NODE_31120_length_229_cov_1.538889_g30764_i0	PRJNA608660	31120	229	1.538889	3.52405581	Eschrichtius robustus	9764	Chordata	Chordata	59.7	7.56e-9	NR	KAJ8794115.1	9764	g30764	i0	71.7	0.602620087336245	46	13	60.3	0	216	79	66	111	KAJ8794115.1 hypothetical protein J1605_019107 [Eschrichtius robustus]	diamond	138	59.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Eschrichtiidae	Eschrichtius	Eschrichtius robustus

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