metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA767802" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA767802" 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
4573424	4573424	PRJNA767802_P_NODE_11604_length_206_cov_1.324841_g11531_i0	PRJNA767802	11604	206	1.324841	2.72917246	Nilaparvata lugens	108931	Arthropoda	Arthropoda	163	7.97e-36	NTclustered	gi\|1096257334\|gb\|KU932306.1\|	108931	g11531	i0	81.373	65.3349514563107	204	34	98	4	4	205	155	356	Nilaparvata lugens isolate NlSFP_unconfirmed_comp29590 seminal fluid protein mRNA, complete cds	blastn	13459	163	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Delphacidae	Nilaparvata	Nilaparvata lugens
4573447	4573447	PRJNA767802_P_NODE_14484_length_178_cov_1.565891_g14411_i0	PRJNA767802	14484	178	1.565891	2.78728598	Blomia tropicalis	40697	Arthropoda	Arthropoda	329	6.21e-86	NTclustered	gi\|2100350414\|gb\|MT782118.1\|	40697	g14411	i0	100	98.9887640449438	178	0	100	0	1	178	4263	4440	Blomia tropicalis external transcribed spacer, partial sequence; and 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	17620	329	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Echimyopodidae	Blomia	Blomia tropicalis
5848745	5848745	PRJNA767802_P_NODE_3645_length_455_cov_5.209360_g3572_i0	PRJNA767802	3645	455	5.20936	23.702588	Blomia tropicalis	40697	Arthropoda	Arthropoda	787	0	NTclustered	gi\|37958154\|gb\|AY283287.1\|	40697	g3572	i0	99.31	0.956043956043956	435	3	96	0	21	455	417	851	Blomia tropicalis isolate BT1313 Blo t 13 allergen mRNA, complete cds	blastn	435	787	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Echimyopodidae	Blomia	Blomia tropicalis
12224868	12224868	PRJNA767802_P_NODE_2830_length_533_cov_52.033058_g2762_i0	PRJNA767802	2830	533	52.033058	277.33619914	Aedes aegypti	7159	Arthropoda	Arthropoda	896	0	NTclustered	gi\|42740775\|gb\|AY432810.1\|	7159	g2762	i0	99.198	605.401500938086	499	0	93	1	19	513	502	4	Aedes aegypti ASAP ID: 38495 conserved unknown mRNA sequence	blastn	322679	896	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Aedes	Aedes aegypti
12224882	12224882	PRJNA767802_P_NODE_6950_length_294_cov_2.142857_g6877_i0	PRJNA767802	6950	294	2.142857	6.29999958	Aphis gossypii	80765	Arthropoda	Arthropoda	538	1.7199999999999995e-148	NTclustered	gi\|2288483578\|ref\|XM_050201367.1\|	80765	g6877	i0	99.66	17.2210884353741	294	1	100	0	1	294	5408	5115	PREDICTED: Aphis gossypii protein Shroom (LOC114124360), transcript variant X5, mRNA	blastn	5063	538	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Aphis	Aphis gossypii
12224891	12224891	PRJNA767802_P_NODE_8530_length_254_cov_2.624390_g8457_i0	PRJNA767802	8530	254	2.62439	6.6659506	Pyemotes zhonghuajia	2749944	Arthropoda	Arthropoda	126	1.3399999999999999e-24	NTclustered	gi\|2260370515\|gb\|OM396909.2\|	2749944	g8457	i0	77.586	3.89763779527559	232	36	89	13	1	225	944	722	Pyemotes zhonghuajia chromosome A mitochondrion, complete sequence	blastn	990	126	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Pyemotidae	Pyemotes	Pyemotes zhonghuajia
13498947	13498947	PRJNA767802_P_NODE_2731_length_545_cov_2.193548_g2663_i0	PRJNA767802	2731	545	2.193548	11.9548366	Timema monikensis	170555	Arthropoda	Arthropoda	58.4	0.001	NTclustered	gi\|1946411097\|emb\|OB793204.1\|	170555	g2663	i0	97.059	0.170642201834862	34	1	6	0	206	239	168510	168543	3_Tms_b3v08	blastn	93	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema monikensis
13498950	13498950	PRJNA767802_P_NODE_3131_length_504_cov_6.156044_g3060_i0	PRJNA767802	3131	504	6.156044	31.02646176	Belonocnema kinseyi	2817044	Arthropoda	Arthropoda	339	3.3799999999999997e-88	NTclustered	gi\|1830566556\|ref\|XM_033358840.1\|	2817044	g3060	i0	83.696	59.8412698412698	368	50	72	9	121	484	473	112	PREDICTED: Belonocnema kinseyi histone H2A-like (LOC117171481), mRNA	blastn	30160	339	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Cynipidae	Belonocnema	Belonocnema kinseyi
16047812	16047812	PRJNA767802_P_NODE_7953_length_267_cov_1.908257_g7880_i0	PRJNA767802	7953	267	1.908257	5.09504619	Dermatophagoides farinae	6954	Arthropoda	Arthropoda	137	6.56e-28	NTclustered	gi\|2205499408\|ref\|XM_047061673.1\|	6954	g7880	i0	83.007	1.14606741573034	153	24	57	2	88	239	262	413	PREDICTED: Dermatophagoides farinae histone H1-like (LOC124497980), mRNA	blastn	306	137	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides farinae
18596853	18596853	PRJNA767802_P_NODE_1435_length_765_cov_8.625698_g1383_i0	PRJNA767802	1435	765	8.625698	65.9865897	Blomia tropicalis	40697	Arthropoda	Arthropoda	1216	0	NTclustered	gi\|37958168\|gb\|AY283294.1\|	40697	g1383	i0	99.258	1.39869281045752	674	4	88	1	93	765	13	686	Blomia tropicalis isolate BT1694 Blo t 13 allergen mRNA, complete cds	blastn	1070	1216	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Echimyopodidae	Blomia	Blomia tropicalis
18596939	18596939	PRJNA767802_P_NODE_6215_length_317_cov_3.373134_g6142_i0	PRJNA767802	6215	317	3.373134	10.69283478	Timema cristinae	61476	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|1946981874\|emb\|OC318503.1\|	61476	g6142	i0	100	0.0946372239747634	30	0	9	0	266	295	34237	34208	3_Tce_b3v08	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema cristinae
19871994	19871994	PRJNA767802_P_NODE_256_length_1546_cov_5.671343_g240_i0	PRJNA767802	256	1546	5.671343	87.67896278	Blomia tropicalis	40697	Arthropoda	Arthropoda	2449	0	NTclustered	gi\|2429084570\|gb\|OQ285976.1\|	40697	g240	i0	99.335	85.264553686934	1353	9	88	0	121	1473	1	1353	Blomia tropicalis clone Blo_t_33.0101_BT_003250.01 allergen mRNA, complete cds	blastn	131819	2449	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Echimyopodidae	Blomia	Blomia tropicalis
19872035	19872035	PRJNA767802_P_NODE_9776_length_230_cov_2.994475_g9703_i0	PRJNA767802	9776	230	2.994475	6.8872925	Culex pipiens	7175	Arthropoda	Arthropoda	403	4.92e-108	NTclustered	gi\|2415559374\|ref\|XM_039590366.2\|	42434	g9703	i0	99.548	3.88695652173913	221	1	96	0	1	221	1762	1542	PREDICTED: Culex pipiens pallens proteoglycan 4-like (LOC120425753), transcript variant X5, mRNA	blastn	894	403	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex pipiens
22422419	22422419	PRJNA767802_P_NODE_12858_length_193_cov_1.416667_g12785_i0	PRJNA767802	12858	193	1.416667	2.73416731	Macdunnoughia confusa	254380	Arthropoda	Arthropoda	52.8	0.017	NTclustered	gi\|2917930536\|emb\|OZ234942.1\|	254380	g12785	i0	100	0.145077720207254	28	0	15	0	61	88	12172516	12172489	Macdunnoughia confusa genome assembly, chromosome: 16	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Macdunnoughia	Macdunnoughia confusa
22883794	22883794	PRJNA767802_P_NODE_2778_length_539_cov_5.424490_g2710_i0	PRJNA767802	2778	539	5.42449	29.2380011	Dytiscidae	50515	Arthropoda	Arthropoda	375	2.7699999999999995e-99	NTclustered	gi\|2820554847\|gb\|PQ123450.1\|	196316	g2710	i0	88.424	63.7680890538033	311	36	58	0	90	400	1	311	Allodessus bistrigatus isolate MB8802 histone 4 gene, partial cds	blastn	34371	375	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Dytiscidae	Allodessus	Allodessus bistrigatus
23698061	23698061	PRJNA767802_P_NODE_10379_length_221_cov_2.372093_g10306_i0	PRJNA767802	10379	221	2.372093	5.24232553	Cydia fagiglandana	1458189	Arthropoda	Arthropoda	113	8.860000000000001e-21	NTclustered	gi\|2689793245\|ref\|XM_063529702.1\|	1458189	g10306	i0	87.755	36.5882352941176	98	10	44	2	1	97	547	643	PREDICTED: Cydia fagiglandana peptidyl-prolyl cis-trans isomerase 6 (LOC134671850), mRNA	blastn	8086	113	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Cydia	Cydia fagiglandana
23698170	23698170	PRJNA767802_P_NODE_7039_length_291_cov_2.318182_g6966_i0	PRJNA767802	7039	291	2.318182	6.74590962	Satyrium ilicis	876074	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2918386103\|emb\|OZ238124.1\|	876074	g6966	i0	96.97	1.07560137457045	33	1	11	0	158	190	27495866	27495834	Satyrium ilicis genome assembly, chromosome: 15	blastn	313	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Satyrium	Satyrium ilicis

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