metadata: contig_metadata: 16 rows where analysis = "diamond" and bioproject = "PRJNA688157"

16 rows where analysis = "diamond" and bioproject = "PRJNA688157"

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
25403211	25403211	PRJNA688157_S_NODE_42880_length_318_cov_1.559184_g42738_i0	PRJNA688157	42880	318	1.559184	4.95820512	root	1	Root_unresolved	Root_unresolved	134	2.83e-36	NR	WP_270022569.1	287	g42738	i0	66	424.603773584906	97	33	91.5	0	1	291	88	184	WP_270022569.1 hypothetical protein [Pseudomonas aeruginosa]	diamond	135024	135	0.992592592592593	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
27335251	27335251	PRJNA688157_S_NODE_68703_length_272_cov_3.130653_g68561_i0	PRJNA688157	68703	272	3.130653	8.51537616	Aureitalea sp. L	1872661	Bacteria	Bacteria	45.4	0.00596	NR	WP_265198814.1	2816962	g68561	i0	40.4	0.573529411764706	52	31	57.4	0	115	270	252	303	WP_265198814.1 hybrid sensor histidine kinase/response regulator [Aureitalea sp. L0-47]	diamond	156	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureitalea	Aureitalea sp. L0-47
28787374	28787374	PRJNA688157_S_NODE_507_length_996_cov_10.564464_g463_i0	PRJNA688157	507	996	10.564464	105.22206144	Moloney murine leukemia virus	11801	Viruses	Viruses	610	4.4799999999999985e-202	NR	NP_057933.2	11801	g463	i0	97.8	0.94578313253012	314	7	94.6	0	996	55	1022	1335	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	942	610	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
28882184	28882184	PRJNA688157_S_NODE_328_length_1112_cov_17.203080_g296_i0	PRJNA688157	328	1112	17.20308	191.2982496	Gammaretrovirus murleu	3428959	Viruses	Viruses	719	2.7400000000000005e-259	NR	8WUS_E	11801	g296	i0	98.6	8.63579136690647	356	5	96	0	1073	6	19	374	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	9603	719	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
29135117	29135117	PRJNA688157_S_NODE_39269_length_326_cov_1.644269_g39127_i0	PRJNA688157	39269	326	1.644269	5.36031694	Sarocladium implicatum	1610689	Fungi	Fungi	209	1.87e-64	NR	KAH8178064.1	1610689	g39127	i0	83.3	1.98773006134969	108	18	99.4	0	325	2	241	348	KAH8178064.1 alpha/beta hydrolase fold domain-containing protein [Sarocladium implicatum]	diamond	648	209	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium implicatum
29135118	29135118	PRJNA688157_S_NODE_61809_length_283_cov_1.547619_g61667_i0	PRJNA688157	61809	283	1.547619	4.37976177	Yeast integrative vector pYFP-Lim4-CFP	1400784	Root_unresolved	Root_unresolved	76.6	7.21e-14	NR	AGW21640.1	1400784	g61667	i0	54	0.92226148409894	87	35	86.9	3	1	246	221	307	AGW21640.1 NLS-YFP-Lim4-CFP [Yeast integrative vector pYFP-Lim4-CFP]	diamond	261	76.6	1									Yeast integrative vector pYFP-Lim4-CFP
29545201	29545201	PRJNA688157_S_NODE_40870_length_322_cov_2.208835_g40728_i0	PRJNA688157	40870	322	2.208835	7.1124487	Shuttle vector pME8	1296590	Root_unresolved	Root_unresolved	60.1	1.69e-8	NR	AGH24530.1	1296590	g40728	i0	71.7	0.428571428571429	46	13	42.9	0	166	29	127	172	AGH24530.1 Mob [Shuttle vector pME8]	diamond	138	60.1	1									Shuttle vector pME8
30283808	30283808	PRJNA688157_S_NODE_95092_length_243_cov_0.917647_g94950_i0	PRJNA688157	95092	243	0.917647	2.22988221	synthetic construct	32630	Root_unresolved	Root_unresolved	105	2.13e-24	NR	AJF23728.1	32630	g94950	i0	70.4	12.2345679012346	71	19	85.2	1	1	207	89	159	AJF23728.1 crowding sensor Cr1 [synthetic construct]	diamond	2973	105	1									synthetic construct
30567400	30567400	PRJNA688157_S_NODE_29673_length_352_cov_2.433692_g29531_i0	PRJNA688157	29673	352	2.433692	8.56659584	root	1	Root_unresolved	Root_unresolved	181	3.3499999999999995e-55	NR	WP_163883712.1	1076926	g29531	i0	72.4	308.446022727273	116	32	98.9	0	4	351	7	122	WP_163883712.1 hypothetical protein, partial [Rhizobium laguerreae]	diamond	108573	181	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium laguerreae
31389559	31389559	PRJNA688157_S_NODE_33276_length_341_cov_4.895522_g33134_i0	PRJNA688157	33276	341	4.895522	16.69373002	Metazoa	33208	Arthropoda	Arthropoda	49.7	3.86e-4	NR	XP_023015979.1	7539	g33134	i0	59	2.3841642228739	39	15	33.4	1	112	225	292	330	XP_023015979.1 uncharacterized protein LOC111505411 [Leptinotarsa decemlineata]	diamond	813	49.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Leptinotarsa	Leptinotarsa decemlineata
31536186	31536186	PRJNA688157_S_NODE_68936_length_272_cov_1.763819_g68794_i0	PRJNA688157	68936	272	1.763819	4.79758768	Cladosporium halotolerans	1052096	Fungi	Fungi	95.5	1.46e-20	NR	XP_069225492.1	1052096	g68794	i0	79.7	0.650735294117647	59	7	65.1	1	272	96	575	628	XP_069225492.1 uncharacterized protein WHR41_08899 [Cladosporium halotolerans]	diamond	177	95.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
31737172	31737172	PRJNA688157_S_NODE_14197_length_420_cov_3.031700_g14055_i0	PRJNA688157	14197	420	3.0317	12.73314	Fructilactobacillus	2767881	Bacteria	Bacteria	100	1.44e-24	NR	WP_006573365.1	2	g14055	i0	68.8	1.14285714285714	80	25	57.1	0	319	80	5	84	WP_006573365.1 MULTISPECIES: hypothetical protein [Bacteria]	diamond	480	100	1	Bacteria
32085263	32085263	PRJNA688157_S_NODE_83998_length_252_cov_1.301676_g83856_i0	PRJNA688157	83998	252	1.301676	3.28022352	Rhizoctonia	1322061	Fungi	Fungi	46.2	0.00227	NR	KAJ1307419.1	456999	g83856	i0	66.7	0.94047619047619	27	9	32.1	0	2	82	274	300	KAJ1307419.1 hypothetical protein OPQ81_001521 [Rhizoctonia solani]	diamond	237	46.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
32465182	32465182	PRJNA688157_S_NODE_98679_length_233_cov_2.393750_g98537_i0	PRJNA688157	98679	233	2.39375	5.5774375	root	1	Root_unresolved	Root_unresolved	122	7.389999999999999e-32	NR	WP_270022569.1	287	g98537	i0	76.4	418.094420600858	72	17	92.7	0	2	217	27	98	WP_270022569.1 hypothetical protein [Pseudomonas aeruginosa]	diamond	97416	123	0.991869918699187	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
32863296	32863296	PRJNA688157_S_NODE_51840_length_300_cov_2.057269_g51698_i0	PRJNA688157	51840	300	2.057269	6.171807	Trematosphaeria pertusa	390896	Fungi	Fungi	56.6	7.93e-7	NR	XP_033675286.1	390896	g51698	i0	38.6	2.9	88	53	88	1	23	286	77	163	XP_033675286.1 uncharacterized protein BU26DRAFT_556950 [Trematosphaeria pertusa]	diamond	870	56.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Trematosphaeriaceae	Trematosphaeria	Trematosphaeria pertusa
32894676	32894676	PRJNA688157_S_NODE_10160_length_453_cov_2.678947_g10018_i0	PRJNA688157	10160	453	2.678947	12.13562991	Sulfitobacter sp.	1903071	Bacteria	Bacteria	44.7	0.0316	NR	MEH6831101.1	1903071	g10018	i0	46.2	0.258278145695364	39	20	25.2	1	160	273	36	74	MEH6831101.1 GNAT family N-acetyltransferase [Sulfitobacter sp.]	diamond	117	44.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Roseobacteraceae	Sulfitobacter	Sulfitobacter sp.

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