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

8 rows where analysis = "diamond", bioproject = "PRJNA683902" 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
26670395	26670395	PRJNA683902_S_NODE_30121_length_178_cov_1.652482_g29677_i0	PRJNA683902	30121	178	1.652482	2.94141796	Amycolatopsis anabasis	1840409	Bacteria	Bacteria	41.2	0.0404	NR	WP_158892349.1	1840409	g29677	i0	40.5	0.707865168539326	42	23	70.8	1	34	159	75	114	WP_158892349.1 hypothetical protein [Amycolatopsis anabasis]	diamond	126	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis anabasis
26987145	26987145	PRJNA683902_S_NODE_24822_length_204_cov_1.598802_g24378_i0	PRJNA683902	24822	204	1.598802	3.26155608	Mycobacterium neglectum	242737	Bacteria	Bacteria	42	0.0411	NR	WP_099042215.1	242737	g24378	i0	49.1	0.779411764705882	53	21	76.5	2	14	169	43	90	WP_099042215.1 TIGR01777 family oxidoreductase [Mycobacterium neglectum]	diamond	159	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium neglectum
27662611	27662611	PRJNA683902_S_NODE_32704_length_169_cov_1.477273_g32260_i0	PRJNA683902	32704	169	1.477273	2.49659137	Bacteria	2	Bacteria	Bacteria	52.8	3.89e-6	NR	WP_198965499.1	133549	g32260	i0	50	7.84615384615385	50	25	88.8	0	158	9	52	101	WP_198965499.1 non-ribosomal peptide synthetase [Mycobacterium shottsii]	diamond	1326	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium shottsii
28313977	28313977	PRJNA683902_S_NODE_22366_length_219_cov_3.412088_g21922_i0	PRJNA683902	22366	219	3.412088	7.47247272	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	42.7	0.0274	NR	WP_355920396.1	3154278	g21922	i0	43.8	0.657534246575342	48	25	63	1	31	168	1	48	WP_355920396.1 ribosome small subunit-dependent GTPase A [Streptomyces sp. NPDC004533]	diamond	144	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC004533
28862117	28862117	PRJNA683902_S_NODE_35748_length_160_cov_1.268293_g35304_i0	PRJNA683902	35748	160	1.268293	2.0292688	Bacteria	2	Bacteria	Bacteria	63.5	7.65e-11	NR	WP_271190726.1	85006	g35304	i0	100	1.125	30	0	56.3	0	91	2	1	30	WP_271190726.1 MULTISPECIES: hypothetical protein [Micrococcales]	diamond	180	63.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales
30145073	30145073	PRJNA683902_S_NODE_38752_length_153_cov_1.008621_g38308_i0	PRJNA683902	38752	153	1.008621	1.54319013	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	95.5	2.08e-21	NR	WP_303678795.1	1528099	g38308	i0	100	0.980392156862745	50	0	98	0	3	152	120	169	WP_303678795.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Lawsonella clevelandensis]	diamond	150	95.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
30366961	30366961	PRJNA683902_S_NODE_34032_length_165_cov_0.914062_g33588_i0	PRJNA683902	34032	165	0.914062	1.5082023	Lawsonella	1847725	Bacteria	Bacteria	117	3.32e-30	NR	WP_290599170.1	1847725	g33588	i0	100	0.981818181818182	54	0	98.2	0	3	164	254	307	WP_290599170.1 MULTISPECIES: ADP-ribosylglycohydrolase family protein [Lawsonella]	diamond	162	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
31820470	31820470	PRJNA683902_S_NODE_38617_length_153_cov_1.620690_g38173_i0	PRJNA683902	38617	153	1.62069	2.4796557	Nocardia brasiliensis	37326	Bacteria	Bacteria	68.9	4.05e-12	NR	WP_195136093.1	37326	g38173	i0	69.6	6.45098039215686	46	14	90.2	0	12	149	100	145	WP_195136093.1 dTDP-4-dehydrorhamnose reductase [Nocardia brasiliensis]	diamond	987	68.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia brasiliensis

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