metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA658591" 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
30598964	30598964	PRJNA658591_S_NODE_2513_length_270_cov_2.932127_g2450_i0	PRJNA658591	2513	270	2.932127	7.9167429	root	1	Root_unresolved	Root_unresolved	107	2.45e-26	NR	XP_051712873.2	9986	g2450	i0	64.8	37.8888888888889	88	27	95.6	2	12	269	111	196	XP_051712873.2 large ribosomal subunit protein eL22 isoform X2 [Oryctolagus cuniculus]	diamond	10230	107	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Lagomorpha	Leporidae	Oryctolagus	Oryctolagus cuniculus
30618386	30618386	PRJNA658591_S_NODE_8853_length_169_cov_0.866667_g8790_i0	PRJNA658591	8853	169	0.866667	1.46466723	Ranitomeya imitator	111125	Chordata	Chordata	59.7	9.52e-10	NR	XP_069586114.1	111125	g8790	i0	51.9	0.958579881656805	54	23	95.9	1	164	3	22	72	XP_069586114.1 COX assembly mitochondrial protein homolog [Ranitomeya imitator]	diamond	162	59.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
31123672	31123672	PRJNA658591_S_NODE_5575_length_199_cov_2.193333_g5512_i0	PRJNA658591	5575	199	2.193333	4.36473267	Ciona intestinalis	7719	Chordata	Chordata	70.9	2.55e-12	NR	XP_002120963.1	7719	g5512	i0	60	0.678391959798995	45	18	67.8	0	34	168	565	609	XP_002120963.1 alpha-amylase 2-like [Ciona intestinalis]	diamond	135	70.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis
31325871	31325871	PRJNA658591_S_NODE_7015_length_183_cov_1.216418_g6952_i0	PRJNA658591	7015	183	1.216418	2.22604494	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	97.1	1.85e-24	NR	XP_053557215.1	8345	g6952	i0	78.3	3.91803278688525	60	13	98.4	0	2	181	5	64	XP_053557215.1 succinyl-CoA:3-ketoacid coenzyme A transferase 1, mitochondrial-like [Bombina bombina]	diamond	717	97.8	0.992842535787321	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
32009648	32009648	PRJNA658591_S_NODE_6498_length_188_cov_2.230216_g6435_i0	PRJNA658591	6498	188	2.230216	4.19280608	Erpetoichthys calabaricus	27687	Chordata	Chordata	66.6	5.46e-11	NR	XP_051791274.1	27687	g6435	i0	71.4	4.69148936170213	49	13	76.6	1	167	24	156	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	882	67	0.994029850746269	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus

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