metadata: contig_metadata: 21 rows where bioproject = "PRJNA1264536" and tax

21 rows where bioproject = "PRJNA1264536" 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
363884	363884	PRJNA1264536_P_NODE_421_length_885_cov_2.161330_g362_i0	PRJNA1264536	421	885	2.16133	19.1277705	Mesenchytraeus hydrius	1797137	Annelida	Annelida	462	3.4799999999999997e-125	NTclustered	gi\|1068288793\|gb\|KU728849.1\|	1797137	g362	i0	76.869	74.3028248587571	856	174	95	20	39	882	875	32	Mesenchytraeus hydrius cytochrome b gene, complete cds; mitochondrial	blastn	65758	462	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Enchytraeida	Enchytraeidae	Mesenchytraeus	Mesenchytraeus hydrius
1638706	1638706	PRJNA1264536_P_NODE_202_length_1225_cov_25.470486_g168_i0	PRJNA1264536	202	1225	25.470486	312.0134535	Pristina longiseta	188231	Annelida	Annelida	891	0	NTclustered	gi\|2169792353\|gb\|OM001222.1\|	188231	g168	i0	97.154	47.3681632653061	527	15	43	0	589	1115	1	527	Pristina longiseta voucher CW649 large subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	58026	891	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Pristina	Pristina longiseta
2914636	2914636	PRJNA1264536_P_NODE_643_length_725_cov_6.108896_g576_i0	PRJNA1264536	643	725	6.108896	44.289496	root	1	Root_unresolved	Root_unresolved	188	6.529999999999999e-56	NR	XFH20256.1	1302595	g576	i0	48.3	4.8	234	114	95.6	2	693	1	1	230	XFH20256.1 ATP synthase F0 subunit 6 [Dendrobaena alpina]	diamond	3480	188	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Dendrobaena	Dendrobaena alpina
10568049	10568049	PRJNA1264536_P_NODE_749_length_675_cov_3.350498_g679_i0	PRJNA1264536	749	675	3.350498	22.6158615	Pristina longiseta	188231	Annelida	Annelida	761	0	NTclustered	gi\|2698734377\|gb\|PP490770.1\|	188231	g679	i0	92.83	50.0459259259259	530	31	78	6	1	527	526	1	Pristina longiseta small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	33781	761	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Pristina	Pristina longiseta
11842567	11842567	PRJNA1264536_P_NODE_4430_length_252_cov_1.307263_g4356_i0	PRJNA1264536	4430	252	1.307263	3.29430276	Phragmatopoma lapidosa	341668	Annelida	Annelida	127	2.94e-34	NR	ADW95788.1	341668	g4356	i0	78.3	4.94047619047619	83	18	98.8	0	250	2	59	141	ADW95788.1 60S ribosomal L7a-like protein [Phragmatopoma lapidosa]	diamond	1245	127	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellariidae	Phragmatopoma	Phragmatopoma lapidosa
13117681	13117681	PRJNA1264536_P_NODE_1631_length_449_cov_3.295213_g1557_i0	PRJNA1264536	1631	449	3.295213	14.79550637	Slavina appendiculata	188233	Annelida	Annelida	84.7	3.05e-16	NR	XBQ63456.1	188233	g1557	i0	38.4	1.87082405345212	138	76	88.2	4	406	11	197	331	XBQ63456.1 NADH dehydrogenase subunit 2 [Slavina appendiculata]	diamond	840	84.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Slavina	Slavina appendiculata
13117712	13117712	PRJNA1264536_P_NODE_3231_length_309_cov_1.466102_g3157_i0	PRJNA1264536	3231	309	1.466102	4.53025518	Helobdella robusta	6412	Annelida	Annelida	189	6.0700000000000005e-58	NR	XP_009024124.1	6412	g3157	i0	88.2	0.990291262135922	102	12	99	0	3	308	16	117	XP_009024124.1 hypothetical protein HELRODRAFT_185887 [Helobdella robusta]	diamond	306	189	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
14393073	14393073	PRJNA1264536_P_NODE_3472_length_296_cov_1.399103_g3398_i0	PRJNA1264536	3472	296	1.399103	4.14134488	Amynthas sp. 3 LZ-2016	1811407	Annelida	Annelida	137	7.38e-28	NTclustered	gi\|1003312133\|gb\|KT429013.1\|	1811407	g3398	i0	84.672	1.36148648648649	137	21	46	0	90	226	13956	13820	Amynthas sp. 3 LZ-2016 mitochondrion, complete genome	blastn	403	137	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Megascolecidae	Amynthas	Amynthas sp. 3 LZ-2016
16941160	16941160	PRJNA1264536_P_NODE_394_length_916_cov_3.004745_g336_i0	PRJNA1264536	394	916	3.0047450000000002	27.5234642	Metaphire tosaensis	506673	Annelida	Annelida	279	3.899999999999999e-70	NTclustered	gi\|2567585139\|dbj\|LC726512.1\|	506673	g336	i0	74.672	53.1834061135371	687	146	74	22	220	895	6892	6223	Metaphire tosaensis CS015 mitochondrial DNA, nearly complete genome	blastn	48716	279	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Megascolecidae	Metaphire	Metaphire tosaensis
21455861	21455861	PRJNA1264536_P_NODE_1657_length_446_cov_1.254692_g1583_i0	PRJNA1264536	1657	446	1.254692	5.59592632	root	1	Root_unresolved	Root_unresolved	190	2.53e-59	NR	CAH1788156.1	6347	g1583	i0	91.3	48.5986547085202	103	9	69.3	0	439	131	4	106	CAH1788156.1 unnamed protein product [Owenia fusiformis]	diamond	21675	191	0.994764397905759	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27295160	27295160	PRJNA1264536_P_NODE_4603_length_251_cov_0.876404_g4529_i0	PRJNA1264536	4603	251	0.876404	2.19977404	Ridgeia piscesae	27915	Annelida	Annelida	54.3	3.55e-6	NR	KAK2186785.1	27915	g4529	i0	42.5	0.956175298804781	80	45	94.4	1	239	3	1372	1451	KAK2186785.1 hypothetical protein NP493_189g05031 [Ridgeia piscesae]	diamond	240	54.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
28684712	28684712	PRJNA1264536_P_NODE_4527_length_251_cov_1.314607_g4453_i0	PRJNA1264536	4527	251	1.314607	3.29966357	Capitella teleta	283909	Annelida	Annelida	124	3.82e-32	NR	ELT91533.1	283909	g4453	i0	69.1	1.94820717131474	81	25	96.8	0	6	248	242	322	ELT91533.1 hypothetical protein CAPTEDRAFT_221378 [Capitella teleta]	diamond	489	124	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
28937196	28937196	PRJNA1264536_P_NODE_2808_length_334_cov_0.896552_g2734_i0	PRJNA1264536	2808	334	0.896552	2.99448368	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	130	2.2499999999999998e-34	NR	CAD5126080.1	2664684	g2734	i0	54.5	0.988023952095808	110	48	98.8	2	3	332	79	186	CAD5126080.1 DgyrCDS14245 [Dimorphilus gyrociliatus]	diamond	330	130	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
29000618	29000618	PRJNA1264536_P_NODE_1908_length_411_cov_2.198225_g1834_i0	PRJNA1264536	1908	411	2.198225	9.03470475	Eisenia nordenskioldi pallida	1269248	Annelida	Annelida	58.5	1.16e-7	NR	QGZ09976.1	1269248	g1834	i0	40.6	1.61313868613139	101	47	73	2	23	322	13	101	QGZ09976.1 NADH dehydrogenase subunit 6 [Eisenia nordenskioldi pallida]	diamond	663	58.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Eisenia	Eisenia nordenskioldi
29063515	29063515	PRJNA1264536_P_NODE_4928_length_248_cov_0.891429_g4854_i0	PRJNA1264536	4928	248	0.891429	2.21074392	Paralvinella palmiformis	53620	Annelida	Annelida	48.5	3.72e-4	NR	KAK2150241.1	53620	g4854	i0	66.7	0.399193548387097	33	11	39.9	0	126	28	428	460	KAK2150241.1 hypothetical protein LSH36_416g02043 [Paralvinella palmiformis]	diamond	99	48.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30123183	30123183	PRJNA1264536_P_NODE_5132_length_246_cov_0.861272_g5058_i0	PRJNA1264536	5132	246	0.861272	2.11872912	Metazoa	33208	Annelida	Annelida	99.4	4.5400000000000005e-22	NR	CAH1789295.1	6347	g5058	i0	56.3	3.65853658536585	80	35	97.6	0	5	244	425	504	CAH1789295.1 unnamed protein product [Owenia fusiformis]	diamond	900	99.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31464604	31464604	PRJNA1264536_P_NODE_3016_length_322_cov_1.879518_g2942_i0	PRJNA1264536	3016	322	1.879518	6.05204796	Paralvinella palmiformis	53620	Annelida	Annelida	46.6	0.00397	NR	KAK2141111.1	53620	g2942	i0	30	2.06832298136646	110	55	82.9	5	320	54	108	216	KAK2141111.1 hypothetical protein LSH36_1159g00016 [Paralvinella palmiformis]	diamond	666	46.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
32115013	32115013	PRJNA1264536_P_NODE_5078_length_246_cov_0.901734_g5004_i0	PRJNA1264536	5078	246	0.901734	2.21826564	Siboglinidae	41324	Annelida	Annelida	112	7.01e-28	NR	KAK2184262.1	27915	g5004	i0	75.3	2.96341463414634	81	19	98.8	1	244	2	181	260	KAK2184262.1 hypothetical protein NP493_273g03000 [Ridgeia piscesae]	diamond	729	112	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
32305018	32305018	PRJNA1264536_P_NODE_3379_length_302_cov_1.017467_g3305_i0	PRJNA1264536	3379	302	1.017467	3.07275034	Annelida	6340	Annelida	Annelida	76.6	5.33e-14	NR	YP_009131513.1	53621	g3305	i0	55.6	1.45033112582781	72	32	71.5	0	218	3	35	106	YP_009131513.1 NADH dehydrogenase subunit 2 [Tevnia jerichonana]	diamond	438	77	0.994805194805195	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Tevnia	Tevnia jerichonana
32399795	32399795	PRJNA1264536_P_NODE_4359_length_253_cov_0.866667_g4285_i0	PRJNA1264536	4359	253	0.866667	2.19266751	Metazoa	33208	Annelida	Annelida	76.6	4.71e-14	NR	KAI0222911.1	104711	g4285	i0	52.2	2.52569169960474	69	33	81.8	0	251	45	520	588	KAI0222911.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Lamellibrachia satsuma]	diamond	639	76.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
32413552	32413552	PRJNA1264536_P_NODE_659_length_717_cov_1.361801_g592_i0	PRJNA1264536	659	717	1.361801	9.76411317	Slavina appendiculata	188233	Annelida	Annelida	181	9.04e-51	NR	XBQ63453.1	188233	g592	i0	51.7	1.7907949790795	209	91	84.1	3	4	606	138	344	XBQ63453.1 NADH dehydrogenase subunit 4 [Slavina appendiculata]	diamond	1284	181	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Slavina	Slavina appendiculata

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