metadata: contig_metadata: 28 rows where bioproject = "PRJNA1167252", tax_clade = "Opisthokonta" and tax

28 rows where bioproject = "PRJNA1167252", tax_clade = "Opisthokonta" 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
314440	314440	PRJNA1167252_P_NODE_19101_length_279_cov_1.509709_g18828_i0	PRJNA1167252	19101	279	1.509709	4.21208811	Mus musculus	10090	Chordata	Chordata	516	7.58e-142	NTclustered	gi\|34785997\|gb\|BC058078.1\|	10090	g18828	i0	100	13.7204301075269	279	0	100	0	1	279	3105	3383	Mus musculus protein phosphatase 1, regulatory (inhibitor) subunit 15b, mRNA (cDNA clone IMAGE:6830215), containing frame-shift errors	blastn	3828	516	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
314674	314674	PRJNA1167252_P_NODE_27481_length_245_cov_0.906977_g27208_i0	PRJNA1167252	27481	245	0.906977	2.22209365	Mus musculus	10090	Chordata	Chordata	453	5.1900000000000006e-123	NTclustered	gi\|18606362\|gb\|BC022924.1\|	10090	g27208	i0	100	79.9959183673469	245	0	100	0	1	245	1599	1843	Mus musculus ST6 (alpha-N-acetyl-neuraminyl-2,3-beta-galactosyl-1,3)-N-acetylgalactosaminide alpha-2,6-sialyltransferase 6, mRNA (cDNA clone MGC:28567 IMAGE:4208472), complete cds	blastn	19599	453	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
2865433	2865433	PRJNA1167252_P_NODE_26583_length_247_cov_0.896552_g26310_i0	PRJNA1167252	26583	247	0.896552	2.21448344	Mus musculus	10090	Chordata	Chordata	457	4.05e-124	NTclustered	gi\|12839178\|dbj\|AK006207.1\|	10090	g26310	i0	100	92.6153846153846	247	0	100	0	1	247	11	257	Mus musculus adult male testis cDNA, RIKEN full-length enriched library, clone:1700021I06 product:Z-PROTEIN (0610007H07RIK) homolog [Mus musculus], full insert sequence	blastn	22876	457	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
3590268	3590268	PRJNA1167252_P_NODE_14623_length_321_cov_2.201613_g14350_i0	PRJNA1167252	14623	321	2.201613	7.06717773	Mus	10088	Chordata	Chordata	593	3.9899999999999986e-165	NTclustered	gi\|354787773\|gb\|JN952274.1\|	10090	g14350	i0	100	99.9501557632399	321	0	100	0	1	321	25499	25819	Mus musculus targeted non-conditional, lacZ-tagged mutant allele Gpx3:tm1e(KOMP)Wtsi; transgenic	blastn	32084	593	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7417616	7417616	PRJNA1167252_P_NODE_13386_length_337_cov_1.181818_g13113_i0	PRJNA1167252	13386	337	1.181818	3.98272666	Mus	10088	Chordata	Chordata	623	5.369999999999999e-174	NTclustered	gi\|756142290\|gb\|KP260515.1\|	10090	g13113	i0	100	100	337	0	100	0	1	337	3029	2693	Mus musculus strain ME mitochondrion, complete genome	blastn	33700	623	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7967997	7967997	PRJNA1167252_P_NODE_29007_length_243_cov_0.917647_g28734_i0	PRJNA1167252	29007	243	0.917647	2.22988221	Mus musculus	10090	Chordata	Chordata	448	2.39e-121	NTclustered	gi\|19572155\|emb\|AL671215.4\|	10090	g28734	i0	100	5.2962962962963	242	0	99	0	2	243	153981	154222	Mouse DNA sequence from clone RP23-277C18 on chromosome X, complete sequence	blastn	1287	448	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7968005	7968005	PRJNA1167252_P_NODE_29287_length_242_cov_0.923077_g29014_i0	PRJNA1167252	29287	242	0.923077	2.23384634	Mus musculus	10090	Chordata	Chordata	448	2.3799999999999995e-121	NTclustered	gi\|13518120\|gb\|AC087233.6\|	10090	g29014	i0	100	2	242	0	100	0	1	242	138249	138490	Mus Musculus Chromosome 17 RP23-476A24, complete sequence	blastn	484	448	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
8692943	8692943	PRJNA1167252_P_NODE_28807_length_243_cov_0.917647_g28534_i0	PRJNA1167252	28807	243	0.917647	2.22988221	Panthera	9688	Chordata	Chordata	52.8	0.022	NTclustered	gi\|2079052933\|ref\|XM_042930812.1\|	9689	g28534	i0	100	0.921810699588477	28	0	12	0	216	243	86	113	PREDICTED: Panthera leo cathepsin A (CTSA), transcript variant X1, mRNA	blastn	224	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Panthera	Panthera leo
10518207	10518207	PRJNA1167252_P_NODE_23329_length_252_cov_0.871508_g23056_i0	PRJNA1167252	23329	252	0.871508	2.19620016	Columba livia	8932	Chordata	Chordata	285	2.07e-72	NTclustered	gi\|2728248450\|ref\|XR_002417937.2\|	8932	g23056	i0	87.352	28.9642857142857	253	26	99	6	2	251	4171	4420	PREDICTED: Columba livia uncharacterized LOC110361372 (LOC110361372), ncRNA	blastn	7299	285	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Columbiformes	Columbidae	Columba	Columba livia
12518504	12518504	PRJNA1167252_P_NODE_16890_length_297_cov_1.392857_g16617_i0	PRJNA1167252	16890	297	1.392857	4.13678529	Equus	9789	Chordata	Chordata	58.4	5.93e-4	NTclustered	gi\|2867947010\|ref\|XM_070231414.1\|	9796	g16617	i0	97.143	4.05387205387205	35	0	12	1	254	288	250	217	PREDICTED: Equus caballus gamma-aminobutyric acid type A receptor subunit alpha5 (GABRA5), transcript variant X6, mRNA	blastn	1204	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Perissodactyla	Equidae	Equus	Equus caballus
13068285	13068285	PRJNA1167252_P_NODE_28891_length_243_cov_0.917647_g28618_i0	PRJNA1167252	28891	243	0.917647	2.22988221	Mus musculus	10090	Chordata	Chordata	449	6.65e-122	NTclustered	gi\|82654643\|gb\|AC163040.5\|	10090	g28618	i0	100	1	243	0	100	0	1	243	132981	133223	Mus musculus BAC clone RP23-71C23 from chromosome 12, complete sequence	blastn	243	449	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14343473	14343473	PRJNA1167252_P_NODE_22432_length_254_cov_1.337017_g22159_i0	PRJNA1167252	22432	254	1.337017	3.39602318	Sorex araneus	42254	Chordata	Chordata	52.8	0.023	NTclustered	gi\|2487341500\|ref\|XM_055145249.1\|	42254	g22159	i0	100	0.110236220472441	28	0	11	0	4	31	574	601	PREDICTED: Sorex araneus CKLF like MARVEL transmembrane domain containing 3 (CMTM3), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Eulipotyphla	Soricidae	Sorex	Sorex araneus
14343595	14343595	PRJNA1167252_P_NODE_26972_length_246_cov_0.901734_g26699_i0	PRJNA1167252	26972	246	0.901734	2.21826564	Mus musculus	10090	Chordata	Chordata	455	1.4500000000000002e-123	NTclustered	gi\|84872403\|gb\|AC107689.7\|	10090	g26699	i0	100	1	246	0	100	0	1	246	34670	34915	Mus musculus chromosome 3, clone RP24-283F19, complete sequence	blastn	246	455	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15067359	15067359	PRJNA1167252_P_NODE_10112_length_394_cov_2.760125_g9839_i0	PRJNA1167252	10112	394	2.760125	10.8748925	Passeriformes	9126	Chordata	Chordata	52.8	0.038	NTclustered	gi\|1832441299\|ref\|XM_033518869.1\|	9157	g9839	i0	100	0.284263959390863	28	0	7	0	219	246	1286	1313	PREDICTED: Parus major POM121 transmembrane nucleoporin (POM121), mRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Paridae	Parus	Parus major
15617029	15617029	PRJNA1167252_P_NODE_13473_length_336_cov_0.840304_g13200_i0	PRJNA1167252	13473	336	0.840304	2.82342144	Microcosmus squamiger	439822	Chordata	Chordata	204	8.269999999999999e-48	NTclustered	gi\|311334493\|emb\|FN984772.1\|	439822	g13200	i0	80.608	14.6875	263	51	78	0	62	324	265	3	Microcosmus squamiger partial mRNA for ribosomal protein L27a (rpl27A gene)	blastn	4935	204	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Pyuridae	Microcosmus	Microcosmus squamiger
15617410	15617410	PRJNA1167252_P_NODE_26993_length_246_cov_0.901734_g26720_i0	PRJNA1167252	26993	246	0.901734	2.21826564	Mus musculus	10090	Chordata	Chordata	455	1.4500000000000002e-123	NTclustered	gi\|48843944\|gb\|AC119954.12\|	10090	g26720	i0	100	1	246	0	100	0	1	246	38520	38765	Mus musculus chromosome 1, clone RP24-450P2, complete sequence	blastn	246	455	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16891743	16891743	PRJNA1167252_P_NODE_27494_length_245_cov_0.906977_g27221_i0	PRJNA1167252	27494	245	0.906977	2.22209365	Mus musculus	10090	Chordata	Chordata	453	5.1900000000000006e-123	NTclustered	gi\|66792972\|gb\|AC153870.8\|	10090	g27221	i0	100	1.48163265306122	245	0	100	0	1	245	147228	146984	Mus musculus 10 BAC RP23-473J14 (Roswell Park Cancer Institute (C57BL/6J Female) Mouse BAC Library) complete sequence	blastn	363	453	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16891782	16891782	PRJNA1167252_P_NODE_28954_length_243_cov_0.917647_g28681_i0	PRJNA1167252	28954	243	0.917647	2.22988221	Mus musculus	10090	Chordata	Chordata	449	6.65e-122	NTclustered	gi\|46064707\|gb\|AC140249.2\|	10090	g28681	i0	100	2	243	0	100	0	1	243	122940	122698	Mus musculus BAC clone RP24-285O1 from chromosome 12, complete sequence	blastn	486	449	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
17617909	17617909	PRJNA1167252_P_NODE_8534_length_436_cov_1.402204_g8261_i0	PRJNA1167252	8534	436	1.402204	6.11360944	Mus	10088	Chordata	Chordata	804	0	NTclustered	gi\|846387586\|dbj\|LC061956.1\|	10090	g8261	i0	100	99.7706422018349	435	0	99	0	2	436	2455	2021	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_5	blastn	43500	804	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
18166148	18166148	PRJNA1167252_P_NODE_22915_length_253_cov_0.866667_g22642_i0	PRJNA1167252	22915	253	0.866667	2.19266751	Mus musculus	10090	Chordata	Chordata	468	1.92e-127	NTclustered	gi\|72097061\|gb\|AC157766.4\|	10090	g22642	i0	100	2	253	0	100	0	1	253	39324	39576	Mus musculus chromosome 1, clone RP24-318F24, complete sequence	blastn	506	468	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20166084	20166084	PRJNA1167252_P_NODE_12336_length_353_cov_1.114286_g12063_i0	PRJNA1167252	12336	353	1.114286	3.93342958	Mus	10088	Chordata	Chordata	652	0	NTclustered	gi\|846387676\|dbj\|LC061971.1\|	10090	g12063	i0	100	100	353	0	100	0	1	353	1557	1205	Mus musculus mitochondrion DNA, including COX1, tRNA-Ser, tRNA-Asp, COX2, tRNA-Lys, ATP8, ATP6 genes, complete sequence, sequence_id: (5951..8605)_20	blastn	35300	652	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20715980	20715980	PRJNA1167252_P_NODE_26897_length_246_cov_0.901734_g26624_i0	PRJNA1167252	26897	246	0.901734	2.21826564	Alectoris rufa	9079	Chordata	Chordata	381	2.5e-101	NTclustered	gi\|2919602046\|emb\|OZ238769.1\|	9079	g26624	i0	94.715	2	246	12	100	1	1	246	85271018	85270774	Alectoris rufa genome assembly, chromosome: 4	blastn	492	381	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Alectoris	Alectoris rufa
21991299	21991299	PRJNA1167252_P_NODE_27498_length_245_cov_0.906977_g27225_i0	PRJNA1167252	27498	245	0.906977	2.22209365	Apteryx mantelli	2696672	Chordata	Chordata	185	2.09e-42	NTclustered	gi\|840008629\|emb\|LK064621.1\|	202946	g27225	i0	83.838	0.808163265306122	198	29	80	2	51	245	1046842	1046645	Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold42	blastn	198	185	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apterygiformes	Apterygidae	Apteryx	Apteryx mantelli
23266776	23266776	PRJNA1167252_P_NODE_24759_length_250_cov_0.881356_g24486_i0	PRJNA1167252	24759	250	0.881356	2.20339	Mus musculus	10090	Chordata	Chordata	451	1.91e-122	NTclustered	gi\|26081940\|dbj\|AK030675.1\|	10090	g24486	i0	99.203	4.016	251	0	99	1	1	249	2031	2281	Mus musculus 6 days neonate head cDNA, RIKEN full-length enriched library, clone:5430421B17 product:unclassifiable, full insert sequence	blastn	1004	451	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
23266818	23266818	PRJNA1167252_P_NODE_26659_length_247_cov_0.885057_g26386_i0	PRJNA1167252	26659	247	0.885057	2.18609079	Mus musculus	10090	Chordata	Chordata	440	4.079999999999999e-119	NTclustered	gi\|68342053\|gb\|AC158628.7\|	10090	g26386	i0	98.785	2	247	3	100	0	1	247	156638	156884	Mus musculus 6 BAC RP23-147K11 (Roswell Park Cancer Institute (C57BL/6J Female) Mouse BAC Library) complete sequence	blastn	494	440	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24540536	24540536	PRJNA1167252_P_NODE_26380_length_247_cov_0.896552_g26107_i0	PRJNA1167252	26380	247	0.896552	2.21448344	Mus musculus	10090	Chordata	Chordata	457	4.05e-124	NTclustered	gi\|52421435\|gb\|AC102354.14\|	10090	g26107	i0	100	2	247	0	100	0	1	247	117371	117617	Mus musculus chromosome 17, clone RP23-80J17, complete sequence	blastn	494	457	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
27640943	27640943	PRJNA1167252_P_NODE_26124_length_247_cov_1.609195_g25851_i0	PRJNA1167252	26124	247	1.609195	3.97471165	Scyliorhinus canicula	7830	Chordata	Chordata	160	6.03e-48	NR	XP_038652922.1	7830	g25851	i0	97.5	42.2550607287449	81	2	98.4	0	245	3	7	87	XP_038652922.1 60S ribosomal protein L13a isoform X2 [Scyliorhinus canicula]	diamond	10437	160	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Carcharhiniformes	Scyliorhinidae	Scyliorhinus	Scyliorhinus canicula
28398531	28398531	PRJNA1167252_P_NODE_16146_length_305_cov_1.327586_g15873_i0	PRJNA1167252	16146	305	1.327586	4.0491373	Ranitomeya imitator	111125	Chordata	Chordata	63.5	3.81e-9	NR	CAJ0933392.1	111125	g15873	i0	62.5	0.472131147540984	48	16	45.2	1	31	168	53	100	CAJ0933392.1 unnamed protein product [Ranitomeya imitator]	diamond	144	63.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator

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