metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1089179" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1089179" 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
194857	194857	PRJNA1089179_P_NODE_15401_length_247_cov_1.517241_g15383_i0	PRJNA1089179	15401	247	1.517241	3.74758527	Mus musculus	10090	Chordata	Chordata	457	4.05e-124	NTclustered	gi\|1907185816\|ref\|XR_391458.4\|	10090	g15383	i0	100	2	247	0	100	0	1	247	29516	29762	PREDICTED: Mus musculus predicted gene, 32849 (Gm32849), ncRNA	blastn	494	457	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
194872	194872	PRJNA1089179_P_NODE_17741_length_233_cov_2.268750_g17723_i0	PRJNA1089179	17741	233	2.26875	5.2861875	Mus musculus	10090	Chordata	Chordata	431	2.2899999999999996e-116	NTclustered	gi\|354781024\|gb\|JN945525.1\|	10090	g17723	i0	100	98.5407725321888	233	0	100	0	1	233	25802	25570	Mus musculus targeted deletion, lacZ-tagged mutant allele Ncoa4:tm1(KOMP)Ucd; transgenic	blastn	22960	431	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
194876	194876	PRJNA1089179_P_NODE_221_length_1036_cov_13.926272_g210_i0	PRJNA1089179	221	1036	13.926272	144.27617792	Apteryx mantelli	2696672	Chordata	Chordata	54.7	0.029	NTclustered	gi\|840016890\|emb\|LK066393.1\|	202946	g210	i0	100	0.027992277992278	29	0	3	0	610	638	207577	207549	Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold1803	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apterygiformes	Apterygidae	Apteryx	Apteryx mantelli
1469418	1469418	PRJNA1089179_P_NODE_15802_length_246_cov_0.890173_g15784_i0	PRJNA1089179	15802	246	0.890173	2.18982558	Mus musculus	10090	Chordata	Chordata	455	1.4500000000000002e-123	NTclustered	gi\|24111065\|gb\|AC121829.3\|	10090	g15784	i0	100	1	246	0	100	0	1	246	27435	27190	Mus musculus BAC clone RP23-480P21 from chromosome 5, complete sequence	blastn	246	455	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4021435	4021435	PRJNA1089179_P_NODE_12864_length_264_cov_1.408377_g12846_i0	PRJNA1089179	12864	264	1.408377	3.71811528	Felis catus	9685	Chordata	Chordata	52.8	0.024	NTclustered	gi\|193506888\|gb\|EU153401.1\|	9685	g12846	i0	100	0.106060606060606	28	0	11	0	41	68	2823445	2823418	Felis catus FLA extended class II, class II, class III, proximal and central class I region genomic sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
7847480	7847480	PRJNA1089179_P_NODE_16347_length_244_cov_0.900585_g16329_i0	PRJNA1089179	16347	244	0.900585	2.1974274	Mus musculus	10090	Chordata	Chordata	451	1.86e-122	NTclustered	gi\|45544808\|gb\|AC110171.29\|	10090	g16329	i0	100	2	244	0	100	0	1	244	2092	1849	Mus musculus chromosome 12, clone RP23-400A5, complete sequence	blastn	488	451	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7847485	7847485	PRJNA1089179_P_NODE_18287_length_200_cov_4.007874_g18269_i0	PRJNA1089179	18287	200	4.007874	8.015748	Rattus rattus	10117	Chordata	Chordata	327	2.58e-85	NTclustered	gi\|1820992308\|ref\|XM_032906490.1\|	10117	g18269	i0	99.444	5.415	180	1	90	0	21	200	861	682	PREDICTED: Rattus rattus homeobox A11 (Hoxa11), mRNA	blastn	1083	327	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus rattus
10398118	10398118	PRJNA1089179_P_NODE_2689_length_482_cov_2.022005_g2671_i0	PRJNA1089179	2689	482	2.022005	9.7460641	Polypterus senegalus	55291	Chordata	Chordata	54.7	0.013	NTclustered	gi\|1993940282\|ref\|XM_039743370.1\|	55291	g2671	i0	100	0.120331950207469	29	0	6	0	449	477	2163	2135	PREDICTED: Polypterus senegalus uncharacterized LOC120522434 (LOC120522434), transcript variant X1, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
11673479	11673479	PRJNA1089179_P_NODE_16110_length_245_cov_0.895349_g16092_i0	PRJNA1089179	16110	245	0.895349	2.19360505	Mus musculus	10090	Chordata	Chordata	453	5.1900000000000006e-123	NTclustered	gi\|53378872\|gb\|AC140256.3\|	10090	g16092	i0	100	17.0448979591837	245	0	100	0	1	245	50300	50544	Mus musculus BAC clone RP23-299A24 from 14, complete sequence	blastn	4176	453	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14223548	14223548	PRJNA1089179_P_NODE_15812_length_246_cov_0.890173_g15794_i0	PRJNA1089179	15812	246	0.890173	2.18982558	Mus musculus	10090	Chordata	Chordata	455	1.4500000000000002e-123	NTclustered	gi\|1907193064\|ref\|XR_003947566.2\|	10090	g15794	i0	100	39.2520325203252	246	0	100	0	1	246	497	252	PREDICTED: Mus musculus predicted gene, 30271 (Gm30271), transcript variant X2, ncRNA	blastn	9656	455	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14223553	14223553	PRJNA1089179_P_NODE_16592_length_243_cov_0.905882_g16574_i0	PRJNA1089179	16592	243	0.905882	2.20129326	Mus musculus	10090	Chordata	Chordata	449	6.65e-122	NTclustered	gi\|46518236\|emb\|AL929441.37\|	10090	g16574	i0	100	1	243	0	100	0	1	243	9554	9312	Mouse DNA sequence from clone RP23-418E20 on chromosome 4, complete sequence	blastn	243	449	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15497407	15497407	PRJNA1089179_P_NODE_14353_length_251_cov_1.292135_g14335_i0	PRJNA1089179	14353	251	1.292135	3.24325885	Mus musculus	10090	Chordata	Chordata	464	2.47e-126	NTclustered	gi\|25809473\|emb\|AL772320.12\|	10090	g14335	i0	100	2	251	0	100	0	1	251	111974	111724	Mouse DNA sequence from clone RP23-346F2 on chromosome 4, complete sequence	blastn	502	464	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15497434	15497434	PRJNA1089179_P_NODE_8213_length_316_cov_1.432099_g8195_i0	PRJNA1089179	8213	316	1.432099	4.52543284	Lontra canadensis	76717	Chordata	Chordata	54.7	0.008	NTclustered	gi\|1820923438\|ref\|XM_032845253.1\|	76717	g8195	i0	100	0.183544303797468	29	0	9	0	216	244	2038	2010	PREDICTED: Lontra canadensis vacuolar ATPase assembly factor VMA21 (VMA21), transcript variant X2, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Lontra	Lontra canadensis
16771796	16771796	PRJNA1089179_P_NODE_15434_length_247_cov_1.241379_g15416_i0	PRJNA1089179	15434	247	1.241379	3.06620613	Mus musculus	10090	Chordata	Chordata	457	4.05e-124	NTclustered	gi\|89145282\|emb\|CT025686.7\|	10090	g15416	i0	100	2	247	0	100	0	1	247	28413	28167	Mouse DNA sequence from clone RP24-273I13 on chromosome 14, complete sequence	blastn	494	457	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16771824	16771824	PRJNA1089179_P_NODE_4914_length_383_cov_65.441935_g4896_i0	PRJNA1089179	4914	383	65.441935	250.64261105	Mus musculus	10090	Chordata	Chordata	52.8	0.037	NTclustered	gi\|14329090\|gb\|AC020968.3\|	10090	g4896	i0	100	0.14621409921671	28	0	7	0	190	217	111650	111623	Mus musculus chromosome 18 clone RP23-193O23, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
18046503	18046503	PRJNA1089179_P_NODE_14255_length_251_cov_8.825843_g14237_i0	PRJNA1089179	14255	251	8.825843	22.15286593	Mus musculus	10090	Chordata	Chordata	425	1.16e-114	NTclustered	gi\|62526282\|gb\|AC157494.2\|	10090	g14237	i0	100	2.74900398406374	230	0	92	0	1	230	62543	62772	Mus musculus BAC clone RP23-2F1 from chromosome 12, complete sequence	blastn	690	425	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
18046511	18046511	PRJNA1089179_P_NODE_15515_length_247_cov_0.885057_g15497_i0	PRJNA1089179	15515	247	0.885057	2.18609079	Mus musculus	10090	Chordata	Chordata	457	4.05e-124	NTclustered	gi\|45917411\|gb\|AC139553.5\|	10090	g15497	i0	100	13.085020242915	247	0	100	0	1	247	88274	88028	Mus musculus chromosome 19, clone RP24-386E18, complete sequence	blastn	3232	457	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
21871618	21871618	PRJNA1089179_P_NODE_10078_length_291_cov_1.853211_g10060_i0	PRJNA1089179	10078	291	1.853211	5.39284401	Mus musculus	10090	Chordata	Chordata	52.8	0.027	NTclustered	gi\|34786904\|emb\|AL929167.10\|	10090	g10060	i0	100	0.0962199312714777	28	0	10	0	196	223	29570	29543	Mouse DNA sequence from clone RP23-5F14 on chromosome 2, complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
21871642	21871642	PRJNA1089179_P_NODE_15738_length_246_cov_0.890173_g15720_i0	PRJNA1089179	15738	246	0.890173	2.18982558	Mus musculus	10090	Chordata	Chordata	379	8.969999999999998e-101	NTclustered	gi\|82830679\|gb\|AC165956.4\|	10090	g15720	i0	100	1.00813008130081	205	0	100	0	42	246	125129	125333	Mus musculus BAC clone RP23-437I5 from chromosome 13, complete sequence	blastn	248	379	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
23146969	23146969	PRJNA1089179_P_NODE_14859_length_249_cov_1.602273_g14841_i0	PRJNA1089179	14859	249	1.602273	3.98965977	Mus musculus	10090	Chordata	Chordata	147	1e-30	NTclustered	gi\|117935732\|gb\|AC191865.3\|	10090	g14841	i0	77.824	7.08032128514056	239	51	96	2	6	243	177207	177444	Mus musculus BAC clone RP24-167O15 from chromosome 16, complete sequence	blastn	1763	147	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
25243898	25243898	PRJNA1089179_P_NODE_6360_length_348_cov_4.258182_g6342_i0	PRJNA1089179	6360	348	4.258182	14.81847336	Felidae	9681	Chordata	Chordata	52.8	0.033	NTclustered	gi\|2131073972\|ref\|XR_006592286.1\|	9685	g6342	i0	100	0.402298850574713	28	0	8	0	61	88	2179	2206	PREDICTED: Felis catus uncharacterized LOC111558511 (LOC111558511), transcript variant X3, ncRNA	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus

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