metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1082072" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1082072" 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
193174	193174	PRJNA1082072_P_NODE_141_length_785_cov_3.985955_g48_i1	PRJNA1082072	141	785	3.985955	31.28974675	Pachyrhinus yasumatsui	2071596	Arthropoda	Arthropoda	518	6.46e-142	NTclustered	gi\|2284955655\|gb\|OK105108.1\|	2071596	g48	i1	81.69	78.5312101910828	639	101	80	13	143	773	631	1	Pachyrhinus yasumatsui elongation factor 1-alpha mRNA, complete cds	blastn	61647	518	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Pachyrhinus	Pachyrhinus yasumatsui
193192	193192	PRJNA1082072_P_NODE_61_length_1102_cov_5.476190_g58_i0	PRJNA1082072	61	1102	5.47619	60.3476138	Asplanchna brightwellii	2005548	Rotifera	other_Eukaryota	359	5.9e-94	NTclustered	gi\|2899343712\|gb\|PQ788833.1\|	2005548	g58	i0	77.508	30.2486388384755	658	109	58	35	9	651	2406	1773	Asplanchna brightwellii chromosome I mitochondrion, complete sequence	blastn	33334	359	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna brightwellii
2292522	2292522	PRJNA1082072_P_NODE_2602_length_245_cov_1.343023_g2595_i0	PRJNA1082072	2602	245	1.343023	3.29040635	Ploima	84394	Rotifera	other_Eukaryota	250	7.31e-62	NTclustered	gi\|1227482247\|gb\|KX495815.1\|	104777	g2595	i0	86.207	85.5387755102041	232	31	94	1	8	238	234	3	Brachionus calyciflorus isolate GQ11 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	20957	252	0.992063492063492	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
2743895	2743895	PRJNA1082072_P_NODE_1203_length_316_cov_0.868313_g1196_i0	PRJNA1082072	1203	316	0.868313	2.74386908	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	52.8	0.03	NTclustered	gi\|2919550840\|emb\|OZ238361.1\|	1002887	g1196	i0	100	0.0886075949367089	28	0	9	0	244	271	14100628	14100601	Glaucopsyche melanops genome assembly, chromosome: 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops
2743903	2743903	PRJNA1082072_P_NODE_2123_length_251_cov_0.865169_g2116_i0	PRJNA1082072	2123	251	0.865169	2.17157419	Apis cerana	7461	Arthropoda	Arthropoda	54.7	0.006	NTclustered	gi\|2644540352\|ref\|XM_062077260.1\|	7461	g2116	i0	100	0.685258964143426	29	0	12	0	168	196	3722	3750	PREDICTED: Apis cerana rho-associated protein kinase 1 (LOC107999428), transcript variant X2, mRNA	blastn	172	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Apis	Apis cerana
3567846	3567846	PRJNA1082072_P_NODE_2963_length_241_cov_0.916667_g2956_i0	PRJNA1082072	2963	241	0.916667	2.20916747	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	4.66e-4	NTclustered	gi\|1928099498\|ref\|XM_037182450.1\|	38358	g2956	i0	100	0.385892116182573	31	0	13	0	194	224	833	803	PREDICTED: Bradysia coprophila facilitated trehalose transporter Tret1 (LOC119075876), transcript variant X2, mRNA	blastn	93	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia coprophila
6120336	6120336	PRJNA1082072_P_NODE_305_length_547_cov_0.974684_g298_i0	PRJNA1082072	305	547	0.974684	5.33152148	Opisthokonta	33154	Placozoa	other_Eukaryota	388	3.61e-103	NTclustered	gi\|196015192\|ref\|XM_002117418.1\|	10228	g298	i0	81.876	88.5319926873857	469	78	85	6	5	470	1080	616	Trichoplax adhaerens uncharacterized protein (TRIADDRAFT_32492), partial mRNA	blastn	48427	388	1	Eukaryota	Opisthokonta	Metazoa	Placozoa	Uniplacotomia	Trichoplacea	Trichoplacidae	Trichoplax	Trichoplax adhaerens
9120802	9120802	PRJNA1082072_P_NODE_2268_length_249_cov_0.875000_g2261_i0	PRJNA1082072	2268	249	0.875	2.17875	Apteryx mantelli	2696672	Chordata	Chordata	52.8	0.023	NTclustered	gi\|840008844\|emb\|LK064627.1\|	202946	g2261	i0	100	0.112449799196787	28	0	11	0	127	154	1730660	1730633	Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold25	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apterygiformes	Apterygidae	Apteryx	Apteryx mantelli
10396504	10396504	PRJNA1082072_P_NODE_949_length_346_cov_1.322344_g942_i0	PRJNA1082072	949	346	1.322344	4.57531024	Contarinia nasturtii	265458	Arthropoda	Arthropoda	268	2.99e-67	NTclustered	gi\|1779648040\|ref\|XM_031774719.1\|	265458	g942	i0	82.109	8.91040462427746	313	56	90	0	26	338	222	534	PREDICTED: Contarinia nasturtii 40S ribosomal protein S23 (LOC116345403), mRNA	blastn	3083	268	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Cecidomyiidae	Contarinia	Contarinia nasturtii
11220600	11220600	PRJNA1082072_P_NODE_2169_length_250_cov_0.870056_g2162_i0	PRJNA1082072	2169	250	0.870056	2.17514	Aves	8782	Chordata	Chordata	124	4.729999999999999e-24	NTclustered	gi\|2583782972\|ref\|XM_059826112.1\|	37040	g2162	i0	77.273	42.612	220	44	87	5	34	250	175	391	PREDICTED: Gavia stellata ribosomal protein L27a (RPL27A), mRNA	blastn	10653	124	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Gaviiformes	Gaviidae	Gavia	Gavia stellata
12946918	12946918	PRJNA1082072_P_NODE_371_length_494_cov_1.323040_g364_i0	PRJNA1082072	371	494	1.32304	6.5358176	Tetranychus urticae	32264	Arthropoda	Arthropoda	298	5.61e-76	NTclustered	gi\|1390650316\|ref\|XM_015931159.2\|	32264	g364	i0	78.714	52.5728744939271	451	92	91	4	1	449	1345	1793	PREDICTED: Tetranychus urticae heat shock cognate 71 kDa protein (LOC107363888), mRNA	blastn	25971	298	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
14221926	14221926	PRJNA1082072_P_NODE_192_length_663_cov_2.977966_g185_i0	PRJNA1082072	192	663	2.977966	19.74391458	Oppiella nova	334625	Arthropoda	Arthropoda	54.7	0.018	NTclustered	gi\|1962580772\|emb\|OC914909.1\|	334625	g185	i0	100	0.0437405731523379	29	0	4	0	602	630	7612	7584	Oppiella nova	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
16770153	16770153	PRJNA1082072_P_NODE_2774_length_243_cov_0.905882_g2767_i0	PRJNA1082072	2774	243	0.905882	2.20129326	Limulus polyphemus	6850	Arthropoda	Arthropoda	52.8	0.022	NTclustered	gi\|1238878208\|ref\|XM_013928808.2\|	6850	g2767	i0	100	0.11522633744856	28	0	12	0	55	82	1779	1806	PREDICTED: Limulus polyphemus palmitoyltransferase ZDHHC23-like (LOC106468386), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Merostomata	Xiphosura	Limulidae	Limulus	Limulus polyphemus
18044924	18044924	PRJNA1082072_P_NODE_1115_length_327_cov_1.161417_g1108_i0	PRJNA1082072	1115	327	1.161417	3.79783359	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	137	8.25e-28	NTclustered	gi\|150984457\|gb\|EF634871.1\|	452809	g1108	i0	81.395	16.0366972477064	172	28	52	3	2	171	160	329	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	5244	137	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
19318916	19318916	PRJNA1082072_P_NODE_1216_length_314_cov_1.257261_g1209_i0	PRJNA1082072	1216	314	1.257261	3.94779954	Diceros bicornis	9805	Chordata	Chordata	161	4.68e-35	NTclustered	gi\|2555101640\|ref\|XM_058537544.1\|	77932	g1209	i0	79.098	51.3343949044586	244	43	76	7	48	287	101	340	PREDICTED: Diceros bicornis minor eukaryotic translation elongation factor 2 (EEF2), mRNA	blastn	16119	161	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Perissodactyla	Rhinocerotidae	Diceros	Diceros bicornis
21419204	21419204	PRJNA1082072_P_NODE_1557_length_282_cov_1.842105_g1550_i0	PRJNA1082072	1557	282	1.842105	5.1947361	Artiodactyla	91561	Chordata	Chordata	54.7	0.007	NTclustered	gi\|2782113514\|ref\|XM_059043140.2\|	27615	g1550	i0	100	0.50354609929078	29	0	10	0	128	156	194	222	PREDICTED: Kogia breviceps collagen triple helix repeat containing 1 (CTHRC1), mRNA	blastn	142	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Physeteridae	Kogia	Kogia breviceps
21419205	21419205	PRJNA1082072_P_NODE_1777_length_271_cov_1.146465_g1770_i0	PRJNA1082072	1777	271	1.146465	3.10692015	Metazoa	33208	Nematoda	Nematoda	243	1.37e-59	NTclustered	gi\|1376147859\|ref\|XM_024654603.1\|	34506	g1770	i0	83.459	159.575645756458	266	38	98	5	3	265	175	437	Strongyloides ratti Polyubiquitin-C (SRAE_2000341300), partial mRNA	blastn	43245	243	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
23145362	23145362	PRJNA1082072_P_NODE_2139_length_251_cov_0.865169_g2132_i0	PRJNA1082072	2139	251	0.865169	2.17157419	Malaya genurostris	325434	Arthropoda	Arthropoda	60.2	1.36e-4	NTclustered	gi\|2557305120\|ref\|XM_058599925.1\|	325434	g2132	i0	97.222	0.143426294820717	36	0	14	1	1	35	110	145	PREDICTED: Malaya genurostris dentin sialophosphoprotein-like (LOC131433109), partial mRNA	blastn	36	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Malaya	Malaya genurostris

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