metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1242190" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1242190" 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
350696	350696	PRJNA1242190_S_NODE_10601_length_266_cov_1.093264_g10594_i0	PRJNA1242190	10601	266	1.093264	2.90808224	Orthetrum poecilops	1168658	Arthropoda	Arthropoda	71.3	6.72e-8	NTclustered	gi\|2709255482\|dbj\|LC757448.1\|	1168658	g10594	i0	100	16.3383458646617	38	0	14	0	27	64	14870	14833	Orthetrum poecilops RFr0884 mitochondrial DNA, nearly complete genome	blastn	4346	71.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Odonata	Libellulidae	Orthetrum	Orthetrum poecilops
1625597	1625597	PRJNA1242190_S_NODE_3162_length_438_cov_3.542466_g3155_i0	PRJNA1242190	3162	438	3.542466	15.51600108	Condylostylus longicornis	2530218	Arthropoda	Arthropoda	233	1.4099999999999998e-56	NTclustered	gi\|2496082430\|ref\|XM_055523037.1\|	2530218	g3155	i0	81.533	5.51826484018265	287	49	65	2	154	438	863	579	PREDICTED: Condylostylus longicornis heat shock protein 83 (LOC129610445), mRNA	blastn	2417	233	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Dolichopodidae	Condylostylus	Condylostylus longicornis
12529581	12529581	PRJNA1242190_S_NODE_10430_length_268_cov_0.994872_g10423_i0	PRJNA1242190	10430	268	0.994872	2.66625696	Timema	61471	Arthropoda	Arthropoda	54.7	0.007	NTclustered	gi\|1947018316\|emb\|OC319311.1\|	61476	g10423	i0	100	0.21641791044776101	29	0	11	0	239	267	53616	53644	3_Tce_b3v08	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema cristinae
13104812	13104812	PRJNA1242190_S_NODE_5871_length_342_cov_4.152416_g5864_i0	PRJNA1242190	5871	342	4.152416	14.20126272	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	54.7	0.009	NTclustered	gi\|1963617327\|emb\|OC873114.1\|	1979941	g5864	i0	100	0.0847953216374269	29	0	8	0	69	97	1638	1610	Medioppia subpectinata	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
16928119	16928119	PRJNA1242190_S_NODE_4514_length_382_cov_1.967638_g4507_i0	PRJNA1242190	4514	382	1.967638	7.51637716	Papilio polytes	76194	Arthropoda	Arthropoda	682	0	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g4507	i0	99.202	4.98167539267016	376	3	98	0	1	376	428	803	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	1903	682	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
18902637	18902637	PRJNA1242190_S_NODE_7335_length_313_cov_1.700000_g7328_i0	PRJNA1242190	7335	313	1.7	5.321	Drosophila	7215	Arthropoda	Arthropoda	80.5	1.34e-10	NTclustered	gi\|2119965241\|ref\|XM_001959683.4\|	7217	g7328	i0	100	5.40894568690096	43	0	14	0	271	313	582	540	PREDICTED: Drosophila ananassae 40S ribosomal protein S16 (LOC6494764), mRNA	blastn	1693	80.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila ananassae
22027581	22027581	PRJNA1242190_S_NODE_11038_length_260_cov_3.149733_g11031_i0	PRJNA1242190	11038	260	3.149733	8.1893058	Longitarsus dorsalis	346795	Arthropoda	Arthropoda	52.8	0.024	NTclustered	gi\|2918386046\|emb\|OZ238108.1\|	346795	g11031	i0	100	0.107692307692308	28	0	11	0	56	83	7820377	7820350	Longitarsus dorsalis genome assembly, chromosome: X	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Longitarsus	Longitarsus dorsalis
22027646	22027646	PRJNA1242190_S_NODE_3458_length_424_cov_13.529915_g3451_i0	PRJNA1242190	3458	424	13.529915	57.3668396	Timema monikensis	170555	Arthropoda	Arthropoda	58.4	8.78e-4	NTclustered	gi\|1946411097\|emb\|OB793204.1\|	170555	g3451	i0	97.059	0.212264150943396	34	1	8	0	52	85	168510	168543	3_Tms_b3v08	blastn	90	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema monikensis
22027704	22027704	PRJNA1242190_S_NODE_8658_length_291_cov_2.059633_g8651_i0	PRJNA1242190	8658	291	2.059633	5.99353203	Hermetia illucens	343691	Arthropoda	Arthropoda	65.8	3.46e-6	NTclustered	gi\|1941210850\|ref\|XM_038065130.1\|	343691	g8651	i0	93.182	0.450171821305842	44	3	15	0	3	46	454	497	PREDICTED: Hermetia illucens 60S ribosomal protein L23 (LOC119657937), mRNA	blastn	131	65.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Stratiomyidae	Hermetia	Hermetia illucens

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