metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA785164" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA785164" 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
28452694	28452694	PRJNA785164_P_NODE_39866_length_285_cov_2.533019_g39401_i0	PRJNA785164	39866	285	2.533019	7.21910415	root	1	Root_unresolved	Root_unresolved	192	2.81e-57	NR	6ZQK_A	10090	g39401	i0	100	9.89473684210526	94	0	98.9	0	3	284	151	244	6ZQK_A Chain A, heavy chain [Mus musculus]	diamond	2820	192	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
28799618	28799618	PRJNA785164_P_NODE_57127_length_245_cov_1.732558_g56662_i0	PRJNA785164	57127	245	1.732558	4.2447671	root	1	Root_unresolved	Root_unresolved	48.5	3.37e-4	NR	KAK9399344.1	8729	g56662	i0	32.9	4.02857142857143	82	53	98	2	243	4	133	214	KAK9399344.1 F-box/LRR-repeat protein 13-like [Crotalus adamanteus]	diamond	987	48.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Viperidae	Crotalus	Crotalus adamanteus
29526129	29526129	PRJNA785164_P_NODE_53370_length_249_cov_0.875000_g52905_i0	PRJNA785164	53370	249	0.875	2.17875	Rodentia	9989	Chordata	Chordata	100	1.47e-22	NR	NP_001153420.2	10090	g52905	i0	98.1	9.74698795180723	52	1	62.7	0	94	249	660	711	NP_001153420.2 alsin isoform 1 [Mus musculus]	diamond	2427	100	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
29611209	29611209	PRJNA785164_P_NODE_60970_length_242_cov_0.911243_g60505_i0	PRJNA785164	60970	242	0.911243	2.20520806	Alectoris rufa	9079	Chordata	Chordata	44.3	0.0104	NR	CAK6567603.1	9079	g60505	i0	56.7	0.371900826446281	30	13	37.2	0	153	242	486	515	CAK6567603.1 unnamed protein product [Alectoris rufa]	diamond	90	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Alectoris	Alectoris rufa
29990534	29990534	PRJNA785164_P_NODE_52711_length_250_cov_0.870056_g52246_i0	PRJNA785164	52711	250	0.870056	2.17514	Ovis ammon polii x Ovis aries	2918886	Chordata	Chordata	45.4	0.00358	NR	KAI4551542.1	2918886	g52246	i0	50	0.504	42	21	50.4	0	146	21	185	226	KAI4551542.1 hypothetical protein MJT46_017794 [Ovis ammon polii x Ovis aries]	diamond	126	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis ammon polii x Ovis aries
30852785	30852785	PRJNA785164_P_NODE_52214_length_250_cov_0.870056_g51749_i0	PRJNA785164	52214	250	0.870056	2.17514	Metazoa	33208	Chordata	Chordata	89.4	1.18e-18	NR	XP_004402094.1	9708	g51749	i0	54.9	14.316	82	37	98.4	0	2	247	328	409	XP_004402094.1 PREDICTED: GMP reductase 2 isoform X1 [Odobenus rosmarus divergens]	diamond	3579	89.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Odobenidae	Odobenus	Odobenus rosmarus
31127525	31127525	PRJNA785164_P_NODE_30595_length_330_cov_3.124514_g30130_i0	PRJNA785164	30595	330	3.124514	10.3108962	Hypanus sabinus	79690	Chordata	Chordata	60.8	4.61e-8	NR	XP_059823631.1	79690	g30130	i0	46	0.454545454545455	50	27	45.5	0	118	267	558	607	XP_059823631.1 IQ calmodulin-binding motif-containing protein 1 isoform X1 [Hypanus sabinus]	diamond	150	60.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
31602433	31602433	PRJNA785164_P_NODE_27516_length_351_cov_1.107914_g27051_i0	PRJNA785164	27516	351	1.107914	3.88877814	Staurois parvus	386267	Chordata	Chordata	53.5	2.55e-6	NR	CAI9557087.1	386267	g27051	i0	63.9	0.615384615384615	36	11	29.1	1	151	50	24	59	CAI9557087.1 unnamed protein product, partial [Staurois parvus]	diamond	216	53.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus

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