metadata: contig_metadata: 14 rows where bioproject = "PRJNA547066" and tax

14 rows where bioproject = "PRJNA547066" 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
3062487	3062487	PRJNA547066_P_NODE_5163_length_169_cov_1.216418_g5069_i0	PRJNA547066	5163	169	1.216418	2.05574642	Demodex brevis	574145	Arthropoda	Arthropoda	313	5.859999999999999e-81	NTclustered	gi\|360047411\|gb\|HQ718592.1\|	574145	g5069	i0	100	9.02958579881657	169	0	100	0	1	169	5197	5029	Demodex brevis isolate Db2 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	1526	313	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex brevis
5615380	5615380	PRJNA547066_P_NODE_2565_length_293_cov_1.147287_g2471_i0	PRJNA547066	2565	293	1.147287	3.36155091	Timema douglasi	61478	Arthropoda	Arthropoda	497	2.9e-136	NTclustered	gi\|1936766486\|emb\|OA594500.1\|	61478	g2471	i0	97.27	1	293	8	100	0	1	293	1850	1558	1_Tdi_b3v08	blastn	293	497	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema douglasi
5615391	5615391	PRJNA547066_P_NODE_4145_length_199_cov_1.219512_g4051_i0	PRJNA547066	4145	199	1.219512	2.42682888	Demodex brevis	574145	Arthropoda	Arthropoda	357	3.2699999999999996e-94	NTclustered	gi\|719240701\|gb\|KM114225.1\|	574145	g4051	i0	98.995	32.0854271356784	199	2	100	0	1	199	10461	10659	Demodex brevis mitochondrion, complete genome	blastn	6385	357	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex brevis
8164399	8164399	PRJNA547066_P_NODE_3547_length_227_cov_1.041667_g3453_i0	PRJNA547066	3547	227	1.041667	2.36458409	Dermatophagoides farinae	6954	Arthropoda	Arthropoda	420	4.81e-113	NTclustered	gi\|256985336\|ref\|NC_013184.1\|	6954	g3453	i0	100	25.0352422907489	227	0	100	0	1	227	6554	6328	Dermatophagoides farinae mitochondrion, complete genome	blastn	5683	420	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides farinae
9439920	9439920	PRJNA547066_P_NODE_2268_length_321_cov_2.069930_g2174_i0	PRJNA547066	2268	321	2.06993	6.6444753	Demodex brevis	574145	Arthropoda	Arthropoda	444	4.2499999999999996e-120	NTclustered	gi\|1735120170\|gb\|MH540325.1\|	574145	g2174	i0	99.588	36.3769470404984	243	1	76	0	1	243	243	1	Demodex brevis isolate D3-1 28S ribosomal RNA gene, partial sequence	blastn	11677	444	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex brevis
10715705	10715705	PRJNA547066_P_NODE_409_length_748_cov_6.539972_g349_i0	PRJNA547066	409	748	6.539972	48.91899056	Demodex brevis	574145	Arthropoda	Arthropoda	1349	0	NTclustered	gi\|719240701\|gb\|KM114225.1\|	574145	g349	i0	99.198	34.9933155080214	748	6	100	0	1	748	11681	12428	Demodex brevis mitochondrion, complete genome	blastn	26175	1349	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex brevis
23463863	23463863	PRJNA547066_P_NODE_979_length_502_cov_3.167024_g891_i0	PRJNA547066	979	502	3.167024	15.89846048	Timema californicum	61474	Arthropoda	Arthropoda	56.5	0.004	NTclustered	gi\|1965181363\|emb\|OE475415.1\|	61474	g891	i0	90.909	0.0876494023904383	44	1	8	2	192	232	309	266	2_Tcm_b3v08	blastn	44	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
24737597	24737597	PRJNA547066_P_NODE_540_length_664_cov_2.912560_g469_i0	PRJNA547066	540	664	2.91256	19.3393984	Drosophila willistoni	7260	Arthropoda	Arthropoda	69.4	6.57e-7	NTclustered	gi\|2203530715\|ref\|XM_023179400.2\|	7260	g469	i0	100	3.71084337349398	37	0	6	0	591	627	3553	3589	PREDICTED: Drosophila willistoni histone acetyltransferase p300 (LOC6649171), mRNA	blastn	2464	69.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila willistoni
27014576	27014576	PRJNA547066_P_NODE_4502_length_186_cov_1.059603_g4408_i0	PRJNA547066	4502	186	1.059603	1.97086158	Dinothrombium tinctorium	1965070	Arthropoda	Arthropoda	61.6	3.75e-9	NR	RWS13046.1	1965070	g4408	i0	65.1	0.693548387096774	43	15	69.4	0	54	182	47	89	RWS13046.1 zinc finger protein 1-like protein [Dinothrombium tinctorium]	diamond	129	61.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombidiidae	Dinothrombium	Dinothrombium tinctorium
27867462	27867462	PRJNA547066_P_NODE_5225_length_168_cov_0.879699_g5131_i0	PRJNA547066	5225	168	0.879699	1.47789432	Tetranychus urticae	32264	Arthropoda	Arthropoda	58.5	1.92e-8	NR	XP_025016543.1	32264	g5131	i0	58.9	2	56	22	100	1	1	168	15	69	XP_025016543.1 glucose-induced degradation protein 8 homolog [Tetranychus urticae]	diamond	336	58.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
29193910	29193910	PRJNA547066_P_NODE_4829_length_177_cov_1.105634_g4735_i0	PRJNA547066	4829	177	1.105634	1.95697218	Dinothrombium tinctorium	1965070	Arthropoda	Arthropoda	43.1	0.0113	NR	RWS10004.1	1965070	g4735	i0	50	0.813559322033898	48	20	74.6	1	140	9	500	547	RWS10004.1 hypothetical protein B4U79_08603 [Dinothrombium tinctorium]	diamond	144	43.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombidiidae	Dinothrombium	Dinothrombium tinctorium
30440458	30440458	PRJNA547066_P_NODE_3453_length_231_cov_2.239796_g3359_i0	PRJNA547066	3453	231	2.239796	5.17392876	Arachnida	6854	Arthropoda	Arthropoda	112	1.27e-26	NR	KAJ6222096.1	40697	g3359	i0	64.5	4.64935064935065	76	26	98.7	1	2	229	103	177	KAJ6222096.1 hypothetical protein RDWZM_000641 [Blomia tropicalis]	diamond	1074	112	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Echimyopodidae	Blomia	Blomia tropicalis
32084253	32084253	PRJNA547066_P_NODE_4778_length_178_cov_1.552448_g4684_i0	PRJNA547066	4778	178	1.552448	2.76335744	Metazoa	33208	Arthropoda	Arthropoda	41.6	0.0276	NR	XP_064486094.1	34597	g4684	i0	48	5.20786516853933	50	23	84.3	1	164	15	115	161	XP_064486094.1 alpha-crystallin A chain-like [Ornithodoros turicata]	diamond	927	42	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Argasidae	Ornithodoros	Ornithodoros turicata
32858984	32858984	PRJNA547066_P_NODE_3940_length_208_cov_1.086705_g3846_i0	PRJNA547066	3940	208	1.086705	2.2603464	Tetranychus urticae	32264	Arthropoda	Arthropoda	120	7.449999999999998e-30	NR	XP_015787051.1	32264	g3846	i0	79.4	0.980769230769231	68	14	98.1	0	4	207	68	135	XP_015787051.1 alpha-protein kinase 1 [Tetranychus urticae]	diamond	204	120	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae

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