metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1253698" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1253698" 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
25278872	25278872	PRJNA1253698_S_NODE_23080_length_162_cov_1.469027_g22714_i0	PRJNA1253698	23080	162	1.469027	2.37982374	Mammalia	40674	Chordata	Chordata	95.1	4.32e-21	NR	XP_004462863.2	9361	g22714	i0	89.4	47.7592592592593	47	5	87	0	142	2	636	682	XP_004462863.2 tudor domain-containing protein 3 isoform X2 [Dasypus novemcinctus]	diamond	7737	95.5	0.995811518324607	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Cingulata	Dasypodidae	Dasypus	Dasypus novemcinctus
27358455	27358455	PRJNA1253698_S_NODE_6283_length_274_cov_1.897778_g5917_i0	PRJNA1253698	6283	274	1.897778	5.19991172	Zosterops borbonicus	364589	Chordata	Chordata	170	6.16e-47	NR	TRZ05783.1	364589	g5917	i0	86.8	0.996350364963504	91	12	99.6	0	274	2	152	242	TRZ05783.1 hypothetical protein HGM15179_021325 [Zosterops borbonicus]	diamond	273	170	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Zosteropidae	Zosterops	Zosterops borbonicus
27958220	27958220	PRJNA1253698_S_NODE_9645_length_221_cov_5.273256_g9279_i0	PRJNA1253698	9645	221	5.273256	11.65389576	Bufotes viridis	30338	Chordata	Chordata	44.3	0.00814	NR	CAK8640094.1	30338	g9279	i0	50	0.733031674208145	54	12	62.4	2	140	3	786	832	CAK8640094.1 Transposon Ty3-I Gag-Pol polyprotein [Bufotes viridis]	diamond	162	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
28589851	28589851	PRJNA1253698_S_NODE_19807_length_166_cov_3.598291_g19441_i0	PRJNA1253698	19807	166	3.598291	5.97316306	Pleurodeles waltl	8319	Chordata	Chordata	43.1	0.00842	NR	KAJ1185330.1	8319	g19441	i0	47.1	0.921686746987952	51	22	83.1	1	27	164	44	94	KAJ1185330.1 hypothetical protein NDU88_002123 [Pleurodeles waltl]	diamond	153	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
28778997	28778997	PRJNA1253698_S_NODE_16527_length_174_cov_2.392000_g16161_i0	PRJNA1253698	16527	174	2.392	4.16208	Zosterops borbonicus	364589	Chordata	Chordata	127	3.1299999999999996e-32	NR	TRZ05783.1	364589	g16161	i0	93	0.982758620689655	57	4	98.3	0	173	3	393	449	TRZ05783.1 hypothetical protein HGM15179_021325 [Zosterops borbonicus]	diamond	171	127	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Zosteropidae	Zosterops	Zosterops borbonicus
30168418	30168418	PRJNA1253698_S_NODE_8712_length_233_cov_1.673913_g8346_i0	PRJNA1253698	8712	233	1.673913	3.90021729	Taeniopygia guttata	59729	Chordata	Chordata	137	4.49e-36	NR	XP_041577555.1	59729	g8346	i0	90.9	0.991416309012876	77	7	99.1	0	232	2	137	213	XP_041577555.1 serine/threonine-protein kinase pim-1 [Taeniopygia guttata]	diamond	231	137	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Estrildidae	Taeniopygia	Taeniopygia guttata
32160410	32160410	PRJNA1253698_S_NODE_8058_length_242_cov_1.331606_g7692_i0	PRJNA1253698	8058	242	1.331606	3.22248652	Lonchura striata	40157	Chordata	Chordata	146	1.6199999999999996e-40	NR	OWK63799.1	40157	g7692	i0	89.9	0.979338842975207	79	8	97.9	0	241	5	112	190	OWK63799.1 Retrovirus-related Pol polyprotein from type-1 retrotransposable element R2 [Lonchura striata]	diamond	237	146	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Estrildidae	Lonchura	Lonchura striata
32318761	32318761	PRJNA1253698_S_NODE_3379_length_379_cov_2.739394_g3014_i0	PRJNA1253698	3379	379	2.739394	10.38230326	Opisthocomus hoazin	30419	Chordata	Chordata	176	3.69e-48	NR	XP_009933901.1	30419	g3014	i0	66.4	0.965699208443272	122	40	96.6	1	372	7	124	244	XP_009933901.1 PREDICTED: cGMP-dependent protein kinase 1 [Opisthocomus hoazin]	diamond	366	176	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Opisthocomiformes	Opisthocomidae	Opisthocomus	Opisthocomus hoazin
32778152	32778152	PRJNA1253698_S_NODE_15220_length_181_cov_1.166667_g14854_i0	PRJNA1253698	15220	181	1.166667	2.11166727	Aves	8782	Chordata	Chordata	112	9.5e-31	NR	NXT45335.1	37079	g14854	i0	89.8	3.91160220994475	59	6	97.8	0	179	3	21	79	NXT45335.1 PO21 protein [Pelecanoides urinatrix]	diamond	708	112	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Procellariiformes	Procellariidae	Pelecanoides	Pelecanoides urinatrix

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