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

10 rows where analysis = "diamond", bioproject = "PRJNA888104" 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
26643807	26643807	PRJNA888104_P_NODE_14321_length_271_cov_4.287129_g14252_i0	PRJNA888104	14321	271	4.287129	11.61811959	Gulo gulo	48420	Chordata	Chordata	67.4	6.55e-12	NR	VCW91066.1	48420	g14252	i0	56.9	13.0073800738007	65	11	56.5	2	3	155	69	130	VCW91066.1 unnamed protein product [Gulo gulo]	diamond	3525	67.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Gulo	Gulo gulo
27568791	27568791	PRJNA888104_P_NODE_20264_length_234_cov_0.872727_g20195_i0	PRJNA888104	20264	234	0.872727	2.04218118	Chordata	7711	Chordata	Chordata	156	5.589999999999998e-47	NR	XP_067871554.1	7792	g20195	i0	93.5	107.5	77	5	98.7	0	232	2	50	126	XP_067871554.1 cytochrome c oxidase subunit 5A, mitochondrial-like [Heterodontus francisci]	diamond	25155	157	0.993630573248408	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Heterodontiformes	Heterodontidae	Heterodontus	Heterodontus francisci
28097697	28097697	PRJNA888104_P_NODE_20305_length_233_cov_2.926829_g20236_i0	PRJNA888104	20305	233	2.926829	6.81951157	Corvus kubaryi	68294	Chordata	Chordata	102	4.4699999999999996e-23	NR	XP_041876411.1	68294	g20236	i0	69.4	1.09442060085837	85	14	94	1	3	221	625	709	XP_041876411.1 uncharacterized protein LOC121660879 [Corvus kubaryi]	diamond	255	102	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Corvidae	Corvus	Corvus kubaryi
28579369	28579369	PRJNA888104_P_NODE_13887_length_276_cov_0.946860_g13818_i0	PRJNA888104	13887	276	0.94686	2.6133336	Chordata	7711	Chordata	Chordata	157	1.08e-46	NR	KFP02737.1	9244	g13818	i0	97.4	53.6630434782609	76	2	82.6	0	276	49	121	196	KFP02737.1 Ribosome biogenesis protein NSA2, partial [Calypte anna]	diamond	14811	158	0.993670886075949	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apodiformes	Trochilidae	Calypte	Calypte anna
29431500	29431500	PRJNA888104_P_NODE_21169_length_232_cov_0.883436_g21100_i0	PRJNA888104	21169	232	0.883436	2.04957152	Chondrichthyes	7777	Chordata	Chordata	168	2.33e-49	NR	XP_041044796.1	13397	g21100	i0	97.4	77.6637931034483	77	2	99.6	0	231	1	265	341	XP_041044796.1 2-oxoisovalerate dehydrogenase subunit beta, mitochondrial isoform X2 [Carcharodon carcharias]	diamond	18018	168	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Lamniformes	Alopiidae	Carcharodon	Carcharodon carcharias
29455055	29455055	PRJNA888104_P_NODE_19690_length_235_cov_0.867470_g19621_i0	PRJNA888104	19690	235	0.86747	2.0385545	Bufotes viridis	30338	Chordata	Chordata	43.9	0.0128	NR	CAK8629749.1	30338	g19621	i0	69.6	0.293617021276596	23	7	29.4	0	79	147	335	357	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	69	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
29462951	29462951	PRJNA888104_P_NODE_19310_length_235_cov_3.060241_g19241_i0	PRJNA888104	19310	235	3.060241	7.19156635	Chondrichthyes	7777	Chordata	Chordata	159	2.4899999999999997e-48	NR	AEM46243.1	46612	g19241	i0	98.7	56.7446808510638	78	1	99.6	0	234	1	24	101	AEM46243.1 ribosomal protein L8, partial [Carcharhinus leucas]	diamond	13335	160	0.99375	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Carcharhiniformes	Carcharhinidae	Carcharhinus	Carcharhinus leucas
29652410	29652410	PRJNA888104_P_NODE_7310_length_363_cov_0.979592_g7241_i0	PRJNA888104	7310	363	0.979592	3.55591896	Cladistia	1338366	Chordata	Chordata	211	5.2e-64	NR	KYO20403.1	8496	g7241	i0	99	73.2561983471074	105	1	86.8	0	317	3	31	135	KYO20403.1 40S ribosomal protein S14 [Alligator mississippiensis]	diamond	26592	213	0.990610328638498	Eukaryota	Opisthokonta	Metazoa	Chordata		Crocodylia	Alligatoridae	Alligator	Alligator mississippiensis
32402964	32402964	PRJNA888104_P_NODE_11039_length_304_cov_1.280851_g10970_i0	PRJNA888104	11039	304	1.280851	3.89378704	Passeriformes	9126	Chordata	Chordata	110	4.68e-28	NR	NXO99573.1	73330	g10970	i0	66.3	2.28947368421053	89	16	74	1	304	80	21	109	NXO99573.1 RL19 protein [Certhia brachydactyla]	diamond	696	110	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Certhiidae	Certhia	Certhia brachydactyla
32623981	32623981	PRJNA888104_P_NODE_22300_length_229_cov_2.256250_g22231_i0	PRJNA888104	22300	229	2.25625	5.1668125	root	1	Root_unresolved	Root_unresolved	155	9.439999999999998e-47	NR	XP_070721757.1	55135	g22231	i0	100	127.71615720524	75	0	98.3	0	3	227	33	107	XP_070721757.1 small ribosomal subunit protein eS24 isoform X2 [Pristiophorus japonicus]	diamond	29247	155	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes		Pristiophoridae	Pristiophorus	Pristiophorus japonicus

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