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

17 rows where analysis = "blastn", bioproject = "PRJNA971593" 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
944407	944407	PRJNA971593_P_NODE_5721_length_508_cov_1.960920_g5573_i0	PRJNA971593	5721	508	1.96092	9.9614736	Dellaglioa kimchii	3344667	Bacteria	Bacteria	52.8	0.05	NTclustered	gi\|2870265686\|gb\|CP170736.1\|	3344667	g5573	i0	100	0.0551181102362205	28	0	6	0	112	139	1095885	1095912	Dellaglioa sp. P0083 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Dellaglioa	Dellaglioa kimchii
2219542	2219542	PRJNA971593_P_NODE_1942_length_843_cov_1.342857_g1818_i0	PRJNA971593	1942	843	1.342857	11.32028451	Pontibacillus sp. HMF3514	2692425	Bacteria	Bacteria	56.5	0.007	NTclustered	gi\|1796203761\|gb\|CP047393.1\|	2692425	g1818	i0	96.97	0.0391459074733096	33	1	4	0	256	288	818054	818022	Pontibacillus sp. HMF3514 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Pontibacillus	Pontibacillus sp. HMF3514
3818225	3818225	PRJNA971593_P_NODE_18663_length_276_cov_1.236453_g18514_i0	PRJNA971593	18663	276	1.236453	3.41261028	Niallia	2837506	Bacteria	Bacteria	494	3.51e-135	NTclustered	gi\|1848538850\|gb\|CP053989.1\|	1397	g18514	i0	98.913	1079.8731884058	276	3	100	0	1	276	119885	120160	Niallia circulans strain FDAARGOS_783 chromosome, complete genome	blastn	298045	494	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia circulans
7322322	7322322	PRJNA971593_P_NODE_23426_length_249_cov_1.312500_g23277_i0	PRJNA971593	23426	249	1.3125	3.268125	Erysipelothrix sp. P66	3141531	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2724004414\|gb\|CP152290.1\|	3141531	g23277	i0	100	0.112449799196787	28	0	11	0	124	151	1518444	1518471	Erysipelothrix sp. P66 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Erysipelothrix	Erysipelothrix sp. P66
7644240	7644240	PRJNA971593_P_NODE_13706_length_325_cov_1.444444_g13557_i0	PRJNA971593	13706	325	1.444444	4.694443	Bacilli	91061	Bacteria	Bacteria	551	2.469999999999999e-152	NTclustered	gi\|453201778\|gb\|JQ999686.1\|	165192	g13557	i0	97.231	390.692307692308	325	9	100	0	1	325	142	466	Uncultured Pediococcus sp. clone GKJWQY101AMK4B 23S ribosomal RNA gene, partial sequence	blastn	126975	551	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	uncultured Pediococcus sp.
9872549	9872549	PRJNA971593_P_NODE_29068_length_241_cov_0.916667_g28919_i0	PRJNA971593	29068	241	0.916667	2.20916747	Mammaliicoccus stepanovicii	643214	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1231729876\|emb\|LT906462.1\|	643214	g28919	i0	100	0.116182572614108	28	0	12	0	208	235	942975	942948	Staphylococcus stepanovicii strain NCTC13839 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus stepanovicii
11470119	11470119	PRJNA971593_P_NODE_25329_length_247_cov_0.885057_g25180_i0	PRJNA971593	25329	247	0.885057	2.18609079	Paenibacillus	44249	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1043654043\|gb\|CP014167.1\|	1462996	g25180	i0	100	2	247	0	100	0	1	247	2693356	2693110	Paenibacillus yonginensis strain DCY84 chromosome, complete genome	blastn	494	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus yonginensis
12423457	12423457	PRJNA971593_P_NODE_22810_length_250_cov_0.870056_g22661_i0	PRJNA971593	22810	250	0.870056	2.17514	Streptococcus sp. FDAARGOS_192	1839799	Bacteria	Bacteria	385	1.97e-102	NTclustered	gi\|1352481858\|gb\|CP020431.2\|	1839799	g22661	i0	94.4	146.768	250	14	100	0	1	250	510156	509907	Streptococcus sp. FDAARGOS_192 chromosome, complete genome	blastn	36692	385	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. FDAARGOS_192
12745436	12745436	PRJNA971593_P_NODE_13190_length_332_cov_1.073359_g13041_i0	PRJNA971593	13190	332	1.073359	3.56355188	FCB group	1783270	Bacteria	Bacteria	69.4	3.11e-7	NTclustered	gi\|1016266797\|gb\|CP014806.1\|	241244	g13041	i0	89.091	1.90060240963855	55	6	17	0	243	297	880259	880313	Rummeliibacillus stabekisii strain PP9, complete genome	blastn	631	69.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Rummeliibacillus	Rummeliibacillus stabekisii
13698135	13698135	PRJNA971593_P_NODE_8851_length_408_cov_1.901493_g8702_i0	PRJNA971593	8851	408	1.901493	7.75809144	Sporolactobacillus sp. Y61	3160863	Bacteria	Bacteria	571	2.4299999999999995e-158	NTclustered	gi\|2754059576\|gb\|CP159510.1\|	3160863	g8702	i0	91.951	932.411764705882	410	30	100	3	1	408	282444	282852	Sporolactobacillus sp. Y61 chromosome, complete genome	blastn	380424	571	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Sporolactobacillaceae	Sporolactobacillus	Sporolactobacillus sp. Y61
16247005	16247005	PRJNA971593_P_NODE_16433_length_294_cov_1.393665_g16284_i0	PRJNA971593	16433	294	1.393665	4.0973751	Candidatus Faecalibacterium intestinigallinarum	2838581	Bacteria	Bacteria	172	2.0099999999999999e-38	NTclustered	gi\|2729058703\|emb\|OZ007003.1\|	2838581	g16284	i0	80.717	74.3027210884354	223	41	76	2	46	267	215739	215960	MAG: Candidatus Faecalibacterium intestinigallinarum isolate 6755_HET_CTRL_s271.ctg000340c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	21845	172	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Candidatus Faecalibacterium intestinigallinarum
17522257	17522257	PRJNA971593_P_NODE_17814_length_282_cov_2.133971_g17665_i0	PRJNA971593	17814	282	2.133971	6.01779822	Jeotgalicoccus sp. WY2	2708346	Bacteria	Bacteria	521	1.6499999999999996e-143	NTclustered	gi\|2043521547\|gb\|CP049818.1\|	2708346	g17665	i0	100	659.549645390071	282	0	100	0	1	282	735389	735670	Jeotgalicoccus sp. WY2 chromosome, complete genome	blastn	185993	521	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. WY2
17843764	17843764	PRJNA971593_P_NODE_2594_length_739_cov_1.987988_g2458_i0	PRJNA971593	2594	739	1.987988	14.69123132	Staphylococcus	1279	Bacteria	Bacteria	1360	0	NTclustered	gi\|2313042772\|gb\|CP094724.1\|	1290	g2458	i0	99.865	476.545331529093	739	1	100	0	1	739	724826	725564	Staphylococcus hominis strain IVB6247 chromosome, complete genome	blastn	352167	1360	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
20392529	20392529	PRJNA971593_P_NODE_19536_length_269_cov_1.178571_g19387_i0	PRJNA971593	19536	269	1.178571	3.17035599	Bacillaceae	186817	Bacteria	Bacteria	492	1.23e-134	NTclustered	gi\|1220359032\|gb\|KY283965.1\|	1409	g19387	i0	99.628	208	269	1	100	0	1	269	283	15	Bacillus sp. (in: Bacteria) strain TR1 16S ribosomal RNA gene, partial sequence	blastn	55952	492	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. (in: firmicutes)
20392581	20392581	PRJNA971593_P_NODE_29696_length_210_cov_2.262774_g29547_i0	PRJNA971593	29696	210	2.262774	4.7518254	Bacillus	1386	Bacteria	Bacteria	215	2.22e-51	NTclustered	gi\|2216359396\|gb\|CP064266.1\|	64104	g29547	i0	93.243	791.852380952381	148	6	70	3	1	147	1608619	1608475	Bacillus pseudomycoides strain N451-2 chromosome, complete genome	blastn	166289	215	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus pseudomycoides
20392620	20392620	PRJNA971593_P_NODE_9396_length_396_cov_1.297214_g9247_i0	PRJNA971593	9396	396	1.297214	5.13696744	Streptococcus	1301	Bacteria	Bacteria	726	0	NTclustered	gi\|1654254190\|emb\|LR594049.1\|	1302	g9247	i0	99.747	330.063131313131	396	1	100	0	1	396	641231	640836	Streptococcus gordonii strain NCTC10231 genome assembly, chromosome: 1	blastn	130705	732	0.991803278688525	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
25492765	25492765	PRJNA971593_P_NODE_23340_length_249_cov_2.346591_g23191_i0	PRJNA971593	23340	249	2.346591	5.84301159	Anoxybacillus	150247	Bacteria	Bacteria	444	3.18e-120	NTclustered	gi\|906363419\|gb\|CP012152.1\|	198467	g23191	i0	98.795	809.682730923695	249	3	100	0	1	249	11870	12118	Anoxybacillus gonensis strain G2, complete genome	blastn	201611	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus gonensis

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