metadata: contig_metadata: 26 rows where bioproject = "PRJNA692200" and tax

26 rows where bioproject = "PRJNA692200" 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
4500552	4500552	PRJNA692200_S_NODE_11164_length_213_cov_2.353659_g11107_i0	PRJNA692200	11164	213	2.353659	5.01329367	Pyrrhula murina	928672	Chordata	Chordata	54.7	0.005	NTclustered	gi\|2920008267\|emb\|OZ239000.1\|	928672	g11107	i0	100	0.136150234741784	29	0	14	0	82	110	23013926	23013954	Pyrrhula murina genome assembly, chromosome: 6	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Pyrrhula	Pyrrhula murina
4500616	4500616	PRJNA692200_S_NODE_13764_length_195_cov_1.506849_g13707_i0	PRJNA692200	13764	195	1.506849	2.93835555	Buceros rhinoceros	175835	Chordata	Chordata	69.4	1.67e-7	NTclustered	gi\|704195242\|ref\|XM_010142047.1\|	175836	g13707	i0	85.075	1.6974358974359	67	10	34	0	124	190	40	106	PREDICTED: Buceros rhinoceros silvestris DEAH (Asp-Glu-Ala-His) box helicase 15 (DHX15), partial mRNA	blastn	331	69.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Bucerotiformes	Bucerotidae	Buceros	Buceros rhinoceros
4501043	4501043	PRJNA692200_S_NODE_9264_length_231_cov_1.637363_g9207_i0	PRJNA692200	9264	231	1.637363	3.78230853	Tupaia chinensis	246437	Chordata	Chordata	52.8	0.021	NTclustered	gi\|1561583174\|ref\|XM_014589170.2\|	246437	g9207	i0	100	0.121212121212121	28	0	12	0	147	174	2532	2559	PREDICTED: Tupaia chinensis family with sequence similarity 83 member H (FAM83H), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Scandentia	Tupaiidae	Tupaia	Tupaia chinensis
5007604	5007604	PRJNA692200_S_NODE_18164_length_173_cov_1.258065_g18107_i0	PRJNA692200	18164	173	1.258065	2.17645245	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.015	NTclustered	gi\|26185849\|emb\|AL772253.12\|	10090	g18107	i0	100	0.647398843930636	28	0	16	0	94	121	73127	73100	Mouse DNA sequence from clone RP23-101F14 on chromosome 2, complete sequence	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7051319	7051319	PRJNA692200_S_NODE_18006_length_173_cov_3.951613_g17949_i0	PRJNA692200	18006	173	3.951613	6.83629049	Pleurodeles waltl	8319	Chordata	Chordata	52.8	0.015	NTclustered	gi\|2833214946\|ref\|XR_011204793.1\|	8319	g17949	i0	100	0.485549132947977	28	0	16	0	58	85	1578	1551	PREDICTED: Pleurodeles waltl uncharacterized lncRNA (LOC138299620), transcript variant X2, ncRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
9601174	9601174	PRJNA692200_S_NODE_19488_length_168_cov_1.764706_g19431_i0	PRJNA692200	19488	168	1.764706	2.96470608	Ailuropoda melanoleuca	9646	Chordata	Chordata	60.2	8.43e-5	NTclustered	gi\|1845541662\|ref\|XR_004623296.1\|	9646	g19431	i0	97.222	0.214285714285714	36	0	21	1	32	67	6061	6027	PREDICTED: Ailuropoda melanoleuca uncharacterized LOC117801007 (LOC117801007), ncRNA	blastn	36	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Ursidae	Ailuropoda	Ailuropoda melanoleuca
9601198	9601198	PRJNA692200_S_NODE_20428_length_166_cov_0.880342_g20371_i0	PRJNA692200	20428	166	0.880342	1.46136772	Rhea pennata	8795	Chordata	Chordata	54.7	0.004	NTclustered	gi\|2663996219\|ref\|XM_062584940.1\|	8795	g20371	i0	100	0.873493975903614	29	0	17	0	54	82	4937	4965	PREDICTED: Rhea pennata centrosomal protein 290 (CEP290), transcript variant X4, mRNA	blastn	145	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Rheiformes	Rheidae	Rhea	Rhea pennata
9601250	9601250	PRJNA692200_S_NODE_23688_length_153_cov_4.384615_g23631_i0	PRJNA692200	23688	153	4.384615	6.70846095	Polypterus senegalus	55291	Chordata	Chordata	152	1.1999999999999999e-32	NTclustered	gi\|1993937637\|ref\|XM_039741126.1\|	55291	g23631	i0	88.889	8.61437908496732	126	11	81	3	27	150	1173	1297	PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA	blastn	1318	152	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
10876803	10876803	PRJNA692200_S_NODE_19989_length_167_cov_0.881356_g19932_i0	PRJNA692200	19989	167	0.881356	1.47186452	Mus musculus	10090	Chordata	Chordata	52.8	0.014	NTclustered	gi\|28300610\|emb\|AL845489.10\|	10090	g19932	i0	100	0.167664670658683	28	0	17	0	131	158	175556	175583	Mouse DNA sequence from clone RP23-300E5 on chromosome 2, complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10876849	10876849	PRJNA692200_S_NODE_21989_length_162_cov_1.345133_g21932_i0	PRJNA692200	21989	162	1.345133	2.17911546	Acanthisitta chloris	57068	Chordata	Chordata	52.8	0.013	NTclustered	gi\|678007806\|ref\|XM_009081696.1\|	57068	g21932	i0	100	0.172839506172839	28	0	17	0	68	95	1058	1085	PREDICTED: Acanthisitta chloris cell adhesion molecule 3 (CADM3), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Acanthisittidae	Acanthisitta	Acanthisitta chloris
12658620	12658620	PRJNA692200_S_NODE_11930_length_207_cov_1.632911_g11873_i0	PRJNA692200	11930	207	1.632911	3.38012577	Gopherus evgoodei	1825980	Chordata	Chordata	119	9.909999999999998e-31	NR	XP_030415344.1	1825980	g11873	i0	88.3	28.695652173913	60	7	87	0	1	180	241	300	XP_030415344.1 DNA repair protein RAD51 homolog 1 isoform X2 [Gopherus evgoodei]	diamond	5940	119	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Testudinidae	Gopherus	Gopherus evgoodei
13933280	13933280	PRJNA692200_S_NODE_9871_length_225_cov_1.653409_g9814_i0	PRJNA692200	9871	225	1.653409	3.72017025	Mustelidae	9655	Chordata	Chordata	58.4	4.3e-4	NTclustered	gi\|2223440451\|ref\|XM_047716428.1\|	9657	g9814	i0	100	5.63555555555556	31	0	14	0	186	216	580	550	PREDICTED: Lutra lutra LDOC1 regulator of NFKB signaling (LDOC1), mRNA	blastn	1268	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Lutra	Lutra lutra
15975208	15975208	PRJNA692200_S_NODE_10073_length_223_cov_1.373563_g10016_i0	PRJNA692200	10073	223	1.373563	3.06304549	Fringilla coelebs	37598	Chordata	Chordata	54.7	0.006	NTclustered	gi\|2917610922\|emb\|OZ228690.1\|	37598	g10016	i0	100	0.130044843049327	29	0	13	0	176	204	47343736	47343764	Fringilla coelebs genome assembly, chromosome: Z	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Fringilla	Fringilla coelebs
15975747	15975747	PRJNA692200_S_NODE_8653_length_237_cov_2.978723_g8596_i0	PRJNA692200	8653	237	2.978723	7.05957351	Tachyglossus aculeatus	9261	Chordata	Chordata	60.2	1.27e-4	NTclustered	gi\|1952428067\|ref\|XM_038772678.1\|	9261	g8596	i0	97.143	0.29535864978903	35	1	15	0	28	62	719	753	PREDICTED: Tachyglossus aculeatus acidic leucine-rich nuclear phosphoprotein 32 family member B-like (LOC119950360), transcript variant X2, mRNA	blastn	70	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Monotremata	Tachyglossidae	Tachyglossus	Tachyglossus aculeatus
16482120	16482120	PRJNA692200_S_NODE_7273_length_253_cov_3.210784_g7216_i0	PRJNA692200	7273	253	3.210784	8.12328352	Aves	8782	Chordata	Chordata	67.6	8.2e-7	NTclustered	gi\|699598148\|ref\|XM_009870665.1\|	57397	g7216	i0	90.385	3.64426877470356	52	3	20	2	55	105	874	924	PREDICTED: Apaloderma vittatum myosin-3 (LOC104274898), partial mRNA	blastn	922	67.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Trogoniformes	Trogonidae	Apaloderma	Apaloderma vittatum
17757105	17757105	PRJNA692200_S_NODE_22054_length_162_cov_0.920354_g21997_i0	PRJNA692200	22054	162	0.920354	1.49097348	root	1	Root_unresolved	Root_unresolved	86.1	1.33e-12	NTclustered	gi\|2635896824\|ref\|XM_061572672.1\|	7753	g21997	i0	90.625	27.8333333333333	64	6	40	0	52	115	1163	1100	PREDICTED: Lethenteron reissneri succinate-CoA ligase GDP-forming subunit beta (SUCLG2), mRNA	blastn	4509	86.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
18524987	18524987	PRJNA692200_S_NODE_8215_length_242_cov_1.227979_g8158_i0	PRJNA692200	8215	242	1.227979	2.97170918	Geospiza fortis	48883	Chordata	Chordata	52.8	0.022	NTclustered	gi\|1756857063\|ref\|XM_005426883.2\|	48883	g8158	i0	88.889	0.18595041322314	45	2	19	2	195	239	2277	2318	PREDICTED: Geospiza fortis terminal uridylyl transferase 7 (TUT7), mRNA	blastn	45	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Thraupidae	Geospiza	Geospiza fortis
19030948	19030948	PRJNA692200_S_NODE_19215_length_169_cov_1.250000_g19158_i0	PRJNA692200	19215	169	1.25	2.1125	Lampetra	13103	Chordata	Chordata	63.9	6.52e-6	NTclustered	gi\|2805715966\|emb\|OZ078417.1\|	7748	g19158	i0	100	3.32544378698225	34	0	20	0	3	36	1635819	1635852	Lampetra fluviatilis genome assembly, chromosome: 14	blastn	562	63.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
22856656	22856656	PRJNA692200_S_NODE_338_length_542_cov_668.328600_g307_i0	PRJNA692200	338	542	668.3286	3622.341012	Chordata	7711	Chordata	Chordata	199	5.310000000000001e-59	NR	KAJ1096059.1	8319	g307	i0	62.1	66.3985239852398	153	57	84.1	1	6	461	217	369	KAJ1096059.1 hypothetical protein NDU88_001206 [Pleurodeles waltl]	diamond	35988	201	0.990049751243781	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
22856666	22856666	PRJNA692200_S_NODE_6018_length_271_cov_1.108108_g5961_i0	PRJNA692200	6018	271	1.108108	3.00297268	Equus	9789	Chordata	Chordata	52.8	0.025	NTclustered	gi\|2868058376\|ref\|XR_011433748.1\|	9796	g5961	i0	96.875	0.236162361623616	32	0	12	1	54	85	7048	7018	PREDICTED: Equus caballus uncharacterized lncRNA (LOC111771081), transcript variant X1, ncRNA	blastn	64	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Perissodactyla	Equidae	Equus	Equus caballus
24898870	24898870	PRJNA692200_S_NODE_12840_length_201_cov_0.973684_g12783_i0	PRJNA692200	12840	201	0.973684	1.95710484	Branchiostoma lanceolatum	7740	Chordata	Chordata	87.9	4.79e-13	NTclustered	gi\|2770756960\|ref\|XM_066417902.1\|	7740	g12783	i0	81.731	2.47761194029851	104	19	52	0	98	201	1107	1004	PREDICTED: Branchiostoma lanceolatum electron transfer flavoprotein subunit alpha, mitochondrial-like (LOC136428422), mRNA	blastn	498	87.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum
24898991	24898991	PRJNA692200_S_NODE_17240_length_177_cov_1.445312_g17183_i0	PRJNA692200	17240	177	1.445312	2.55820224	Polypterus senegalus	55291	Chordata	Chordata	241	2.97e-59	NTclustered	gi\|1993937635\|ref\|XM_039741125.1\|	55291	g17183	i0	91.86	19.3050847457627	172	14	97	0	6	177	280	109	PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X1, mRNA	blastn	3417	241	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
27978270	27978270	PRJNA692200_S_NODE_5385_length_282_cov_2.639485_g5328_i0	PRJNA692200	5385	282	2.639485	7.4433477	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	66.6	2.2e-10	NR	XP_016008649.1	9407	g5328	i0	60	5.88297872340426	45	18	47.9	0	282	148	333	377	XP_016008649.1 dipeptidyl peptidase 1 isoform X2 [Rousettus aegyptiacus]	diamond	1659	67	0.994029850746269	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Pteropodidae	Rousettus	Rousettus aegyptiacus
29135455	29135455	PRJNA692200_S_NODE_6849_length_259_cov_2.152381_g6792_i0	PRJNA692200	6849	259	2.152381	5.57466679	Aquarana catesbeiana	8400	Chordata	Chordata	45.1	8.03e-4	NR	PIO16144.1	8400	g6792	i0	41.4	1.5984555984556	70	34	81.1	3	251	42	11	73	PIO16144.1 hypothetical protein AB205_0051180 [Aquarana catesbeiana]	diamond	414	45.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Aquarana	Aquarana catesbeiana
30367363	30367363	PRJNA692200_S_NODE_4692_length_295_cov_3.109756_g4635_i0	PRJNA692200	4692	295	3.109756	9.1737802	Cervus hanglu yarkandensis	84702	Chordata	Chordata	91.3	1.62e-21	NR	KAF4026532.1	84702	g4635	i0	51.1	2.4406779661017	90	39	86.4	2	14	268	12	101	KAF4026532.1 hypothetical protein G4228_018388, partial [Cervus hanglu yarkandensis]	diamond	720	91.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Cervus	Cervus hanglu
31863776	31863776	PRJNA692200_S_NODE_12017_length_206_cov_3.254777_g11960_i0	PRJNA692200	12017	206	3.254777	6.70484062	Metazoa	33208	Chordata	Chordata	43.5	0.0122	NR	XP_018425512.1	125878	g11960	i0	56.8	3.36407766990291	37	15	53.9	1	201	91	436	471	XP_018425512.1 PREDICTED: alanine aminotransferase 2 [Nanorana parkeri]	diamond	693	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dicroglossidae	Nanorana	Nanorana parkeri

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