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

24 rows where analysis = "blastn", bioproject = "PRJEB65099" 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
129938	129938	PRJEB65099_P_NODE_5641_length_249_cov_0.886364_g5536_i0	PRJEB65099	5641	249	0.886364	2.20704636	Meloidogyne incognita	6306	Nematoda	Nematoda	449	6.840000000000001e-122	NTclustered	gi\|133752979\|gb\|EF370396.1\|	6306	g5536	i0	99.197	5.45381526104418	249	2	100	0	1	249	1075	1323	Meloidogyne incognita venom allergen-like protein (vap-2) gene, complete cds	blastn	1358	449	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne incognita
2680042	2680042	PRJEB65099_P_NODE_3643_length_292_cov_1.068493_g3538_i0	PRJEB65099	3643	292	1.068493	3.11999956	Rattus norvegicus	10116	Chordata	Chordata	540	4.74e-149	NTclustered	gi\|298882625\|emb\|FQ211010.1\|	10116	g3538	i0	100	97.4280821917808	292	0	100	0	1	292	183	474	Rattus norvegicus TL0ABA18YP20 mRNA sequence	blastn	28449	540	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus
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
6097041	6097041	PRJEB65099_P_NODE_5245_length_251_cov_0.876404_g5140_i0	PRJEB65099	5245	251	0.876404	2.19977404	Lampetra	13103	Chordata	Chordata	287	5.73e-73	NTclustered	gi\|2815010089\|emb\|OZ078632.2\|	7748	g5140	i0	93.782	93.0159362549801	193	8	76	2	1	190	4105374	4105183	Lampetra fluviatilis genome assembly, chromosome: 64	blastn	23347	287	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
6508174	6508174	PRJEB65099_P_NODE_5866_length_247_cov_1.551724_g5761_i0	PRJEB65099	5866	247	1.551724	3.83275828	Mus musculus	10090	Chordata	Chordata	56.5	0.002	NTclustered	gi\|47551370\|gb\|AC026233.4\|	10090	g5761	i0	94.444	0.291497975708502	36	2	15	0	112	147	129429	129464	Mus musculus strain C57BL6/J chromosome 5 clone RP23-407F12, complete sequence	blastn	72	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
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
9057218	9057218	PRJEB65099_P_NODE_6148_length_246_cov_0.901734_g6043_i0	PRJEB65099	6148	246	0.901734	2.21826564	Sus scrofa	9823	Chordata	Chordata	67.6	7.94e-7	NTclustered	gi\|168149178\|emb\|CT797459.5\|	9823	g6043	i0	86.885	0.463414634146341	61	7	24	1	162	221	69063	69123	Pig DNA sequence from clone CH242-214A4 on chromosome 7, complete sequence	blastn	114	67.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
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
15021770	15021770	PRJEB65099_P_NODE_6592_length_243_cov_1.811765_g6487_i0	PRJEB65099	6592	243	1.811765	4.40258895	Bos	9903	Chordata	Chordata	420	5.21e-113	NTclustered	gi\|1068294018\|gb\|KX592814.1\|	9913	g6487	i0	97.942	249.938271604938	243	4	100	1	1	243	5676253	5676494	Bos taurus isolate Dominette_000065F genomic sequence	blastn	60735	422	0.995260663507109	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
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
16706619	16706619	PRJEB65099_P_NODE_5314_length_251_cov_0.876404_g5209_i0	PRJEB65099	5314	251	0.876404	2.19977404	Rattus norvegicus	10116	Chordata	Chordata	449	6.899999999999999e-122	NTclustered	gi\|229220814\|gb\|AC115369.5\|	10116	g5209	i0	99.2	4.54183266932271	250	1	99	1	1	250	67102	66854	Rattus norvegicus CH230-89H17 (Children's Hospital Oakland Research Institute Rat (BN/SsNHsd/MCW) BAC library) complete sequence	blastn	1140	449	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus
16706635	16706635	PRJEB65099_P_NODE_6514_length_244_cov_0.912281_g6409_i0	PRJEB65099	6514	244	0.912281	2.22596564	Meloidogyne incognita	6306	Nematoda	Nematoda	446	8.639999999999999e-121	NTclustered	gi\|40037069\|gb\|AY422836.1\|	6306	g6409	i0	99.59	5.0655737704918	244	1	100	0	1	244	1064	1307	Meloidogyne incognita cellulase (eng3) mRNA, complete cds	blastn	1236	446	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne incognita
17981489	17981489	PRJEB65099_P_NODE_5315_length_251_cov_0.876404_g5210_i0	PRJEB65099	5315	251	0.876404	2.19977404	Sus scrofa	9823	Chordata	Chordata	346	9.32e-91	NTclustered	gi\|1191804880\|ref\|XM_005659135.3\|	9823	g5210	i0	97.525	4.0398406374502	202	5	90	0	27	228	6404	6203	PREDICTED: Sus scrofa coiled-coil domain containing 170 (CCDC170), transcript variant X1, mRNA	blastn	1014	346	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
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
20530936	20530936	PRJEB65099_P_NODE_6677_length_243_cov_0.917647_g6572_i0	PRJEB65099	6677	243	0.917647	2.22988221	Sus scrofa	9823	Chordata	Chordata	95.3	3.59e-15	NTclustered	gi\|116636932\|emb\|CT737289.9\|	9823	g6572	i0	90.411	0.860082304526749	73	6	30	1	172	243	158367	158439	Pig DNA sequence from clone CH242-133B3 on chromosome 14, complete sequence	blastn	209	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
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);;