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

10 rows where bioproject = "PRJNA800090" 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
4626487	4626487	PRJNA800090_P_NODE_177864_length_234_cov_0.872727_g175679_i0	PRJNA800090	177864	234	0.872727	2.04218118	Helobdella robusta	6412	Annelida	Annelida	56.5	0.002	NTclustered	gi\|85060524\|gb\|AC171133.2\|	6412	g175679	i0	94.595	0.277777777777778	37	1	16	1	83	119	97929	97894	Helobdella robusta clone CH306-1A4, complete sequence	blastn	65	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
7177822	7177822	PRJNA800090_P_NODE_63286_length_435_cov_1.393443_g61102_i0	PRJNA800090	63286	435	1.393443	6.06147705	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.042	NTclustered	gi\|2920003527\|emb\|OZ238867.1\|	1046305	g61102	i0	100	0.064367816091954	28	0	6	0	4	31	27018770	27018797	Ailoscolex lacteospumosus genome assembly, chromosome: 8	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
8452324	8452324	PRJNA800090_P_NODE_56107_length_470_cov_1.977556_g53923_i0	PRJNA800090	56107	470	1.977556	9.2945132	Opisthokonta	33154	Annelida	Annelida	236	1.49e-75	NR	CAH1782245.1	6347	g53923	i0	67.9	65.6936170212766	156	50	99.6	0	1	468	5	160	CAH1782245.1 unnamed protein product [Owenia fusiformis]	diamond	30876	238	0.991596638655462	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
18649585	18649585	PRJNA800090_P_NODE_178655_length_233_cov_1.756098_g176470_i0	PRJNA800090	178655	233	1.756098	4.09170834	Hirudo verbana	311461	Annelida	Annelida	54.7	0.006	NTclustered	gi\|2918369697\|emb\|OZ237786.1\|	311461	g176470	i0	92.105	1.1244635193133	38	3	16	0	22	59	1404488	1404525	Hirudo verbana genome assembly, chromosome: 8	blastn	262	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18649926	18649926	PRJNA800090_P_NODE_194435_length_226_cov_2.751592_g192250_i0	PRJNA800090	194435	226	2.751592	6.21859792	Hirudo verbana	311461	Annelida	Annelida	58.4	4.32e-4	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g192250	i0	94.595	0.163716814159292	37	2	16	0	101	137	9719734	9719770	Hirudo verbana genome assembly, chromosome: 7	blastn	37	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
19926914	19926914	PRJNA800090_P_NODE_90196_length_347_cov_1.935252_g88011_i0	PRJNA800090	90196	347	1.935252	6.71532444	Hirudo verbana	311461	Annelida	Annelida	52.8	0.033	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g88011	i0	100	0.0806916426512968	28	0	8	0	173	200	13398909	13398882	Hirudo verbana genome assembly, chromosome: 4	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
21202928	21202928	PRJNA800090_S_NODE_20657_length_275_cov_0.951456_g20545_i0	PRJNA800090	20657	275	0.951456	2.616504	Hirudo medicinalis	6421	Annelida	Annelida	303	6.32e-78	NTclustered	gi\|404503289\|emb\|HE962521.1\|	6421	g20545	i0	86.545	100.763636363636	275	37	100	0	1	275	560	286	Hirudo medicinalis partial mRNA for putative heat shock protein-70kDa (hsp70 gene), clone 1AA3	blastn	27710	303	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo medicinalis
27591425	27591425	PRJNA800090_P_NODE_182064_length_232_cov_0.895706_g179879_i0	PRJNA800090	182064	232	0.895706	2.07803792	Owenia fusiformis	6347	Annelida	Annelida	77	2.72e-14	NR	CAH1773070.1	6347	g179879	i0	42.2	6.60775862068965	83	41	98.3	1	2	229	8	90	CAH1773070.1 unnamed protein product [Owenia fusiformis]	diamond	1533	77	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30243811	30243811	PRJNA800090_P_NODE_172832_length_236_cov_0.874251_g170647_i0	PRJNA800090	172832	236	0.874251	2.06323236	Lamellibrachia satsuma	104711	Annelida	Annelida	97.1	2.6500000000000003e-21	NR	KAI0214031.1	104711	g170647	i0	62.3	14.6822033898305	77	29	97.9	0	2	232	70	146	KAI0214031.1 hypothetical protein LSAT2_000874 [Lamellibrachia satsuma]	diamond	3465	97.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
30275524	30275524	PRJNA800090_P_NODE_104172_length_318_cov_1.493976_g101987_i0	PRJNA800090	104172	318	1.493976	4.75084368	Capitella teleta	283909	Annelida	Annelida	42.4	0.0294	NR	ELU13942.1	283909	g101987	i0	37.7	0.575471698113208	61	36	57.5	1	312	130	41	99	ELU13942.1 hypothetical protein CAPTEDRAFT_86332, partial [Capitella teleta]	diamond	183	42.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta

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