metadata: contig_metadata: 5 rows where bioproject = "PRJEB12982", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJEB12982", 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
2570761	2570761	PRJEB12982_P_NODE_13863_length_187_cov_1.775362_g13700_i0	PRJEB12982	13863	187	1.775362	3.31992694	Lumbriculus sp. EZ-2019	2480966	Annelida	Annelida	320	3.97e-83	NTclustered	gi\|1494622620\|gb\|MK076419.1\|	2480966	g13700	i0	97.838	76.0160427807487	185	4	99	0	3	187	3458	3274	Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence	blastn	14215	320	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Lumbriculida	Lumbriculidae	Lumbriculus	Lumbriculus sp. EZ-2019
5123451	5123451	PRJEB12982_P_NODE_7845_length_258_cov_1.296651_g7682_i0	PRJEB12982	7845	258	1.296651	3.3453595800000002	Aeolosoma viride	394736	Annelida	Annelida	195	3.69e-45	NTclustered	gi\|1151119859\|gb\|KY079093.1\|	394736	g7682	i0	84.694	27.7441860465116	196	29	76	1	19	214	260	66	Aeolosoma viride beta-tubulin isoform 1 mRNA, complete cds	blastn	7158	195	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma viride
15013551	15013551	PRJEB12982_P_NODE_4352_length_362_cov_1.939297_g4189_i0	PRJEB12982	4352	362	1.939297	7.02025514	root	1	Root_unresolved	Root_unresolved	60.2	2.05e-4	NTclustered	gi\|440586614\|emb\|HE971740.1\|	6359	g4189	i0	100	10.0773480662983	32	0	9	0	331	362	7	38	Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene)	blastn	3648	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
22972899	22972899	PRJEB12982_P_NODE_16819_length_167_cov_0.864407_g16656_i0	PRJEB12982	16819	167	0.864407	1.44355969	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	62.1	2.33e-5	NTclustered	gi\|2920003371\|emb\|OZ238862.1\|	1046305	g16656	i0	92.857	5.50299401197605	42	3	25	0	72	113	6462940	6462981	Ailoscolex lacteospumosus genome assembly, chromosome: 3	blastn	919	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
29054282	29054282	PRJEB12982_P_NODE_16048_length_171_cov_2.508197_g15885_i0	PRJEB12982	16048	171	2.508197	4.28901687	Owenia fusiformis	6347	Annelida	Annelida	52.4	4.01e-6	NR	CAH1800061.1	6347	g15885	i0	51.8	0.982456140350877	56	25	94.7	1	7	168	11	66	CAH1800061.1 unnamed protein product, partial [Owenia fusiformis]	diamond	168	52.4	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);;