metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA688352" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA688352" 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
19028446	19028446	PRJNA688352_P_NODE_3495_length_333_cov_2.207692_g3392_i0	PRJNA688352	3495	333	2.207692	7.35161436	root	1	Root_unresolved	Root_unresolved	216	7.34e-64	NR	XP_030109804.2	10090	g3392	i0	95.5	12.981981981982	111	5	100	0	333	1	69	179	XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus]	diamond	4323	218	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
27018968	27018968	PRJNA688352_P_NODE_2302_length_396_cov_2.275542_g2199_i0	PRJNA688352	2302	396	2.275542	9.01114632	Staurois parvus	386267	Chordata	Chordata	57.4	1.47e-7	NR	CAI9533415.1	386267	g2199	i0	40	3.14393939393939	110	47	68.9	4	294	22	1	110	CAI9533415.1 unnamed protein product [Staurois parvus]	diamond	1245	57.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
27240189	27240189	PRJNA688352_P_NODE_7063_length_251_cov_0.865169_g6960_i0	PRJNA688352	7063	251	0.865169	2.17157419	Euphydryas editha	104508	Arthropoda	Arthropoda	44.3	0.0121	NR	CAH2084649.1	104508	g6960	i0	35.3	3.19123505976096	51	33	61	0	3	155	296	346	CAH2084649.1 unnamed protein product [Euphydryas editha]	diamond	801	44.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Euphydryas	Euphydryas editha
27567643	27567643	PRJNA688352_P_NODE_12084_length_241_cov_0.916667_g11981_i0	PRJNA688352	12084	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	43.5	0.0201	NR	CAH1268004.1	7740	g11981	i0	33.8	2.09128630705394	74	47	89.6	1	217	2	431	504	CAH1268004.1 FAM160A1 [Branchiostoma lanceolatum]	diamond	504	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum
29892886	29892886	PRJNA688352_P_NODE_10211_length_245_cov_0.895349_g10108_i0	PRJNA688352	10211	245	0.895349	2.19360505	Cordylochernes scorpioides	51811	Arthropoda	Arthropoda	41.2	0.0178	NR	UYV63843.1	51811	g10108	i0	48.4	0.379591836734694	31	16	38	0	205	113	15	45	UYV63843.1 hypothetical protein LAZ67_2005794 [Cordylochernes scorpioides]	diamond	93	41.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Pseudoscorpiones	Chernetidae	Cordylochernes	Cordylochernes scorpioides
30461822	30461822	PRJNA688352_P_NODE_2013_length_418_cov_2.744928_g1910_i0	PRJNA688352	2013	418	2.744928	11.47379904	Erpetoichthys calabaricus	27687	Chordata	Chordata	89	5.83e-18	NR	XP_051791274.1	27687	g1910	i0	52.9	3.66028708133971	102	20	72.5	2	305	3	156	230	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	1530	89	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
30650709	30650709	PRJNA688352_P_NODE_7853_length_250_cov_0.870056_g7750_i0	PRJNA688352	7853	250	0.870056	2.17514	Eurytemora carolleeae	1294199	Arthropoda	Arthropoda	72.8	5.36e-13	NR	XP_023343148.1	1294199	g7750	i0	61.8	0.912	76	24	91.2	3	6	233	163	233	XP_023343148.1 uncharacterized protein LOC111712695 [Eurytemora carolleeae]	diamond	228	72.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Calanoida	Temoridae	Eurytemora	Eurytemora carolleeae
31346315	31346315	PRJNA688352_P_NODE_8636_length_248_cov_0.880000_g8533_i0	PRJNA688352	8636	248	0.88	2.1824	Thelohanellus kitauei	669202	Cnidaria	other_Eukaryota	76.6	2.06e-14	NR	KII69710.1	669202	g8533	i0	50	0.967741935483871	80	39	96.8	1	246	7	129	207	KII69710.1 putative ATP-dependent RNA helicase DDX27 [Thelohanellus kitauei]	diamond	240	76.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Thelohanellus	Thelohanellus kitauei
32117087	32117087	PRJNA688352_P_NODE_10018_length_245_cov_0.895349_g9915_i0	PRJNA688352	10018	245	0.895349	2.19360505	Metazoa	33208	Rotifera	other_Eukaryota	44.7	0.00583	NR	RNA20642.1	10195	g9915	i0	42.5	2.14285714285714	80	39	98	3	2	241	129	201	RNA20642.1 hypothetical protein BpHYR1_044838 [Brachionus plicatilis]	diamond	525	44.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
32401874	32401874	PRJNA688352_P_NODE_2379_length_391_cov_1.823899_g2276_i0	PRJNA688352	2379	391	1.823899	7.13144509	root	1	Root_unresolved	Root_unresolved	259	3.06e-83	NR	XP_036010302.1	10090	g2276	i0	97.7	16.9565217391304	130	3	99.7	0	391	2	65	194	XP_036010302.1 uncharacterized protein Gm53410 [Mus musculus]	diamond	6630	259	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
32516981	32516981	PRJNA688352_P_NODE_9559_length_246_cov_0.890173_g9456_i0	PRJNA688352	9559	246	0.890173	2.18982558	Chrysochloris asiatica	185453	Chordata	Chordata	43.5	0.0202	NR	XP_006860356.1	185453	g9456	i0	33.3	0.878048780487805	72	43	87.8	2	21	236	303	369	XP_006860356.1 PREDICTED: inactive hydroxysteroid dehydrogenase-like protein 1 [Chrysochloris asiatica]	diamond	216	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia		Chrysochloridae	Chrysochloris	Chrysochloris asiatica
32654145	32654145	PRJNA688352_P_NODE_5460_length_280_cov_2.821256_g5357_i0	PRJNA688352	5460	280	2.821256	7.8995168	root	1	Root_unresolved	Root_unresolved	203	1.33e-60	NR	XP_030110853.2	10090	g5357	i0	100	16.9392857142857	93	0	99.6	0	280	2	166	258	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	4743	203	1	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);;