metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA983848" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA983848" 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
23921094	23921094	PRJNA983848_P_NODE_18019_length_1376_cov_4.425173_g13845_i0	PRJNA983848	18019	1376	4.425173	60.89038048	Capitella teleta	283909	Annelida	Annelida	112	1.97e-24	NR	ELT95918.1	283909	g13845	i0	63.3	0.196220930232558	90	32	19.4	1	547	813	67	156	ELT95918.1 hypothetical protein CAPTEDRAFT_186637 [Capitella teleta]	diamond	270	112	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
26614642	26614642	PRJNA983848_P_NODE_95141_length_312_cov_1.163180_g89258_i0	PRJNA983848	95141	312	1.16318	3.6291216	Ridgeia piscesae	27915	Annelida	Annelida	44.3	0.015	NR	KAK2178133.1	27915	g89258	i0	44.7	0.365384615384615	38	21	36.5	0	213	100	83	120	KAK2178133.1 hypothetical protein NP493_560g00012 [Ridgeia piscesae]	diamond	114	44.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
26646214	26646214	PRJNA983848_P_NODE_144221_length_250_cov_0.881356_g138338_i0	PRJNA983848	144221	250	0.881356	2.20339	Helobdella robusta	6412	Annelida	Annelida	84	8.64e-17	NR	XP_009011579.1	6412	g138338	i0	59.6	4.104	57	23	68.4	0	23	193	146	202	XP_009011579.1 hypothetical protein HELRODRAFT_183749 [Helobdella robusta]	diamond	1026	84	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28611447	28611447	PRJNA983848_P_NODE_94287_length_313_cov_2.458333_g88404_i0	PRJNA983848	94287	313	2.458333	7.69458229	Metazoa	33208	Annelida	Annelida	134	5.939999999999998e-35	NR	XP_009024025.1	6412	g88404	i0	61	7.64856230031949	100	39	95.8	0	312	13	308	407	XP_009024025.1 hypothetical protein HELRODRAFT_177629 [Helobdella robusta]	diamond	2394	135	0.992592592592593	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30057818	30057818	PRJNA983848_P_NODE_46831_length_519_cov_15.446188_g40961_i0	PRJNA983848	46831	519	15.446188	80.16571572	Paralvinella palmiformis	53620	Annelida	Annelida	136	2.59e-38	NR	KAK2170379.1	53620	g40961	i0	65.9	1.05780346820809	91	31	52.6	0	513	241	1	91	KAK2170379.1 hypothetical protein LSH36_3g21017 [Paralvinella palmiformis]	diamond	549	136	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31005795	31005795	PRJNA983848_P_NODE_138474_length_253_cov_0.866667_g132591_i0	PRJNA983848	138474	253	0.866667	2.19266751	Capitella teleta	283909	Annelida	Annelida	54.7	2.62e-6	NR	ELU01654.1	283909	g132591	i0	39.7	6.92490118577075	73	44	86.6	0	251	33	1066	1138	ELU01654.1 hypothetical protein CAPTEDRAFT_155489 [Capitella teleta]	diamond	1752	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
31353575	31353575	PRJNA983848_P_NODE_82136_length_341_cov_0.873134_g76253_i0	PRJNA983848	82136	341	0.873134	2.97738694	Lamellibrachia satsuma	104711	Annelida	Annelida	53.1	2.58e-5	NR	KAI0224060.1	104711	g76253	i0	54.8	1.10850439882698	42	19	37	0	55	180	564	605	KAI0224060.1 hypothetical protein LSAT2_024917 [Lamellibrachia satsuma]	diamond	378	53.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
31416806	31416806	PRJNA983848_P_NODE_50256_length_488_cov_2.655422_g44380_i0	PRJNA983848	50256	488	2.655422	12.95845936	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	57.4	4.11e-6	NR	CAD5119519.1	2664684	g44380	i0	56.8	0.461065573770492	37	16	22.7	0	76	186	2541	2577	CAD5119519.1 DgyrCDS8121 [Dimorphilus gyrociliatus]	diamond	225	57.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
31454505	31454505	PRJNA983848_P_NODE_135816_length_255_cov_1.285714_g129933_i0	PRJNA983848	135816	255	1.285714	3.2785707	Metazoa	33208	Annelida	Annelida	45.1	0.00659	NR	KAK2179343.1	27915	g129933	i0	52.9	0.764705882352941	34	16	40	0	24	125	724	757	KAK2179343.1 hypothetical protein NP493_496g02012 [Ridgeia piscesae]	diamond	195	45.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
32655826	32655826	PRJNA983848_P_NODE_55300_length_451_cov_1.653439_g49421_i0	PRJNA983848	55300	451	1.653439	7.45700989	Metazoa	33208	Annelida	Annelida	101	1.0100000000000002e-21	NR	KAI0235910.1	104711	g49421	i0	54.8	7.43015521064302	93	33	55.9	1	448	197	306	398	KAI0235910.1 hypothetical protein LSAT2_013532 [Lamellibrachia satsuma]	diamond	3351	102	0.990196078431373	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);;