metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA753112" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA753112" 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
2005221	2005221	PRJNA753112_P_NODE_34322_length_234_cov_2.906832_g33980_i0	PRJNA753112	34322	234	2.906832	6.80198688	Pomacea canaliculata	400727	Mollusca	Mollusca	111	2.99e-29	NR	XP_025086345.1	400727	g33980	i0	66.7	0.961538461538462	75	25	96.2	0	7	231	1	75	XP_025086345.1 LOW QUALITY PROTEIN: 40S ribosomal protein S11-like [Pomacea canaliculata]	diamond	225	111	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
4557179	4557179	PRJNA753112_P_NODE_11184_length_406_cov_0.936937_g10842_i0	PRJNA753112	11184	406	0.936937	3.80396422	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	103	1.62e-25	NR	KAH9399477.1	59818	g10842	i0	43.8	13.5	121	64	86.5	2	29	379	12	132	KAH9399477.1 60S ribosomal protein L22 [Tyrophagus putrescentiae]	diamond	5481	103	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
7107631	7107631	PRJNA753112_P_NODE_22286_length_288_cov_1.562791_g21944_i0	PRJNA753112	22286	288	1.562791	4.50083808	Metazoa	33208	Chordata	Chordata	142	2.51e-38	NR	Q9GR88.1	7723	g21944	i0	69.1	58.7083333333333	94	29	97.9	0	1	282	154	247	Q9GR88.1 RecName: Full=Eukaryotic peptide chain release factor subunit 1; Short=Eukaryotic release factor 1; Short=eRF1 [Polyandrocarpa misakiensis]	diamond	16908	143	0.993006993006993	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Polyandrocarpa	Polyandrocarpa misakiensis
7107972	7107972	PRJNA753112_P_NODE_7806_length_489_cov_1.959135_g7464_i0	PRJNA753112	7806	489	1.959135	9.58017015	Daphnia sinensis	1820382	Arthropoda	Arthropoda	132	9.92e-36	NR	KAI9549990.1	1820382	g7464	i0	48.2	3.34969325153374	137	70	83.4	1	473	66	45	181	KAI9549990.1 hypothetical protein GHT06_007518 [Daphnia sinensis]	diamond	1638	132	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia sinensis
16031719	16031719	PRJNA753112_P_NODE_29493_length_251_cov_1.612360_g29151_i0	PRJNA753112	29493	251	1.61236	4.0470236	root	1	Root_unresolved	Root_unresolved	110	8.44e-26	NR	XP_048680898.1	8467	g29151	i0	100	48.3107569721116	50	0	59.8	0	249	100	2071	2120	XP_048680898.1 serine/threonine-protein kinase mTOR isoform X4 [Caretta caretta]	diamond	12126	111	0.990990990990991	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Caretta	Caretta caretta
17307007	17307007	PRJNA753112_P_NODE_20574_length_299_cov_2.004425_g20232_i0	PRJNA753112	20574	299	2.004425	5.99323075	Metazoa	33208	Echinodermata	other_Eukaryota	144	6.14e-40	NR	XP_071487048.1	105358	g20232	i0	74.7	11.0969899665552	91	23	91.3	0	14	286	11	101	XP_071487048.1 ADP,ATP carrier protein-like [Diadema antillarum]	diamond	3318	145	0.993103448275862	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
24153100	24153100	PRJNA753112_P_NODE_11339_length_403_cov_2.360606_g10997_i0	PRJNA753112	11339	403	2.360606	9.51324218	Dermatophagoides farinae	6954	Arthropoda	Arthropoda	159	1.18e-45	NR	XP_046909420.1	6954	g10997	i0	60.2	23.7617866004963	133	42	99	2	5	403	65	186	XP_046909420.1 40S ribosomal protein S2-like [Dermatophagoides farinae]	diamond	9576	159	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides farinae
27937409	27937409	PRJNA753112_P_NODE_15645_length_343_cov_2.185185_g15303_i0	PRJNA753112	15645	343	2.185185	7.49518455	Pristionchus fissidentatus	1538716	Nematoda	Nematoda	128	6.83e-36	NR	GMT14341.1	1538716	g15303	i0	65.6	1.61807580174927	93	31	81.3	1	320	42	7	98	GMT14341.1 hypothetical protein PFISCL1PPCAC_5638, partial [Pristionchus fissidentatus]	diamond	555	128	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus fissidentatus
28379307	28379307	PRJNA753112_P_NODE_23146_length_283_cov_1.719048_g22804_i0	PRJNA753112	23146	283	1.719048	4.86490584	Uloborus diversus	327109	Arthropoda	Arthropoda	119	1.51e-30	NR	XP_054713810.1	327109	g22804	i0	54.7	1.99293286219081	95	42	99.6	1	2	283	80	174	XP_054713810.1 ribosome biogenesis protein BRX1 homolog [Uloborus diversus]	diamond	564	119	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Uloboridae	Uloborus	Uloborus diversus
28726676	28726676	PRJNA753112_P_NODE_9827_length_433_cov_1.733333_g9485_i0	PRJNA753112	9827	433	1.733333	7.50533189	Lepeophtheirus salmonis	72036	Arthropoda	Arthropoda	98.6	1.35e-22	NR	ADD38186.1	72036	g9485	i0	35.3	0.963048498845266	139	85	96.3	1	429	13	3	136	ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis]	diamond	417	98.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Siphonostomatoida	Caligidae	Lepeophtheirus	Lepeophtheirus salmonis
29462407	29462407	PRJNA753112_P_NODE_28870_length_253_cov_0.866667_g28528_i0	PRJNA753112	28870	253	0.866667	2.19266751	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	119	5.8399999999999995e-30	NR	NXI53838.1	176938	g28528	i0	67.5	21.6403162055336	83	27	98.4	0	2	250	299	381	NXI53838.1 VATB1 ATPase [Chloroceryle aenea]	diamond	5475	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Coraciiformes	Cerylidae	Chloroceryle	Chloroceryle aenea
29746622	29746622	PRJNA753112_P_NODE_27350_length_260_cov_1.475936_g27008_i0	PRJNA753112	27350	260	1.475936	3.8374335999999998	Metazoa	33208	Cnidaria	other_Eukaryota	101	1.19e-24	NR	XP_057310907.1	13093	g27008	i0	68.8	6.46153846153846	80	23	91.2	2	259	23	89	167	XP_057310907.1 60S ribosomal protein L18-like [Hydractinia symbiolongicarpus]	diamond	1680	101	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
30567990	30567990	PRJNA753112_P_NODE_12733_length_379_cov_4.751634_g12391_i0	PRJNA753112	12733	379	4.751634	18.00869286	root	1	Root_unresolved	Root_unresolved	46.2	0.00665	NR	BAM20583.1	76194	g12391	i0	37.9	1.58311345646438	66	35	47.5	1	241	62	57	122	BAM20583.1 unknown secreted protein, partial [Papilio polytes]	diamond	600	46.6	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
31759614	31759614	PRJNA753112_P_NODE_33797_length_241_cov_2.773810_g33455_i0	PRJNA753112	33797	241	2.77381	6.6848821	Adineta ricciae	249248	Rotifera	other_Eukaryota	65.5	4.18e-11	NR	CAF0745393.1	249248	g33455	i0	40.8	2.46473029045643	71	42	88.4	0	4	216	17	87	CAF0745393.1 unnamed protein product [Adineta ricciae]	diamond	594	65.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
32896886	32896886	PRJNA753112_P_NODE_9660_length_437_cov_1.618132_g9318_i0	PRJNA753112	9660	437	1.618132	7.07123684	Trichuris suis	68888	Nematoda	Nematoda	90.5	1.58e-18	NR	KFD51108.1	68888	g9318	i0	39	0.967963386727689	141	82	94.1	1	5	415	174	314	KFD51108.1 hypothetical protein M513_08008 [Trichuris suis]	diamond	423	90.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis

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