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

8 rows where bioproject = "PRJNA902848", 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
8534941	8534941	PRJNA902848_P_NODE_18767_length_244_cov_0.912281_g18717_i0	PRJNA902848	18767	244	0.912281	2.22596564	Aeolosomatidae sp. Biologic-POLY002	2962484	Annelida	Annelida	383	6.87e-102	NTclustered	gi\|2264468515\|gb\|ON931460.1\|	2962484	g18717	i0	99.061	60.9139344262295	213	2	87	0	26	238	1	213	Aeolosomatidae sp. Biologic-POLY002 isolate BES10848_BMR07305 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	14863	383	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae		Aeolosomatidae sp. Biologic-POLY002
13635775	13635775	PRJNA902848_P_NODE_291_length_1070_cov_6.898696_g260_i0	PRJNA902848	291	1070	6.898696	73.8160472	Aeolosoma sp. GG-2011	1071604	Annelida	Annelida	364	1.23e-95	NTclustered	gi\|342220097\|gb\|HQ691208.1\|	1071604	g260	i0	81.385	16.5542056074766	462	72	42	10	549	999	14	472	Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	17713	364	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma sp. GG-2011
23834107	23834107	PRJNA902848_P_NODE_16719_length_247_cov_0.896552_g16669_i0	PRJNA902848	16719	247	0.896552	2.21448344	Sabellida	6362	Annelida	Annelida	130	2.21e-33	NR	KAI0229899.1	104711	g16669	i0	74.1	5.90283400809717	81	21	98.4	0	3	245	46	126	KAI0229899.1 Sodium- and chloride-dependent glycine transporter 1 [Lamellibrachia satsuma]	diamond	1458	130	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
28698260	28698260	PRJNA902848_P_NODE_8967_length_298_cov_1.386667_g8917_i0	PRJNA902848	8967	298	1.386667	4.13226766	Aglaophamus verrilli	2507394	Annelida	Annelida	75.1	1.6e-14	NR	QAT81017.1	2507394	g8917	i0	47.9	0.714765100671141	71	37	71.5	0	293	81	89	159	QAT81017.1 extracellular globin, partial [Aglaophamus verrilli]	diamond	213	75.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nephtyidae	Aglaophamus	Aglaophamus verrilli
29463032	29463032	PRJNA902848_P_NODE_14850_length_250_cov_0.881356_g14800_i0	PRJNA902848	14850	250	0.881356	2.20339	Metazoa	33208	Annelida	Annelida	109	2.19e-28	NR	ABW23168.1	6344	g14800	i0	70.2	14.16	84	24	99.6	1	249	1	17	100	ABW23168.1 ribosomal protein rpl13, partial [Arenicola marina]	diamond	3540	110	0.990909090909091	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
30118932	30118932	PRJNA902848_P_NODE_4692_length_380_cov_1.188925_g4642_i0	PRJNA902848	4692	380	1.188925	4.517915	Lamellibrachia satsuma	104711	Annelida	Annelida	72.8	3.08e-14	NR	KAI0207446.1	104711	g4642	i0	58.1	1.02631578947368	62	24	48.9	1	50	235	1	60	KAI0207446.1 hypothetical protein LSAT2_007855, partial [Lamellibrachia satsuma]	diamond	390	72.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
31509743	31509743	PRJNA902848_P_NODE_17036_length_247_cov_0.896552_g16986_i0	PRJNA902848	17036	247	0.896552	2.21448344	Paralvinella palmiformis	53620	Annelida	Annelida	55.5	1.31e-6	NR	KAK2160042.1	53620	g16986	i0	41.1	1.15384615384615	95	34	98.4	5	2	244	18	104	KAK2160042.1 hypothetical protein LSH36_141g03025 [Paralvinella palmiformis]	diamond	285	55.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31857389	31857389	PRJNA902848_P_NODE_17037_length_247_cov_0.896552_g16987_i0	PRJNA902848	17037	247	0.896552	2.21448344	Lamellibrachia satsuma	104711	Annelida	Annelida	113	6.34e-27	NR	KAI0240797.1	104711	g16987	i0	63.2	1.05668016194332	87	27	99.6	1	2	247	538	624	KAI0240797.1 hypothetical protein LSAT2_008422 [Lamellibrachia satsuma]	diamond	261	113	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma

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