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

7 rows where analysis = "blastn", bioproject = "PRJNA229468" and tax_phylum = "Arthropoda"

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