metadata: contig_metadata: 9 rows where bioproject = "PRJNA1002816" and tax

9 rows where bioproject = "PRJNA1002816" 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
26876518	26876518	PRJNA1002816_P_NODE_13241_length_303_cov_2.213043_g13081_i0	PRJNA1002816	13241	303	2.213043	6.70552029	Lamellibrachia satsuma	104711	Annelida	Annelida	107	1.97e-24	NR	KAI0211998.1	104711	g13081	i0	50	0.97029702970297	98	49	97	0	5	298	490	587	KAI0211998.1 S1 RNA-binding domain-containing protein 1 [Lamellibrachia satsuma]	diamond	294	107	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
27887224	27887224	PRJNA1002816_P_NODE_4585_length_530_cov_1.516411_g4425_i0	PRJNA1002816	4585	530	1.516411	8.0369783	Owenia fusiformis	6347	Annelida	Annelida	179	2.19e-48	NR	CAH1772664.1	6347	g4425	i0	49.7	1.01320754716981	179	87	99.6	2	1	528	648	826	CAH1772664.1 unnamed protein product [Owenia fusiformis]	diamond	537	179	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28669373	28669373	PRJNA1002816_P_NODE_10827_length_338_cov_2.358491_g10667_i0	PRJNA1002816	10827	338	2.358491	7.97169958	Metazoa	33208	Annelida	Annelida	61.6	2.79e-8	NR	CAH1775644.1	6347	g10667	i0	38.9	1.77514792899408	72	44	63.9	0	321	106	417	488	CAH1775644.1 unnamed protein product [Owenia fusiformis]	diamond	600	61.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29150649	29150649	PRJNA1002816_P_NODE_13409_length_301_cov_1.013158_g13249_i0	PRJNA1002816	13409	301	1.013158	3.04960558	Owenia fusiformis	6347	Annelida	Annelida	43.5	0.0414	NR	CAH1783611.1	6347	g13249	i0	51.6	0.308970099667774	31	15	30.9	0	2	94	48	78	CAH1783611.1 unnamed protein product, partial [Owenia fusiformis]	diamond	93	43.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29844881	29844881	PRJNA1002816_P_NODE_14971_length_281_cov_1.336538_g14811_i0	PRJNA1002816	14971	281	1.336538	3.75567178	Paralvinella palmiformis	53620	Annelida	Annelida	100	4.1e-22	NR	KAK2165140.1	53620	g14811	i0	50.6	0.950177935943061	89	44	95	0	10	276	1105	1193	KAK2165140.1 hypothetical protein LSH36_54g04001 [Paralvinella palmiformis]	diamond	267	100	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30343498	30343498	PRJNA1002816_P_NODE_912_length_1130_cov_4.481552_g827_i0	PRJNA1002816	912	1130	4.481552	50.6415376	Metazoa	33208	Annelida	Annelida	289	8.66e-91	NR	AIZ77505.1	6359	g827	i0	49.7	4.7070796460177	292	142	77.5	1	144	1019	25	311	AIZ77505.1 legumain-protease-precursor [Platynereis dumerilii]	diamond	5319	289	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
30627195	30627195	PRJNA1002816_P_NODE_18173_length_249_cov_0.875000_g18013_i0	PRJNA1002816	18173	249	0.875	2.17875	Metazoa	33208	Annelida	Annelida	90.5	1.11e-19	NR	KAK2141800.1	53620	g18013	i0	54.4	3.95180722891566	79	36	95.2	0	1	237	142	220	KAK2141800.1 hypothetical protein LSH36_1037g00044 [Paralvinella palmiformis]	diamond	984	91.3	0.991237677984666	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31139911	31139911	PRJNA1002816_P_NODE_12555_length_312_cov_1.288703_g12395_i0	PRJNA1002816	12555	312	1.288703	4.02075336	Capitella teleta	283909	Annelida	Annelida	45.8	0.00608	NR	ELT92085.1	283909	g12395	i0	43.1	0.557692307692308	58	30	52.9	2	284	120	110	167	ELT92085.1 hypothetical protein CAPTEDRAFT_227393 [Capitella teleta]	diamond	174	45.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
31638727	31638727	PRJNA1002816_P_NODE_13396_length_301_cov_1.096491_g13236_i0	PRJNA1002816	13396	301	1.096491	3.30043791	Metazoa	33208	Annelida	Annelida	85.1	7.06e-17	NR	CAH1790732.1	6347	g13236	i0	46.7	2.91029900332226	92	46	91.7	1	26	301	12	100	CAH1790732.1 unnamed protein product [Owenia fusiformis]	diamond	876	85.1	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);;