metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA242641" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA242641" 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
1056716	1056716	PRJNA242641_S_NODE_1701_length_177_cov_4.871622_g1673_i0	PRJNA242641	1701	177	4.871622	8.62277094	Corynebacterium	1716	Bacteria	Bacteria	311	2.23e-80	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g1673	i0	99.415	361.717514124294	171	1	100	0	1	171	623415	623585	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	64024	311	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
2918042	2918042	PRJNA242641_S_NODE_703_length_275_cov_5.378049_g675_i0	PRJNA242641	703	275	5.378049	14.78963475	Aliterella chasmolithica	2739056	Bacteria	Bacteria	370	6.14e-98	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g675	i0	90.975	160.101818181818	277	21	100	4	1	275	2202	2476	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44028	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
3607155	3607155	PRJNA242641_S_NODE_663_length_284_cov_5.145098_g635_i0	PRJNA242641	663	284	5.145098	14.61207832	Rummeliibacillus	648802	Bacteria	Bacteria	486	6.069999999999999e-133	NTclustered	gi\|2563036164\|gb\|CP132291.1\|	101070	g635	i0	97.535	1027.31338028169	284	7	100	0	1	284	3141764	3142047	Rummeliibacillus pycnus strain X33 chromosome, complete genome	blastn	291757	486	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Rummeliibacillus	Rummeliibacillus pycnus
4194531	4194531	PRJNA242641_S_NODE_384_length_374_cov_6.973913_g356_i0	PRJNA242641	384	374	6.973913	26.08243462	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	643	4.6199999999999985e-180	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g356	i0	98.108	117.33422459893	370	6	99	1	1	369	513	144	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43883	643	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4884646	4884646	PRJNA242641_S_NODE_1384_length_197_cov_11.875000_g1356_i0	PRJNA242641	1384	197	11.875	23.39375	Cutibacterium	1912216	Bacteria	Bacteria	357	3.23e-94	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1356	i0	99.49	210.893401015228	196	1	99	0	2	197	55152	54957	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	41546	357	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4884650	4884650	PRJNA242641_S_NODE_44_length_911_cov_13.003401_g38_i0	PRJNA242641	44	911	13.003401	118.46098311	Cutibacterium	1912216	Bacteria	Bacteria	1677	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g38	i0	99.89	283.479692645445	911	1	100	0	1	911	55360	56270	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	258250	1677	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6745104	6745104	PRJNA242641_S_NODE_2446_length_150_cov_8.553719_g2418_i0	PRJNA242641	2446	150	8.553719	12.8305785	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	226	6.8e-55	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g2418	i0	94.04	108.74	151	5	100	3	1	150	1234	1087	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	16311	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
6745107	6745107	PRJNA242641_S_NODE_766_length_263_cov_3.034188_g738_i0	PRJNA242641	766	263	3.034188	7.97991444	Rummeliibacillus pycnus	101070	Bacteria	Bacteria	388	1.61e-103	NTclustered	gi\|2563036164\|gb\|CP132291.1\|	101070	g738	i0	94.444	957.498098859316	252	14	97	0	1	252	1653587	1653838	Rummeliibacillus pycnus strain X33 chromosome, complete genome	blastn	251822	388	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Rummeliibacillus	Rummeliibacillus pycnus
8020840	8020840	PRJNA242641_S_NODE_307_length_416_cov_3.731266_g279_i0	PRJNA242641	307	416	3.731266	15.52206656	Rummeliibacillus pycnus	101070	Bacteria	Bacteria	725	0	NTclustered	gi\|2563036164\|gb\|CP132291.1\|	101070	g279	i0	98.077	1062.70913461538	416	8	100	0	1	416	1654002	1653587	Rummeliibacillus pycnus strain X33 chromosome, complete genome	blastn	442087	725	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Rummeliibacillus	Rummeliibacillus pycnus
8709361	8709361	PRJNA242641_S_NODE_867_length_246_cov_11.852535_g839_i0	PRJNA242641	867	246	11.852535	29.1572361	Cutibacterium	1912216	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g839	i0	100	264.239837398374	246	0	100	0	1	246	56541	56296	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	65003	455	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9984757	9984757	PRJNA242641_S_NODE_1388_length_197_cov_4.946429_g1360_i0	PRJNA242641	1388	197	4.946429	9.74446513	Bacillales	1385	Bacteria	Bacteria	303	4.27e-78	NTclustered	gi\|2313057121\|gb\|CP094729.1\|	1282	g1360	i0	95.789	539.472081218274	190	4	96	4	1	189	778417	778231	Staphylococcus epidermidis strain IVB6210 chromosome, complete genome	blastn	106276	303	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
9984758	9984758	PRJNA242641_S_NODE_1988_length_165_cov_6.852941_g1960_i0	PRJNA242641	1988	165	6.852941	11.30735265	Bacillati	1783272	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1960	i0	98.788	501.666666666667	165	2	100	0	1	165	748936	748772	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	82775	294	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11259874	11259874	PRJNA242641_S_NODE_1629_length_181_cov_6.940789_g1601_i0	PRJNA242641	1629	181	6.940789	12.56282809	Staphylococcus	1279	Bacteria	Bacteria	329	6.340000000000001e-86	NTclustered	gi\|2318610287\|gb\|OP663211.1\|	1280	g1601	i0	99.448	100	181	1	100	0	1	181	527	707	Staphylococcus aureus strain HA MRSA_3 16S ribosomal RNA gene, partial sequence	blastn	18100	329	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
12535258	12535258	PRJNA242641_S_NODE_2330_length_153_cov_7.185484_g2302_i0	PRJNA242641	2330	153	7.185484	10.99379052	Staphylococcus	1279	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|2588959008\|gb\|OR636873.1\|	1280	g2302	i0	100	235.790849673203	153	0	100	0	1	153	1214	1366	Staphylococcus aureus strain SRV05 16S ribosomal RNA gene, partial sequence	blastn	36076	283	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13810088	13810088	PRJNA242641_S_NODE_2431_length_151_cov_2.106557_g2403_i0	PRJNA242641	2431	151	2.106557	3.18090107	Micrococcus	1269	Bacteria	Bacteria	274	2.42e-69	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g2403	i0	99.338	72.0993377483444	151	1	100	0	1	151	2260610	2260760	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	10887	274	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
14396481	14396481	PRJNA242641_S_NODE_772_length_262_cov_6.330472_g744_i0	PRJNA242641	772	262	6.330472	16.58583664	Staphylococcus epidermidis	1282	Bacteria	Bacteria	435	2.0300000000000003e-117	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g744	i0	96.565	116.965648854962	262	9	100	0	1	262	874	613	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	30645	435	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
15084235	15084235	PRJNA242641_S_NODE_1552_length_185_cov_5.064103_g1524_i0	PRJNA242641	1552	185	5.064103	9.36859055	Bacillati	1783272	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1524	i0	100	499.108108108108	185	0	100	0	1	185	749092	748908	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	92335	342	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
15084237	15084237	PRJNA242641_S_NODE_392_length_370_cov_22.636364_g364_i0	PRJNA242641	392	370	22.636364	83.7545468	Cutibacterium	1912216	Bacteria	Bacteria	673	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g364	i0	99.459	192.383783783784	370	2	100	0	1	370	53961	53592	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	71182	673	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16359095	16359095	PRJNA242641_S_NODE_2093_length_161_cov_3.272727_g2065_i0	PRJNA242641	2093	161	3.272727	5.26909047	Micrococcus	1269	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g2065	i0	100	295.478260869565	161	0	100	0	1	161	345561	345721	Micrococcus luteus strain V017 chromosome, complete genome	blastn	47572	298	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
18908120	18908120	PRJNA242641_S_NODE_835_length_251_cov_8.324324_g807_i0	PRJNA242641	835	251	8.324324	20.89405324	Micrococcus	1269	Bacteria	Bacteria	407	4.2099999999999995e-109	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g807	i0	100	295.107569721116	220	0	88	0	32	251	346157	346376	Micrococcus luteus strain V017 chromosome, complete genome	blastn	74072	407	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
22733457	22733457	PRJNA242641_S_NODE_2358_length_152_cov_9.959350_g2330_i0	PRJNA242641	2358	152	9.95935	15.138212	Bacillales	1385	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g2330	i0	100	101.013157894737	152	0	100	0	1	152	517	366	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	15354	281	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
22733458	22733458	PRJNA242641_S_NODE_638_length_288_cov_9.505792_g610_i0	PRJNA242641	638	288	9.505792	27.37668096	Corynebacterium	1716	Bacteria	Bacteria	521	1.69e-143	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g610	i0	99.306	365.041666666667	288	2	100	0	1	288	760220	759933	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	105132	521	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
24008628	24008628	PRJNA242641_S_NODE_459_length_344_cov_4.123810_g431_i0	PRJNA242641	459	344	4.12381	14.1859064	Corynebacterium	1716	Bacteria	Bacteria	636	7.059999999999998e-178	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g431	i0	100	341.723837209302	344	0	100	0	1	344	621728	622071	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	117553	636	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
25282763	25282763	PRJNA242641_S_NODE_220_length_498_cov_10.671642_g38_i1	PRJNA242641	220	498	10.671642	53.14477716	Cutibacterium	1912216	Bacteria	Bacteria	761	0	NTclustered	gi\|966537955\|gb\|CP012352.1\|	1747	g38	i1	95.588	244.367469879518	476	20	95	1	1	475	1775154	1775629	Cutibacterium acnes strain PA_15_2_L1 chromosome, complete genome	blastn	121695	761	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25282765	25282765	PRJNA242641_S_NODE_2360_length_152_cov_8.373984_g2332_i0	PRJNA242641	2360	152	8.373984	12.72845568	Corynebacterium	1716	Bacteria	Bacteria	268	1.13e-67	NTclustered	gi\|2550471320\|gb\|CP100376.1\|	38284	g2332	i0	99.324	356.315789473684	148	1	97	0	1	148	2342309	2342456	Corynebacterium accolens strain CA7 chromosome	blastn	54160	268	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
25282767	25282767	PRJNA242641_S_NODE_280_length_436_cov_6.604423_g252_i0	PRJNA242641	280	436	6.604423	28.79528428	Staphylococcus	1279	Bacteria	Bacteria	800	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g252	i0	99.771	501.05504587156	436	1	100	0	1	436	2278364	2277929	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	218460	800	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25282770	25282770	PRJNA242641_S_NODE_860_length_248_cov_3.063927_g832_i0	PRJNA242641	860	248	3.063927	7.59853896	Chroococcidiopsidales	1890505	Bacteria	Bacteria	364	2.539999999999999e-96	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g832	i0	93.145	131.157258064516	248	17	100	0	1	248	1868	1621	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32527	366	0.994535519125683	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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