metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1057075" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1057075" 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
4839334	4839334	PRJNA1057075_S_NODE_2464_length_265_cov_52881.166667_g2365_i0	PRJNA1057075	2464	265	52881.166667	140135.09166755	Bacteria	2	Bacteria	Bacteria	398	2.7e-106	NTclustered	gi\|1042399388\|gb\|KU555885.1\|	1292	g2365	i0	98.238	431.267924528302	227	4	86	0	1	227	443	669	Staphylococcus warneri strain SWA15219-3 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	114286	398	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
6554525	6554525	PRJNA1057075_S_NODE_3806_length_228_cov_3.849162_g3707_i0	PRJNA1057075	3806	228	3.849162	8.77608936	Aliterella chasmolithica	2739056	Bacteria	Bacteria	326	1.08e-84	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g3707	i0	94.737	109.504385964912	209	11	92	0	18	226	2178	1970	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	24967	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
6554550	6554550	PRJNA1057075_S_NODE_9986_length_157_cov_2.185185_g9887_i0	PRJNA1057075	9986	157	2.185185	3.43074045	Emergencia timonensis	1776384	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2613044976\|gb\|CP136188.1\|	1776384	g9887	i0	100	0.713375796178344	28	0	18	0	75	102	1824571	1824544	Emergencia timonensis strain NTUH-41-K21 chromosome, complete genome	blastn	112	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Emergencia	Emergencia timonensis
7829201	7829201	PRJNA1057075_S_NODE_4947_length_204_cov_0.948387_g4848_i0	PRJNA1057075	4947	204	0.948387	1.93470948	Clostridium septicum	1504	Bacteria	Bacteria	220	4.61e-53	NTclustered	gi\|2260370548\|gb\|CP099799.1\|	1504	g4848	i0	89.326	744.647058823529	178	15	86	3	25	200	231885	231710	Clostridium septicum strain RMA 8861 chromosome, complete genome	blastn	151908	220	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium septicum
9939434	9939434	PRJNA1057075_S_NODE_4648_length_209_cov_7.793750_g4549_i0	PRJNA1057075	4648	209	7.79375	16.2889375	Bacteria	2	Bacteria	Bacteria	209	1.03e-49	NTclustered	gi\|1199098093\|gb\|CP021423.1\|	2004467	g4549	i0	84.977	30.1531100478469	213	24	100	5	1	209	1550893	1550685	Armatimonadetes bacterium Uphvl-Ar1 genome	blastn	6302	211	0.990521327014218	Bacteria		Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar1
11655150	11655150	PRJNA1057075_S_NODE_4050_length_222_cov_6.179191_g3951_i0	PRJNA1057075	4050	222	6.179191	13.71780402	Aeromicrobium sp. Leaf245	1736306	Bacteria	Bacteria	355	1.34e-93	NTclustered	gi\|2241593934\|emb\|OW824151.1\|	1736306	g3951	i0	98.99	246.900900900901	198	2	89	0	1	198	2452	2255	Aeromicrobium sp. Leaf245 isolate wt genome assembly, chromosome: 1	blastn	54812	355	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Aeromicrobium	Aeromicrobium sp. Leaf245
13764679	13764679	PRJNA1057075_S_NODE_7091_length_177_cov_1.593750_g6992_i0	PRJNA1057075	7091	177	1.59375	2.8209375	Lactobacillus	1578	Bacteria	Bacteria	324	2.87e-84	NTclustered	gi\|2913177562\|gb\|CP180627.1\|	47770	g6992	i0	100	377.35593220339	175	0	99	0	1	175	1145979	1146153	Lactobacillus crispatus strain T31e chromosome, complete genome	blastn	66792	324	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
18028404	18028404	PRJNA1057075_S_NODE_4435_length_213_cov_6.445122_g4336_i0	PRJNA1057075	4435	213	6.445122	13.72810986	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	305	1.3e-78	NTclustered	gi\|225696178\|gb\|FJ805845.1\|	259957	g4336	i0	93.301	126.868544600939	209	10	97	4	7	213	1770	1564	Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27023	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19302304	19302304	PRJNA1057075_S_NODE_2376_length_268_cov_52638.155251_g2277_i0	PRJNA1057075	2376	268	52638.155251	141070.25607268	Staphylococcus hominis	1290	Bacteria	Bacteria	412	9.77e-111	NTclustered	gi\|1780389983\|gb\|CP046301.1\|	1290	g2277	i0	99.558	410.981343283582	226	1	84	0	43	268	1064642	1064867	Staphylococcus hominis strain FDAARGOS_747 chromosome, complete genome	blastn	110143	412	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
21853434	21853434	PRJNA1057075_S_NODE_10658_length_152_cov_3.902913_g10559_i0	PRJNA1057075	10658	152	3.902913	5.93242776	Corynebacterium hesseae	2913502	Bacteria	Bacteria	279	5.24e-71	NTclustered	gi\|2704699628\|gb\|CP137211.1\|	2913502	g10559	i0	100	359.644736842105	151	0	99	0	2	152	820498	820648	Corynebacterium hesseae strain 10VPs_Sm8 chromosome, complete genome	blastn	54666	279	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hesseae
21853466	21853466	PRJNA1057075_S_NODE_6298_length_185_cov_1.323529_g6199_i0	PRJNA1057075	6298	185	1.323529	2.44852865	Calothrix sp. 336/3	1337936	Bacteria	Bacteria	300	5.110000000000001e-77	NTclustered	gi\|817925425\|gb\|CP011382.1\|	1337936	g6199	i0	96.175	220.432432432432	183	7	99	0	3	185	2531315	2531133	Calothrix sp. 336/3, complete genome	blastn	40780	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. 336/3
21853470	21853470	PRJNA1057075_S_NODE_7058_length_177_cov_2.875000_g6959_i0	PRJNA1057075	7058	177	2.875	5.08875	Clostridium perfringens	1502	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2702800439\|gb\|CP148701.1\|	1502	g6959	i0	100	0.169491525423729	30	0	17	0	119	148	502640	502669	Clostridium perfringens strain Z1322PCP0092 chromosome, complete genome	blastn	30	56.5	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
23128899	23128899	PRJNA1057075_S_NODE_4179_length_219_cov_4.282353_g4080_i0	PRJNA1057075	4179	219	4.282353	9.37835307	Weissella paramesenteroides	1249	Bacteria	Bacteria	374	3.64e-99	NTclustered	gi\|1937010051\|gb\|CP065046.1\|	1249	g4080	i0	98.131	547.922374429224	214	4	98	0	1	214	363558	363345	Weissella paramesenteroides strain STCH-BD1 chromosome	blastn	119995	374	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella paramesenteroides

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