metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA642647" 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
27776394	27776394	PRJNA642647_P_NODE_1424_length_292_cov_2.890196_g1374_i0	PRJNA642647	1424	292	2.890196	8.43937232	Brugia pahangi	6280	Nematoda	Nematoda	46.6	0.0028	NR	VDN81525.1	6280	g1374	i0	48.3	2.20890410958904	60	25	60.6	2	285	109	278	332	VDN81525.1 unnamed protein product [Brugia pahangi]	diamond	645	46.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia pahangi
28483184	28483184	PRJNA642647_P_NODE_6306_length_152_cov_2.591304_g6256_i0	PRJNA642647	6306	152	2.591304	3.93878208	root	1	Root_unresolved	Root_unresolved	48.9	7.12e-5	NR	QKY88654.1	271932	g6256	i0	46	8.23026315789474	50	23	90.8	1	7	144	231	280	QKY88654.1 matrix metalloprotease 13 [Tetracapsuloides bryosalmonae]	diamond	1251	49.3	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Malacovalvulida	Saccosporidae	Tetracapsuloides	Tetracapsuloides bryosalmonae
29146566	29146566	PRJNA642647_P_NODE_6429_length_151_cov_3.350877_g6379_i0	PRJNA642647	6429	151	3.350877	5.05982427	Rodentia	9989	Chordata	Chordata	53.9	1.21e-6	NR	EGW07491.1	10029	g6379	i0	85.7	7.47019867549669	28	4	55.6	0	5	88	406	433	EGW07491.1 Inositol 1,4,5-trisphosphate receptor type 2 [Cricetulus griseus]	diamond	1128	53.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
31060984	31060984	PRJNA642647_P_NODE_4255_length_175_cov_2.210145_g4205_i0	PRJNA642647	4255	175	2.210145	3.86775375	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	47.4	3.37e-4	NR	KAK3748527.1	3060491	g4205	i0	56.3	0.548571428571429	32	14	54.9	0	3	98	474	505	KAK3748527.1 hypothetical protein QZH41_012374 [Actinostola sp. cb2023]	diamond	96	47.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023
31389314	31389314	PRJNA642647_P_NODE_1236_length_315_cov_2.996403_g1186_i0	PRJNA642647	1236	315	2.996403	9.43866945	Metazoa	33208	Arthropoda	Arthropoda	45.8	0.00668	NR	XP_050359582.1	171585	g1186	i0	28.6	4.22857142857143	91	40	71.4	4	296	72	214	295	XP_050359582.1 myoneurin-like isoform X2 [Nymphalis io]	diamond	1332	46.2	0.991341991341991	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Nymphalis	Nymphalis io

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