metadata: contig_metadata: 5 rows where bioproject = "PRJNA169559" and tax

5 rows where bioproject = "PRJNA169559" 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
1054830	1054830	PRJNA169559_P_NODE_11581_length_495_cov_2.427039_g9747_i0	PRJNA169559	11581	495	2.427039	12.01384305	root	1	Root_unresolved	Root_unresolved	133	2.61e-33	NR	KAK2189433.1	27915	g9747	i0	54.1	16.2424242424242	133	54	76.4	2	382	5	341	473	KAK2189433.1 hypothetical protein NP493_106g00021 [Ridgeia piscesae]	diamond	8040	133	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
4192049	4192049	PRJNA169559_P_NODE_24184_length_312_cov_2.805654_g22108_i0	PRJNA169559	24184	312	2.805654	8.75364048	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	71.3	8.05e-8	NTclustered	gi\|2920003527\|emb\|OZ238867.1\|	1046305	g22108	i0	90.566	1.79807692307692	53	5	17	0	172	224	20169963	20169911	Ailoscolex lacteospumosus genome assembly, chromosome: 8	blastn	561	71.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
11843744	11843744	PRJNA169559_P_NODE_48190_length_163_cov_1.589552_g46113_i0	PRJNA169559	48190	163	1.589552	2.59096976	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	110	1.03e-27	NR	CAD5121000.1	2664684	g46113	i0	84.2	1.04907975460123	57	6	99.4	1	163	2	61	117	CAD5121000.1 DgyrCDS9544 [Dimorphilus gyrociliatus]	diamond	171	110	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
15667838	15667838	PRJNA169559_P_NODE_27253_length_281_cov_2.349206_g25177_i0	PRJNA169559	27253	281	2.349206	6.60126886	Helobdella robusta	6412	Annelida	Annelida	60.2	1.55e-4	NTclustered	gi\|675875705\|ref\|XM_009025165.1\|	6412	g25177	i0	87.273	12.1423487544484	55	3	19	4	35	87	3351	3299	Helobdella robusta hypothetical protein mRNA	blastn	3412	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
24591333	24591333	PRJNA169559_P_NODE_34940_length_247_cov_10.555046_g32863_i0	PRJNA169559	34940	247	10.555046	26.07096362	Hirudo verbana	311461	Annelida	Annelida	58.4	4.8e-4	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g32863	i0	97.059	0.396761133603239	34	1	14	0	2	35	2105466	2105499	Hirudo verbana genome assembly, chromosome: 9	blastn	98	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana

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