metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJEB75227" and tax

25 rows where analysis = "blastn", bioproject = "PRJEB75227" 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
135664	135664	PRJEB75227_P_NODE_8801_length_251_cov_0.876404_g8630_i0	PRJEB75227	8801	251	0.876404	2.19977404	Gallus gallus	9031	Chordata	Chordata	453	5.34e-123	NTclustered	gi\|2201689789\|ref\|XM_046943656.1\|	9031	g8630	i0	99.203	66.9402390438247	251	2	100	0	1	251	5172	5422	PREDICTED: Gallus gallus signal transducing adaptor molecule 2 (STAM2), transcript variant X2, mRNA	blastn	16802	453	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
1410252	1410252	PRJEB75227_P_NODE_6782_length_275_cov_1.544554_g6611_i0	PRJEB75227	6782	275	1.544554	4.2475235	Sus scrofa	9823	Chordata	Chordata	95.3	4.14e-15	NTclustered	gi\|1191801811\|ref\|XR_002341200.1\|	9823	g6611	i0	100	1.65818181818182	51	0	19	0	225	275	2834	2784	PREDICTED: Sus scrofa uncharacterized LOC102166957 (LOC102166957), transcript variant X2, ncRNA	blastn	456	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
3961803	3961803	PRJEB75227_P_NODE_7964_length_256_cov_1.207650_g7793_i0	PRJEB75227	7964	256	1.20765	3.091584	Pituophis catenifer	94850	Chordata	Chordata	52.8	0.023	NTclustered	gi\|2893867960\|ref\|XM_070949806.1\|	94852	g7793	i0	100	0.21875	28	0	11	0	127	154	2726	2699	PREDICTED: Pituophis catenifer annectens zinc finger protein 574 (ZNF574), transcript variant X1, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Colubridae	Pituophis	Pituophis catenifer
5238159	5238159	PRJEB75227_P_NODE_11085_length_244_cov_0.912281_g10914_i0	PRJEB75227	11085	244	0.912281	2.22596564	Sus scrofa	9823	Chordata	Chordata	158	4.53e-34	NTclustered	gi\|224762785\|emb\|CU407122.4\|	9823	g10914	i0	95	51.0819672131148	100	5	41	0	145	244	76055	76154	Pig DNA sequence from clone CH242-52A15 on chromosome X, complete sequence	blastn	12464	158	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
5238161	5238161	PRJEB75227_P_NODE_11165_length_244_cov_0.912281_g10994_i0	PRJEB75227	11165	244	0.912281	2.22596564	Sus scrofa	9823	Chordata	Chordata	58.4	4.73e-4	NTclustered	gi\|1191886276\|ref\|XR_002344678.1\|	9823	g10994	i0	100	0.770491803278688	31	0	13	0	203	233	1321	1291	PREDICTED: Sus scrofa uncharacterized LOC110260999 (LOC110260999), transcript variant X2, misc_RNA	blastn	188	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
5238232	5238232	PRJEB75227_P_NODE_9685_length_248_cov_0.891429_g9514_i0	PRJEB75227	9685	248	0.891429	2.21074392	Gallus gallus	9031	Chordata	Chordata	401	1.9299999999999994e-107	NTclustered	gi\|111120395\|gb\|AC186854.2\|	9031	g9514	i0	96.386	79.2338709677419	249	0	100	4	1	248	168222	167982	Gallus gallus BAC clone CH261-10D22 from chromosome z, complete sequence	blastn	19650	401	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
7788046	7788046	PRJEB75227_P_NODE_7287_length_267_cov_1.371134_g7116_i0	PRJEB75227	7287	267	1.371134	3.66092778	Sus scrofa	9823	Chordata	Chordata	222	1.76e-53	NTclustered	gi\|195945747\|emb\|CU468466.12\|	9823	g7116	i0	88.649	182.067415730337	185	18	99	3	2	184	49487	49670	Pig DNA sequence from clone CH242-229D21 on chromosome X, complete sequence	blastn	48612	222	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
7788068	7788068	PRJEB75227_P_NODE_9647_length_248_cov_1.388571_g9476_i0	PRJEB75227	9647	248	1.388571	3.44365608	Gallus gallus	9031	Chordata	Chordata	305	1.56e-78	NTclustered	gi\|297306136\|dbj\|AB556497.1\|	9031	g9476	i0	90.83	10.5120967741935	229	19	92	2	4	230	175	403	Gallus gallus DNA, CENP-A associated sequence, partial sequence, clone: CAIP#198	blastn	2607	305	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
10338703	10338703	PRJEB75227_P_NODE_6389_length_281_cov_2.576923_g6218_i0	PRJEB75227	6389	281	2.576923	7.24115363	Gallus gallus	9031	Chordata	Chordata	520	5.909999999999999e-143	NTclustered	gi\|2024360878\|ref\|XR_005840240.1\|	9031	g6218	i0	100	71.0177935943061	281	0	100	0	1	281	1248	968	PREDICTED: Gallus gallus 28S ribosomal RNA (LOC121106977), rRNA	blastn	19956	520	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
11198959	11198959	PRJEB75227_P_NODE_7529_length_263_cov_1.400000_g7358_i0	PRJEB75227	7529	263	1.4	3.682	Bovidae	9895	Chordata	Chordata	388	1.61e-103	NTclustered	gi\|2633717494\|ref\|XR_009740327.1\|	9906	g7358	i0	93.208	711.003802281369	265	16	100	2	1	263	82	346	PREDICTED: Bos javanicus dihydrodiol dehydrogenase 3-like (LOC133259245), transcript variant X6, misc_RNA	blastn	186994	388	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
11198963	11198963	PRJEB75227_P_NODE_8309_length_253_cov_0.866667_g8138_i0	PRJEB75227	8309	253	0.866667	2.19266751	Phasianidae	9005	Chordata	Chordata	390	4.28e-104	NTclustered	gi\|2919602537\|emb\|OZ238770.1\|	9079	g8138	i0	94.466	2	253	14	100	0	1	253	36102811	36102559	Alectoris rufa genome assembly, chromosome: 5	blastn	506	390	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Alectoris	Alectoris rufa
11614099	11614099	PRJEB75227_P_NODE_10130_length_247_cov_0.896552_g9959_i0	PRJEB75227	10130	247	0.896552	2.21448344	Alectoris rufa	9079	Chordata	Chordata	279	9.41e-71	NTclustered	gi\|2919603366\|emb\|OZ238775.1\|	9079	g9959	i0	87.059	1.03238866396761	255	24	100	4	1	247	15349747	15350000	Alectoris rufa genome assembly, chromosome: 10	blastn	255	279	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Alectoris	Alectoris rufa
11614103	11614103	PRJEB75227_P_NODE_10470_length_246_cov_0.901734_g10299_i0	PRJEB75227	10470	246	0.901734	2.21826564	Meleagris gallopavo	9103	Chordata	Chordata	344	3.27e-90	NTclustered	gi\|2721460824\|emb\|HG999682.4\|	9103	g10299	i0	92.213	7.97560975609756	244	18	100	1	1	243	43518001	43518244	Meleagris gallopavo genome assembly, chromosome: 3	blastn	1962	344	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
11614164	11614164	PRJEB75227_P_NODE_7590_length_262_cov_1.375661_g7419_i0	PRJEB75227	7590	262	1.375661	3.60423182	Sus scrofa	9823	Chordata	Chordata	117	8.360000000000001e-22	NTclustered	gi\|1191802949\|ref\|XR_002341317.1\|	9823	g7419	i0	98.485	0.251908396946565	66	1	25	0	5	70	2008	1943	PREDICTED: Sus scrofa translation initiation factor IF-2-like (LOC102160746), transcript variant X5, misc_RNA	blastn	66	117	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
13749095	13749095	PRJEB75227_P_NODE_8211_length_253_cov_0.866667_g8040_i0	PRJEB75227	8211	253	0.866667	2.19266751	Felidae	9681	Chordata	Chordata	167	7.86e-37	NTclustered	gi\|2450872132\|ref\|XR_008418891.1\|	9691	g8040	i0	88.028	74.0197628458498	142	15	55	1	112	251	7361	7220	PREDICTED: Panthera pardus uncharacterized LOC128774307 (LOC128774307), transcript variant X6, ncRNA	blastn	18727	167	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Panthera	Panthera pardus
14164057	14164057	PRJEB75227_P_NODE_9612_length_248_cov_1.782857_g9441_i0	PRJEB75227	9612	248	1.782857	4.42148536	Meleagris gallopavo	9103	Chordata	Chordata	254	5.73e-63	NTclustered	gi\|2721460876\|emb\|HG999684.4\|	9103	g9441	i0	87.615	77.0725806451613	218	27	88	0	1	218	65042000	65041783	Meleagris gallopavo genome assembly, chromosome: 4	blastn	19114	254	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
16712303	16712303	PRJEB75227_P_NODE_10814_length_245_cov_0.906977_g10643_i0	PRJEB75227	10814	245	0.906977	2.22209365	Meleagris gallopavo	9103	Chordata	Chordata	322	1.53e-83	NTclustered	gi\|2721460880\|emb\|HG999685.4\|	9103	g10643	i0	90.283	2.01224489795918	247	22	100	2	1	245	54634453	54634699	Meleagris gallopavo genome assembly, chromosome: 5	blastn	493	322	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
17573559	17573559	PRJEB75227_P_NODE_7454_length_264_cov_1.633508_g7283_i0	PRJEB75227	7454	264	1.633508	4.31246112	Mammalia	40674	Chordata	Chordata	121	6.519999999999999e-23	NTclustered	gi\|2451157076\|ref\|XR_006654403.2\|	9430	g7283	i0	77.169	47.1704545454545	219	43	82	7	10	226	925	1138	PREDICTED: Desmodus rotundus uncharacterized lncRNA (LOC123478968), transcript variant X1, ncRNA	blastn	12453	121	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Phyllostomidae	Desmodus	Desmodus rotundus
17987247	17987247	PRJEB75227_P_NODE_9415_length_249_cov_0.886364_g9244_i0	PRJEB75227	9415	249	0.886364	2.20704636	Acomys russatus	60746	Chordata	Chordata	52.8	0.023	NTclustered	gi\|2318330557\|ref\|XM_051163283.1\|	60746	g9244	i0	96.875	0.1285140562249	32	0	13	1	97	128	1455	1485	PREDICTED: Acomys russatus zinc finger matrin-type 2 (Zmat2), mRNA	blastn	32	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Acomys	Acomys russatus
19261211	19261211	PRJEB75227_P_NODE_3136_length_414_cov_0.868035_g2965_i0	PRJEB75227	3136	414	0.868035	3.5936649	Xenopus laevis	8355	Chordata	Chordata	276	2.17e-69	NTclustered	gi\|157423658\|gb\|BC153797.1\|	8355	g2965	i0	78.744	1	414	86	99	2	1	413	886	474	Xenopus laevis hypothetical protein LOC100126647, mRNA (cDNA clone MGC:181736 IMAGE:8824068), complete cds	blastn	414	276	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
20536572	20536572	PRJEB75227_P_NODE_7337_length_266_cov_1.616580_g7166_i0	PRJEB75227	7337	266	1.61658	4.3001028	Meleagris gallopavo	9103	Chordata	Chordata	455	1.5900000000000002e-123	NTclustered	gi\|2721460880\|emb\|HG999685.4\|	9103	g7166	i0	99.598	3.76315789473684	249	1	94	0	18	266	36046353	36046105	Meleagris gallopavo genome assembly, chromosome: 5	blastn	1001	455	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
20536595	20536595	PRJEB75227_P_NODE_9957_length_247_cov_1.793103_g9786_i0	PRJEB75227	9957	247	1.793103	4.42896441	Bos taurus	9913	Chordata	Chordata	364	2.519999999999999e-96	NTclustered	gi\|226437720\|gb\|AC150858.6\|	9913	g9786	i0	93.469	375.854251012146	245	16	99	0	3	247	88196	88440	Bos taurus BAC CH240-431L22 (Children's Hospital Oakland Research Institute Bovine BAC Library complete sequence	blastn	92836	364	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
21812477	21812477	PRJEB75227_P_NODE_9918_length_248_cov_0.891429_g9747_i0	PRJEB75227	9918	248	0.891429	2.21074392	Meleagris gallopavo	9103	Chordata	Chordata	383	7.0000000000000005e-102	NTclustered	gi\|2721460871\|emb\|HG999689.4\|	9103	g9747	i0	94.758	58.2661290322581	248	10	100	2	1	248	5377546	5377302	Meleagris gallopavo genome assembly, chromosome: 10	blastn	14450	383	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
23948137	23948137	PRJEB75227_P_NODE_11739_length_242_cov_0.923077_g11568_i0	PRJEB75227	11739	242	0.923077	2.23384634	root	1	Root_unresolved	Root_unresolved	381	2.449999999999999e-101	NTclustered	gi\|393793924\|emb\|FO082638.4\|	9823	g11568	i0	95.041	32.7851239669422	242	12	100	0	1	242	3191	3432	Pig DNA sequence from clone WTSI_1061-68I20 on chromosome Y, complete sequence	blastn	7934	381	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
24361426	24361426	PRJEB75227_P_NODE_11080_length_244_cov_0.912281_g10909_i0	PRJEB75227	11080	244	0.912281	2.22596564	Sus scrofa	9823	Chordata	Chordata	446	8.639999999999999e-121	NTclustered	gi\|290964995\|emb\|FP085596.4\|	9823	g10909	i0	99.59	1.59016393442623	244	1	100	0	1	244	114317	114560	Pig DNA sequence from clone CH242-208M4 on chromosome X, complete sequence	blastn	388	446	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa

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