metadata: contig_metadata: 5 rows where bioproject = "PRJNA721440", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA721440", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"

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
7088930	7088930	PRJNA721440_S_NODE_21326_length_155_cov_3.377358_g21200_i0	PRJNA721440	21326	155	3.377358	5.2349049	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2920003527\|emb\|OZ238867.1\|	1046305	g21200	i0	100	1.47741935483871	29	0	19	0	83	111	1686840	1686868	Ailoscolex lacteospumosus genome assembly, chromosome: 8	blastn	229	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
12673238	12673238	PRJNA721440_S_NODE_14390_length_179_cov_1.638462_g14264_i0	PRJNA721440	14390	179	1.638462	2.93284698	Metazoa	33208	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2920003578\|emb\|OZ238870.1\|	1046305	g14264	i0	100	0.972067039106145	29	0	16	0	62	90	14999051	14999079	Ailoscolex lacteospumosus genome assembly, chromosome: 11	blastn	174	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
27526010	27526010	PRJNA721440_S_NODE_5523_length_256_cov_1.275362_g5397_i0	PRJNA721440	5523	256	1.275362	3.26492672	Paralvinella palmiformis	53620	Annelida	Annelida	52.8	1.3e-5	NR	KAK2164809.1	53620	g5397	i0	40	0.8203125	70	40	82	1	26	235	102	169	KAK2164809.1 hypothetical protein LSH36_58g00027 [Paralvinella palmiformis]	diamond	210	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
28230862	28230862	PRJNA721440_S_NODE_15366_length_175_cov_1.206349_g15240_i0	PRJNA721440	15366	175	1.206349	2.11111075	Metazoa	33208	Annelida	Annelida	80.5	7.13e-16	NR	CAH1802338.1	6347	g15240	i0	64.8	12.1542857142857	54	18	92.6	1	170	9	475	527	CAH1802338.1 unnamed protein product [Owenia fusiformis]	diamond	2127	80.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32528846	32528846	PRJNA721440_S_NODE_3279_length_314_cov_7.479245_g3153_i0	PRJNA721440	3279	314	7.479245	23.4848293	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.5	1.42e-5	NR	KAK2153378.1	53620	g3153	i0	45	4.32802547770701	60	31	57.3	1	110	289	5	62	KAK2153378.1 hypothetical protein LSH36_299g03010 [Paralvinella palmiformis]	diamond	1359	53.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis

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