metadata: contig_metadata: 29 rows where analysis = "diamond", bioproject = "PRJNA982106" and tax

29 rows where analysis = "diamond", bioproject = "PRJNA982106" 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
2239082	2239082	PRJNA982106_P_NODE_20162_length_252_cov_1.229050_g19922_i0	PRJNA982106	20162	252	1.22905	3.097206	Grus japonensis	30415	Chordata	Chordata	156	1.08e-43	NR	GAB0207453.1	30415	g19922	i0	84.3	11.8571428571429	83	13	98.8	0	2	250	159	241	GAB0207453.1 pol-like protein ENS-3 [Grus japonensis]	diamond	2988	156	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Gruiformes	Gruidae	Grus	Grus japonensis
4791730	4791730	PRJNA982106_P_NODE_14144_length_290_cov_1.092166_g13904_i0	PRJNA982106	14144	290	1.092166	3.1672814	Rhipicephalus microplus	6941	Arthropoda	Arthropoda	190	1.27e-53	NR	KAL3221900.1	6941	g13904	i0	97.9	0.993103448275862	96	2	99.3	0	2	289	1909	2004	KAL3221900.1 hypothetical protein MRX96_029108 [Rhipicephalus microplus]	diamond	288	190	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
4792052	4792052	PRJNA982106_P_NODE_30564_length_242_cov_2.278107_g30324_i0	PRJNA982106	30564	242	2.278107	5.51301894	Gigantopelta aegis	1735272	Mollusca	Mollusca	136	2.03e-38	NR	XP_041360936.1	1735272	g30324	i0	83.1	6.73140495867769	77	13	95.5	0	12	242	1	77	XP_041360936.1 40S ribosomal protein S8-like [Gigantopelta aegis]	diamond	1629	136	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
9892061	9892061	PRJNA982106_P_NODE_29228_length_244_cov_0.900585_g28988_i0	PRJNA982106	29228	244	0.900585	2.1974274	Blattodea	85823	Arthropoda	Arthropoda	114	1.3e-27	NR	PSN31704.1	6973	g28988	i0	63	7.9672131147541	81	30	99.6	0	244	2	316	396	PSN31704.1 hypothetical protein C0J52_23621, partial [Blattella germanica]	diamond	1944	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blattellidae	Blattella	Blattella germanica
11167112	11167112	PRJNA982106_P_NODE_18689_length_261_cov_1.228723_g18449_i0	PRJNA982106	18689	261	1.228723	3.20696703	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	125	6.62e-34	NR	XP_041460284.1	7654	g18449	i0	67.1	1.95402298850575	85	27	96.6	1	260	9	65	149	XP_041460284.1 60S ribosomal protein L9-like isoform X1 [Lytechinus variegatus]	diamond	510	125	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
13717279	13717279	PRJNA982106_P_NODE_12611_length_302_cov_1.117904_g12371_i0	PRJNA982106	12611	302	1.117904	3.37607008	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	184	3.1499999999999998e-52	NR	XP_002732853.1	10224	g12371	i0	82	3.97350993377483	100	18	99.3	0	301	2	404	503	XP_002732853.1 PREDICTED: 1,4-alpha-glucan-branching enzyme-like [Saccoglossus kowalevskii]	diamond	1200	184	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
18815768	18815768	PRJNA982106_P_NODE_33055_length_231_cov_2.474684_g32815_i0	PRJNA982106	33055	231	2.474684	5.71652004	Chordata	7711	Chordata	Chordata	106	5.2600000000000005e-27	NR	KAK9411593.1	8729	g32815	i0	61.7	36.8181818181818	81	22	93.5	1	16	231	82	162	KAK9411593.1 40S ribosomal protein S12 [Crotalus adamanteus]	diamond	8505	107	0.990654205607477	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Viperidae	Crotalus	Crotalus adamanteus
26804715	26804715	PRJNA982106_P_NODE_32341_length_241_cov_0.916667_g32101_i0	PRJNA982106	32341	241	0.916667	2.20916747	Zophobas morio	2755281	Arthropoda	Arthropoda	114	1.78e-27	NR	XP_063933903.1	2755281	g32101	i0	66.7	3.06224066390041	81	26	99.6	1	240	1	1274	1354	XP_063933903.1 acetyl-CoA carboxylase 2-like isoform X1 [Zophobas morio]	diamond	738	114	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Zophobas	Zophobas morio
26836592	26836592	PRJNA982106_P_NODE_20981_length_251_cov_0.865169_g20741_i0	PRJNA982106	20981	251	0.865169	2.17157419	Anas platyrhynchos	8839	Chordata	Chordata	52.8	1.17e-5	NR	EOB05496.1	8839	g20741	i0	71.8	0.466135458167331	39	11	46.6	0	6	122	15	53	EOB05496.1 Placenta growth factor [Anas platyrhynchos]	diamond	117	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Anas	Anas platyrhynchos
27000486	27000486	PRJNA982106_P_NODE_3102_length_498_cov_1.327059_g2863_i0	PRJNA982106	3102	498	1.327059	6.60875382	Chordata	7711	Chordata	Chordata	241	4.71e-77	NR	XP_027263554.2	10029	g2863	i0	79.5	14.8433734939759	156	29	94	1	494	27	128	280	XP_027263554.2 40S ribosomal protein S3 isoform X2 [Cricetulus griseus]	diamond	7392	243	0.991769547325103	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
27311035	27311035	PRJNA982106_P_NODE_17463_length_268_cov_63.030769_g17223_i0	PRJNA982106	17463	268	63.030769	168.92246092	Chroicocephalus ridibundus	1192867	Chordata	Chordata	48.1	5.32e-4	NR	XP_063212287.1	1192867	g17223	i0	78.6	0.313432835820896	28	6	31.3	0	118	201	217	244	XP_063212287.1 uncharacterized protein LOC134525383 [Chroicocephalus ridibundus]	diamond	84	48.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Charadriiformes	Laridae	Chroicocephalus	Chroicocephalus ridibundus
27626792	27626792	PRJNA982106_P_NODE_5784_length_391_cov_1.128931_g5544_i0	PRJNA982106	5784	391	1.128931	4.41412021	Rhipicephalus microplus	6941	Arthropoda	Arthropoda	159	5.089999999999999e-48	NR	KAL3219571.1	6941	g5544	i0	91.4	0.713554987212276	93	8	71.4	0	378	100	1	93	KAL3219571.1 hypothetical protein MRX96_030329 [Rhipicephalus microplus]	diamond	279	159	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
28510694	28510694	PRJNA982106_P_NODE_1927_length_631_cov_0.876344_g1693_i0	PRJNA982106	1927	631	0.876344	5.52973064	Accipiter gentilis	8957	Chordata	Chordata	255	2.92e-77	NR	XP_049649411.1	8957	g1693	i0	58.3	1.06022187004754	223	80	99.8	2	1	630	2	224	XP_049649411.1 uncharacterized protein LOC126035221 [Accipiter gentilis]	diamond	669	255	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Accipitriformes	Accipitridae	Astur	Astur gentilis
28605406	28605406	PRJNA982106_P_NODE_32907_length_241_cov_0.875000_g32667_i0	PRJNA982106	32907	241	0.875	2.10875	Sycon ciliatum	27933	Porifera	other_Eukaryota	95.5	1.02e-20	NR	XP_065178755.1	27933	g32667	i0	82.4	4.44398340248963	51	9	63.5	0	89	241	1976	2026	XP_065178755.1 acetyl-CoA carboxylase-like [Sycon ciliatum]	diamond	1071	95.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
29400734	29400734	PRJNA982106_P_NODE_14109_length_290_cov_1.387097_g13869_i0	PRJNA982106	14109	290	1.387097	4.0225813	Metazoa	33208	Cnidaria	other_Eukaryota	79.3	3.22e-15	NR	XP_057289553.1	13093	g13869	i0	67.3	16.6655172413793	49	16	50.7	0	2	148	244	292	XP_057289553.1 eukaryotic translation initiation factor 3 subunit G-like isoform X2 [Hydractinia symbiolongicarpus]	diamond	4833	79.7	0.994981179422836	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
29773473	29773473	PRJNA982106_P_NODE_14691_length_287_cov_0.855140_g14451_i0	PRJNA982106	14691	287	0.85514	2.4542518	Lepeophtheirus salmonis	72036	Arthropoda	Arthropoda	66.2	3.58e-11	NR	ACO12385.1	72036	g14451	i0	63.5	3.26132404181185	52	19	54.4	0	262	107	43	94	ACO12385.1 60S ribosomal protein L24 [Lepeophtheirus salmonis]	diamond	936	66.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Siphonostomatoida	Caligidae	Lepeophtheirus	Lepeophtheirus salmonis
29779627	29779627	PRJNA982106_P_NODE_4831_length_416_cov_3.938776_g4592_i0	PRJNA982106	4831	416	3.938776	16.38530816	Metazoa	33208	Chordata	Chordata	200	7.070000000000001e-59	NR	ANH55795.1	8450	g4592	i0	95.4	640.550480769231	109	5	78.6	0	89	415	127	235	ANH55795.1 cytochrome c oxidase subunit I [Hypogeophis rostratus]	diamond	266469	202	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Indotyphlidae	Hypogeophis	Hypogeophis rostratus
29805135	29805135	PRJNA982106_P_NODE_15171_length_284_cov_0.886256_g14931_i0	PRJNA982106	15171	284	0.886256	2.51696704	Tachyglossus aculeatus	9261	Chordata	Chordata	60.8	5.34e-9	NR	XP_038627340.1	9261	g14931	i0	63.8	25.3204225352113	47	17	49.6	0	283	143	124	170	XP_038627340.1 ferredoxin-2, mitochondrial [Tachyglossus aculeatus]	diamond	7191	60.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Monotremata	Tachyglossidae	Tachyglossus	Tachyglossus aculeatus
29994902	29994902	PRJNA982106_P_NODE_4271_length_435_cov_1.140884_g4032_i0	PRJNA982106	4271	435	1.140884	4.9628454	Helicoverpa zea	7113	Arthropoda	Arthropoda	130	1.36e-33	NR	XP_047024313.1	7113	g4032	i0	46.7	1.03448275862069	150	69	99.3	4	3	434	117	261	XP_047024313.1 cathepsin B-like [Helicoverpa zea]	diamond	450	130	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Helicoverpa	Helicoverpa zea
30184264	30184264	PRJNA982106_P_NODE_32992_length_236_cov_3.447853_g32752_i0	PRJNA982106	32992	236	3.447853	8.13693308	Anthophora plagiata	597819	Arthropoda	Arthropoda	43.1	0.0239	NR	CAK9813121.1	597819	g32752	i0	48.6	2.22457627118644	35	18	44.5	0	176	72	222	256	CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata]	diamond	525	43.5	0.990804597701149	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Anthophora	Anthophora plagiata
30443205	30443205	PRJNA982106_P_NODE_25993_length_246_cov_1.462428_g25753_i0	PRJNA982106	25993	246	1.462428	3.59757288	Metazoa	33208	Mollusca	Mollusca	112	1.19e-26	NR	XP_046380465.1	6454	g25753	i0	74.7	237.80487804878	75	19	91.5	0	236	12	638	712	XP_046380465.1 SWI/SNF complex subunit SMARCC2-like isoform X5 [Haliotis rufescens]	diamond	58500	112	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
30500283	30500283	PRJNA982106_P_NODE_19153_length_258_cov_1.664865_g18913_i0	PRJNA982106	19153	258	1.664865	4.2953517	Physella acuta	109671	Mollusca	Mollusca	47.8	7.83e-4	NR	XP_059165578.1	109671	g18913	i0	48.7	1.7093023255814	39	20	45.3	0	137	253	333	371	XP_059165578.1 stabilin-2-like [Physella acuta]	diamond	441	47.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
30658242	30658242	PRJNA982106_P_NODE_3793_length_456_cov_3.874674_g3554_i0	PRJNA982106	3793	456	3.874674	17.66851344	Staurois parvus	386267	Chordata	Chordata	58.5	8.77e-8	NR	CAI9533415.1	386267	g3554	i0	40	2.22368421052632	110	47	59.9	4	391	119	1	110	CAI9533415.1 unnamed protein product [Staurois parvus]	diamond	1014	58.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
31069181	31069181	PRJNA982106_P_NODE_17635_length_268_cov_0.861538_g17395_i0	PRJNA982106	17635	268	0.861538	2.30892184	Calidris pugnax	198806	Chordata	Chordata	76.6	5.88e-14	NR	XP_014807396.1	198806	g17395	i0	59.7	0.694029850746269	62	25	69.4	0	188	3	845	906	XP_014807396.1 PREDICTED: uncharacterized protein LOC106893722 [Calidris pugnax]	diamond	186	76.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Charadriiformes	Scolopacidae	Calidris	Calidris pugnax
31226840	31226840	PRJNA982106_P_NODE_10555_length_321_cov_1.229839_g10315_i0	PRJNA982106	10555	321	1.229839	3.94778319	Engystomops pustulosus	76066	Chordata	Chordata	47.4	2.21e-4	NR	KAG8536220.1	76066	g10315	i0	67.9	0.785046728971963	28	9	26.2	0	85	2	43	70	KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus]	diamond	252	47.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
31480307	31480307	PRJNA982106_P_NODE_20436_length_251_cov_0.865169_g20196_i0	PRJNA982106	20436	251	0.865169	2.17157419	Calidris pugnax	198806	Chordata	Chordata	79.7	3.98e-15	NR	XP_014807396.1	198806	g20196	i0	71.9	2.04382470119522	57	16	68.1	0	3	173	79	135	XP_014807396.1 PREDICTED: uncharacterized protein LOC106893722 [Calidris pugnax]	diamond	513	79.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Charadriiformes	Scolopacidae	Calidris	Calidris pugnax
31701400	31701400	PRJNA982106_P_NODE_18837_length_260_cov_1.433155_g18597_i0	PRJNA982106	18837	260	1.433155	3.726203	Zophobas morio	2755281	Arthropoda	Arthropoda	92.8	1.12e-19	NR	XP_063901660.1	2755281	g18597	i0	57.1	0.969230769230769	84	35	96.9	1	258	7	678	760	XP_063901660.1 protein kinase C delta type-like isoform X2 [Zophobas morio]	diamond	252	92.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Zophobas	Zophobas morio
31764671	31764671	PRJNA982106_P_NODE_8717_length_341_cov_2.018657_g8477_i0	PRJNA982106	8717	341	2.018657	6.88362037	Erpetoichthys calabaricus	27687	Chordata	Chordata	75.9	1.65e-13	NR	XP_051791274.1	27687	g8477	i0	74.5	2.24340175953079	51	12	44	1	232	83	156	206	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	765	75.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
32781929	32781929	PRJNA982106_P_NODE_30220_length_243_cov_0.905882_g29980_i0	PRJNA982106	30220	243	0.905882	2.20129326	Chordata	7711	Chordata	Chordata	42	0.0328	NR	ETE69610.1	8665	g29980	i0	100	2.96296296296296	20	0	24.7	0	2	61	122	141	ETE69610.1 Tumor susceptibility protein, partial [Ophiophagus hannah]	diamond	720	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Elapidae	Ophiophagus	Ophiophagus hannah

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