metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA169559" 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
364886	364886	PRJNA169559_P_NODE_20421_length_367_cov_2.869822_g18375_i0	PRJNA169559	20421	367	2.869822	10.53224674	Lethenteron reissneri	7753	Chordata	Chordata	171	9.22e-38	NTclustered	gi\|2635903854\|ref\|XM_061574750.1\|	7753	g18375	i0	82.474	26.9673024523161	194	34	53	0	1	194	472	665	PREDICTED: Lethenteron reissneri parkin coregulated gene protein-like (LOC133357008), mRNA	blastn	9897	171	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
364969	364969	PRJNA169559_P_NODE_26541_length_287_cov_1.279070_g24465_i0	PRJNA169559	26541	287	1.27907	3.6709309	Fringilla coelebs	37598	Chordata	Chordata	52.8	0.027	NTclustered	gi\|2917610922\|emb\|OZ228690.1\|	37598	g24465	i0	100	0.0975609756097561	28	0	10	0	22	49	63098159	63098186	Fringilla coelebs genome assembly, chromosome: Z	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Fringilla	Fringilla coelebs
365175	365175	PRJNA169559_P_NODE_6801_length_650_cov_2.731079_g5301_i0	PRJNA169559	6801	650	2.731079	17.7520135	Apteryx mantelli	2696672	Chordata	Chordata	244	9.94e-60	NTclustered	gi\|2788337125\|ref\|XM_067316786.1\|	2696672	g5301	i0	79.032	30.02	372	67	57	9	274	641	879	515	PREDICTED: Apteryx mantelli dual specificity tyrosine-phosphorylation-regulated kinase 1A-like (LOC106500513), mRNA	blastn	19513	244	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apterygiformes	Apterygidae	Apteryx	Apteryx mantelli
1639765	1639765	PRJNA169559_P_NODE_24862_length_304_cov_1.680000_g22786_i0	PRJNA169559	24862	304	1.68	5.1072	Mus musculus	10090	Chordata	Chordata	52.8	0.028	NTclustered	gi\|49615225\|gb\|AC115787.6\|	10090	g22786	i0	100	0.0921052631578947	28	0	9	0	208	235	55060	55087	Mus musculus chromosome 16, clone RP23-212P1, complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
1639787	1639787	PRJNA169559_P_NODE_26722_length_285_cov_2.277344_g24646_i0	PRJNA169559	26722	285	2.277344	6.4904304	Lethenteron reissneri	7753	Chordata	Chordata	235	2.44e-57	NTclustered	gi\|2635819448\|ref\|XM_061551223.1\|	7753	g24646	i0	84.298	68.2666666666667	242	36	84	1	3	242	727	968	PREDICTED: Lethenteron reissneri serine/threonine-protein phosphatase PP1-beta catalytic subunit-like (LOC133342219), mRNA	blastn	19456	235	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
1639835	1639835	PRJNA169559_P_NODE_32542_length_255_cov_1.203540_g30466_i0	PRJNA169559	32542	255	1.20354	3.069027	Styela clava	7725	Chordata	Chordata	78.7	3.82e-10	NTclustered	gi\|1981767160\|ref\|XM_039394675.1\|	7725	g30466	i0	92.593	1.9843137254902	54	4	21	0	38	91	1016	963	PREDICTED: Styela clava alpha-enolase-like (LOC120328239), mRNA	blastn	506	78.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
1639876	1639876	PRJNA169559_P_NODE_41362_length_231_cov_39.297030_g39285_i0	PRJNA169559	41362	231	39.29703	90.7761393	Microcaecilia unicolor	1415580	Chordata	Chordata	52.8	0.021	NTclustered	gi\|1716988291\|ref\|XM_030215858.1\|	1415580	g39285	i0	100	0.121212121212121	28	0	12	0	15	42	39	12	PREDICTED: Microcaecilia unicolor choline-phosphate cytidylyltransferase A (LOC115478491), transcript variant X1, mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Siphonopidae	Microcaecilia	Microcaecilia unicolor
2915812	2915812	PRJNA169559_P_NODE_4823_length_772_cov_3.491252_g3529_i0	PRJNA169559	4823	772	3.491252	26.95246544	Canis lupus	9612	Chordata	Chordata	1153	0	NTclustered	gi\|35187713\|gb\|AY339974.1\|	9615	g3529	i0	94.519	49.5038860103627	748	39	100	2	1	747	747	1	Canis familiaris clone 2 satellite sequence	blastn	38217	1153	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
3605242	3605242	PRJNA169559_P_NODE_21943_length_344_cov_2.330159_g19880_i0	PRJNA169559	21943	344	2.330159	8.01574696	Mammalia	40674	Chordata	Chordata	95.3	5.33e-15	NTclustered	gi\|2867967139\|ref\|XM_005597755.4\|	9796	g19880	i0	88.462	6.86627906976744	78	9	23	0	245	322	487	410	PREDICTED: Equus caballus eukaryotic translation initiation factor 4A1 (EIF4A1), transcript variant X1, mRNA	blastn	2362	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Perissodactyla	Equidae	Equus	Equus caballus
7432733	7432733	PRJNA169559_P_NODE_37526_length_241_cov_1.448113_g35449_i0	PRJNA169559	37526	241	1.448113	3.48995233	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	65.8	2.79e-6	NTclustered	gi\|2069520095\|ref\|XR_006102330.1\|	8520	g35449	i0	97.368	16.4813278008299	38	1	16	0	30	67	299	336	PREDICTED: Sceloporus undulatus uncharacterized LOC121923206 (LOC121923206), ncRNA	blastn	3972	65.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Phrynosomatidae	Sceloporus	Sceloporus undulatus
9293223	9293223	PRJNA169559_P_NODE_46488_length_193_cov_8.512195_g44411_i0	PRJNA169559	46488	193	8.512195	16.42853635	Ochotona princeps	9978	Chordata	Chordata	52.8	0.017	NTclustered	gi\|2558318719\|ref\|XM_058675597.1\|	9978	g44411	i0	100	0.580310880829015	28	0	15	0	1	28	327	354	PREDICTED: Ochotona princeps ubiquitin C (UBC), mRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Lagomorpha	Ochotonidae	Ochotona	Ochotona princeps
10569137	10569137	PRJNA169559_P_NODE_39909_length_235_cov_1.771845_g37832_i0	PRJNA169559	39909	235	1.771845	4.16383575	Acinonyx jubatus	32536	Chordata	Chordata	75	4.49e-9	NTclustered	gi\|2437673126\|ref\|XM_015062530.3\|	32536	g37832	i0	81.319	0.387234042553191	91	17	39	0	1	91	1568	1658	PREDICTED: Acinonyx jubatus DEAD-box helicase 18 (DDX18), mRNA	blastn	91	75	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Acinonyx	Acinonyx jubatus
12533458	12533458	PRJNA169559_P_NODE_47110_length_183_cov_4.266234_g45033_i0	PRJNA169559	47110	183	4.266234	7.80720822	Cheloniidae	8465	Chordata	Chordata	56.5	0.001	NTclustered	gi\|2911444060\|emb\|OZ223572.1\|	8472	g45033	i0	96.97	0.360655737704918	33	1	18	0	27	59	50290553	50290521	Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 14	blastn	66	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Lepidochelys	Lepidochelys kempii
18906260	18906260	PRJNA169559_P_NODE_17155_length_410_cov_2.230971_g15168_i0	PRJNA169559	17155	410	2.230971	9.1469811	Mammalia	40674	Chordata	Chordata	58.4	8.46e-4	NTclustered	gi\|1788870104\|ref\|XM_031946177.1\|	9305	g15168	i0	97.059	1.68048780487805	34	1	8	0	288	321	406	439	PREDICTED: Sarcophilus harrisii BCL2 apoptosis regulator (BCL2), mRNA	blastn	689	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Dasyuromorphia	Dasyuridae	Sarcophilus	Sarcophilus harrisii
19490847	19490847	PRJNA169559_P_NODE_16736_length_414_cov_3.096104_g14758_i0	PRJNA169559	16736	414	3.096104	12.81787056	Nothoprocta perdicaria	30464	Chordata	Chordata	296	1.67e-75	NTclustered	gi\|1443722022\|ref\|XM_026051569.1\|	30464	g14758	i0	80.879	82.5314009661836	387	65	92	7	35	414	917	533	PREDICTED: Nothoprocta perdicaria protein phosphatase 1 catalytic subunit alpha (PPP1CA), partial mRNA	blastn	34168	296	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Tinamiformes	Tinamidae	Nothoprocta	Nothoprocta perdicaria
20766565	20766565	PRJNA169559_P_NODE_32897_length_253_cov_13.120536_g30821_i0	PRJNA169559	32897	253	13.120536	33.19495608	Ranitomeya imitator	111125	Chordata	Chordata	104	6.25e-18	NTclustered	gi\|2851921963\|ref\|XM_069756253.1\|	111125	g30821	i0	88.372	4.58893280632411	86	10	34	0	2	87	2205	2290	PREDICTED: Ranitomeya imitator peptidase M20 domain containing 1 (PM20D1), mRNA	blastn	1161	104	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
20766572	20766572	PRJNA169559_P_NODE_33637_length_251_cov_3.000000_g31560_i0	PRJNA169559	33637	251	3	7.53	Nyctibius grandis	48427	Chordata	Chordata	154	6.06e-33	NTclustered	gi\|2805116535\|ref\|XM_068410000.1\|	48427	g31560	i0	82.584	68.605577689243	178	27	70	4	2	177	360	535	PREDICTED: Nyctibius grandis ADP ribosylation factor 3 (ARF3), transcript variant X2, mRNA	blastn	17220	154	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Caprimulgiformes	Nyctibiidae	Nyctibius	Nyctibius grandis
23316993	23316993	PRJNA169559_P_NODE_1799_length_1243_cov_5.901977_g1071_i0	PRJNA169559	1799	1243	5.901977	73.36157411	Serinus canaria	9135	Chordata	Chordata	394	1.83e-104	NTclustered	gi\|2312744235\|ref\|XM_050987987.1\|	9135	g1071	i0	75.694	25.4867256637168	864	169	68	33	231	1075	223	1064	PREDICTED: Serinus canaria calreticulin (CALR), mRNA	blastn	31680	394	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Serinus	Serinus canaria
24591341	24591341	PRJNA169559_P_NODE_37200_length_242_cov_1.154930_g35123_i0	PRJNA169559	37200	242	1.15493	2.7949306	Sitta europaea	50251	Chordata	Chordata	52.8	0.022	NTclustered	gi\|2917587609\|emb\|OZ228644.1\|	50251	g35123	i0	100	0.231404958677686	28	0	12	0	204	231	4312857	4312830	Sitta europaea genome assembly, chromosome: 23	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Sittidae	Sitta	Sitta europaea
24591394	24591394	PRJNA169559_P_NODE_45320_length_211_cov_2.478022_g43243_i0	PRJNA169559	45320	211	2.478022	5.22862642	Pyrrhula murina	928672	Chordata	Chordata	54.7	0.005	NTclustered	gi\|2920008267\|emb\|OZ239000.1\|	928672	g43243	i0	100	0.137440758293839	29	0	14	0	96	124	23013954	23013926	Pyrrhula murina genome assembly, chromosome: 6	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Pyrrhula	Pyrrhula murina

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