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

18 rows where analysis = "blastn", bioproject = "PRJNA638138" 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
1155201	1155201	PRJNA638138_P_NODE_10621_length_324_cov_0.988048_g10406_i0	PRJNA638138	10621	324	0.988048	3.20127552	root	1	Root_unresolved	Root_unresolved	599	8.67e-167	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g10406	i0	100	57.7777777777778	324	0	100	0	1	324	2427506	2427829	Staphylococcus aureus strain WH9628 chromosome	blastn	18720	599	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
1885431	1885431	PRJNA638138_P_NODE_13502_length_295_cov_0.981982_g13287_i0	PRJNA638138	13502	295	0.981982	2.8968469	Anaerococcus sp. Marseille-Q7828	3036300	Bacteria	Bacteria	462	1.07e-125	NTclustered	gi\|2472116327\|emb\|OX458331.1\|	3036300	g13287	i0	94.915	865.6	295	15	100	0	1	295	256284	255990	Anaerococcus sp. Marseille-Q7828 genome assembly, chromosome: contig00001	blastn	255352	462	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. Marseille-Q7828
3706863	3706863	PRJNA638138_P_NODE_16863_length_267_cov_2.226804_g16648_i0	PRJNA638138	16863	267	2.226804	5.94556668	Bacilli	91061	Bacteria	Bacteria	494	3.38e-135	NTclustered	gi\|2070669246\|gb\|MZ603108.1\|	1290	g16648	i0	100	100	267	0	100	0	1	267	298	32	Staphylococcus hominis strain PSMR 5.6 16S ribosomal RNA gene, partial sequence	blastn	26700	494	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
4437266	4437266	PRJNA638138_P_NODE_6704_length_386_cov_0.779553_g6489_i0	PRJNA638138	6704	386	0.779553	3.00907458	Abyssicoccus albus	1817405	Bacteria	Bacteria	555	2.299999999999999e-153	NTclustered	gi\|1142909432\|gb\|CP019573.1\|	1817405	g6489	i0	92.746	312.544041450777	386	25	100	3	1	386	292038	292420	Abyssicoccus albus strain S31 chromosome, complete genome	blastn	120642	555	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Abyssicoccaceae	Abyssicoccus	Abyssicoccus albus
6987800	6987800	PRJNA638138_P_NODE_15386_length_279_cov_1.485437_g15171_i0	PRJNA638138	15386	279	1.485437	4.14436923	Weissella paramesenteroides	1249	Bacteria	Bacteria	494	3.55e-135	NTclustered	gi\|2853045441\|gb\|CP097574.1\|	1249	g15171	i0	98.566	6.98207885304659	279	4	100	0	1	279	1941945	1942223	Weissella paramesenteroides strain JL-5 chromosome, complete genome	blastn	1948	494	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella paramesenteroides
8808146	8808146	PRJNA638138_P_NODE_21927_length_250_cov_0.870056_g21712_i0	PRJNA638138	21927	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g21712	i0	100	42	250	0	100	0	1	250	287235	286986	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	10500	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
9538082	9538082	PRJNA638138_P_NODE_588_length_1135_cov_1.049906_g462_i0	PRJNA638138	588	1135	1.049906	11.9164331	Staphylococcus epidermidis	1282	Bacteria	Bacteria	704	0	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g462	i0	78.831	41.5938325991189	1044	221	92	0	7	1050	1052	9	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	47209	704	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12088729	12088729	PRJNA638138_P_NODE_19470_length_251_cov_0.865169_g19255_i0	PRJNA638138	19470	251	0.865169	2.17157419	Staphylococcus gallinarum	1293	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2894814219\|gb\|CP178530.1\|	1293	g19255	i0	99.203	100.812749003984	251	2	100	0	1	251	473626	473876	Staphylococcus gallinarum strain X16P4 chromosome, complete genome	blastn	25304	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus gallinarum
12634298	12634298	PRJNA638138_P_NODE_29130_length_245_cov_0.895349_g28915_i0	PRJNA638138	29130	245	0.895349	2.19360505	Streptococcus	1301	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2886503043\|emb\|OZ217341.1\|	28037	g28915	i0	99.184	100	245	2	100	0	1	245	1355406	1355650	Streptococcus mitis isolate S. mitis C22 genome assembly, chromosome: 1	blastn	24500	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
12634311	12634311	PRJNA638138_P_NODE_32610_length_243_cov_0.905882_g32395_i0	PRJNA638138	32610	243	0.905882	2.20129326	Streptococcus	1301	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g32395	i0	100	100	243	0	100	0	1	243	1563581	1563339	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	24300	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
13909238	13909238	PRJNA638138_P_NODE_34991_length_241_cov_0.916667_g34776_i0	PRJNA638138	34991	241	0.916667	2.20916747	Streptococcus	1301	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g34776	i0	100	99.9709543568465	241	0	100	0	1	241	407964	408204	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	24093	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
14638258	14638258	PRJNA638138_P_NODE_21512_length_250_cov_0.870056_g21297_i0	PRJNA638138	21512	250	0.870056	2.17514	Streptococcus mitis	28037	Bacteria	Bacteria	392	1.1699999999999999e-104	NTclustered	gi\|1851386209\|gb\|CP047883.1\|	28037	g21297	i0	95.161	99.188	248	12	99	0	3	250	694883	694636	Streptococcus mitis strain S022-V3-A4 chromosome, complete genome	blastn	24797	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
15912195	15912195	PRJNA638138_P_NODE_19673_length_251_cov_0.865169_g19458_i0	PRJNA638138	19673	251	0.865169	2.17157419	Staphylococcus hominis	1290	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2870745991\|gb\|CP134693.1\|	1290	g19458	i0	100	99.4262948207171	251	0	100	0	1	251	734945	734695	Staphylococcus hominis strain acrlw chromosome, complete genome	blastn	24956	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
17187372	17187372	PRJNA638138_P_NODE_26954_length_246_cov_0.890173_g26739_i0	PRJNA638138	26954	246	0.890173	2.18982558	Exiguobacterium aurantiacum	33987	Bacteria	Bacteria	372	1.5e-98	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g26739	i0	93.902	5.99593495934959	246	15	100	0	1	246	1557386	1557141	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	1475	372	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
17733147	17733147	PRJNA638138_P_NODE_3454_length_517_cov_2.675676_g3240_i0	PRJNA638138	3454	517	2.675676	13.83324492	Lactobacillus	1578	Bacteria	Bacteria	913	0	NTclustered	gi\|2551527569\|gb\|CP130436.1\|	1579	g3240	i0	98.641	405.936170212766	515	7	99	0	1	515	128820	129334	Lactobacillus acidophilus strain ATCC 53544 chromosome, complete genome	blastn	209869	913	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus acidophilus
21557098	21557098	PRJNA638138_P_NODE_13817_length_292_cov_1.187215_g13602_i0	PRJNA638138	13817	292	1.187215	3.4666678	Streptococcus	1301	Bacteria	Bacteria	540	4.74e-149	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g13602	i0	100	335.921232876712	292	0	100	0	1	292	1569963	1570254	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	98089	540	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
22286661	22286661	PRJNA638138_P_NODE_9498_length_337_cov_2.488636_g9283_i0	PRJNA638138	9498	337	2.488636	8.38670332	Lactobacillus iners	147802	Bacteria	Bacteria	623	5.369999999999999e-174	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g9283	i0	100	494.489614243323	337	0	100	0	1	337	3422	3086	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	166643	623	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
22832635	22832635	PRJNA638138_P_NODE_1898_length_681_cov_2.435855_g1690_i0	PRJNA638138	1898	681	2.435855	16.58817255	Staphylococcus	1279	Bacteria	Bacteria	1258	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1690	i0	100	546.859030837004	681	0	100	0	1	681	749123	748443	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	372411	1258	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis

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