metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA713989" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA713989" and tax_clade = "Opisthokonta"

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
27936423	27936423	PRJNA713989_S_NODE_8885_length_188_cov_1.460432_g8825_i0	PRJNA713989	8885	188	1.460432	2.74561216	Caenorhabditis elegans	6239	Nematoda	Nematoda	68.9	1.03e-11	NR	NP_001256606.1	6239	g8825	i0	92.9	0.893617021276596	56	4	89.4	0	187	20	191	246	NP_001256606.1 Replication factor C subunit 1 [Caenorhabditis elegans]	diamond	168	68.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
28125797	28125797	PRJNA713989_S_NODE_7245_length_203_cov_10.441558_g7185_i0	PRJNA713989	7245	203	10.441558	21.19636274	Anthophora plagiata	597819	Arthropoda	Arthropoda	43.9	0.00841	NR	CAK9813121.1	597819	g7185	i0	48.6	2.58620689655172	35	18	51.7	0	148	44	222	256	CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata]	diamond	525	44.3	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Anthophora	Anthophora plagiata
28251959	28251959	PRJNA713989_S_NODE_3446_length_275_cov_1.026549_g3386_i0	PRJNA713989	3446	275	1.026549	2.82300975	Bufotes viridis	30338	Chordata	Chordata	47.8	8.91e-4	NR	CAK8629749.1	30338	g3386	i0	52.5	0.436363636363636	40	15	39.3	1	208	101	323	362	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	120	47.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
31569134	31569134	PRJNA713989_S_NODE_14056_length_161_cov_0.910714_g13996_i0	PRJNA713989	14056	161	0.910714	1.46624954	Cladosporium halotolerans	1052096	Fungi	Fungi	105	9.66e-25	NR	XP_069227834.1	1052096	g13996	i0	88.7	2.96273291925466	53	6	98.8	0	3	161	573	625	XP_069227834.1 uncharacterized protein WHR41_06875 [Cladosporium halotolerans]	diamond	477	105	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
31632062	31632062	PRJNA713989_S_NODE_12676_length_165_cov_0.879310_g12616_i0	PRJNA713989	12676	165	0.87931	1.4508615	Caenorhabditis elegans	6239	Nematoda	Nematoda	67	3.67e-12	NR	NP_492280.1	6239	g12616	i0	98.2	1	55	1	100	0	1	165	62	116	NP_492280.1 Protein yippee-like [Caenorhabditis elegans]	diamond	165	67	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
31979998	31979998	PRJNA713989_S_NODE_3358_length_277_cov_2.179825_g3298_i0	PRJNA713989	3358	277	2.179825	6.03811525	Staurois parvus	386267	Chordata	Chordata	50.4	6.51e-5	NR	CAI9550647.1	386267	g3298	i0	51.1	1.63537906137184	47	18	45.5	2	248	123	159	205	CAI9550647.1 unnamed protein product [Staurois parvus]	diamond	453	50.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
32011770	32011770	PRJNA713989_S_NODE_12678_length_165_cov_0.879310_g12618_i0	PRJNA713989	12678	165	0.87931	1.4508615	Trichonephila clavipes	2585209	Arthropoda	Arthropoda	42	0.0164	NR	GFX88553.1	2585209	g12618	i0	36.5	0.945454545454545	52	22	74.5	1	2	124	106	157	GFX88553.1 nucleic-acid-binding protein from transposon X-element [Trichonephila clavipes]	diamond	156	42	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Trichonephila	Trichonephila clavipes
32769991	32769991	PRJNA713989_S_NODE_11460_length_169_cov_1.275000_g11400_i0	PRJNA713989	11460	169	1.275	2.15475	Mytilus edulis	6550	Mollusca	Mollusca	42.4	0.0188	NR	CAG2187267.1	6550	g11400	i0	45.5	0.781065088757396	44	23	76.3	1	130	2	192	235	CAG2187267.1 unnamed protein product [Mytilus edulis]	diamond	132	42.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis

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