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

10 rows where analysis = "diamond", bioproject = "PRJNA784298" 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
4593750	4593750	PRJNA784298_P_NODE_8144_length_441_cov_2.008152_g7943_i0	PRJNA784298	8144	441	2.008152	8.85595032	Darwinula stevensoni	69355	Arthropoda	Arthropoda	149	5.76e-41	NR	CAD7255224.1	69355	g7943	i0	54.8	0.993197278911565	146	40	99.3	2	439	2	84	203	CAD7255224.1 unnamed protein product, partial [Darwinula stevensoni]	diamond	438	149	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
17343587	17343587	PRJNA784298_P_NODE_22314_length_260_cov_1.106952_g22113_i0	PRJNA784298	22314	260	1.106952	2.8780752	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	134	5.12e-38	NR	XP_018653298.1	6183	g22113	i0	73.3	17.8615384615385	86	23	99.2	0	1	258	44	129	XP_018653298.1 putative 60s ribosomal protein L11 [Schistosoma mansoni]	diamond	4644	134	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
19892125	19892125	PRJNA784298_P_NODE_1696_length_983_cov_2.086813_g1536_i0	PRJNA784298	1696	983	2.086813	20.51337179	Idotea baltica	82763	Arthropoda	Arthropoda	372	5.34e-125	NR	MCL4166761.1	82763	g1536	i0	60.6	0.991861648016277	325	124	99.2	1	1	975	23	343	MCL4166761.1 hypothetical protein [Idotea baltica]	diamond	975	372	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
23718288	23718288	PRJNA784298_P_NODE_59_length_4639_cov_8.504380_g50_i0	PRJNA784298	59	4639	8.50438	394.5181882	root	1	Root_unresolved	Root_unresolved	960	0	NR	CAG4649328.1	202097	g50	i0	47.9	1.11230868721707	1223	428	78.6	13	3649	2	3	1023	CAG4649328.1 EOG090X067V, partial [Scapholeberis mucronata]	diamond	5160	960	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Scapholeberis	Scapholeberis mucronata
27085297	27085297	PRJNA784298_P_NODE_23102_length_254_cov_2.359116_g22901_i0	PRJNA784298	23102	254	2.359116	5.99215464	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	43.5	0.0185	NR	XP_033096970.1	1529436	g22901	i0	36.7	0.708661417322835	60	36	68.5	1	46	219	163	222	XP_033096970.1 transmembrane protein 70, mitochondrial-like [Anneissia japonica]	diamond	180	43.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
28190437	28190437	PRJNA784298_P_NODE_6806_length_485_cov_2.669903_g6606_i0	PRJNA784298	6806	485	2.669903	12.94902955	Rattus norvegicus	10116	Chordata	Chordata	50.8	6.94e-4	NR	AAS66221.1	10116	g6606	i0	31.4	0.865979381443299	140	70	79.8	9	425	39	1070	1194	AAS66221.1 LRRG00130 [Rattus norvegicus]	diamond	420	50.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus
28578926	28578926	PRJNA784298_P_NODE_23727_length_251_cov_0.865169_g23526_i0	PRJNA784298	23727	251	0.865169	2.17157419	Arthropoda	6656	Arthropoda	Arthropoda	52	1.68e-5	NR	XP_017462234.1	28612	g23526	i0	41.3	1.91235059760956	80	47	95.6	0	8	247	94	173	XP_017462234.1 PREDICTED: E3 ubiquitin-protein ligase Bre1-like [Rhagoletis zephyria]	diamond	480	52	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Rhagoletis	Rhagoletis zephyria
29273251	29273251	PRJNA784298_P_NODE_22269_length_260_cov_1.625668_g22068_i0	PRJNA784298	22269	260	1.625668	4.2267368	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	134	2e-36	NR	XP_069097964.1	8319	g22068	i0	73.3	95.0307692307692	86	23	99.2	0	3	260	24	109	XP_069097964.1 large ribosomal subunit protein uL18B-like [Pleurodeles waltl]	diamond	24708	135	0.992592592592593	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
29895791	29895791	PRJNA784298_P_NODE_6911_length_481_cov_3.426471_g6710_i0	PRJNA784298	6911	481	3.426471	16.48132551	Ranitomeya imitator	111125	Chordata	Chordata	65.9	3.31e-9	NR	CAJ0925002.1	111125	g6710	i0	52.7	0.923076923076923	74	29	42.4	1	205	2	288	361	CAJ0925002.1 unnamed protein product, partial [Ranitomeya imitator]	diamond	444	65.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
30505330	30505330	PRJNA784298_P_NODE_25593_length_245_cov_0.895349_g25392_i0	PRJNA784298	25593	245	0.895349	2.19360505	Amphipoda	6821	Arthropoda	Arthropoda	64.7	3.72e-10	NR	XP_018026009.1	294128	g25392	i0	75	2.71836734693878	44	11	53.9	0	245	114	217	260	XP_018026009.1 40S ribosomal protein S4 [Hyalella azteca]	diamond	666	65.1	0.993855606758833	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Amphipoda	Hyalellidae	Hyalella	Hyalella azteca

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