metadata: contig_metadata: 7 rows where bioproject = "PRJNA1126198", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA1126198", 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
2305415	2305415	PRJNA1126198_P_NODE_101542_length_341_cov_2.205224_g100823_i0	PRJNA1126198	101542	341	2.205224	7.51981384	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	144	1.3199999999999999e-40	NR	CAD5118891.1	2664684	g100823	i0	72.2	7.72434017595308	97	26	85.3	1	49	339	49	144	CAD5118891.1 DgyrCDS7565 [Dimorphilus gyrociliatus]	diamond	2634	144	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
6659138	6659138	PRJNA1126198_P_NODE_256066_length_276_cov_1.995074_g255345_i0	PRJNA1126198	256066	276	1.995074	5.50640424	Hirudo verbana	311461	Annelida	Annelida	56.5	0.002	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g255345	i0	96.97	0.221014492753623	33	1	12	0	148	180	1623071	1623103	Hirudo verbana genome assembly, chromosome: 13	blastn	61	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
17608121	17608121	PRJNA1126198_P_NODE_4114_length_881_cov_6.199257_g3575_i0	PRJNA1126198	4114	881	6.199257	54.61545417	Annelida	6340	Annelida	Annelida	289	6.989999999999998e-94	NR	XP_009021786.1	6412	g3575	i0	57.6	10.6753688989784	243	100	82.4	2	833	108	7	247	XP_009021786.1 hypothetical protein HELRODRAFT_185784 [Helobdella robusta]	diamond	9405	290	0.996551724137931	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
23234027	23234027	PRJNA1126198_P_NODE_429819_length_246_cov_0.890173_g429098_i0	PRJNA1126198	429819	246	0.890173	2.18982558	Hirudo verbana	311461	Annelida	Annelida	56.5	0.002	NTclustered	gi\|2918369614\|emb\|OZ237780.1\|	311461	g429098	i0	90.909	0.178861788617886	44	1	17	3	1	43	14064758	14064717	Hirudo verbana genome assembly, chromosome: 2	blastn	44	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24506993	24506993	PRJNA1126198_P_NODE_11140_length_575_cov_3.272908_g10467_i0	PRJNA1126198	11140	575	3.272908	18.819221	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.016	NTclustered	gi\|2920003644\|emb\|OZ238875.1\|	1046305	g10467	i0	94.444	0.0626086956521739	36	1	6	1	27	61	520190	520155	Ailoscolex lacteospumosus genome assembly, chromosome: 16	blastn	36	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
26943606	26943606	PRJNA1126198_P_NODE_144962_length_315_cov_3.041322_g144243_i0	PRJNA1126198	144962	315	3.041322	9.5801643	Pectinaria gouldii	260746	Annelida	Annelida	115	6.8699999999999996e-31	NR	AKV16229.1	260746	g144243	i0	62.7	1.88571428571429	102	37	96.2	1	303	1	1	102	AKV16229.1 60S ribosomal protein L36 [Pectinaria gouldii]	diamond	594	115	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Pectinariidae	Pectinaria	Pectinaria gouldii
32177616	32177616	PRJNA1126198_P_NODE_143118_length_316_cov_2.333333_g142399_i0	PRJNA1126198	143118	316	2.333333	7.37333228	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	81.3	1.45e-16	NR	ABW23172.1	6344	g142399	i0	80.4	11.9240506329114	51	10	48.4	0	3	155	137	187	ABW23172.1 ribosomal protein rpl18 [Arenicola marina]	diamond	3768	82	0.991463414634146	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina

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