metadata: contig_metadata: 10 rows where bioproject = "PRJNA846110", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA846110", tax_clade = "Opisthokonta" 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
3383926	3383926	PRJNA846110_P_NODE_3523_length_552_cov_26.553236_g3282_i0	PRJNA846110	3523	552	26.553236	146.57386272	Phragmatopoma lapidosa	341668	Annelida	Annelida	372	3.67e-98	NTclustered	gi\|700589151\|gb\|KM267711.1\|	341668	g3282	i0	80.483	60.4655797101449	497	88	89	9	60	552	40	531	Phragmatopoma lapidosa clone 329 60S ribosomal protein mRNA, complete cds	blastn	33377	372	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellariidae	Phragmatopoma	Phragmatopoma lapidosa
11036841	11036841	PRJNA846110_P_NODE_4009_length_518_cov_29.557303_g3766_i0	PRJNA846110	4009	518	29.557303	153.10682954	Phragmatopoma lapidosa	341668	Annelida	Annelida	292	2.75e-74	NTclustered	gi\|700589083\|gb\|KM267677.1\|	341668	g3766	i0	81.87	7.91891891891892	353	59	68	4	43	393	407	58	Phragmatopoma lapidosa clone 43 40S ribosomal protein mRNA, complete cds	blastn	4102	292	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellariidae	Phragmatopoma	Phragmatopoma lapidosa
14861084	14861084	PRJNA846110_P_NODE_6252_length_417_cov_36.177326_g6008_i0	PRJNA846110	6252	417	36.177326	150.85944942	Owenia fusiformis	6347	Annelida	Annelida	173	2.05e-53	NR	CAH1789098.1	6347	g6008	i0	96.4	23.4820143884892	84	3	60.4	0	400	149	18	101	CAH1789098.1 unnamed protein product, partial [Owenia fusiformis]	diamond	9792	173	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
17411189	17411189	PRJNA846110_P_NODE_17994_length_273_cov_1.340000_g17749_i0	PRJNA846110	17994	273	1.34	3.6582	Hirudo verbana	311461	Annelida	Annelida	52.8	0.025	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g17749	i0	100	0.102564102564103	28	0	10	0	51	78	4564904	4564931	Hirudo verbana genome assembly, chromosome: 9	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18684404	18684404	PRJNA846110_P_NODE_28375_length_243_cov_0.905882_g28130_i0	PRJNA846110	28375	243	0.905882	2.20129326	Metazoa	33208	Annelida	Annelida	62.4	4.45e-9	NR	KAI0223570.1	104711	g28130	i0	85.2	0.666666666666667	27	4	33.3	0	241	161	1500	1526	KAI0223570.1 S-adenosylmethionine synthase [Lamellibrachia satsuma]	diamond	162	62.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
24182952	24182952	PRJNA846110_P_NODE_3379_length_565_cov_1.823171_g3139_i0	PRJNA846110	3379	565	1.823171	10.30091615	Metazoa	33208	Annelida	Annelida	96.7	3.98e-22	NR	AHI16243.1	6359	g3139	i0	95.7	1.20530973451327	46	2	24.4	0	2	139	72	117	AHI16243.1 gbrl [Platynereis dumerilii]	diamond	681	96.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
25059373	25059373	PRJNA846110_P_NODE_9100_length_352_cov_5.318996_g8856_i0	PRJNA846110	9100	352	5.318996	18.72286592	Pectinaria gouldii	260746	Annelida	Annelida	189	2.4299999999999993e-43	NTclustered	gi\|57904689\|gb\|AY855263.1\|	260746	g8856	i0	86.55	44.5625	171	23	49	0	182	352	560	390	Pectinaria gouldii alpha tubulin mRNA, partial cds	blastn	15686	189	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Pectinariidae	Pectinaria	Pectinaria gouldii
28002500	28002500	PRJNA846110_P_NODE_20765_length_259_cov_1.698925_g20520_i0	PRJNA846110	20765	259	1.698925	4.40021575	Lamellibrachia satsuma	104711	Annelida	Annelida	96.3	6.77e-21	NR	KAI0212794.1	104711	g20520	i0	83.6	3.82239382239382	55	9	63.7	0	167	3	5410	5464	KAI0212794.1 hypothetical protein LSAT2_002235 [Lamellibrachia satsuma]	diamond	990	96.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
29013004	29013004	PRJNA846110_P_NODE_15928_length_283_cov_1.171429_g15683_i0	PRJNA846110	15928	283	1.171429	3.31514407	Lamellibrachia satsuma	104711	Annelida	Annelida	126	2.15e-33	NR	KAI0207297.1	104711	g15683	i0	70.9	0.911660777385159	86	25	91.2	0	283	26	120	205	KAI0207297.1 hypothetical protein LSAT2_008050 [Lamellibrachia satsuma]	diamond	258	126	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
32584232	32584232	PRJNA846110_P_NODE_27559_length_244_cov_1.684211_g27314_i0	PRJNA846110	27559	244	1.684211	4.10947484	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	43.1	0.0289	NR	CAD5111868.1	2664684	g27314	i0	36.9	0.799180327868853	65	41	79.9	0	234	40	1326	1390	CAD5111868.1 DgyrCDS1134 [Dimorphilus gyrociliatus]	diamond	195	43.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus

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