metadata: contig_metadata: 16 rows where bioproject = "PRJNA399133", tax_clade = "Opisthokonta" and tax

16 rows where bioproject = "PRJNA399133", tax_clade = "Opisthokonta" 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
4240396	4240396	PRJNA399133_P_NODE_6344_length_209_cov_1.109195_g6256_i0	PRJNA399133	6344	209	1.109195	2.31821755	Macrobrachium nipponense	159736	Arthropoda	Arthropoda	54.7	0.005	NTclustered	gi\|2708658989\|ref\|XM_064251657.1\|	159736	g6256	i0	100	0.272727272727273	29	0	14	0	19	47	2303	2275	PREDICTED: Macrobrachium nipponense protein kintoun-like (LOC135216386), mRNA	blastn	57	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Macrobrachium	Macrobrachium nipponense
5517063	5517063	PRJNA399133_P_NODE_7625_length_190_cov_1.548387_g7537_i0	PRJNA399133	7625	190	1.548387	2.9419353	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	95.3	2.67e-15	NTclustered	gi\|78097480\|gb\|AC167666.4\|	7176	g7537	i0	91.304	0.763157894736842	69	6	36	0	122	190	12799	12867	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence	blastn	145	95.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
5517065	5517065	PRJNA399133_P_NODE_765_length_599_cov_3.407801_g690_i0	PRJNA399133	765	599	3.407801	20.41272799	Timema monikensis	170555	Arthropoda	Arthropoda	58.4	0.001	NTclustered	gi\|1946411097\|emb\|OB793204.1\|	170555	g690	i0	97.059	0.155258764607679	34	1	6	0	307	340	168543	168510	3_Tms_b3v08	blastn	93	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema monikensis
10617046	10617046	PRJNA399133_P_NODE_10069_length_166_cov_1.129771_g9981_i0	PRJNA399133	10069	166	1.129771	1.87541986	Ochlerotatus camptorhynchus	644619	Arthropoda	Arthropoda	113	6.290000000000001e-21	NTclustered	gi\|2730521630\|ref\|XM_065237886.1\|	644619	g9981	i0	90.588	18.4457831325301	85	8	51	0	3	87	351	435	PREDICTED: Ochlerotatus camptorhynchus ribosomal protein L12 (RpL12), mRNA	blastn	3062	113	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Ochlerotatus	Ochlerotatus camptorhynchus
10617269	10617269	PRJNA399133_P_NODE_9829_length_168_cov_1.443609_g9741_i0	PRJNA399133	9829	168	1.443609	2.42526312	Tarsonemidae gen. sp. AD1063	2051817	Arthropoda	Arthropoda	228	2.179999999999999e-55	NTclustered	gi\|1282188753\|gb\|KY922163.1\|	2051817	g9741	i0	91.124	33.7440476190476	169	14	100	1	1	168	276	108	Tarsonemidae gen. sp. AD1063 voucher UMMZ BMOC 07-0502-001 AD1063 18S ribosomal RNA gene, partial sequence	blastn	5669	228	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tarsonemidae		Tarsonemidae gen. sp. AD1063
12559573	12559573	PRJNA399133_P_NODE_7070_length_197_cov_2.086420_g6982_i0	PRJNA399133	7070	197	2.08642	4.1102474	Demodex	188544	Arthropoda	Arthropoda	224	3.419999999999999e-54	NTclustered	gi\|443299081\|gb\|KC010485.1\|	188545	g6982	i0	100	83.0406091370558	121	0	100	0	77	197	864	744	Demodex canis 18S ribosomal RNA gene, partial sequence	blastn	16359	224	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex canis
14442127	14442127	PRJNA399133_P_NODE_11992_length_153_cov_1.330508_g11904_i0	PRJNA399133	11992	153	1.330508	2.03567724	Cyprideis torosa	163714	Arthropoda	Arthropoda	104	3.41e-18	NTclustered	gi\|1937147980\|emb\|OB680495.1\|	163714	g11904	i0	85.149	0.660130718954248	101	15	66	0	5	105	1401	1501	Cyprideis torosa	blastn	101	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cytherideidae	Cyprideis	Cyprideis torosa
18264788	18264788	PRJNA399133_P_NODE_1015_length_505_cov_2.429787_g937_i0	PRJNA399133	1015	505	2.429787	12.27042435	Cyprideis torosa	163714	Arthropoda	Arthropoda	139	3.68e-28	NTclustered	gi\|1937151424\|emb\|OB705531.1\|	163714	g937	i0	80	0.396039603960396	200	31	38	8	1	194	248	52	Cyprideis torosa	blastn	200	139	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cytherideidae	Cyprideis	Cyprideis torosa
18264922	18264922	PRJNA399133_P_NODE_6015_length_215_cov_1.183333_g5927_i0	PRJNA399133	6015	215	1.183333	2.54416595	Demodex folliculorum	481310	Arthropoda	Arthropoda	387	4.57e-103	NTclustered	gi\|746000042\|ref\|NC_026102.1\|	481310	g5927	i0	99.07	1	215	2	100	0	1	215	6131	6345	Demodex folliculorum mitochondrion, complete genome	blastn	215	387	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex folliculorum
19539002	19539002	PRJNA399133_P_NODE_11676_length_155_cov_1.125000_g11588_i0	PRJNA399133	11676	155	1.125	1.74375	Panonychus citri	50023	Arthropoda	Arthropoda	178	2.02e-40	NTclustered	gi\|2437594881\|ref\|XM_053348552.1\|	50023	g11588	i0	88.158	84.8709677419355	152	15	97	3	3	152	1185	1335	PREDICTED: Panonychus citri actin, clone 403 (LOC128389044), mRNA	blastn	13155	178	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Panonychus	Panonychus citri
22089755	22089755	PRJNA399133_P_NODE_5598_length_224_cov_1.343915_g5510_i0	PRJNA399133	5598	224	1.343915	3.0103696	Papilio polytes	76194	Arthropoda	Arthropoda	364	2.2499999999999993e-96	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g5510	i0	96.364	0.982142857142857	220	7	98	1	6	224	779	560	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	220	364	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
22757796	22757796	PRJNA399133_P_NODE_3658_length_263_cov_9.114035_g3570_i0	PRJNA399133	3658	263	9.114035	23.96991205	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	254	6.13e-63	NTclustered	gi\|2866482757\|ref\|XM_070214723.1\|	29030	g3570	i0	84.291	251.019011406844	261	39	99	2	4	263	1805	1546	PREDICTED: Drosophila takahashii Polyubiquitin-63E (Ubi-p63E), transcript variant X3, mRNA	blastn	66018	255	0.996078431372549	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila takahashii
24639670	24639670	PRJNA399133_P_NODE_500_length_753_cov_3.376045_g437_i0	PRJNA399133	500	753	3.376045	25.42161885	Cyprideis torosa	163714	Arthropoda	Arthropoda	551	6.109999999999998e-152	NTclustered	gi\|1936765087\|emb\|OB662863.1\|	163714	g437	i0	80.694	4.8871181938911	720	129	95	9	38	752	19450	18736	Cyprideis torosa	blastn	3680	551	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cytherideidae	Cyprideis	Cyprideis torosa
24639693	24639693	PRJNA399133_P_NODE_6600_length_204_cov_2.183432_g6512_i0	PRJNA399133	6600	204	2.183432	4.45420128	Acyrthosiphon pisum	7029	Arthropoda	Arthropoda	320	4.42e-83	NTclustered	gi\|886117\|gb\|U27819.1\|APU27819	7029	g6512	i0	95.074	99	203	10	99	0	2	204	1231	1433	Acyrthosiphon pisum 18S ribosomal RNA gene	blastn	20196	320	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
29096587	29096587	PRJNA399133_P_NODE_9608_length_170_cov_1.185185_g9520_i0	PRJNA399133	9608	170	1.185185	2.0148145	Leptotrombidium deliense	299467	Arthropoda	Arthropoda	69.7	1.31e-12	NR	RWS23085.1	299467	g9520	i0	60.4	0.847058823529412	48	18	84.7	1	150	7	22	68	RWS23085.1 hypothetical protein B4U80_13961 [Leptotrombidium deliense]	diamond	144	69.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
31434168	31434168	PRJNA399133_P_NODE_8696_length_178_cov_1.398601_g8608_i0	PRJNA399133	8696	178	1.398601	2.48950978	Araneus ventricosus	182803	Arthropoda	Arthropoda	51.2	1.62e-5	NR	GBN61280.1	182803	g8608	i0	56.8	5.6123595505618	44	19	74.2	0	2	133	1145	1188	GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus]	diamond	999	51.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Araneus	Araneus ventricosus

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