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

7 rows where analysis = "diamond", bioproject = "PRJNA1074408" 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
27225295	27225295	PRJNA1074408_S_NODE_9823_length_151_cov_3.583333_g9693_i0	PRJNA1074408	9823	151	3.583333	5.41083283	Bos taurus	9913	Chordata	Chordata	89.4	1.76e-19	NR	XP_024835237.2	9913	g9693	i0	100	0.993377483443709	50	0	99.3	0	2	151	12	61	XP_024835237.2 translation initiation factor IF-2, partial [Bos taurus]	diamond	150	89.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
28827188	28827188	PRJNA1074408_S_NODE_4128_length_228_cov_1.556757_g3998_i0	PRJNA1074408	4128	228	1.556757	3.54940596	Metazoa	33208	Chordata	Chordata	49.3	3.62e-5	NR	XP_067961094.1	7769	g3998	i0	36.2	5.28947368421053	69	43	89.5	1	219	16	58	126	XP_067961094.1 ragulator complex protein LAMTOR2 [Myxine glutinosa]	diamond	1206	49.7	0.991951710261569	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
30730933	30730933	PRJNA1074408_S_NODE_4254_length_225_cov_1.054945_g4124_i0	PRJNA1074408	4254	225	1.054945	2.37362625	Myxine glutinosa	7769	Chordata	Chordata	56.2	5.49e-7	NR	XP_067992270.1	7769	g4124	i0	74.4	1.04	39	10	52	0	117	1	24422	24460	XP_067992270.1 LOW QUALITY PROTEIN: titin [Myxine glutinosa]	diamond	234	56.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
31195972	31195972	PRJNA1074408_S_NODE_6875_length_178_cov_1.777778_g6745_i0	PRJNA1074408	6875	178	1.777778	3.16444484	Anura	8342	Chordata	Chordata	69.7	4.82e-12	NR	XP_066447536.1	57060	g6745	i0	84.2	62.123595505618	38	6	64	0	114	1	489	526	XP_066447536.1 kelch-like protein 32 [Eleutherodactylus coqui]	diamond	11058	69.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Eleutherodactylidae	Eleutherodactylus	Eleutherodactylus coqui
31679193	31679193	PRJNA1074408_S_NODE_9677_length_152_cov_1.761468_g9547_i0	PRJNA1074408	9677	152	1.761468	2.67743136	Orcinus orca	9733	Chordata	Chordata	50.4	2.04e-5	NR	XP_049557796.1	9733	g9547	i0	46	1.83552631578947	50	27	98.7	0	150	1	2050	2099	XP_049557796.1 nucleosome-remodeling factor subunit BPTF isoform X18 [Orcinus orca]	diamond	279	50.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Orcinus	Orcinus orca
31869015	31869015	PRJNA1074408_S_NODE_7137_length_175_cov_1.818182_g7007_i0	PRJNA1074408	7137	175	1.818182	3.1818185	Canis lupus familiaris	9615	Chordata	Chordata	49.3	7.44e-5	NR	BAA25253.1	9615	g7007	i0	63.6	3.92571428571429	33	12	56.6	0	76	174	1022	1054	BAA25253.1 unnamed protein product [Canis lupus familiaris]	diamond	687	49.7	0.991951710261569	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
32628014	32628014	PRJNA1074408_S_NODE_8780_length_159_cov_1.655172_g8650_i0	PRJNA1074408	8780	159	1.655172	2.63172348	Ambystoma mexicanum	8296	Chordata	Chordata	50.8	1.64e-5	NR	XP_069481484.1	8296	g8650	i0	58.1	4.05660377358491	43	18	81.1	0	2	130	1264	1306	XP_069481484.1 mucin-2-like [Ambystoma mexicanum]	diamond	645	50.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Ambystomatidae	Ambystoma	Ambystoma mexicanum

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