metadata: contig_metadata: 9 rows where bioproject = "PRJNA951388", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA951388", 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
14962605	14962605	PRJNA951388_S_NODE_5112_length_371_cov_5.865772_g4985_i0	PRJNA951388	5112	371	5.865772	21.76201412	Lamellibrachia satsuma	104711	Annelida	Annelida	130	1.22e-34	NR	KAI0217027.1	104711	g4985	i0	64.5	2.33692722371968	93	33	75.2	0	14	292	168	260	KAI0217027.1 General transcription factor IIF subunit 2 [Lamellibrachia satsuma]	diamond	867	130	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
18786507	18786507	PRJNA951388_S_NODE_95_length_1434_cov_18.267450_g64_i0	PRJNA951388	95	1434	18.26745	261.955233	Metazoa	33208	Annelida	Annelida	589	1.3199999999999999e-202	NR	XP_009029869.1	6412	g64	i0	70.3	54.8096234309623	489	132	99.8	3	1431	1	73	560	XP_009029869.1 hypothetical protein HELRODRAFT_158018 [Helobdella robusta]	diamond	78597	589	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
20061405	20061405	PRJNA951388_S_NODE_2656_length_468_cov_16.551899_g2529_i0	PRJNA951388	2656	468	16.551899	77.46288732	Metazoa	33208	Annelida	Annelida	162	4.71e-44	NR	CAH1795454.1	6347	g2529	i0	56.4	20.1538461538462	140	60	89.7	1	2	421	379	517	CAH1795454.1 unnamed protein product [Owenia fusiformis]	diamond	9432	163	0.993865030674847	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
26708715	26708715	PRJNA951388_S_NODE_6941_length_323_cov_2.144000_g6814_i0	PRJNA951388	6941	323	2.144	6.92512	Lamellibrachia satsuma	104711	Annelida	Annelida	50.1	8.68e-5	NR	KAI0218916.1	104711	g6814	i0	79.3	0.538699690402477	29	6	26.9	0	138	52	22	50	KAI0218916.1 Vesicle transport protein SFT2A [Lamellibrachia satsuma]	diamond	174	50.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
27601068	27601068	PRJNA951388_S_NODE_4624_length_387_cov_8.328025_g4497_i0	PRJNA951388	4624	387	8.328025	32.22945675	Metazoa	33208	Annelida	Annelida	48.1	0.00172	NR	KAI0237524.1	104711	g4497	i0	38.6	1.26356589147287	83	45	61.2	3	48	284	155	235	KAI0237524.1 Gamma-secretase subunit Aph-1b [Lamellibrachia satsuma]	diamond	489	48.5	0.991752577319588	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
27916440	27916440	PRJNA951388_S_NODE_4805_length_381_cov_8.405844_g4678_i0	PRJNA951388	4805	381	8.405844	32.02626564	Metazoa	33208	Annelida	Annelida	61.2	1.93e-8	NR	XP_009025440.1	6412	g4678	i0	53.4	2.48818897637795	58	27	45.7	0	3	176	120	177	XP_009025440.1 hypothetical protein HELRODRAFT_185077 [Helobdella robusta]	diamond	948	61.6	0.993506493506494	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30531027	30531027	PRJNA951388_S_NODE_4933_length_377_cov_4.467105_g4806_i0	PRJNA951388	4933	377	4.467105	16.84098585	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	60.1	1.5e-7	NR	CAD5116920.1	2664684	g4806	i0	33.9	0.938992042440318	118	73	91.5	2	370	26	1442	1557	CAD5116920.1 DgyrCDS5761 [Dimorphilus gyrociliatus]	diamond	354	60.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
32181912	32181912	PRJNA951388_S_NODE_2058_length_508_cov_17.027586_g1934_i0	PRJNA951388	2058	508	17.027586	86.50013688	Metazoa	33208	Annelida	Annelida	147	1.55e-39	NR	XP_009029093.1	6412	g1934	i0	51.1	5.72244094488189	137	64	80.3	2	505	98	205	339	XP_009029093.1 hypothetical protein HELRODRAFT_185160 [Helobdella robusta]	diamond	2907	147	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32561781	32561781	PRJNA951388_S_NODE_11539_length_239_cov_3.668675_g11412_i0	PRJNA951388	11539	239	3.668675	8.76813325	Metazoa	33208	Annelida	Annelida	102	8.260000000000001e-26	NR	XP_009009516.1	6412	g11412	i0	54.5	53.1087866108787	77	35	96.7	0	4	234	28	104	XP_009009516.1 hypothetical protein HELRODRAFT_62386, partial [Helobdella robusta]	diamond	12693	102	1	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);;