metadata: contig_metadata: 8 rows where bioproject = "PRJNA608894", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA608894", 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
1861364	1861364	PRJNA608894_P_NODE_36442_length_298_cov_1.640000_g35943_i0	PRJNA608894	36442	298	1.64	4.8872	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	120	3.81e-32	NR	CAH1783075.1	6347	g35943	i0	63.9	6.24161073825503	83	30	83.6	0	282	34	84	166	CAH1783075.1 unnamed protein product, partial [Owenia fusiformis]	diamond	1860	120	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
12065340	12065340	PRJNA608894_P_NODE_7270_length_1036_cov_4.138110_g6882_i0	PRJNA608894	7270	1036	4.13811	42.8708196	Metazoa	33208	Annelida	Annelida	281	7.0899999999999996e-90	NR	XP_009025699.1	6412	g6882	i0	63.4	10.3986486486486	246	81	68.6	2	1012	302	1	246	XP_009025699.1 hypothetical protein HELRODRAFT_107583 [Helobdella robusta]	diamond	10773	281	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
12065375	12065375	PRJNA608894_P_NODE_9650_length_817_cov_2.315860_g9204_i0	PRJNA608894	9650	817	2.31586	18.9205762	Theromyzon tessulatum	13286	Annelida	Annelida	315	9.49e-81	NTclustered	gi\|23344733\|gb\|AF542132.1\|	13286	g9204	i0	97.297	0.74296205630355	185	5	23	0	633	817	975	1159	Theromyzon tessulatum cathepsin L mRNA, complete cds	blastn	607	315	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
18437983	18437983	PRJNA608894_P_NODE_8095_length_950_cov_5.115165_g7686_i0	PRJNA608894	8095	950	5.115165	48.5940675	Sabellida	6362	Annelida	Annelida	199	1.3200000000000001e-59	NR	CAH1784699.1	6347	g7686	i0	55	10.3136842105263	191	80	60.3	2	906	334	1	185	CAH1784699.1 unnamed protein product [Owenia fusiformis]	diamond	9798	199	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27124509	27124509	PRJNA608894_P_NODE_18322_length_488_cov_1.843373_g17826_i0	PRJNA608894	18322	488	1.843373	8.99566024	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.3	0.03	NR	KAK2162461.1	53620	g17826	i0	34.1	0.786885245901639	82	50	48	2	487	254	10	91	KAK2162461.1 hypothetical protein LSH36_98g04005 [Paralvinella palmiformis]	diamond	384	44.7	0.991051454138702	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
27901175	27901175	PRJNA608894_P_NODE_7125_length_1052_cov_5.400409_g6738_i0	PRJNA608894	7125	1052	5.400409	56.81230268	Owenia fusiformis	6347	Annelida	Annelida	325	5.31e-102	NR	CAH1789021.1	6347	g6738	i0	61.3	6.03992395437262	253	96	71.9	2	271	1026	424	675	CAH1789021.1 unnamed protein product [Owenia fusiformis]	diamond	6354	325	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30206260	30206260	PRJNA608894_P_NODE_52832_length_248_cov_0.880000_g52333_i0	PRJNA608894	52832	248	0.88	2.1824	Helobdella robusta	6412	Annelida	Annelida	51.2	2.2e-5	NR	XP_009021946.1	6412	g52333	i0	55.3	4.39112903225806	47	19	56.9	1	1	141	152	196	XP_009021946.1 hypothetical protein HELRODRAFT_176222 [Helobdella robusta]	diamond	1089	51.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32433045	32433045	PRJNA608894_P_NODE_19059_length_474_cov_1.628429_g18563_i0	PRJNA608894	19059	474	1.628429	7.71875346	Metazoa	33208	Annelida	Annelida	219	2.57e-63	NR	CAH1788947.1	6347	g18563	i0	69.9	8.27215189873418	146	44	92.4	0	35	472	4	149	CAH1788947.1 unnamed protein product, partial [Owenia fusiformis]	diamond	3921	219	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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