metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA839281" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA839281" 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
12308882	12308882	PRJNA839281_S_NODE_26250_length_167_cov_1.610169_g25981_i0	PRJNA839281	26250	167	1.610169	2.68898223	Phallusia mammillata	59560	Chordata	Chordata	97.4	2.36e-24	NR	CAB3265753.1	59560	g25981	i0	83.6	2.96407185628743	55	9	98.8	0	1	165	50	104	CAB3265753.1 40S ribosomal protein S15Aa [Phallusia mammillata]	diamond	495	97.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Ascidiidae	Phallusia	Phallusia mammillata
27718504	27718504	PRJNA839281_S_NODE_31824_length_164_cov_0.886957_g31555_i0	PRJNA839281	31824	164	0.886957	1.45460948	Hypanus sabinus	79690	Chordata	Chordata	75.5	3.62e-14	NR	XP_059838539.1	79690	g31555	i0	83	6.8780487804878	47	8	86	0	143	3	35	81	XP_059838539.1 heat shock protein HSP 90-beta [Hypanus sabinus]	diamond	1128	75.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
28168609	28168609	PRJNA839281_S_NODE_23625_length_174_cov_2.088000_g23356_i0	PRJNA839281	23625	174	2.088	3.63312	Mammalia	40674	Chordata	Chordata	44.7	0.00251	NR	VTJ53676.1	9995	g23356	i0	76.7	1.3448275862069	30	7	51.7	0	79	168	104	133	VTJ53676.1 Hypothetical predicted protein [Marmota monax]	diamond	234	44.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Sciuridae	Marmota	Marmota monax
28602255	28602255	PRJNA839281_S_NODE_22147_length_179_cov_0.800000_g21878_i0	PRJNA839281	22147	179	0.8	1.432	Capra hircus	9925	Chordata	Chordata	48.1	1.98e-4	NR	XP_017900436.1	9925	g21878	i0	82.8	0.972067039106145	29	5	48.6	0	16	102	719	747	XP_017900436.1 PREDICTED: basic proline-rich protein-like [Capra hircus]	diamond	174	48.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Capra	Capra hircus
28736943	28736943	PRJNA839281_S_NODE_29887_length_165_cov_0.879310_g29618_i0	PRJNA839281	29887	165	0.87931	1.4508615	Chondrichthyes	7777	Chordata	Chordata	52.8	3.87e-6	NR	XP_059826436.1	79690	g29618	i0	47.2	1.92727272727273	53	28	96.4	0	162	4	28	80	XP_059826436.1 exosome complex exonuclease RRP44 [Hypanus sabinus]	diamond	318	53.1	0.994350282485876	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
29044345	29044345	PRJNA839281_S_NODE_33608_length_163_cov_0.894737_g33339_i0	PRJNA839281	33608	163	0.894737	1.45842131	Petromyzon marinus	7757	Chordata	Chordata	56.6	1.11e-7	NR	XP_032818635.1	7757	g33339	i0	55.6	11.521472392638	54	19	99.4	1	162	1	138	186	XP_032818635.1 proteasome subunit alpha type-6 [Petromyzon marinus]	diamond	1878	56.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Petromyzon	Petromyzon marinus
29115938	29115938	PRJNA839281_S_NODE_6068_length_338_cov_2.339100_g5799_i0	PRJNA839281	6068	338	2.3391	7.906158	Rodentia	9989	Chordata	Chordata	51.2	1.01e-4	NR	MBZ3873924.1	30640	g5799	i0	75.8	1.46449704142012	33	8	29.3	0	1	99	98	130	MBZ3873924.1 Actin, cytoplasmic 1 [Sciurus carolinensis]	diamond	495	51.6	0.992248062015504	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Sciuridae	Sciurus	Sciurus carolinensis
29170616	29170616	PRJNA839281_S_NODE_20349_length_185_cov_0.977941_g20080_i0	PRJNA839281	20349	185	0.977941	1.80919085	Chelonoidis abingdonii	106734	Chordata	Chordata	43.9	0.00656	NR	XP_032629857.1	106734	g20080	i0	43.6	1.78378378378378	55	27	89.2	3	20	184	187	237	XP_032629857.1 megakaryocyte and platelet inhibitory receptor G6b isoform X3 [Chelonoidis abingdonii]	diamond	330	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Testudinidae	Chelonoidis	Chelonoidis abingdonii
29296804	29296804	PRJNA839281_S_NODE_36269_length_162_cov_0.876106_g36000_i0	PRJNA839281	36269	162	0.876106	1.41929172	Odorrana macrotympana	2820320	Chordata	Chordata	57.4	4.92e-8	NR	QTE20700.1	2820320	g36000	i0	71.8	5.74074074074074	39	11	72.2	0	1	117	70	108	QTE20700.1 ATP synthase F0 subunit 6 [Odorrana macrotympana]	diamond	930	57.8	0.993079584775087	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Odorrana	Odorrana macrotympana
30434192	30434192	PRJNA839281_S_NODE_31773_length_164_cov_0.886957_g31504_i0	PRJNA839281	31773	164	0.886957	1.45460948	Staurois parvus	386267	Chordata	Chordata	47	3.35e-4	NR	CAI9536211.1	386267	g31504	i0	52.2	0.841463414634146	46	15	71.3	3	117	1	179	224	CAI9536211.1 unnamed protein product [Staurois parvus]	diamond	138	47	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
30971076	30971076	PRJNA839281_S_NODE_20254_length_185_cov_1.279412_g19985_i0	PRJNA839281	20254	185	1.279412	2.3669122	Phallusia mammillata	59560	Chordata	Chordata	82	8.36e-17	NR	CAB3265727.1	59560	g19985	i0	63.9	3.95675675675676	61	20	98.9	1	1	183	74	132	CAB3265727.1 60S ribosomal protein L5 [Phallusia mammillata]	diamond	732	82	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Ascidiidae	Phallusia	Phallusia mammillata
31065973	31065973	PRJNA839281_S_NODE_36215_length_162_cov_0.902655_g35946_i0	PRJNA839281	36215	162	0.902655	1.4623011	Ranitomeya imitator	111125	Chordata	Chordata	42.4	0.016	NR	CAJ0947973.1	111125	g35946	i0	84.2	5.2962962962963	19	3	35.2	0	109	53	129	147	CAJ0947973.1 unnamed protein product [Ranitomeya imitator]	diamond	858	42.7	0.992974238875878	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
31191786	31191786	PRJNA839281_S_NODE_20615_length_184_cov_0.851852_g20346_i0	PRJNA839281	20615	184	0.851852	1.56740768	Euleptes europaea	460621	Chordata	Chordata	50.4	3.28e-5	NR	XP_056720363.1	460621	g20346	i0	51.5	1.30434782608696	33	16	53.8	0	52	150	586	618	XP_056720363.1 zinc finger protein 436-like [Euleptes europaea]	diamond	240	50.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Sphaerodactylidae	Euleptes	Euleptes europaea
31991268	31991268	PRJNA839281_S_NODE_20498_length_184_cov_1.466667_g20229_i0	PRJNA839281	20498	184	1.466667	2.69866728	root	1	Root_unresolved	Root_unresolved	138	3.19e-36	NR	XP_029332929.1	10089	g20229	i0	98.3	14.6739130434783	60	1	97.8	0	182	3	793	852	XP_029332929.1 LOW QUALITY PROTEIN: uncharacterized protein LOC110295489 [Mus caroli]	diamond	2700	139	0.992805755395683	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus caroli
32023050	32023050	PRJNA839281_S_NODE_18698_length_191_cov_1.232394_g18429_i0	PRJNA839281	18698	191	1.232394	2.35387254	Carnivora	33554	Chordata	Chordata	43.9	0.00721	NR	XP_027432800.1	9704	g18429	i0	86.4	1.38219895287958	44	5	69.1	1	134	3	127	169	XP_027432800.1 translation initiation factor IF-2-like [Zalophus californianus]	diamond	264	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Otariidae	Zalophus	Zalophus californianus

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