metadata: contig_metadata: 10 rows where bioproject = "PRJNA929522", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA929522", tax_clade = "Opisthokonta" 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
13658972	13658972	PRJNA929522_S_NODE_1971_length_474_cov_2.201995_g1901_i0	PRJNA929522	1971	474	2.201995	10.4374563	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	197	4.39e-61	NR	XP_009021936.1	6412	g1901	i0	66.2	45.2025316455696	136	46	86.1	0	416	9	5	140	XP_009021936.1 hypothetical protein HELRODRAFT_185778 [Helobdella robusta]	diamond	21426	197	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
20379782	20379782	PRJNA929522_S_NODE_376_length_966_cov_3.079507_g335_i0	PRJNA929522	376	966	3.079507	29.74803762	Clitellata	42113	Annelida	Annelida	56.5	0.008	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g335	i0	100	0.10351966873706	30	0	3	0	47	76	1460732	1460703	Hirudo verbana genome assembly, chromosome: 7	blastn	100	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
22582482	22582482	PRJNA929522_S_NODE_9118_length_247_cov_0.885057_g9048_i0	PRJNA929522	9118	247	0.885057	2.18609079	Hirudo verbana	311461	Annelida	Annelida	60.2	1.33e-4	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g9048	i0	92.857	11.5303643724696	42	2	17	1	59	99	2414322	2414363	Hirudo verbana genome assembly, chromosome: 9	blastn	2848	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
23857729	23857729	PRJNA929522_S_NODE_8999_length_248_cov_0.874286_g8929_i0	PRJNA929522	8999	248	0.874286	2.16822928	Hirudo verbana	311461	Annelida	Annelida	56.5	0.002	NTclustered	gi\|2918369614\|emb\|OZ237780.1\|	311461	g8929	i0	100	4.03629032258065	30	0	13	0	108	137	14367229	14367258	Hirudo verbana genome assembly, chromosome: 2	blastn	1001	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
26651823	26651823	PRJNA929522_S_NODE_2941_length_390_cov_1.772871_g2871_i0	PRJNA929522	2941	390	1.772871	6.9141969	Metazoa	33208	Annelida	Annelida	142	5.12e-38	NR	CAH1773934.1	6347	g2871	i0	59.5	25.5538461538462	121	45	91.5	2	357	1	232	350	CAH1773934.1 unnamed protein product [Owenia fusiformis]	diamond	9966	142	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27126352	27126352	PRJNA929522_S_NODE_3502_length_359_cov_2.772727_g3432_i0	PRJNA929522	3502	359	2.772727	9.95408993	Opisthokonta	33154	Annelida	Annelida	101	4.16e-22	NR	CAH1774739.1	6347	g3432	i0	46.7	6.01671309192201	120	60	99.4	3	3	359	237	353	CAH1774739.1 unnamed protein product [Owenia fusiformis]	diamond	2160	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27443139	27443139	PRJNA929522_S_NODE_5763_length_294_cov_1.045249_g5693_i0	PRJNA929522	5763	294	1.045249	3.07303206	Metazoa	33208	Annelida	Annelida	48.5	6.02e-4	NR	CAH1774461.1	6347	g5693	i0	43.9	1.5	41	23	41.8	0	153	31	309	349	CAH1774461.1 unnamed protein product [Owenia fusiformis]	diamond	441	48.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29172465	29172465	PRJNA929522_S_NODE_9749_length_243_cov_1.217647_g9679_i0	PRJNA929522	9749	243	1.217647	2.95888221	Capitella teleta	283909	Annelida	Annelida	118	6.599999999999998e-29	NR	ELU13723.1	283909	g9679	i0	73.3	0.925925925925926	75	20	92.6	0	239	15	72	146	ELU13723.1 hypothetical protein CAPTEDRAFT_150692 [Capitella teleta]	diamond	225	118	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
31446995	31446995	PRJNA929522_S_NODE_9176_length_247_cov_0.867816_g9106_i0	PRJNA929522	9176	247	0.867816	2.14350552	Paralvinella palmiformis	53620	Annelida	Annelida	50.4	7.46e-5	NR	KAK2145410.1	53620	g9106	i0	36.5	1.78542510121457	74	47	89.9	0	245	24	566	639	KAK2145410.1 hypothetical protein LSH36_684g01026 [Paralvinella palmiformis]	diamond	441	50.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
32174744	32174744	PRJNA929522_S_NODE_3058_length_382_cov_2.148867_g2988_i0	PRJNA929522	3058	382	2.148867	8.20867194	Owenia fusiformis	6347	Annelida	Annelida	101	1e-24	NR	CAH1790108.1	6347	g2988	i0	51.5	1.66492146596859	99	41	73.8	3	48	329	38	134	CAH1790108.1 unnamed protein product [Owenia fusiformis]	diamond	636	101	1	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);;