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

10 rows where bioproject = "PRJNA557895" 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
3679638	3679638	PRJNA557895_P_NODE_9383_length_295_cov_2.073171_g9028_i0	PRJNA557895	9383	295	2.073171	6.11585445	Metazoa	33208	Annelida	Annelida	135	2.58e-34	NR	CAH1796415.1	6347	g9028	i0	66.3	6.93559322033898	98	32	99.7	1	295	2	672	768	CAH1796415.1 unnamed protein product [Owenia fusiformis]	diamond	2046	135	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
5639767	5639767	PRJNA557895_P_NODE_20105_length_207_cov_0.987342_g19750_i0	PRJNA557895	20105	207	0.987342	2.04379794	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	56.5	0.001	NTclustered	gi\|2920003563\|emb\|OZ238869.1\|	1046305	g19750	i0	100	0.705314009661836	30	0	14	0	111	140	3450794	3450823	Ailoscolex lacteospumosus genome assembly, chromosome: 10	blastn	146	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
6914428	6914428	PRJNA557895_P_NODE_686_length_1385_cov_48.559132_g49_i31	PRJNA557895	686	1385	48.559132	672.5439782	Loimia sp. RM-2022	2927651	Annelida	Annelida	65.8	1.82e-5	NTclustered	gi\|2209439381\|gb\|ON017366.1\|	2927651	g49	i31	97.368	0.0274368231046931	38	1	3	0	1195	1232	22	59	Loimia sp. RM-2022 isolate R5 small subunit ribosomal RNA gene, partial sequence	blastn	38	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Terebellidae	Loimia	Loimia sp. RM-2022
8189320	8189320	PRJNA557895_P_NODE_687_length_1385_cov_48.229042_g49_i32	PRJNA557895	687	1385	48.229042	667.9722317	Loimia sp. RM-2022	2927651	Annelida	Annelida	65.8	1.82e-5	NTclustered	gi\|2209439381\|gb\|ON017366.1\|	2927651	g49	i32	97.368	0.0274368231046931	38	1	3	0	154	191	59	22	Loimia sp. RM-2022 isolate R5 small subunit ribosomal RNA gene, partial sequence	blastn	38	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Terebellidae	Loimia	Loimia sp. RM-2022
18388296	18388296	PRJNA557895_P_NODE_415_length_1796_cov_57.423583_g49_i23	PRJNA557895	415	1796	57.423583	1031.32755068	Loimia sp. RM-2022	2927651	Annelida	Annelida	65.8	2.38e-5	NTclustered	gi\|2209439381\|gb\|ON017366.1\|	2927651	g49	i23	97.368	0.0211581291759465	38	1	2	0	1606	1643	22	59	Loimia sp. RM-2022 isolate R5 small subunit ribosomal RNA gene, partial sequence	blastn	38	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Terebellidae	Loimia	Loimia sp. RM-2022
24761976	24761976	PRJNA557895_P_NODE_1220_length_1015_cov_3.034161_g968_i0	PRJNA557895	1220	1015	3.034161	30.79673415	Metazoa	33208	Annelida	Annelida	417	3.419999999999999e-143	NR	XP_009029644.1	6412	g968	i0	67.3	7.8295566502463	303	99	89.6	0	979	71	1	303	XP_009029644.1 hypothetical protein HELRODRAFT_186151 [Helobdella robusta]	diamond	7947	417	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27015506	27015506	PRJNA557895_P_NODE_26382_length_179_cov_2.284615_g26027_i0	PRJNA557895	26382	179	2.284615	4.08946085	Ridgeia piscesae	27915	Annelida	Annelida	48.9	1.05e-4	NR	KAK2191968.1	27915	g26027	i0	67.9	1.47486033519553	28	9	46.9	0	85	2	32	59	KAK2191968.1 hypothetical protein NP493_42g11007 [Ridgeia piscesae]	diamond	264	48.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
29555873	29555873	PRJNA557895_P_NODE_20650_length_204_cov_1.967742_g20295_i0	PRJNA557895	20650	204	1.967742	4.01419368	Metazoa	33208	Annelida	Annelida	50.8	3.26e-5	NR	CAH1784407.1	6347	g20295	i0	44.8	8.27941176470588	58	31	85.3	1	201	28	1173	1229	CAH1784407.1 unnamed protein product [Owenia fusiformis]	diamond	1689	50.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29998298	29998298	PRJNA557895_P_NODE_28991_length_169_cov_2.541667_g28636_i0	PRJNA557895	28991	169	2.541667	4.29541723	Metazoa	33208	Annelida	Annelida	79.3	1.36e-15	NR	KAI0218025.1	104711	g28636	i0	70.4	1.91715976331361	54	16	95.9	0	168	7	285	338	KAI0218025.1 Pyruvate dehydrogenase E1 component subunit alpha type II, mitochondrial [Lamellibrachia satsuma]	diamond	324	79.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
30204956	30204956	PRJNA557895_P_NODE_17412_length_221_cov_0.976744_g17057_i0	PRJNA557895	17412	221	0.976744	2.15860424	Ridgeia piscesae	27915	Annelida	Annelida	82	3.64e-18	NR	KAK2174777.1	27915	g17057	i0	60.9	1.72398190045249	64	25	86.9	0	201	10	49	112	KAK2174777.1 hypothetical protein NP493_778g04017 [Ridgeia piscesae]	diamond	381	82	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae

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