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

10 rows where analysis = "diamond", bioproject = "PRJNA1009807" and tax_superkingdom = "Eukaryota"

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
26907941	26907941	PRJNA1009807_S_NODE_122_length_663_cov_3.791667_g105_i0	PRJNA1009807	122	663	3.791667	25.13875221	Trichuris suis	68888	Nematoda	Nematoda	52.4	6.44e-4	NR	KFD59988.1	68888	g105	i0	41.3	0.470588235294118	104	51	43	3	466	182	207	309	KFD59988.1 LOW QUALITY PROTEIN: hypothetical protein M514_27836 [Trichuris suis]	diamond	312	52.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
27571628	27571628	PRJNA1009807_S_NODE_2624_length_196_cov_1.050955_g2596_i0	PRJNA1009807	2624	196	1.050955	2.0598718	Ophiocordyceps australis	1399860	Fungi	Fungi	42.4	0.0274	NR	PHH61573.1	1399860	g2596	i0	45.5	0.673469387755102	44	19	59.7	1	27	143	449	492	PHH61573.1 hypothetical protein CDD81_8154 [Ophiocordyceps australis]	diamond	132	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Ophiocordyceps	Ophiocordyceps australis
27603429	27603429	PRJNA1009807_S_NODE_4064_length_164_cov_1.480000_g4036_i0	PRJNA1009807	4064	164	1.48	2.4272	Paragonimus westermani	34504	Platyhelminthes	Platyhelminthes	57.4	8.58e-8	NR	KAA3669829.1	34504	g4036	i0	54	1.82926829268293	50	23	91.5	0	162	13	180	229	KAA3669829.1 uncharacterized protein DEA37_0001408, partial [Paragonimus westermani]	diamond	300	57.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus westermani
27824400	27824400	PRJNA1009807_S_NODE_1864_length_227_cov_2.148936_g1836_i0	PRJNA1009807	1864	227	2.148936	4.87808472	Porites lobata	104759	Cnidaria	other_Eukaryota	42.7	0.0298	NR	CAH3174760.1	104759	g1836	i0	50	0.475770925110132	36	18	47.6	0	46	153	363	398	CAH3174760.1 unnamed protein product [Porites lobata]	diamond	108	42.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
27887285	27887285	PRJNA1009807_S_NODE_2725_length_192_cov_2.320261_g2697_i0	PRJNA1009807	2725	192	2.320261	4.45490112	Anthophora plagiata	597819	Arthropoda	Arthropoda	43.9	0.00747	NR	CAK9813121.1	597819	g2697	i0	48.6	2.734375	35	18	54.7	0	40	144	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
28487391	28487391	PRJNA1009807_S_NODE_1867_length_226_cov_7.636364_g1839_i0	PRJNA1009807	1867	226	7.636364	17.25818264	Cichorium endivia	114280	Plants	Plants	45.8	0.00249	NR	KAI3490028.1	114280	g1839	i0	57.1	1.02212389380531	42	18	55.8	0	219	94	303	344	KAI3490028.1 hypothetical protein L1887_45857 [Cichorium endivia]	diamond	231	45.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Cichorium	Cichorium endivia
28992807	28992807	PRJNA1009807_S_NODE_3148_length_182_cov_1.202797_g3120_i0	PRJNA1009807	3148	182	1.202797	2.18909054	Petrolisthes cinctipes	88211	Arthropoda	Arthropoda	99.8	1.4000000000000002e-22	NR	KAK3884497.1	88211	g3120	i0	70	1.96153846153846	60	18	98.9	0	2	181	139	198	KAK3884497.1 hypothetical protein Pcinc_011235 [Petrolisthes cinctipes]	diamond	357	99.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Porcellanidae	Petrolisthes	Petrolisthes cinctipes
30666371	30666371	PRJNA1009807_S_NODE_2453_length_201_cov_1.746914_g2425_i0	PRJNA1009807	2453	201	1.746914	3.51129714	Polychytrium aggregatum	110093	Fungi	Fungi	50.4	2.01e-6	NR	KAI9188549.1	110093	g2425	i0	50	0.686567164179104	46	23	68.7	0	182	45	1	46	KAI9188549.1 hypothetical protein BJ171DRAFT_549717 [Polychytrium aggregatum]	diamond	138	50.4	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
30761315	30761315	PRJNA1009807_S_NODE_4454_length_158_cov_1.899160_g4426_i0	PRJNA1009807	4454	158	1.89916	3.0006728	Tanacetum cinerariifolium	118510	Plants	Plants	45.8	9.68e-4	NR	GEU28441.1	118510	g4426	i0	48	0.949367088607595	50	26	94.9	0	9	158	2848	2897	GEU28441.1 hypothetical protein [Tanacetum cinerariifolium]	diamond	150	45.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
31132567	31132567	PRJNA1009807_S_NODE_4535_length_157_cov_1.042373_g4507_i0	PRJNA1009807	4535	157	1.042373	1.63652561	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	78.2	1.21e-16	NR	CAI2383002.1	5936	g4507	i0	66	3.82165605095541	50	17	95.5	0	152	3	72	121	CAI2383002.1 unnamed protein product [Moneuplotes crassus]	diamond	600	78.2	1	Eukaryota	Sar		Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus

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