metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA902848" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA902848" 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
3432859	3432859	PRJNA902848_P_NODE_8143_length_309_cov_1.830508_g8093_i0	PRJNA902848	8143	309	1.830508	5.65626972	Chordata	7711	Chordata	Chordata	183	3.48e-57	NR	XP_025866826.1	9627	g8093	i0	81.4	69.9708737864078	102	19	99	0	306	1	1	102	XP_025866826.1 ras-related C3 botulinum toxin substrate 2 [Vulpes vulpes]	diamond	21621	184	0.994565217391304	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Vulpes	Vulpes vulpes
7625132	7625132	PRJNA902848_P_NODE_3286_length_435_cov_2.541436_g3236_i0	PRJNA902848	3286	435	2.541436	11.0552466	root	1	Root_unresolved	Root_unresolved	200	1.62e-63	NR	XP_015706664.1	93934	g3236	i0	75.9	1.64827586206897	116	27	79.3	1	2	346	17	132	XP_015706664.1 vitelline membrane outer layer protein 1 homolog [Coturnix japonica]	diamond	717	200	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Coturnix	Coturnix japonica
11085440	11085440	PRJNA902848_P_NODE_10269_length_281_cov_2.230769_g10219_i0	PRJNA902848	10269	281	2.230769	6.26846089	Branchiostoma	7737	Chordata	Chordata	143	9.23e-41	NR	XP_035658935.1	7739	g10219	i0	74.2	4.8576512455516	93	24	99.3	0	2	280	39	131	XP_035658935.1 40S ribosomal protein S8-like [Branchiostoma floridae]	diamond	1365	143	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma floridae
27853065	27853065	PRJNA902848_P_NODE_18364_length_245_cov_0.906977_g18314_i0	PRJNA902848	18364	245	0.906977	2.22209365	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	86.3	1.85e-17	NR	XP_009860924.1	7719	g18314	i0	53.8	6.86938775510204	80	37	98	0	6	245	115	194	XP_009860924.1 structural maintenance of chromosomes protein 1A [Ciona intestinalis]	diamond	1683	86.7	0.995386389850058	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis
32585344	32585344	PRJNA902848_P_NODE_11999_length_262_cov_5.529101_g11949_i0	PRJNA902848	11999	262	5.529101	14.48624462	Lethenteron reissneri	7753	Chordata	Chordata	52.4	1.2e-6	NR	XP_061416355.1	7753	g11949	i0	41.5	2.20992366412214	65	36	74.4	1	222	28	12	74	XP_061416355.1 calmodulin-like protein 5 [Lethenteron reissneri]	diamond	579	52.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
32876045	32876045	PRJNA902848_P_NODE_18360_length_245_cov_0.906977_g18310_i0	PRJNA902848	18360	245	0.906977	2.22209365	Aves	8782	Chordata	Chordata	68.9	1.7e-11	NR	XP_069634053.1	8969	g18310	i0	47.5	1.84897959183673	80	36	93.1	3	231	4	145	222	XP_069634053.1 urokinase plasminogen activator surface receptor-like [Haliaeetus albicilla]	diamond	453	69.3	0.994227994227994	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Accipitriformes	Accipitridae	Haliaeetus	Haliaeetus albicilla
32907496	32907496	PRJNA902848_P_NODE_4320_length_392_cov_1.272727_g4270_i0	PRJNA902848	4320	392	1.272727	4.98908984	Chordata	7711	Chordata	Chordata	122	2.0699999999999998e-32	NR	KAJ1118367.1	8319	g4270	i0	50	17.9234693877551	122	61	93.4	0	371	6	37	158	KAJ1118367.1 hypothetical protein NDU88_006558 [Pleurodeles waltl]	diamond	7026	123	0.991869918699187	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl

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