metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA1068513" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA1068513" 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
181949	181949	PRJNA1068513_S_NODE_4581_length_422_cov_2.194842_g4536_i0	PRJNA1068513	4581	422	2.194842	9.26223324	Trachemys scripta	34903	Chordata	Chordata	52.8	0.041	NTclustered	gi\|1846728636\|ref\|XM_034763038.1\|	31138	g4536	i0	100	0.132701421800948	28	0	7	0	151	178	1881	1908	PREDICTED: Trachemys scripta elegans minichromosome maintenance domain containing 2 (MCMDC2), transcript variant X4, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Emydidae	Trachemys	Trachemys scripta
1456485	1456485	PRJNA1068513_S_NODE_11902_length_254_cov_2.027624_g11856_i0	PRJNA1068513	11902	254	2.027624	5.15016496	Mus musculus	10090	Chordata	Chordata	58.4	4.96e-4	NTclustered	gi\|55416083\|gb\|AC120865.7\|	10090	g11856	i0	97.059	0.822834645669291	34	1	13	0	128	161	185531	185498	Mus musculus chromosome 5, clone RP23-88L6, complete sequence	blastn	209	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
1456518	1456518	PRJNA1068513_S_NODE_1682_length_598_cov_2.811429_g1641_i0	PRJNA1068513	1682	598	2.811429	16.81234542	Hemicordylus capensis	884348	Chordata	Chordata	60.2	3.54e-4	NTclustered	gi\|2432982198\|ref\|XR_008315944.1\|	884348	g1641	i0	94.872	0.0652173913043478	39	1	6	1	474	511	1197	1159	PREDICTED: Hemicordylus capensis uncharacterized LOC128344603 (LOC128344603), transcript variant X1, ncRNA	blastn	39	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Cordylidae	Hemicordylus	Hemicordylus capensis
1456632	1456632	PRJNA1068513_S_NODE_9182_length_298_cov_0.906667_g9136_i0	PRJNA1068513	9182	298	0.906667	2.70186766	Sus scrofa	9823	Chordata	Chordata	58.4	5.95e-4	NTclustered	gi\|315461785\|emb\|FP102403.9\|	9823	g9136	i0	100	0.291946308724832	31	0	10	0	264	294	46268	46298	Pig DNA sequence from clone CH242-141K19 on chromosome X, complete sequence	blastn	87	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
2288890	2288890	PRJNA1068513_S_NODE_7322_length_336_cov_4.045627_g7276_i0	PRJNA1068513	7322	336	4.045627	13.59330672	Metazoa	33208	Chordata	Chordata	52.8	0.032	NTclustered	gi\|71480322\|gb\|AC157360.9\|	10090	g7276	i0	96.774	0.175595238095238	31	1	9	0	215	245	101751	101781	Mus musculus chromosome 8, clone RP23-420E22, complete sequence	blastn	59	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
2732368	2732368	PRJNA1068513_S_NODE_12923_length_246_cov_0.901734_g12877_i0	PRJNA1068513	12923	246	0.901734	2.21826564	Pelobates fuscus	191477	Chordata	Chordata	185	2.1e-42	NTclustered	gi\|2688563234\|ref\|XM_063429425.1\|	191477	g12877	i0	80.408	14.2317073170732	245	46	99	2	1	244	901	658	PREDICTED: Pelobates fuscus kinesin family member 5C (KIF5C), mRNA	blastn	3501	185	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pelobatidae	Pelobates	Pelobates fuscus
4008290	4008290	PRJNA1068513_S_NODE_1164_length_661_cov_51.039116_g1124_i0	PRJNA1068513	1164	661	51.039116	337.36855676	Apteryx mantelli	2696672	Chordata	Chordata	58.4	0.001	NTclustered	gi\|840008768\|emb\|LK064626.1\|	202946	g1124	i0	100	0.0937972768532526	31	0	9	0	422	452	7728750	7728780	Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold2	blastn	62	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apterygiformes	Apterygidae	Apteryx	Apteryx mantelli
5284729	5284729	PRJNA1068513_S_NODE_7445_length_334_cov_0.969349_g7399_i0	PRJNA1068513	7445	334	0.969349	3.23762566	Mus musculus	10090	Chordata	Chordata	54.7	0.009	NTclustered	gi\|62123223\|gb\|AC152939.2\|	10090	g7399	i0	100	0.389221556886228	29	0	9	0	14	42	163607	163579	Mus musculus BAC clone RP23-312I2 from chromosome 7, complete sequence	blastn	130	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6559717	6559717	PRJNA1068513_S_NODE_11986_length_253_cov_1.750000_g11940_i0	PRJNA1068513	11986	253	1.75	4.4275	Petromyzon marinus	7757	Chordata	Chordata	56.5	0.002	NTclustered	gi\|1822404569\|ref\|XM_032966987.1\|	7757	g11940	i0	100	1.35177865612648	30	0	12	0	25	54	1609	1638	PREDICTED: Petromyzon marinus voltage-dependent calcium channel gamma-2 subunit-like (LOC116949560), mRNA	blastn	342	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Petromyzon	Petromyzon marinus
7834334	7834334	PRJNA1068513_S_NODE_10607_length_273_cov_6.610000_g10561_i0	PRJNA1068513	10607	273	6.61	18.0453	Styela clava	7725	Chordata	Chordata	54.7	0.007	NTclustered	gi\|1981761564\|ref\|XM_039391807.1\|	7725	g10561	i0	100	0.106227106227106	29	0	11	0	216	244	682	710	PREDICTED: Styela clava uncharacterized LOC120325700 (LOC120325700), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
9109349	9109349	PRJNA1068513_S_NODE_10008_length_283_cov_0.880952_g9962_i0	PRJNA1068513	10008	283	0.880952	2.49309416	Elgaria multicarinata	71008	Chordata	Chordata	54.7	0.007	NTclustered	gi\|2676903696\|ref\|XM_063136382.1\|	159646	g9962	i0	96.875	0.226148409893993	32	1	11	0	12	43	1927	1958	PREDICTED: Elgaria multicarinata webbii ELMO domain containing 2 (ELMOD2), transcript variant X2, mRNA	blastn	64	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Anguidae	Elgaria	Elgaria multicarinata
9109361	9109361	PRJNA1068513_S_NODE_12088_length_252_cov_2.910615_g12042_i0	PRJNA1068513	12088	252	2.910615	7.3347498	Apus apus	8895	Chordata	Chordata	54.7	0.006	NTclustered	gi\|2323509940\|ref\|XM_051638611.1\|	8895	g12042	i0	100	0.69047619047619	29	0	12	0	1	29	3366	3394	PREDICTED: Apus apus ATPase phospholipid transporting 8A2 (ATP8A2), transcript variant X2, mRNA	blastn	174	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apodiformes	Apodidae	Apus	Apus apus
10385178	10385178	PRJNA1068513_S_NODE_589_length_789_cov_2.074022_g560_i0	PRJNA1068513	589	789	2.074022	16.36403358	Sus scrofa	9823	Chordata	Chordata	54.7	0.022	NTclustered	gi\|239913936\|emb\|FP103090.4\|	9823	g560	i0	100	0.0367553865652725	29	0	4	0	378	406	119424	119452	Pig DNA sequence from clone CH242-266A14 on chromosome 2, complete sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
10385185	10385185	PRJNA1068513_S_NODE_6589_length_356_cov_1.540636_g6543_i0	PRJNA1068513	6589	356	1.540636	5.48466416	Styela clava	7725	Chordata	Chordata	215	4.06e-51	NTclustered	gi\|1981809853\|ref\|XM_039417077.1\|	7725	g6543	i0	79.933	25.3904494382022	299	55	83	5	1	296	515	219	PREDICTED: Styela clava S-adenosylmethionine synthase-like (LOC120347189), transcript variant X1, mRNA	blastn	9039	215	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
11217035	11217035	PRJNA1068513_S_NODE_9709_length_288_cov_1.776744_g9663_i0	PRJNA1068513	9709	288	1.776744	5.11702272	Gekkonidae	8561	Chordata	Chordata	52.8	0.027	NTclustered	gi\|2593507722\|ref\|XM_060242596.1\|	13085	g9663	i0	100	1.45833333333333	28	0	10	0	65	92	1971	1944	PREDICTED: Heteronotia binoei eukaryotic translation initiation factor 4 gamma 1 (EIF4G1), transcript variant X1, mRNA	blastn	420	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Gekkonidae	Heteronotia	Heteronotia binoei
12935646	12935646	PRJNA1068513_S_NODE_51_length_1443_cov_6.972993_g42_i0	PRJNA1068513	51	1443	6.972993	100.62028899	Trichosurus vulpecula	9337	Chordata	Chordata	320	3.68e-82	NTclustered	gi\|1919002861\|ref\|XM_036742054.1\|	9337	g42	i0	79.348	7.38946638946639	460	91	39	3	391	848	714	257	PREDICTED: Trichosurus vulpecula SEC11 homolog C, signal peptidase complex subunit (SEC11C), transcript variant X1, mRNA	blastn	10663	320	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Diprotodontia	Phalangeridae	Trichosurus	Trichosurus vulpecula
15484620	15484620	PRJNA1068513_S_NODE_6813_length_349_cov_7.586957_g6767_i0	PRJNA1068513	6813	349	7.586957	26.47847993	Sorex araneus	42254	Chordata	Chordata	60.2	1.97e-4	NTclustered	gi\|2487325587\|ref\|XM_055138727.1\|	42254	g6767	i0	100	0.0916905444126074	32	0	9	0	243	274	2775	2744	PREDICTED: Sorex araneus RUN and FYVE domain containing 2 (RUFY2), transcript variant X2, mRNA	blastn	32	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Eulipotyphla	Soricidae	Sorex	Sorex araneus
18033602	18033602	PRJNA1068513_S_NODE_4255_length_436_cov_2.344353_g4210_i0	PRJNA1068513	4255	436	2.344353	10.22137908	Branchiostoma belcheri	7741	Chordata	Chordata	187	1.1099999999999999e-42	NTclustered	gi\|1126176388\|ref\|XM_019764898.1\|	7741	g4210	i0	81.197	14.6192660550459	234	42	53	2	76	308	877	1109	PREDICTED: Branchiostoma belcheri electron transfer flavoprotein subunit alpha, mitochondrial-like (LOC109467008), mRNA	blastn	6374	187	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
18033607	18033607	PRJNA1068513_S_NODE_4775_length_414_cov_4.134897_g4730_i0	PRJNA1068513	4775	414	4.134897	17.11847358	Lethenteron reissneri	7753	Chordata	Chordata	60.2	2.38e-4	NTclustered	gi\|2635884359\|ref\|XM_061569463.1\|	7753	g4730	i0	87.037	0.64975845410628	54	5	13	2	232	284	878	930	PREDICTED: Lethenteron reissneri potassium voltage-gated channel subfamily S member 3-like (LOC133353323), transcript variant X1, mRNA	blastn	269	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
19307422	19307422	PRJNA1068513_S_NODE_13916_length_219_cov_6.061644_g13870_i0	PRJNA1068513	13916	219	6.061644	13.27500036	Tupaia chinensis	246437	Chordata	Chordata	52.8	0.019	NTclustered	gi\|1561583174\|ref\|XM_014589170.2\|	246437	g13870	i0	100	0.127853881278539	28	0	13	0	69	96	2559	2532	PREDICTED: Tupaia chinensis family with sequence similarity 83 member H (FAM83H), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Scandentia	Tupaiidae	Tupaia	Tupaia chinensis
19307493	19307493	PRJNA1068513_S_NODE_7016_length_345_cov_1.088235_g6970_i0	PRJNA1068513	7016	345	1.088235	3.75441075	Myotis yumanensis	159337	Chordata	Chordata	56.5	0.003	NTclustered	gi\|2870491406\|ref\|XR_011472374.1\|	159337	g6970	i0	96.97	0.0956521739130435	33	1	10	0	3	35	1836	1868	PREDICTED: Myotis yumanensis uncharacterized lncRNA (LOC139014889), ncRNA	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Vespertilionidae	Myotis	Myotis yumanensis
20140041	20140041	PRJNA1068513_S_NODE_1236_length_651_cov_6.299308_g1196_i0	PRJNA1068513	1236	651	6.299308	41.00849508	Passeridae	9158	Chordata	Chordata	176	3.68e-39	NTclustered	gi\|2032794888\|ref\|XM_041460927.1\|	221976	g1196	i0	78.261	6.4531490015361	276	58	42	2	1	275	1432	1706	PREDICTED: Pyrgilauda ruficollis transmembrane 9 superfamily member 3 (TM9SF3), mRNA	blastn	4201	176	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Passeridae	Pyrgilauda	Pyrgilauda ruficollis
21858701	21858701	PRJNA1068513_S_NODE_4218_length_437_cov_5.480769_g4173_i0	PRJNA1068513	4218	437	5.480769	23.95096053	Rattus norvegicus	10116	Chordata	Chordata	54.7	0.012	NTclustered	gi\|304307791\|gb\|AC241917.4\|	10116	g4173	i0	96.875	0.0732265446224256	32	1	7	0	251	282	79586	79617	Rattus norvegicus Y Chr BAC RNECO-147G24 (Amplicon Express Rat SHR-Akr (EcoR1 Digest) BAC library) complete sequence	blastn	32	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus
23134138	23134138	PRJNA1068513_S_NODE_12319_length_251_cov_0.876404_g12273_i0	PRJNA1068513	12319	251	0.876404	2.19977404	Branchiostoma floridae	7739	Chordata	Chordata	52.8	0.023	NTclustered	gi\|1889994181\|ref\|XM_035834414.1\|	7739	g12273	i0	100	0.111553784860558	28	0	11	0	24	51	2733	2760	PREDICTED: Branchiostoma floridae fibrinogen-like protein 1 (LOC118425520), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma floridae
23134147	23134147	PRJNA1068513_S_NODE_13059_length_244_cov_3.380117_g13013_i0	PRJNA1068513	13059	244	3.380117	8.24748548	Hemiscyllium ocellatum	170820	Chordata	Chordata	54.7	0.006	NTclustered	gi\|2618614457\|ref\|XM_060845793.1\|	170820	g13013	i0	100	2.01229508196721	29	0	12	0	214	242	1677	1649	PREDICTED: Hemiscyllium ocellatum zinc finger protein 502-like (LOC132828710), transcript variant X2, mRNA	blastn	491	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Orectolobiformes	Hemiscylliidae	Hemiscyllium	Hemiscyllium ocellatum
23134169	23134169	PRJNA1068513_S_NODE_2019_length_567_cov_2.287449_g1977_i0	PRJNA1068513	2019	567	2.287449	12.96983583	Pezoporus occidentalis	407982	Chordata	Chordata	54.7	0.016	NTclustered	gi\|2674413314\|ref\|XM_062641412.1\|	407982	g1977	i0	100	0.0511463844797178	29	0	5	0	255	283	9880	9852	PREDICTED: Pezoporus occidentalis G protein-coupled receptor 21 (GPR21), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Psittaciformes	Psittacidae	Pezoporus	Pezoporus occidentalis
24407687	24407687	PRJNA1068513_S_NODE_11360_length_262_cov_1.650794_g11314_i0	PRJNA1068513	11360	262	1.650794	4.32508028	Melanerpes formicivorus	211600	Chordata	Chordata	54.7	0.007	NTclustered	gi\|2797513551\|ref\|XM_068138340.1\|	211600	g11314	i0	100	0.221374045801527	29	0	11	0	21	49	4421	4449	PREDICTED: Melanerpes formicivorus zinc finger DBF-type containing 2 (ZDBF2), transcript variant X2, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Piciformes	Picidae	Melanerpes	Melanerpes formicivorus
24407700	24407700	PRJNA1068513_S_NODE_12540_length_249_cov_0.886364_g12494_i0	PRJNA1068513	12540	249	0.886364	2.20704636	Mus musculus	10090	Chordata	Chordata	54.7	0.006	NTclustered	gi\|71533340\|gb\|AC156162.2\|	10090	g12494	i0	100	0.116465863453815	29	0	12	0	91	119	100783	100755	Mus musculus BAC clone RP24-342A17 from chromosome 9, complete sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus

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