metadata: contig_metadata: 19 rows where bioproject = "PRJNA795983", tax_kingdom = "Metazoa" and tax

19 rows where bioproject = "PRJNA795983", 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
4608690	4608690	PRJNA795983_S_NODE_8304_length_416_cov_1.084548_g8179_i0	PRJNA795983	8304	416	1.084548	4.51171968	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	217	8.09e-68	NR	CAH1795352.1	6347	g8179	i0	76.1	161.221153846154	138	33	99.5	0	2	415	129	266	CAH1795352.1 unnamed protein product [Owenia fusiformis]	diamond	67068	219	0.990867579908676	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
10984258	10984258	PRJNA795983_S_NODE_8329_length_415_cov_2.032164_g8204_i0	PRJNA795983	8329	415	2.032164	8.4334806	Metazoa	33208	Annelida	Annelida	184	9.02e-53	NR	XP_009029772.1	6412	g8204	i0	63.5	19.8	137	50	99	0	3	413	331	467	XP_009029772.1 hypothetical protein HELRODRAFT_186162 [Helobdella robusta]	diamond	8217	185	0.994594594594595	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
11420359	11420359	PRJNA795983_S_NODE_11469_length_370_cov_1.626263_g11344_i0	PRJNA795983	11469	370	1.626263	6.0171731	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.035	NTclustered	gi\|2918369614\|emb\|OZ237780.1\|	311461	g11344	i0	100	0.151351351351351	28	0	8	0	146	173	2013497	2013470	Hirudo verbana genome assembly, chromosome: 2	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
13533870	13533870	PRJNA795983_S_NODE_40571_length_244_cov_0.900585_g40446_i0	PRJNA795983	40571	244	0.900585	2.1974274	Hirudo verbana	311461	Annelida	Annelida	52.8	0.022	NTclustered	gi\|2918369614\|emb\|OZ237780.1\|	311461	g40446	i0	100	0.229508196721311	28	0	11	0	210	237	1105981	1105954	Hirudo verbana genome assembly, chromosome: 2	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
15244927	15244927	PRJNA795983_S_NODE_27812_length_275_cov_1.282178_g27687_i0	PRJNA795983	27812	275	1.282178	3.5259895	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.025	NTclustered	gi\|2918369614\|emb\|OZ237780.1\|	311461	g27687	i0	100	0.305454545454545	28	0	10	0	2	29	1956681	1956708	Hirudo verbana genome assembly, chromosome: 2	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18631769	18631769	PRJNA795983_S_NODE_4795_length_509_cov_2.596330_g4671_i0	PRJNA795983	4795	509	2.59633	13.2153197	Hirudo verbana	311461	Annelida	Annelida	63.9	2.3e-5	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g4671	i0	95	8.11198428290766	40	2	8	0	429	468	9641225	9641264	Hirudo verbana genome assembly, chromosome: 7	blastn	4129	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
21182509	21182509	PRJNA795983_S_NODE_20757_length_304_cov_1.025974_g20632_i0	PRJNA795983	20757	304	1.025974	3.11896096	Metazoa	33208	Annelida	Annelida	119	6.399999999999998e-29	NR	CAH1797939.1	6347	g20632	i0	64	4.43092105263158	89	31	87.8	1	267	1	98	185	CAH1797939.1 unnamed protein product [Owenia fusiformis]	diamond	1347	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
23732785	23732785	PRJNA795983_S_NODE_13019_length_354_cov_1.085409_g12894_i0	PRJNA795983	13019	354	1.085409	3.84234786	Hirudo verbana	311461	Annelida	Annelida	54.7	0.009	NTclustered	gi\|2918369720\|emb\|OZ237792.1\|	311461	g12894	i0	100	0.0819209039548023	29	0	8	0	34	62	7031344	7031316	Hirudo verbana genome assembly, chromosome: 14	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
25006490	25006490	PRJNA795983_S_NODE_24940_length_285_cov_1.787736_g24815_i0	PRJNA795983	24940	285	1.787736	5.0950476	Hirudo verbana	311461	Annelida	Annelida	115	3.3100000000000003e-21	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g24815	i0	76.818	73.7964912280702	220	41	75	7	10	224	2704462	2704676	Hirudo verbana genome assembly, chromosome: 12	blastn	21032	115	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
25006501	25006501	PRJNA795983_S_NODE_25960_length_281_cov_2.312500_g25835_i0	PRJNA795983	25960	281	2.3125	6.498125	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	176	2.21e-51	NR	UCK81606.1	6344	g25835	i0	96.7	213.138790035587	92	3	98.2	0	278	3	228	319	UCK81606.1 26S proteasome regulatory subunit 6B [Arenicola marina]	diamond	59892	177	0.994350282485876	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
26619771	26619771	PRJNA795983_S_NODE_30401_length_266_cov_1.974093_g30276_i0	PRJNA795983	30401	266	1.974093	5.25108738	Metazoa	33208	Annelida	Annelida	172	9.77e-51	NR	CAH1789822.1	6347	g30276	i0	98.9	109.172932330827	88	1	99.2	0	1	264	129	216	CAH1789822.1 unnamed protein product [Owenia fusiformis]	diamond	29040	173	0.994219653179191	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27559180	27559180	PRJNA795983_S_NODE_43084_length_241_cov_0.916667_g42959_i0	PRJNA795983	43084	241	0.916667	2.20916747	Lamellibrachia satsuma	104711	Annelida	Annelida	52.8	1.04e-5	NR	KAI0208593.1	104711	g42959	i0	49.3	2.57676348547718	67	27	82.2	4	221	24	4	64	KAI0208593.1 hypothetical protein LSAT2_006741 [Lamellibrachia satsuma]	diamond	621	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
27884222	27884222	PRJNA795983_S_NODE_44465_length_228_cov_2.858065_g44340_i0	PRJNA795983	44465	228	2.858065	6.5163882	Metazoa	33208	Annelida	Annelida	147	2.17e-44	NR	ABC48921.1	6396	g44340	i0	98.7	9.92105263157895	75	1	98.7	0	3	227	3	77	ABC48921.1 calmodulin, partial [Eisenia fetida]	diamond	2262	147	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Eisenia	Eisenia fetida
27915674	27915674	PRJNA795983_S_NODE_38665_length_247_cov_0.885057_g38540_i0	PRJNA795983	38665	247	0.885057	2.18609079	Metazoa	33208	Annelida	Annelida	51.2	5.36e-6	NR	KAK2159534.1	53620	g38540	i0	57.9	2.75708502024291	38	16	46.2	0	9	122	31	68	KAK2159534.1 hypothetical protein LSH36_151g04024 [Paralvinella palmiformis]	diamond	681	51.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
28073589	28073589	PRJNA795983_S_NODE_7565_length_430_cov_1.806723_g7440_i0	PRJNA795983	7565	430	1.806723	7.7689089	Metazoa	33208	Annelida	Annelida	119	1.8399999999999998e-31	NR	CAH1776824.1	6347	g7440	i0	60.2	134.246511627907	98	39	68.4	0	364	71	18	115	CAH1776824.1 unnamed protein product [Owenia fusiformis]	diamond	57726	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28199776	28199776	PRJNA795983_S_NODE_35626_length_251_cov_1.752809_g35501_i0	PRJNA795983	35626	251	1.752809	4.39955059	Opisthokonta	33154	Annelida	Annelida	87.8	1.44e-18	NR	XP_009020629.1	6412	g35501	i0	51.8	4.41035856573705	83	40	99.2	0	251	3	192	274	XP_009020629.1 hypothetical protein HELRODRAFT_185715 [Helobdella robusta]	diamond	1107	88.6	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
29232921	29232921	PRJNA795983_S_NODE_24829_length_286_cov_0.859155_g24704_i0	PRJNA795983	24829	286	0.859155	2.4571833	Owenia fusiformis	6347	Annelida	Annelida	174	1.34e-49	NR	CAH1773112.1	6347	g24704	i0	86.3	10.9615384615385	95	13	99.7	0	1	285	295	389	CAH1773112.1 unnamed protein product [Owenia fusiformis]	diamond	3135	174	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30536918	30536918	PRJNA795983_S_NODE_5833_length_472_cov_4.493734_g5708_i0	PRJNA795983	5833	472	4.493734	21.21042448	Sabellida	6362	Annelida	Annelida	167	1.98e-49	NR	AIU94816.1	341668	g5708	i0	54.5	23.7012711864407	154	69	97.9	1	471	10	33	185	AIU94816.1 40S ribosomal protein [Phragmatopoma lapidosa]	diamond	11187	167	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellariidae	Phragmatopoma	Phragmatopoma lapidosa
31706467	31706467	PRJNA795983_S_NODE_22717_length_294_cov_5.764706_g22592_i0	PRJNA795983	22717	294	5.764706	16.94823564	Metazoa	33208	Annelida	Annelida	105	1.59e-26	NR	KAK2145821.1	53620	g22592	i0	55.9	5.87755102040816	93	39	94.9	1	280	2	22	112	KAK2145821.1 hypothetical protein LSH36_655g01078, partial [Paralvinella palmiformis]	diamond	1728	105	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);;