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

14 rows where analysis = "blastn", bioproject = "PRJEB50765" 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
991329	991329	PRJEB50765_P_NODE_2001_length_204_cov_1.371257_g1977_i0	PRJEB50765	2001	204	1.371257	2.79736428	Culex	7174	Arthropoda	Arthropoda	62.1	2.96e-5	NTclustered	gi\|1949592807\|ref\|XM_038254214.1\|	7176	g1977	i0	100	13.2549019607843	33	0	16	0	19	51	353	321	Culex quinquefasciatus ATP synthase subunit beta, mitochondrial (LOC6038107), mRNA	blastn	2704	62.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
1393963	1393963	PRJEB50765_P_NODE_3182_length_154_cov_1.136752_g3158_i0	PRJEB50765	3182	154	1.136752	1.75059808	Aedes aegypti	7159	Arthropoda	Arthropoda	193	7.14e-45	NTclustered	gi\|1218254935\|ref\|XM_001655975.2\|	7159	g3158	i0	89.542	97.5064935064935	153	14	99	2	2	153	1353	1504	PREDICTED: Aedes aegypti tubulin beta-1 chain (LOC5576244), mRNA	blastn	15016	193	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Aedes	Aedes aegypti
2669626	2669626	PRJEB50765_P_NODE_2663_length_171_cov_1.156716_g2639_i0	PRJEB50765	2663	171	1.156716	1.97798436	Mus musculus	10090	Chordata	Chordata	316	4.6e-82	NTclustered	gi\|26984705\|emb\|AL772296.6\|	10090	g2639	i0	100	1	171	0	100	0	1	171	109327	109157	Mouse DNA sequence from clone RP23-66O9 on chromosome 4, complete sequence	blastn	171	316	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
2669628	2669628	PRJEB50765_P_NODE_3043_length_157_cov_15.308333_g3019_i0	PRJEB50765	3043	157	15.308333	24.03408281	Mus musculus	10090	Chordata	Chordata	291	2.52e-74	NTclustered	gi\|85069293\|gb\|DQ322708.1\|	10090	g3019	i0	100	271.917197452229	157	0	100	0	1	157	2805	2649	Mus musculus clone fosmid G135P66076F10 sequence from forward end	blastn	42691	291	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
5221954	5221954	PRJEB50765_P_NODE_1125_length_298_cov_2.490421_g1101_i0	PRJEB50765	1125	298	2.490421	7.42145458	Chironomus tepperi	113505	Arthropoda	Arthropoda	209	1.55e-49	NTclustered	gi\|2874233255\|ref\|XM_070651430.1\|	113505	g1101	i0	84.404	26.0167785234899	218	29	72	4	51	266	147	361	PREDICTED: Chironomus tepperi tubulin alpha-1 chain (LOC139099036), mRNA	blastn	7753	209	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
5221970	5221970	PRJEB50765_P_NODE_3265_length_152_cov_0.991304_g3241_i0	PRJEB50765	3265	152	0.991304	1.50678208	Drosophila melanogaster	7227	Arthropoda	Arthropoda	52.8	0.012	NTclustered	gi\|15451502\|gb\|AC008326.9\|	7227	g3241	i0	100	0.368421052631579	28	0	18	0	70	97	57099	57126	Drosophila melanogaster, chromosome 2L, region 27C-27C, BAC clone BACR39J17, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila melanogaster
6497798	6497798	PRJEB50765_P_NODE_2926_length_161_cov_3.120968_g2902_i0	PRJEB50765	2926	161	3.120968	5.02475848	Docodesmus trinidadensis	245715	Arthropoda	Arthropoda	86.1	1.32e-12	NTclustered	gi\|34597163\|gb\|AY310255.1\|	245715	g2902	i0	89.552	1.37267080745342	67	7	42	0	85	151	213	279	Docodesmus trinidadensis voucher Dotr elongation factor 2 mRNA, partial cds	blastn	221	86.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Diplopoda	Polydesmida	Pyrgodesmidae	Docodesmus	Docodesmus trinidadensis
10322475	10322475	PRJEB50765_P_NODE_1409_length_257_cov_2.268182_g1385_i0	PRJEB50765	1409	257	2.268182	5.82922774	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	442	1.1899999999999995e-119	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g1385	i0	97.665	1	257	6	100	0	1	257	268	12	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	257	442	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
11597876	11597876	PRJEB50765_P_NODE_290_length_618_cov_2.383821_g272_i0	PRJEB50765	290	618	2.383821	14.73201378	Papilio polytes	76194	Arthropoda	Arthropoda	977	0	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g272	i0	99.259	24.1326860841424	540	4	87	0	79	618	1	540	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	14914	977	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
12873055	12873055	PRJEB50765_P_NODE_2811_length_165_cov_1.789062_g2787_i0	PRJEB50765	2811	165	1.789062	2.9519523	Bradysia coprophila	38358	Arthropoda	Arthropoda	193	7.79e-45	NTclustered	gi\|1928081288\|ref\|XM_037188404.1\|	38358	g2787	i0	89.474	99.6909090909091	152	16	92	0	4	155	861	1012	PREDICTED: Bradysia coprophila ATP synthase subunit beta, mitochondrial (LOC119080178), mRNA	blastn	16449	193	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia coprophila
13744767	13744767	PRJEB50765_P_NODE_1071_length_308_cov_2.405904_g1047_i0	PRJEB50765	1071	308	2.405904	7.41018432	Caenorhabditis	6237	Nematoda	Nematoda	265	3.39e-66	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g1047	i0	87.446	76.4415584415584	231	27	75	2	77	306	1307	1078	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	23544	265	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
14147887	14147887	PRJEB50765_P_NODE_2352_length_184_cov_3.183673_g2328_i0	PRJEB50765	2352	184	3.183673	5.85795832	Caenorhabditis elegans	6239	Nematoda	Nematoda	202	1.47e-47	NTclustered	gi\|1972294218\|ref\|NM_001380754.2\|	6239	g2328	i0	86.413	97.8858695652174	184	25	100	0	1	184	86	269	Caenorhabditis elegans Actin-3 (act-3), mRNA	blastn	18011	202	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
21393446	21393446	PRJEB50765_P_NODE_977_length_330_cov_2.443686_g953_i0	PRJEB50765	977	330	2.443686	8.0641638	Metazoa	33208	Mollusca	Mollusca	108	6.54e-19	NTclustered	gi\|2694132578\|ref\|XM_063542695.1\|	6551	g953	i0	84.404	13.3212121212121	109	17	33	0	7	115	465	573	PREDICTED: Mytilus trossulus small ribosomal subunit protein uS9 (LOC134683410), mRNA	blastn	4396	108	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus trossulus
23071566	23071566	PRJEB50765_P_NODE_2459_length_180_cov_1.083916_g2435_i0	PRJEB50765	2459	180	1.083916	1.9510488	Amurrhyparia leopardinula	1875010	Arthropoda	Arthropoda	67.6	5.45e-7	NTclustered	gi\|1051347853\|gb\|KX050456.1\|	1875010	g2435	i0	86.885	0.338888888888889	61	7	34	1	19	79	278	337	Amurrhyparia leopardinula voucher KN00881 cytosolic malate dehydrogenase (MDH) gene, partial cds	blastn	61	67.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Erebidae	Amurrhyparia	Amurrhyparia leopardinula

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