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

10 rows where analysis = "diamond", bioproject = "PRJNA733995" 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
14745551	14745551	PRJNA733995_P_NODE_13452_length_243_cov_0.905882_g13405_i0	PRJNA733995	13452	243	0.905882	2.20129326	Sarcoptes scabiei	52283	Arthropoda	Arthropoda	115	2.799999999999999e-29	NR	KAI7692677.1	52283	g13405	i0	72.5	10.8641975308642	80	22	98.8	0	3	242	97	176	KAI7692677.1 hypothetical protein SSS_06703 [Sarcoptes scabiei]	diamond	2640	115	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Sarcoptidae	Sarcoptes	Sarcoptes scabiei
26703959	26703959	PRJNA733995_P_NODE_11521_length_255_cov_2.923077_g11474_i0	PRJNA733995	11521	255	2.923077	7.45384635	Portunus trituberculatus	210409	Arthropoda	Arthropoda	40.4	0.0436	NR	MPC90678.1	210409	g11474	i0	48.7	0.458823529411765	39	19	44.7	1	83	196	2	40	MPC90678.1 hypothetical protein [Portunus trituberculatus]	diamond	117	40.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Portunus	Portunus trituberculatus
27779083	27779083	PRJNA733995_P_NODE_5404_length_371_cov_1.033557_g5357_i0	PRJNA733995	5404	371	1.033557	3.83449647	Portunus trituberculatus	210409	Arthropoda	Arthropoda	63.5	6.89e-10	NR	XP_045134091.1	210409	g5357	i0	55.7	0.986522911051213	61	26	48.5	1	369	190	41	101	XP_045134091.1 LYR motif-containing protein 1-like isoform X1 [Portunus trituberculatus]	diamond	366	63.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Portunus	Portunus trituberculatus
28505082	28505082	PRJNA733995_P_NODE_10927_length_262_cov_2.042328_g10880_i0	PRJNA733995	10927	262	2.042328	5.35089936	Spea bombifrons	233779	Chordata	Chordata	80.5	2.53e-15	NR	XP_053326285.1	233779	g10880	i0	73.7	5.69083969465649	57	10	65.3	1	175	5	76	127	XP_053326285.1 rho GTPase-activating protein 29 [Spea bombifrons]	diamond	1491	81.3	0.990159901599016	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pelobatidae	Spea	Spea bombifrons
28505109	28505109	PRJNA733995_P_NODE_6827_length_328_cov_1.509804_g6780_i0	PRJNA733995	6827	328	1.509804	4.95215712	Condylura cristata	143302	Chordata	Chordata	73.2	1.35e-12	NR	XP_012576637.1	143302	g6780	i0	61.2	0.896341463414634	49	19	44.8	0	12	158	52	100	XP_012576637.1 PREDICTED: WD repeat-containing protein 5 [Condylura cristata]	diamond	294	73.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Eulipotyphla	Talpidae	Condylura	Condylura cristata
28883940	28883940	PRJNA733995_P_NODE_4808_length_394_cov_1.485981_g4761_i0	PRJNA733995	4808	394	1.485981	5.85476514	Adineta ricciae	249248	Rotifera	other_Eukaryota	133	2.84e-35	NR	CAF1644004.1	249248	g4761	i0	50.8	1.94162436548223	126	59	95.2	2	15	389	66	189	CAF1644004.1 unnamed protein product [Adineta ricciae]	diamond	765	133	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30115473	30115473	PRJNA733995_P_NODE_1492_length_738_cov_2.915789_g1448_i0	PRJNA733995	1492	738	2.915789	21.51852282	Trichinella sp. T9	181606	Nematoda	Nematoda	77	5.15e-12	NR	KRX60888.1	181606	g1448	i0	27.8	2.50813008130081	223	136	83.3	9	615	1	598	813	KRX60888.1 Exostosin-like 3 [Trichinella sp. T9]	diamond	1851	77	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella sp. T9
31000320	31000320	PRJNA733995_P_NODE_10614_length_266_cov_1.595855_g10567_i0	PRJNA733995	10614	266	1.595855	4.2449743	Pecten maximus	6579	Mollusca	Mollusca	43.5	0.0256	NR	XP_033760791.1	6579	g10567	i0	26.4	0.981203007518797	87	47	78.9	2	261	52	213	299	XP_033760791.1 uncharacterized protein LOC117342692 [Pecten maximus]	diamond	261	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
31537907	31537907	PRJNA733995_P_NODE_10996_length_262_cov_1.068783_g10949_i0	PRJNA733995	10996	262	1.068783	2.80021146	Pinctada imbricata	66713	Mollusca	Mollusca	46.6	0.00214	NR	KAK3095811.1	66713	g10949	i0	36.4	0.755725190839695	66	37	69.8	1	211	29	735	800	KAK3095811.1 hypothetical protein FSP39_019502 [Pinctada imbricata]	diamond	198	46.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata
32107120	32107120	PRJNA733995_P_NODE_998_length_910_cov_2.708483_g961_i0	PRJNA733995	998	910	2.708483	24.6471953	Haliotis rubra	36100	Mollusca	Mollusca	61.2	1.86e-6	NR	XP_046563617.1	36100	g961	i0	30	0.725274725274725	110	70	34.3	3	474	163	43	151	XP_046563617.1 probable xyloglucan galactosyltransferase GT17 [Haliotis rubra]	diamond	660	61.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra

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