metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA1073183" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA1073183" and tax_phylum = "Chordata"

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
7393790	7393790	PRJNA1073183_P_NODE_19226_length_298_cov_1.368889_g19131_i0	PRJNA1073183	19226	298	1.368889	4.07928922	Metazoa	33208	Chordata	Chordata	116	1.0600000000000002e-27	NR	CAB3263606.1	59560	g19131	i0	52	1.99328859060403	98	46	98.7	1	296	3	283	379	CAB3263606.1 lysosomal alpha-mannosidase-like [Phallusia mammillata]	diamond	594	116	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Ascidiidae	Phallusia	Phallusia mammillata
12940800	12940800	PRJNA1073183_P_NODE_13071_length_358_cov_1.582456_g12976_i0	PRJNA1073183	13071	358	1.582456	5.66519248	Metazoa	33208	Chordata	Chordata	130	9.34e-35	NR	XP_019641702.1	7741	g12976	i0	63.2	3.82122905027933	114	42	95.5	0	344	3	12	125	XP_019641702.1 PREDICTED: 60S ribosomal protein L7-like [Branchiostoma belcheri]	diamond	1368	130	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
14215755	14215755	PRJNA1073183_P_NODE_14052_length_346_cov_1.545788_g13957_i0	PRJNA1073183	14052	346	1.545788	5.34842648	Metazoa	33208	Chordata	Chordata	97.4	7.21e-21	NR	GCC29143.1	137246	g13957	i0	71	4.77745664739884	69	20	59.8	0	18	224	29	97	GCC29143.1 hypothetical protein [Chiloscyllium punctatum]	diamond	1653	97.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Orectolobiformes	Hemiscylliidae	Chiloscyllium	Chiloscyllium punctatum
16318556	16318556	PRJNA1073183_P_NODE_19333_length_297_cov_1.375000_g19238_i0	PRJNA1073183	19333	297	1.375	4.08375	Branchiostoma belcheri	7741	Chordata	Chordata	68.6	1.96e-12	NR	XP_019621563.1	7741	g19238	i0	85.7	4.60606060606061	91	12	91.9	1	2	274	25	114	XP_019621563.1 PREDICTED: 60S acidic ribosomal protein P2 [Branchiostoma belcheri]	diamond	1368	68.9	0.995645863570392	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
16318633	16318633	PRJNA1073183_P_NODE_8473_length_438_cov_1.950685_g8379_i0	PRJNA1073183	8473	438	1.950685	8.5440003	Sarcophilus harrisii	9305	Chordata	Chordata	155	5.139999999999999e-42	NR	XP_031798108.1	9305	g8379	i0	49.7	45.4794520547945	145	73	99.3	0	435	1	59	203	XP_031798108.1 nucleolar protein 56 isoform X2 [Sarcophilus harrisii]	diamond	19920	155	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Dasyuromorphia	Dasyuridae	Sarcophilus	Sarcophilus harrisii
23139818	23139818	PRJNA1073183_P_NODE_7399_length_469_cov_1.060606_g7305_i0	PRJNA1073183	7399	469	1.060606	4.97424214	Ciona intestinalis	7719	Chordata	Chordata	215	1.03e-66	NR	XP_002128514.1	7719	g7305	i0	66	2.9680170575693	156	51	99.8	1	2	469	30	183	XP_002128514.1 spermidine synthase [Ciona intestinalis]	diamond	1392	215	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis
27027239	27027239	PRJNA1073183_P_NODE_26842_length_251_cov_0.865169_g26747_i0	PRJNA1073183	26842	251	0.865169	2.17157419	Rodentia	9989	Chordata	Chordata	51.6	3.01e-5	NR	XP_032744025.1	10117	g26747	i0	57.6	1.08764940239044	59	25	70.5	0	1	177	66	124	XP_032744025.1 cAMP-dependent protein kinase catalytic subunit alpha [Rattus rattus]	diamond	273	51.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus rattus
27161955	27161955	PRJNA1073183_P_NODE_24642_length_262_cov_1.402116_g24547_i0	PRJNA1073183	24642	262	1.402116	3.67354392	Kogia breviceps	27615	Chordata	Chordata	43.1	0.0358	NR	XP_066868853.1	27615	g24547	i0	41.3	0.721374045801527	63	34	69.8	2	222	40	432	493	XP_066868853.1 armadillo repeat-containing protein 5 [Kogia breviceps]	diamond	189	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Physeteridae	Kogia	Kogia breviceps
27983351	27983351	PRJNA1073183_P_NODE_9905_length_408_cov_0.913433_g9811_i0	PRJNA1073183	9905	408	0.913433	3.72680664	Thamnophis elegans	35005	Chordata	Chordata	222	1.6799999999999994e-67	NR	XP_032093824.1	35005	g9811	i0	80.7	60.5514705882353	135	26	99.3	0	3	407	322	456	XP_032093824.1 fumarate hydratase, mitochondrial isoform X1 [Thamnophis elegans]	diamond	24705	222	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Colubridae	Thamnophis	Thamnophis elegans
28921970	28921970	PRJNA1073183_P_NODE_8168_length_446_cov_1.238606_g8074_i0	PRJNA1073183	8168	446	1.238606	5.52418276	Chordata	7711	Chordata	Chordata	191	5.690000000000001e-59	NR	KAK9406484.1	8729	g8074	i0	66.9	59.8654708520179	145	44	95.5	2	427	2	38	181	KAK9406484.1 hypothetical protein NXF25_005258 [Crotalus adamanteus]	diamond	26700	191	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Viperidae	Crotalus	Crotalus adamanteus
29057005	29057005	PRJNA1073183_P_NODE_32288_length_244_cov_0.900585_g32193_i0	PRJNA1073183	32288	244	0.900585	2.1974274	Petromyzon marinus	7757	Chordata	Chordata	63.2	1.74e-9	NR	XP_032825180.1	7757	g32193	i0	51.6	4.9672131147541	62	29	76.2	1	235	50	53	113	XP_032825180.1 methylsterol monooxygenase 1 [Petromyzon marinus]	diamond	1212	63.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Petromyzon	Petromyzon marinus
29372664	29372664	PRJNA1073183_P_NODE_31429_length_245_cov_0.895349_g31334_i0	PRJNA1073183	31429	245	0.895349	2.19360505	Candoia aspera	51853	Chordata	Chordata	73.6	5.34e-13	NR	XP_063165777.1	51853	g31334	i0	44.7	11.4734693877551	76	42	93.1	0	228	1	332	407	XP_063165777.1 HBS1-like protein isoform X1 [Candoia aspera]	diamond	2811	73.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Boidae	Candoia	Candoia aspera
29435489	29435489	PRJNA1073183_P_NODE_31650_length_244_cov_1.736842_g31555_i0	PRJNA1073183	31650	244	1.736842	4.23789448	Bombina bombina	8345	Chordata	Chordata	62.4	4.46e-9	NR	XP_053566456.1	8345	g31555	i0	39.5	0.995901639344262	81	49	99.6	0	244	2	367	447	XP_053566456.1 phosphoacetylglucosamine mutase [Bombina bombina]	diamond	243	62.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
29806064	29806064	PRJNA1073183_P_NODE_22411_length_277_cov_1.127451_g22316_i0	PRJNA1073183	22411	277	1.127451	3.12303927	Aves	8782	Chordata	Chordata	59.7	6.27e-8	NR	XP_010217834.1	94827	g22316	i0	46.2	1.12635379061372	52	28	56.3	0	103	258	738	789	XP_010217834.1 PREDICTED: enteropeptidase [Tinamus guttatus]	diamond	312	59.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Tinamiformes	Tinamidae	Tinamus	Tinamus guttatus
29814582	29814582	PRJNA1073183_P_NODE_30751_length_246_cov_0.890173_g30656_i0	PRJNA1073183	30751	246	0.890173	2.18982558	Heterocephalus glaber	10181	Chordata	Chordata	47	0.00118	NR	XP_012922819.1	10181	g30656	i0	39	0.939024390243902	77	32	75.6	1	187	2	60	136	XP_012922819.1 LOW QUALITY PROTEIN: protein SET-like [Heterocephalus glaber]	diamond	231	47	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Bathyergidae	Heterocephalus	Heterocephalus glaber
30193661	30193661	PRJNA1073183_P_NODE_11792_length_376_cov_1.155116_g11697_i0	PRJNA1073183	11792	376	1.155116	4.34323616	Mesocricetus auratus	10036	Chordata	Chordata	58.9	1.87e-8	NR	XP_040612164.1	10036	g11697	i0	53.7	1.72340425531915	54	24	43.1	1	41	202	19	71	XP_040612164.1 protein CTLA-2-beta [Mesocricetus auratus]	diamond	648	58.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Mesocricetus	Mesocricetus auratus
30501266	30501266	PRJNA1073183_P_NODE_10413_length_397_cov_2.271605_g10319_i0	PRJNA1073183	10413	397	2.271605	9.01827185	Metazoa	33208	Chordata	Chordata	238	2.1e-76	NR	KYO40344.1	8496	g10319	i0	94.4	60.4760705289673	124	7	93.7	0	373	2	164	287	KYO40344.1 kxDL motif-containing protein 1 [Alligator mississippiensis]	diamond	24009	240	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Chordata		Crocodylia	Alligatoridae	Alligator	Alligator mississippiensis
30825632	30825632	PRJNA1073183_P_NODE_27614_length_250_cov_0.870056_g27519_i0	PRJNA1073183	27614	250	0.870056	2.17514	Phrynocephalus forsythii	171643	Chordata	Chordata	71.6	2.35e-12	NR	KAJ7305927.1	171643	g27519	i0	47.6	0.984	82	40	98.4	1	248	3	215	293	KAJ7305927.1 hypothetical protein JRQ81_010293, partial [Phrynocephalus forsythii]	diamond	246	71.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Agamidae	Phrynocephalus	Phrynocephalus forsythii
32879993	32879993	PRJNA1073183_P_NODE_29720_length_247_cov_0.885057_g29625_i0	PRJNA1073183	29720	247	0.885057	2.18609079	Sorex fumeus	62283	Chordata	Chordata	50.8	5.22e-5	NR	XP_055988133.1	62283	g29625	i0	32.1	1.88259109311741	78	44	91.1	2	227	3	14	85	XP_055988133.1 E3 ubiquitin-protein ligase TRIM38-like [Sorex fumeus]	diamond	465	50.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Eulipotyphla	Soricidae	Sorex	Sorex fumeus

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