metadata: contig_metadata: 10 rows where bioproject = "PRJEB3181", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJEB3181", tax_kingdom = "Metazoa" 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
988886	988886	PRJEB3181_S_NODE_5741_length_255_cov_70.177273_g5448_i0	PRJEB3181	5741	255	70.177273	178.95204615	Theromyzon tessulatum	13286	Annelida	Annelida	89.4	7.32e-19	NR	AAN28680.1	13286	g5448	i0	88.9	0.529411764705882	45	5	52.9	0	13	147	307	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	135	89.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
1330324	1330324	PRJEB3181_S_NODE_10602_length_196_cov_2.018634_g10309_i0	PRJEB3181	10602	196	2.018634	3.95652264	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.005	NTclustered	gi\|2920003545\|emb\|OZ238868.1\|	1046305	g10309	i0	96.875	0.163265306122449	32	1	16	0	58	89	534659	534690	Ailoscolex lacteospumosus genome assembly, chromosome: 9	blastn	32	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
8983037	8983037	PRJEB3181_P_NODE_17428_length_199_cov_2.059524_g17164_i0	PRJEB3181	17428	199	2.059524	4.09845276	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	102	1.69e-17	NTclustered	gi\|2920003257\|emb\|OZ238860.1\|	1046305	g17164	i0	87.5	2.22613065326633	88	11	44	0	105	192	43170591	43170678	Ailoscolex lacteospumosus genome assembly, chromosome: 1	blastn	443	102	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
10258706	10258706	PRJEB3181_P_NODE_24509_length_163_cov_1.469697_g24244_i0	PRJEB3181	24509	163	1.469697	2.39560611	Hirudo verbana	311461	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2918369614\|emb\|OZ237780.1\|	311461	g24244	i0	96.97	0.202453987730061	33	0	20	1	42	73	273679	273647	Hirudo verbana genome assembly, chromosome: 2	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
12809695	12809695	PRJEB3181_S_NODE_6971_length_236_cov_2.985075_g6678_i0	PRJEB3181	6971	236	2.985075	7.044777	Platynereis dumerilii	6359	Annelida	Annelida	106	1.6e-18	NTclustered	gi\|83307676\|emb\|CT033650.1\|	6359	g6678	i0	80	33.1949152542373	145	27	61	2	83	226	778	635	Platynereis dumerilii EST IB0AAA16CH07EM1	blastn	7834	106	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
29458023	29458023	PRJEB3181_P_NODE_21390_length_176_cov_6.289655_g21125_i0	PRJEB3181	21390	176	6.289655	11.0697928	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	76.6	1.54e-14	NR	CAH1794321.1	6347	g21125	i0	76.2	2.11363636363636	42	10	71.6	0	175	50	386	427	CAH1794321.1 unnamed protein product [Owenia fusiformis]	diamond	372	77	0.994805194805195	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30216186	30216186	PRJEB3181_P_NODE_9172_length_280_cov_8.437751_g8908_i0	PRJEB3181	9172	280	8.437751	23.6257028	Metazoa	33208	Annelida	Annelida	70.5	1.83e-12	NR	CAH1772408.1	6347	g8908	i0	55.1	15.2357142857143	69	31	73.9	0	2	208	113	181	CAH1772408.1 unnamed protein product, partial [Owenia fusiformis]	diamond	4266	70.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30538799	30538799	PRJEB3181_P_NODE_20493_length_181_cov_2.260000_g20229_i0	PRJEB3181	20493	181	2.26	4.0906	Theromyzon tessulatum	13286	Annelida	Annelida	80.1	6.55e-16	NR	AAN28680.1	13286	g20229	i0	89.7	0.646408839779006	39	4	64.6	0	3	119	313	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	117	80.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
31076063	31076063	PRJEB3181_P_NODE_12775_length_237_cov_2.131068_g12511_i0	PRJEB3181	12775	237	2.131068	5.05063116	Helobdella robusta	6412	Annelida	Annelida	61.2	8.37e-9	NR	XP_009020629.1	6412	g12511	i0	49.3	0.873417721518987	69	32	87.3	1	237	31	228	293	XP_009020629.1 hypothetical protein HELRODRAFT_185715 [Helobdella robusta]	diamond	207	61.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32341380	32341380	PRJEB3181_S_NODE_11459_length_190_cov_1.174194_g11166_i0	PRJEB3181	11459	190	1.174194	2.2309686	Ridgeia piscesae	27915	Annelida	Annelida	68.9	6.16e-12	NR	KAK2171970.1	27915	g11166	i0	71.4	3.9	42	12	66.3	0	1	126	144	185	KAK2171970.1 hypothetical protein NP493_1009g01009 [Ridgeia piscesae]	diamond	741	68.9	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);;