metadata: contig_metadata: 7 rows where bioproject = "PRJNA1146366" and tax

7 rows where bioproject = "PRJNA1146366" 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
290298	290298	PRJNA1146366_S_NODE_1641_length_278_cov_1.517073_g1638_i0	PRJNA1146366	1641	278	1.517073	4.21746294	Ovis aries	9940	Chordata	Chordata	154	6.82e-33	NTclustered	gi\|199945614\|gb\|FJ042940.1\|	9940	g1638	i0	89.431	45.6834532374101	123	12	44	1	72	193	34254	34132	Ovis aries APOBEC3A (APOBEC3A) gene, complete cds; APOBEC3F (APOBEC3F) gene, complete cds, alternatively spliced; and CBX7 gene, complete sequence	blastn	12700	154	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
6136527	6136527	PRJNA1146366_S_NODE_365_length_416_cov_10.169096_g362_i0	PRJNA1146366	365	416	10.169096	42.30343936	Ochotona princeps	9978	Chordata	Chordata	72.8	3.68e-14	NR	XP_058514412.1	9978	g362	i0	74	1.75240384615385	50	13	36.1	0	78	227	3	52	XP_058514412.1 thymosin beta-15A isoform X1 [Ochotona princeps]	diamond	729	72.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Lagomorpha	Ochotonidae	Ochotona	Ochotona princeps
18142034	18142034	PRJNA1146366_S_NODE_2315_length_247_cov_2.839080_g2312_i0	PRJNA1146366	2315	247	2.83908	7.0125276	Hyla sarda	327740	Chordata	Chordata	52.8	0.022	NTclustered	gi\|2512226893\|ref\|XM_056533279.1\|	327740	g2312	i0	100	0.11336032388664	28	0	11	0	1	28	464	437	PREDICTED: Hyla sarda CLN3 lysosomal/endosomal transmembrane protein, battenin (CLN3), transcript variant X1, mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Hyla	Hyla sarda
20691796	20691796	PRJNA1146366_S_NODE_1097_length_315_cov_1.834711_g1094_i0	PRJNA1146366	1097	315	1.834711	5.77933965	Erpetoichthys calabaricus	27687	Chordata	Chordata	211	4.6e-50	NTclustered	gi\|2327581580\|ref\|XM_051922993.1\|	27687	g1094	i0	79.341	7.48571428571429	334	43	99	16	2	315	1284	957	PREDICTED: Erpetoichthys calabaricus E3 SUMO-protein ligase ZBED1-like (LOC127526706), mRNA	blastn	2358	211	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
20691808	20691808	PRJNA1146366_S_NODE_2397_length_244_cov_4.514620_g2394_i0	PRJNA1146366	2397	244	4.51462	11.0156728	Meles meles	9662	Chordata	Chordata	54.7	0.006	NTclustered	gi\|1190059416\|emb\|LT800002.1\|	9662	g2394	i0	100	0.463114754098361	29	0	12	0	1	29	30	58	Meles meles mRNA for Enzyme (Glyceraldehyde 3-phosphate dehydrogenase gene)	blastn	113	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Meles	Meles meles
28764754	28764754	PRJNA1146366_S_NODE_1767_length_271_cov_4.505051_g1764_i0	PRJNA1146366	1767	271	4.505051	12.20868821	root	1	Root_unresolved	Root_unresolved	92.4	2.88e-22	NR	KAK2531691.1	8932	g1764	i0	97.8	82.859778597786	46	1	50.9	0	266	129	22	67	KAK2531691.1 hypothetical protein Q9966_008500 [Columba livia]	diamond	22455	93.2	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Columbiformes	Columbidae	Columba	Columba livia
31714117	31714117	PRJNA1146366_S_NODE_1537_length_284_cov_1.981043_g1534_i0	PRJNA1146366	1537	284	1.981043	5.62616212	Ciona intestinalis	7719	Chordata	Chordata	60.5	1.33e-9	NR	NP_001177191.1	7719	g1534	i0	68.4	0.77112676056338	38	12	40.1	0	284	171	49	86	NP_001177191.1 selenoprotein W, 1 [Ciona intestinalis]	diamond	219	60.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis

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