metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA782235" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA782235" 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
21166008	21166008	PRJNA782235_P_NODE_26097_length_243_cov_0.905882_g25908_i0	PRJNA782235	26097	243	0.905882	2.20129326	Rangifer tarandus platyrhynchus	3082113	Chordata	Chordata	110	5.29e-29	NR	CAI9168121.1	3082113	g25908	i0	76	0.925925925925926	75	18	92.6	0	243	19	64	138	CAI9168121.1 unnamed protein product [Rangifer tarandus platyrhynchus]	diamond	225	110	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Rangifer	Rangifer tarandus
27590925	27590925	PRJNA782235_P_NODE_21604_length_247_cov_0.885057_g21415_i0	PRJNA782235	21604	247	0.885057	2.18609079	Physeter macrocephalus	9755	Chordata	Chordata	47.4	9.4e-4	NR	XP_054945354.1	9755	g21415	i0	75.9	0.352226720647773	29	7	35.2	0	106	20	175	203	XP_054945354.1 LOW QUALITY PROTEIN: ATP-binding cassette sub-family C member 4-like [Physeter macrocephalus]	diamond	87	47.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Physeteridae	Physeter	Physeter macrocephalus
27938125	27938125	PRJNA782235_P_NODE_25205_length_243_cov_1.752941_g25016_i0	PRJNA782235	25205	243	1.752941	4.25964663	Phyllostomus discolor	89673	Chordata	Chordata	44.7	0.00491	NR	KAF6074951.1	89673	g25016	i0	55.2	0.358024691358025	29	13	35.8	0	139	53	84	112	KAF6074951.1 hypothetical protein HJG60_009361 [Phyllostomus discolor]	diamond	87	44.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Phyllostomidae	Phyllostomus	Phyllostomus discolor
28159274	28159274	PRJNA782235_P_NODE_27985_length_241_cov_0.916667_g27796_i0	PRJNA782235	27985	241	0.916667	2.20916747	Rangifer tarandus platyrhynchus	3082113	Chordata	Chordata	143	9.41e-40	NR	CAI9153848.1	3082113	g27796	i0	87.2	0.970954356846473	78	10	97.1	0	234	1	23	100	CAI9153848.1 unnamed protein product [Rangifer tarandus platyrhynchus]	diamond	234	143	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Rangifer	Rangifer tarandus
28695979	28695979	PRJNA782235_P_NODE_19187_length_249_cov_0.875000_g18998_i0	PRJNA782235	19187	249	0.875	2.17875	Heptranchias perlo	212740	Chordata	Chordata	65.9	2.78e-10	NR	XP_067841360.1	212740	g18998	i0	50.7	1.55421686746988	67	33	80.7	0	235	35	18	84	XP_067841360.1 LOW QUALITY PROTEIN: S-adenosylmethionine-dependent nucleotide dehydratase RSAD2 [Heptranchias perlo]	diamond	387	65.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Hexanchiformes	Hexanchidae	Heptranchias	Heptranchias perlo
30148169	30148169	PRJNA782235_P_NODE_16652_length_251_cov_0.865169_g16463_i0	PRJNA782235	16652	251	0.865169	2.17157419	Crocuta crocuta	9678	Chordata	Chordata	43.5	0.00395	NR	KAF0876186.1	9678	g16463	i0	66.7	0.322709163346614	27	9	32.3	0	31	111	30	56	KAF0876186.1 LORF2 protein, partial [Crocuta crocuta]	diamond	81	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Hyaenidae	Crocuta	Crocuta crocuta
30316208	30316208	PRJNA782235_P_NODE_26052_length_243_cov_0.905882_g25863_i0	PRJNA782235	26052	243	0.905882	2.20129326	Artiodactyla	91561	Chordata	Chordata	51.6	5.64e-6	NR	KAJ1063486.1	9925	g25863	i0	45.7	1.76543209876543	70	37	85.2	1	31	237	32	101	KAJ1063486.1 hypothetical protein K5549_021639, partial [Capra hircus]	diamond	429	52	0.992307692307692	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Capra	Capra hircus
30748739	30748739	PRJNA782235_P_NODE_23334_length_245_cov_0.895349_g23145_i0	PRJNA782235	23334	245	0.895349	2.19360505	Rangifer tarandus platyrhynchus	3082113	Chordata	Chordata	58.2	1.32e-7	NR	CAI9152427.1	3082113	g23145	i0	93.5	0.759183673469388	31	2	38	0	4	96	337	367	CAI9152427.1 unnamed protein product [Rangifer tarandus platyrhynchus]	diamond	186	58.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Rangifer	Rangifer tarandus
31231781	31231781	PRJNA782235_P_NODE_24815_length_244_cov_0.900585_g24626_i0	PRJNA782235	24815	244	0.900585	2.1974274	Metazoa	33208	Chordata	Chordata	43.9	0.0141	NR	XP_019335264.1	8496	g24626	i0	37	1.99180327868852	54	34	66.4	0	6	167	146	199	XP_019335264.1 tigger transposable element-derived protein 1-like [Alligator mississippiensis]	diamond	486	44.3	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Chordata		Crocodylia	Alligatoridae	Alligator	Alligator mississippiensis
31317509	31317509	PRJNA782235_P_NODE_14095_length_263_cov_2.115789_g13906_i0	PRJNA782235	14095	263	2.115789	5.56452507	Cyrtonyx montezumae	9017	Chordata	Chordata	62	8.05e-9	NR	XP_065609848.1	9017	g13906	i0	67.7	0.707224334600761	62	15	67.3	2	3	179	1219	1278	XP_065609848.1 LOW QUALITY PROTEIN: tensin-2-like [Cyrtonyx montezumae]	diamond	186	62	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Odontophoridae	Cyrtonyx	Cyrtonyx montezumae

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