metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA314497" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA314497" 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
16958014	16958014	PRJNA314497_S_NODE_474_length_349_cov_8.743750_g451_i0	PRJNA314497	474	349	8.74375	30.5156875	Culicoides brevitarsis	469753	Arthropoda	Arthropoda	187	1.84e-59	NR	XP_063703218.1	469753	g451	i0	89.9	0.851002865329513	99	10	85.1	0	14	310	1	99	XP_063703218.1 ATP synthase subunit g, mitochondrial [Culicoides brevitarsis]	diamond	297	187	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Ceratopogonidae	Culicoides	Culicoides brevitarsis
26599186	26599186	PRJNA314497_P_NODE_1281_length_492_cov_3.382289_g1142_i0	PRJNA314497	1281	492	3.382289	16.64086188	Elsinoe fawcettii	40997	Fungi	Fungi	117	5.37e-27	NR	KAF4547717.1	40997	g1142	i0	42	1.68292682926829	138	80	84.1	0	4	417	2349	2486	KAF4547717.1 AMP-binding enzyme 2 [Elsinoe fawcettii]	diamond	828	117	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Myriangiales	Elsinoaceae	Elsinoe	Elsinoe fawcettii
26631189	26631189	PRJNA314497_S_NODE_1521_length_179_cov_2.480000_g1498_i0	PRJNA314497	1521	179	2.48	4.4392	Barbourula kalimantanensis	877557	Chordata	Chordata	95.5	1.04e-22	NR	ADW79448.1	877557	g1498	i0	97.9	904.206703910615	48	1	80.4	0	178	35	103	150	ADW79448.1 cytochrome oxidase subunit I, partial [Barbourula kalimantanensis]	diamond	161853	96.3	0.991692627206646	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Barbourula	Barbourula kalimantanensis
28274368	28274368	PRJNA314497_S_NODE_126_length_621_cov_6.712838_g111_i0	PRJNA314497	126	621	6.712838	41.68672398	Mycena metata	1033252	Fungi	Fungi	381	1.86e-131	NR	KAJ7746270.1	1033252	g111	i0	97.4	0.927536231884058	192	5	92.8	0	2	577	105	296	KAJ7746270.1 Arv1-like family-domain-containing protein [Mycena metata]	diamond	576	381	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena metata
30105808	30105808	PRJNA314497_S_NODE_372_length_397_cov_6.013587_g349_i0	PRJNA314497	372	397	6.013587	23.87394039	Culicoides sonorensis	179676	Arthropoda	Arthropoda	150	1.55e-44	NR	AAU06505.1	179676	g349	i0	84.4	0.581863979848867	77	12	58.2	0	352	122	1	77	AAU06505.1 unknown salivary protein [Culicoides sonorensis]	diamond	231	150	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Ceratopogonidae	Culicoides	Culicoides sonorensis
31306593	31306593	PRJNA314497_S_NODE_455_length_356_cov_6.348624_g432_i0	PRJNA314497	455	356	6.348624	22.60110144	Thrips palmi	161013	Arthropoda	Arthropoda	48.1	0.00175	NR	XP_034240145.1	161013	g432	i0	33.3	0.758426966292135	90	55	74.2	2	83	346	805	891	XP_034240145.1 uncharacterized protein LOC117644643 [Thrips palmi]	diamond	270	48.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips palmi
31703727	31703727	PRJNA314497_S_NODE_1277_length_200_cov_2.736842_g1254_i0	PRJNA314497	1277	200	2.736842	5.473684	Chordata	7711	Chordata	Chordata	99	2.81e-22	NR	NP_033640.1	7748	g1254	i0	74.2	264.3	66	17	99	0	2	199	252	317	NP_033640.1 cytochrome c oxidase subunit I [Lampetra fluviatilis]	diamond	52860	99	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
32192482	32192482	PRJNA314497_S_NODE_1958_length_157_cov_2.234375_g1935_i0	PRJNA314497	1958	157	2.234375	3.50796875	Phyllosticta citricarpa	55181	Fungi	Fungi	45.8	9.57e-4	NR	KAK7540103.1	55181	g1935	i0	70.4	1.5477707006369399	27	8	51.6	0	2	82	569	595	KAK7540103.1 hypothetical protein IWX46DRAFT_606636 [Phyllosticta citricarpa]	diamond	243	45.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Botryosphaeriales	Phyllostictaceae	Phyllosticta	Phyllosticta citricarpa
32666462	32666462	PRJNA314497_P_NODE_4820_length_162_cov_1.654135_g4668_i0	PRJNA314497	4820	162	1.654135	2.6796987	Scheffersomyces stipitis	4924	Fungi	Fungi	58.2	3.85e-8	NR	KAG2732346.1	4924	g4668	i0	60	2.5	45	18	83.3	0	161	27	258	302	KAG2732346.1 hypothetical protein G9P44_004763 [Scheffersomyces stipitis]	diamond	405	58.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Scheffersomyces	Scheffersomyces stipitis
32760961	32760961	PRJNA314497_S_NODE_980_length_236_cov_2.507246_g957_i0	PRJNA314497	980	236	2.507246	5.91710056	Eleutherodactylus atkinsi	448426	Chordata	Chordata	88.6	2.32e-18	NR	AGN71168.1	448426	g957	i0	97.5	14.7457627118644	40	1	50.8	0	102	221	410	449	AGN71168.1 cytochrome c oxidase subunit I [Eleutherodactylus atkinsi]	diamond	3480	89	0.995505617977528	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Eleutherodactylidae	Eleutherodactylus	Eleutherodactylus atkinsi

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