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

8 rows where analysis = "diamond", bioproject = "PRJNA596867" 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
28090429	28090429	PRJNA596867_P_NODE_10765_length_257_cov_1.744565_g10690_i0	PRJNA596867	10765	257	1.744565	4.48353205	Polypterus senegalus	55291	Chordata	Chordata	55.8	1.09e-6	NR	MBN3294582.1	55291	g10690	i0	37.9	3.07003891050584	87	51	99.2	2	255	1	971	1056	MBN3294582.1 LORF2 protein [Polypterus senegalus]	diamond	789	56.2	0.99288256227758	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
28469574	28469574	PRJNA596867_P_NODE_15206_length_241_cov_0.916667_g15131_i0	PRJNA596867	15206	241	0.916667	2.20916747	Staurois parvus	386267	Chordata	Chordata	70.5	1.56e-12	NR	CAI9610165.1	386267	g15131	i0	89.2	12.7344398340249	37	4	46.1	0	98	208	5	41	CAI9610165.1 unnamed protein product, partial [Staurois parvus]	diamond	3069	71.2	0.990168539325843	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
29082782	29082782	PRJNA596867_P_NODE_15088_length_241_cov_0.916667_g15013_i0	PRJNA596867	15088	241	0.916667	2.20916747	Chordata	7711	Chordata	Chordata	166	1.47e-45	NR	KAG5214554.1	9940	g15013	i0	98.8	50.7883817427386	80	1	99.6	0	240	1	238	317	KAG5214554.1 hypothetical protein JEQ12_000130 [Ovis aries]	diamond	12240	166	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
29511200	29511200	PRJNA596867_P_NODE_7370_length_302_cov_0.925764_g7295_i0	PRJNA596867	7370	302	0.925764	2.79580728	Lepus europaeus	9983	Chordata	Chordata	44.3	0.0203	NR	XP_062033643.1	9983	g7295	i0	47.8	0.456953642384106	46	23	44.7	1	4	138	151	196	XP_062033643.1 protein fuzzy homolog isoform X1 [Lepus europaeus]	diamond	138	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Lagomorpha	Leporidae	Lepus	Lepus europaeus
29985067	29985067	PRJNA596867_P_NODE_13931_length_244_cov_0.900585_g13856_i0	PRJNA596867	13931	244	0.900585	2.1974274	Mesocricetus auratus	10036	Chordata	Chordata	42.7	0.0364	NR	XP_040589295.1	10036	g13856	i0	46.2	0.479508196721311	39	21	48	0	202	86	174	212	XP_040589295.1 LOW QUALITY PROTEIN: mas-related G-protein coupled receptor member B2-like [Mesocricetus auratus]	diamond	117	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Mesocricetus	Mesocricetus auratus
30679904	30679904	PRJNA596867_P_NODE_13513_length_245_cov_0.895349_g13438_i0	PRJNA596867	13513	245	0.895349	2.19360505	Cnephaeus nilssonii	3371016	Chordata	Chordata	48.1	4.6e-4	NR	KAK1336725.1	3371016	g13438	i0	91.7	0.575510204081633	24	2	29.4	0	76	5	280	303	KAK1336725.1 hypothetical protein QTO34_002760 [Cnephaeus nilssonii]	diamond	141	48.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Vespertilionidae	Cnephaeus	Cnephaeus nilssonii
31628404	31628404	PRJNA596867_P_NODE_10916_length_256_cov_0.912568_g10841_i0	PRJNA596867	10916	256	0.912568	2.33617408	Polypterus senegalus	55291	Chordata	Chordata	124	8.76e-31	NR	MBN3294582.1	55291	g10841	i0	75	2.953125	84	21	98.4	0	254	3	527	610	MBN3294582.1 LORF2 protein [Polypterus senegalus]	diamond	756	124	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
32609038	32609038	PRJNA596867_P_NODE_9680_length_270_cov_2.319797_g9605_i0	PRJNA596867	9680	270	2.319797	6.2634519	Amblyraja radiata	386614	Chordata	Chordata	47	0.00172	NR	XP_032886880.1	386614	g9605	i0	51.9	2.37777777777778	54	19	52.2	2	22	162	351	404	XP_032886880.1 LOW QUALITY PROTEIN: uncharacterized protein LOC116979475, partial [Amblyraja radiata]	diamond	642	47	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Amblyraja	Amblyraja radiata

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