metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB58983" 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
1399664	1399664	PRJEB58983_P_NODE_6962_length_468_cov_6.665823_g6548_i0	PRJEB58983	6962	468	6.665823	31.19605164	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	211	4.86e-64	NR	NP_001091345.1	8355	g6548	i0	65.8	12.9935897435897	158	50	98.7	1	6	467	1	158	NP_001091345.1 uncharacterized protein LOC100037184 [Xenopus laevis]	diamond	6081	211	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
17976571	17976571	PRJEB58983_P_NODE_27695_length_253_cov_2.544444_g27280_i0	PRJEB58983	27695	253	2.544444	6.43744332	Oikopleura dioica	34765	Chordata	Chordata	119	2.89e-29	NR	CAG5090479.1	34765	g27280	i0	68.8	2.73913043478261	77	24	91.3	0	2	232	461	537	CAG5090479.1 Oidioi.mRNA.OKI2018_I69.PAR.g12618.t1.cds [Oikopleura dioica]	diamond	693	119	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
24350727	24350727	PRJEB58983_P_NODE_23980_length_270_cov_1.137056_g23565_i0	PRJEB58983	23980	270	1.137056	3.0700512	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	119	8.489999999999999e-31	NR	XP_003409146.1	9785	g23565	i0	62.8	53.7	86	31	95.6	1	12	269	82	166	XP_003409146.1 thioredoxin-dependent peroxide reductase, mitochondrial [Loxodonta africana]	diamond	14499	119	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Proboscidea	Elephantidae	Loxodonta	Loxodonta africana
27349937	27349937	PRJEB58983_P_NODE_6663_length_477_cov_7.757426_g6249_i0	PRJEB58983	6663	477	7.757426	37.00292202	Erpetoichthys calabaricus	27687	Chordata	Chordata	132	2.75e-34	NR	XP_051791274.1	27687	g6249	i0	77.8	5.14465408805031	90	19	56	1	78	344	115	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2454	132	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
27847962	27847962	PRJEB58983_P_NODE_21764_length_280_cov_3.173913_g21349_i0	PRJEB58983	21764	280	3.173913	8.8869564	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	56.2	5.35e-7	NR	XP_066287101.1	7740	g21349	i0	37	1.95	92	48	98.6	2	3	278	33	114	XP_066287101.1 large ribosomal subunit protein uL6-like [Branchiostoma lanceolatum]	diamond	546	56.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum
28075786	28075786	PRJEB58983_P_NODE_19505_length_293_cov_0.977273_g19090_i0	PRJEB58983	19505	293	0.977273	2.86340989	Panthera uncia	29064	Chordata	Chordata	46.6	0.00296	NR	XP_049490775.1	29064	g19090	i0	40	0.716723549488055	70	35	68.6	4	62	262	572	637	XP_049490775.1 ubiquilin-4 isoform X1 [Panthera uncia]	diamond	210	46.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Panthera	Panthera uncia
28795107	28795107	PRJEB58983_P_NODE_35607_length_199_cov_4.055556_g35192_i0	PRJEB58983	35607	199	4.055556	8.07055644	Metazoa	33208	Chordata	Chordata	55.1	9.35e-7	NR	XP_039615133.1	55291	g35192	i0	53.8	14.1105527638191	39	16	55.8	1	25	135	74	112	XP_039615133.1 nephronectin a isoform X1 [Polypterus senegalus]	diamond	2808	55.5	0.992792792792793	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
28826683	28826683	PRJEB58983_P_NODE_33248_length_237_cov_2.079268_g32833_i0	PRJEB58983	33248	237	2.079268	4.92786516	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.5	3.21e-4	NR	XP_067980085.1	7769	g32833	i0	42	5	50	26	59.5	1	237	97	205	254	XP_067980085.1 transcription factor E2F8-like isoform X2 [Myxine glutinosa]	diamond	1185	48.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
29875719	29875719	PRJEB58983_P_NODE_15431_length_325_cov_4.607143_g15016_i0	PRJEB58983	15431	325	4.607143	14.97321475	Engystomops pustulosus	76066	Chordata	Chordata	47.4	2.34e-4	NR	KAG8536220.1	76066	g15016	i0	67.9	0.775384615384615	28	9	25.8	0	84	1	43	70	KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus]	diamond	252	47.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
30406343	30406343	PRJEB58983_P_NODE_29333_length_249_cov_1.573864_g28918_i0	PRJEB58983	29333	249	1.573864	3.91892136	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.9	4.68e-6	NR	XP_067886081.1	7792	g28918	i0	38	1.89156626506024	50	31	60.2	0	90	239	1663	1712	XP_067886081.1 proprotein convertase subtilisin/kexin type 5b isoform X2 [Heterodontus francisci]	diamond	471	53.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Heterodontiformes	Heterodontidae	Heterodontus	Heterodontus francisci
31993398	31993398	PRJEB58983_P_NODE_3118_length_700_cov_2.556619_g2727_i0	PRJEB58983	3118	700	2.556619	17.896333	Hypanus sabinus	79690	Chordata	Chordata	72.8	9.09e-11	NR	XP_059816063.1	79690	g2727	i0	37.6	0.934285714285714	109	62	44.6	2	587	276	110	217	XP_059816063.1 uncharacterized protein LOC132387718 [Hypanus sabinus]	diamond	654	72.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
32303346	32303346	PRJEB58983_P_NODE_29359_length_249_cov_1.346591_g28944_i0	PRJEB58983	29359	249	1.346591	3.35301159	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	97.4	1.0399999999999997e-23	NR	XP_029442562.1	194408	g28944	i0	85.4	2.8433734939759	48	7	57.8	0	1	144	12	59	XP_029442562.1 coatomer subunit alpha-like [Rhinatrema bivittatum]	diamond	708	98.2	0.991853360488798	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Rhinatrematidae	Rhinatrema	Rhinatrema bivittatum
32745239	32745239	PRJEB58983_P_NODE_7660_length_447_cov_1.938503_g7246_i0	PRJEB58983	7660	447	1.938503	8.66510841	Metazoa	33208	Chordata	Chordata	45.8	0.0262	NR	XP_014393696.1	109478	g7246	i0	39.4	1.67785234899329	66	30	38.3	3	444	274	418	482	XP_014393696.1 PREDICTED: LOW QUALITY PROTEIN: latent-transforming growth factor beta-binding protein 3 [Myotis brandtii]	diamond	750	46.2	0.991341991341991	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Vespertilionidae	Myotis	Myotis brandtii
32902438	32902438	PRJEB58983_P_NODE_25340_length_263_cov_2.621053_g24925_i0	PRJEB58983	25340	263	2.621053	6.89336939	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	135	3.0599999999999997e-35	NR	XP_033373003.1	9157	g24925	i0	74.7	60.5247148288973	87	22	99.2	0	2	262	408	494	XP_033373003.1 lysine--tRNA ligase isoform X3 [Parus major]	diamond	15918	135	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Paridae	Parus	Parus major

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