metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1167252" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1167252" and tax_kingdom = "Metazoa"

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
21991265	21991265	PRJNA1167252_P_NODE_26078_length_247_cov_1.793103_g25805_i0	PRJNA1167252	26078	247	1.793103	4.42896441	Adineta vaga	104782	Rotifera	other_Eukaryota	78.6	2.81e-15	NR	UJR08602.1	104782	g25805	i0	47.5	4.8582995951417	80	41	97.2	1	7	246	73	151	UJR08602.1 hypothetical protein I4U23_012861 [Adineta vaga]	diamond	1200	78.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
27640943	27640943	PRJNA1167252_P_NODE_26124_length_247_cov_1.609195_g25851_i0	PRJNA1167252	26124	247	1.609195	3.97471165	Scyliorhinus canicula	7830	Chordata	Chordata	160	6.03e-48	NR	XP_038652922.1	7830	g25851	i0	97.5	42.2550607287449	81	2	98.4	0	245	3	7	87	XP_038652922.1 60S ribosomal protein L13a isoform X2 [Scyliorhinus canicula]	diamond	10437	160	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Carcharhiniformes	Scyliorhinidae	Scyliorhinus	Scyliorhinus canicula
27880976	27880976	PRJNA1167252_P_NODE_18665_length_282_cov_1.866029_g18392_i0	PRJNA1167252	18665	282	1.866029	5.26220178	Hymenoptera	7399	Arthropoda	Arthropoda	147	2.6099999999999993e-43	NR	XP_001600769.1	7425	g18392	i0	70.7	2.91489361702128	92	27	97.9	0	278	3	40	131	XP_001600769.1 general odorant-binding protein 69a [Nasonia vitripennis]	diamond	822	147	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Pteromalidae	Nasonia	Nasonia vitripennis
28335381	28335381	PRJNA1167252_P_NODE_29246_length_242_cov_0.923077_g28973_i0	PRJNA1167252	29246	242	0.923077	2.23384634	Folsomia candida	158441	Arthropoda	Arthropoda	65.1	4.94e-10	NR	OXA63021.1	158441	g28973	i0	64.4	2.29338842975207	45	16	55.8	0	2	136	179	223	OXA63021.1 Aminopeptidase N [Folsomia candida]	diamond	555	65.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Entomobryomorpha	Isotomidae	Folsomia	Folsomia candida
28398531	28398531	PRJNA1167252_P_NODE_16146_length_305_cov_1.327586_g15873_i0	PRJNA1167252	16146	305	1.327586	4.0491373	Ranitomeya imitator	111125	Chordata	Chordata	63.5	3.81e-9	NR	CAJ0933392.1	111125	g15873	i0	62.5	0.472131147540984	48	16	45.2	1	31	168	53	100	CAJ0933392.1 unnamed protein product [Ranitomeya imitator]	diamond	144	63.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
28903519	28903519	PRJNA1167252_P_NODE_24608_length_250_cov_0.881356_g24335_i0	PRJNA1167252	24608	250	0.881356	2.20339	Eretmocerus hayati	131215	Arthropoda	Arthropoda	120	5.72e-30	NR	KAJ8664880.1	131215	g24335	i0	67.1	0.984	82	27	98.4	0	5	250	409	490	KAJ8664880.1 hypothetical protein QAD02_006542 [Eretmocerus hayati]	diamond	246	120	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Aphelinidae	Eretmocerus	Eretmocerus hayati
29851075	29851075	PRJNA1167252_P_NODE_22731_length_253_cov_0.866667_g22458_i0	PRJNA1167252	22731	253	0.866667	2.19266751	Uroleucon formosanum	796250	Arthropoda	Arthropoda	99.4	5.28e-22	NR	KAL4141829.1	796250	g22458	i0	56.6	0.984189723320158	83	36	98.4	0	250	2	619	701	KAL4141829.1 hypothetical protein QTP88_004386 [Uroleucon formosanum]	diamond	249	99.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Uroleucon	Uroleucon formosanum
31482123	31482123	PRJNA1167252_P_NODE_28816_length_243_cov_0.917647_g28543_i0	PRJNA1167252	28816	243	0.917647	2.22988221	Aphis	80764	Arthropoda	Arthropoda	101	9.45e-23	NR	XP_050053398.1	80765	g28543	i0	72.3	3.20987654320988	65	18	80.2	0	241	47	238	302	XP_050053398.1 PDZ and LIM domain protein Zasp isoform X1 [Aphis gossypii]	diamond	780	101	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Aphis	Aphis gossypii
32221847	32221847	PRJNA1167252_P_NODE_18278_length_285_cov_1.839623_g18005_i0	PRJNA1167252	18278	285	1.839623	5.24292555	Liolophura japonica	13599	Mollusca	Mollusca	128	4.71e-35	NR	XP_064606698.1	13599	g18005	i0	67	0.926315789473684	88	29	92.6	0	1	264	35	122	XP_064606698.1 inosine triphosphate pyrophosphatase-like [Liolophura japonica]	diamond	264	128	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
32853158	32853158	PRJNA1167252_P_NODE_18500_length_284_cov_0.777251_g18227_i0	PRJNA1167252	18500	284	0.777251	2.20739284	Stegodyphus mimosarum	407821	Arthropoda	Arthropoda	45.8	0.00476	NR	KFM67879.1	407821	g18227	i0	48.7	0.823943661971831	39	20	41.2	0	278	162	20	58	KFM67879.1 Zinc finger protein 346, partial [Stegodyphus mimosarum]	diamond	234	45.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Eresidae	Stegodyphus	Stegodyphus mimosarum

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