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

10 rows where bioproject = "PRJNA641991" 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
1893966	1893966	PRJNA641991_P_NODE_322_length_642_cov_2.757167_g287_i0	PRJNA641991	322	642	2.757167	17.70101214	Helobdella robusta	6412	Annelida	Annelida	514	6.77e-141	NTclustered	gi\|675877099\|ref\|XM_009025862.1\|	6412	g287	i0	82.215	87.0669781931464	596	106	93	0	9	604	680	85	Helobdella robusta hypothetical protein mRNA	blastn	55897	514	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
3168626	3168626	PRJNA641991_S_NODE_2243_length_349_cov_2.370000_g2124_i0	PRJNA641991	2243	349	2.37	8.2713	Hirudo verbana	311461	Annelida	Annelida	58.4	7.08e-4	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g2124	i0	100	0.0888252148997135	31	0	9	0	68	98	1265054	1265084	Hirudo verbana genome assembly, chromosome: 7	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
3168652	3168652	PRJNA641991_S_NODE_9943_length_180_cov_2.725191_g9824_i0	PRJNA641991	9943	180	2.725191	4.9053438	Helobdella robusta	6412	Annelida	Annelida	180	6.71e-41	NTclustered	gi\|675847221\|ref\|XM_009010923.1\|	6412	g9824	i0	84.916	27.5388888888889	179	25	99	2	3	180	721	898	Helobdella robusta hypothetical protein mRNA	blastn	4957	180	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
3710188	3710188	PRJNA641991_S_NODE_14263_length_162_cov_0.902655_g14144_i0	PRJNA641991	14263	162	0.902655	1.4623011	Clitellata	42113	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2918369613\|emb\|OZ237779.1\|	311461	g14144	i0	100	0.530864197530864	29	0	18	0	39	67	8828832	8828860	Hirudo verbana genome assembly, chromosome: 1	blastn	86	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
10821980	10821980	PRJNA641991_S_NODE_13669_length_163_cov_1.307018_g13550_i0	PRJNA641991	13669	163	1.307018	2.13043934	Acromegalomma interruptum	2023653	Annelida	Annelida	182	1.66e-41	NTclustered	gi\|1227250258\|gb\|MF145113.1\|	2023653	g13550	i0	86.957	42.7914110429448	161	21	99	0	3	163	404	244	Acromegalomma interruptum isolate Rcvrn_Contig127_ORF20 putative phototransduction mRNA, partial cds	blastn	6975	182	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellidae	Acromegalomma	Acromegalomma interruptum
17195731	17195731	PRJNA641991_S_NODE_634_length_652_cov_3.817579_g534_i0	PRJNA641991	634	652	3.817579	24.89061508	Hirudo verbana	311461	Annelida	Annelida	69.4	6.44e-7	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g534	i0	95.349	1.78374233128834	43	2	7	0	506	548	12212955	12212997	Hirudo verbana genome assembly, chromosome: 7	blastn	1163	69.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
19744602	19744602	PRJNA641991_P_NODE_3256_length_167_cov_0.864407_g3215_i0	PRJNA641991	3256	167	0.864407	1.44355969	Owenia fusiformis	6347	Annelida	Annelida	93.2	8.550000000000001e-21	NR	CAH1786744.1	6347	g3215	i0	80.4	3.64670658682635	51	10	91.6	0	15	167	301	351	CAH1786744.1 unnamed protein product, partial [Owenia fusiformis]	diamond	609	93.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
23570526	23570526	PRJNA641991_S_NODE_8779_length_190_cov_0.921986_g8660_i0	PRJNA641991	8779	190	0.921986	1.7517734	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	62.1	2.71e-5	NTclustered	gi\|2920003456\|emb\|OZ238864.1\|	1046305	g8660	i0	97.297	10.7947368421053	37	0	19	1	114	150	9985751	9985716	Ailoscolex lacteospumosus genome assembly, chromosome: 5	blastn	2051	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
30649729	30649729	PRJNA641991_S_NODE_14313_length_162_cov_0.902655_g14194_i0	PRJNA641991	14313	162	0.902655	1.4623011	Owenia fusiformis	6347	Annelida	Annelida	52	4.04e-6	NR	CAH1787259.1	6347	g14194	i0	53.8	23.0185185185185	52	24	96.3	0	2	157	77	128	CAH1787259.1 unnamed protein product [Owenia fusiformis]	diamond	3729	52	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32653870	32653870	PRJNA641991_S_NODE_13180_length_164_cov_1.773913_g13061_i0	PRJNA641991	13180	164	1.773913	2.90921732	Metazoa	33208	Annelida	Annelida	87.4	1.55e-18	NR	KAI0223160.1	104711	g13061	i0	64.8	3.95121951219512	54	19	98.8	0	163	2	144	197	KAI0223160.1 DnaJ-like protein subfamily A member 1 [Lamellibrachia satsuma]	diamond	648	87.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma

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