metadata: contig_metadata: 10 rows where bioproject = "PRJNA909412", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA909412", 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
3441471	3441471	PRJNA909412_P_NODE_16163_length_152_cov_2.221239_g16022_i0	PRJNA909412	16163	152	2.221239	3.37628328	Hirudo verbana	311461	Annelida	Annelida	52.8	0.012	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g16022	i0	100	0.184210526315789	28	0	18	0	68	95	13389006	13388979	Hirudo verbana genome assembly, chromosome: 4	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
12369748	12369748	PRJNA909412_P_NODE_1290_length_490_cov_1.738359_g1151_i0	PRJNA909412	1290	490	1.738359	8.5179591	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	167	1.98e-49	NR	KAK2168654.1	53620	g1151	i0	64.2	21.3061224489796	137	49	83.9	0	67	477	37	173	KAK2168654.1 hypothetical protein LSH36_15g12056 [Paralvinella palmiformis]	diamond	10440	168	0.994047619047619	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
18742185	18742185	PRJNA909412_P_NODE_16055_length_152_cov_2.920354_g15914_i0	PRJNA909412	16055	152	2.920354	4.43893808	Metazoa	33208	Annelida	Annelida	95.9	1.72e-21	NR	KAI0231143.1	104711	g15914	i0	90	57.2368421052632	50	5	98.7	0	2	151	202	251	KAI0231143.1 Serine/threonine-protein phosphatase 4 catalytic subunit [Lamellibrachia satsuma]	diamond	8700	96.7	0.991726990692865	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
25116664	25116664	PRJNA909412_P_NODE_1220_length_507_cov_3.061966_g1082_i0	PRJNA909412	1220	507	3.061966	15.52416762	Metazoa	33208	Annelida	Annelida	238	6.96e-76	NR	XP_009025699.1	6412	g1082	i0	76.6	30.094674556213	154	36	91.1	0	46	507	1	154	XP_009025699.1 hypothetical protein HELRODRAFT_107583 [Helobdella robusta]	diamond	15258	238	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
29739924	29739924	PRJNA909412_P_NODE_17030_length_151_cov_1.580357_g16889_i0	PRJNA909412	17030	151	1.580357	2.38633907	Lamellibrachia satsuma	104711	Annelida	Annelida	82.8	8.1e-17	NR	KAI0212899.1	104711	g16889	i0	72	0.993377483443709	50	14	99.3	0	2	151	213	262	KAI0212899.1 Bifunctional glutamate/proline--tRNA ligase [Lamellibrachia satsuma]	diamond	150	82.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
30055890	30055890	PRJNA909412_P_NODE_17391_length_151_cov_1.169643_g17250_i0	PRJNA909412	17391	151	1.169643	1.76616093	Lamellibrachia satsuma	104711	Annelida	Annelida	53.9	7.32e-7	NR	KAI0224217.1	104711	g17250	i0	53.1	1.94701986754967	49	22	97.4	1	147	1	124	171	KAI0224217.1 Ras-related protein Rab-39A [Lamellibrachia satsuma]	diamond	294	53.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
30561322	30561322	PRJNA909412_P_NODE_14073_length_158_cov_4.336134_g13932_i0	PRJNA909412	14073	158	4.336134	6.85109172	Paralvinella palmiformis	53620	Annelida	Annelida	48.5	1.06e-4	NR	KAK2155293.1	53620	g13932	i0	40.7	1.12025316455696	59	28	98.7	1	158	3	175	233	KAK2155293.1 hypothetical protein LSH36_243g01053 [Paralvinella palmiformis]	diamond	177	48.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31011297	31011297	PRJNA909412_P_NODE_4994_length_233_cov_2.881443_g4853_i0	PRJNA909412	4994	233	2.881443	6.71376219	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	64.7	5.99e-10	NR	UCK81610.1	6344	g4853	i0	62.3	4.76394849785408	53	20	68.2	0	161	3	93	145	UCK81610.1 26S proteasome non-ATPase regulatory subunit 2 [Arenicola marina]	diamond	1110	65.1	0.993855606758833	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
31067292	31067292	PRJNA909412_P_NODE_12535_length_161_cov_3.827869_g12394_i0	PRJNA909412	12535	161	3.827869	6.16286909	Lamellibrachia satsuma	104711	Annelida	Annelida	41.2	0.0435	NR	KAI0232996.1	104711	g12394	i0	66.7	1.00621118012422	27	9	50.3	0	76	156	32	58	KAI0232996.1 hypothetical protein LSAT2_016778 [Lamellibrachia satsuma]	diamond	162	41.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
31952530	31952530	PRJNA909412_P_NODE_12897_length_161_cov_2.819672_g12756_i0	PRJNA909412	12897	161	2.819672	4.53967192	Owenia fusiformis	6347	Annelida	Annelida	49.3	5.92e-5	NR	CAH1788527.1	6347	g12756	i0	52.6	1.67701863354037	38	18	70.8	0	46	159	200	237	CAH1788527.1 unnamed protein product [Owenia fusiformis]	diamond	270	49.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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