metadata: contig_metadata: 8 rows where tax_clade = "marine Actinobacteria clade" and tax

8 rows where tax_clade = "marine Actinobacteria clade" and tax_kingdom = "Bacillati"

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_species
10079633	10079633	PRJNA630162_P_NODE_121968_length_173_cov_2.201613_g120445_i0	PRJNA630162	121968	173	2.201613	3.80879049	Bacteria	2	Bacteria	Bacteria	75	3.1e-9	NTclustered	gi\|14334232\|gb\|AY033296.1\|	159799	g120445	i0	79.439	1.5028901734104	107	20	61	2	8	113	1678	1783	Uncultured actinobacterium MB11A03 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	260	75	1	Bacteria	marine Actinobacteria clade	Bacillati	Actinomycetota	Actinomycetes	uncultured actinobacterium MB11A03
10906308	10906308	PRJNA704949_P_NODE_963009_length_266_cov_2.129032_g947674_i0	PRJNA704949	963009	266	2.129032	5.66322512	uncultured actinobacterium Rifle_16ft_4_minimus_15811	1665145	Bacteria	Bacteria	217	8.149999999999999e-52	NTclustered	gi\|874574165\|gb\|KT006959.1\|	1665145	g947674	i0	81.749	18.5714285714286	263	44	98	4	6	266	7080	6820	Uncultured actinobacterium Rifle_16ft_4_minimus_15811 genomic sequence	blastn	4940	217	1	Bacteria	marine Actinobacteria clade	Bacillati	Actinomycetota	Actinomycetes	uncultured actinobacterium Rifle_16ft_4_minimus_15811
18151073	18151073	PRJNA1148190_P_NODE_718175_length_244_cov_0.900585_g707002_i0	PRJNA1148190	718175	244	0.900585	2.1974274	uncultured actinobacterium Rifle_16ft_4_minimus_38826	1665148	Bacteria	Bacteria	274	4.31e-69	NTclustered	gi\|874576766\|gb\|KT007023.1\|	1665148	g707002	i0	87.448	10.6311475409836	239	28	98	2	1	238	22185	22422	Uncultured actinobacterium Rifle_16ft_4_minimus_38826 genomic sequence	blastn	2594	274	1	Bacteria	marine Actinobacteria clade	Bacillati	Actinomycetota	Actinomycetes	uncultured actinobacterium Rifle_16ft_4_minimus_38826
19490611	19490611	PRJNA168635_P_NODE_34976_length_153_cov_2.836538_g34560_i0	PRJNA168635	34976	153	2.836538	4.33990314	uncultured actinobacterium MB11C06	159800	Bacteria	Bacteria	97.1	5.71e-16	NTclustered	gi\|14334238\|gb\|AY033302.1\|	159800	g34560	i0	79.605	7.44444444444444	152	18	95	11	8	153	1748	1892	Uncultured actinobacterium MB11C06 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	1139	97.1	1	Bacteria	marine Actinobacteria clade	Bacillati	Actinomycetota	Actinomycetes	uncultured actinobacterium MB11C06
25508404	25508404	PRJEB14175_P_NODE_270457_length_189_cov_5.601562_g268189_i0	PRJEB14175	270457	189	5.601562	10.58695218	uncultured actinobacterium Rifle_16ft_4_minimus_9892	1665150	Bacteria	Bacteria	65.8	2.08e-6	NTclustered	gi\|874577995\|gb\|KT007057.1\|	1665150	g268189	i0	90.196	0.46031746031746	51	3	26	2	50	98	5272	5322	Uncultured actinobacterium Rifle_16ft_4_minimus_9892 genomic sequence	blastn	87	65.8	1	Bacteria	marine Actinobacteria clade	Bacillati	Actinomycetota	Actinomycetes	uncultured actinobacterium Rifle_16ft_4_minimus_9892
25885839	25885839	PRJEB20058_P_NODE_231827_length_229_cov_23.845238_g229002_i0	PRJEB20058	231827	229	23.845238	54.60559502	Bacteria	2	Bacteria	Bacteria	80.5	9.37e-11	NTclustered	gi\|14334232\|gb\|AY033296.1\|	159799	g229002	i0	78.125	1.41048034934498	128	26	55	2	80	206	1783	1657	Uncultured actinobacterium MB11A03 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	323	80.5	1	Bacteria	marine Actinobacteria clade	Bacillati	Actinomycetota	Actinomycetes	uncultured actinobacterium MB11A03
27770721	27770721	PRJNA414036_P_NODE_18244_length_351_cov_422.509494_g16530_i0	PRJNA414036	18244	351	422.509494	1483.00832394	uncultured actinobacterium HF	152507	Bacteria	Bacteria	57.4	3.29e-7	NR	ADI22944.1	723604	g16530	i0	40.4	1.1965811965812	94	55	79.5	1	45	323	85	178	ADI22944.1 hypothetical protein [uncultured actinobacterium HF0500_35G12]	diamond	420	57.4	1	Bacteria	marine Actinobacteria clade	Bacillati	Actinomycetota	Actinomycetes	uncultured actinobacterium HF0500_35G12
32653132	32653132	PRJNA550047_P_NODE_236480_length_301_cov_3.135965_g234511_i0	PRJNA550047	236480	301	3.135965	9.43925465	Bacillati	1783272	Bacteria	Bacteria	54.7	2.26e-6	NR	AKQ04440.1	1665149	g234511	i0	49.1	3.97674418604651	55	28	54.8	0	297	133	102	156	AKQ04440.1 30S ribosomal protein S4, small subunit ribosomal protein S4 [uncultured actinobacterium Rifle_16ft_4_minimus_550]	diamond	1197	54.7	1	Bacteria	marine Actinobacteria clade	Bacillati	Actinomycetota	Actinomycetes	uncultured actinobacterium Rifle_16ft_4_minimus_550

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