metadata: contig_metadata: 10 rows where bioproject = "PRJNA1123309" and tax

10 rows where bioproject = "PRJNA1123309" 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
278487	278487	PRJNA1123309_P_NODE_46121_length_255_cov_1.252747_g45741_i0	PRJNA1123309	46121	255	1.252747	3.19450485	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	155	3.5399999999999992e-43	NR	CAH1783597.1	6347	g45741	i0	89.4	25.9882352941176	85	9	100	0	255	1	21	105	CAH1783597.1 unnamed protein product [Owenia fusiformis]	diamond	6627	155	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
4105551	4105551	PRJNA1123309_P_NODE_51564_length_250_cov_3.412429_g51184_i0	PRJNA1123309	51564	250	3.412429	8.5310725	Helobdella robusta	6412	Annelida	Annelida	56.5	0.002	NTclustered	gi\|675849589\|ref\|XM_009012107.1\|	6412	g51184	i0	100	0.12	30	0	12	0	179	208	28	57	Helobdella robusta hypothetical protein partial mRNA	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
10481670	10481670	PRJNA1123309_P_NODE_14809_length_401_cov_0.865854_g14432_i0	PRJNA1123309	14809	401	0.865854	3.47207454	Owenia fusiformis	6347	Annelida	Annelida	150	2.93e-39	NR	CAH1789021.1	6347	g14432	i0	52.7	6.59850374064838	148	54	99.5	4	3	401	465	611	CAH1789021.1 unnamed protein product [Owenia fusiformis]	diamond	2646	150	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
13782251	13782251	PRJNA1123309_P_NODE_27271_length_310_cov_1.308017_g26891_i0	PRJNA1123309	27271	310	1.308017	4.0548527	root	1	Root_unresolved	Root_unresolved	54.7	0.008	NTclustered	gi\|2920003623\|emb\|OZ238873.1\|	1046305	g26891	i0	100	0.27741935483871	29	0	9	0	25	53	17185339	17185311	Ailoscolex lacteospumosus genome assembly, chromosome: 14	blastn	86	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
15581066	15581066	PRJNA1123309_P_NODE_28653_length_303_cov_1.360870_g28273_i0	PRJNA1123309	28653	303	1.36087	4.1234361	Paralvinella palmiformis	53620	Annelida	Annelida	82.8	7.28e-18	NR	KAK2143623.1	53620	g28273	i0	58.8	0.673267326732673	68	23	67.3	1	210	7	4	66	KAK2143623.1 hypothetical protein LSH36_825g03002 [Paralvinella palmiformis]	diamond	204	82.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
16855767	16855767	PRJNA1123309_P_NODE_5854_length_607_cov_1.586142_g5502_i0	PRJNA1123309	5854	607	1.586142	9.62788194	Hirudo verbana	311461	Annelida	Annelida	56.5	0.005	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g5502	i0	100	0.0494233937397035	30	0	5	0	327	356	457494	457465	Hirudo verbana genome assembly, chromosome: 13	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
23230669	23230669	PRJNA1123309_P_NODE_40479_length_269_cov_1.852041_g40099_i0	PRJNA1123309	40479	269	1.852041	4.98199029	Hirudo verbana	311461	Annelida	Annelida	58.4	5.3e-4	NTclustered	gi\|2918369720\|emb\|OZ237792.1\|	311461	g40099	i0	94.595	1.57992565055762	37	2	14	0	5	41	7753599	7753563	Hirudo verbana genome assembly, chromosome: 14	blastn	425	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
26710886	26710886	PRJNA1123309_P_NODE_58941_length_246_cov_0.901734_g58561_i0	PRJNA1123309	58941	246	0.901734	2.21826564	Sabellida	6362	Annelida	Annelida	63.9	1.29e-9	NR	KAK2176742.1	27915	g58561	i0	42.9	3.67073170731707	77	44	93.9	0	233	3	389	465	KAK2176742.1 hypothetical protein NP493_643g03051 [Ridgeia piscesae]	diamond	903	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
28838583	28838583	PRJNA1123309_P_NODE_22168_length_339_cov_0.966165_g21789_i0	PRJNA1123309	22168	339	0.966165	3.27529935	Paralvinella palmiformis	53620	Annelida	Annelida	46.2	0.0069	NR	KAK2151515.1	53620	g21789	i0	59.5	0.327433628318584	37	15	32.7	0	26	136	44	80	KAK2151515.1 hypothetical protein LSH36_361g07004 [Paralvinella palmiformis]	diamond	111	46.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30860087	30860087	PRJNA1123309_P_NODE_61514_length_245_cov_0.906977_g61134_i0	PRJNA1123309	61514	245	0.906977	2.22209365	Pectinaria gouldii	260746	Annelida	Annelida	85.9	2.04e-19	NR	ACJ09354.1	260746	g61134	i0	71.6	1.64081632653061	67	18	82	1	45	245	1	66	ACJ09354.1 hypothetical protein [Pectinaria gouldii]	diamond	402	85.9	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);;