metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA904835" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA904835" 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
29518934	29518934	PRJNA904835_P_NODE_15790_length_519_cov_2.237668_g15537_i0	PRJNA904835	15790	519	2.237668	11.61349692	Latimeria chalumnae	7897	Chordata	Chordata	117	4.92e-27	NR	XP_064409497.1	7897	g15537	i0	45.3	4.32369942196532	148	75	82.7	3	517	89	559	705	XP_064409497.1 phospholipid-transporting ATPase ID [Latimeria chalumnae]	diamond	2244	117	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
30000394	30000394	PRJNA904835_P_NODE_55471_length_245_cov_0.895349_g55215_i0	PRJNA904835	55471	245	0.895349	2.19360505	Chordata	7711	Chordata	Chordata	132	1.64e-37	NR	PIO30534.1	8400	g55215	i0	69.3	9.4530612244898	88	20	99.2	2	2	244	21	108	PIO30534.1 hypothetical protein AB205_0007110, partial [Aquarana catesbeiana]	diamond	2316	132	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Aquarana	Aquarana catesbeiana
30157981	30157981	PRJNA904835_P_NODE_40052_length_299_cov_1.592920_g39796_i0	PRJNA904835	40052	299	1.59292	4.7628308	Mammalia	40674	Chordata	Chordata	206	2.0800000000000002e-59	NR	XP_045736629.1	9716	g39796	i0	99	50.628762541806	99	1	99.3	0	298	2	60	158	XP_045736629.1 nuclear factor NF-kappa-B p105 subunit isoform X5 [Mirounga angustirostris]	diamond	15138	207	0.995169082125604	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Mirounga	Mirounga angustirostris
30340786	30340786	PRJNA904835_P_NODE_58432_length_242_cov_0.911243_g58176_i0	PRJNA904835	58432	242	0.911243	2.20520806	Falco naumanni	148594	Chordata	Chordata	56.6	4.35e-8	NR	XP_040442173.1	148594	g58176	i0	62.1	2.59090909090909	66	18	73.1	2	202	26	9	74	XP_040442173.1 interferon alpha-inducible protein 27-like protein 2A [Falco naumanni]	diamond	627	56.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Falconiformes	Falconidae	Falco	Falco naumanni

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