metadata: contig_metadata: 29 rows where bioproject = "PRJNA371613" and tax

29 rows where bioproject = "PRJNA371613" 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
399600	399600	PRJNA371613_P_NODE_8521_length_165_cov_1.000000_g8345_i0	PRJNA371613	8521	165	1	1.65	Gallus gallus	9031	Chordata	Chordata	219	1.29e-52	NTclustered	gi\|15341323\|gb\|AF401307.1\|AF401307	9031	g8345	i0	90.909	25.4727272727273	165	12	100	3	1	165	380	219	Gallus gallus clone pG728_T7-end CNM repeat sequence	blastn	4203	219	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
1073514	1073514	PRJNA371613_P_NODE_4601_length_228_cov_0.905759_g4425_i0	PRJNA371613	4601	228	0.905759	2.06513052	Bovidae	9895	Chordata	Chordata	383	6.35e-102	NTclustered	gi\|602753633\|gb\|KF787959.1\|	9902	g4425	i0	96.943	103.973684210526	229	6	100	1	1	228	740	968	Bison bonasus clone 1 satellite I sequence	blastn	23706	383	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bison	Bison bonasus
1674261	1674261	PRJNA371613_P_NODE_7822_length_169_cov_0.969697_g7646_i0	PRJNA371613	7822	169	0.969697	1.63878793	Sus scrofa	9823	Chordata	Chordata	313	5.859999999999999e-81	NTclustered	gi\|262072719\|emb\|CU466999.6\|	9823	g7646	i0	100	1	169	0	100	0	1	169	158541	158373	Pig DNA sequence from clone CH242-94F12 on chromosome X, complete sequence	blastn	169	313	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
1674272	1674272	PRJNA371613_P_NODE_9102_length_162_cov_1.952000_g8926_i0	PRJNA371613	9102	162	1.952	3.16224	Sus scrofa	9823	Chordata	Chordata	300	4.36e-77	NTclustered	gi\|1191866728\|ref\|XR_002342478.1\|	9823	g8926	i0	100	3	162	0	100	0	1	162	186	25	PREDICTED: Sus scrofa uncharacterized LOC110259959 (LOC110259959), ncRNA	blastn	486	300	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
2348839	2348839	PRJNA371613_P_NODE_8462_length_165_cov_2.000000_g8286_i0	PRJNA371613	8462	165	2	3.3	Bovidae	9895	Chordata	Chordata	150	4.76e-32	NTclustered	gi\|2587640796\|ref\|XM_059875919.1\|	9913	g8286	i0	83.537	105.636363636364	164	24	99	2	2	164	262	423	PREDICTED: Bos taurus ADP ribosylation factor interacting protein 1 (ARFIP1), transcript variant X4, mRNA	blastn	17430	150	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
4226736	4226736	PRJNA371613_P_NODE_9204_length_162_cov_1.024000_g9028_i0	PRJNA371613	9204	162	1.024	1.65888	Ovis aries	9940	Chordata	Chordata	237	3.47e-58	NTclustered	gi\|2607038454\|ref\|XM_004017286.6\|	9940	g9028	i0	93.711	0.981481481481482	159	9	98	1	1	158	3119	2961	PREDICTED: Ovis aries zinc finger CCHC-type and RNA-binding motif-containing protein 1 (LOC101108423), mRNA	blastn	159	237	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
6176501	6176501	PRJNA371613_P_NODE_8985_length_163_cov_1.015873_g8809_i0	PRJNA371613	8985	163	1.015873	1.65587299	Passeriformes	9126	Chordata	Chordata	54.7	0.004	NTclustered	gi\|2797736290\|ref\|XM_068183680.1\|	187417	g8809	i0	96.97	0.607361963190184	33	0	20	1	8	40	2997	2966	PREDICTED: Anomalospiza imberbis bone morphogenetic protein 5 (BMP5), mRNA	blastn	99	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Passeridae	Anomalospiza	Anomalospiza imberbis
6777221	6777221	PRJNA371613_P_NODE_7146_length_172_cov_0.948148_g6970_i0	PRJNA371613	7146	172	0.948148	1.63081456	Ovis aries	9940	Chordata	Chordata	243	7.979999999999999e-60	NTclustered	gi\|2606992803\|ref\|XM_060394795.1\|	9940	g6970	i0	94.34	46.6976744186046	159	8	92	1	1	159	5189	5032	PREDICTED: Ovis aries ring finger and FYVE like domain containing E3 ubiquitin protein ligase (RFFL), transcript variant X2, mRNA	blastn	8032	243	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
8052788	8052788	PRJNA371613_P_NODE_3987_length_254_cov_1.202765_g3811_i0	PRJNA371613	3987	254	1.202765	3.0550231	Muntiacus reevesi	9886	Chordata	Chordata	379	9.31e-101	NTclustered	gi\|2746008129\|ref\|XR_010658990.1\|	9886	g3811	i0	93.725	1233.51968503937	255	13	100	3	1	254	245	497	PREDICTED: Muntiacus reevesi uncharacterized lncRNA (LOC136146451), ncRNA	blastn	313314	379	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Muntiacus	Muntiacus reevesi
9327686	9327686	PRJNA371613_P_NODE_7568_length_170_cov_0.962406_g7392_i0	PRJNA371613	7568	170	0.962406	1.6360902	Canis lupus	9612	Chordata	Chordata	285	1.29e-72	NTclustered	gi\|121584093\|gb\|AC190392.7\|	9615	g7392	i0	96.552	2.02352941176471	174	2	100	3	1	170	59663	59490	Canis Familiaris chromosome 29, clone XX-183G5, complete sequence	blastn	344	285	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
9327687	9327687	PRJNA371613_P_NODE_7588_length_170_cov_0.962406_g7412_i0	PRJNA371613	7588	170	0.962406	1.6360902	Sus scrofa	9823	Chordata	Chordata	78.7	2.35e-10	NTclustered	gi\|109240787\|emb\|CT737389.4\|	9823	g7412	i0	94.118	1.90588235294118	51	3	30	0	119	169	151400	151350	Pig DNA sequence from clone CH242-40A13 on chromosome 7, complete sequence	blastn	324	78.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
9327700	9327700	PRJNA371613_P_NODE_8868_length_164_cov_1.007874_g8692_i0	PRJNA371613	8868	164	1.007874	1.65291336	Vulpes lagopus	494514	Chordata	Chordata	167	4.689999999999999e-37	NTclustered	gi\|2044207943\|ref\|XM_041768088.1\|	494514	g8692	i0	93.043	86.2256097560976	115	6	70	2	2	115	4255	4142	PREDICTED: Vulpes lagopus zinc finger and SCAN domain containing 20 (ZSCAN20), transcript variant X1, mRNA	blastn	14141	167	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Vulpes	Vulpes lagopus
10001642	10001642	PRJNA371613_P_NODE_6208_length_186_cov_1.107383_g6032_i0	PRJNA371613	6208	186	1.107383	2.05973238	Artiodactyla	91561	Chordata	Chordata	263	6.75e-66	NTclustered	gi\|2878528240\|ref\|XR_011566667.1\|	9915	g6032	i0	93.258	587.516129032258	178	12	96	0	9	186	18839	18662	PREDICTED: Bos indicus uncharacterized lncRNA (LOC139183162), ncRNA	blastn	109278	263	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos indicus
10001652	10001652	PRJNA371613_P_NODE_8748_length_164_cov_1.007874_g8572_i0	PRJNA371613	8748	164	1.007874	1.65291336	Suidae	9821	Chordata	Chordata	124	2.86e-24	NTclustered	gi\|1191878419\|ref\|XM_021091406.1\|	9823	g8572	i0	100	35.1524390243902	67	0	41	0	1	67	1004	938	PREDICTED: Sus scrofa metallophosphoesterase domain containing 1 (MPPED1), transcript variant X1, mRNA	blastn	5765	124	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
11276727	11276727	PRJNA371613_P_NODE_5649_length_196_cov_1.635220_g5473_i0	PRJNA371613	5649	196	1.63522	3.2050312	root	1	Root_unresolved	Root_unresolved	340	3.229999999999999e-89	NTclustered	gi\|50872232\|gb\|AC149779.3\|	9913	g5473	i0	97.959	837.790816326531	196	4	100	0	1	196	30243	30438	Bos taurus BAC CH240-5F6 (Children's Hospital Oakland Research Institute Bovine BAC Library (male)) complete sequence	blastn	164207	340	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
11878283	11878283	PRJNA371613_P_NODE_8630_length_165_cov_1.000000_g8454_i0	PRJNA371613	8630	165	1	1.65	Bos mutus	72004	Chordata	Chordata	159	7.9e-35	NTclustered	gi\|2868778568\|ref\|XM_070376450.1\|	72004	g8454	i0	95.05	2.33939393939394	101	5	61	0	12	112	81	181	PREDICTED: Bos mutus small leucine rich protein 1 (SMLR1), mRNA	blastn	386	159	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos mutus
15702258	15702258	PRJNA371613_P_NODE_2873_length_326_cov_1.117647_g2697_i0	PRJNA371613	2873	326	1.117647	3.64352922	Bos javanicus	9906	Chordata	Chordata	562	1.14e-155	NTclustered	gi\|2633679211\|ref\|XR_009735241.1\|	9906	g2697	i0	97.853	125.113496932515	326	6	100	1	1	326	1880	2204	PREDICTED: Bos javanicus uncharacterized LOC133243985 (LOC133243985), ncRNA	blastn	40787	562	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
15702284	15702284	PRJNA371613_P_NODE_7913_length_168_cov_0.977099_g7737_i0	PRJNA371613	7913	168	0.977099	1.64152632	Bos taurus	9913	Chordata	Chordata	311	2.11e-80	NTclustered	gi\|2587669800\|ref\|XR_009492982.1\|	9913	g7737	i0	100	2	168	0	100	0	1	168	4342	4509	PREDICTED: Bos taurus uncharacterized lncRNA (LOC132343947), ncRNA	blastn	336	311	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
16375992	16375992	PRJNA371613_P_NODE_7933_length_168_cov_0.977099_g7757_i0	PRJNA371613	7933	168	0.977099	1.64152632	Bovidae	9895	Chordata	Chordata	272	9.95e-69	NTclustered	gi\|2587669645\|ref\|XR_009492966.1\|	9913	g7757	i0	95.833	318.732142857143	168	7	100	0	1	168	31280	31113	PREDICTED: Bos taurus uncharacterized lncRNA (LOC132343941), ncRNA	blastn	53547	274	0.992700729927007	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
16976945	16976945	PRJNA371613_P_NODE_8774_length_164_cov_1.007874_g8598_i0	PRJNA371613	8774	164	1.007874	1.65291336	Sus scrofa	9823	Chordata	Chordata	102	1.34e-17	NTclustered	gi\|322487378\|emb\|FN673745.1\|	9823	g8598	i0	98.276	38.8048780487805	58	1	35	0	1	58	72426	72369	Sus scrofa BAC clone KNP_466E2	blastn	6364	102	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
18251189	18251189	PRJNA371613_P_NODE_7815_length_169_cov_0.969697_g7639_i0	PRJNA371613	7815	169	0.969697	1.63878793	Sus scrofa	9823	Chordata	Chordata	73.1	1.08e-8	NTclustered	gi\|1191908198\|ref\|XM_021062495.1\|	9823	g7639	i0	79.13	2.69230769230769	115	16	67	5	48	161	1136	1029	PREDICTED: Sus scrofa X-ray radiation resistance associated 1 (XRRA1), transcript variant X5, mRNA	blastn	455	73.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
19525419	19525419	PRJNA371613_P_NODE_9196_length_162_cov_1.024000_g9020_i0	PRJNA371613	9196	162	1.024	1.65888	Canis lupus	9612	Chordata	Chordata	252	1.24e-62	NTclustered	gi\|61675818\|gb\|AC093453.40\|	9615	g9020	i0	94.512	220.728395061728	164	7	100	1	1	162	107021	106858	Canis lupus familiaris strain Doberman Pinscher clone rp81-252i15, complete sequence	blastn	35758	252	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
20199593	20199593	PRJNA371613_P_NODE_9476_length_153_cov_2.155172_g9300_i0	PRJNA371613	9476	153	2.155172	3.29741316	Bos	9903	Chordata	Chordata	163	5.5500000000000004e-36	NTclustered	gi\|2633680777\|ref\|XM_061434904.1\|	9906	g9300	i0	92.857	2.9281045751634	112	8	73	0	38	149	1011	900	PREDICTED: Bos javanicus ADP ribosylation factor like GTPase 13B (ARL13B), transcript variant X3, mRNA	blastn	448	163	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
20801044	20801044	PRJNA371613_P_NODE_7597_length_170_cov_0.962406_g7421_i0	PRJNA371613	7597	170	0.962406	1.6360902	Sus scrofa	9823	Chordata	Chordata	52.8	0.014	NTclustered	gi\|1191890046\|ref\|XM_005665255.2\|	9823	g7421	i0	100	1.97647058823529	28	0	16	0	143	170	1974	1947	PREDICTED: Sus scrofa peptidylprolyl isomerase E (PPIE), transcript variant X3, mRNA	blastn	336	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
21475178	21475178	PRJNA371613_P_NODE_4177_length_245_cov_1.538462_g4001_i0	PRJNA371613	4177	245	1.538462	3.7692319	Oikopleura	34763	Chordata	Chordata	52.8	0.022	NTclustered	gi\|2279963496\|gb\|OP113807.1\|	34765	g4001	i0	100	2.28571428571429	28	0	11	0	146	173	4345	4372	Oikopleura dioica isolate AOM-5 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence	blastn	560	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
23351541	23351541	PRJNA371613_P_NODE_7019_length_173_cov_0.941176_g6843_i0	PRJNA371613	7019	173	0.941176	1.62823448	Acinonyx jubatus	32536	Chordata	Chordata	104	3.96e-18	NTclustered	gi\|2437678575\|ref\|XR_008295960.1\|	32536	g6843	i0	89.412	38.1098265895954	85	5	47	3	92	172	3887	3971	PREDICTED: Acinonyx jubatus uncharacterized LOC128314378 (LOC128314378), ncRNA	blastn	6593	104	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Acinonyx	Acinonyx jubatus
27707115	27707115	PRJNA371613_P_NODE_9124_length_162_cov_1.464000_g8948_i0	PRJNA371613	9124	162	1.464	2.37168	Orcinus orca	9733	Chordata	Chordata	42.7	0.0124	NR	XP_004267183.2	9733	g8948	i0	59	0.722222222222222	39	11	63	1	23	124	34	72	XP_004267183.2 forkhead box protein N1 isoform X2 [Orcinus orca]	diamond	117	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Orcinus	Orcinus orca
30264768	30264768	PRJNA371613_P_NODE_5292_length_206_cov_1.461538_g5116_i0	PRJNA371613	5292	206	1.461538	3.01076828	Hypanus sabinus	79690	Chordata	Chordata	61.2	6.84e-9	NR	XP_059823631.1	79690	g5116	i0	46	0.728155339805825	50	27	72.8	0	169	20	558	607	XP_059823631.1 IQ calmodulin-binding motif-containing protein 1 isoform X1 [Hypanus sabinus]	diamond	150	61.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
32034778	32034778	PRJNA371613_P_NODE_8798_length_164_cov_1.007874_g8622_i0	PRJNA371613	8798	164	1.007874	1.65291336	Rousettus aegyptiacus	9407	Chordata	Chordata	43.5	0.00268	NR	KAF6427968.1	9407	g8622	i0	56.4	2.85365853658537	39	12	69.5	2	47	160	75	109	KAF6427968.1 hypothetical protein HJG63_008428 [Rousettus aegyptiacus]	diamond	468	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Pteropodidae	Rousettus	Rousettus aegyptiacus

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