metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1132896" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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
283649	283649	PRJNA1132896_P_NODE_5801_length_263_cov_1.621053_g5710_i0	PRJNA1132896	5801	263	1.621053	4.26336939	Mus musculus	10090	Chordata	Chordata	486	5.5499999999999986e-133	NTclustered	gi\|157041231\|ref\|NG_006890.1\|	10090	g5710	i0	100	3.00380228136882	263	0	100	0	1	263	10957	11219	Mus musculus vomeronasal 2, receptor, pseudogene 56 (Vmn2r-ps56) on chromosome 7	blastn	790	486	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
283668	283668	PRJNA1132896_P_NODE_7861_length_248_cov_0.880000_g7770_i0	PRJNA1132896	7861	248	0.88	2.1824	Mus musculus	10090	Chordata	Chordata	453	5.2600000000000005e-123	NTclustered	gi\|37360081\|dbj\|AK129209.1\|	10090	g7770	i0	99.597	40.4314516129032	248	1	100	0	1	248	4323	4076	Mus musculus premature mRNA for mKIAA0767 protein	blastn	10027	453	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
1558205	1558205	PRJNA1132896_P_NODE_3302_length_310_cov_2.687764_g3211_i0	PRJNA1132896	3302	310	2.687764	8.3320684	Pyrrhula murina	928672	Chordata	Chordata	52.8	0.029	NTclustered	gi\|2920008277\|emb\|OZ239010.1\|	928672	g3211	i0	100	0.0903225806451613	28	0	9	0	95	122	6907218	6907245	Pyrrhula murina genome assembly, chromosome: 15	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Pyrrhula	Pyrrhula murina
2307124	2307124	PRJNA1132896_P_NODE_6782_length_251_cov_0.865169_g6691_i0	PRJNA1132896	6782	251	0.865169	2.17157419	root	1	Root_unresolved	Root_unresolved	464	2.47e-126	NTclustered	gi\|23271606\|gb\|BC036149.1\|	10090	g6691	i0	100	38.4980079681275	251	0	100	0	1	251	3230	2980	Mus musculus family with sequence similarity 83, member H, mRNA (cDNA clone IMAGE:4976934), partial cds	blastn	9663	464	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4110702	4110702	PRJNA1132896_P_NODE_9804_length_242_cov_0.911243_g9713_i0	PRJNA1132896	9804	242	0.911243	2.20520806	Branchiostoma lanceolatum	7740	Chordata	Chordata	54.7	0.006	NTclustered	gi\|2770776026\|ref\|XM_066427943.1\|	7740	g9713	i0	100	0.119834710743802	29	0	12	0	50	78	560	588	PREDICTED: Branchiostoma lanceolatum serine/threonine-protein kinase Nek4-like (LOC136434860), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum
5386882	5386882	PRJNA1132896_P_NODE_9265_length_244_cov_0.900585_g9174_i0	PRJNA1132896	9265	244	0.900585	2.1974274	Phacochoerus africanus	41426	Chordata	Chordata	145	3.53e-30	NTclustered	gi\|2225091091\|ref\|XM_047764663.1\|	41426	g9174	i0	84	61.1639344262295	150	24	61	0	1	150	352	203	PREDICTED: Phacochoerus africanus N-alpha-acetyltransferase 10, NatA catalytic subunit (NAA10), mRNA	blastn	14924	145	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Phacochoerus	Phacochoerus africanus
6134583	6134583	PRJNA1132896_P_NODE_3525_length_301_cov_1.350877_g3434_i0	PRJNA1132896	3525	301	1.350877	4.06613977	Metazoa	33208	Chordata	Chordata	56.5	0.002	NTclustered	gi\|2716852727\|ref\|XM_009515144.2\|	9209	g3434	i0	96.97	3.79401993355482	33	1	11	0	197	229	1210	1242	PREDICTED: Phalacrocorax carbo interferon lambda receptor 1 (IFNLR1), mRNA	blastn	1142	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Suliformes	Phalacrocoracidae	Phalacrocorax	Phalacrocorax carbo
6661541	6661541	PRJNA1132896_P_NODE_8606_length_246_cov_0.890173_g8515_i0	PRJNA1132896	8606	246	0.890173	2.18982558	Mus musculus	10090	Chordata	Chordata	455	1.4500000000000002e-123	NTclustered	gi\|28204904\|gb\|BC046384.1\|	10090	g8515	i0	100	37.8048780487805	246	0	100	0	1	246	1740	1985	Mus musculus chloride intracellular channel 4 (mitochondrial), mRNA (cDNA clone MGC:51372 IMAGE:3155573), complete cds	blastn	9300	455	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7409679	7409679	PRJNA1132896_P_NODE_6046_length_260_cov_1.491979_g5955_i0	PRJNA1132896	6046	260	1.491979	3.8791454	Lampetra	13103	Chordata	Chordata	60.2	1.42e-4	NTclustered	gi\|2805714469\|emb\|OZ078412.1\|	7748	g5955	i0	100	12.7576923076923	32	0	12	0	172	203	3086418	3086387	Lampetra fluviatilis genome assembly, chromosome: 9	blastn	3317	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
9211682	9211682	PRJNA1132896_P_NODE_8768_length_245_cov_0.895349_g8677_i0	PRJNA1132896	8768	245	0.895349	2.19360505	Mus musculus	10090	Chordata	Chordata	451	1.87e-122	NTclustered	gi\|74190587\|dbj\|AK144558.1\|	10090	g8677	i0	100	15.8285714285714	244	0	99	0	1	244	1624	1381	Mus musculus adult male accessory axillary lymph node cDNA, RIKEN full-length enriched library, clone:G630097D12 product:ATPase, Class V, type 10D, full insert sequence	blastn	3878	451	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10487171	10487171	PRJNA1132896_P_NODE_7109_length_250_cov_0.870056_g7018_i0	PRJNA1132896	7109	250	0.870056	2.17514	Mus musculus	10090	Chordata	Chordata	451	1.91e-122	NTclustered	gi\|70668960\|gb\|AC151263.3\|	10090	g7018	i0	99.2	2	250	2	100	0	1	250	67338	67089	Mus musculus BAC clone RP24-464I20 from chromosome 17, complete sequence	blastn	500	451	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11762278	11762278	PRJNA1132896_P_NODE_9270_length_244_cov_0.900585_g9179_i0	PRJNA1132896	9270	244	0.900585	2.1974274	Mus musculus	10090	Chordata	Chordata	451	1.86e-122	NTclustered	gi\|1562203513\|ref\|NM_001357242.2\|	10090	g9179	i0	100	99.8934426229508	244	0	100	0	1	244	796	1039	Mus musculus BRO1 domain and CAAX motif containing (Brox), transcript variant 2, mRNA	blastn	24374	451	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13037390	13037390	PRJNA1132896_P_NODE_8771_length_245_cov_0.895349_g8680_i0	PRJNA1132896	8771	245	0.895349	2.19360505	Mus musculus	10090	Chordata	Chordata	420	5.26e-113	NTclustered	gi\|27694064\|gb\|BC043336.1\|	10090	g8680	i0	99.565	58.734693877551	230	1	94	0	1	230	2135	2364	Mus musculus mucin-like protocadherin, mRNA (cDNA clone MGC:49520 IMAGE:5042289), complete cds	blastn	14390	420	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14312525	14312525	PRJNA1132896_P_NODE_10252_length_241_cov_0.916667_g10161_i0	PRJNA1132896	10252	241	0.916667	2.20916747	Mus musculus	10090	Chordata	Chordata	446	8.519999999999999e-121	NTclustered	gi\|55701397\|gb\|AC101684.13\|	10090	g10161	i0	100	1	241	0	100	0	1	241	40661	40901	Mus musculus chromosome 1, clone RP23-187I13, complete sequence	blastn	241	446	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14312551	14312551	PRJNA1132896_P_NODE_4632_length_280_cov_1.478261_g4541_i0	PRJNA1132896	4632	280	1.478261	4.1391308	Mus musculus	10090	Chordata	Chordata	518	2.12e-142	NTclustered	gi\|58036634\|gb\|AC117715.10\|	10090	g4541	i0	100	78.5214285714286	280	0	100	0	1	280	73796	73517	Mus musculus chromosome 7, clone RP23-62M19, complete sequence	blastn	21986	518	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14312613	14312613	PRJNA1132896_P_NODE_9872_length_242_cov_0.911243_g9781_i0	PRJNA1132896	9872	242	0.911243	2.20520806	Mus musculus	10090	Chordata	Chordata	442	1.1099999999999995e-119	NTclustered	gi\|12805564\|gb\|BC002260.1\|	10090	g9781	i0	99.587	12.6115702479339	242	1	100	0	1	242	1237	1478	Mus musculus PC4 and SFRS1 interacting protein 1, mRNA (cDNA clone IMAGE:3494613), partial cds	blastn	3052	442	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16860836	16860836	PRJNA1132896_P_NODE_6354_length_256_cov_0.994536_g6263_i0	PRJNA1132896	6354	256	0.994536	2.54601216	Erinaceus europaeus	9365	Chordata	Chordata	89.8	1.77e-13	NTclustered	gi\|2591632720\|ref\|XM_007532722.3\|	9365	g6263	i0	96.296	12.375	54	2	21	0	58	111	728	675	PREDICTED: Erinaceus europaeus protein disulfide isomerase family A member 4 (PDIA4), mRNA	blastn	3168	89.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Eulipotyphla	Erinaceidae	Erinaceus	Erinaceus europaeus
19409568	19409568	PRJNA1132896_P_NODE_8776_length_245_cov_0.895349_g8685_i0	PRJNA1132896	8776	245	0.895349	2.19360505	Mus musculus	10090	Chordata	Chordata	449	6.710000000000001e-122	NTclustered	gi\|26325621\|dbj\|AK029690.1\|	10090	g8685	i0	100	17.7142857142857	243	0	99	0	1	243	1694	1936	Mus musculus adult male testis cDNA, RIKEN full-length enriched library, clone:4930471C14 product:ribose-phosphate pyrophosphokinase (EC 2.7.6.1) catalytic chain II homolog [Rattus norvegicus], full insert sequence	blastn	4340	449	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
21433688	21433688	PRJNA1132896_P_NODE_9077_length_244_cov_0.900585_g8986_i0	PRJNA1132896	9077	244	0.900585	2.1974274	Chordata	7711	Chordata	Chordata	451	1.86e-122	NTclustered	gi\|120577631\|gb\|BC130156.1\|	8355	g8986	i0	100	99.4139344262295	244	0	100	0	1	244	1090	1333	Xenopus laevis ADP-ribosylation factor 1, mRNA (cDNA clone MGC:160711 IMAGE:7201256), complete cds	blastn	24257	451	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
21960448	21960448	PRJNA1132896_P_NODE_7998_length_248_cov_0.874286_g7907_i0	PRJNA1132896	7998	248	0.874286	2.16822928	Mus musculus	10090	Chordata	Chordata	446	8.81e-121	NTclustered	gi\|671696010\|ref\|NM_001301330.1\|	10090	g7907	i0	99.19	97.6975806451613	247	2	99	0	1	247	293	539	Mus musculus WAPL cohesin release factor (Wapl), transcript variant 2, mRNA	blastn	24229	446	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
23235958	23235958	PRJNA1132896_P_NODE_7379_length_249_cov_1.676136_g7288_i0	PRJNA1132896	7379	249	1.676136	4.17357864	Gallus gallus	9031	Chordata	Chordata	54.7	0.006	NTclustered	gi\|116643033\|gb\|AC189018.3\|	9031	g7288	i0	96.875	0.257028112449799	32	1	13	0	18	49	177726	177757	Gallus gallus BAC clone CH261-138K4 from chromosome z, complete sequence	blastn	64	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
23235964	23235964	PRJNA1132896_P_NODE_7519_length_249_cov_0.875000_g7428_i0	PRJNA1132896	7519	249	0.875	2.17875	Mus musculus	10090	Chordata	Chordata	460	3.16e-125	NTclustered	gi\|354796342\|gb\|JN960843.1\|	10090	g7428	i0	100	5.02409638554217	249	0	100	0	1	249	28351	28599	Mus musculus targeted non-conditional, lacZ-tagged mutant allele Lama5:tm1e(KOMP)Wtsi; transgenic	blastn	1251	460	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24509540	24509540	PRJNA1132896_P_NODE_10100_length_241_cov_1.083333_g10009_i0	PRJNA1132896	10100	241	1.083333	2.61083253	Mus musculus	10090	Chordata	Chordata	446	8.519999999999999e-121	NTclustered	gi\|74192697\|dbj\|AK159167.1\|	10090	g10009	i0	100	100.261410788382	241	0	100	0	1	241	637	877	Mus musculus osteoclast-like cell cDNA, RIKEN full-length enriched library, clone:I420007A10 product:prosaposin, full insert sequence	blastn	24163	446	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24509580	24509580	PRJNA1132896_P_NODE_4900_length_276_cov_1.995074_g4809_i0	PRJNA1132896	4900	276	1.995074	5.50640424	Mus musculus	10090	Chordata	Chordata	505	1.62e-138	NTclustered	gi\|77404057\|gb\|AC158579.7\|	10090	g4809	i0	99.639	4.01449275362319	277	0	100	1	1	276	159334	159058	Mus musculus chromosome 7, clone RP24-180F12, complete sequence	blastn	1108	505	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus

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