metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax_kingdom = "Metazoa"

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
26794069	26794069	PRJNA557436_S_NODE_421_length_537_cov_2.386454_g379_i0	PRJNA557436	421	537	2.386454	12.81525798	Gnathostoma spinigerum	75299	Nematoda	Nematoda	141	1.4099999999999999e-40	NR	MFH4985130.1	75299	g379	i0	91	0.374301675977654	67	6	37.4	0	253	53	1	67	MFH4985130.1 hypothetical protein [Gnathostoma spinigerum]	diamond	201	141	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
28089451	28089451	PRJNA557436_S_NODE_4125_length_197_cov_2.530864_g4077_i0	PRJNA557436	4125	197	2.530864	4.98580208	Rangifer tarandus platyrhynchus	3082113	Chordata	Chordata	54.3	1.68e-6	NR	CAI9150999.1	3082113	g4077	i0	96.6	0.441624365482233	29	1	44.2	0	1	87	501	529	CAI9150999.1 unnamed protein product, partial [Rangifer tarandus platyrhynchus]	diamond	87	54.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Rangifer	Rangifer tarandus
29226452	29226452	PRJNA557436_S_NODE_4729_length_187_cov_2.440789_g4681_i0	PRJNA557436	4729	187	2.440789	4.56427543	Pararge aegeria aegeria	348720	Arthropoda	Arthropoda	40.8	0.0333	NR	CAH2246697.1	348720	g4681	i0	32.3	0.994652406417112	62	39	94.7	1	10	186	38	99	CAH2246697.1 jg3536 [Pararge aegeria aegeria]	diamond	186	40.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Pararge	Pararge aegeria
31135252	31135252	PRJNA557436_S_NODE_6375_length_169_cov_2.074627_g6327_i0	PRJNA557436	6375	169	2.074627	3.50611963	root	1	Root_unresolved	Root_unresolved	70.5	2.19e-12	NR	KOC58562.1	597456	g6327	i0	61.1	5.48520710059172	54	21	95.9	0	3	164	915	968	KOC58562.1 Uncharacterized protein yejH [Habropoda laboriosa]	diamond	927	70.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Habropoda	Habropoda laboriosa
32527709	32527709	PRJNA557436_S_NODE_3519_length_209_cov_5.051724_g3471_i0	PRJNA557436	3519	209	5.051724	10.55810316	Artiodactyla	91561	Chordata	Chordata	47.4	5.67e-4	NR	XP_069396403.1	9728	g3471	i0	70.3	2.32535885167464	37	10	53.1	1	140	30	115	150	XP_069396403.1 collagen alpha-1(I) chain-like, partial [Delphinus delphis]	diamond	486	47.8	0.99163179916318	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Delphinus	Delphinus delphis

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