metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1148965" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1148965" 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
1036582	1036582	PRJNA1148965_S_NODE_321_length_329_cov_4.253906_g318_i0	PRJNA1148965	321	329	4.253906	13.99535074	Bos	9903	Chordata	Chordata	549	9.009999999999996e-152	NTclustered	gi\|2633679555\|ref\|XR_009735293.1\|	9906	g318	i0	98.403	79.2218844984803	313	4	95	1	1	312	881	1193	PREDICTED: Bos javanicus uncharacterized LOC133244066 (LOC133244066), ncRNA	blastn	26064	549	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
1036584	1036584	PRJNA1148965_S_NODE_821_length_244_cov_1.000000_g818_i0	PRJNA1148965	821	244	1	2.44	Bos	9903	Chordata	Chordata	385	1.91e-102	NTclustered	gi\|2633855138\|ref\|XR_009736011.1\|	9906	g818	i0	98.182	541.459016393443	220	4	90	0	22	241	1685	1904	PREDICTED: Bos javanicus uncharacterized LOC133246330 (LOC133246330), ncRNA	blastn	132116	388	0.992268041237113	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
1575441	1575441	PRJNA1148965_S_NODE_502_length_283_cov_1.114286_g499_i0	PRJNA1148965	502	283	1.114286	3.15342938	Bos taurus	9913	Chordata	Chordata	518	2.14e-142	NTclustered	gi\|226424000\|gb\|AC150492.4\|	9913	g499	i0	99.648	1.00353356890459	284	0	100	1	1	283	127725	128008	Bos taurus BAC CH240-454H24 (Children's Hospital Oakland Research Institute Bovine BAC Library complete sequence	blastn	284	518	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
5403901	5403901	PRJNA1148965_S_NODE_225_length_364_cov_2.233677_g222_i0	PRJNA1148965	225	364	2.233677	8.13058428	Mus musculus	10090	Chordata	Chordata	641	1.6099999999999993e-179	NTclustered	gi\|47124098\|gb\|BC069931.1\|	10090	g222	i0	99.433	90.5576923076923	353	2	97	0	12	364	799	447	Mus musculus cDNA clone MGC:78219 IMAGE:3489785, complete cds	blastn	32963	641	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
7414404	7414404	PRJNA1148965_S_NODE_806_length_245_cov_0.906977_g803_i0	PRJNA1148965	806	245	0.906977	2.22209365	Mus	10088	Chordata	Chordata	453	5.1900000000000006e-123	NTclustered	gi\|846387786\|dbj\|LC061991.1\|	10090	g803	i0	100	100	245	0	100	0	1	245	788	1032	Mus musculus mitochondrion DNA, including ATP6, COX3, tRNA-Gly, ND3, tRNA-Arg, ND4L, ND4 genes, complete sequence, sequence_id: (8070..10988)_18	blastn	24500	453	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10504627	10504627	PRJNA1148965_S_NODE_769_length_247_cov_2.097701_g766_i0	PRJNA1148965	769	247	2.097701	5.18132147	Heterocephalus glaber	10181	Chordata	Chordata	52.8	0.022	NTclustered	gi\|1196716665\|ref\|XR_002394006.1\|	10181	g766	i0	96.774	0.125506072874494	31	1	13	0	217	247	7	37	PREDICTED: Heterocephalus glaber uncharacterized LOC110348636 (LOC110348636), transcript variant X14, ncRNA	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Bathyergidae	Heterocephalus	Heterocephalus glaber
11779447	11779447	PRJNA1148965_S_NODE_130_length_427_cov_1.926554_g127_i0	PRJNA1148965	130	427	1.926554	8.22638558	Bos taurus	9913	Chordata	Chordata	754	0	NTclustered	gi\|2587618257\|ref\|XR_009493754.1\|	9913	g127	i0	98.818	60.7142857142857	423	5	99	0	5	427	4549	4971	PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344790), transcript variant X2, ncRNA	blastn	25925	754	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
12515266	12515266	PRJNA1148965_S_NODE_170_length_394_cov_1.884735_g167_i0	PRJNA1148965	170	394	1.884735	7.4258559	root	1	Root_unresolved	Root_unresolved	69.4	3.74e-7	NTclustered	gi\|1196716699\|ref\|XR_002394040.1\|	10181	g167	i0	97.561	9.57868020304569	41	0	10	1	352	392	11	50	PREDICTED: Heterocephalus glaber uncharacterized LOC110348636 (LOC110348636), transcript variant X48, ncRNA	blastn	3774	69.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Bathyergidae	Heterocephalus	Heterocephalus glaber
18152558	18152558	PRJNA1148965_S_NODE_435_length_298_cov_1.128889_g432_i0	PRJNA1148965	435	298	1.128889	3.36408922	Bos taurus	9913	Chordata	Chordata	507	4.92e-139	NTclustered	gi\|2587618257\|ref\|XR_009493754.1\|	9913	g432	i0	100	15.7785234899329	274	0	92	0	1	274	4360	4087	PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344790), transcript variant X2, ncRNA	blastn	4702	507	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
18152559	18152559	PRJNA1148965_S_NODE_635_length_262_cov_1.005291_g632_i0	PRJNA1148965	635	262	1.005291	2.63386242	Mus musculus	10090	Chordata	Chordata	484	1.99e-132	NTclustered	gi\|145966796\|ref\|NM_008221.4\|	10090	g632	i0	100	64.1984732824427	262	0	100	0	1	262	604	343	Mus musculus hemoglobin Y, beta-like embryonic chain (Hbb-y), mRNA	blastn	16820	484	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20702249	20702249	PRJNA1148965_S_NODE_257_length_353_cov_1.296429_g254_i0	PRJNA1148965	257	353	1.296429	4.57639437	Mus musculus	10090	Chordata	Chordata	625	1.5699999999999996e-174	NTclustered	gi\|12846704\|dbj\|AK010927.1\|	10090	g254	i0	98.584	99.614730878187	353	5	100	0	1	353	200	552	Mus musculus 13 days embryo liver cDNA, RIKEN full-length enriched library, clone:2510008C04 product:hemoglobin, beta adult major chain, full insert sequence	blastn	35164	625	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
21438429	21438429	PRJNA1148965_S_NODE_317_length_333_cov_1.284615_g314_i0	PRJNA1148965	317	333	1.284615	4.27776795	Mus	10088	Chordata	Chordata	610	4.13e-170	NTclustered	gi\|846387786\|dbj\|LC061991.1\|	10090	g314	i0	99.7	100	333	1	100	0	1	333	976	1308	Mus musculus mitochondrion DNA, including ATP6, COX3, tRNA-Gly, ND3, tRNA-Arg, ND4L, ND4 genes, complete sequence, sequence_id: (8070..10988)_18	blastn	33300	610	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22713471	22713471	PRJNA1148965_S_NODE_278_length_346_cov_0.893773_g275_i0	PRJNA1148965	278	346	0.893773	3.09245458	Bovidae	9895	Chordata	Chordata	573	5.65e-159	NTclustered	gi\|2633868663\|ref\|XR_009736655.1\|	9906	g275	i0	96.532	1603.85549132948	346	12	100	0	1	346	12325	12670	PREDICTED: Bos javanicus uncharacterized LOC133248291 (LOC133248291), ncRNA	blastn	554934	577	0.993067590987868	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
24526785	24526785	PRJNA1148965_S_NODE_440_length_297_cov_1.000000_g437_i0	PRJNA1148965	440	297	1	2.97	Bos taurus	9913	Chordata	Chordata	217	9.25e-52	NTclustered	gi\|320090038\|gb\|HQ144226.1\|	9913	g437	i0	97.638	447.710437710438	127	2	43	1	74	200	545	670	Bos taurus clone NN14 EDA gene, intron 1	blastn	132970	217	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus

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