metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJEB56699" and tax

32 rows where analysis = "blastn", bioproject = "PRJEB56699" 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
124576	124576	PRJEB56699_P_NODE_4201_length_238_cov_3.602871_g3971_i0	PRJEB56699	4201	238	3.602871	8.57483298	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	363	8.69e-96	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g3971	i0	94.191	241.726890756303	241	8	100	4	1	238	1858572	1858335	Calothrix sp. PCC 7716 DNA, complete genome	blastn	57531	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
2267278	2267278	PRJEB56699_P_NODE_5722_length_191_cov_1.339506_g5492_i0	PRJEB56699	5722	191	1.339506	2.55845646	Candidatus Planktophila	622681	Bacteria	Bacteria	346	6.73e-91	NTclustered	gi\|1877811242\|gb\|CP029557.1\|	1848255	g5492	i0	99.474	85.3246073298429	190	1	99	0	2	191	917887	918076	Actinobacteria bacterium IMCC25003 chromosome, complete genome	blastn	16297	346	1	Bacteria		Bacillati	Actinomycetota					Actinobacteria bacterium IMCC25003
3542568	3542568	PRJEB56699_P_NODE_423_length_886_cov_4.002334_g191_i1	PRJEB56699	423	886	4.002334	35.46067924	Cutibacterium	1912216	Bacteria	Bacteria	1079	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g191	i1	94.595	306.013544018059	703	28	92	10	32	730	56599	57295	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	271128	1079	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4819978	4819978	PRJEB56699_P_NODE_1844_length_421_cov_5.056122_g1621_i0	PRJEB56699	1844	421	5.056122	21.28627362	Micrococcus	1269	Bacteria	Bacteria	505	2.5899999999999995e-138	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g1621	i0	98.606	250.688836104513	287	0	68	4	137	421	346168	346452	Micrococcus luteus strain V017 chromosome, complete genome	blastn	105540	505	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
4819979	4819979	PRJEB56699_P_NODE_2124_length_387_cov_18.000000_g1898_i0	PRJEB56699	2124	387	18	69.66	Rhodococcus	1827	Bacteria	Bacteria	689	0	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g1898	i0	98.961	418.279069767442	385	4	99	0	3	387	560755	560371	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	161874	689	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
4819986	4819986	PRJEB56699_P_NODE_6044_length_178_cov_1.315436_g5814_i0	PRJEB56699	6044	178	1.315436	2.34147608	Streptococcus	1301	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g5814	i0	100	345.056179775281	178	0	100	0	1	178	1568768	1568945	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	61420	329	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
5227145	5227145	PRJEB56699_P_NODE_1045_length_573_cov_3.560662_g871_i0	PRJEB56699	1045	573	3.560662	20.40259326	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	880	0	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g871	i0	95.113	442.212914485166	573	3	100	2	1	573	885532	886079	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	253388	880	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
5227153	5227153	PRJEB56699_P_NODE_6525_length_156_cov_7.976378_g6295_i0	PRJEB56699	6525	156	7.976378	12.44314968	Bacillota bacterium	1879010	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|1328374770\|dbj\|LC361041.1\|	1879010	g6295	i0	100	119.333333333333	156	0	100	0	1	156	107	262	Firmicutes bacterium gene for 16S ribosomal RNA, partial sequence	blastn	18616	289	1	Bacteria		Bacillati	Bacillota					Bacillota bacterium
6502836	6502836	PRJEB56699_P_NODE_1386_length_498_cov_6.861407_g1188_i0	PRJEB56699	1386	498	6.861407	34.16980686	Calothrix parietina	32054	Bacteria	Bacteria	881	0	NTclustered	gi\|1345606777\|gb\|MG968511.1\|	2081933	g1188	i0	98.982	191.913654618474	491	5	99	0	8	498	1	491	Calothrix parietina UTEX LB 1952 23S ribosomal RNA gene, partial sequence	blastn	95573	881	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parietina
7777052	7777052	PRJEB56699_P_NODE_1147_length_549_cov_3.451923_g871_i1	PRJEB56699	1147	549	3.451923	18.95105727	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	935	0	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g871	i1	97.464	399.765027322404	552	7	100	7	1	549	885532	886079	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	219471	935	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
8645168	8645168	PRJEB56699_P_NODE_2487_length_351_cov_44.916149_g2259_i0	PRJEB56699	2487	351	44.916149	157.65568299	root	1	Root_unresolved	Root_unresolved	606	5.639999999999997e-169	NTclustered	gi\|29893122\|dbj\|AB108478.1\|	1747	g2259	i0	97.727	135.373219373219	352	6	99	2	1	350	1	352	Propionibacterium acnes gene for 16S ribosomal RNA, partial sequence, isolate: #4860	blastn	47516	610	0.99344262295082	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8645169	8645169	PRJEB56699_P_NODE_267_length_1125_cov_5.971715_g191_i0	PRJEB56699	267	1125	5.971715	67.18179375	Cutibacterium	1912216	Bacteria	Bacteria	1613	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g191	i0	96.708	255.304888888889	972	26	97	6	157	1125	57295	56327	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	287218	1613	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11195352	11195352	PRJEB56699_P_NODE_2829_length_323_cov_5.993197_g2599_i0	PRJEB56699	2829	323	5.993197	19.35802631	Micrococcus	1269	Bacteria	Bacteria	529	1.1499999999999999e-145	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g2599	i0	96.285	160.030959752322	323	10	100	2	1	323	2260334	2260654	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	51690	529	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
11603021	11603021	PRJEB56699_P_NODE_2470_length_353_cov_3.657407_g2242_i0	PRJEB56699	2470	353	3.657407	12.91064671	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	603	7.349999999999999e-168	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g2242	i0	97.45	425.515580736544	353	9	100	0	1	353	81480	81128	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	150207	603	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
12471004	12471004	PRJEB56699_P_NODE_1410_length_494_cov_7.976344_g1212_i0	PRJEB56699	1410	494	7.976344	39.40313936	Rhodoluna	529883	Bacteria	Bacteria	721	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g1212	i0	93.443	175.082995951417	488	29	98	3	9	494	477509	477995	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	86491	721	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
12471007	12471007	PRJEB56699_P_NODE_4450_length_227_cov_4.015152_g4220_i0	PRJEB56699	4450	227	4.015152	9.11439504	root	1	Root_unresolved	Root_unresolved	401	1.7399999999999995e-107	NTclustered	gi\|353256004\|gb\|JN090916.1\|	1211	g4220	i0	100	102.863436123348	217	0	96	0	1	217	368	584	Uncultured cyanobacterium clone D57C8 16S ribosomal RNA gene, partial sequence	blastn	23350	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12878207	12878207	PRJEB56699_P_NODE_3591_length_270_cov_14.178423_g3361_i0	PRJEB56699	3591	270	14.178423	38.2817421	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	483	7.409999999999998e-132	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g3361	i0	98.889	462.666666666667	270	3	100	0	1	270	80578	80847	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	124920	483	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
13745468	13745468	PRJEB56699_P_NODE_5911_length_184_cov_2.677419_g5681_i0	PRJEB56699	5911	184	2.677419	4.92645096	Streptococcus	1301	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g5681	i0	100	348.103260869565	184	0	100	0	1	184	1571258	1571441	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	64051	340	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
13745469	13745469	PRJEB56699_P_NODE_651_length_718_cov_3.769231_g191_i2	PRJEB56699	651	718	3.769231	27.06307858	Cutibacterium	1912216	Bacteria	Bacteria	1016	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g191	i2	99.288	272.649025069638	562	4	95	0	157	718	57325	56764	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	195762	1016	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15427000	15427000	PRJEB56699_P_NODE_1313_length_514_cov_4.562887_g1118_i0	PRJEB56699	1313	514	4.562887	23.45323918	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	889	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g1118	i0	97.86	289.928015564202	514	11	100	0	1	514	1858808	1859321	Calothrix sp. PCC 7716 DNA, complete genome	blastn	149023	889	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
16294702	16294702	PRJEB56699_P_NODE_1753_length_433_cov_7.967822_g1533_i0	PRJEB56699	1753	433	7.967822	34.50066926	Cutibacterium	1912216	Bacteria	Bacteria	750	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1533	i0	98.585	274.309468822171	424	6	98	0	1	424	56790	56367	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	118776	750	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18843643	18843643	PRJEB56699_P_NODE_2455_length_354_cov_6.058462_g2227_i0	PRJEB56699	2455	354	6.058462	21.44695548	Micrococcus	1269	Bacteria	Bacteria	481	3.5999999999999984e-131	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g2227	i0	90.716	241.002824858757	377	12	100	4	1	354	345476	345852	Micrococcus luteus strain V017 chromosome, complete genome	blastn	85315	481	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
18843646	18843646	PRJEB56699_P_NODE_5535_length_195_cov_2.403614_g5305_i0	PRJEB56699	5535	195	2.403614	4.6870473	Dulcicalothrix	2662189	Bacteria	Bacteria	318	1.5e-82	NTclustered	gi\|443300358\|gb\|KC216389.1\|	1211	g5305	i0	96.842	97.8615384615385	190	6	97	0	1	190	208	19	Uncultured cyanobacterium clone DBS-107 16S ribosomal RNA gene, partial sequence	blastn	19083	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19250163	19250163	PRJEB56699_P_NODE_1556_length_465_cov_4.990826_g1347_i0	PRJEB56699	1556	465	4.990826	23.2073409	Microbacterium sp. LKL04	912630	Bacteria	Bacteria	475	2.26e-129	NTclustered	gi\|1081430622\|emb\|LT627736.1\|	912630	g1347	i0	98.168	151.339784946237	273	3	89	1	1	271	560735	560463	Microbacterium sp. LKL04 genome assembly, chromosome: I	blastn	70373	475	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. LKL04
20118540	20118540	PRJEB56699_P_NODE_596_length_750_cov_5.911234_g466_i0	PRJEB56699	596	750	5.911234	44.334255	Cutibacterium	1912216	Bacteria	Bacteria	1227	0	NTclustered	gi\|966535676\|gb\|CP012351.1\|	1747	g466	i0	96.395	269.344	749	19	100	7	1	747	1522995	1523737	Cutibacterium acnes strain PA_21_1_L1 chromosome, complete genome	blastn	202008	1227	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
20118541	20118541	PRJEB56699_P_NODE_6396_length_161_cov_2.871212_g6166_i0	PRJEB56699	6396	161	2.871212	4.62265132	Corynebacterium	1716	Bacteria	Bacteria	243	7.39e-60	NTclustered	gi\|662020105\|ref\|NR_121992.1\|	38305	g6166	i0	93.827	411.627329192547	162	9	100	1	1	161	840	679	Corynebacterium vitaeruminis strain DSM 20294 23S ribosomal RNA gene, complete sequence	blastn	66272	243	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium vitaeruminis
21394098	21394098	PRJEB56699_P_NODE_1857_length_419_cov_5.197436_g1634_i0	PRJEB56699	1857	419	5.197436	21.77725684	Micrococcus	1269	Bacteria	Bacteria	440	7.369999999999997e-119	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g1634	i0	91.395	194.768496420048	337	6	75	4	1	314	345852	345516	Micrococcus luteus strain V017 chromosome, complete genome	blastn	81608	440	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
21394101	21394101	PRJEB56699_P_NODE_5737_length_190_cov_2.459627_g5507_i0	PRJEB56699	5737	190	2.459627	4.6732913	Rhodococcus	1827	Bacteria	Bacteria	346	6.690000000000001e-91	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g5507	i0	99.474	409.984210526316	190	1	100	0	1	190	559223	559412	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	77897	346	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
22668928	22668928	PRJEB56699_P_NODE_2398_length_358_cov_5.781155_g2170_i0	PRJEB56699	2398	358	5.781155	20.6965349	Micrococcus	1269	Bacteria	Bacteria	521	2.15e-143	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g2170	i0	92.388	259.810055865922	381	6	100	4	1	358	345852	345472	Micrococcus luteus strain V017 chromosome, complete genome	blastn	93012	521	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
22668933	22668933	PRJEB56699_P_NODE_6078_length_176_cov_1.897959_g5848_i0	PRJEB56699	6078	176	1.897959	3.34040784	Limosilactobacillus	2742598	Bacteria	Bacteria	71.3	4.1e-8	NTclustered	gi\|2901660165\|gb\|CP179918.1\|	1598	g5848	i0	95.455	13.4602272727273	44	2	25	0	130	173	412116	412159	Limosilactobacillus reuteri strain ZJ617 chromosome, complete genome	blastn	2369	71.3	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus reuteri
24350449	24350449	PRJEB56699_P_NODE_2800_length_325_cov_6.395270_g2570_i0	PRJEB56699	2800	325	6.39527	20.7846275	Candidatus Planktophila limnetica	573600	Bacteria	Bacteria	381	3.429999999999999e-101	NTclustered	gi\|1240564617\|gb\|CP016782.1\|	573600	g2570	i0	94.378	180.963076923077	249	13	76	1	78	325	683014	683262	Candidatus Planktophila limnetica, complete genome	blastn	58813	381	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales	Candidatus Nanopelagicaceae	Candidatus Planktophila	Candidatus Planktophila limnetica
25218116	25218116	PRJEB56699_P_NODE_6580_length_154_cov_5.096000_g6350_i0	PRJEB56699	6580	154	5.096	7.84784	Microbacterium	33882	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|1004607083\|gb\|KT865791.1\|	1811287	g6350	i0	100	173.006493506494	154	0	100	0	1	154	2419	2266	Microbacterium sp. ALBL_044 23S ribosomal RNA gene, partial sequence	blastn	26643	285	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. ALBL_044

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