metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA229468" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA229468" 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
367288	367288	PRJNA229468_S_NODE_321_length_277_cov_4.311404_g308_i0	PRJNA229468	321	277	4.311404	11.94258908	Ciona intestinalis	7719	Chordata	Chordata	235	2.3599999999999997e-57	NTclustered	gi\|1494783678\|ref\|XM_009862731.3\|	7719	g308	i0	82.955	152.649819494585	264	41	99	4	16	277	1225	1486	PREDICTED: Ciona intestinalis polyubiquitin-A (LOC100175058), transcript variant X1, mRNA	blastn	42284	235	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis
1642069	1642069	PRJNA229468_S_NODE_642_length_203_cov_0.993506_g629_i0	PRJNA229468	642	203	0.993506	2.01681718	Strongyloides papillosus	174720	Nematoda	Nematoda	139	1.3199999999999999e-28	NTclustered	gi\|687022666\|emb\|LM525580.1\|	174720	g629	i0	83.117	66.8374384236453	154	24	75	2	50	202	237377	237225	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000007	blastn	13568	139	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
2917899	2917899	PRJNA229468_S_NODE_1083_length_166_cov_1.307692_g1070_i0	PRJNA229468	1083	166	1.307692	2.17076872	Cotesia glomerata	32391	Arthropoda	Arthropoda	128	2.25e-25	NTclustered	gi\|2120545063\|ref\|XM_044719895.1\|	32391	g1070	i0	81.132	69.4638554216867	159	30	96	0	6	164	846	1004	PREDICTED: Cotesia glomerata polyubiquitin (LOC123259399), mRNA	blastn	11531	128	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Cotesia	Cotesia glomerata
2917900	2917900	PRJNA229468_S_NODE_163_length_378_cov_1.683891_g150_i0	PRJNA229468	163	378	1.683891	6.36510798	Lottia gigantea	225164	Mollusca	Mollusca	226	1.9999999999999998e-54	NTclustered	gi\|676456588\|ref\|XM_009056125.1\|	225164	g150	i0	83.065	7.94708994708995	248	42	66	0	25	272	386	139	Lottia gigantea hypothetical protein mRNA	blastn	3004	226	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
4194376	4194376	PRJNA229468_S_NODE_844_length_181_cov_2.303030_g831_i0	PRJNA229468	844	181	2.30303	4.1684843	Xenopus tropicalis	8364	Chordata	Chordata	111	2.5e-20	NTclustered	gi\|77620966\|emb\|CR761546.2\|	8364	g831	i0	79.29	3.7292817679558	169	27	91	6	11	175	271	107	Xenopus tropicalis finished cDNA, clone TGas127d10	blastn	675	111	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
5470639	5470639	PRJNA229468_S_NODE_905_length_177_cov_2.257812_g892_i0	PRJNA229468	905	177	2.257812	3.99632724	Scyliorhinus canicula	7830	Chordata	Chordata	95.3	2.45e-15	NTclustered	gi\|1952512345\|ref\|XM_038789812.1\|	7830	g892	i0	79.412	2.30508474576271	136	26	76	2	43	177	246	112	PREDICTED: Scyliorhinus canicula 60S ribosomal protein L11-like (LOC119962035), mRNA	blastn	408	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Carcharhiniformes	Scyliorhinidae	Scyliorhinus	Scyliorhinus canicula
6744941	6744941	PRJNA229468_S_NODE_426_length_240_cov_1.198953_g413_i0	PRJNA229468	426	240	1.198953	2.8774872	Physella acuta	109671	Mollusca	Mollusca	154	5.75e-33	NTclustered	gi\|2572306679\|ref\|XM_059294357.1\|	109671	g413	i0	82.065	28.5208333333333	184	30	76	3	1	183	305	486	PREDICTED: Physella acuta large ribosomal subunit protein uL14 (LOC131937156), mRNA	blastn	6845	154	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
7434488	7434488	PRJNA229468_S_NODE_846_length_181_cov_1.931818_g833_i0	PRJNA229468	846	181	1.931818	3.49659058	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	230	6.62e-56	NTclustered	gi\|687022656\|emb\|LM525570.1\|	174720	g833	i0	89.888	94.6243093922652	178	18	98	0	4	181	200843	200666	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000005	blastn	17127	230	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
8709274	8709274	PRJNA229468_S_NODE_967_length_172_cov_2.479675_g954_i0	PRJNA229468	967	172	2.479675	4.265041	Lepidoptera	7088	Arthropoda	Arthropoda	191	2.93e-44	NTclustered	gi\|1905483641\|gb\|MK295902.1\|	282318	g954	i0	87.135	99.4418604651163	171	18	98	4	1	169	37	205	Leptotes pirithous voucher LYC076 elongation factor 1 alpha (Ef1a) gene, partial cds	blastn	17104	191	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Leptotes	Leptotes pirithous
9984666	9984666	PRJNA229468_S_NODE_1148_length_164_cov_1.217391_g1135_i0	PRJNA229468	1148	164	1.217391	1.99652124	root	1	Root_unresolved	Root_unresolved	189	1e-43	NTclustered	gi\|2805740242\|emb\|OZ078478.1\|	7748	g1135	i0	88.05	97.0731707317073	159	19	97	0	1	159	103581	103739	Lampetra fluviatilis genome assembly, chromosome: 75	blastn	15920	189	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
10571338	10571338	PRJNA229468_S_NODE_589_length_211_cov_1.259259_g576_i0	PRJNA229468	589	211	1.259259	2.65703649	Aphidius gifuensis	684658	Arthropoda	Arthropoda	207	3.7400000000000004e-49	NTclustered	gi\|2106734177\|ref\|XM_044149429.1\|	684658	g576	i0	84.434	84.9336492890995	212	31	100	2	1	211	205	415	PREDICTED: Aphidius gifuensis actin-5C (LOC122850281), transcript variant X2, mRNA	blastn	17921	207	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Aphidius	Aphidius gifuensis
11845855	11845855	PRJNA229468_S_NODE_890_length_178_cov_1.790698_g877_i0	PRJNA229468	890	178	1.790698	3.18744244	Hyla sarda	327740	Chordata	Chordata	104	4.1e-18	NTclustered	gi\|2512160901\|ref\|XM_056558662.1\|	327740	g877	i0	81.967	2.45505617977528	122	22	69	0	1	122	302	181	PREDICTED: Hyla sarda tyrosine 3-monooxygenase/tryptophan 5-monooxygenase activation protein epsilon (YWHAE), transcript variant X1, mRNA	blastn	437	104	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Hyla	Hyla sarda
12535170	12535170	PRJNA229468_S_NODE_1110_length_165_cov_3.732759_g1097_i0	PRJNA229468	1110	165	3.732759	6.15905235	root	1	Root_unresolved	Root_unresolved	305	9.59e-79	NTclustered	gi\|78097480\|gb\|AC167666.4\|	7176	g1097	i0	100	293	165	0	100	0	1	165	1184	1020	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence	blastn	48345	305	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
13121080	13121080	PRJNA229468_S_NODE_451_length_234_cov_1.308108_g438_i0	PRJNA229468	451	234	1.308108	3.06097272	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	165	2.58e-36	NTclustered	gi\|2729103509\|ref\|XM_065214830.1\|	499914	g438	i0	81.159	3.25641025641026	207	37	88	2	10	215	143	348	PREDICTED: Rhopilema esculentum large ribosomal subunit protein uL15-like (LOC135695664), mRNA	blastn	762	165	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
15670083	15670083	PRJNA229468_S_NODE_1033_length_168_cov_1.285714_g1020_i0	PRJNA229468	1033	168	1.285714	2.15999952	Chrysochloris asiatica	185453	Chordata	Chordata	95.3	2.31e-15	NTclustered	gi\|586491719\|ref\|XM_006876253.1\|	185453	g1020	i0	87.059	40.5178571428571	85	10	51	1	82	166	415	332	PREDICTED: Chrysochloris asiatica solute carrier family 25 (mitochondrial carrier; adenine nucleotide translocator), member 6 (SLC25A6), mRNA	blastn	6807	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia		Chrysochloridae	Chrysochloris	Chrysochloris asiatica
19493241	19493241	PRJNA229468_S_NODE_1156_length_164_cov_0.886957_g1143_i0	PRJNA229468	1156	164	0.886957	1.45460948	Saccostrea cuccullata	36930	Mollusca	Mollusca	52.8	0.014	NTclustered	gi\|2669042795\|ref\|XM_062758970.1\|	36930	g1143	i0	96.774	0.378048780487805	31	1	19	0	99	129	2414	2384	PREDICTED: Saccostrea cucullata MAM and LDL-receptor class A domain-containing protein 2-like (LOC134276709), mRNA	blastn	62	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea cuccullata
20768807	20768807	PRJNA229468_S_NODE_1217_length_162_cov_1.336283_g1204_i0	PRJNA229468	1217	162	1.336283	2.16477846	Pseudoterpna coronillaria	1007376	Arthropoda	Arthropoda	56.5	0.001	NTclustered	gi\|2918369759\|emb\|OZ237826.1\|	1007376	g1204	i0	100	0.537037037037037	30	0	19	0	102	131	2879577	2879548	Pseudoterpna coronillaria genome assembly, chromosome: 1	blastn	87	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Geometridae	Pseudoterpna	Pseudoterpna coronillaria
20768809	20768809	PRJNA229468_S_NODE_517_length_220_cov_1.783626_g504_i0	PRJNA229468	517	220	1.783626	3.9239772	Belonocnema kinseyi	2817044	Arthropoda	Arthropoda	113	8.810000000000001e-21	NTclustered	gi\|1830529047\|ref\|XM_033358781.1\|	2817044	g504	i0	81.295	11.9409090909091	139	26	63	0	5	143	743	881	PREDICTED: Belonocnema kinseyi 60S ribosomal protein L3 (LOC117171447), mRNA	blastn	2627	113	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Cynipidae	Belonocnema	Belonocnema kinseyi
23319336	23319336	PRJNA229468_S_NODE_619_length_206_cov_0.974522_g606_i0	PRJNA229468	619	206	0.974522	2.00751532	Sitta europaea	50251	Chordata	Chordata	52.8	0.018	NTclustered	gi\|2917598300\|emb\|OZ228662.1\|	50251	g606	i0	100	0.135922330097087	28	0	14	0	1	28	9505611	9505584	Sitta europaea genome assembly, chromosome: 8	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Sittidae	Sitta	Sitta europaea
23319341	23319341	PRJNA229468_S_NODE_999_length_170_cov_2.421488_g986_i0	PRJNA229468	999	170	2.421488	4.1165296	Geotrypetes seraphini	260995	Chordata	Chordata	65.8	1.83e-6	NTclustered	gi\|1835613316\|ref\|XM_033917946.1\|	260995	g986	i0	75.94	4.00588235294118	133	28	77	4	35	165	346	476	PREDICTED: Geotrypetes seraphini ribosomal protein S25 (RPS25), mRNA	blastn	681	65.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Dermophiidae	Geotrypetes	Geotrypetes seraphini
24008523	24008523	PRJNA229468_S_NODE_1239_length_161_cov_1.821429_g1226_i0	PRJNA229468	1239	161	1.821429	2.93250069	Formicidae	36668	Arthropoda	Arthropoda	95.3	2.19e-15	NTclustered	gi\|780621847\|ref\|XM_011709211.1\|	64793	g1226	i0	80.992	7.08695652173913	121	21	75	2	33	152	1066	947	PREDICTED: Wasmannia auropunctata 60S ribosomal protein L3 (LOC105462542), mRNA	blastn	1141	95.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Wasmannia	Wasmannia auropunctata

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