metadata: contig_metadata: 17 rows where bioproject = "PRJNA342843" and tax

17 rows where bioproject = "PRJNA342843" and tax_kingdom = "Metazoa"

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
392791	392791	PRJNA342843_S_NODE_10861_length_186_cov_4.524138_g10711_i0	PRJNA342843	10861	186	4.524138	8.41489668	Sus scrofa	9823	Chordata	Chordata	311	2.38e-80	NTclustered	gi\|509046\|emb\|X70941.1\|	9823	g10711	i0	96.774	32.6774193548387	186	6	100	0	1	186	66	251	S.scrofa DNA for centromere specific motif	blastn	6078	311	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
1667405	1667405	PRJNA342843_S_NODE_12082_length_175_cov_0.940299_g11932_i0	PRJNA342843	12082	175	0.940299	1.64552325	Sus scrofa	9823	Chordata	Chordata	283	4.8e-72	NTclustered	gi\|256855753\|emb\|CU915403.6\|	9823	g11932	i0	96.491	130.474285714286	171	6	98	0	5	175	35329	35159	Pig DNA sequence from clone CH242-289L5 on chromosome X, complete sequence	blastn	22833	283	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
4220142	4220142	PRJNA342843_S_NODE_14584_length_157_cov_1.017241_g14434_i0	PRJNA342843	14584	157	1.017241	1.59706837	Sus scrofa	9823	Chordata	Chordata	228	2.0099999999999995e-55	NTclustered	gi\|2057\|emb\|X51563.1\|	9823	g14434	i0	93.506	0.980891719745223	154	9	98	1	4	157	26	178	S. scrofa Ac2 satellite DNA (clone pMb2.3)	blastn	154	228	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
4220161	4220161	PRJNA342843_S_NODE_15244_length_153_cov_0.901786_g15094_i0	PRJNA342843	15244	153	0.901786	1.37973258	Sus scrofa	9823	Chordata	Chordata	69.4	1.24e-7	NTclustered	gi\|2103\|emb\|X16513.1\|	9823	g15094	i0	97.5	2.55555555555556	40	1	75	0	114	153	1049	1010	Pig gender-neutral repetitive DNA	blastn	391	69.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
6173182	6173182	PRJNA342843_S_NODE_13645_length_163_cov_0.934426_g13495_i0	PRJNA342843	13645	163	0.934426	1.52311438	Sus	9822	Chordata	Chordata	302	1.22e-77	NTclustered	gi\|465481179\|gb\|KC505407.1\|	9823	g13495	i0	100	100	163	0	100	0	1	163	14136	14298	Sus scrofa breed Penzhou pig mitochondrion, complete genome	blastn	16300	302	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
8046051	8046051	PRJNA342843_S_NODE_11427_length_181_cov_1.264286_g11277_i0	PRJNA342843	11427	181	1.264286	2.28835766	Sus scrofa	9823	Chordata	Chordata	257	3.04e-64	NTclustered	gi\|371918167\|dbj\|AK395835.1\|	9823	g11277	i0	94.706	124.022099447514	170	2	94	4	12	181	704	866	Sus scrofa mRNA, clone: OVRT10070H01, expressed in ovary	blastn	22448	257	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
8046139	8046139	PRJNA342843_S_NODE_14327_length_158_cov_1.504274_g14177_i0	PRJNA342843	14327	158	1.5042739999999999	2.37675292	Notodromas monacha	399045	Arthropoda	Arthropoda	281	1.53e-71	NTclustered	gi\|1938055242\|emb\|OA888849.1\|	399045	g14177	i0	98.734	40.1645569620253	158	2	100	0	1	158	566	409	Notodromas monacha	blastn	6346	281	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cyprididae	Notodromas	Notodromas monacha
11273558	11273558	PRJNA342843_S_NODE_9369_length_205_cov_0.835366_g9219_i0	PRJNA342843	9369	205	0.835366	1.7125003	Bovidae	9895	Chordata	Chordata	348	2.0400000000000002e-91	NTclustered	gi\|2587621616\|ref\|XM_059890066.1\|	9913	g9219	i0	98	905.473170731707	200	4	98	0	1	200	2977	3176	PREDICTED: Bos taurus interphotoreceptor matrix proteoglycan 2 (IMPG2), transcript variant X7, mRNA	blastn	185622	348	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
11871538	11871538	PRJNA342843_S_NODE_15510_length_151_cov_1.509091_g15360_i0	PRJNA342843	15510	151	1.509091	2.27872741	Bos taurus	9913	Chordata	Chordata	270	3.1299999999999996e-68	NTclustered	gi\|270310993\|gb\|GU211007.1\|	9913	g15360	i0	99.329	1752.70198675497	149	1	99	0	3	151	73980	73832	Bos taurus breed Polish Red myocyte enhancer factor 2C (MEF2C) gene, promoter region and complete cds	blastn	264658	270	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
11871842	11871842	PRJNA342843_S_NODE_9150_length_208_cov_1.473054_g9000_i0	PRJNA342843	9150	208	1.473054	3.06395232	Sus scrofa	9823	Chordata	Chordata	220	4.72e-53	NTclustered	gi\|2103\|emb\|X16513.1\|	9823	g9000	i0	91.304	16.0240384615385	161	14	100	0	1	161	161	1	Pig gender-neutral repetitive DNA	blastn	3333	220	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
14421476	14421476	PRJNA342843_S_NODE_10432_length_192_cov_1.211921_g10282_i0	PRJNA342843	10432	192	1.211921	2.32688832	Satyrium ilicis	876074	Arthropoda	Arthropoda	52.8	0.017	NTclustered	gi\|2918386088\|emb\|OZ238121.1\|	876074	g10282	i0	100	0.145833333333333	28	0	15	0	73	100	23317818	23317845	Satyrium ilicis genome assembly, chromosome: 12	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Satyrium	Satyrium ilicis
14421499	14421499	PRJNA342843_S_NODE_11212_length_183_cov_1.345070_g11062_i0	PRJNA342843	11212	183	1.34507	2.4614781	Sus scrofa	9823	Chordata	Chordata	283	5.08e-72	NTclustered	gi\|238654711\|emb\|CU929667.3\|	9823	g11062	i0	99.359	213.72131147541	156	1	85	0	28	183	38216	38371	Pig DNA sequence from clone CH242-54L3 on chromosome X, complete sequence	blastn	39111	283	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
14421812	14421812	PRJNA342843_S_NODE_5872_length_275_cov_1.089744_g5722_i0	PRJNA342843	5872	275	1.089744	2.996796	Notodromas monacha	399045	Arthropoda	Arthropoda	492	1.26e-134	NTclustered	gi\|1938055242\|emb\|OA888849.1\|	399045	g5722	i0	98.909	27.9090909090909	275	3	100	0	1	275	1804	2078	Notodromas monacha	blastn	7675	492	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cyprididae	Notodromas	Notodromas monacha
15695391	15695391	PRJNA342843_S_NODE_11413_length_181_cov_1.442857_g11263_i0	PRJNA342843	11413	181	1.442857	2.61157117	Columba livia	8932	Chordata	Chordata	52.8	0.015	NTclustered	gi\|2728280758\|ref\|XR_010469264.1\|	8932	g11263	i0	100	0.154696132596685	28	0	15	0	129	156	726	699	PREDICTED: Columba livia uncharacterized LOC135577459 (LOC135577459), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Columbiformes	Columbidae	Columba	Columba livia
18244617	18244617	PRJNA342843_S_NODE_4855_length_310_cov_3.520446_g4705_i0	PRJNA342843	4855	310	3.520446	10.9133826	Sus scrofa	9823	Chordata	Chordata	433	8.85e-117	NTclustered	gi\|2103\|emb\|X16513.1\|	9823	g4705	i0	91.935	46.7161290322581	310	24	100	1	1	310	558	250	Pig gender-neutral repetitive DNA	blastn	14482	433	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
19518991	19518991	PRJNA342843_S_NODE_9036_length_210_cov_1.248521_g8886_i0	PRJNA342843	9036	210	1.248521	2.6218941	Sus scrofa	9823	Chordata	Chordata	339	1.26e-88	NTclustered	gi\|327530738\|emb\|FQ014219.5\|	9823	g8886	i0	95.735	204.242857142857	211	7	100	2	1	210	45006	45215	Pig DNA sequence from clone CH242-352J3 on chromosome X, complete sequence	blastn	42891	339	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
20196437	20196437	PRJNA342843_S_NODE_8936_length_211_cov_2.441176_g8786_i0	PRJNA342843	8936	211	2.441176	5.15088136	root	1	Root_unresolved	Root_unresolved	385	1.61e-102	NTclustered	gi\|163681\|gb\|J00036.1\|BOVRS715B	9913	g8786	i0	99.526	100.165876777251	211	1	100	0	1	211	666	876	Bovine thymus satellite I (1.715 gm/ml) DNA, b	blastn	21135	385	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);;