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

5 rows where bioproject = "PRJNA1160211", 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
1583798	1583798	PRJNA1160211_S_NODE_126582_length_410_cov_7.367953_g125350_i0	PRJNA1160211	126582	410	7.367953	30.2086073	Hirudo verbana	311461	Annelida	Annelida	60.2	2.35e-4	NTclustered	gi\|2918369720\|emb\|OZ237792.1\|	311461	g125350	i0	94.737	1.28048780487805	38	2	9	0	80	117	7753600	7753563	Hirudo verbana genome assembly, chromosome: 14	blastn	525	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
5412120	5412120	PRJNA1160211_S_NODE_118545_length_423_cov_29.837143_g117316_i0	PRJNA1160211	118545	423	29.837143	126.21111489	Golfingia vulgaris	210797	Annelida	Annelida	115	5.1200000000000005e-21	NTclustered	gi\|351637709\|gb\|AF519273.2\|	210797	g117316	i0	77.5	46.3947990543735	200	40	46	4	32	227	1253	1451	Golfingia vulgaris isolate DNA100207 28S ribosomal RNA gene, partial sequence	blastn	19625	115	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Sipuncula	Golfingiida	Golfingiidae	Golfingia	Golfingia vulgaris
18162542	18162542	PRJNA1160211_S_NODE_98575_length_460_cov_3.770026_g97350_i0	PRJNA1160211	98575	460	3.770026	17.3421196	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.045	NTclustered	gi\|2920003527\|emb\|OZ238867.1\|	1046305	g97350	i0	100	0.0608695652173913	28	0	6	0	213	240	189909	189936	Ailoscolex lacteospumosus genome assembly, chromosome: 8	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
28556527	28556527	PRJNA1160211_S_NODE_94247_length_468_cov_23.240506_g93022_i0	PRJNA1160211	94247	468	23.240506	108.76556808	Capitella teleta	283909	Annelida	Annelida	53.1	4.48e-5	NR	ELU03813.1	283909	g93022	i0	37.8	0.628205128205128	98	51	60.3	4	185	466	63	154	ELU03813.1 hypothetical protein CAPTEDRAFT_155689 [Capitella teleta]	diamond	294	53.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
29156481	29156481	PRJNA1160211_S_NODE_285549_length_238_cov_2.800000_g284316_i0	PRJNA1160211	285549	238	2.8	6.664	Helobdella robusta	6412	Annelida	Annelida	63.9	1.18e-9	NR	XP_009030288.1	6412	g284316	i0	44.3	0.882352941176471	70	35	83.2	2	237	40	178	247	XP_009030288.1 hypothetical protein HELRODRAFT_165469 [Helobdella robusta]	diamond	210	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta

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