metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA688736" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA688736" and tax_phylum = "Actinomycetota"

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
667964	667964	PRJNA688736_P_NODE_40321_length_253_cov_0.866667_g40036_i0	PRJNA688736	40321	253	0.866667	2.19266751	Paeniglutamicibacter sp. Y32M11	2853258	Bacteria	Bacteria	377	3.33e-100	NTclustered	gi\|2070136978\|gb\|CP079107.1\|	2853258	g40036	i0	93.676	82.2806324110672	253	15	100	1	1	253	2777380	2777631	Paeniglutamicibacter sp. Y32M11 chromosome, complete genome	blastn	20817	377	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Paeniglutamicibacter	Paeniglutamicibacter sp. Y32M11
668156	668156	PRJNA688736_P_NODE_48201_length_244_cov_1.830409_g47916_i0	PRJNA688736	48201	244	1.830409	4.46619796	Nocardioides sp. HDW12B	2714939	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|1821124102\|gb\|CP049867.1\|	2714939	g47916	i0	98.361	282.680327868852	244	4	100	0	1	244	2039284	2039041	Nocardioides sp. HDW12B chromosome, complete genome	blastn	68974	429	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. HDW12B
1943850	1943850	PRJNA688736_P_NODE_35522_length_269_cov_1.122449_g35237_i0	PRJNA688736	35522	269	1.122449	3.01938781	Nocardioides sp. HDW12B	2714939	Bacteria	Bacteria	460	3.45e-125	NTclustered	gi\|1821124102\|gb\|CP049867.1\|	2714939	g35237	i0	97.753	210.851301115242	267	6	99	0	1	267	2039192	2039458	Nocardioides sp. HDW12B chromosome, complete genome	blastn	56719	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. HDW12B
2452331	2452331	PRJNA688736_P_NODE_1302_length_1141_cov_2.367978_g1160_i0	PRJNA688736	1302	1141	2.367978	27.01862898	Bifidobacterium	1678	Bacteria	Bacteria	1362	0	NTclustered	gi\|2077498158\|gb\|CP048272.1\|	1684	g1160	i0	90.75	276.015775635408	1027	86	90	7	1	1023	28803	29824	Bifidobacterium asteroides strain ESL0447 chromosome, complete genome	blastn	314934	1362	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium asteroides
3218625	3218625	PRJNA688736_P_NODE_30103_length_292_cov_1.027397_g29818_i0	PRJNA688736	30103	292	1.027397	2.99999924	uncultured Actinomycetes bacterium	152507	Bacteria	Bacteria	124	5.65e-24	NTclustered	gi\|2874254103\|emb\|OY970186.1\|	152507	g29818	i0	83.333	3.63356164383562	138	20	47	3	1	137	3263864	3263729	MAG: uncultured Actinomycetes bacterium isolate MFD04967.bin.c.5 genome assembly, chromosome: 1	blastn	1061	124	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
3218773	3218773	PRJNA688736_P_NODE_36663_length_264_cov_1.633508_g36378_i0	PRJNA688736	36663	264	1.633508	4.31246112	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	483	7.219999999999998e-132	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g36378	i0	99.621	396.234848484848	264	1	100	0	1	264	79710	79973	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	104606	483	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
4495494	4495494	PRJNA688736_P_NODE_20224_length_347_cov_1.423358_g19939_i0	PRJNA688736	20224	347	1.423358	4.93905226	Nocardioides sp. HDW12B	2714939	Bacteria	Bacteria	514	3.49e-141	NTclustered	gi\|1821124102\|gb\|CP049867.1\|	2714939	g19939	i0	93.429	198.887608069164	350	18	99	4	1	346	2038619	2038271	Nocardioides sp. HDW12B chromosome, complete genome	blastn	69014	514	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. HDW12B
6281980	6281980	PRJNA688736_P_NODE_8205_length_517_cov_1.858108_g7922_i0	PRJNA688736	8205	517	1.858108	9.60641836	Microbacterium	33882	Bacteria	Bacteria	905	0	NTclustered	gi\|2175339957\|gb\|CP090347.1\|	462710	g7922	i0	98.263	175.947775628627	518	8	100	1	1	517	1046392	1045875	Microbacterium binotii strain Au-Mic3 chromosome, complete genome	blastn	90965	911	0.993413830954994	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium binotii
7555731	7555731	PRJNA688736_P_NODE_45646_length_247_cov_0.896552_g45361_i0	PRJNA688736	45646	247	0.896552	2.21448344	Rhodococcus	1827	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1823517382\|gb\|CP050124.1\|	1833	g45361	i0	100	49.9109311740891	247	0	100	0	1	247	2914224	2913978	Rhodococcus erythropolis strain KB1 chromosome, complete genome	blastn	12328	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
10106165	10106165	PRJNA688736_P_NODE_33548_length_277_cov_1.279412_g33263_i0	PRJNA688736	33548	277	1.279412	3.54397124	Collinsella	102106	Bacteria	Bacteria	412	1.0099999999999997e-110	NTclustered	gi\|2299381659\|gb\|CP102276.1\|	147206	g33263	i0	98.712	93.4548736462094	233	2	96	1	36	267	178465	178697	Collinsella stercoris strain DSM 13279 chromosome, complete genome	blastn	25887	412	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Coriobacteriaceae	Collinsella	Collinsella stercoris
10106391	10106391	PRJNA688736_P_NODE_43688_length_249_cov_0.886364_g43403_i0	PRJNA688736	43688	249	0.886364	2.20704636	Rhodococcoides	3259750	Bacteria	Bacteria	387	5.439999999999998e-103	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g43403	i0	94.758	2.99196787148594	248	13	99	0	2	249	4493938	4493691	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	745	388	0.997422680412371	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
10871742	10871742	PRJNA688736_P_NODE_28529_length_299_cov_1.380531_g28244_i0	PRJNA688736	28529	299	1.380531	4.12778769	uncultured Microthrixaceae bacterium	1798915	Bacteria	Bacteria	497	2.97e-136	NTclustered	gi\|2874253917\|emb\|OY970242.1\|	1798915	g28244	i0	96.678	95.5652173913043	301	6	100	3	1	299	1276177	1275879	MAG: uncultured Microthrixaceae bacterium isolate MFD03066.bin.2.142 genome assembly, chromosome: 1	blastn	28574	497	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Microthrixaceae		uncultured Microthrixaceae bacterium
10872048	10872048	PRJNA688736_P_NODE_41069_length_252_cov_0.871508_g40784_i0	PRJNA688736	41069	252	0.871508	2.19620016	Rhodococcoides fascians	1828	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1017211286\|gb\|CP015220.1\|	1828	g40784	i0	100	5.1984126984127	252	0	100	0	1	252	2608262	2608513	Rhodococcus sp. PBTS2, complete genome	blastn	1310	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
12147525	12147525	PRJNA688736_P_NODE_49370_length_243_cov_0.964706_g49085_i0	PRJNA688736	49370	243	0.964706	2.34423558	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	399	6.789999999999999e-107	NTclustered	gi\|2874253902\|emb\|OY970120.1\|	3039803	g49085	i0	96.296	366.041152263374	243	9	100	0	1	243	2861056	2861298	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.22 genome assembly, chromosome: 1	blastn	88948	399	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
12656810	12656810	PRJNA688736_P_NODE_26630_length_308_cov_2.668085_g26345_i0	PRJNA688736	26630	308	2.668085	8.2177018	Microbacterium	33882	Bacteria	Bacteria	569	6.419999999999998e-158	NTclustered	gi\|470475773\|ref\|NR_076300.1\|	2033	g26345	i0	100	204.948051948052	308	0	100	0	1	308	1667	1360	Microbacterium testaceum strain StLB037 23S ribosomal RNA gene, complete sequence	blastn	63124	569	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
13931724	13931724	PRJNA688736_P_NODE_43851_length_249_cov_0.886364_g43566_i0	PRJNA688736	43851	249	0.886364	2.20704636	Rhodococcus	1827	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g43566	i0	99.598	49	249	1	100	0	1	249	182718	182966	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	12201	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
15206325	15206325	PRJNA688736_P_NODE_39372_length_254_cov_1.458564_g39087_i0	PRJNA688736	39372	254	1.458564	3.70475256	Bifidobacterium	1678	Bacteria	Bacteria	309	1.24e-79	NTclustered	gi\|1539944830\|emb\|LR134344.1\|	1681	g39087	i0	88.716	309.291338582677	257	23	100	6	1	254	523225	523478	Bifidobacterium bifidum strain NCTC13001 genome assembly, chromosome: 1	blastn	78560	309	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium bifidum
15206373	15206373	PRJNA688736_P_NODE_41892_length_251_cov_0.876404_g41607_i0	PRJNA688736	41892	251	0.876404	2.19977404	Mycobacteriales	85007	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1780479987\|gb\|CP046322.1\|	1725	g41607	i0	100	62.398406374502	251	0	100	0	1	251	887716	887466	Corynebacterium xerosis strain FDAARGOS_674 chromosome, complete genome	blastn	15662	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium xerosis
15206599	15206599	PRJNA688736_P_NODE_7972_length_523_cov_2.244444_g7689_i0	PRJNA688736	7972	523	2.244444	11.73844212	Cutibacterium	1912216	Bacteria	Bacteria	966	0	NTclustered	gi\|2493038017\|gb\|CP114010.1\|	1747	g7689	i0	100	240.793499043977	523	0	100	0	1	523	606831	607353	Cutibacterium acnes strain CBS-BPNBT19329 chromosome, complete genome	blastn	125935	966	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16480012	16480012	PRJNA688736_P_NODE_18073_length_364_cov_1.505155_g17788_i0	PRJNA688736	18073	364	1.505155	5.4787642	Bifidobacterium	1678	Bacteria	Bacteria	355	2.35e-93	NTclustered	gi\|507148202\|ref\|NR_103009.1\|	1684	g17788	i0	84.595	248.313186813187	370	44	99	9	2	364	44	407	Bifidobacterium asteroides strain PRL2011 23S ribosomal RNA gene, complete sequence	blastn	90386	355	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium asteroides
18520266	18520266	PRJNA688736_P_NODE_49555_length_243_cov_0.917647_g49270_i0	PRJNA688736	49555	243	0.917647	2.22988221	Agromyces soli	659012	Bacteria	Bacteria	346	8.97e-91	NTclustered	gi\|2216365065\|gb\|CP094533.1\|	659012	g49270	i0	92.857	8.01234567901234	238	17	98	0	6	243	579872	580109	Agromyces soli strain KACC 16215 chromosome, complete genome	blastn	1947	346	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agromyces	Agromyces soli
19794780	19794780	PRJNA688736_P_NODE_35436_length_269_cov_1.377551_g35151_i0	PRJNA688736	35436	269	1.377551	3.70561219	Corynebacterium afermentans	38286	Bacteria	Bacteria	488	1.5799999999999998e-133	NTclustered	gi\|2531251647\|gb\|CP046606.1\|	144183	g35151	i0	99.625	5.74349442379182	267	1	99	0	1	267	103114	102848	Corynebacterium afermentans subsp. afermentans strain DSM 44280 chromosome, complete genome	blastn	1545	488	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium afermentans
19795012	19795012	PRJNA688736_P_NODE_44836_length_248_cov_0.891429_g44551_i0	PRJNA688736	44836	248	0.891429	2.21074392	Blastococcus saxobsidens	138336	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|378781357\|emb\|FO117623.1\|	1146883	g44551	i0	96.97	0.133064516129032	33	0	13	1	204	235	3466071	3466039	Blastococcus saxobsidens DD2 complete genome	blastn	33	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
20304052	20304052	PRJNA688736_P_NODE_39056_length_255_cov_1.670330_g38771_i0	PRJNA688736	39056	255	1.67033	4.2593415	Propionibacteriales	85009	Bacteria	Bacteria	444	3.27e-120	NTclustered	gi\|470475867\|ref\|NR_076305.1\|	29405	g38771	i0	98.039	229.745098039216	255	5	100	0	1	255	284	30	Microlunatus phosphovorus strain NM-1 23S ribosomal RNA gene, complete sequence	blastn	58585	444	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus phosphovorus
20304306	20304306	PRJNA688736_P_NODE_5256_length_631_cov_2.413978_g4979_i0	PRJNA688736	5256	631	2.413978	15.23220118	Nocardiaceae	85025	Bacteria	Bacteria	970	0	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g4979	i0	98.543	337.259904912837	549	8	87	0	83	631	1710611	1710063	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	212811	970	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
21070546	21070546	PRJNA688736_P_NODE_45997_length_247_cov_0.896552_g45712_i0	PRJNA688736	45997	247	0.896552	2.21448344	Corynebacterium ihumii	1232427	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|2443258367\|gb\|CP063190.1\|	1232427	g45712	i0	98.785	11.82995951417	247	3	100	0	1	247	80642	80396	Corynebacterium ihumii strain DSM 45751 chromosome, complete genome	blastn	2922	440	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium ihumii
21070680	21070680	PRJNA688736_P_NODE_51497_length_229_cov_2.500000_g51212_i0	PRJNA688736	51497	229	2.5	5.725	Rhodococcoides fascians	1828	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g51212	i0	100	360.812227074236	229	0	100	0	1	229	1622902	1623130	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	82626	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
24894338	24894338	PRJNA688736_P_NODE_48040_length_245_cov_0.906977_g47755_i0	PRJNA688736	48040	245	0.906977	2.22209365	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g47755	i0	99.592	36.9510204081633	245	1	100	0	1	245	2128752	2128996	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	9053	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
25403674	25403674	PRJNA688736_P_NODE_17580_length_368_cov_2.033898_g17295_i0	PRJNA688736	17580	368	2.033898	7.48474464	Cutibacterium	1912216	Bacteria	Bacteria	680	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g17295	i0	100	272.986413043478	368	0	100	0	1	368	608655	609022	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	100459	680	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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