metadata: contig_metadata: 7 rows where bioproject = "PRJNA788929", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA788929", 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
769278	769278	PRJNA788929_P_NODE_2601_length_1306_cov_59.510138_g2264_i0	PRJNA788929	2601	1306	59.510138	777.20240228	Owenia fusiformis	6347	Annelida	Annelida	89	1.17e-14	NR	CAH1801412.1	6347	g2264	i0	34.4	1.01990811638591	151	90	33.5	4	853	416	60	206	CAH1801412.1 unnamed protein product [Owenia fusiformis]	diamond	1332	89	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
5042637	5042637	PRJNA788929_P_NODE_46024_length_224_cov_4.105960_g45363_i0	PRJNA788929	46024	224	4.10596	9.1973504	Prionospio	94674	Annelida	Annelida	198	2.42e-46	NTclustered	gi\|2532676574\|gb\|OR243563.1\|	507517	g45363	i0	88.485	74.6205357142857	165	17	74	2	23	187	996	1158	Prionospio cirrifera isolate MH10 large subunit ribosomal RNA gene, partial sequence	blastn	16715	198	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Spionida	Spionidae	Prionospio	Prionospio cirrifera
7147548	7147548	PRJNA788929_P_NODE_10546_length_546_cov_39.739958_g9893_i0	PRJNA788929	10546	546	39.739958	216.98017068	Hirudo verbana	311461	Annelida	Annelida	63.9	2.48e-5	NTclustered	gi\|2918369621\|emb\|OZ237783.1\|	311461	g9893	i0	95	1.61538461538462	40	2	7	0	280	319	2868337	2868376	Hirudo verbana genome assembly, chromosome: 5	blastn	882	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
8867497	8867497	PRJNA788929_P_NODE_4067_length_1014_cov_40.195537_g3580_i0	PRJNA788929	4067	1014	40.195537	407.58274518	Opisthokonta	33154	Annelida	Annelida	65.8	1.32e-5	NTclustered	gi\|675862479\|ref\|XM_009018552.1\|	6412	g3580	i0	100	2.35305719921105	35	0	3	0	92	126	1627	1661	Helobdella robusta hypothetical protein partial mRNA	blastn	2386	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
10973530	10973530	PRJNA788929_P_NODE_40049_length_246_cov_3.653179_g39388_i0	PRJNA788929	40049	246	3.653179	8.98682034	Stylaria sp. THS-2006	397589	Annelida	Annelida	364	2.509999999999999e-96	NTclustered	gi\|111559330\|gb\|DQ790065.1\|	397589	g39388	i0	97.653	84.9308943089431	213	4	87	1	11	223	2475	2264	Stylaria sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence	blastn	20893	364	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Stylaria	Stylaria sp. THS-2006
22891942	22891942	PRJNA788929_P_NODE_29018_length_293_cov_31.518182_g28357_i0	PRJNA788929	29018	293	31.518182	92.34827326	Aeolosoma	55816	Annelida	Annelida	399	8.419999999999998e-107	NTclustered	gi\|111559284\|gb\|DQ790019.1\|	397537	g28357	i0	94.297	120.232081911263	263	12	89	3	23	284	2179	2439	Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence	blastn	35228	399	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma sp. THS-2006
26873387	26873387	PRJNA788929_P_NODE_30161_length_287_cov_10.700935_g29500_i0	PRJNA788929	30161	287	10.700935	30.71168345	Metazoa	33208	Annelida	Annelida	73.6	9.32e-13	NR	KAK2194035.1	27915	g29500	i0	36.7	4.73519163763066	90	56	93	1	20	286	106	195	KAK2194035.1 hypothetical protein NP493_3g07028 [Ridgeia piscesae]	diamond	1359	73.6	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);;