metadata: contig_metadata: 5 rows where bioproject = "PRJNA763243", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA763243", 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
12685014	12685014	PRJNA763243_P_NODE_68190_length_228_cov_2.051613_g67844_i0	PRJNA763243	68190	228	2.051613	4.67767764	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	102	1.99e-17	NTclustered	gi\|111559331\|gb\|DQ790066.1\|	1037239	g67844	i0	92.857	36.2412280701754	70	5	31	0	1	70	1065	996	Terebellides stroemi 28S large subunit ribosomal RNA gene, partial sequence	blastn	8263	102	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Trichobranchidae	Terebellides	Terebellides stroemii
21145734	21145734	PRJNA763243_P_NODE_34797_length_291_cov_2.059633_g34451_i0	PRJNA763243	34797	291	2.059633	5.99353203	Hirudo verbana	311461	Annelida	Annelida	56.5	0.002	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g34451	i0	94.595	0.25085910652921	37	0	12	2	148	182	13278400	13278364	Hirudo verbana genome assembly, chromosome: 1	blastn	73	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
22420892	22420892	PRJNA763243_P_NODE_53878_length_249_cov_1.295455_g53532_i0	PRJNA763243	53878	249	1.295455	3.22568295	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	108	3.6499999999999998e-25	NR	CAD5118409.1	2664684	g53532	i0	65.4	0.939759036144578	78	27	94	0	238	5	184	261	CAD5118409.1 DgyrCDS7118 [Dimorphilus gyrociliatus]	diamond	234	108	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
26682840	26682840	PRJNA763243_P_NODE_13501_length_416_cov_2.588921_g13156_i0	PRJNA763243	13501	416	2.588921	10.76991136	Opisthokonta	33154	Annelida	Annelida	154	6.47e-42	NR	CAH1801246.1	6347	g13156	i0	52.2	7.78846153846154	136	63	97.4	2	1	405	193	327	CAH1801246.1 unnamed protein product [Owenia fusiformis]	diamond	3240	154	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28316515	28316515	PRJNA763243_P_NODE_33566_length_295_cov_1.463964_g33220_i0	PRJNA763243	33566	295	1.463964	4.3186938	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	67.8	1.12e-10	NR	CAD5115146.1	2664684	g33220	i0	49.2	0.661016949152542	65	33	66.1	0	2	196	5	69	CAD5115146.1 DgyrCDS4150 [Dimorphilus gyrociliatus]	diamond	195	67.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus

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