metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA846110" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA846110" 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
3383926	3383926	PRJNA846110_P_NODE_3523_length_552_cov_26.553236_g3282_i0	PRJNA846110	3523	552	26.553236	146.57386272	Phragmatopoma lapidosa	341668	Annelida	Annelida	372	3.67e-98	NTclustered	gi\|700589151\|gb\|KM267711.1\|	341668	g3282	i0	80.483	60.4655797101449	497	88	89	9	60	552	40	531	Phragmatopoma lapidosa clone 329 60S ribosomal protein mRNA, complete cds	blastn	33377	372	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellariidae	Phragmatopoma	Phragmatopoma lapidosa
11036841	11036841	PRJNA846110_P_NODE_4009_length_518_cov_29.557303_g3766_i0	PRJNA846110	4009	518	29.557303	153.10682954	Phragmatopoma lapidosa	341668	Annelida	Annelida	292	2.75e-74	NTclustered	gi\|700589083\|gb\|KM267677.1\|	341668	g3766	i0	81.87	7.91891891891892	353	59	68	4	43	393	407	58	Phragmatopoma lapidosa clone 43 40S ribosomal protein mRNA, complete cds	blastn	4102	292	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellariidae	Phragmatopoma	Phragmatopoma lapidosa
17411189	17411189	PRJNA846110_P_NODE_17994_length_273_cov_1.340000_g17749_i0	PRJNA846110	17994	273	1.34	3.6582	Hirudo verbana	311461	Annelida	Annelida	52.8	0.025	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g17749	i0	100	0.102564102564103	28	0	10	0	51	78	4564904	4564931	Hirudo verbana genome assembly, chromosome: 9	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
25059373	25059373	PRJNA846110_P_NODE_9100_length_352_cov_5.318996_g8856_i0	PRJNA846110	9100	352	5.318996	18.72286592	Pectinaria gouldii	260746	Annelida	Annelida	189	2.4299999999999993e-43	NTclustered	gi\|57904689\|gb\|AY855263.1\|	260746	g8856	i0	86.55	44.5625	171	23	49	0	182	352	560	390	Pectinaria gouldii alpha tubulin mRNA, partial cds	blastn	15686	189	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Pectinariidae	Pectinaria	Pectinaria gouldii

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