metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA380660" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA380660" 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
2952875	2952875	PRJNA380660_P_NODE_10143_length_205_cov_1.738636_g9743_i0	PRJNA380660	10143	205	1.738636	3.5642038	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	85.5	5.68e-19	NR	XP_003221845.1	28377	g9743	i0	62.1	11.0341463414634	66	25	96.6	0	1	198	16	81	XP_003221845.1 uncharacterized protein LOC100564988 [Anolis carolinensis]	diamond	2262	85.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Dactyloidae	Anolis	Anolis carolinensis
27186678	27186678	PRJNA380660_P_NODE_7802_length_253_cov_2.964286_g7402_i0	PRJNA380660	7802	253	2.964286	7.49964358	Opisthokonta	33154	Chordata	Chordata	82.4	4.7e-16	NR	KAG8541826.1	76066	g7402	i0	60.3	26.7272727272727	68	27	80.6	0	46	249	206	273	KAG8541826.1 hypothetical protein GDO81_028185 [Engystomops pustulosus]	diamond	6762	82.8	0.995169082125604	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
29853949	29853949	PRJNA380660_P_NODE_6691_length_288_cov_1.938224_g6291_i0	PRJNA380660	6691	288	1.938224	5.58208512	Leptosomus discolor	188344	Chordata	Chordata	60.5	1.15e-8	NR	XP_009959597.1	188344	g6291	i0	78.4	58.46875	37	8	38.5	0	141	31	138	174	XP_009959597.1 PREDICTED: polyadenylate-binding protein 1, partial [Leptosomus discolor]	diamond	16839	60.8	0.995065789473684	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Coraciiformes	Leptosomidae	Leptosomus	Leptosomus discolor
31102962	31102962	PRJNA380660_P_NODE_895_length_921_cov_6.352018_g674_i0	PRJNA380660	895	921	6.352018	58.50208578	Chordata	7711	Chordata	Chordata	263	2.28e-81	NR	NP_001080167.1	8355	g674	i0	46.2	36.8241042345277	305	130	99.3	5	917	3	138	408	NP_001080167.1 ornithine decarboxylase 1 [Xenopus laevis]	diamond	33915	263	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
31514417	31514417	PRJNA380660_P_NODE_1736_length_644_cov_3.227642_g674_i1	PRJNA380660	1736	644	3.227642	20.78601448	Opisthokonta	33154	Chordata	Chordata	164	2.03e-44	NR	NP_001396552.1	10090	g674	i1	50.3	23.4316770186335	167	76	77.8	2	5	505	138	297	NP_001396552.1 ornithine decarboxylase isoform 1 [Mus musculus]	diamond	15090	165	0.993939393939394	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
32621109	32621109	PRJNA380660_P_NODE_3780_length_421_cov_1.938776_g3391_i0	PRJNA380660	3780	421	1.938776	8.16224696	Chordata	7711	Chordata	Chordata	56.6	3.28e-6	NR	XP_064355673.1	8790	g3391	i0	32.2	3.84085510688836	90	49	57.7	3	28	270	166	252	XP_064355673.1 epididymal sperm-binding protein 1-like [Dromaius novaehollandiae]	diamond	1617	56.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Casuariiformes	Dromaiidae	Dromaius	Dromaius novaehollandiae

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