metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB41113" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB41113" 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
28991733	28991733	PRJEB41113_S_NODE_11228_length_156_cov_5.008403_g11219_i0	PRJEB41113	11228	156	5.008403	7.81310868	Emydura macquarii macquarii	1129001	Chordata	Chordata	41.2	0.0394	NR	XP_067396343.1	1129001	g11219	i0	40	2.59615384615385	45	27	86.5	0	11	145	1	45	XP_067396343.1 embryonic polyadenylate-binding protein 2 isoform X1 [Emydura macquarii macquarii]	diamond	405	41.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Chelidae	Emydura	Emydura macquarii
29212622	29212622	PRJEB41113_S_NODE_3729_length_198_cov_1.602484_g3720_i0	PRJEB41113	3729	198	1.602484	3.17291832	Pleurodeles waltl	8319	Chordata	Chordata	40.4	0.0403	NR	KAJ1208393.1	8319	g3720	i0	43.9	0.621212121212121	41	21	59.1	1	168	52	26	66	KAJ1208393.1 hypothetical protein NDU88_003779, partial [Pleurodeles waltl]	diamond	123	40.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
30152924	30152924	PRJEB41113_S_NODE_472_length_309_cov_1.658088_g463_i0	PRJEB41113	472	309	1.658088	5.12349192	root	1	Root_unresolved	Root_unresolved	212	1.75e-65	NR	XP_036010302.1	10090	g463	i0	99	21	103	1	100	0	1	309	77	179	XP_036010302.1 uncharacterized protein Gm53410 [Mus musculus]	diamond	6489	213	0.995305164319249	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
30191319	30191319	PRJEB41113_S_NODE_9452_length_162_cov_1.288000_g9443_i0	PRJEB41113	9452	162	1.288	2.08656	Canis lupus dingo	286419	Chordata	Chordata	42.4	0.017	NR	XP_048959677.1	286419	g9443	i0	43.8	0.888888888888889	48	25	85.2	1	161	24	596	643	XP_048959677.1 protein FAM110B isoform X1 [Canis lupus dingo]	diamond	144	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
31986464	31986464	PRJEB41113_S_NODE_7098_length_174_cov_1.408759_g7089_i0	PRJEB41113	7098	174	1.408759	2.45124066	root	1	Root_unresolved	Root_unresolved	106	4.3799999999999995e-25	NR	XP_036018054.1	10090	g7089	i0	91.1	28.8103448275862	56	5	96.6	0	2	169	322	377	XP_036018054.1 uncharacterized protein Gm54073 [Mus musculus]	diamond	5013	106	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
32303317	32303317	PRJEB41113_S_NODE_11359_length_156_cov_2.050420_g11350_i0	PRJEB41113	11359	156	2.05042	3.1986552	Polypteridae	8289	Chordata	Chordata	79	1.14e-15	NR	XP_051791274.1	27687	g11350	i0	79.2	11.1730769230769	53	10	100	1	156	1	127	179	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	1743	79	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus

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