metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA827593" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA827593" 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
23773364	23773364	PRJNA827593_P_NODE_22739_length_442_cov_3.287263_g22440_i0	PRJNA827593	22739	442	3.287263	14.52970246	root	1	Root_unresolved	Root_unresolved	77	3.51e-13	NR	KAK7796718.1	447135	g22440	i0	48.1	1.67647058823529	79	41	53.6	0	142	378	492	570	KAK7796718.1 hypothetical protein U0070_023578 [Myodes glareolus]	diamond	741	77	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Myodes	Myodes glareolus
27086230	27086230	PRJNA827593_P_NODE_52882_length_273_cov_3.555000_g52583_i0	PRJNA827593	52882	273	3.555	9.70515	Meriones unguiculatus	10047	Chordata	Chordata	43.5	0.0272	NR	XP_060237778.1	10047	g52583	i0	44.4	0.494505494505495	45	25	49.5	0	81	215	360	404	XP_060237778.1 centrosomal protein of 44 kDa isoform X2 [Meriones unguiculatus]	diamond	135	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Meriones	Meriones unguiculatus
27370925	27370925	PRJNA827593_P_NODE_64743_length_245_cov_2.523256_g64444_i0	PRJNA827593	64743	245	2.523256	6.1819772	Engystomops pustulosus	76066	Chordata	Chordata	57.4	2.69e-7	NR	KAG8568304.1	76066	g64444	i0	36.1	1.01632653061224	83	48	99.2	2	243	1	248	327	KAG8568304.1 hypothetical protein GDO81_013953 [Engystomops pustulosus]	diamond	249	57.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
28231445	28231445	PRJNA827593_P_NODE_65166_length_245_cov_0.895349_g64867_i0	PRJNA827593	65166	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	58.2	1.42e-7	NR	XP_006217958.1	30538	g64867	i0	50	6.64897959183673	46	23	56.3	0	24	161	350	395	XP_006217958.1 beta-mannosidase isoform X1 [Vicugna pacos]	diamond	1629	58.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Camelidae	Vicugna	Vicugna pacos
28831521	28831521	PRJNA827593_P_NODE_47828_length_290_cov_1.930876_g47529_i0	PRJNA827593	47828	290	1.930876	5.5995404	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	66.6	1.64e-10	NR	NXH44011.1	667154	g47529	i0	56.6	5.21379310344828	53	23	54.8	0	81	239	239	291	NXH44011.1 ACTG protein [Dicaeum eximium]	diamond	1512	67	0.994029850746269	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Dicaeidae	Dicaeum	Dicaeum eximium
28886052	28886052	PRJNA827593_P_NODE_54548_length_269_cov_1.178571_g54249_i0	PRJNA827593	54548	269	1.178571	3.17035599	Protopterus annectens	7888	Chordata	Chordata	45.4	0.00598	NR	XP_043914766.1	7888	g54249	i0	39.7	0.646840148698885	58	31	64.7	1	245	72	1561	1614	XP_043914766.1 trichohyalin-like isoform X1 [Protopterus annectens]	diamond	174	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Ceratodontiformes	Protopteridae	Protopterus	Protopterus annectens
29454152	29454152	PRJNA827593_P_NODE_66990_length_242_cov_1.804734_g66691_i0	PRJNA827593	66990	242	1.804734	4.36745628	Hypanus sabinus	79690	Chordata	Chordata	48.1	4.54e-4	NR	XP_059816063.1	79690	g66691	i0	39.4	1.63636363636364	66	35	75.6	1	36	218	139	204	XP_059816063.1 uncharacterized protein LOC132387718 [Hypanus sabinus]	diamond	396	48.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
31896358	31896358	PRJNA827593_P_NODE_55577_length_266_cov_1.295337_g55278_i0	PRJNA827593	55577	266	1.295337	3.44559642	Mammalia	40674	Chordata	Chordata	70.5	8.66e-12	NR	XP_071072823.1	9361	g55278	i0	60	53.9097744360902	70	25	76.7	2	244	41	1048	1116	XP_071072823.1 lysine-specific demethylase 4C isoform X1 [Dasypus novemcinctus]	diamond	14340	70.9	0.994358251057828	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Cingulata	Dasypodidae	Dasypus	Dasypus novemcinctus
32772591	32772591	PRJNA827593_P_NODE_24520_length_424_cov_2.119658_g24221_i0	PRJNA827593	24520	424	2.119658	8.98734992	Hemiscyllium ocellatum	170820	Chordata	Chordata	48.9	0.00163	NR	XP_060679184.1	170820	g24221	i0	30.1	2.93632075471698	93	64	65.8	1	10	288	15	106	XP_060679184.1 serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit C-like, partial [Hemiscyllium ocellatum]	diamond	1245	48.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Orectolobiformes	Hemiscylliidae	Hemiscyllium	Hemiscyllium ocellatum
32907177	32907177	PRJNA827593_P_NODE_68940_length_234_cov_2.391304_g68641_i0	PRJNA827593	68940	234	2.391304	5.59565136	Squamata	8509	Chordata	Chordata	50.8	4.7e-5	NR	ETE61196.1	8665	g68641	i0	60.5	6.06410256410256	43	17	55.1	0	23	151	24	66	ETE61196.1 putative phospholipid-transporting ATPase ID, partial [Ophiophagus hannah]	diamond	1419	51.2	0.9921875	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Elapidae	Ophiophagus	Ophiophagus hannah

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