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

17 rows where analysis = "blastn", bioproject = "PRJNA1199893" 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
1044692	1044692	PRJNA1199893_P_NODE_14701_length_249_cov_1.227273_g14626_i0	PRJNA1199893	14701	249	1.227273	3.05590977	Glutamicibacter	1742989	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g14626	i0	97.189	441.971887550201	249	7	100	0	1	249	100792	100544	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	110051	422	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
1601290	1601290	PRJNA1199893_P_NODE_11782_length_279_cov_1.199029_g11707_i0	PRJNA1199893	11782	279	1.199029	3.34529091	Raineyella sp. LH-20	3081204	Bacteria	Bacteria	388	1.7199999999999998e-103	NTclustered	gi\|2606726494\|gb\|CP137003.1\|	3081204	g11707	i0	91.786	250.666666666667	280	21	100	2	1	279	99714	99992	Raineyella sp. LH-20 chromosome, complete genome	blastn	69936	388	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Raineyella	Raineyella sp. LH-20
2877819	2877819	PRJNA1199893_P_NODE_8283_length_332_cov_0.737452_g8208_i0	PRJNA1199893	8283	332	0.737452	2.44834064	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	599	8.909999999999998e-167	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g8208	i0	99.394	355.972891566265	330	2	99	0	1	330	293068	293397	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	118183	599	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
8697591	8697591	PRJNA1199893_P_NODE_17147_length_242_cov_0.911243_g17072_i0	PRJNA1199893	17147	242	0.911243	2.20520806	Listeria	1637	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1958359519\|gb\|CP068150.1\|	1639	g17072	i0	96.875	2.3801652892562	32	0	13	1	94	124	2829987	2830018	Listeria monocytogenes strain FDAARGOS_1080 chromosome, complete genome	blastn	576	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
9972748	9972748	PRJNA1199893_P_NODE_16728_length_243_cov_0.905882_g16653_i0	PRJNA1199893	16728	243	0.905882	2.20129326	Lacticaseibacillus	2759736	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1917898043\|gb\|CP049324.1\|	1597	g16653	i0	100	100	243	0	100	0	1	243	1350986	1350744	Lacticaseibacillus paracasei strain NSMJ15 chromosome	blastn	24300	449	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
10530522	10530522	PRJNA1199893_P_NODE_14829_length_249_cov_0.875000_g14754_i0	PRJNA1199893	14829	249	0.875	2.17875	Streptococcus sp. 116-D4	2598453	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1778008955\|dbj\|AP021887.1\|	2598453	g14754	i0	100	328	249	0	100	0	1	249	19375	19127	Streptococcus sp. 116-D4 DNA, complete genome	blastn	81672	460	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. 116-D4
10530676	10530676	PRJNA1199893_P_NODE_449_length_1265_cov_3.327181_g416_i0	PRJNA1199893	449	1265	3.327181	42.08883965	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1777	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g416	i0	92.047	147.522529644269	1270	92	100	9	1	1265	2893	1628	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	186616	1777	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10530801	10530801	PRJNA1199893_P_NODE_9849_length_304_cov_1.320346_g9774_i0	PRJNA1199893	9849	304	1.320346	4.01385184	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g9774	i0	100	0.0921052631578947	28	0	9	0	135	162	703756	703783	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
11247963	11247963	PRJNA1199893_P_NODE_5549_length_408_cov_1.167164_g5475_i0	PRJNA1199893	5549	408	1.167164	4.76202912	Actinomycetes	1760	Bacteria	Bacteria	649	0	NTclustered	gi\|254972631\|gb\|GQ329251.1\|	114050	g5475	i0	95.355	121.291666666667	409	18	100	1	1	408	136	544	Uncultured Arthrobacter sp. clone P4s-190 16S ribosomal RNA gene, partial sequence	blastn	49487	652	0.995398773006135	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	uncultured Arthrobacter sp.
13080356	13080356	PRJNA1199893_P_NODE_16431_length_244_cov_0.900585_g16356_i0	PRJNA1199893	16431	244	0.900585	2.1974274	Corynebacterium minutissimum	38301	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1403572617\|emb\|LS483460.1\|	38301	g16356	i0	100	7.21311475409836	244	0	100	0	1	244	171178	171421	Corynebacterium minutissimum strain NCTC10288 genome assembly, chromosome: 1	blastn	1760	451	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium minutissimum
14355837	14355837	PRJNA1199893_P_NODE_5112_length_425_cov_2.303977_g5039_i0	PRJNA1199893	5112	425	2.303977	9.79190225	Corynebacterium kefirresidentii	1979527	Bacteria	Bacteria	756	0	NTclustered	gi\|2869819920\|gb\|CP175795.1\|	1979527	g5039	i0	98.824	361.771764705882	425	4	99	1	2	425	788415	787991	Corynebacterium kefirresidentii strain YSMAA1_1_C6 chromosome, complete genome	blastn	153753	756	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
17622379	17622379	PRJNA1199893_P_NODE_13614_length_257_cov_1.010870_g13539_i0	PRJNA1199893	13614	257	1.01087	2.5979359	Lacticaseibacillus	2759736	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1845309819\|gb\|CP053619.1\|	47715	g13539	i0	100	455.933852140078	257	0	100	0	1	257	546695	546439	Lacticaseibacillus rhamnosus strain LV108 chromosome, complete genome	blastn	117175	475	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus rhamnosus
17622395	17622395	PRJNA1199893_P_NODE_4014_length_478_cov_1.217284_g3941_i0	PRJNA1199893	4014	478	1.217284	5.81861752	Bacteria	2	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2209700036\|dbj\|AP025668.1\|	1912	g3941	i0	96.875	1.66317991631799	32	1	7	0	368	399	2208162	2208193	Streptomyces hygroscopicus HOK021 DNA, complete genome	blastn	795	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces hygroscopicus
18178418	18178418	PRJNA1199893_P_NODE_17575_length_241_cov_0.916667_g17500_i0	PRJNA1199893	17575	241	0.916667	2.20916747	Anaerococcus sp. Marseille-Q7828	3036300	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|2472116327\|emb\|OX458331.1\|	3036300	g17500	i0	97.925	587.634854771784	241	5	100	0	1	241	257160	256920	Anaerococcus sp. Marseille-Q7828 genome assembly, chromosome: contig00001	blastn	141620	418	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. Marseille-Q7828
20170933	20170933	PRJNA1199893_P_NODE_9796_length_305_cov_1.137931_g9721_i0	PRJNA1199893	9796	305	1.137931	3.47068955	Arthrobacter	1663	Bacteria	Bacteria	492	1.41e-134	NTclustered	gi\|2719889153\|gb\|CP151657.1\|	1670	g9721	i0	95.738	447.072131147541	305	13	100	0	1	305	751595	751291	Arthrobacter citreus strain EINP1 chromosome, complete genome	blastn	136357	492	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
22721554	22721554	PRJNA1199893_P_NODE_8778_length_322_cov_2.168675_g8703_i0	PRJNA1199893	8778	322	2.168675	6.9831335	Corynebacterium	1716	Bacteria	Bacteria	278	4.58e-70	NTclustered	gi\|2869819920\|gb\|CP175795.1\|	1979527	g8703	i0	100	25.2204968944099	150	0	93	0	1	150	421392	421243	Corynebacterium kefirresidentii strain YSMAA1_1_C6 chromosome, complete genome	blastn	8121	278	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
25270839	25270839	PRJNA1199893_P_NODE_12240_length_273_cov_1.925000_g12165_i0	PRJNA1199893	12240	273	1.925	5.25525	Glutamicibacter	1742989	Bacteria	Bacteria	499	7.45e-137	NTclustered	gi\|2688610184\|gb\|CP033081.2\|	37929	g12165	i0	99.635	279.970695970696	274	0	100	1	1	273	92044	92317	Glutamicibacter nicotianae strain OTC-16 chromosome, complete genome	blastn	76432	499	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae

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