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

7 rows where analysis = "diamond", bioproject = "PRJNA656952" 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
22299692	22299692	PRJNA656952_P_NODE_36098_length_247_cov_0.885057_g35911_i0	PRJNA656952	36098	247	0.885057	2.18609079	Metazoa	33208	Chordata	Chordata	85.5	1.88e-17	NR	PKK31288.1	8932	g35911	i0	59.7	38.502024291498	67	26	81.4	1	3	203	196	261	PKK31288.1 calpain 3 [Columba livia]	diamond	9510	86.3	0.990730011587486	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Columbiformes	Columbidae	Columba	Columba livia
26745101	26745101	PRJNA656952_P_NODE_36561_length_247_cov_0.885057_g36374_i0	PRJNA656952	36561	247	0.885057	2.18609079	Chordata	7711	Chordata	Chordata	78.2	1.01e-14	NR	POI28313.1	9083	g36374	i0	69.2	49.1781376518219	52	16	63.2	0	239	84	313	364	POI28313.1 hypothetical protein CIB84_007936 [Bambusicola thoracicus]	diamond	12147	78.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Bambusicola	Bambusicola thoracicus
26764803	26764803	PRJNA656952_P_NODE_25561_length_276_cov_0.837438_g25374_i0	PRJNA656952	25561	276	0.837438	2.31132888	Engystomops pustulosus	76066	Chordata	Chordata	67	2.05e-12	NR	KAG8588135.1	76066	g25374	i0	63.6	0.597826086956522	55	18	57.6	1	10	168	7	61	KAG8588135.1 hypothetical protein GDO81_005883 [Engystomops pustulosus]	diamond	165	67	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
27725783	27725783	PRJNA656952_P_NODE_35504_length_248_cov_0.880000_g35317_i0	PRJNA656952	35504	248	0.88	2.1824	Opisthokonta	33154	Chordata	Chordata	48.1	2.06e-4	NR	EDL83200.1	10116	g35317	i0	58.1	6.14516129032258	31	13	37.5	0	244	152	128	158	EDL83200.1 similar to Zinc finger protein OZF (POZF-1), partial [Rattus norvegicus]	diamond	1524	48.5	0.991752577319588	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus
28628994	28628994	PRJNA656952_P_NODE_30387_length_253_cov_2.222222_g30200_i0	PRJNA656952	30387	253	2.222222	5.62222166	Rangifer tarandus platyrhynchus	3082113	Chordata	Chordata	42	0.0452	NR	CAI9180670.1	3082113	g30200	i0	31.6	0.936758893280632	79	50	92.5	2	253	20	42	117	CAI9180670.1 unnamed protein product [Rangifer tarandus platyrhynchus]	diamond	237	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Rangifer	Rangifer tarandus
29670376	29670376	PRJNA656952_P_NODE_43790_length_241_cov_0.916667_g43603_i0	PRJNA656952	43790	241	0.916667	2.20916747	Polypterus senegalus	55291	Chordata	Chordata	45.4	0.00419	NR	XP_039597292.1	55291	g43603	i0	69	4.18257261410788	29	9	36.1	0	219	133	958	986	XP_039597292.1 zinc finger protein 62 homolog [Polypterus senegalus]	diamond	1008	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
30567181	30567181	PRJNA656952_P_NODE_2193_length_679_cov_1.156766_g2046_i0	PRJNA656952	2193	679	1.156766	7.85444114	root	1	Root_unresolved	Root_unresolved	468	2.2999999999999992e-161	NR	XP_030110853.2	10090	g2046	i0	99.1	10.9484536082474	226	2	99.9	0	678	1	91	316	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	7434	471	0.993630573248408	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus

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