metadata: contig_metadata: 27 rows where bioproject = "PRJEB2333" and tax

27 rows where bioproject = "PRJEB2333" 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
22864	22864	PRJEB2333_P_NODE_3301_length_404_cov_2.754768_g2525_i0	PRJEB2333	3301	404	2.754768	11.12926272	Sanguibacter biliveldensis	3030830	Bacteria	Bacteria	525	1.8999999999999994e-144	NTclustered	gi\|2621750761\|gb\|CP138359.1\|	3030830	g2525	i0	91.601	306.44801980198	381	31	98	1	24	404	794920	794541	Sanguibacter biliveldensis strain 4.1 chromosome, complete genome	blastn	123805	525	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Sanguibacteraceae	Sanguibacter	Sanguibacter biliveldensis
2261424	2261424	PRJEB2333_P_NODE_2442_length_623_cov_2.129693_g1678_i1	PRJEB2333	2442	623	2.129693	13.26798739	Micrococcus	1269	Bacteria	Bacteria	606	1.0499999999999997e-168	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g1678	i1	96.237	143.337078651685	372	11	80	2	1	369	2260414	2260785	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	89299	606	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
4813964	4813964	PRJEB2333_P_NODE_2904_length_460_cov_2.900709_g2132_i0	PRJEB2333	2904	460	2.900709	13.3432614	Bacillati	1783272	Bacteria	Bacteria	337	1.1e-87	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g2132	i0	100	366.980434782609	182	0	73	0	279	460	748736	748917	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	168811	337	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6089282	6089282	PRJEB2333_P_NODE_4665_length_156_cov_3.016807_g3888_i0	PRJEB2333	4665	156	3.016807	4.70621892	Actinomyces	1654	Bacteria	Bacteria	226	7.149999999999997e-55	NTclustered	gi\|1948661326\|gb\|CP066049.1\|	1655	g3888	i0	93.96	225.525641025641	149	9	96	0	3	151	295683	295831	Actinomyces naeslundii strain FDAARGOS_1037 chromosome, complete genome	blastn	35182	228	0.991228070175439	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
7363893	7363893	PRJEB2333_P_NODE_4606_length_158_cov_2.198347_g3829_i0	PRJEB2333	4606	158	2.198347	3.47338826	root	1	Root_unresolved	Root_unresolved	292	7.07e-75	NTclustered	gi\|1226527082\|gb\|MF578812.1\|	1655	g3829	i0	100	100	158	0	100	0	1	158	325	482	Actinomyces naeslundii strain K55 16S ribosomal RNA gene, partial sequence	blastn	15800	292	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
8639258	8639258	PRJEB2333_P_NODE_3347_length_399_cov_1.848066_g2571_i0	PRJEB2333	3347	399	1.848066	7.37378334	Micrococcaceae	1268	Bacteria	Bacteria	248	4.54e-61	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g2571	i0	96.078	196.428571428571	153	4	70	1	1	153	562058	562208	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	78375	248	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
8639262	8639262	PRJEB2333_P_NODE_3687_length_219_cov_11.181319_g2910_i0	PRJEB2333	3687	219	11.181319	24.48708861	Streptococcus	1301	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g2910	i0	100	106	219	0	100	0	1	219	1573074	1572856	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	23214	405	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
8639264	8639264	PRJEB2333_P_NODE_3847_length_199_cov_3.228395_g3070_i0	PRJEB2333	3847	199	3.228395	6.42450605	Planococcus	1372	Bacteria	Bacteria	340	3.2899999999999996e-89	NTclustered	gi\|1799096099\|gb\|CP047673.1\|	2233542	g3070	i0	97.487	534	199	5	100	0	1	199	139701	139503	Planococcus halotolerans strain Y50 chromosome, complete genome	blastn	106266	340	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus halotolerans
11189486	11189486	PRJEB2333_P_NODE_2769_length_489_cov_1.584071_g1998_i0	PRJEB2333	2769	489	1.584071	7.74610719	Corynebacterium	1716	Bacteria	Bacteria	318	4.259999999999999e-82	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g1998	i0	100	250.298568507157	172	0	68	0	318	489	2720	2891	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	122396	318	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
12776456	12776456	PRJEB2333_P_NODE_4331_length_168_cov_1.137405_g3554_i0	PRJEB2333	4331	168	1.137405	1.9108404	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g3554	i0	100	0.166666666666667	28	0	17	0	98	125	1687046	1687073	Synechococcus sp. CB0101 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
13739606	13739606	PRJEB2333_P_NODE_3451_length_340_cov_6.217822_g2674_i0	PRJEB2333	3451	340	6.217822	21.1405948	Streptococcus	1301	Bacteria	Bacteria	623	5.429999999999999e-174	NTclustered	gi\|2182940279\|gb\|OM368578.1\|	1313	g2674	i0	99.706	147.202941176471	340	1	100	0	1	340	349	10	Streptococcus pneumoniae strain FC6532 16S ribosomal RNA gene, partial sequence	blastn	50049	628	0.99203821656051006	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
15014024	15014024	PRJEB2333_P_NODE_3392_length_393_cov_1.522472_g2616_i0	PRJEB2333	3392	393	1.522472	5.98331496	root	1	Root_unresolved	Root_unresolved	169	3.5799999999999997e-37	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g2616	i0	100	40.3740458015267	91	0	43	0	1	91	2188	2098	Uncultured cyanobacterium clone AN2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	15867	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16288860	16288860	PRJEB2333_P_NODE_3633_length_228_cov_2.251309_g2856_i0	PRJEB2333	3633	228	2.251309	5.13298452	Nocardioides	1839	Bacteria	Bacteria	392	1.0499999999999997e-104	NTclustered	gi\|1321370352\|gb\|CP025581.1\|	2045452	g2856	i0	97.807	255.486842105263	228	4	100	1	1	228	999333	999107	Nocardioides houyundeii strain 78 chromosome, complete genome	blastn	58251	392	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides houyundeii
17564017	17564017	PRJEB2333_P_NODE_2834_length_473_cov_4.784404_g2062_i0	PRJEB2333	2834	473	4.784404	22.63023092	Streptococcus	1301	Bacteria	Bacteria	863	0	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g2062	i0	99.577	345.07822410148	473	2	100	0	1	473	1571585	1571113	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	163222	863	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
17564022	17564022	PRJEB2333_P_NODE_3334_length_400_cov_2.476584_g2558_i0	PRJEB2333	3334	400	2.476584	9.906336	Micrococcus	1269	Bacteria	Bacteria	233	1.2799999999999998e-56	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g2558	i0	98.485	133.8675	132	2	33	0	2	133	345471	345602	Micrococcus luteus strain V017 chromosome, complete genome	blastn	53547	233	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
17564031	17564031	PRJEB2333_P_NODE_4094_length_180_cov_5.706294_g3317_i0	PRJEB2333	4094	180	5.706294	10.2713292	Rothia	32207	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g3317	i0	100	313.716666666667	180	0	100	0	1	180	651955	651776	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	56469	333	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
18837958	18837958	PRJEB2333_P_NODE_3695_length_218_cov_5.552486_g2918_i0	PRJEB2333	3695	218	5.552486	12.10441948	Bacillales	1385	Bacteria	Bacteria	403	4.62e-108	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g2918	i0	100	110.009174311927	218	0	100	0	1	218	298	515	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	23982	403	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20112669	20112669	PRJEB2333_P_NODE_2336_length_687_cov_4.549231_g1581_i0	PRJEB2333	2336	687	4.549231	31.25321697	Streptococcus	1301	Bacteria	Bacteria	1232	0	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g1581	i0	98.984	366.193595342067	689	5	100	2	1	687	1570541	1569853	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	251575	1238	0.995153473344103	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
20112697	20112697	PRJEB2333_P_NODE_3856_length_198_cov_6.608696_g3079_i0	PRJEB2333	3856	198	6.608696	13.08521808	Micrococcaceae	1268	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g3079	i0	100	408.752525252525	198	0	100	0	1	198	100856	100659	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	80933	366	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
20112705	20112705	PRJEB2333_P_NODE_4096_length_180_cov_2.916084_g3319_i0	PRJEB2333	4096	180	2.916084	5.2489512	Staphylococcus	1279	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|1487186653\|gb\|MF678869.1\|	29380	g3319	i0	100	470.022222222222	180	0	100	0	1	180	2395	2574	Staphylococcus caprae strain DSM 20608 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	84604	333	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus caprae
21699594	21699594	PRJEB2333_P_NODE_4178_length_175_cov_2.420290_g3401_i0	PRJEB2333	4178	175	2.42029	4.2355075	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	274	2.89e-69	NTclustered	gi\|2694275225\|gb\|CP140010.1\|	1528099	g3401	i0	94.857	255.634285714286	175	9	100	0	1	175	1854078	1854252	MAG: Lawsonella clevelandensis isolate TECA_312545_bc_10 chromosome	blastn	44736	274	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
23938479	23938479	PRJEB2333_P_NODE_2339_length_686_cov_3.027735_g1583_i0	PRJEB2333	2339	686	3.027735	20.7702621	Rothia	32207	Bacteria	Bacteria	619	1.4999999999999996e-172	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g1583	i0	94.541	309.316326530612	403	18	92	4	287	686	1004404	1004003	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	212191	619	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
23938526	23938526	PRJEB2333_P_NODE_4819_length_152_cov_1.626087_g4042_i0	PRJEB2333	4819	152	1.626087	2.47165224	Geobacillus	129337	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|1205983\|gb\|U33536.1\|BSU33536	1422	g4042	i0	100	10	152	0	100	0	1	152	1508	1659	Bacillus stearothermophilus DNA polymerase I (polA) gene, complete cds	blastn	1520	281	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
25212230	25212230	PRJEB2333_P_NODE_2440_length_623_cov_2.378840_g1678_i0	PRJEB2333	2440	623	2.37884	14.8201732	Micrococcus	1269	Bacteria	Bacteria	597	6.329999999999999e-166	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g1678	i0	96.185	143.199036918138	367	11	79	2	260	623	2260780	2260414	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	89213	597	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
25212236	25212236	PRJEB2333_P_NODE_2680_length_513_cov_1.861345_g1910_i0	PRJEB2333	2680	513	1.861345	9.54869985	Mycobacteriales	85007	Bacteria	Bacteria	390	9.37e-104	NTclustered	gi\|2663843834\|gb\|CP143053.1\|	321318	g1910	i0	95.528	137.884990253411	246	8	47	2	271	513	853464	853709	Dietzia cinnamea strain 55 chromosome	blastn	70735	390	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia cinnamea
25212248	25212248	PRJEB2333_P_NODE_3300_length_404_cov_3.160763_g2524_i0	PRJEB2333	3300	404	3.160763	12.76948252	Rothia	32207	Bacteria	Bacteria	640	6.5e-179	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g2524	i0	95.297	278.299504950495	404	17	99	2	1	403	651955	651553	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	112433	645	0.992248062015504	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
25212253	25212253	PRJEB2333_P_NODE_3580_length_240_cov_2.871921_g2803_i0	PRJEB2333	3580	240	2.871921	6.8926104	Micrococcus	1269	Bacteria	Bacteria	394	3.11e-105	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g2803	i0	96.25	260.1125	240	9	100	0	1	240	346591	346352	Micrococcus luteus strain V017 chromosome, complete genome	blastn	62427	394	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus

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