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

10 rows where bioproject = "PRJNA807685" 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
3357516	3357516	PRJNA807685_P_NODE_40883_length_192_cov_1.335484_g39810_i0	PRJNA807685	40883	192	1.335484	2.56412928	Hirudo verbana	311461	Annelida	Annelida	71.3	4.56e-8	NTclustered	gi\|2918369643\|emb\|OZ237784.1\|	311461	g39810	i0	95.556	2.31770833333333	45	0	22	2	67	109	3391269	3391225	Hirudo verbana genome assembly, chromosome: 6	blastn	445	71.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
7184985	7184985	PRJNA807685_P_NODE_58566_length_160_cov_1.422764_g57493_i0	PRJNA807685	58566	160	1.422764	2.2764224	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	67.6	4.74e-7	NTclustered	gi\|2920003608\|emb\|OZ238872.1\|	1046305	g57493	i0	83.784	10.0875	74	8	45	4	13	84	11170802	11170731	Ailoscolex lacteospumosus genome assembly, chromosome: 13	blastn	1614	67.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
7600953	7600953	PRJNA807685_P_NODE_58766_length_160_cov_1.252033_g57693_i0	PRJNA807685	58766	160	1.252033	2.0032528	Metazoa	33208	Annelida	Annelida	60.2	7.93e-5	NTclustered	gi\|675884587\|ref\|XM_009029548.1\|	6412	g57693	i0	100	3.88125	32	0	20	0	88	119	1403	1372	Helobdella robusta hypothetical protein mRNA	blastn	621	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
8459582	8459582	PRJNA807685_P_NODE_3587_length_1443_cov_5.249644_g3021_i0	PRJNA807685	3587	1443	5.249644	75.75236292	Hirudo verbana	311461	Annelida	Annelida	65.8	1.9e-5	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g3021	i0	93.182	3.08801108801109	44	3	3	0	5	48	12951282	12951239	Hirudo verbana genome assembly, chromosome: 4	blastn	4456	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18658092	18658092	PRJNA807685_P_NODE_53995_length_166_cov_1.713178_g52922_i0	PRJNA807685	53995	166	1.713178	2.84387548	Hirudo verbana	311461	Annelida	Annelida	60.2	8.31e-5	NTclustered	gi\|2918369697\|emb\|OZ237786.1\|	311461	g52922	i0	86.792	1.20481927710843	53	7	32	0	114	166	2946928	2946980	Hirudo verbana genome assembly, chromosome: 8	blastn	200	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18658168	18658168	PRJNA807685_P_NODE_67635_length_150_cov_1.734513_g66562_i0	PRJNA807685	67635	150	1.734513	2.6017695	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.012	NTclustered	gi\|2920003323\|emb\|OZ238861.1\|	1046305	g66562	i0	100	0.186666666666667	28	0	19	0	54	81	33041020	33041047	Ailoscolex lacteospumosus genome assembly, chromosome: 2	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
27505612	27505612	PRJNA807685_P_NODE_42023_length_189_cov_1.572368_g40950_i0	PRJNA807685	42023	189	1.572368	2.97177552	Metazoa	33208	Annelida	Annelida	62	2.09e-9	NR	KAI0212821.1	104711	g40950	i0	80	1.61904761904762	35	7	55.6	0	85	189	2	36	KAI0212821.1 N-alpha-acetyltransferase 15, NatA auxiliary subunit [Lamellibrachia satsuma]	diamond	306	62.4	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
29273361	29273361	PRJNA807685_P_NODE_23629_length_277_cov_2.287500_g22556_i0	PRJNA807685	23629	277	2.2875	6.336375	Metazoa	33208	Annelida	Annelida	57.4	3.91e-7	NR	ELU00056.1	283909	g22556	i0	38.8	7.59205776173285	98	49	98.6	4	3	275	735	828	ELU00056.1 hypothetical protein CAPTEDRAFT_195211 [Capitella teleta]	diamond	2103	57.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
30126024	30126024	PRJNA807685_P_NODE_49652_length_173_cov_1.713235_g48579_i0	PRJNA807685	49652	173	1.713235	2.96389655	Metazoa	33208	Annelida	Annelida	99	1.33e-22	NR	KAK2145251.1	53620	g48579	i0	82.7	24.3468208092486	52	9	90.2	0	157	2	110	161	KAK2145251.1 hypothetical protein LSH36_692g01011 [Paralvinella palmiformis]	diamond	4212	99	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30473940	30473940	PRJNA807685_P_NODE_52333_length_169_cov_1.128788_g51260_i0	PRJNA807685	52333	169	1.128788	1.90765172	Metazoa	33208	Annelida	Annelida	49.7	4.57e-5	NR	XP_009024344.1	6412	g51260	i0	64.7	5.37869822485207	34	12	60.4	0	161	60	17	50	XP_009024344.1 hypothetical protein HELRODRAFT_114186 [Helobdella robusta]	diamond	909	50.1	0.992015968063872	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);;