metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax_phylum = "Bacillota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2386473	2386473	PRJNA515078_P_NODE_2962_length_565_cov_4.462121_g2740_i0	PRJNA515078	2962	565	4.462121	25.21098365	Staphylococcus	1279	Bacteria	Bacteria	983	0	NTclustered	gi\|2710589954\|gb\|CP121240.2\|	1280	g2740	i0	98.053	527.033628318584	565	11	100	0	1	565	1852754	1852190	Staphylococcus aureus strain OD028 chromosome, complete genome	blastn	297774	983	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
3037873	3037873	PRJNA515078_P_NODE_19883_length_195_cov_0.987342_g19650_i0	PRJNA515078	19883	195	0.987342	1.9253169	Clostridium sp. MB05	3376682	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2882621205\|gb\|CP174370.1\|	3376682	g19650	i0	100	0.143589743589744	28	0	14	0	14	41	3203307	3203280	Clostridium sp. MB05 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. MB05
3662249	3662249	PRJNA515078_P_NODE_34583_length_150_cov_1.265487_g34350_i0	PRJNA515078	34583	150	1.265487	1.8982305	Bacillales	1385	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|1481136082\|gb\|CP032410.1\|	1465	g34350	i0	100	0.373333333333333	28	0	19	0	5	32	1746842	1746815	Brevibacillus laterosporus strain E7593-50 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus laterosporus
3662252	3662252	PRJNA515078_P_NODE_3743_length_500_cov_3.280778_g3511_i0	PRJNA515078	3743	500	3.280778	16.40389	Staphylococcus	1279	Bacteria	Bacteria	924	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g3511	i0	100	546.254	500	0	100	0	1	500	748429	748928	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	273127	924	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6864556	6864556	PRJNA515078_P_NODE_17246_length_210_cov_1.514451_g17013_i0	PRJNA515078	17246	210	1.514451	3.1803471	Paenibacillus sp. FSL H7-0737	1536775	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2709392188\|gb\|CP150149.1\|	1536775	g17013	i0	100	0.266666666666667	28	0	13	0	9	36	942483	942510	Paenibacillus sp. FSL H7-0737 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL H7-0737
9414942	9414942	PRJNA515078_P_NODE_19468_length_197_cov_0.975000_g19235_i0	PRJNA515078	19468	197	0.975	1.92075	Anaerovoracaceae bacterium	3030912	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2814788368\|emb\|OY764195.2\|	3030912	g19235	i0	100	0.142131979695431	28	0	14	0	77	104	2362707	2362734	MAG: Anaerovoracaceae bacterium isolate cdaadf04-e2f3-4fd8-80f9-b39a06479d73 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Anaerovoracaceae bacterium
10690557	10690557	PRJNA515078_P_NODE_15269_length_224_cov_1.893048_g15036_i0	PRJNA515078	15269	224	1.893048	4.24042752	Pseudolactococcus carnosus	2749961	Bacteria	Bacteria	63.9	9.19e-6	NTclustered	gi\|1699918189\|gb\|CP017194.1\|	2749961	g15036	i0	93.023	0.191964285714286	43	3	19	0	29	71	1310459	1310417	Lactococcus carnosus strain TMW 2.1612 chromosome, complete genome	blastn	43	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Pseudolactococcus	Pseudolactococcus carnosus
10690591	10690591	PRJNA515078_P_NODE_20069_length_194_cov_1.133758_g19836_i0	PRJNA515078	20069	194	1.133758	2.19949052	Paenibacillus tritici	1873425	Bacteria	Bacteria	58.4	3.6e-4	NTclustered	gi\|2030667083\|gb\|CP073365.1\|	1873425	g19836	i0	97.143	0.180412371134021	35	0	18	1	81	115	1849816	1849849	Paenibacillus tritici strain PH55-1 chromosome, complete genome	blastn	35	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus tritici
11314106	11314106	PRJNA515078_P_NODE_17289_length_210_cov_1.184971_g17056_i0	PRJNA515078	17289	210	1.184971	2.4884391	root	1	Root_unresolved	Root_unresolved	372	1.25e-98	NTclustered	gi\|719642273\|gb\|CP009746.1\|	1405	g17056	i0	100	96.4523809523809	201	0	96	0	6	206	5592037	5591837	Bacillus weihenstephanensis strain WSBC 10204, complete genome	blastn	20255	374	0.994652406417112	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
11314145	11314145	PRJNA515078_P_NODE_31829_length_155_cov_2.610169_g31596_i0	PRJNA515078	31829	155	2.610169	4.04576195	root	1	Root_unresolved	Root_unresolved	287	3.21e-73	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g31596	i0	100	97.8903225806452	155	0	100	0	1	155	2463327	2463481	Staphylococcus aureus strain WH9628 chromosome	blastn	15173	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
11314156	11314156	PRJNA515078_P_NODE_34489_length_150_cov_1.380531_g34256_i0	PRJNA515078	34489	150	1.380531	2.0707965	Lactococcus	1357	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|1995453616\|gb\|CP070872.1\|	1151742	g34256	i0	100	0.56	28	0	19	0	83	110	1009749	1009776	Lactococcus taiwanensis strain K_LL004 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus taiwanensis
12589928	12589928	PRJNA515078_P_NODE_3450_length_521_cov_17.654959_g3220_i0	PRJNA515078	3450	521	17.654959	91.98233639	root	1	Root_unresolved	Root_unresolved	957	0	NTclustered	gi\|511633707\|gb\|KF011975.1\|	1282	g3220	i0	99.808	299.744721689059	521	1	100	0	1	521	19	539	Staphylococcus epidermidis strain O1 16S ribosomal RNA gene, partial sequence	blastn	156167	959	0.997914494264859	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13864726	13864726	PRJNA515078_P_NODE_22431_length_183_cov_1.582192_g22198_i0	PRJNA515078	22431	183	1.582192	2.89541136	Psychrobacillus	1221880	Bacteria	Bacteria	82.4	1.99e-11	NTclustered	gi\|1755647179\|gb\|CP031739.1\|	2303505	g22198	i0	91.525	29.3715846994536	59	5	32	0	116	174	1823316	1823374	Psychrobacillus sp. AK 1817 chromosome, complete genome	blastn	5375	82.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Psychrobacillus	Psychrobacillus sp. AK 1817
17688814	17688814	PRJNA515078_P_NODE_24234_length_176_cov_1.683453_g24001_i0	PRJNA515078	24234	176	1.683453	2.96287728	Bacillota	1239	Bacteria	Bacteria	110	8.69e-20	NTclustered	gi\|2550031476\|gb\|OQ263304.1\|	33968	g24001	i0	79.503	92.3977272727273	161	27	90	5	19	176	362318	362475	Leuconostoc pseudomesenteroides strain NFICC227 PrtP (prtP) gene, complete cds	blastn	16262	110	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc pseudomesenteroides
23439345	23439345	PRJNA515078_P_NODE_33939_length_151_cov_1.368421_g33706_i0	PRJNA515078	33939	151	1.368421	2.06631571	Paenibacillus baekrokdamisoli	1712516	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|1514759603\|dbj\|AP019308.1\|	1712516	g33706	i0	100	0.185430463576159	28	0	19	0	112	139	6198503	6198476	Paenibacillus baekrokdamisoli KCTC 33723 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus baekrokdamisoli
25337330	25337330	PRJNA515078_P_NODE_17960_length_205_cov_1.976190_g17727_i0	PRJNA515078	17960	205	1.97619	4.0511895000000004	Streptococcus	1301	Bacteria	Bacteria	357	3.3899999999999996e-94	NTclustered	gi\|2563200286\|dbj\|AP028603.1\|	1313	g17727	i0	98.049	347.009756097561	205	4	100	0	1	205	18443	18647	Streptococcus pneumoniae Pne2 DNA, complete genome	blastn	71137	357	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
25337372	25337372	PRJNA515078_P_NODE_31820_length_155_cov_2.694915_g31587_i0	PRJNA515078	31820	155	2.694915	4.17711825	Streptococcus	1301	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g31587	i0	100	563.135483870968	155	0	100	0	1	155	18120	17966	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	87286	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius

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