metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1218816" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1218816" 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
6711326	6711326	PRJNA1218816_P_NODE_59726_length_244_cov_1.801170_g59293_i0	PRJNA1218816	59726	244	1.80117	4.3948548	Metazoa	33208	Chordata	Chordata	84.7	6.03e-19	NR	XP_005996654.1	7897	g59293	i0	58.5	6.03688524590164	65	27	79.9	0	197	3	10	74	XP_005996654.1 large ribosomal subunit protein eL22 isoform X3 [Latimeria chalumnae]	diamond	1473	85.5	0.990643274853801	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
15073875	15073875	PRJNA1218816_P_NODE_60092_length_244_cov_0.900585_g59659_i0	PRJNA1218816	60092	244	0.900585	2.1974274	Polypterus senegalus	55291	Chordata	Chordata	75.1	1e-13	NR	KAG2466795.1	55291	g59659	i0	61.5	0.639344262295082	52	20	63.9	0	2	157	243	294	KAG2466795.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	156	75.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
23285630	23285630	PRJNA1218816_P_NODE_43079_length_291_cov_1.871560_g42646_i0	PRJNA1218816	43079	291	1.87156	5.4462396	Metazoa	33208	Chordata	Chordata	142	3.15e-39	NR	XP_019622626.1	7741	g42646	i0	73.7	8.81443298969072	95	25	97.9	0	287	3	89	183	XP_019622626.1 PREDICTED: 60S acidic ribosomal protein P0-like [Branchiostoma belcheri]	diamond	2565	142	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
29946440	29946440	PRJNA1218816_P_NODE_57751_length_247_cov_0.885057_g57318_i0	PRJNA1218816	57751	247	0.885057	2.18609079	Pristiophorus japonicus	55135	Chordata	Chordata	62.4	4.64e-9	NR	XP_070722277.1	55135	g57318	i0	49.2	5.80566801619433	63	31	75.3	1	25	210	450	512	XP_070722277.1 poly(ADP-ribose) glycohydrolase-like [Pristiophorus japonicus]	diamond	1434	62.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes		Pristiophoridae	Pristiophorus	Pristiophorus japonicus
30122968	30122968	PRJNA1218816_P_NODE_62752_length_241_cov_0.916667_g62319_i0	PRJNA1218816	62752	241	0.916667	2.20916747	Metazoa	33208	Chordata	Chordata	47.8	6.27e-4	NR	XP_019614942.1	7741	g62319	i0	43.5	2.04149377593361	46	25	57.3	1	4	141	468	512	XP_019614942.1 PREDICTED: GTP-binding protein 1-like isoform X2 [Branchiostoma belcheri]	diamond	492	48.1	0.993762993762994	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
31988044	31988044	PRJNA1218816_P_NODE_38638_length_312_cov_1.531381_g38205_i0	PRJNA1218816	38638	312	1.531381	4.77790872	Opisthokonta	33154	Chordata	Chordata	86.3	2.76e-19	NR	XP_018421159.1	125878	g38205	i0	66.7	3.55769230769231	72	21	69.2	1	292	77	1	69	XP_018421159.1 PREDICTED: 60S acidic ribosomal protein P2-like [Nanorana parkeri]	diamond	1110	86.7	0.995386389850058	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dicroglossidae	Nanorana	Nanorana parkeri
32159306	32159306	PRJNA1218816_P_NODE_35738_length_328_cov_1.811765_g35305_i0	PRJNA1218816	35738	328	1.811765	5.9425892	Clavelina lepadiformis	159417	Chordata	Chordata	134	9.56e-38	NR	CAK8697013.1	159417	g35305	i0	56	0.996951219512195	109	48	99.7	0	2	328	3	111	CAK8697013.1 unnamed protein product [Clavelina lepadiformis]	diamond	327	134	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Aplousobranchia	Clavelinidae	Clavelina	Clavelina lepadiformis
32557911	32557911	PRJNA1218816_P_NODE_62919_length_241_cov_0.916667_g62486_i0	PRJNA1218816	62919	241	0.916667	2.20916747	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47.8	6.46e-4	NR	DAA26857.1	9913	g62486	i0	40.2	4.84232365145228	82	47	99.6	1	240	1	1044	1125	DAA26857.1 TPA: proprotein convertase subtilisin/kexin type 5 [Bos taurus]	diamond	1167	48.1	0.993762993762994	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
32696291	32696291	PRJNA1218816_P_NODE_28480_length_382_cov_0.996764_g28047_i0	PRJNA1218816	28480	382	0.996764	3.80763848	Xenopus laevis	8355	Chordata	Chordata	58.5	5.54e-7	NR	AAW83026.1	8355	g28047	i0	36.5	2.86649214659686	85	48	64.4	3	92	337	971	1052	AAW83026.1 proprotein convertase 6C [Xenopus laevis]	diamond	1095	58.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis

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