metadata: contig_metadata: 18 rows where bioproject = "PRJNA415636" and tax

18 rows where bioproject = "PRJNA415636" 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
419116	419116	PRJNA415636_S_NODE_6761_length_198_cov_2.384106_g6714_i0	PRJNA415636	6761	198	2.384106	4.72052988	Chlorops oryzae	1046848	Arthropoda	Arthropoda	176	9.76e-40	NTclustered	gi\|1678416163\|gb\|MK225558.1\|	1046848	g6714	i0	83.246	87.8030303030303	191	32	96	0	1	191	450	260	Chlorops oryzae actin mRNA, partial cds	blastn	17385	176	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chloropidae	Chlorops	Chlorops oryzae
2969828	2969828	PRJNA415636_S_NODE_903_length_420_cov_15.517426_g856_i0	PRJNA415636	903	420	15.517426	65.1731892	Timema californicum	61474	Arthropoda	Arthropoda	56.5	0.003	NTclustered	gi\|1965181363\|emb\|OE475415.1\|	61474	g856	i0	90.909	0.104761904761905	44	1	10	2	60	100	309	266	2_Tcm_b3v08	blastn	44	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
5522886	5522886	PRJNA415636_S_NODE_3745_length_255_cov_1.711538_g3698_i0	PRJNA415636	3745	255	1.711538	4.3644219	Chelidurella thaleri	2546182	Arthropoda	Arthropoda	54.7	0.006	NTclustered	gi\|2919608728\|emb\|OZ238409.1\|	2546182	g3698	i0	100	0.333333333333333	29	0	11	0	217	245	17092230	17092202	Chelidura thaleri genome assembly, chromosome: 10	blastn	85	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Dermaptera	Forficulidae	Chelidurella	Chelidurella thaleri
5522890	5522890	PRJNA415636_S_NODE_4665_length_234_cov_2.449198_g4618_i0	PRJNA415636	4665	234	2.449198	5.73112332	Rhagoletis zephyria	28612	Arthropoda	Arthropoda	150	7.22e-32	NTclustered	gi\|1048065036\|ref\|XM_017608015.1\|	28612	g4618	i0	88.618	2.85042735042735	123	14	53	0	112	234	428	306	PREDICTED: Rhagoletis zephyria 60S ribosomal protein L11 (LOC108356914), mRNA	blastn	667	150	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Rhagoletis	Rhagoletis zephyria
5522891	5522891	PRJNA415636_S_NODE_4885_length_230_cov_2.273224_g4838_i0	PRJNA415636	4885	230	2.273224	5.2284152	Glossina fuscipes	7396	Arthropoda	Arthropoda	54.7	0.006	NTclustered	gi\|1939361499\|ref\|XM_038045242.1\|	7396	g4838	i0	100	1.89130434782609	29	0	13	0	97	125	8392	8420	PREDICTED: Glossina fuscipes titin (LOC119645211), transcript variant X8, mRNA	blastn	435	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Glossinidae	Glossina	Glossina fuscipes
11897955	11897955	PRJNA415636_S_NODE_6510_length_203_cov_2.243590_g6463_i0	PRJNA415636	6510	203	2.24359	4.5544877	Tetra sinicae	1316262	Arthropoda	Arthropoda	110	1.04e-19	NTclustered	gi\|472278790\|gb\|KC422563.1\|	1316262	g6463	i0	85.586	3.1871921182266	111	9	54	5	64	172	180	285	Tetra sinicae isolate OUT2 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	647	110	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Eriophyidae	Tetra	Tetra sinicae
18934719	18934719	PRJNA415636_S_NODE_815_length_432_cov_5.735065_g768_i0	PRJNA415636	815	432	5.735065	24.7754808	Timema	61471	Arthropoda	Arthropoda	54.7	0.012	NTclustered	gi\|1947819235\|emb\|OD566261.1\|	61472	g768	i0	100	0.134259259259259	29	0	7	0	282	310	111505	111477	4_Tbi_b3v08	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema bartmani
19544934	19544934	PRJNA415636_S_NODE_3636_length_258_cov_2.658768_g3589_i0	PRJNA415636	3636	258	2.658768	6.85962144	Anopheles albimanus	7167	Arthropoda	Arthropoda	67.6	8.39e-7	NTclustered	gi\|1894959010\|ref\|XM_035929323.1\|	7167	g3589	i0	74.375	0.953488372093023	160	39	62	2	3	161	351	509	PREDICTED: Anopheles albimanus 40S ribosomal protein S24-like (LOC118463066), mRNA	blastn	246	67.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Anopheles	Anopheles albimanus
19544936	19544936	PRJNA415636_S_NODE_4276_length_242_cov_1.830769_g4229_i0	PRJNA415636	4276	242	1.830769	4.43046098	Euthrix potatoria	624169	Arthropoda	Arthropoda	93.5	1.28e-14	NTclustered	gi\|2918370000\|emb\|OZ237887.1\|	624169	g4229	i0	91.176	1.38429752066116	68	6	28	0	145	212	13118106	13118039	Euthrix potatoria genome assembly, chromosome: 15	blastn	335	93.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lasiocampidae	Euthrix	Euthrix potatoria
19544938	19544938	PRJNA415636_S_NODE_4576_length_236_cov_1.015873_g4529_i0	PRJNA415636	4576	236	1.015873	2.3974602800000002	Zootermopsis nevadensis	136037	Arthropoda	Arthropoda	215	2.55e-51	NTclustered	gi\|1227986958\|ref\|XM_022069474.1\|	136037	g4529	i0	84.071	38.4110169491525	226	33	95	3	10	233	490	266	PREDICTED: Zootermopsis nevadensis RING-box protein 1A (LOC110832453), transcript variant X4, mRNA	blastn	9065	215	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Termopsidae	Zootermopsis	Zootermopsis nevadensis
20209474	20209474	PRJNA415636_S_NODE_6136_length_210_cov_1.184049_g6089_i0	PRJNA415636	6136	210	1.184049	2.4865029	Diploptera punctata	6984	Arthropoda	Arthropoda	110	3.32e-29	NR	KAJ9590993.1	6984	g6089	i0	65.7	3	70	24	100	0	1	210	50	119	KAJ9590993.1 hypothetical protein L9F63_027798, partial [Diploptera punctata]	diamond	630	110	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blaberidae	Diploptera	Diploptera punctata
23371226	23371226	PRJNA415636_S_NODE_5919_length_212_cov_33.254545_g5872_i0	PRJNA415636	5919	212	33.254545	70.4996354	Penaeus monodon	6687	Arthropoda	Arthropoda	56.5	0.001	NTclustered	gi\|1832334880\|gb\|MK599468.1\|	6687	g5872	i0	100	0.674528301886792	30	0	14	0	1	30	87	116	Penaeus monodon C-type lectin mRNA, complete cds	blastn	143	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus monodon
27471543	27471543	PRJNA415636_S_NODE_5783_length_215_cov_0.910714_g5736_i0	PRJNA415636	5783	215	0.910714	1.9580351	Metazoa	33208	Arthropoda	Arthropoda	93.2	4.3e-20	NR	XP_059087636.1	6832	g5736	i0	60.6	18.446511627907	71	28	99.1	0	3	215	485	555	XP_059087636.1 adenylyl cyclase-associated protein 1-like isoform X4 [Tigriopus californicus]	diamond	3966	93.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
27913265	27913265	PRJNA415636_S_NODE_4845_length_231_cov_2.070652_g4798_i0	PRJNA415636	4845	231	2.070652	4.78320612	Trichogramma	7490	Arthropoda	Arthropoda	105	1.24e-24	NR	XP_023315593.1	7493	g4798	i0	67.5	5.93506493506494	77	24	98.7	1	1	228	32	108	XP_023315593.1 peptidyl-prolyl cis-trans isomerase FKBP4 isoform X2 [Trichogramma pretiosum]	diamond	1371	105	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Trichogrammatidae	Trichogramma	Trichogramma pretiosum
28465286	28465286	PRJNA415636_S_NODE_2226_length_311_cov_2.625000_g2179_i0	PRJNA415636	2226	311	2.625	8.16375	Leptotrombidium deliense	299467	Arthropoda	Arthropoda	84	8.42e-18	NR	RWS28058.1	299467	g2179	i0	60	2.44051446945338	85	30	80.1	3	1	249	83	165	RWS28058.1 60S ribosomal protein L21-like protein [Leptotrombidium deliense]	diamond	759	84	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
29839431	29839431	PRJNA415636_S_NODE_3791_length_254_cov_1.676329_g3744_i0	PRJNA415636	3791	254	1.676329	4.25787566	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	2.08e-34	NR	XP_055937680.1	94029	g3744	i0	73.5	13.6535433070866	83	22	98	0	3	251	31	113	XP_055937680.1 60S ribosomal protein L31 [Argiope bruennichi]	diamond	3468	125	0.992	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Argiope	Argiope bruennichi
30597580	30597580	PRJNA415636_S_NODE_1093_length_397_cov_34.262857_g1046_i0	PRJNA415636	1093	397	34.262857	136.02354229	root	1	Root_unresolved	Root_unresolved	53.1	4.85e-5	NR	GBN61280.1	182803	g1046	i0	50.9	3.68765743073048	53	26	40.1	0	122	280	1136	1188	GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus]	diamond	1464	53.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Araneus	Araneus ventricosus
31672388	31672388	PRJNA415636_S_NODE_4277_length_242_cov_1.630769_g4230_i0	PRJNA415636	4277	242	1.630769	3.94646098	Metazoa	33208	Arthropoda	Arthropoda	127	2.02e-34	NR	NP_001040464.1	7091	g4230	i0	73.8	39.9421487603306	80	21	99.2	0	3	242	124	203	NP_001040464.1 thioredoxin peroxidase [Bombyx mori]	diamond	9666	128	0.9921875	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori

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