metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA385396" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA385396" 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
2957909	2957909	PRJNA385396_P_NODE_8903_length_298_cov_1.368889_g8811_i0	PRJNA385396	8903	298	1.368889	4.07928922	Metazoa	33208	Chordata	Chordata	144	1.4e-38	NR	XP_071065821.1	9361	g8811	i0	68.8	66.5234899328859	93	29	93.6	0	294	16	152	244	XP_071065821.1 alpha-aminoadipic semialdehyde dehydrogenase isoform X2 [Dasypus novemcinctus]	diamond	19824	145	0.993103448275862	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Cingulata	Dasypodidae	Dasypus	Dasypus novemcinctus
27264938	27264938	PRJNA385396_P_NODE_5463_length_354_cov_0.882562_g5371_i0	PRJNA385396	5463	354	0.882562	3.12426948	Ranitomeya imitator	111125	Chordata	Chordata	47.4	0.00256	NR	CAJ0956274.1	111125	g5371	i0	50	0.322033898305085	38	19	32.2	0	302	189	1	38	CAJ0956274.1 unnamed protein product [Ranitomeya imitator]	diamond	114	47.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
27580662	27580662	PRJNA385396_P_NODE_11244_length_271_cov_1.353535_g11152_i0	PRJNA385396	11244	271	1.353535	3.66807985	Erpetoichthys calabaricus	27687	Chordata	Chordata	63.5	2.09e-9	NR	XP_051791274.1	27687	g11152	i0	47.8	4.98154981549815	90	19	98.5	2	267	1	161	223	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	1350	63.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
28734311	28734311	PRJNA385396_P_NODE_6367_length_335_cov_1.755725_g6275_i0	PRJNA385396	6367	335	1.755725	5.88167875	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	109	6.4e-26	NR	KAI8496862.1	7741	g6275	i0	53.5	47.1492537313433	114	47	99.4	2	333	1	45	155	KAI8496862.1 nucleosomal DNA binding [Branchiostoma belcheri]	diamond	15795	109	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
28748965	28748965	PRJNA385396_P_NODE_17927_length_245_cov_0.895349_g17835_i0	PRJNA385396	17927	245	0.895349	2.19360505	Latimeria chalumnae	7897	Chordata	Chordata	42.7	0.0389	NR	XP_064407985.1	7897	g17835	i0	35.9	0.783673469387755	64	41	78.4	0	5	196	861	924	XP_064407985.1 valine--tRNA ligase, mitochondrial isoform X2 [Latimeria chalumnae]	diamond	192	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
28875262	28875262	PRJNA385396_P_NODE_6328_length_336_cov_1.243346_g6236_i0	PRJNA385396	6328	336	1.243346	4.17764256	Ciona intestinalis	7719	Chordata	Chordata	68.9	7.45e-11	NR	XP_026696704.1	7719	g6236	i0	42.3	3.05357142857143	78	40	67	3	269	45	2702	2777	XP_026696704.1 fibrillin-1-like [Ciona intestinalis]	diamond	1026	68.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis
28987117	28987117	PRJNA385396_P_NODE_11648_length_267_cov_1.190722_g11556_i0	PRJNA385396	11648	267	1.190722	3.17922774	Chordata	7711	Chordata	Chordata	46.2	0.00313	NR	XP_055507882.1	7782	g11556	i0	64.6	4.86516853932584	48	17	53.9	0	153	10	961	1008	XP_055507882.1 calpain-15-like [Leucoraja erinaceus]	diamond	1299	46.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Leucoraja	Leucoraja erinaceus
29113226	29113226	PRJNA385396_P_NODE_17488_length_246_cov_0.890173_g17396_i0	PRJNA385396	17488	246	0.890173	2.18982558	Metazoa	33208	Chordata	Chordata	103	2.13e-23	NR	XP_053562311.1	8345	g17396	i0	57.7	26.0243902439024	78	29	93.9	2	13	243	120	194	XP_053562311.1 cytosolic endo-beta-N-acetylglucosaminidase [Bombina bombina]	diamond	6402	104	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
29474879	29474879	PRJNA385396_P_NODE_19110_length_244_cov_0.900585_g19018_i0	PRJNA385396	19110	244	0.900585	2.1974274	Leucoraja erinaceus	7782	Chordata	Chordata	93.6	1.91e-21	NR	XP_055506633.1	7782	g19018	i0	59.5	2.72950819672131	74	30	91	0	23	244	50	123	XP_055506633.1 60S ribosomal protein L18a [Leucoraja erinaceus]	diamond	666	93.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Leucoraja	Leucoraja erinaceus
29917381	29917381	PRJNA385396_P_NODE_11671_length_267_cov_0.793814_g11579_i0	PRJNA385396	11671	267	0.793814	2.11948338	Bufotes viridis	30338	Chordata	Chordata	46.2	0.0028	NR	CAK8629749.1	30338	g11579	i0	62.1	0.325842696629214	29	11	32.6	0	223	137	329	357	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	87	46.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
30012172	30012172	PRJNA385396_P_NODE_9531_length_290_cov_1.050691_g9439_i0	PRJNA385396	9531	290	1.050691	3.0470039	Galeopterus variegatus	482537	Chordata	Chordata	42.4	0.029	NR	XP_008582852.1	482537	g9439	i0	44	0.517241379310345	50	24	47.6	1	142	5	54	103	XP_008582852.1 PREDICTED: MKI67 FHA domain-interacting nucleolar phosphoprotein-like, partial [Galeopterus variegatus]	diamond	150	42.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Dermoptera	Cynocephalidae	Galeopterus	Galeopterus variegatus
30123509	30123509	PRJNA385396_P_NODE_20172_length_242_cov_1.816568_g20080_i0	PRJNA385396	20172	242	1.816568	4.39609456	Chordata	7711	Chordata	Chordata	78.2	2.09e-16	NR	XP_032814458.1	7757	g20080	i0	56.3	3.9297520661157	80	35	99.2	0	241	2	7	86	XP_032814458.1 60S ribosomal protein L35 isoform X2 [Petromyzon marinus]	diamond	951	78.6	0.994910941475827	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Petromyzon	Petromyzon marinus
30597455	30597455	PRJNA385396_P_NODE_16233_length_248_cov_0.880000_g16141_i0	PRJNA385396	16233	248	0.88	2.1824	Chordata	7711	Chordata	Chordata	77.4	1.1e-14	NR	XP_039592720.1	55291	g16141	i0	65.8	82.1008064516129	73	25	88.3	0	3	221	189	261	XP_039592720.1 ubiquitin-conjugating enzyme E2Q-like protein 1 [Polypterus senegalus]	diamond	20361	77.8	0.994858611825193	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
30959967	30959967	PRJNA385396_P_NODE_18074_length_245_cov_0.895349_g17982_i0	PRJNA385396	18074	245	0.895349	2.19360505	Lynx rufus	61384	Chordata	Chordata	44.7	0.00752	NR	XP_046952238.1	61384	g17982	i0	48.6	0.881632653061225	72	30	82	3	223	23	17	86	XP_046952238.1 proline-rich protein HaeIII subfamily 1-like [Lynx rufus]	diamond	216	44.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Lynx	Lynx rufus
32446667	32446667	PRJNA385396_P_NODE_11719_length_266_cov_1.419689_g11627_i0	PRJNA385396	11719	266	1.419689	3.77637274	Apaloderma vittatum	57397	Chordata	Chordata	57	7.34e-8	NR	XP_009873761.1	57397	g11627	i0	53.4	0.992481203007519	88	41	99.2	0	266	3	2	89	XP_009873761.1 PREDICTED: F-box/LRR-repeat protein 14, partial [Apaloderma vittatum]	diamond	264	57	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Trogoniformes	Trogonidae	Apaloderma	Apaloderma vittatum
32541615	32541615	PRJNA385396_P_NODE_14119_length_250_cov_1.005650_g14027_i0	PRJNA385396	14119	250	1.00565	2.514125	Canis lupus familiaris	9615	Chordata	Chordata	119	5.6899999999999995e-30	NR	XP_038437651.1	9615	g14027	i0	74.7	43.824	83	21	99.6	0	249	1	11	93	XP_038437651.1 ribose-phosphate pyrophosphokinase 1-like isoform X3 [Canis lupus familiaris]	diamond	10956	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus

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