metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA885753" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA885753" 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
5965012	5965012	PRJNA885753_S_NODE_2305_length_301_cov_2.508772_g2287_i0	PRJNA885753	2305	301	2.508772	7.55140372	Corynebacterium comes	2675218	Bacteria	Bacteria	551	2.2699999999999992e-152	NTclustered	gi\|1782155183\|gb\|CP046453.1\|	2675218	g2287	i0	99.668	441.12292358804	301	1	100	0	1	301	701989	702289	Corynebacterium comes strain 2019 chromosome, complete genome	blastn	132778	551	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium comes
8514600	8514600	PRJNA885753_S_NODE_1527_length_353_cov_1.657143_g1509_i0	PRJNA885753	1527	353	1.657143	5.84971479	Corynebacterium humireducens	1223514	Bacteria	Bacteria	597	3.42e-166	NTclustered	gi\|748228406\|gb\|CP005286.1\|	1223515	g1509	i0	97.167	401.640226628895	353	10	100	0	1	353	626527	626879	Corynebacterium humireducens NBRC 106098 = DSM 45392, complete genome	blastn	141779	597	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium humireducens
8514652	8514652	PRJNA885753_S_NODE_867_length_450_cov_3.053050_g849_i0	PRJNA885753	867	450	3.05305	13.738725	Priestia megaterium	1404	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|1830450554\|gb\|CP051128.1\|	1404	g849	i0	100	0.0622222222222222	28	0	6	0	377	404	2883836	2883809	Priestia megaterium strain S2 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
10169934	10169934	PRJNA885753_S_NODE_1668_length_341_cov_1.518657_g1650_i0	PRJNA885753	1668	341	1.518657	5.17862037	Mycobacteriaceae	1762	Bacteria	Bacteria	599	9.18e-167	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g1650	i0	100	157.067448680352	324	0	95	0	1	324	1313057	1313380	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	53560	599	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
10169938	10169938	PRJNA885753_S_NODE_3688_length_252_cov_0.871508_g3670_i0	PRJNA885753	3688	252	0.871508	2.19620016	Listeria	1637	Bacteria	Bacteria	438	1.5e-118	NTclustered	gi\|2207579355\|gb\|CP084086.1\|	1642	g3670	i0	98.016	99.9960317460317	252	5	100	0	1	252	2150161	2150412	Listeria innocua strain ZM39 chromosome	blastn	25199	438	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria innocua
13615350	13615350	PRJNA885753_S_NODE_3931_length_249_cov_1.170455_g3913_i0	PRJNA885753	3931	249	1.170455	2.91443295	Tessaracoccus timonensis	2161816	Bacteria	Bacteria	414	2.49e-111	NTclustered	gi\|1379009977\|emb\|LT996886.1\|	2161816	g3913	i0	97.917	190.144578313253	240	4	96	1	1	240	1995234	1994996	Tessaracoccus sp. Marseille-P5995 genome assembly, chromosome: contig00001	blastn	47346	414	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Tessaracoccus	Tessaracoccus timonensis
13995211	13995211	PRJNA885753_S_NODE_1011_length_420_cov_1.974063_g993_i0	PRJNA885753	1011	420	1.974063	8.2910646	Mycobacteriaceae	1762	Bacteria	Bacteria	776	0	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g993	i0	100	190.278571428571	420	0	100	0	1	420	1313064	1312645	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	79917	776	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
16164458	16164458	PRJNA885753_S_NODE_3053_length_269_cov_2.020408_g3035_i0	PRJNA885753	3053	269	2.020408	5.43489752	Corynebacterium humireducens	1223514	Bacteria	Bacteria	401	2.1199999999999993e-107	NTclustered	gi\|748228406\|gb\|CP005286.1\|	1223515	g3035	i0	93.704	330.230483271375	270	14	100	3	1	269	1274788	1275055	Corynebacterium humireducens NBRC 106098 = DSM 45392, complete genome	blastn	88832	401	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium humireducens
16543888	16543888	PRJNA885753_S_NODE_4033_length_248_cov_0.891429_g4015_i0	PRJNA885753	4033	248	0.891429	2.21074392	Chroococcidiopsidales	1890505	Bacteria	Bacteria	315	2.59e-81	NTclustered	gi\|225696214\|gb\|FJ805881.1\|	259957	g4015	i0	89.683	174.245967741935	252	18	100	5	1	248	1859	2106	Uncultured Chroococcidiopsis sp. clone A3_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43213	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17439921	17439921	PRJNA885753_S_NODE_4214_length_246_cov_0.901734_g4196_i0	PRJNA885753	4214	246	0.901734	2.21826564	Capillimicrobium parvum	2884022	Bacteria	Bacteria	398	2.4799999999999997e-106	NTclustered	gi\|2164499877\|gb\|CP087164.1\|	2884022	g4196	i0	95.951	100.772357723577	247	6	100	4	1	246	2764372	2764129	Capillimicrobium parvum strain 0166_1 chromosome, complete genome	blastn	24790	398	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Capillimicrobiaceae	Capillimicrobium	Capillimicrobium parvum
18713087	18713087	PRJNA885753_S_NODE_1475_length_358_cov_1.905263_g1457_i0	PRJNA885753	1475	358	1.905263	6.82084154	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	651	0	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g1457	i0	99.441	390.18156424581	358	2	100	0	1	358	81648	81291	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	139685	651	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
18713133	18713133	PRJNA885753_S_NODE_4235_length_246_cov_0.895954_g4217_i0	PRJNA885753	4235	246	0.895954	2.20404684	Clostridium baratii	1561	Bacteria	Bacteria	340	4.2299999999999996e-89	NTclustered	gi\|2695223087\|gb\|CP124306.1\|	1561	g4217	i0	91.803	202.752032520325	244	20	99	0	1	244	3164749	3164506	Clostridium baratii strain C201 chromosome, complete genome	blastn	49877	340	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium baratii
19092810	19092810	PRJNA885753_S_NODE_515_length_585_cov_4.412109_g499_i0	PRJNA885753	515	585	4.412109	25.81083765	root	1	Root_unresolved	Root_unresolved	809	0	NTclustered	gi\|119433766\|gb\|EF032505.1\|	2017	g499	i0	100	69.4410256410256	438	0	75	0	85	522	69444	69007	Streptoalloteichus hindustanus strain ATCC 31158 tallysomycin biosynthetic gene cluster, complete sequence	blastn	40623	813	0.995079950799508	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Streptoalloteichus	Streptoalloteichus hindustanus
21263686	21263686	PRJNA885753_S_NODE_2297_length_302_cov_0.903930_g2279_i0	PRJNA885753	2297	302	0.90393	2.7298686	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	553	6.32e-153	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g2279	i0	99.669	386.890728476821	302	1	100	0	1	302	886042	885741	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	116841	553	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
21263703	21263703	PRJNA885753_S_NODE_3717_length_252_cov_0.871508_g3699_i0	PRJNA885753	3717	252	0.871508	2.19620016	Listeria innocua	1642	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2027970313\|gb\|CP071179.1\|	1642	g3699	i0	100	100	252	0	100	0	1	252	2246755	2246504	Listeria innocua strain LI47 chromosome, complete genome	blastn	25200	466	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria innocua
21643533	21643533	PRJNA885753_S_NODE_3097_length_268_cov_0.769231_g3079_i0	PRJNA885753	3097	268	0.769231	2.06153908	Oscillatoriales	1150	Bacteria	Bacteria	420	5.84e-113	NTclustered	gi\|46409899\|gb\|AY584524.1\|	272133	g3079	i0	96.813	127.992537313433	251	8	94	0	4	254	523	773	Microcoleus sp. PCC 8701 23S ribosomal RNA gene, partial sequence	blastn	34302	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PCC 8701
23813918	23813918	PRJNA885753_S_NODE_2679_length_284_cov_1.644550_g2661_i0	PRJNA885753	2679	284	1.64455	4.670522	Mycolicibacterium aubagnense	319707	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|1806292234\|dbj\|AP022577.1\|	319707	g2661	i0	100	161.62676056338	281	0	99	0	4	284	947176	946896	Mycolicibacterium aubagnense JCM 15296 DNA, complete genome	blastn	45902	520	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aubagnense
24192874	24192874	PRJNA885753_S_NODE_3379_length_260_cov_0.791444_g3361_i0	PRJNA885753	3379	260	0.791444	2.0577544	Micrococcales	85006	Bacteria	Bacteria	331	2.72e-86	NTclustered	gi\|2442350572\|gb\|CP110680.1\|	1708	g3361	i0	89.961	279.269230769231	259	23	99	3	1	259	3280406	3280661	Cellulomonas fimi strain Clb-11 chromosome, complete genome	blastn	72610	331	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas fimi

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