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

14 rows where bioproject = "PRJNA454154" 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
441960	441960	PRJNA454154_S_NODE_161_length_242_cov_39.146341_g158_i0	PRJNA454154	161	242	39.146341	94.73414522	Cicindelinae sp. YW-2015	1620299	Arthropoda	Arthropoda	141	4.52e-29	NTclustered	gi\|762060975\|gb\|KJ825855.1\|	1620299	g158	i0	80.978	39.1280991735537	184	30	75	5	5	185	140	321	Cicindelinae sp. YW-2015 28S ribosomal RNA gene, partial sequence	blastn	9469	141	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Carabidae		Cicindelinae sp. YW-2015
1093462	1093462	PRJNA454154_S_NODE_321_length_193_cov_3.628205_g318_i0	PRJNA454154	321	193	3.628205	7.00243565	Metazoa	33208	Arthropoda	Arthropoda	60.2	9.94e-5	NTclustered	gi\|1465231271\|gb\|MG910466.1\|	6728	g318	i0	89.362	2.71502590673575	47	5	24	0	4	50	1843	1889	Procambarus clarkii heat shock protein 70 kDa isoform 1 (Hsp70) mRNA, partial cds	blastn	524	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
1716822	1716822	PRJNA454154_S_NODE_42_length_373_cov_7.089286_g39_i0	PRJNA454154	42	373	7.089286	26.44303678	Speleorchestes sp. AD1084	2051767	Arthropoda	Arthropoda	104	9.66e-18	NTclustered	gi\|1282187773\|gb\|KY921978.1\|	2051767	g39	i0	83.478	4.32707774798928	115	16	30	3	66	177	2568	2454	Speleorchestes sp. AD1084 voucher UMMZ BMOC 07-0615-007 AD1084 28S ribosomal RNA gene, partial sequence	blastn	1614	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Nanorchestidae	Speleorchestes	Speleorchestes sp. AD1084
2992591	2992591	PRJNA454154_S_NODE_103_length_280_cov_7.168724_g100_i0	PRJNA454154	103	280	7.168724	20.0724272	Lepeophtheirus salmonis	72036	Arthropoda	Arthropoda	139	1.9299999999999999e-28	NTclustered	gi\|2024297716\|ref\|XM_040723615.1\|	72036	g100	i0	81.287	3.46071428571429	171	32	61	0	98	268	612	442	PREDICTED: Lepeophtheirus salmonis 40S ribosomal protein S18 (LOC121128048), mRNA	blastn	969	139	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Siphonostomatoida	Caligidae	Lepeophtheirus	Lepeophtheirus salmonis
8095070	8095070	PRJNA454154_S_NODE_167_length_240_cov_10.453202_g164_i0	PRJNA454154	167	240	10.453202	25.0876848	Andinodontis sp. Ecuador: Vinillos	2493408	Arthropoda	Arthropoda	80.5	9.9e-11	NTclustered	gi\|1530827587\|gb\|MK103992.1\|	2493408	g164	i0	90.323	19.2333333333333	62	5	25	1	49	109	923	862	Andinodontis sp. Ecuador: Vinillos voucher OSAC:DRMaddison DNA2648 28S large subunit ribosomal RNA gene, partial sequence	blastn	4616	80.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Carabidae	Andinodontis	Andinodontis sp. Ecuador: Vinillos
8095071	8095071	PRJNA454154_S_NODE_247_length_209_cov_3.889535_g244_i0	PRJNA454154	247	209	3.889535	8.12912815	Thripidae	45053	Arthropoda	Arthropoda	105	2.22e-25	NR	XP_026293202.1	133901	g244	i0	69.6	2.97129186602871	69	21	99	0	207	1	236	304	XP_026293202.1 annexin B11 isoform X2 [Frankliniella occidentalis]	diamond	621	105	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Frankliniella	Frankliniella occidentalis
10645827	10645827	PRJNA454154_S_NODE_449_length_176_cov_1.733813_g446_i0	PRJNA454154	449	176	1.733813	3.05151088	Photinus pyralis	7054	Arthropoda	Arthropoda	91.6	3.15e-14	NTclustered	gi\|1770344310\|ref\|XM_031485639.1\|	7054	g446	i0	81.356	3.01136363636364	118	16	65	5	28	141	585	700	PREDICTED: Photinus pyralis 60S ribosomal protein L9 (LOC116169534), transcript variant X1, mRNA	blastn	530	91.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Lampyridae	Photinus	Photinus pyralis
22118463	22118463	PRJNA454154_S_NODE_278_length_201_cov_11.073171_g275_i0	PRJNA454154	278	201	11.073171	22.25707371	Topomyia yanbarensis	2498891	Arthropoda	Arthropoda	56.5	0.001	NTclustered	gi\|2563603579\|ref\|XM_058977644.1\|	2498891	g275	i0	96.97	0.164179104477612	33	1	16	0	8	40	1212	1244	PREDICTED: Topomyia yanbarensis actin, muscle-type A2-like (LOC131691333), mRNA	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Topomyia	Topomyia yanbarensis
22118467	22118467	PRJNA454154_S_NODE_658_length_152_cov_2.617391_g655_i0	PRJNA454154	658	152	2.617391	3.97843432	Darwinula stevensoni	69355	Arthropoda	Arthropoda	60.2	7.43e-5	NTclustered	gi\|1936519677\|emb\|LR901095.1\|	69355	g655	i0	100	0.210526315789474	32	0	21	0	17	48	19172	19141	Darwinula stevensoni	blastn	32	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
23394153	23394153	PRJNA454154_S_NODE_279_length_201_cov_6.109756_g276_i0	PRJNA454154	279	201	6.109756	12.28060956	Paracalanus parvus	187406	Arthropoda	Arthropoda	80.5	8.02e-11	NTclustered	gi\|961376867\|gb\|KT755344.1\|	187406	g276	i0	80.583	0.512437810945274	103	20	51	0	97	199	209	107	Paracalanus parvus clone ParpacDNA53 60S ribosomal protein L39 mRNA, complete cds	blastn	103	80.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Calanoida	Paracalanidae	Paracalanus	Paracalanus parvus
24668139	24668139	PRJNA454154_S_NODE_620_length_155_cov_0.923729_g617_i0	PRJNA454154	620	155	0.923729	1.43177995	Lieinix nemesis	320282	Arthropoda	Arthropoda	106	9.64e-19	NTclustered	gi\|2566555242\|gb\|OK767026.1\|	320282	g617	i0	79.355	1	155	28	99	4	3	155	31	183	Lieinix nemesis voucher MGCL:LEP-28910 ribosomal protein L21 gene, partial cds	blastn	155	106	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pieridae	Lieinix	Lieinix nemesis
26949485	26949485	PRJNA454154_S_NODE_442_length_177_cov_1.807143_g439_i0	PRJNA454154	442	177	1.807143	3.19864311	Tigriopus californicus	6832	Arthropoda	Arthropoda	63.9	1.01e-11	NR	TRY61806.1	6832	g439	i0	48.2	1.79661016949153	56	29	94.9	0	8	175	11	66	TRY61806.1 hypothetical protein TCAL_17220 [Tigriopus californicus]	diamond	318	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
27424015	27424015	PRJNA454154_S_NODE_663_length_152_cov_1.000000_g660_i0	PRJNA454154	663	152	1	1.52	Nymphon striatum	424472	Arthropoda	Arthropoda	47.8	1.81e-4	NR	KAG1668330.1	424472	g660	i0	51.5	0.651315789473684	33	16	65.1	0	3	101	298	330	KAG1668330.1 Actin-related protein 2/3 complex subunit 1A [Nymphon striatum]	diamond	99	47.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Pycnogonida	Pantopoda	Nymphonidae	Nymphon	Nymphon striatum
30549980	30549980	PRJNA454154_S_NODE_273_length_202_cov_2.981818_g270_i0	PRJNA454154	273	202	2.981818	6.02327236	Dinothrombium tinctorium	1965070	Arthropoda	Arthropoda	51.6	2.52e-6	NR	RWS01562.1	1965070	g270	i0	65	1.76732673267327	40	11	55	1	197	87	34	73	RWS01562.1 ribosomal protein LP1-like protein [Dinothrombium tinctorium]	diamond	357	51.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombidiidae	Dinothrombium	Dinothrombium tinctorium

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