metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJEB65099" and tax

14 rows where analysis = "blastn", bioproject = "PRJEB65099" 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
3956031	3956031	PRJEB65099_P_NODE_2404_length_376_cov_1.801980_g2299_i0	PRJEB65099	2404	376	1.80198	6.7754448	Diuraphis noxia	143948	Arthropoda	Arthropoda	56.5	0.003	NTclustered	gi\|985399333\|ref\|XM_015511795.1\|	143948	g2299	i0	100	3.6781914893617	30	0	8	0	248	277	839	868	PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA	blastn	1383	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Diuraphis	Diuraphis noxia
3956051	3956051	PRJEB65099_P_NODE_5924_length_247_cov_0.896552_g5819_i0	PRJEB65099	5924	247	0.896552	2.21448344	Drosophila melanogaster	7227	Arthropoda	Arthropoda	451	1.88e-122	NTclustered	gi\|13027520\|gb\|AC007984.4\|AC007984	7227	g5819	i0	99.595	1	247	1	100	0	1	247	60507	60753	Drosophila melanogaster, chromosome 3R, region 97D-97E, BAC clone BACR05C10, complete sequence	blastn	247	451	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
4821915	4821915	PRJEB65099_P_NODE_2904_length_336_cov_1.844106_g2799_i0	PRJEB65099	2904	336	1.844106	6.19619616	root	1	Root_unresolved	Root_unresolved	604	1.9399999999999992e-168	NTclustered	gi\|83281396\|gb\|AC167967.6\|	7176	g2799	i0	99.107	166.005952380952	336	3	100	0	1	336	134	469	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940144D9, complete sequence	blastn	55778	610	0.99016393442623	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
5232481	5232481	PRJEB65099_P_NODE_5165_length_252_cov_0.871508_g5060_i0	PRJEB65099	5165	252	0.871508	2.19620016	Drosophila melanogaster	7227	Arthropoda	Arthropoda	466	6.89e-127	NTclustered	gi\|158250\|gb\|J01123.1\|DRORGEEC2	7227	g5060	i0	100	41.6825396825397	252	0	100	0	1	252	37	288	d.melanogaster rrna external transcribed spacer, 38s precursor; clones pdmr y22, pdmr 275c2	blastn	10504	466	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
7782336	7782336	PRJEB65099_P_NODE_6147_length_246_cov_0.901734_g6042_i0	PRJEB65099	6147	246	0.901734	2.21826564	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	69.4	2.21e-7	NTclustered	gi\|1535917676\|ref\|XM_027345226.1\|	6956	g6042	i0	92.157	0.207317073170732	51	1	20	2	1	48	1777	1827	PREDICTED: Dermatophagoides pteronyssinus retinoic acid receptor RXR-alpha-B-like (LOC113795048), mRNA	blastn	51	69.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
8646937	8646937	PRJEB65099_P_NODE_2847_length_340_cov_2.913858_g2742_i0	PRJEB65099	2847	340	2.913858	9.9071172	Chironomidae	7149	Arthropoda	Arthropoda	584	2.56e-162	NTclustered	gi\|2486656233\|gb\|OQ819021.1\|	611500	g2742	i0	97.647	101.652941176471	340	8	100	0	1	340	2250	1911	Hydrobaenus laticaudus isolate 617 HYD-BAS8G7-10 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence	blastn	34562	584	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Hydrobaenus	Hydrobaenus laticaudus
11608456	11608456	PRJEB65099_P_NODE_2950_length_333_cov_2.134615_g2845_i0	PRJEB65099	2950	333	2.134615	7.10826795	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	52.8	0.031	NTclustered	gi\|1964071897\|emb\|OC878895.1\|	1979941	g2845	i0	100	0.0840840840840841	28	0	8	0	305	332	518	545	Medioppia subpectinata	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
12472829	12472829	PRJEB65099_P_NODE_5350_length_251_cov_0.876404_g5245_i0	PRJEB65099	5350	251	0.876404	2.19977404	root	1	Root_unresolved	Root_unresolved	464	2.47e-126	NTclustered	gi\|78190082\|gb\|AC168047.3\|	7176	g5245	i0	100	42.8964143426295	251	0	100	0	1	251	86245	85995	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence	blastn	10767	464	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
12883558	12883558	PRJEB65099_P_NODE_6091_length_246_cov_0.901734_g5986_i0	PRJEB65099	6091	246	0.901734	2.21826564	Drosophila melanogaster	7227	Arthropoda	Arthropoda	449	6.74e-122	NTclustered	gi\|114329622\|gb\|CP000215.2\|	7227	g5986	i0	99.593	48.7154471544715	246	1	100	0	1	246	308692	308937	Drosophila melanogaster genomic scaffold 211000022280786	blastn	11984	449	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
16296545	16296545	PRJEB65099_P_NODE_6933_length_242_cov_0.923077_g6828_i0	PRJEB65099	6933	242	0.923077	2.23384634	Staphylinidae	29026	Arthropoda	Arthropoda	248	2.59e-61	NTclustered	gi\|693464834\|gb\|KJ844884.1\|	1541375	g6828	i0	97.902	59.3471074380165	143	3	59	0	8	150	283	141	Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence	blastn	14362	248	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Staphylinidae	Pselaptrichus	Pselaptrichus sp. DDM1181
17981509	17981509	PRJEB65099_P_NODE_6735_length_243_cov_0.917647_g6630_i0	PRJEB65099	6735	243	0.917647	2.22988221	Oppiella nova	334625	Arthropoda	Arthropoda	335	1.9399999999999993e-87	NTclustered	gi\|1962641582\|emb\|OC958448.1\|	334625	g6630	i0	92.05	1.83539094650206	239	18	98	1	1	238	304	542	Oppiella nova	blastn	446	335	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
21806688	21806688	PRJEB65099_P_NODE_5318_length_251_cov_0.876404_g5213_i0	PRJEB65099	5318	251	0.876404	2.19977404	Drosophila melanogaster	7227	Arthropoda	Arthropoda	435	1.93e-117	NTclustered	gi\|13270514\|gb\|AC009250.3\|AC009250	7227	g5213	i0	97.647	1.01593625498008	255	2	100	1	1	251	33449	33195	Drosophila melanogaster, chromosome 2L, region 36B-36B, BAC clone BACR27M18, complete sequence	blastn	255	435	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
21806697	21806697	PRJEB65099_P_NODE_5978_length_247_cov_0.896552_g5873_i0	PRJEB65099	5978	247	0.896552	2.21448344	Orthoperus sp. CO961	1285980	Arthropoda	Arthropoda	457	4.05e-124	NTclustered	gi\|444301546\|gb\|JX845001.1\|	1285980	g5873	i0	100	91.4453441295547	247	0	100	0	1	247	617	863	Orthoperus sp. CO961 18S ribosomal RNA gene, partial sequence	blastn	22587	457	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Corylophidae	Orthoperus	Orthoperus sp. CO961
23081882	23081882	PRJEB65099_P_NODE_6519_length_244_cov_0.912281_g6414_i0	PRJEB65099	6519	244	0.912281	2.22596564	Chelidurella thaleri	2546182	Arthropoda	Arthropoda	75	4.7e-9	NTclustered	gi\|2919610596\|emb\|OZ238420.1\|	2546182	g6414	i0	85.714	14.6926229508197	70	10	29	0	104	173	10998912	10998843	Chelidura thaleri genome assembly, chromosome: 21	blastn	3585	75	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Dermaptera	Forficulidae	Chelidurella	Chelidurella thaleri

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