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

9 rows where analysis = "diamond", bioproject = "PRJNA702290" and tax_phylum = "Chordata"

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
27082777	27082777	PRJNA702290_P_NODE_1682_length_158_cov_10.260504_g1674_i0	PRJNA702290	1682	158	10.260504	16.21159632	Mimus melanotis	245851	Chordata	Chordata	64.3	2.83e-10	NR	KAL2297966.1	245851	g1674	i0	64.2	1.00632911392405	53	17	96.8	1	158	6	470	522	KAL2297966.1 LOW QUALITY PROTEIN: hypothetical protein Nmel_016925 [Mimus melanotis]	diamond	159	64.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Mimidae	Mimus	Mimus melanotis
27304160	27304160	PRJNA702290_P_NODE_1143_length_191_cov_4.552632_g1135_i0	PRJNA702290	1143	191	4.552632	8.69552712	Dendropsophus ebraccatus	150705	Chordata	Chordata	43.5	0.0101	NR	XP_069819635.1	150705	g1135	i0	76	0.785340314136126	25	6	39.3	0	2	76	236	260	XP_069819635.1 zinc finger protein 862-like [Dendropsophus ebraccatus]	diamond	150	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Dendropsophus	Dendropsophus ebraccatus
27462159	27462159	PRJNA702290_P_NODE_1963_length_155_cov_3.612069_g1955_i0	PRJNA702290	1963	155	3.612069	5.59870695	Polypterus senegalus	55291	Chordata	Chordata	44.7	0.00228	NR	XP_039614085.1	55291	g1955	i0	50.7	17.1290322580645	69	14	94.8	1	153	7	203	271	XP_039614085.1 hydroxyacyl-coenzyme A dehydrogenase, mitochondrial isoform X3 [Polypterus senegalus]	diamond	2655	44.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
27809513	27809513	PRJNA702290_P_NODE_984_length_191_cov_8.651316_g976_i0	PRJNA702290	984	191	8.651316	16.52401356	Xenopus laevis	8355	Chordata	Chordata	97.4	1.03e-21	NR	NP_001087147.1	8355	g976	i0	81.4	4.63350785340314	59	7	92.7	1	183	7	624	678	NP_001087147.1 transportin 3 S homeolog [Xenopus laevis]	diamond	885	97.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
27978307	27978307	PRJNA702290_P_NODE_1785_length_157_cov_12.813559_g1777_i0	PRJNA702290	1785	157	12.813559	20.11728763	root	1	Root_unresolved	Root_unresolved	53.1	4.91e-7	NR	PIO15684.1	8400	g1777	i0	100	34.3949044585987	25	0	47.8	0	77	3	22	46	PIO15684.1 hypothetical protein AB205_0014410, partial [Aquarana catesbeiana]	diamond	5400	53.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Aquarana	Aquarana catesbeiana
29324785	29324785	PRJNA702290_P_NODE_949_length_191_cov_9.421053_g941_i0	PRJNA702290	949	191	9.421053	17.99421123	Miniopterus natalensis	291302	Chordata	Chordata	57.4	1.25e-7	NR	XP_016072990.1	291302	g941	i0	92.3	33.0785340314136	26	2	40.8	0	113	190	194	219	XP_016072990.1 PREDICTED: sestrin-1 isoform X2 [Miniopterus natalensis]	diamond	6318	57.8	0.993079584775087	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Miniopteridae	Miniopterus	Miniopterus natalensis
30283929	30283929	PRJNA702290_P_NODE_852_length_191_cov_11.644737_g844_i0	PRJNA702290	852	191	11.644737	22.24144767	Metazoa	33208	Chordata	Chordata	57	1.66e-7	NR	NP_001080195.1	8355	g844	i0	96.2	35.0575916230367	26	1	40.8	0	80	3	70	95	NP_001080195.1 solute carrier family 25 member 3 [Xenopus laevis]	diamond	6696	57	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
30378686	30378686	PRJNA702290_P_NODE_932_length_191_cov_9.796053_g924_i0	PRJNA702290	932	191	9.796053	18.71046123	Metazoa	33208	Chordata	Chordata	51.2	1.88e-5	NR	ADI79577.1	36310	g924	i0	100	21.7696335078534	22	0	34.6	0	7	72	427	448	ADI79577.1 cytochrome oxidase subunit I [Gekko gecko]	diamond	4158	51.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Gekkonidae	Gekko	Gekko gecko
30504763	30504763	PRJNA702290_P_NODE_1953_length_155_cov_7.818966_g1945_i0	PRJNA702290	1953	155	7.818966	12.1193973	Metazoa	33208	Chordata	Chordata	70.1	4.41e-13	NR	AAG00839.1	30343	g1945	i0	70	588.696774193548	60	8	96.8	1	154	5	62	121	AAG00839.1 cytochrome oxidase I, partial [Dryophytes versicolor]	diamond	91248	70.5	0.994326241134752	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Dryophytes	Dryophytes versicolor

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