metadata: contig_metadata: 8 rows where bioproject = "PRJEB75017", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJEB75017", tax_clade = "Opisthokonta" 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
135435	135435	PRJEB75017_P_NODE_9641_length_292_cov_2.237443_g9512_i0	PRJEB75017	9641	292	2.237443	6.53333356	Opisthokonta	33154	Annelida	Annelida	165	1.15e-49	NR	KAI0212693.1	104711	g9512	i0	81.1	39.8732876712329	95	18	97.6	0	8	292	27	121	KAI0212693.1 60S ribosomal protein L10-like [Lamellibrachia satsuma]	diamond	11643	166	0.993975903614458	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
1409998	1409998	PRJEB75017_P_NODE_8202_length_314_cov_1.107884_g8073_i0	PRJEB75017	8202	314	1.107884	3.47875576	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.008	NTclustered	gi\|2920003593\|emb\|OZ238871.1\|	1046305	g8073	i0	100	0.0923566878980892	29	0	9	0	115	143	20725471	20725499	Ailoscolex lacteospumosus genome assembly, chromosome: 12	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
2685395	2685395	PRJEB75017_P_NODE_1323_length_750_cov_3.369276_g1203_i0	PRJEB75017	1323	750	3.369276	25.26957	Helobdella robusta	6412	Annelida	Annelida	62.1	1.25e-4	NTclustered	gi\|675876331\|ref\|XM_009025478.1\|	6412	g1203	i0	94.872	1.404	39	2	5	0	228	266	870	908	Helobdella robusta hypothetical protein partial mRNA	blastn	1053	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
10338378	10338378	PRJEB75017_P_NODE_14149_length_252_cov_1.307263_g14020_i0	PRJEB75017	14149	252	1.307263	3.29430276	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.006	NTclustered	gi\|2920003508\|emb\|OZ238866.1\|	1046305	g14020	i0	100	0.115079365079365	29	0	12	0	213	241	21228423	21228451	Ailoscolex lacteospumosus genome assembly, chromosome: 7	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
23087222	23087222	PRJEB75017_P_NODE_8619_length_307_cov_1.333333_g8490_i0	PRJEB75017	8619	307	1.333333	4.09333231	Metazoa	33208	Annelida	Annelida	100	5e-25	NR	KAI0217071.1	104711	g8490	i0	70	2.19869706840391	60	18	58.6	0	5	184	59	118	KAI0217071.1 40S ribosomal protein S29 [Lamellibrachia satsuma]	diamond	675	101	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
28985185	28985185	PRJEB75017_P_NODE_15748_length_248_cov_1.211429_g15619_i0	PRJEB75017	15748	248	1.211429	3.00434392	Metazoa	33208	Annelida	Annelida	58.5	1.01e-7	NR	CAH1773934.1	6347	g15619	i0	52	12.5806451612903	50	24	60.5	0	247	98	332	381	CAH1773934.1 unnamed protein product [Owenia fusiformis]	diamond	3120	58.9	0.99320882852292	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30539662	30539662	PRJEB75017_P_NODE_7033_length_336_cov_2.060837_g6904_i0	PRJEB75017	7033	336	2.060837	6.92441232	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	72.8	3.11e-12	NR	CAD5113280.1	2664684	g6904	i0	55.6	0.482142857142857	54	24	48.2	0	336	175	414	467	CAD5113280.1 DgyrCDS2458 [Dimorphilus gyrociliatus]	diamond	162	72.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
30602741	30602741	PRJEB75017_P_NODE_10673_length_282_cov_1.492823_g10544_i0	PRJEB75017	10673	282	1.492823	4.20976086	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	49.7	2.17e-4	NR	CAD5123037.1	2664684	g10544	i0	38.3	0.861702127659574	81	45	81.9	2	269	39	935	1014	CAD5123037.1 DgyrCDS11420 [Dimorphilus gyrociliatus]	diamond	243	49.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus

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