metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB8827" 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
25666291	25666291	PRJEB8827h_S_NODE_338_length_411_cov_14.313830_g319_i0	PRJEB8827	338	411	14.31383	58.8298413	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	129	1.7299999999999998e-35	NR	XP_055937680.1	94029	g319	i0	77.8	14.4306569343066	81	18	59.1	0	411	169	39	119	XP_055937680.1 60S ribosomal protein L31 [Argiope bruennichi]	diamond	5931	129	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Argiope	Argiope bruennichi
32913847	32913847	PRJEB8827b_S_NODE_46913_length_151_cov_1.724138_g46861_i0	PRJEB8827	46913	151	1.724138	2.60344838	Homalodisca vitripennis	197043	Arthropoda	Arthropoda	92.4	1.13e-20	NR	KAG8301348.1	197043	g46861	i0	75.5	21.6953642384106	49	12	97.4	0	148	2	286	334	KAG8301348.1 hypothetical protein J6590_055116 [Homalodisca vitripennis]	diamond	3276	93.2	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Homalodisca	Homalodisca vitripennis
32957685	32957685	PRJEB8827f_S_NODE_11394_length_178_cov_1.825175_g11374_i0	PRJEB8827	11394	178	1.825175	3.2488115	Insecta	50557	Arthropoda	Arthropoda	42	0.0302	NR	XP_017773819.1	110193	g11374	i0	60	1.19662921348315	35	14	59	0	38	142	931	965	XP_017773819.1 PREDICTED: alanine--tRNA ligase, cytoplasmic [Nicrophorus vespilloides]	diamond	213	42.4	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Silphidae	Nicrophorus	Nicrophorus vespilloides
33016792	33016792	PRJEB8827h_S_NODE_900_length_302_cov_5.389513_g881_i0	PRJEB8827	900	302	5.389513	16.27632926	Idotea baltica	82763	Arthropoda	Arthropoda	72.4	1.11e-13	NR	MCL4126019.1	82763	g881	i0	73.3	2.60264900662252	45	12	44.7	0	301	167	77	121	MCL4126019.1 hypothetical protein [Idotea baltica]	diamond	786	72.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
33025990	33025990	PRJEB8827f_S_NODE_33348_length_154_cov_1.344538_g33328_i0	PRJEB8827	33348	154	1.344538	2.07058852	Syrphidae	34680	Arthropoda	Arthropoda	72	5.03e-13	NR	XP_055853046.1	286459	g33328	i0	66.7	9.11688311688312	39	13	76	0	3	119	726	764	XP_055853046.1 neprilysin-2 isoform X2 [Episyrphus balteatus]	diamond	1404	72	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Syrphidae	Episyrphus	Episyrphus balteatus
33067786	33067786	PRJEB8827f_S_NODE_3093_length_249_cov_4.004673_g3073_i0	PRJEB8827	3093	249	4.004673	9.97163577	Schistocerca gregaria	7010	Arthropoda	Arthropoda	59.3	1.86e-8	NR	XP_049850888.1	7010	g3073	i0	77.8	1.51807228915663	36	8	43.4	0	247	140	134	169	XP_049850888.1 ras-like protein rasG [Schistocerca gregaria]	diamond	378	59.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca gregaria
33128241	33128241	PRJEB8827h_S_NODE_6007_length_199_cov_839.304878_g5988_i0	PRJEB8827	6007	199	839.304878	1670.21670722	Arthropoda	6656	Arthropoda	Arthropoda	57.4	2.92e-8	NR	NP_001037114.1	7091	g5988	i0	87.1	19.7939698492462	31	4	46.7	0	159	67	121	151	NP_001037114.1 small ribosomal subunit protein uS11 [Bombyx mori]	diamond	3939	57.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
33136187	33136187	PRJEB8827h_S_NODE_1751_length_243_cov_5.822115_g1732_i0	PRJEB8827	1751	243	5.822115	14.14773945	Araneus ventricosus	182803	Arthropoda	Arthropoda	41.6	0.0474	NR	GBN38575.1	182803	g1732	i0	38.6	0.864197530864197	70	40	86.4	1	243	34	73	139	GBN38575.1 hypothetical protein AVEN_106509-1 [Araneus ventricosus]	diamond	210	41.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Araneus	Araneus ventricosus
33153219	33153219	PRJEB8827h_S_NODE_2632_length_219_cov_4.461957_g2613_i0	PRJEB8827	2632	219	4.461957	9.77168583	Idotea baltica	82763	Arthropoda	Arthropoda	89	6.25e-20	NR	MCL4142858.1	82763	g2613	i0	70.3	2.63013698630137	64	19	87.7	0	218	27	141	204	MCL4142858.1 hypothetical protein [Idotea baltica]	diamond	576	89	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica

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