metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA561212" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA561212" 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
13884558	13884558	PRJNA561212_P_NODE_2811_length_657_cov_6.726027_g2606_i0	PRJNA561212	2811	657	6.726027	44.18999739	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	221	7.42e-70	NR	XP_009021809.1	6412	g2606	i0	56.5	7.63926940639269	186	78	84	2	579	28	1	185	XP_009021809.1 hypothetical protein HELRODRAFT_157417 [Helobdella robusta]	diamond	5019	221	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
15848125	15848125	PRJNA561212_P_NODE_12873_length_311_cov_0.949580_g12662_i0	PRJNA561212	12873	311	0.94958	2.9531938	Opisthokonta	33154	Annelida	Annelida	147	2.4399999999999998e-42	NR	CAH1783142.1	6347	g12662	i0	71.4	23.6430868167203	98	28	94.5	0	303	10	19	116	CAH1783142.1 unnamed protein product, partial [Owenia fusiformis]	diamond	7353	148	0.993243243243243	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27015747	27015747	PRJNA561212_P_NODE_10162_length_346_cov_1.358974_g9951_i0	PRJNA561212	10162	346	1.358974	4.70205004	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	90.1	3.19e-18	NR	CAD5119000.1	2664684	g9951	i0	40.4	3.84971098265896	94	56	81.5	0	342	61	1726	1819	CAD5119000.1 DgyrCDS7656 [Dimorphilus gyrociliatus]	diamond	1332	90.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
27219211	27219211	PRJNA561212_P_NODE_1702_length_829_cov_5.078042_g1515_i0	PRJNA561212	1702	829	5.078042	42.09696818	Metazoa	33208	Annelida	Annelida	143	3.39e-39	NR	ELT90547.1	283909	g1515	i0	62	4.86007237635706	108	41	39.1	0	652	329	20	127	ELT90547.1 hypothetical protein CAPTEDRAFT_219277 [Capitella teleta]	diamond	4029	143	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
27630281	27630281	PRJNA561212_P_NODE_5484_length_472_cov_1.308271_g5273_i0	PRJNA561212	5484	472	1.308271	6.17503912	Opisthokonta	33154	Annelida	Annelida	48.9	0.0025	NR	KAI0220616.1	104711	g5273	i0	33.3	0.75635593220339	57	38	36.2	0	462	292	433	489	KAI0220616.1 Alpha-1,3-mannosyl-glycoprotein 2-beta-N-acetylglucosaminyltransferase [Lamellibrachia satsuma]	diamond	357	49.3	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
27995149	27995149	PRJNA561212_P_NODE_16125_length_281_cov_1.846154_g15914_i0	PRJNA561212	16125	281	1.846154	5.18769274	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	72	1.31e-12	NR	CAD5110963.1	2664684	g15914	i0	38.4	9.98220640569395	86	46	91.8	1	259	2	12	90	CAD5110963.1 DgyrCDS317 [Dimorphilus gyrociliatus]	diamond	2805	72	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
29068760	29068760	PRJNA561212_P_NODE_20328_length_253_cov_0.866667_g20117_i0	PRJNA561212	20328	253	0.866667	2.19266751	Paralvinella palmiformis	53620	Annelida	Annelida	67.4	8.23e-11	NR	KAK2163526.1	53620	g20117	i0	43.1	2.40711462450593	72	40	84.2	1	27	239	20	91	KAK2163526.1 hypothetical protein LSH36_78g04007 [Paralvinella palmiformis]	diamond	609	67.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
29257804	29257804	PRJNA561212_P_NODE_21269_length_251_cov_0.876404_g21058_i0	PRJNA561212	21269	251	0.876404	2.19977404	Owenia fusiformis	6347	Annelida	Annelida	64.7	1.9e-10	NR	CAH1788940.1	6347	g21058	i0	44.6	0.884462151394422	74	37	88.4	2	222	1	6	75	CAH1788940.1 unnamed protein product [Owenia fusiformis]	diamond	222	64.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29478780	29478780	PRJNA561212_P_NODE_19350_length_258_cov_1.589189_g19139_i0	PRJNA561212	19350	258	1.589189	4.10010762	Phragmatopoma lapidosa	341668	Annelida	Annelida	70.1	5.2e-13	NR	AIU94829.1	341668	g19139	i0	59.7	0.779069767441861	67	23	75.6	2	10	204	5	69	AIU94829.1 60S ribosomal protein [Phragmatopoma lapidosa]	diamond	201	70.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellariidae	Phragmatopoma	Phragmatopoma lapidosa
29492946	29492946	PRJNA561212_P_NODE_2070_length_758_cov_1.503650_g1876_i0	PRJNA561212	2070	758	1.50365	11.397667	Opisthokonta	33154	Annelida	Annelida	153	1.3e-41	NR	KAK2179078.1	27915	g1876	i0	47	1.32585751978892	164	85	64.5	2	234	722	83	245	KAK2179078.1 hypothetical protein NP493_515g00001 [Ridgeia piscesae]	diamond	1005	153	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
29921323	29921323	PRJNA561212_P_NODE_19371_length_258_cov_1.410811_g19160_i0	PRJNA561212	19371	258	1.410811	3.63989238	Paralvinella palmiformis	53620	Annelida	Annelida	97.8	1.92e-21	NR	KAK2142671.1	53620	g19160	i0	52.9	13.1627906976744	85	37	95.3	1	7	252	54	138	KAK2142671.1 hypothetical protein LSH36_924g00042 [Paralvinella palmiformis]	diamond	3396	97.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30029940	30029940	PRJNA561212_P_NODE_10711_length_338_cov_1.109434_g10500_i0	PRJNA561212	10711	338	1.109434	3.74988692	Opisthokonta	33154	Annelida	Annelida	129	1.36e-32	NR	KAK2170279.1	53620	g10500	i0	53.8	5.92011834319527	106	49	94.1	0	329	12	42	147	KAK2170279.1 hypothetical protein LSH36_3g02026 [Paralvinella palmiformis]	diamond	2001	129	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30141873	30141873	PRJNA561212_P_NODE_5272_length_481_cov_2.296569_g5061_i0	PRJNA561212	5272	481	2.296569	11.04649689	Ridgeia piscesae	27915	Annelida	Annelida	72.8	1.48e-11	NR	KAK2191952.1	27915	g5061	i0	46.9	1.25987525987526	64	34	39.9	0	479	288	437	500	KAK2191952.1 hypothetical protein NP493_42g10009 [Ridgeia piscesae]	diamond	606	72.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
30346284	30346284	PRJNA561212_P_NODE_4072_length_548_cov_2.597895_g3864_i0	PRJNA561212	4072	548	2.597895	14.2364646	root	1	Root_unresolved	Root_unresolved	141	5.42e-36	NR	CAH1794753.1	6347	g3864	i0	41.1	4.00729927007299	185	87	98	6	539	3	282	450	CAH1794753.1 unnamed protein product, partial [Owenia fusiformis]	diamond	2196	142	0.992957746478873	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30566644	30566644	PRJNA561212_P_NODE_10153_length_346_cov_1.761905_g9942_i0	PRJNA561212	10153	346	1.761905	6.0961913	Metazoa	33208	Annelida	Annelida	72.4	4.54e-12	NR	CAH1781164.1	6347	g9942	i0	58.1	1.03179190751445	62	25	53.8	1	194	9	9	69	CAH1781164.1 unnamed protein product [Owenia fusiformis]	diamond	357	72.8	0.994505494505495	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31357094	31357094	PRJNA561212_P_NODE_25696_length_242_cov_1.455621_g25485_i0	PRJNA561212	25696	242	1.455621	3.52260282	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	97.8	1.55e-21	NR	CAH1799871.1	6347	g25485	i0	73	19.7851239669421	63	17	78.1	0	237	49	644	706	CAH1799871.1 unnamed protein product [Owenia fusiformis]	diamond	4788	97.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31420213	31420213	PRJNA561212_P_NODE_20336_length_253_cov_0.866667_g20125_i0	PRJNA561212	20336	253	0.866667	2.19266751	Opisthokonta	33154	Annelida	Annelida	45.8	0.00319	NR	KAK2149383.1	53620	g20125	i0	45.8	2.85770750988142	48	26	56.9	0	101	244	178	225	KAK2149383.1 hypothetical protein LSH36_454g00002 [Paralvinella palmiformis]	diamond	723	45.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31596324	31596324	PRJNA561212_P_NODE_18356_length_265_cov_1.489583_g18145_i0	PRJNA561212	18356	265	1.489583	3.94739495	Paralvinella palmiformis	53620	Annelida	Annelida	48.5	4.49e-4	NR	KAK2169377.1	53620	g18145	i0	45.6	0.645283018867924	57	28	63.4	2	250	83	144	198	KAK2169377.1 hypothetical protein LSH36_10g02033 [Paralvinella palmiformis]	diamond	171	48.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31659158	31659158	PRJNA561212_P_NODE_17477_length_272_cov_1.095477_g17266_i0	PRJNA561212	17477	272	1.095477	2.97969744	Lamellibrachia satsuma	104711	Annelida	Annelida	70.1	1.28e-11	NR	KAI0233815.1	104711	g17266	i0	61.8	1.22426470588235	55	20	60.7	1	175	11	705	758	KAI0233815.1 CCAAT/enhancer-binding protein zeta [Lamellibrachia satsuma]	diamond	333	70.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma

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