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

13 rows where analysis = "blastn", bioproject = "PRJNA1264536" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2329326	2329326	PRJNA1264536_P_NODE_4702_length_250_cov_0.881356_g4628_i0	PRJNA1264536	4702	250	0.881356	2.20339	Faecalibacterium	216851	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2094528058\|gb\|CP065382.1\|	853	g4628	i0	100	39.052	250	0	100	0	1	250	1955882	1956131	Faecalibacterium prausnitzii strain Fp944 chromosome, complete genome	blastn	9763	462	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
4191037	4191037	PRJNA1264536_P_NODE_4884_length_248_cov_0.891429_g4810_i0	PRJNA1264536	4884	248	0.891429	2.21074392	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2318943546\|gb\|CP107201.1\|	2485925	g4810	i0	100	1.98790322580645	248	0	100	0	1	248	302940	302693	MAG: Oscillospiraceae bacterium isolate KR001_HAM_0045 chromosome, complete genome	blastn	493	459	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
5467279	5467279	PRJNA1264536_P_NODE_5405_length_243_cov_0.917647_g5331_i0	PRJNA1264536	5405	243	0.917647	2.22988221	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	137	5.88e-28	NTclustered	gi\|2531976022\|emb\|OY282355.1\|	498747	g5331	i0	81.034	1.60493827160494	174	31	71	2	70	242	790376	790204	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	390	137	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
6156785	6156785	PRJNA1264536_P_NODE_2625_length_347_cov_1.138686_g2551_i0	PRJNA1264536	2625	347	1.138686	3.95124042	Cutibacterium	1912216	Bacteria	Bacteria	641	1.5299999999999996e-179	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2551	i0	100	271.881844380403	347	0	100	0	1	347	57055	56709	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	94343	641	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8706810	8706810	PRJNA1264536_P_NODE_3747_length_282_cov_0.856459_g3673_i0	PRJNA1264536	3747	282	0.856459	2.41521438	Faecalibacterium	216851	Bacteria	Bacteria	394	3.75e-105	NTclustered	gi\|2094528058\|gb\|CP065382.1\|	853	g3673	i0	100	245.560283687943	213	0	79	0	70	282	355362	355150	Faecalibacterium prausnitzii strain Fp944 chromosome, complete genome	blastn	69248	394	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
9292070	9292070	PRJNA1264536_P_NODE_4608_length_251_cov_0.876404_g4534_i0	PRJNA1264536	4608	251	0.876404	2.19977404	Clostridium manihotivorum	2320868	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1554469089\|gb\|CP025746.1\|	2320868	g4534	i0	100	0.111553784860558	28	0	11	0	24	51	1835404	1835431	Clostridium manihotivorum strain CT4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium manihotivorum
10568040	10568040	PRJNA1264536_P_NODE_5429_length_243_cov_0.917647_g5355_i0	PRJNA1264536	5429	243	0.917647	2.22988221	Faecalitalea cylindroides	39483	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|295098739\|emb\|FP929041.1\|	717960	g5355	i0	99.588	13.6913580246914	243	1	100	0	1	243	917485	917727	Eubacterium cylindroides T2-87 draft genome	blastn	3327	444	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Faecalitalea	Faecalitalea cylindroides
11257336	11257336	PRJNA1264536_P_NODE_3189_length_312_cov_0.970711_g3115_i0	PRJNA1264536	3189	312	0.970711	3.02861832	Mollicutes	31969	Bacteria	Bacteria	544	3.95e-150	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g3115	i0	99.663	96.2980769230769	297	1	95	0	13	309	427863	428159	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	30045	544	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16941184	16941184	PRJNA1264536_P_NODE_4974_length_247_cov_0.896552_g4900_i0	PRJNA1264536	4974	247	0.896552	2.21448344	Kitasatospora aureofaciens	1894	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1175678048\|gb\|CP020567.1\|	1894	g4900	i0	99.19	27.6842105263158	247	2	100	0	1	247	1300372	1300126	Kitasatospora aureofaciens strain DM-1, complete genome	blastn	6838	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora aureofaciens
18215663	18215663	PRJNA1264536_P_NODE_5235_length_245_cov_0.860465_g5161_i0	PRJNA1264536	5235	245	0.860465	2.10813925	Bacillus sp. FJAT-42376	2014076	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1519589463\|gb\|CP033906.1\|	2014076	g5161	i0	100	0.114285714285714	28	0	11	0	34	61	1125341	1125368	Bacillus sp. FJAT-42376 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. FJAT-42376
20180107	20180107	PRJNA1264536_P_NODE_4876_length_248_cov_0.891429_g4802_i0	PRJNA1264536	4876	248	0.891429	2.21074392	Brevibacterium	1696	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1013855561\|gb\|CP014869.1\|	1703	g4802	i0	99.597	371.758064516129	248	1	100	0	1	248	831242	831489	Brevibacterium linens strain BS258 chromosome, complete genome	blastn	92196	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium linens
22040595	22040595	PRJNA1264536_P_NODE_5378_length_243_cov_0.917647_g5304_i0	PRJNA1264536	5378	243	0.917647	2.22988221	Blautia wexlerae	418240	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2921375364\|gb\|CP136550.1\|	1121115	g5304	i0	99.588	5.86008230452675	243	1	100	0	1	243	3974127	3974369	Blautia wexlerae DSM 19850 chromosome, complete genome	blastn	1424	444	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia wexlerae
24590195	24590195	PRJNA1264536_P_NODE_4340_length_253_cov_0.866667_g4266_i0	PRJNA1264536	4340	253	0.866667	2.19266751	Actinocatenispora sera	390989	Bacteria	Bacteria	300	7.43e-77	NTclustered	gi\|2020954569\|dbj\|AP023354.1\|	390989	g4266	i0	88.664	1.97233201581028	247	26	97	2	4	249	2534309	2534064	Actinocatenispora sera NBRC 101916 DNA, complete genome	blastn	499	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Actinocatenispora	Actinocatenispora sera

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