metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA796639" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA796639" 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_order	tax_family	tax_genus	tax_species
7158942	7158942	PRJNA796639_P_NODE_6286_length_248_cov_0.880000_g6161_i0	PRJNA796639	6286	248	0.88	2.1824	Mycolicibacterium chitae	1792	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1806410789\|dbj\|AP022604.1\|	1792	g6161	i0	100	0.233870967741935	29	0	12	0	28	56	4866058	4866086	Mycolicibacterium chitae JCM 12403 DNA, nearly complete genome	blastn	58	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium chitae
9708761	9708761	PRJNA796639_P_NODE_6228_length_248_cov_0.880000_g6103_i0	PRJNA796639	6228	248	0.88	2.1824	uncultured Eubacteriales bacterium	172733	Bacteria	Bacteria	340	4.27e-89	NTclustered	gi\|2729058706\|emb\|OZ007006.1\|	172733	g6103	i0	91.498	8.96774193548387	247	21	99	0	1	247	7078	7324	MAG: uncultured Eubacteriales bacterium isolate metabat2_pooled_hifiasm.126 MAG genome assembly, chromosome: 1	blastn	2224	340	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales			uncultured Eubacteriales bacterium
12260021	12260021	PRJNA796639_P_NODE_4810_length_268_cov_1.579487_g4685_i0	PRJNA796639	4810	268	1.579487	4.23302516	Apilactobacillus apisilvae	2923364	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2239972674\|gb\|CP093362.1\|	2923364	g4685	i0	100	0.108208955223881	29	0	11	0	72	100	96647	96619	Apilactobacillus apisilvae strain SG5_A10 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Apilactobacillus	Apilactobacillus apisilvae
12260064	12260064	PRJNA796639_P_NODE_7370_length_243_cov_0.905882_g7245_i0	PRJNA796639	7370	243	0.905882	2.20129326	Nocardioides sp. S5	2017486	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1999037722\|gb\|CP022296.1\|	2017486	g7245	i0	100	230.102880658436	243	0	100	0	1	243	1843263	1843505	Nocardioides sp. S5 chromosome, complete genome	blastn	55915	449	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. S5
12696259	12696259	PRJNA796639_P_NODE_7830_length_241_cov_0.916667_g7705_i0	PRJNA796639	7830	241	0.916667	2.20916747	Peribacillus	2675229	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1906925978\|gb\|CP050509.1\|	421767	g7705	i0	99.585	1139.9377593361	241	1	100	0	1	241	5138452	5138692	Peribacillus butanolivorans strain KJ40 chromosome, complete genome	blastn	274725	440	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus butanolivorans
13534145	13534145	PRJNA796639_P_NODE_3431_length_304_cov_1.129870_g3306_i0	PRJNA796639	3431	304	1.12987	3.4348048	Streptomyces sp. cg36	3238798	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2784064359\|gb\|CP163520.1\|	3238798	g3306	i0	100	0.0921052631578947	28	0	9	0	254	281	995425	995398	Streptomyces sp. cg36 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. cg36
14809083	14809083	PRJNA796639_P_NODE_5632_length_251_cov_0.865169_g5507_i0	PRJNA796639	5632	251	0.865169	2.17157419	Crocosphaera subtropica	2546360	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|171696371\|gb\|CP000806.1\|	43989	g5507	i0	100	0.111553784860558	28	0	11	0	24	51	2156137	2156164	Cyanothece sp. ATCC 51142 circular chromosome, complete sequence	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica
16519500	16519500	PRJNA796639_P_NODE_1313_length_491_cov_1.031100_g1188_i0	PRJNA796639	1313	491	1.0311	5.062701	Cutibacterium	1912216	Bacteria	Bacteria	898	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g1188	i0	99.594	270.720977596741	493	0	100	1	1	491	608443	608935	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	132924	898	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19068301	19068301	PRJNA796639_P_NODE_4275_length_280_cov_1.681159_g4150_i0	PRJNA796639	4275	280	1.681159	4.7072452	Nocardioides	1839	Bacteria	Bacteria	501	2.13e-137	NTclustered	gi\|1605178659\|gb\|CP038267.1\|	2518370	g4150	i0	98.929	235.482142857143	280	3	100	0	1	280	573651	573372	Nocardioides euryhalodurans strain MMS17-SY117 chromosome, complete genome	blastn	65935	501	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides euryhalodurans
24168233	24168233	PRJNA796639_P_NODE_5659_length_251_cov_0.865169_g5534_i0	PRJNA796639	5659	251	0.865169	2.17157419	Lactiplantibacillus	2767842	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2739944818\|emb\|OZ061355.1\|	1589	g5534	i0	100	480.358565737052	251	0	100	0	1	251	1279560	1279310	Lactiplantibacillus pentosus isolate Lactiplantibacillus pentosus CNRZ1547 genome assembly, chromosome: 1	blastn	120570	464	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus pentosus
25006969	25006969	PRJNA796639_P_NODE_6600_length_247_cov_0.885057_g6475_i0	PRJNA796639	6600	247	0.885057	2.18609079	Enterococcus faecalis	1351	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1963785894\|emb\|LR962464.1\|	1351	g6475	i0	100	100	247	0	100	0	1	247	2123226	2122980	Enterococcus faecalis isolate 28157_4#317 genome assembly, chromosome: 1	blastn	24700	457	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
25443370	25443370	PRJNA796639_P_NODE_1860_length_410_cov_2.323442_g1735_i0	PRJNA796639	1860	410	2.323442	9.5261122	Cutibacterium	1912216	Bacteria	Bacteria	758	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1735	i0	100	250.648780487805	410	0	100	0	1	410	55374	55783	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	102766	758	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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