metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA645397" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA645397" and tax_phylum = "Actinomycetota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
12099010	12099010	PRJNA645397_P_NODE_7650_length_187_cov_1.101449_g7577_i0	PRJNA645397	7650	187	1.101449	2.05970963	Mycobacteroides abscessus	36809	Bacteria	Bacteria	60.1	6.39e-9	NR	WP_119636024.1	36809	g7577	i0	96.4	0.449197860962567	28	1	44.9	0	161	78	198	225	WP_119636024.1 hypothetical protein [Mycobacteroides abscessus]	diamond	84	60.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides abscessus
13373676	13373676	PRJNA645397_P_NODE_9311_length_169_cov_0.866667_g9238_i0	PRJNA645397	9311	169	0.866667	1.46466723	uncultured Corynebacterium sp.	159447	Bacteria	Bacteria	94	1.18e-20	NR	WP_288814934.1	159447	g9238	i0	97.9	0.85207100591716	48	1	85.2	0	164	21	278	325	WP_288814934.1 type VII secretion protein EccCb [uncultured Corynebacterium sp.]	diamond	144	94	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	uncultured Corynebacterium sp.
14648513	14648513	PRJNA645397_P_NODE_11052_length_162_cov_0.920354_g10979_i0	PRJNA645397	11052	162	0.920354	1.49097348	Ornithinimicrobium sp. F	1977084	Bacteria	Bacteria	84.3	2.65e-17	NR	WP_247090196.1	2926412	g10979	i0	87.5	0.888888888888889	48	6	88.9	0	161	18	563	610	WP_247090196.1 LTA synthase family protein [Ornithinimicrobium sp. F0845]	diamond	144	84.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Ornithinimicrobiaceae	Ornithinimicrobium	Ornithinimicrobium sp. F0845
15922455	15922455	PRJNA645397_P_NODE_7493_length_189_cov_1.142857_g7420_i0	PRJNA645397	7493	189	1.142857	2.15999973	Brevibacterium	1696	Bacteria	Bacteria	68.9	2.07e-12	NR	WP_063248792.1	1696	g7420	i0	97.3	0.587301587301587	37	1	58.7	0	188	78	164	200	WP_063248792.1 MULTISPECIES: TetR/AcrR family transcriptional regulator [Brevibacterium]	diamond	111	68.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium
19746445	19746445	PRJNA645397_P_NODE_8596_length_175_cov_1.293651_g8523_i0	PRJNA645397	8596	175	1.293651	2.26388925	Pseudonocardia alni	33907	Bacteria	Bacteria	83.2	6.86e-17	NR	WP_350589018.1	33907	g8523	i0	76.1	0.788571428571429	46	11	78.9	0	139	2	193	238	WP_350589018.1 phage portal protein [Pseudonocardia alni]	diamond	138	83.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia alni
28028977	28028977	PRJNA645397_P_NODE_9805_length_167_cov_0.881356_g9732_i0	PRJNA645397	9805	167	0.881356	1.47186452	Brevibacterium casei	33889	Bacteria	Bacteria	111	2.6e-27	NR	WP_259820315.1	33889	g9732	i0	100	0.988023952095808	55	0	98.8	0	165	1	267	321	WP_259820315.1 MFS transporter [Brevibacterium casei]	diamond	165	111	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
29386663	29386663	PRJNA645397_P_NODE_11049_length_162_cov_0.920354_g10976_i0	PRJNA645397	11049	162	0.920354	1.49097348	Microbacterium hibisci	2036000	Bacteria	Bacteria	104	2.54e-25	NR	WP_203579156.1	2036000	g10976	i0	90.7	1	54	5	100	0	1	162	82	135	WP_203579156.1 LysR family transcriptional regulator [Microbacterium hibisci]	diamond	162	104	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium hibisci
29607160	29607160	PRJNA645397_P_NODE_1510_length_419_cov_2.416216_g1444_i0	PRJNA645397	1510	419	2.416216	10.12394504	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	179	1.57e-51	NR	WP_303678908.1	1528099	g1444	i0	98.8	0.615751789976134	86	1	61.6	0	419	162	342	427	WP_303678908.1 glycosyltransferase 87 family protein [Lawsonella clevelandensis]	diamond	258	179	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
29891926	29891926	PRJNA645397_P_NODE_1811_length_388_cov_2.171091_g1740_i0	PRJNA645397	1811	388	2.171091	8.42383308	Asanoa sp.	1872643	Bacteria	Bacteria	47.8	8.36e-4	NR	HEV7711379.1	1872643	g1740	i0	35.4	0.981958762886598	127	70	92	5	8	364	1	123	HEV7711379.1 DUF2809 domain-containing protein [Asanoa sp.]	diamond	381	47.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Asanoa	Asanoa sp.
29967248	29967248	PRJNA645397_P_NODE_7311_length_191_cov_1.211268_g7238_i0	PRJNA645397	7311	191	1.211268	2.31352188	Actinomycetes	1760	Bacteria	Bacteria	106	6.24e-25	NR	WP_009380205.1	1696	g7238	i0	89.8	2.78010471204188	59	6	92.7	0	2	178	231	289	WP_009380205.1 MULTISPECIES: stealth family protein [Brevibacterium]	diamond	531	106	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium
30081104	30081104	PRJNA645397_P_NODE_2892_length_318_cov_3.561338_g2819_i0	PRJNA645397	2892	318	3.561338	11.32505484	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	208	1.7800000000000001e-63	NR	WP_303678908.1	1528099	g2819	i0	99	0.981132075471698	104	1	98.1	0	316	5	217	320	WP_303678908.1 glycosyltransferase 87 family protein [Lawsonella clevelandensis]	diamond	312	208	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31579047	31579047	PRJNA645397_P_NODE_10016_length_166_cov_0.888889_g9943_i0	PRJNA645397	10016	166	0.888889	1.47555574	Bacteria	2	Bacteria	Bacteria	64.7	2.33e-10	NR	PZU30716.1	51671	g9943	i0	54.5	2.89156626506024	55	25	99.4	0	2	166	295	349	PZU30716.1 MAG: teichoic acid transporter [Microbacterium sp.]	diamond	480	64.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp.
32136212	32136212	PRJNA645397_P_NODE_8738_length_173_cov_2.258065_g8665_i0	PRJNA645397	8738	173	2.258065	3.90645245	Actinomadura sp.	1989	Bacteria	Bacteria	42.4	0.0198	NR	HEV7934151.1	1989	g8665	i0	40.4	0.901734104046243	52	31	90.2	0	16	171	118	169	HEV7934151.1 5-(carboxyamino)imidazole ribonucleotide synthase [Actinomadura sp.]	diamond	156	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura sp.
32685580	32685580	PRJNA645397_P_NODE_4880_length_239_cov_0.852632_g4807_i0	PRJNA645397	4880	239	0.852632	2.03779048	Bacteria	2	Bacteria	Bacteria	152	1.07e-42	NR	WP_144589432.1	33889	g4807	i0	98.7	2.97489539748954	79	1	99.2	0	238	2	95	173	WP_144589432.1 nucleotide sugar dehydrogenase [Brevibacterium casei]	diamond	711	152	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
32799218	32799218	PRJNA645397_P_NODE_10940_length_162_cov_1.150442_g10867_i0	PRJNA645397	10940	162	1.150442	1.86371604	Brevibacterium casei	33889	Bacteria	Bacteria	88.2	1.18e-20	NR	WP_259820328.1	33889	g10867	i0	95.6	0.833333333333333	45	2	83.3	0	160	26	1	45	WP_259820328.1 carboxymuconolactone decarboxylase family protein [Brevibacterium casei]	diamond	135	88.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei

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