metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA556842" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA556842" 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
10725964	10725964	PRJNA556842_P_NODE_169_length_2257_cov_35.410811_g105_i0	PRJNA556842	169	2257	35.410811	799.22200427	Opisthokonta	33154	Brachiopoda	other_Eukaryota	633	1.2499999999999999e-216	NR	XP_013400629.1	7574	g105	i0	60.1	87.2578644217988	536	196	69	3	200	1756	65	599	XP_013400629.1 heat shock cognate 71 kDa protein [Lingula anatina]	diamond	196941	636	0.995283018867924	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27250826	27250826	PRJNA556842_P_NODE_383_length_1657_cov_7.925309_g247_i0	PRJNA556842	383	1657	7.925309	131.32237013	Metazoa	33208	Annelida	Annelida	135	4.11e-33	NR	CAH1798937.1	6347	g247	i0	47.4	7.8159324079662	156	76	28.2	1	367	834	29	178	CAH1798937.1 unnamed protein product [Owenia fusiformis]	diamond	12951	136	0.992647058823529	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27773384	27773384	PRJNA556842_P_NODE_4444_length_443_cov_4.133005_g3948_i0	PRJNA556842	4444	443	4.133005	18.30921215	Staurois parvus	386267	Chordata	Chordata	53.5	5.8e-6	NR	CAI9557087.1	386267	g3948	i0	63.9	0.487584650112867	36	11	23	1	235	336	24	59	CAI9557087.1 unnamed protein product, partial [Staurois parvus]	diamond	216	53.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
28689096	28689096	PRJNA556842_P_NODE_17047_length_156_cov_1.983193_g16542_i0	PRJNA556842	17047	156	1.983193	3.09378108	Staurois parvus	386267	Chordata	Chordata	40.4	0.00759	NR	CAI9622433.1	386267	g16542	i0	78.9	0.365384615384615	19	4	36.5	0	3	59	14	32	CAI9622433.1 unnamed protein product, partial [Staurois parvus]	diamond	57	40.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
29320260	29320260	PRJNA556842_P_NODE_15949_length_164_cov_2.968504_g15444_i0	PRJNA556842	15949	164	2.968504	4.86834656	Harpegnathos saltator	610380	Arthropoda	Arthropoda	48.5	9.78e-5	NR	XP_011137057.1	610380	g15444	i0	73.3	0.548780487804878	30	8	54.9	0	157	68	1	30	XP_011137057.1 uncharacterized protein LOC105181771 [Harpegnathos saltator]	diamond	90	48.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Harpegnathos	Harpegnathos saltator
29414978	29414978	PRJNA556842_P_NODE_10129_length_240_cov_2.502463_g9624_i0	PRJNA556842	10129	240	2.502463	6.0059112	Adineta environmental sample	1193592	Rotifera	other_Eukaryota	53.5	3.4e-7	NR	XBW52376.1	1193592	g9624	i0	64	0.625	50	18	62.5	0	2	151	31	80	XBW52376.1 ice-binding family protein, partial [Adineta environmental sample]	diamond	150	53.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta environmental sample
29793804	29793804	PRJNA556842_P_NODE_7991_length_292_cov_1.968627_g7487_i0	PRJNA556842	7991	292	1.968627	5.74839084	Bufotes viridis	30338	Chordata	Chordata	43.1	0.0447	NR	CAK8629749.1	30338	g7487	i0	60	0.35958904109589	35	14	36	0	200	96	329	363	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	105	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
29920455	29920455	PRJNA556842_P_NODE_16031_length_164_cov_1.220472_g15526_i0	PRJNA556842	16031	164	1.220472	2.00157408	Idotea baltica	82763	Arthropoda	Arthropoda	70.5	3.26e-13	NR	MCL4120794.1	82763	g15526	i0	63	0.98780487804878	54	20	98.8	0	164	3	138	191	MCL4120794.1 hypothetical protein [Idotea baltica]	diamond	162	70.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
30204372	30204372	PRJNA556842_P_NODE_12912_length_195_cov_1.120253_g12407_i0	PRJNA556842	12912	195	1.120253	2.18449335	Polypterus senegalus	55291	Chordata	Chordata	65.1	2.32e-10	NR	KAG2461018.1	55291	g12407	i0	60.4	3.15384615384615	53	21	81.5	0	195	37	287	339	KAG2461018.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	615	65.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
30583596	30583596	PRJNA556842_P_NODE_1193_length_965_cov_38.913793_g888_i0	PRJNA556842	1193	965	38.913793	375.51810245	Polypedilum vanderplanki	319348	Arthropoda	Arthropoda	70.9	1.42e-9	NR	KAG5668960.1	319348	g888	i0	35.7	0.391709844559586	126	78	38.9	3	876	502	267	390	KAG5668960.1 hypothetical protein PVAND_016866 [Polypedilum vanderplanki]	diamond	378	70.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Polypedilum	Polypedilum vanderplanki
32006530	32006530	PRJNA556842_P_NODE_16978_length_157_cov_1.025000_g16473_i0	PRJNA556842	16978	157	1.025	1.60925	Colius striatus	57412	Chordata	Chordata	43.5	0.00595	NR	XP_061871356.1	57412	g16473	i0	39.6	0.917197452229299	48	25	91.7	1	149	6	273	316	XP_061871356.1 lysophosphatidic acid receptor 2 isoform X2 [Colius striatus]	diamond	144	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Coliiformes	Coliidae	Colius	Colius striatus

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