metadata: contig_metadata: 10 rows where bioproject = "PRJNA529241" and tax

10 rows where bioproject = "PRJNA529241" 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
3052268	3052268	PRJNA529241_P_NODE_458663_length_154_cov_0.974359_g456341_i0	PRJNA529241	458663	154	0.974359	1.50051286	Hirudo verbana	311461	Annelida	Annelida	52.8	0.013	NTclustered	gi\|2918369643\|emb\|OZ237784.1\|	311461	g456341	i0	100	0.181818181818182	28	0	18	0	79	106	2631511	2631538	Hirudo verbana genome assembly, chromosome: 6	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
3053566	3053566	PRJNA529241_P_NODE_82103_length_236_cov_6.859296_g79781_i0	PRJNA529241	82103	236	6.859296	16.18793856	Hirudo verbana	311461	Annelida	Annelida	58.4	4.55e-4	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g79781	i0	94.595	1.24576271186441	37	2	16	0	3	39	582778	582814	Hirudo verbana genome assembly, chromosome: 1	blastn	294	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
6876563	6876563	PRJNA529241_P_NODE_169206_length_177_cov_1.392857_g166884_i0	PRJNA529241	169206	177	1.392857	2.46535689	Hirudo verbana	311461	Annelida	Annelida	58.4	3.21e-4	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g166884	i0	100	90.135593220339	31	0	18	0	79	109	2617912	2617882	Hirudo verbana genome assembly, chromosome: 4	blastn	15954	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
10702385	10702385	PRJNA529241_P_NODE_129129_length_197_cov_0.968750_g126807_i0	PRJNA529241	129129	197	0.96875	1.9084375	Hirudo verbana	311461	Annelida	Annelida	56.5	0.001	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g126807	i0	100	6.9238578680203	30	0	15	0	51	80	2430516	2430487	Hirudo verbana genome assembly, chromosome: 12	blastn	1364	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
13254402	13254402	PRJNA529241_P_NODE_39151_length_326_cov_6.290657_g36832_i0	PRJNA529241	39151	326	6.290657	20.50754182	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.031	NTclustered	gi\|2920003545\|emb\|OZ238868.1\|	1046305	g36832	i0	100	0.0858895705521472	28	0	9	0	242	269	14749510	14749537	Ailoscolex lacteospumosus genome assembly, chromosome: 9	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
13255035	13255035	PRJNA529241_P_NODE_454751_length_155_cov_1.322034_g452429_i0	PRJNA529241	454751	155	1.322034	2.0491527	Hirudo verbana	311461	Annelida	Annelida	52.8	0.013	NTclustered	gi\|2918369706\|emb\|OZ237788.1\|	311461	g452429	i0	100	0.180645161290323	28	0	18	0	46	73	5988954	5988927	Hirudo verbana genome assembly, chromosome: 10	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
23450635	23450635	PRJNA529241_P_NODE_122039_length_201_cov_3.359756_g119717_i0	PRJNA529241	122039	201	3.359756	6.75310956	Hirudo verbana	311461	Annelida	Annelida	56.5	0.001	NTclustered	gi\|2918369710\|emb\|OZ237789.1\|	311461	g119717	i0	96.97	0.641791044776119	33	1	16	0	151	183	3337457	3337425	Hirudo verbana genome assembly, chromosome: 11	blastn	129	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24725350	24725350	PRJNA529241_P_NODE_23200_length_441_cov_14.316832_g20929_i0	PRJNA529241	23200	441	14.316832	63.13722912	Hirudo verbana	311461	Annelida	Annelida	60.2	2.55e-4	NTclustered	gi\|2918369616\|emb\|OZ237781.1\|	311461	g20929	i0	97.143	2.3015873015873	35	1	8	0	255	289	13955279	13955245	Hirudo verbana genome assembly, chromosome: 3	blastn	1015	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24725413	24725413	PRJNA529241_P_NODE_239860_length_173_cov_4.683824_g237538_i0	PRJNA529241	239860	173	4.683824	8.10301552	Hirudo verbana	311461	Annelida	Annelida	62.1	2.41e-5	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g237538	i0	100	4.61849710982659	33	0	19	0	99	131	7358513	7358481	Hirudo verbana genome assembly, chromosome: 1	blastn	799	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24725614	24725614	PRJNA529241_P_NODE_268980_length_173_cov_4.036765_g266658_i0	PRJNA529241	268980	173	4.036765	6.98360345	Hirudo verbana	311461	Annelida	Annelida	52.8	0.015	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g266658	i0	96.875	0.184971098265896	32	0	18	1	18	48	2764595	2764626	Hirudo verbana genome assembly, chromosome: 13	blastn	32	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana

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