metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1198392" 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
7978186	7978186	PRJNA1198392_P_NODE_9147_length_286_cov_1.446009_g9006_i0	PRJNA1198392	9147	286	1.446009	4.13558574	root	1	Root_unresolved	Root_unresolved	139	7.949999999999999e-40	NR	XP_012370101.1	10160	g9006	i0	61.3	54.6083916083916	93	36	97.6	0	284	6	47	139	XP_012370101.1 40S ribosomal protein S4-like [Octodon degus]	diamond	15618	140	0.992857142857143	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Octodontidae	Octodon	Octodon degus
26870269	26870269	PRJNA1198392_P_NODE_6061_length_328_cov_1.447059_g5920_i0	PRJNA1198392	6061	328	1.447059	4.74635352	root	1	Root_unresolved	Root_unresolved	234	2.6099999999999997e-72	NR	XP_030110853.2	10090	g5920	i0	100	15.9512195121951	109	0	99.7	0	327	1	149	257	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	5232	234	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
27059819	27059819	PRJNA1198392_P_NODE_21542_length_239_cov_2.409639_g21401_i0	PRJNA1198392	21542	239	2.409639	5.75903721	Branchiostoma	7737	Chordata	Chordata	60.5	4.97e-9	NR	XP_035697557.1	7739	g21401	i0	46	2.4979079497908	63	33	77.8	1	188	3	23	85	XP_035697557.1 uncharacterized protein LOC118430675 [Branchiostoma floridae]	diamond	597	60.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma floridae
27186070	27186070	PRJNA1198392_P_NODE_16862_length_249_cov_0.875000_g16721_i0	PRJNA1198392	16862	249	0.875	2.17875	Chondrichthyes	7777	Chordata	Chordata	110	2.82e-28	NR	NP_001279380.1	7868	g16721	i0	61.6	7.96385542168675	73	28	88	0	28	246	114	186	NP_001279380.1 cysteine and glycine-rich protein 1a [Callorhinchus milii]	diamond	1983	110	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Chimaeriformes	Callorhinchidae	Callorhinchus	Callorhinchus milii
29724801	29724801	PRJNA1198392_P_NODE_21650_length_235_cov_2.413580_g21509_i0	PRJNA1198392	21650	235	2.41358	5.671913	Erpetoichthys calabaricus	27687	Chordata	Chordata	70.1	2.1e-13	NR	XP_028680108.2	27687	g21509	i0	42.9	0.982978723404255	77	44	98.3	0	232	2	5	81	XP_028680108.2 MORN repeat-containing protein 3-like [Erpetoichthys calabaricus]	diamond	231	70.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
30135378	30135378	PRJNA1198392_P_NODE_14152_length_260_cov_3.080214_g14011_i0	PRJNA1198392	14152	260	3.080214	8.0085564	Staurois parvus	386267	Chordata	Chordata	77.8	2.23e-16	NR	CAI9618505.1	386267	g14011	i0	43.2	1.01538461538462	88	45	98.1	2	6	260	2	87	CAI9618505.1 unnamed protein product, partial [Staurois parvus]	diamond	264	77.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
30723273	30723273	PRJNA1198392_P_NODE_8254_length_290_cov_1.419355_g8113_i0	PRJNA1198392	8254	290	1.419355	4.1161295	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	101	1.8000000000000001e-22	NR	KAI8478444.1	7741	g8113	i0	67.9	34.3034482758621	81	26	83.8	0	251	9	818	898	KAI8478444.1 Ubiquitin-like modifier-activating enzyme 6, partial [Branchiostoma belcheri]	diamond	9948	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
32526278	32526278	PRJNA1198392_P_NODE_18759_length_246_cov_0.890173_g18618_i0	PRJNA1198392	18759	246	0.890173	2.18982558	Chordata	7711	Chordata	Chordata	105	1.23e-24	NR	KAJ1096059.1	8319	g18618	i0	69.6	72.3292682926829	69	21	84.1	0	244	38	301	369	KAJ1096059.1 hypothetical protein NDU88_001206 [Pleurodeles waltl]	diamond	17793	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
32727776	32727776	PRJNA1198392_P_NODE_14160_length_260_cov_2.588235_g14019_i0	PRJNA1198392	14160	260	2.588235	6.729411	Ambystoma mexicanum	8296	Chordata	Chordata	97.1	2.98e-21	NR	XP_069510199.1	8296	g14019	i0	59.4	1.67307692307692	64	25	72.7	1	42	230	99	162	XP_069510199.1 sequestosome-1 [Ambystoma mexicanum]	diamond	435	97.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Ambystomatidae	Ambystoma	Ambystoma mexicanum
32853573	32853573	PRJNA1198392_P_NODE_15380_length_253_cov_1.366667_g15239_i0	PRJNA1198392	15380	253	1.366667	3.45766751	Crocuta crocuta	9678	Chordata	Chordata	47	4.72e-4	NR	KAF0870498.1	9678	g15239	i0	51.2	1.22134387351779	43	19	49.8	2	129	4	1	42	KAF0870498.1 LORF2 protein, partial [Crocuta crocuta]	diamond	309	47	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Hyaenidae	Crocuta	Crocuta crocuta

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