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

7 rows where analysis = "diamond", bioproject = "PRJNA1036688" 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
5272523	5272523	PRJNA1036688_P_NODE_6765_length_219_cov_2.120879_g6473_i0	PRJNA1036688	6765	219	2.120879	4.64472501	Metazoa	33208	Chordata	Chordata	114	1.63e-29	NR	MBZ3884393.1	30640	g6473	i0	76.3	3.97260273972603	76	15	100	1	1	219	29	104	MBZ3884393.1 40S ribosomal protein S2 [Sciurus carolinensis]	diamond	870	114	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Sciuridae	Sciurus	Sciurus carolinensis
28290380	28290380	PRJNA1036688_P_NODE_8226_length_192_cov_1.496774_g7934_i0	PRJNA1036688	8226	192	1.496774	2.87380608	root	1	Root_unresolved	Root_unresolved	139	8.999999999999999e-37	NR	XP_030110853.2	10090	g7934	i0	100	15.75	63	0	98.4	0	2	190	170	232	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	3024	139	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
28898284	28898284	PRJNA1036688_P_NODE_7148_length_211_cov_1.545977_g6856_i0	PRJNA1036688	7148	211	1.545977	3.26201147	Polypterus senegalus	55291	Chordata	Chordata	45.8	0.00189	NR	KAG2469876.1	55291	g6856	i0	64.3	10.3791469194313	28	10	39.8	0	209	126	299	326	KAG2469876.1 TC1A transposase, partial [Polypterus senegalus]	diamond	2190	45.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
29088026	29088026	PRJNA1036688_P_NODE_9428_length_176_cov_1.676259_g9136_i0	PRJNA1036688	9428	176	1.676259	2.95021584	Staurois parvus	386267	Chordata	Chordata	44.7	3.23e-4	NR	CAI9580978.1	386267	g9136	i0	56.1	0.698863636363636	41	18	69.9	0	27	149	1	41	CAI9580978.1 unnamed protein product, partial [Staurois parvus]	diamond	123	44.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
29308810	29308810	PRJNA1036688_P_NODE_8469_length_188_cov_2.821192_g8177_i0	PRJNA1036688	8469	188	2.821192	5.30384096	Bufotes viridis	30338	Chordata	Chordata	42.7	0.018	NR	CAK8609802.1	30338	g8177	i0	52.9	1.78723404255319	34	16	54.3	0	107	6	1	34	CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis]	diamond	336	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
30406681	30406681	PRJNA1036688_P_NODE_11813_length_153_cov_19.672414_g11521_i0	PRJNA1036688	11813	153	19.672414	30.09879342	Opisthokonta	33154	Chordata	Chordata	40.8	0.0169	NR	NWZ51675.1	8969	g11521	i0	69.2	2.54901960784314	26	8	51	0	153	76	6	31	NWZ51675.1 ZN252 protein [Haliaeetus albicilla]	diamond	390	40.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Accipitriformes	Accipitridae	Haliaeetus	Haliaeetus albicilla
32564850	32564850	PRJNA1036688_P_NODE_11419_length_157_cov_0.966667_g11127_i0	PRJNA1036688	11419	157	0.966667	1.51766719	Tricholaema leucomelas	240729	Chordata	Chordata	43.5	9.45e-4	NR	NXX49186.1	240729	g11127	i0	38.6	2.56050955414013	44	27	84.1	0	134	3	2	45	NXX49186.1 Z585A protein [Tricholaema leucomelas]	diamond	402	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Piciformes	Lybiidae	Tricholaema lacrymosa	Tricholaema leucomelas

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