metadata: contig_metadata: 14 rows where bioproject = "PRJNA690234", tax_kingdom = "Metazoa" and tax

14 rows where bioproject = "PRJNA690234", 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
3221289	3221289	PRJNA690234_P_NODE_5183_length_573_cov_2.480000_g4821_i0	PRJNA690234	5183	573	2.48	14.2104	Metazoa	33208	Annelida	Annelida	306	3.4799999999999996e-103	NR	CAH1784968.1	6347	g4821	i0	83.1	167.712041884817	177	30	92.7	0	532	2	50	226	CAH1784968.1 unnamed protein product [Owenia fusiformis]	diamond	96099	308	0.993506493506494	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
13424223	13424223	PRJNA690234_P_NODE_3511_length_704_cov_7.015848_g3164_i0	PRJNA690234	3511	704	7.015848	49.39156992	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	65.8	9.03e-6	NTclustered	gi\|2920003608\|emb\|OZ238872.1\|	1046305	g3164	i0	83.333	0.602272727272727	72	10	10	2	607	677	19159118	19159048	Ailoscolex lacteospumosus genome assembly, chromosome: 13	blastn	424	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
13424236	13424236	PRJNA690234_P_NODE_4191_length_641_cov_3.204225_g3836_i0	PRJNA690234	4191	641	3.204225	20.53908225	Metazoa	33208	Annelida	Annelida	298	1.38e-97	NR	CAH1782863.1	6347	g3836	i0	76.2	86.3307332293292	185	44	86.6	0	87	641	22	206	CAH1782863.1 unnamed protein product [Owenia fusiformis]	diamond	55338	300	0.993333333333333	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
18522071	18522071	PRJNA690234_P_NODE_1775_length_989_cov_8.972707_g1521_i0	PRJNA690234	1775	989	8.972707	88.74007223	Metazoa	33208	Annelida	Annelida	417	2.4299999999999995e-143	NR	XP_009029644.1	6412	g1521	i0	67.3	7.12537917087968	303	99	91.9	0	54	962	1	303	XP_009029644.1 hypothetical protein HELRODRAFT_186151 [Helobdella robusta]	diamond	7047	417	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
22347382	22347382	PRJNA690234_P_NODE_16918_length_309_cov_1.313559_g16551_i0	PRJNA690234	16918	309	1.313559	4.05889731	Opisthokonta	33154	Annelida	Annelida	135	1.11e-34	NR	KAK2165573.1	53620	g16551	i0	67	5.47572815533981	94	31	91.3	0	2	283	81	174	KAK2165573.1 hypothetical protein LSH36_48g03046 [Paralvinella palmiformis]	diamond	1692	135	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
28156447	28156447	PRJNA690234_P_NODE_18305_length_296_cov_1.914798_g17938_i0	PRJNA690234	18305	296	1.914798	5.66780208	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	147	1.73e-38	NR	CAD5112872.1	2664684	g17938	i0	77.6	3.02027027027027	98	21	98.3	1	294	4	780	877	CAD5112872.1 DgyrCDS2083 [Dimorphilus gyrociliatus]	diamond	894	147	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
28483492	28483492	PRJNA690234_P_NODE_11326_length_378_cov_1.265574_g10960_i0	PRJNA690234	11326	378	1.265574	4.78386972	Metazoa	33208	Annelida	Annelida	99.8	1.0799999999999999e-23	NR	XP_009022555.1	6412	g10960	i0	40	10.5238095238095	120	70	93.7	1	24	377	4	123	XP_009022555.1 hypothetical protein HELRODRAFT_67291 [Helobdella robusta]	diamond	3978	100	0.998	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
29714437	29714437	PRJNA690234_P_NODE_10230_length_399_cov_1.196319_g9864_i0	PRJNA690234	10230	399	1.196319	4.77331281	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	110	3.63e-26	NR	XP_009023714.1	6412	g9864	i0	40.3	86.7293233082707	129	77	97	0	12	398	112	240	XP_009023714.1 hypothetical protein HELRODRAFT_84860, partial [Helobdella robusta]	diamond	34605	110	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
29777857	29777857	PRJNA690234_P_NODE_11951_length_367_cov_1.588435_g11584_i0	PRJNA690234	11951	367	1.588435	5.82955645	Metazoa	33208	Annelida	Annelida	108	1.8999999999999998e-24	NR	XP_009030522.1	6412	g11584	i0	49.6	4.59400544959128	113	57	92.4	0	2	340	150	262	XP_009030522.1 hypothetical protein HELRODRAFT_108462 [Helobdella robusta]	diamond	1686	109	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30019386	30019386	PRJNA690234_P_NODE_9391_length_417_cov_2.970930_g9025_i0	PRJNA690234	9391	417	2.97093	12.3887781	Paralvinella palmiformis	53620	Annelida	Annelida	60.1	2.44e-8	NR	KAK2163798.1	53620	g9025	i0	29.2	0.640287769784173	89	63	64	0	268	2	44	132	KAK2163798.1 hypothetical protein LSH36_74g11125 [Paralvinella palmiformis]	diamond	267	60.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30145276	30145276	PRJNA690234_P_NODE_18832_length_292_cov_1.178082_g18465_i0	PRJNA690234	18832	292	1.178082	3.43999944	Paralvinella palmiformis	53620	Annelida	Annelida	99.4	8.300000000000001e-22	NR	KAK2145597.1	53620	g18465	i0	45.3	0.976027397260274	95	52	97.6	0	291	7	100	194	KAK2145597.1 hypothetical protein LSH36_669g01023 [Paralvinella palmiformis]	diamond	285	99.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30461971	30461971	PRJNA690234_P_NODE_1133_length_1229_cov_5.912630_g926_i0	PRJNA690234	1133	1229	5.91263	72.6662227	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	332	1.14e-100	NR	CAD5115251.1	2664684	g926	i0	49.1	4.81366965012205	330	164	79.6	3	1059	82	61	390	CAD5115251.1 DgyrCDS4245 [Dimorphilus gyrociliatus]	diamond	5916	332	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
31757538	31757538	PRJNA690234_P_NODE_9357_length_418_cov_1.814493_g8991_i0	PRJNA690234	9357	418	1.814493	7.58458074	Helobdella robusta	6412	Annelida	Annelida	127	1.31e-33	NR	XP_009019383.1	6412	g8991	i0	48.9	2.00239234449761	139	70	99	1	3	416	5	143	XP_009019383.1 hypothetical protein HELRODRAFT_155763 [Helobdella robusta]	diamond	837	127	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
31863722	31863722	PRJNA690234_P_NODE_6637_length_501_cov_2.829439_g6271_i0	PRJNA690234	6637	501	2.829439	14.17548939	Metazoa	33208	Annelida	Annelida	206	2.08e-64	NR	XP_009023584.1	6412	g6271	i0	56.3	28.9700598802395	167	73	100	0	501	1	3	169	XP_009023584.1 hypothetical protein HELRODRAFT_185850 [Helobdella robusta]	diamond	14514	207	0.995169082125604	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta

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