metadata: contig_metadata: 10 rows where bioproject = "PRJNA781196", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA781196", 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
5862862	5862862	PRJNA781196_P_NODE_46305_length_263_cov_1.447368_g45928_i0	PRJNA781196	46305	263	1.447368	3.80657784	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.024	NTclustered	gi\|2920003323\|emb\|OZ238861.1\|	1046305	g45928	i0	100	0.106463878326996	28	0	11	0	38	65	41183711	41183684	Ailoscolex lacteospumosus genome assembly, chromosome: 2	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
13513215	13513215	PRJNA781196_P_NODE_44171_length_269_cov_1.989796_g43794_i0	PRJNA781196	44171	269	1.989796	5.35255124	Hirudo verbana	311461	Annelida	Annelida	52.8	0.025	NTclustered	gi\|2918369710\|emb\|OZ237789.1\|	311461	g43794	i0	100	0.104089219330855	28	0	10	0	147	174	7605754	7605727	Hirudo verbana genome assembly, chromosome: 11	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18610863	18610863	PRJNA781196_P_NODE_3495_length_807_cov_3.786104_g3171_i0	PRJNA781196	3495	807	3.786104	30.55385928	Metazoa	33208	Annelida	Annelida	297	4.04e-97	NR	CAH1793798.1	6347	g3171	i0	67.4	17.5687732342007	215	70	79.9	0	801	157	1	215	CAH1793798.1 unnamed protein product [Owenia fusiformis]	diamond	14178	298	0.996644295302013	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
22436874	22436874	PRJNA781196_P_NODE_54818_length_250_cov_0.881356_g54441_i0	PRJNA781196	54818	250	0.881356	2.20339	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	56.5	0.002	NTclustered	gi\|2920003593\|emb\|OZ238871.1\|	1046305	g54441	i0	96.97	1.8	33	1	13	0	97	129	19917839	19917871	Ailoscolex lacteospumosus genome assembly, chromosome: 12	blastn	450	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
24985666	24985666	PRJNA781196_P_NODE_30520_length_318_cov_1.077551_g30143_i0	PRJNA781196	30520	318	1.077551	3.42661218	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.03	NTclustered	gi\|2920003636\|emb\|OZ238874.1\|	1046305	g30143	i0	100	0.0880503144654088	28	0	9	0	89	116	13990980	13991007	Ailoscolex lacteospumosus genome assembly, chromosome: 15	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
26809807	26809807	PRJNA781196_P_NODE_54181_length_250_cov_1.322034_g53804_i0	PRJNA781196	54181	250	1.322034	3.305085	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99	1.1799999999999999e-23	NR	CAH1772408.1	6347	g53804	i0	67.1	21.168	79	26	94.8	0	249	13	94	172	CAH1772408.1 unnamed protein product, partial [Owenia fusiformis]	diamond	5292	99.8	0.991983967935872	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
26967910	26967910	PRJNA781196_P_NODE_31262_length_314_cov_1.908714_g30885_i0	PRJNA781196	31262	314	1.908714	5.99336196	Annelida	6340	Annelida	Annelida	95.5	6.12e-22	NR	CCD27757.1	210783	g30885	i0	55.3	9.07643312101911	103	45	97.5	1	314	9	91	193	CCD27757.1 ribosomal protein l13, partial [Apionsoma misakianum]	diamond	2850	95.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Sipuncula	Phascolosomatiformes	Phascolosomatidae	Apionsoma	Apionsoma misakianum
29368211	29368211	PRJNA781196_P_NODE_46829_length_261_cov_2.734043_g46452_i0	PRJNA781196	46829	261	2.734043	7.13585223	Metazoa	33208	Annelida	Annelida	107	5.53e-27	NR	XP_009021316.1	6412	g46452	i0	66.3	50.7586206896552	86	29	98.9	0	3	260	71	156	XP_009021316.1 hypothetical protein HELRODRAFT_101069 [Helobdella robusta]	diamond	13248	107	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32402560	32402560	PRJNA781196_P_NODE_62299_length_245_cov_0.906977_g61922_i0	PRJNA781196	62299	245	0.906977	2.22209365	Opisthokonta	33154	Annelida	Annelida	66.2	1.74e-10	NR	KAK2151706.1	53620	g61922	i0	43.3	3.90612244897959	90	39	96.7	3	243	7	229	317	KAK2151706.1 hypothetical protein LSH36_354g03044 [Paralvinella palmiformis]	diamond	957	66.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
32740402	32740402	PRJNA781196_P_NODE_28960_length_325_cov_1.198413_g28583_i0	PRJNA781196	28960	325	1.198413	3.89484225	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	46.6	0.0038	NR	CAD5113051.1	2664684	g28583	i0	35	1.28307692307692	60	30	47.1	1	154	2	20	79	CAD5113051.1 DgyrCDS2248 [Dimorphilus gyrociliatus]	diamond	417	46.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus

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