metadata: contig_metadata: 4 rows where bioproject = "PRJNA1248471", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA1248471", 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
6731396	6731396	PRJNA1248471_S_NODE_21986_length_162_cov_0.796460_g21886_i0	PRJNA1248471	21986	162	0.79646	1.2902652	Amynthas corticis	351238	Annelida	Annelida	73.1	1.03e-8	NTclustered	gi\|927371976\|ref\|NC_027832.1\|	351238	g21886	i0	93.75	0.839506172839506	48	3	30	0	77	124	3192	3239	Amynthas corticis mitochondrion, complete genome	blastn	136	73.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Megascolecidae	Amynthas	Amynthas corticis
11832131	11832131	PRJNA1248471_S_NODE_13010_length_190_cov_0.794326_g12910_i0	PRJNA1248471	13010	190	0.794326	1.5092194	Sigambra sp. 2 SH-2024	3120359	Annelida	Annelida	84.2	5.79e-12	NTclustered	gi\|2689264539\|gb\|OR123444.1\|	3120359	g12910	i0	81.081	1.76842105263158	111	15	57	6	77	184	9346	9239	Sigambra sp. 2 SH-2024 voucher SIO:BIC:A10175 mitochondrion, complete genome	blastn	336	84.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Pilargidae	Sigambra	Sigambra sp. 2 SH-2024
29473301	29473301	PRJNA1248471_S_NODE_11170_length_199_cov_0.806667_g11070_i0	PRJNA1248471	11170	199	0.806667	1.60526733	Microphthalmus listensis	142807	Annelida	Annelida	43.1	0.013	NR	QHT64944.1	142807	g11070	i0	71.4	0.422110552763819	28	8	42.2	0	86	3	183	210	QHT64944.1 cytochrome oxidase subunit 2, partial [Microphthalmus listensis]	diamond	84	43.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Hesionidae	Microphthalmus	Microphthalmus listensis
31401029	31401029	PRJNA1248471_S_NODE_3996_length_276_cov_0.757709_g3896_i0	PRJNA1248471	3996	276	0.757709	2.09127684	Capitella teleta	283909	Annelida	Annelida	56.6	2.08e-8	NR	ELU17866.1	283909	g3896	i0	64.6	0.521739130434783	48	8	52.2	1	72	215	1	39	ELU17866.1 hypothetical protein CAPTEDRAFT_109301, partial [Capitella teleta]	diamond	144	56.6	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);;