metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA724039" 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
28168059	28168059	PRJNA724039_S_NODE_9465_length_212_cov_1.988571_g9258_i0	PRJNA724039	9465	212	1.988571	4.21577052	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	95.1	6.300000000000001e-22	NR	CAL5908699.1	7748	g9258	i0	70	108.962264150943	70	21	99.1	0	3	212	126	195	CAL5908699.1 unnamed protein product [Lampetra fluviatilis]	diamond	23100	95.9	0.991657977059437	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
29041934	29041934	PRJNA724039_S_NODE_15368_length_163_cov_1.142857_g15161_i0	PRJNA724039	15368	163	1.142857	1.86285691	Polypterus senegalus	55291	Chordata	Chordata	41.2	0.0454	NR	XP_039608797.1	55291	g15161	i0	81	0.386503067484663	21	4	38.7	0	50	112	490	510	XP_039608797.1 uncharacterized protein LOC120528708 [Polypterus senegalus]	diamond	63	41.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
29231363	29231363	PRJNA724039_S_NODE_3069_length_417_cov_5.097368_g2862_i0	PRJNA724039	3069	417	5.097368	21.25602456	Erpetoichthys calabaricus	27687	Chordata	Chordata	133	6.689999999999999e-35	NR	XP_051791274.1	27687	g2862	i0	77.8	5.88489208633094	90	19	64	1	20	286	115	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2454	133	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
30662872	30662872	PRJNA724039_S_NODE_16133_length_159_cov_0.950820_g15926_i0	PRJNA724039	16133	159	0.95082	1.5118038	Metazoa	33208	Chordata	Chordata	49.7	4.18e-5	NR	XP_039263030.1	7725	g15926	i0	55.3	5.50943396226415	47	21	88.7	0	148	8	1027	1073	XP_039263030.1 cullin-associated NEDD8-dissociated protein 1-like [Styela clava]	diamond	876	49.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
30968659	30968659	PRJNA724039_S_NODE_1794_length_581_cov_4.806985_g1602_i0	PRJNA724039	1794	581	4.806985	27.92858285	Polypterus senegalus	55291	Chordata	Chordata	62	1.73e-7	NR	KAG2469303.1	55291	g1602	i0	70.7	0.635111876075731	41	12	21.2	0	213	335	11	51	KAG2469303.1 SRPK2 kinase, partial [Polypterus senegalus]	diamond	369	62	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
31042415	31042415	PRJNA724039_S_NODE_6215_length_274_cov_2.181435_g6008_i0	PRJNA724039	6215	274	2.181435	5.9771319	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	144	3.1399999999999993e-40	NR	XP_069097964.1	8319	g6008	i0	76.7	73.8722627737226	90	21	98.5	0	1	270	20	109	XP_069097964.1 large ribosomal subunit protein uL18B-like [Pleurodeles waltl]	diamond	20241	144	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
32075348	32075348	PRJNA724039_S_NODE_16118_length_159_cov_1.188525_g15911_i0	PRJNA724039	16118	159	1.188525	1.88975475	Ciona intestinalis	7719	Chordata	Chordata	77.4	6.56e-15	NR	XP_002131800.1	7719	g15911	i0	70	1.88679245283019	50	15	94.3	0	150	1	53	102	XP_002131800.1 calreticulin [Ciona intestinalis]	diamond	300	77.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis

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