metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA1262902" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA1262902" 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
1638376	1638376	PRJNA1262902_P_NODE_7322_length_251_cov_1.471910_g7280_i0	PRJNA1262902	7322	251	1.47191	3.6944941	Staphylococcus warneri	1292	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|1717399658\|gb\|CP038244.1\|	1292	g7280	i0	99.602	6	251	1	100	0	1	251	1467	1717	Staphylococcus warneri strain GD01 plasmid p2GD01, complete sequence	blastn	1506	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
1638379	1638379	PRJNA1262902_P_NODE_7502_length_251_cov_0.865169_g7460_i0	PRJNA1262902	7502	251	0.865169	2.17157419	Staphylococcus warneri	1292	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g7460	i0	100	100.003984063745	251	0	100	0	1	251	1548070	1547820	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	25101	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
2329280	2329280	PRJNA1262902_P_NODE_11522_length_242_cov_1.881657_g11480_i0	PRJNA1262902	11522	242	1.881657	4.55360994	Staphylococcus	1279	Bacteria	Bacteria	418	1.8699999999999998e-112	NTclustered	gi\|1908784908\|gb\|CP051991.1\|	1280	g11480	i0	100	517.785123966942	226	0	93	0	1	226	2343066	2342841	Staphylococcus aureus strain ER08597.3 chromosome, complete genome	blastn	125304	418	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
2329281	2329281	PRJNA1262902_P_NODE_11742_length_242_cov_0.911243_g11700_i0	PRJNA1262902	11742	242	0.911243	2.20520806	Staphylococcus	1279	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g11700	i0	99.587	99.702479338843	242	1	100	0	1	242	2315917	2315676	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	24128	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
2914268	2914268	PRJNA1262902_P_NODE_7243_length_252_cov_1.290503_g7201_i0	PRJNA1262902	7243	252	1.290503	3.25206756	Vallitalea guaymasensis	1185412	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2030004409\|gb\|CP058561.1\|	1185412	g7201	i0	100	0.111111111111111	28	0	11	0	221	248	4900823	4900850	Vallitalea guaymasensis strain Ra1766G1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Vallitaleaceae	Vallitalea	Vallitalea guaymasensis
2914282	2914282	PRJNA1262902_P_NODE_8523_length_249_cov_0.875000_g8481_i0	PRJNA1262902	8523	249	0.875	2.17875	Saccharibacillus brassicae	2583377	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1696750961\|gb\|CP041217.1\|	2583377	g8481	i0	96.875	0.1285140562249	32	1	13	0	94	125	2447129	2447098	Saccharibacillus brassicae strain ATSA2 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Saccharibacillus	Saccharibacillus brassicae
6156743	6156743	PRJNA1262902_P_NODE_1285_length_405_cov_1.557229_g1243_i0	PRJNA1262902	1285	405	1.557229	6.30677745	Enterococcus	1350	Bacteria	Bacteria	743	0	NTclustered	gi\|1913493076\|gb\|CP050490.1\|	37734	g1243	i0	99.753	57.3506172839506	405	1	100	0	1	405	995269	995673	Enterococcus casseliflavus strain EGM182 chromosome, complete genome	blastn	23227	743	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
6156755	6156755	PRJNA1262902_P_NODE_7905_length_250_cov_0.870056_g7863_i0	PRJNA1262902	7905	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g7863	i0	99.2	72.896	250	2	100	0	1	250	2148258	2148507	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	18224	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
6741293	6741293	PRJNA1262902_P_NODE_12226_length_241_cov_0.916667_g12184_i0	PRJNA1262902	12226	241	0.916667	2.20916747	Staphylococcus warneri	1292	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g12184	i0	100	22.9253112033195	241	0	100	0	1	241	699170	699410	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	5525	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
9291671	9291671	PRJNA1262902_P_NODE_4208_length_290_cov_1.419355_g4166_i0	PRJNA1262902	4208	290	1.419355	4.1161295	Halanaerobium praevalens	2331	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|309388281\|gb\|CP002175.1\|	572479	g4166	i0	100	0.096551724137931	28	0	10	0	191	218	414598	414571	Halanaerobium praevalens DSM 2228, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium praevalens
9291681	9291681	PRJNA1262902_P_NODE_6208_length_263_cov_1.378947_g6166_i0	PRJNA1262902	6208	263	1.378947	3.62663061	Anaerococcus prevotii	33034	Bacteria	Bacteria	353	5.88e-93	NTclustered	gi\|256797400\|gb\|CP001708.1\|	525919	g6166	i0	90.875	1	263	24	100	0	1	263	414348	414610	Anaerococcus prevotii DSM 20548, complete genome	blastn	263	353	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
9291686	9291686	PRJNA1262902_P_NODE_6508_length_260_cov_1.149733_g6466_i0	PRJNA1262902	6508	260	1.149733	2.9893058	Peptoniphilus genitalis	3036303	Bacteria	Bacteria	470	5.519999999999998e-128	NTclustered	gi\|2246887130\|gb\|CP097885.1\|	3036303	g6466	i0	99.231	528.619230769231	260	2	100	0	1	260	291013	291272	Peptoniphilus genitalis strain SAHP1 chromosome, complete genome	blastn	137441	470	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus genitalis
9291687	9291687	PRJNA1262902_P_NODE_6568_length_259_cov_1.403226_g6526_i0	PRJNA1262902	6568	259	1.403226	3.63435534	Streptococcus oralis	1303	Bacteria	Bacteria	446	9.26e-121	NTclustered	gi\|1247204361\|gb\|CP023507.1\|	1303	g6526	i0	97.683	50.1660231660232	259	6	100	0	1	259	242449	242191	Streptococcus oralis strain FDAARGOS_367 chromosome, complete genome	blastn	12993	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9291719	9291719	PRJNA1262902_P_NODE_8728_length_248_cov_0.880000_g8686_i0	PRJNA1262902	8728	248	0.88	2.1824	Trichococcus shcherbakoviae	2094020	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2621704421\|emb\|OY761017.1\|	2094020	g8686	i0	99.597	5.93951612903226	248	1	100	0	1	248	963542	963789	MAG: Trichococcus shcherbakoviae isolate 89b17532-9bee-499f-becb-1a49c542a750 genome assembly, chromosome: 2	blastn	1473	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Trichococcus	Trichococcus shcherbakoviae
10567672	10567672	PRJNA1262902_P_NODE_8149_length_250_cov_0.870056_g8107_i0	PRJNA1262902	8149	250	0.870056	2.17514	Staphylococcus hominis	1290	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1854288993\|gb\|CP054550.1\|	1290	g8107	i0	100	88.312	250	0	100	0	1	250	2175761	2175512	Staphylococcus hominis strain FDAARGOS_661 chromosome, complete genome	blastn	22078	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
11257308	11257308	PRJNA1262902_P_NODE_9149_length_247_cov_0.885057_g9107_i0	PRJNA1262902	9149	247	0.885057	2.18609079	Bacillus	1386	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1352835676\|gb\|CP026673.1\|	1402	g9107	i0	100	70.6963562753036	247	0	100	0	1	247	1786255	1786009	Bacillus licheniformis strain 14ADL4 chromosome, complete genome	blastn	17462	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus licheniformis
13807419	13807419	PRJNA1262902_P_NODE_12671_length_226_cov_2.496732_g12629_i0	PRJNA1262902	12671	226	2.496732	5.64261432	Bacillales	1385	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|164416071\|gb\|EU350088.1\|	1280	g12629	i0	100	120.33185840708	226	0	100	0	1	226	1318	1543	Staphylococcus aureus strain JY50 plasmid pKH21, complete sequence	blastn	27195	418	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13807429	13807429	PRJNA1262902_P_NODE_9891_length_246_cov_0.890173_g9849_i0	PRJNA1262902	9891	246	0.890173	2.18982558	Melissococcus	33969	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1381844732\|dbj\|AP018493.1\|	33970	g9849	i0	100	0.227642276422764	28	0	11	0	40	67	179556	179529	Melissococcus plutonius plasmid pMP1 DAT561 DNA, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Melissococcus	Melissococcus plutonius
14392712	14392712	PRJNA1262902_P_NODE_532_length_581_cov_1.870079_g491_i0	PRJNA1262902	532	581	1.870079	10.86515899	Clostridium beijerinckii	1520	Bacteria	Bacteria	1074	0	NTclustered	gi\|1389517133\|gb\|CP029329.1\|	1520	g491	i0	100	1020.15146299484	581	0	100	0	1	581	271835	271255	Clostridium beijerinckii isolate WB53 chromosome, complete genome	blastn	592708	1074	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
14392715	14392715	PRJNA1262902_P_NODE_5772_length_268_cov_1.558974_g5730_i0	PRJNA1262902	5772	268	1.558974	4.17805032	Terrisporobacter petrolearius	1460447	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2727622740\|gb\|CP154619.1\|	1460447	g5730	i0	94.286	0.261194029850746	35	1	13	1	179	213	378432	378465	Terrisporobacter petrolearius strain HSE chromosome, complete genome	blastn	70	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Terrisporobacter	Terrisporobacter petrolearius
14392727	14392727	PRJNA1262902_P_NODE_7352_length_251_cov_1.219101_g7310_i0	PRJNA1262902	7352	251	1.219101	3.05994351	Staphylococcus aureus	1280	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621759458\|gb\|CP138361.1\|	1280	g7310	i0	94.286	11.5896414342629	35	2	14	0	189	223	697449	697483	Staphylococcus aureus strain V482 chromosome, complete genome	blastn	2909	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
15666452	15666452	PRJNA1262902_P_NODE_6093_length_264_cov_1.612565_g6051_i0	PRJNA1262902	6093	264	1.612565	4.2571716	Finegoldia magna	1260	Bacteria	Bacteria	475	1.2099999999999996e-129	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g6051	i0	99.242	6.00378787878788	264	1	100	1	1	264	574056	574318	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	1585	475	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
16356425	16356425	PRJNA1262902_P_NODE_5233_length_275_cov_2.618812_g5191_i0	PRJNA1262902	5233	275	2.618812	7.201733	Clostridium	1485	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1370563981\|gb\|CP027781.1\|	1491	g5191	i0	100	0.949090909090909	29	0	11	0	98	126	2524408	2524380	Clostridium botulinum strain MAP 5 chromosome, complete genome	blastn	261	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
17631660	17631660	PRJNA1262902_P_NODE_10814_length_244_cov_0.900585_g10772_i0	PRJNA1262902	10814	244	0.900585	2.1974274	Proteiniclasticum	1155385	Bacteria	Bacteria	191	4.47e-44	NTclustered	gi\|2282824529\|gb\|CP102060.1\|	2961947	g10772	i0	85.263	5.59426229508197	190	23	77	3	13	200	3284402	3284216	Clostridiaceae bacterium HFYG-1003 chromosome, complete genome	blastn	1365	191	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium HFYG-1003
18215315	18215315	PRJNA1262902_P_NODE_8635_length_248_cov_1.714286_g8593_i0	PRJNA1262902	8635	248	1.714286	4.25142928	Finegoldia magna	1260	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g8593	i0	100	245.459677419355	248	0	100	0	1	248	163297	163544	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	60874	459	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
18215322	18215322	PRJNA1262902_P_NODE_9315_length_247_cov_0.885057_g9273_i0	PRJNA1262902	9315	247	0.885057	2.18609079	Streptococcus parasuis	1501662	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2830875038\|gb\|CP170759.1\|	1501662	g9273	i0	100	13.5101214574899	247	0	100	0	1	247	1611076	1611322	Streptococcus parasuis strain FZ1 chromosome, complete genome	blastn	3337	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasuis
18905444	18905444	PRJNA1262902_P_NODE_10595_length_244_cov_1.216374_g10553_i0	PRJNA1262902	10595	244	1.216374	2.96795256	Bacillales	1385	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2432632113\|gb\|OP378667.1\|	1280	g10553	i0	100	100	244	0	100	0	1	244	13794	14037	Staphylococcus aureus strain MRSA10075 plasmid pMRSA10075_2, complete sequence	blastn	24400	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
21455828	21455828	PRJNA1262902_P_NODE_11577_length_242_cov_1.431953_g11535_i0	PRJNA1262902	11577	242	1.431953	3.46532626	Staphylococcus	1279	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g11535	i0	99.587	29.9586776859504	242	1	100	0	1	242	1011761	1011520	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	7250	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
22040215	22040215	PRJNA1262902_P_NODE_5138_length_277_cov_1.132353_g5096_i0	PRJNA1262902	5138	277	1.132353	3.13661781	Thermaerobacter marianensis	73919	Bacteria	Bacteria	158	5.25e-34	NTclustered	gi\|315590829\|gb\|CP002344.1\|	644966	g5096	i0	81.579	53.3790613718412	190	35	69	0	67	256	435436	435247	Thermaerobacter marianensis DSM 12885, complete genome	blastn	14786	158	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiales Family XVII. Incertae Sedis	Thermaerobacter	Thermaerobacter marianensis
25280084	25280084	PRJNA1262902_P_NODE_1900_length_358_cov_1.578947_g1858_i0	PRJNA1262902	1900	358	1.578947	5.65263026	Leuconostoc	1243	Bacteria	Bacteria	662	0	NTclustered	gi\|507148371\|ref\|NR_103174.1\|	1244	g1858	i0	100	346.997206703911	358	0	100	0	1	358	781	1138	Leuconostoc gelidum strain JB7 23S ribosomal RNA gene, complete sequence	blastn	124225	662	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc gelidum

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