metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1193541" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1193541" 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
26787677	26787677	PRJNA1193541_P_NODE_421_length_1024_cov_4.893796_g332_i1	PRJNA1193541	421	1024	4.893796	50.11247104	Staurois parvus	386267	Chordata	Chordata	49.7	0.00621	NR	CAI9536211.1	386267	g332	i1	54.2	0.140625	48	15	12	3	654	532	178	225	CAI9536211.1 unnamed protein product [Staurois parvus]	diamond	144	49.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
27167021	27167021	PRJNA1193541_P_NODE_5582_length_360_cov_2.383275_g5444_i0	PRJNA1193541	5582	360	2.383275	8.57979	Staurois parvus	386267	Chordata	Chordata	62	1.65e-9	NR	CAI9619393.1	386267	g5444	i0	53	1.08333333333333	66	18	44.2	3	198	356	50	115	CAI9619393.1 unnamed protein product, partial [Staurois parvus]	diamond	390	62	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
27388611	27388611	PRJNA1193541_P_NODE_11963_length_252_cov_0.849162_g11825_i0	PRJNA1193541	11963	252	0.849162	2.13988824	Engystomops pustulosus	76066	Chordata	Chordata	45.4	5.43e-4	NR	KAG8546926.1	76066	g11825	i0	51	0.583333333333333	49	24	58.3	0	62	208	9	57	KAG8546926.1 hypothetical protein GDO81_029527 [Engystomops pustulosus]	diamond	147	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
27420288	27420288	PRJNA1193541_P_NODE_12623_length_249_cov_1.312500_g12485_i0	PRJNA1193541	12623	249	1.3125	3.268125	Staurois parvus	386267	Chordata	Chordata	53.1	1.43e-6	NR	CAI9548327.1	386267	g12485	i0	58	0.602409638554217	50	16	54.2	1	140	6	47	96	CAI9548327.1 unnamed protein product [Staurois parvus]	diamond	150	53.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
28304069	28304069	PRJNA1193541_P_NODE_12246_length_251_cov_0.865169_g12108_i0	PRJNA1193541	12246	251	0.865169	2.17157419	Ursus maritimus	29073	Chordata	Chordata	79	7.36e-15	NR	XP_040497168.1	29073	g12108	i0	59	0.932270916334661	78	31	93.2	1	17	250	240	316	XP_040497168.1 uncharacterized protein LOC103676899 [Ursus maritimus]	diamond	234	79	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Ursidae	Ursus	Ursus maritimus
28746108	28746108	PRJNA1193541_P_NODE_13747_length_246_cov_0.890173_g13609_i0	PRJNA1193541	13747	246	0.890173	2.18982558	Regulus satrapa	13245	Chordata	Chordata	47.8	4.35e-5	NR	NWR50751.1	13245	g13609	i0	45.5	0.670731707317073	55	27	67.1	1	4	168	2	53	NWR50751.1 ZNF85 protein [Regulus satrapa]	diamond	165	47.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Regulidae	Regulus	Regulus satrapa
30640934	30640934	PRJNA1193541_P_NODE_11033_length_265_cov_1.625000_g10895_i0	PRJNA1193541	11033	265	1.625	4.30625	Rangifer tarandus platyrhynchus	3082113	Chordata	Chordata	45.1	0.00601	NR	CAI9169444.1	3082113	g10895	i0	42.4	0.747169811320755	66	35	72.5	2	73	264	35	99	CAI9169444.1 unnamed protein product [Rangifer tarandus platyrhynchus]	diamond	198	45.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Rangifer	Rangifer tarandus
32840832	32840832	PRJNA1193541_P_NODE_11140_length_264_cov_1.240838_g11002_i0	PRJNA1193541	11140	264	1.240838	3.27581232	Chordata	7711	Chordata	Chordata	57	4.49e-7	NR	KAG5201318.1	9940	g11002	i0	77.8	77.75	36	8	40.9	0	260	153	598	633	KAG5201318.1 hypothetical protein JEQ12_004081 [Ovis aries]	diamond	20526	57.4	0.993031358885017	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries

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