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

18 rows where analysis = "blastn", bioproject = "PRJNA397065" 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
2354663	2354663	PRJNA397065_S_NODE_11782_length_227_cov_3.914141_g11532_i0	PRJNA397065	11782	227	3.914141	8.88510007	Staphylococcus	1279	Bacteria	Bacteria	394	2.92e-105	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g11532	i0	98.649	463.920704845815	222	3	98	0	6	227	750477	750698	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	105310	394	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2962755	2962755	PRJNA397065_S_NODE_15703_length_181_cov_1.750000_g15453_i0	PRJNA397065	15703	181	1.75	3.1675	Bacillus mycoides	1405	Bacteria	Bacteria	119	1.49e-22	NTclustered	gi\|2049702949\|gb\|CP036078.1\|	1405	g15453	i0	83.465	0.701657458563536	127	21	70	0	55	181	10880	10754	Bacillus mycoides strain JAS1004 plasmid p12	blastn	127	119	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
5515682	5515682	PRJNA397065_S_NODE_14125_length_196_cov_4.838323_g13875_i0	PRJNA397065	14125	196	4.838323	9.48311308	Bacillus altitudinis	293387	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2595843104\|gb\|CP136643.1\|	293387	g13875	i0	100	0.142857142857143	28	0	14	0	43	70	651564	651537	Bacillus altitudinis strain RS1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus altitudinis
5515704	5515704	PRJNA397065_S_NODE_16665_length_173_cov_1.243056_g16415_i0	PRJNA397065	16665	173	1.243056	2.15048688	Anaerococcus nagyae	1755241	Bacteria	Bacteria	285	1.32e-72	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g16415	i0	99.363	141.063583815029	157	1	91	0	1	157	122115	121959	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	24404	285	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
5515705	5515705	PRJNA397065_S_NODE_16765_length_172_cov_1.972028_g16515_i0	PRJNA397065	16765	172	1.972028	3.39188816	Bacillus pseudomycoides	64104	Bacteria	Bacteria	285	1.31e-72	NTclustered	gi\|673968774\|gb\|CP007621.1\|	64104	g16515	i0	96.512	15.8895348837209	172	6	100	0	1	172	3328	3499	Bacillus pseudomycoides strain 219298 plasmid, complete sequence	blastn	2733	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus pseudomycoides
10615924	10615924	PRJNA397065_S_NODE_18709_length_158_cov_1.054264_g18459_i0	PRJNA397065	18709	158	1.054264	1.66573712	Peptoniphilus harei	54005	Bacteria	Bacteria	265	1.5399999999999998e-66	NTclustered	gi\|1958280563\|gb\|CP068103.1\|	54005	g18459	i0	96.835	241.240506329114	158	5	100	0	1	158	765576	765733	Peptoniphilus harei strain FDAARGOS_1136 chromosome, complete genome	blastn	38116	265	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
11282681	11282681	PRJNA397065_S_NODE_17189_length_168_cov_4.733813_g16939_i0	PRJNA397065	17189	168	4.733813	7.95280584	root	1	Root_unresolved	Root_unresolved	311	2.11e-80	NTclustered	gi\|719642273\|gb\|CP009746.1\|	1405	g16939	i0	100	9.16666666666667	168	0	100	0	1	168	5602891	5602724	Bacillus weihenstephanensis strain WSBC 10204, complete genome	blastn	1540	311	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
12558060	12558060	PRJNA397065_S_NODE_14490_length_192_cov_104.509202_g14240_i0	PRJNA397065	14490	192	104.509202	200.65766784	Bacillales	1385	Bacteria	Bacteria	339	1.13e-88	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g14240	i0	98.942	472.291666666667	189	2	98	0	1	189	771830	771642	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	90680	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
13165784	13165784	PRJNA397065_S_NODE_19271_length_154_cov_1.832000_g19021_i0	PRJNA397065	19271	154	1.832	2.82128	Paenibacillus sp. N3/727	2925845	Bacteria	Bacteria	183	4.3e-42	NTclustered	gi\|2210008735\|gb\|CP093336.1\|	2925845	g19021	i0	91.111	6.77272727272727	135	12	88	0	20	154	3770162	3770296	Paenibacillus sp. N3/727 chromosome, complete genome	blastn	1043	183	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. N3/727
13165785	13165785	PRJNA397065_S_NODE_19311_length_154_cov_1.464000_g19061_i0	PRJNA397065	19311	154	1.464	2.25456	Paenibacillus chitinolyticus	79263	Bacteria	Bacteria	235	1.17e-57	NTclustered	gi\|2853811915\|gb\|CP173427.1\|	79263	g19061	i0	94.156	931.097402597403	154	9	100	0	1	154	273381	273228	Paenibacillus chitinolyticus strain KFRI-Sea08-06 chromosome, complete genome	blastn	143389	235	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus chitinolyticus
13833095	13833095	PRJNA397065_S_NODE_2891_length_668_cov_8.250391_g2674_i0	PRJNA397065	2891	668	8.250391	55.11261188	Streptococcus	1301	Bacteria	Bacteria	1160	0	NTclustered	gi\|1943213388\|gb\|CP065706.1\|	1303	g2674	i0	98.057	328.094311377246	669	9	99	3	1	666	198074	198741	Streptococcus oralis strain FDAARGOS_886 chromosome, complete genome	blastn	219167	1160	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
16989578	16989578	PRJNA397065_S_NODE_7934_length_311_cov_4.773050_g7684_i0	PRJNA397065	7934	311	4.77305	14.8441855	Staphylococcus epidermidis	1282	Bacteria	Bacteria	553	6.539999999999998e-153	NTclustered	gi\|2811867800\|gb\|CP170247.1\|	1282	g7684	i0	98.714	539.729903536978	311	4	100	0	1	311	751293	750983	Staphylococcus epidermidis strain Q10 chromosome, complete genome	blastn	167856	553	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20813644	20813644	PRJNA397065_S_NODE_19857_length_150_cov_3.289256_g19607_i0	PRJNA397065	19857	150	3.289256	4.933884	uncultured Streptococcus sp.	83427	Bacteria	Bacteria	272	8.609999999999998e-69	NTclustered	gi\|1139275923\|emb\|LT689803.1\|	83427	g19607	i0	99.333	106.806666666667	150	1	100	0	1	150	180	31	Uncultured Streptococcus sp. partial 16S rRNA gene, isolate 459N_15219	blastn	16021	272	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	uncultured Streptococcus sp.
22756611	22756611	PRJNA397065_S_NODE_3958_length_533_cov_7.642857_g3719_i0	PRJNA397065	3958	533	7.642857	40.73642781	Staphylococcus	1279	Bacteria	Bacteria	935	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g3719	i0	98.311	536.076923076923	533	9	100	0	1	533	2277708	2278240	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	285729	935	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
24030940	24030940	PRJNA397065_S_NODE_10559_length_247_cov_10198.321101_g10309_i0	PRJNA397065	10559	247	10198.321101	25189.85311947	Alkaliphilus	114627	Bacteria	Bacteria	274	4.38e-69	NTclustered	gi\|158139258\|gb\|CP000853.1\|	350688	g10309	i0	93.478	646.303643724696	184	12	74	0	64	247	14538	14355	Alkaliphilus oremlandii OhILAs, complete genome	blastn	159637	276	0.992753623188406	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Natronincolaceae	Alkaliphilus	Alkaliphilus oremlandii
24031576	24031576	PRJNA397065_S_NODE_7999_length_309_cov_5.360714_g7749_i0	PRJNA397065	7999	309	5.360714	16.56460626	Streptococcus	1301	Bacteria	Bacteria	527	3.9299999999999985e-145	NTclustered	gi\|1686100227\|gb\|MK330575.1\|	28037	g7749	i0	97.419	326.171521035599	310	6	100	2	1	309	4033	3725	Streptococcus mitis strain PL429 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	100787	527	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
25305449	25305449	PRJNA397065_S_NODE_12520_length_217_cov_1.994681_g12270_i0	PRJNA397065	12520	217	1.994681	4.32845777	root	1	Root_unresolved	Root_unresolved	398	2.14e-106	NTclustered	gi\|719642273\|gb\|CP009746.1\|	1405	g12270	i0	100	10.2027649769585	215	0	99	0	1	215	5602565	5602351	Bacillus weihenstephanensis strain WSBC 10204, complete genome	blastn	2214	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
25305480	25305480	PRJNA397065_S_NODE_13400_length_204_cov_97.131429_g13150_i0	PRJNA397065	13400	204	97.131429	198.14811516	Streptococcus	1301	Bacteria	Bacteria	344	2.62e-90	NTclustered	gi\|1348284726\|gb\|CP020451.2\|	1304	g13150	i0	97.059	559.490196078431	204	6	100	0	1	204	605172	604969	Streptococcus salivarius strain FDAARGOS_259 chromosome, complete genome	blastn	114136	344	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);;