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

11 rows where analysis = "diamond", bioproject = "PRJEB6055" 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
26685312	26685312	PRJEB6055_S_NODE_2781_length_196_cov_2.552795_g2757_i0	PRJEB6055	2781	196	2.552795	5.0034782	Diaphorina citri	121845	Arthropoda	Arthropoda	44.3	0.00556	NR	KAI5702344.1	121845	g2757	i0	53.5	5.9234693877551	43	18	65.8	1	63	191	43	83	KAI5702344.1 hypothetical protein M8J77_016943 [Diaphorina citri]	diamond	1161	44.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Psyllidae	Diaphorina	Diaphorina citri
26907079	26907079	PRJEB6055_S_NODE_4362_length_169_cov_1.335821_g4338_i0	PRJEB6055	4362	169	1.335821	2.25753749	Adineta ricciae	249248	Rotifera	other_Eukaryota	74.3	7.62e-14	NR	CAF1267090.1	249248	g4338	i0	83.8	1.97041420118343	37	6	65.7	0	168	58	320	356	CAF1267090.1 unnamed protein product [Adineta ricciae]	diamond	333	74.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28069119	28069119	PRJEB6055_S_NODE_3005_length_191_cov_3.391026_g2981_i0	PRJEB6055	3005	191	3.391026	6.47685966	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82	2.41e-16	NR	KAJ1369248.1	148309	g2981	i0	59.6	7.31937172774869	52	21	81.7	0	1	156	405	456	KAJ1369248.1 hypothetical protein KIN20_030662 [Parelaphostrongylus tenuis]	diamond	1398	82.4	0.995145631067961	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Parelaphostrongylus	Parelaphostrongylus tenuis
28518055	28518055	PRJEB6055_S_NODE_1907_length_222_cov_3.320856_g1883_i0	PRJEB6055	1907	222	3.320856	7.37230032	Nephila pilipes	299642	Arthropoda	Arthropoda	47	6.35e-4	NR	GFT36626.1	299642	g1883	i0	49.2	2.21621621621622	59	26	79.7	2	40	216	66	120	GFT36626.1 hypothetical protein NPIL_642691 [Nephila pilipes]	diamond	492	47	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Nephila	Nephila pilipes
29079600	29079600	PRJEB6055_S_NODE_5508_length_155_cov_1.000000_g5484_i0	PRJEB6055	5508	155	1	1.55	Metazoa	33208	Platyhelminthes	Platyhelminthes	57	3.4e-8	NR	KAF8568914.1	34504	g5484	i0	51	7.70322580645161	51	25	98.7	0	153	1	106	156	KAF8568914.1 hypothetical protein P879_01172 [Paragonimus westermani]	diamond	1194	57.4	0.993031358885017	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus westermani
29742335	29742335	PRJEB6055_S_NODE_4410_length_168_cov_1.263158_g4386_i0	PRJEB6055	4410	168	1.263158	2.12210544	Opisthokonta	33154	Arthropoda	Arthropoda	48.1	1.66e-4	NR	CAD7399651.1	61476	g4386	i0	59.5	5.67857142857143	37	15	66.1	0	160	50	53	89	CAD7399651.1 unnamed protein product [Timema cristinae]	diamond	954	48.5	0.991752577319588	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema cristinae
30216268	30216268	PRJEB6055_S_NODE_832_length_293_cov_1.860465_g808_i0	PRJEB6055	832	293	1.860465	5.45116245	Mollusca	6447	Mollusca	Mollusca	97.1	4.36e-22	NR	XP_050391847.1	6465	g808	i0	64.5	8.31399317406143	62	22	63.5	0	292	107	196	257	XP_050391847.1 40S ribosomal protein S4 [Patella vulgata]	diamond	2436	97.8	0.992842535787321	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
30855069	30855069	PRJEB6055_S_NODE_2874_length_194_cov_1.509434_g2850_i0	PRJEB6055	2874	194	1.509434	2.92830196	Argopecten irradians	31199	Mollusca	Mollusca	53.9	6.55e-7	NR	XP_069123020.1	31199	g2850	i0	70.5	3.44845360824742	44	13	68	0	15	146	114	157	XP_069123020.1 small ribosomal subunit protein eS24-like isoform X2 [Argopecten irradians]	diamond	669	53.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
32056689	32056689	PRJEB6055_S_NODE_1538_length_237_cov_2.856436_g1514_i0	PRJEB6055	1538	237	2.856436	6.76975332	Octopus sinensis	2607531	Mollusca	Mollusca	98.2	2.48e-22	NR	XP_029635157.1	2607531	g1514	i0	75	1.9873417721519	52	13	65.8	0	2	157	284	335	XP_029635157.1 cathepsin B [Octopus sinensis]	diamond	471	98.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
32056690	32056690	PRJEB6055_S_NODE_2498_length_203_cov_5.738095_g2474_i0	PRJEB6055	2498	203	5.738095	11.64833285	Adineta steineri	433720	Rotifera	other_Eukaryota	76.3	7.54e-15	NR	CAF0713792.1	433720	g2474	i0	72.9	3.54679802955665	48	13	70.9	0	201	58	146	193	CAF0713792.1 unnamed protein product [Adineta steineri]	diamond	720	76.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
32088363	32088363	PRJEB6055_S_NODE_4638_length_165_cov_1.223077_g4614_i0	PRJEB6055	4638	165	1.223077	2.01807705	Patiria miniata	46514	Echinodermata	other_Eukaryota	79.3	3.27e-16	NR	XP_038051326.1	46514	g4614	i0	76.7	2.34545454545455	43	10	78.2	0	3	131	204	246	XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata]	diamond	387	79.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata

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