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

10 rows where bioproject = "PRJNA857857", 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
8497594	8497594	PRJNA857857_P_NODE_14167_length_419_cov_0.832370_g13720_i0	PRJNA857857	14167	419	0.83237	3.4876303	Hirudo verbana	311461	Annelida	Annelida	58.4	8.67e-4	NTclustered	gi\|2918369621\|emb\|OZ237783.1\|	311461	g13720	i0	90.909	8.33890214797136	44	3	10	1	36	78	686924	686881	Hirudo verbana genome assembly, chromosome: 5	blastn	3494	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
11048926	11048926	PRJNA857857_P_NODE_44129_length_246_cov_0.890173_g43680_i0	PRJNA857857	44129	246	0.890173	2.18982558	Hirudo verbana	311461	Annelida	Annelida	56.5	0.002	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g43680	i0	100	0.121951219512195	30	0	12	0	29	58	5567161	5567132	Hirudo verbana genome assembly, chromosome: 12	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
11049034	11049034	PRJNA857857_P_NODE_49389_length_242_cov_1.609467_g48940_i0	PRJNA857857	49389	242	1.609467	3.89491014	Metazoa	33208	Annelida	Annelida	79.7	3.47e-15	NR	KAK2191170.1	27915	g48940	i0	45.8	27.3719008264463	72	39	89.3	0	239	24	93	164	KAK2191170.1 hypothetical protein NP493_57g01029 [Ridgeia piscesae]	diamond	6624	80.1	0.995006242197254	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
15263495	15263495	PRJNA857857_P_NODE_20292_length_347_cov_2.270073_g19843_i0	PRJNA857857	20292	347	2.270073	7.87715331	Metazoa	33208	Annelida	Annelida	230	1.4099999999999995e-55	NTclustered	gi\|86372483\|gb\|DQ300086.1\|	210803	g19843	i0	80.645	88.3832853025937	310	49	88	7	42	347	9	311	Phascolosoma stephensoni isolate DNA100203 histone H3 gene, partial cds	blastn	30669	230	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Sipuncula	Phascolosomatiformes	Phascolosomatidae	Phascolosoma	Phascolosoma stephensoni
23797684	23797684	PRJNA857857_P_NODE_6139_length_627_cov_5.864621_g5719_i0	PRJNA857857	6139	627	5.864621	36.77117367	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	224	7.759999999999999e-72	NR	XP_009028241.1	6412	g5719	i0	76.4	14.7799043062201	140	33	67	0	40	459	8	147	XP_009028241.1 hypothetical protein HELRODRAFT_115475 [Helobdella robusta]	diamond	9267	226	0.991150442477876	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
26611718	26611718	PRJNA857857_P_NODE_13301_length_432_cov_1.501393_g12855_i0	PRJNA857857	13301	432	1.501393	6.48601776	Capitella teleta	283909	Annelida	Annelida	129	1.54e-31	NR	ELT88611.1	283909	g12855	i0	45.4	0.979166666666667	141	71	97.9	3	425	3	481	615	ELT88611.1 hypothetical protein CAPTEDRAFT_195295 [Capitella teleta]	diamond	423	129	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
26991600	26991600	PRJNA857857_P_NODE_52562_length_206_cov_5.225564_g52113_i0	PRJNA857857	52562	206	5.225564	10.76466184	Helobdella robusta	6412	Annelida	Annelida	99.8	1.4000000000000002e-22	NR	XP_009019935.1	6412	g52113	i0	83.1	7.9368932038835	59	10	85.9	0	198	22	418	476	XP_009019935.1 hypothetical protein HELRODRAFT_188740 [Helobdella robusta]	diamond	1635	99.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27979232	27979232	PRJNA857857_P_NODE_17165_length_379_cov_1.424837_g16718_i0	PRJNA857857	17165	379	1.424837	5.40013223	Metazoa	33208	Annelida	Annelida	85.5	1.44e-16	NR	XP_009028227.1	6412	g16718	i0	37.5	10.7651715039578	128	74	96.6	2	13	378	66	193	XP_009028227.1 hypothetical protein HELRODRAFT_115456 [Helobdella robusta]	diamond	4080	85.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28484480	28484480	PRJNA857857_P_NODE_946_length_1391_cov_1.832322_g758_i0	PRJNA857857	946	1391	1.832322	25.48759902	root	1	Root_unresolved	Root_unresolved	51.2	0.0103	NR	CAH1777824.1	6347	g758	i0	37.5	0.638389647735442	64	40	13.8	0	628	437	605	668	CAH1777824.1 unnamed protein product, partial [Owenia fusiformis]	diamond	888	51.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29683902	29683902	PRJNA857857_P_NODE_26150_length_304_cov_0.930736_g25701_i0	PRJNA857857	26150	304	0.930736	2.82943744	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.1	6.39e-8	NR	CAH1794207.1	6347	g25701	i0	38.9	3.53289473684211	90	49	84.9	3	258	1	607	694	CAH1794207.1 unnamed protein product [Owenia fusiformis]	diamond	1074	60.5	0.993388429752066	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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