metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA682774" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA682774" 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
664636	664636	PRJNA682774_P_NODE_2581_length_287_cov_1.093458_g2552_i0	PRJNA682774	2581	287	1.093458	3.13822446	Mycolicibacterium phocaicum	319706	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g2552	i0	100	0.0975609756097561	28	0	10	0	121	148	2530054	2530027	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
664668	664668	PRJNA682774_P_NODE_4541_length_247_cov_0.896552_g4512_i0	PRJNA682774	4541	247	0.896552	2.21448344	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2777572590\|dbj\|AP031419.1\|	28026	g4512	i0	99.595	30.9392712550607	247	1	100	0	1	247	1289408	1289654	Bifidobacterium pseudocatenulatum i02-0019-A2 DNA, complete genome	blastn	7642	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
1940653	1940653	PRJNA682774_P_NODE_4542_length_247_cov_0.896552_g4513_i0	PRJNA682774	4542	247	0.896552	2.21448344	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2777572590\|dbj\|AP031419.1\|	28026	g4513	i0	99.595	26.6437246963563	247	1	100	0	1	247	1627524	1627278	Bifidobacterium pseudocatenulatum i02-0019-A2 DNA, complete genome	blastn	6581	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
4492587	4492587	PRJNA682774_P_NODE_3584_length_252_cov_0.871508_g3555_i0	PRJNA682774	3584	252	0.871508	2.19620016	Microbacterium maritypicum	33918	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2274432258\|gb\|CP101471.1\|	33918	g3555	i0	100	11.6388888888889	252	0	100	0	1	252	1188232	1188483	Microbacterium maritypicum strain DND4 chromosome, complete genome	blastn	2933	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
5003119	5003119	PRJNA682774_P_NODE_4424_length_247_cov_0.896552_g4395_i0	PRJNA682774	4424	247	0.896552	2.21448344	root	1	Root_unresolved	Root_unresolved	451	1.88e-122	NTclustered	gi\|1434131788\|gb\|MH669264.1\|	1818	g4395	i0	99.597	107.449392712551	248	0	100	1	1	247	86	333	Nocardia globerula strain H88 16S ribosomal RNA gene, partial sequence	blastn	26540	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia globerula
7043323	7043323	PRJNA682774_P_NODE_3846_length_251_cov_0.876404_g3817_i0	PRJNA682774	3846	251	0.876404	2.19977404	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2119983138\|gb\|CP079231.1\|	28026	g3817	i0	99.203	14.7091633466135	251	2	100	0	1	251	135550	135300	Bifidobacterium pseudocatenulatum strain YIT12820 chromosome, complete genome	blastn	3692	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
7043343	7043343	PRJNA682774_P_NODE_4966_length_244_cov_0.912281_g4937_i0	PRJNA682774	4966	244	0.912281	2.22596564	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|2473732839\|gb\|CP092470.1\|	28026	g4937	i0	99.59	10.25	244	1	100	0	1	244	115972	115729	Bifidobacterium pseudocatenulatum strain Bi-OTA128 chromosome, complete genome	blastn	2501	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
7552609	7552609	PRJNA682774_P_NODE_3726_length_251_cov_1.640449_g3697_i0	PRJNA682774	3726	251	1.640449	4.11752699	Bacteria	2	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1082320433\|gb\|CP016795.1\|	47716	g3697	i0	96.97	16.7569721115538	33	1	13	0	39	71	4326120	4326088	Streptomyces olivaceus strain KLBMP 5084 chromosome, complete genome	blastn	4206	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces olivaceus
8827602	8827602	PRJNA682774_P_NODE_2127_length_310_cov_0.822785_g2098_i0	PRJNA682774	2127	310	0.822785	2.5506335	Geodermatophilaceae	85030	Bacteria	Bacteria	568	2.3299999999999995e-157	NTclustered	gi\|1345370482\|gb\|MG966308.1\|	38502	g2098	i0	99.677	99.2903225806452	310	1	100	0	1	310	11	320	Blastococcus aggregatus strain POA05 16S ribosomal RNA gene, partial sequence	blastn	30780	573	0.991273996509599	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus aggregatus
8827610	8827610	PRJNA682774_P_NODE_3447_length_253_cov_0.866667_g3418_i0	PRJNA682774	3447	253	0.866667	2.19266751	Bifidobacterium	1678	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|2006561467\|gb\|CP071684.1\|	1679	g3418	i0	99.605	100	253	1	100	0	1	253	1288448	1288196	Bifidobacterium longum subsp. longum strain JCM 11342 chromosome, complete genome	blastn	25300	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
8827614	8827614	PRJNA682774_P_NODE_3947_length_250_cov_0.881356_g3918_i0	PRJNA682774	3947	250	0.881356	2.20339	Bifidobacterium	1678	Bacteria	Bacteria	460	3.17e-125	NTclustered	gi\|1866614236\|gb\|CP029796.1\|	1679	g3918	i0	100	99.964	249	0	99	0	1	249	1516873	1516625	Bifidobacterium longum subsp. longum strain YS108R chromosome, complete genome	blastn	24991	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
8827623	8827623	PRJNA682774_P_NODE_4927_length_245_cov_0.906977_g4898_i0	PRJNA682774	4927	245	0.906977	2.22209365	Microbacterium	33882	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1547062844\|gb\|CP031422.1\|	82380	g4898	i0	100	23.7183673469388	245	0	100	0	1	245	3044827	3044583	Microbacterium oxydans strain HG3 chromosome, complete genome	blastn	5811	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium oxydans
9593244	9593244	PRJNA682774_P_NODE_1828_length_331_cov_2.139535_g1799_i0	PRJNA682774	1828	331	2.139535	7.08186085	Microbacterium sp. BH-3-3-3	1906742	Bacteria	Bacteria	579	1.1599999999999996e-160	NTclustered	gi\|1084379694\|gb\|CP017674.1\|	1906742	g1799	i0	98.187	192.601208459214	331	6	100	0	1	331	485138	485468	Microbacterium sp. BH-3-3-3 chromosome, complete genome	blastn	63751	579	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. BH-3-3-3
10103364	10103364	PRJNA682774_P_NODE_3588_length_252_cov_0.871508_g3559_i0	PRJNA682774	3588	252	0.871508	2.19620016	Cutibacterium	1912216	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g3559	i0	99.603	51.3174603174603	252	1	100	0	1	252	2491238	2490987	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	12932	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12144041	12144041	PRJNA682774_P_NODE_4630_length_246_cov_0.901734_g4601_i0	PRJNA682774	4630	246	0.901734	2.21826564	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	241	4.42e-59	NTclustered	gi\|2874253667\|emb\|OY969101.1\|	3039803	g4601	i0	84.711	13.2154471544715	242	35	98	2	1	241	4401588	4401828	MAG: uncultured Actinomycetota bacterium isolate MFD04212.bin.c.6 genome assembly, chromosome: 1	blastn	3251	241	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
12144053	12144053	PRJNA682774_P_NODE_5330_length_242_cov_1.242604_g5301_i0	PRJNA682774	5330	242	1.242604	3.00710168	Crossiella sp. CA-258035	2981138	Bacteria	Bacteria	58.4	4.69e-4	NTclustered	gi\|2509236845\|gb\|CP116413.1\|	2981138	g5301	i0	100	0.128099173553719	31	0	13	0	205	235	1143225	1143195	Crossiella sp. CA-258035 chromosome, complete genome	blastn	31	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Crossiella	Crossiella sp. CA-258035
13418609	13418609	PRJNA682774_P_NODE_2911_length_272_cov_1.175879_g2882_i0	PRJNA682774	2911	272	1.175879	3.19839088	Bifidobacterium catenulatum	1686	Bacteria	Bacteria	484	2.0799999999999996e-132	NTclustered	gi\|730564789\|gb\|CP007456.1\|	1447716	g2882	i0	98.897	38.7573529411765	272	2	100	1	1	272	1862447	1862177	Bifidobacterium kashiwanohense PV20-2, complete genome	blastn	10542	484	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium catenulatum
13418645	13418645	PRJNA682774_P_NODE_4811_length_245_cov_0.906977_g4782_i0	PRJNA682774	4811	245	0.906977	2.22209365	Collinsella aerofaciens	74426	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1526295663\|gb\|CP024960.1\|	74426	g4782	i0	100	12.5795918367347	245	0	100	0	1	245	644094	643850	Collinsella aerofaciens strain C11 chromosome, complete genome	blastn	3082	453	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Coriobacteriaceae	Collinsella	Collinsella aerofaciens
14693618	14693618	PRJNA682774_P_NODE_4472_length_247_cov_0.896552_g4443_i0	PRJNA682774	4472	247	0.896552	2.21448344	Micrococcus antarcticus	86171	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|2851356301\|gb\|CP085253.1\|	86171	g4443	i0	99.19	2	247	2	100	0	1	247	204355	204601	Micrococcus antarcticus strain ABH-515 chromosome, complete genome	blastn	494	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus antarcticus
14693632	14693632	PRJNA682774_P_NODE_5232_length_243_cov_0.917647_g5203_i0	PRJNA682774	5232	243	0.917647	2.22988221	Collinsella aerofaciens	74426	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|1721134214\|emb\|LR699016.1\|	74426	g5203	i0	98.354	7.9917695473251	243	4	100	0	1	243	1719024	1718782	Collinsella aerofaciens isolate MGYG-HGUT-02539 genome assembly, chromosome: 1	blastn	1942	427	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Coriobacteriaceae	Collinsella	Collinsella aerofaciens
15967378	15967378	PRJNA682774_P_NODE_4133_length_249_cov_0.886364_g4104_i0	PRJNA682774	4133	249	0.886364	2.20704636	Bifidobacterium breve	1685	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1143275817\|gb\|CP019596.1\|	1685	g4104	i0	99.598	11	249	1	100	0	1	249	1817750	1817998	Bifidobacterium breve strain LMC520, complete genome	blastn	2739	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium breve
16477548	16477548	PRJNA682774_P_NODE_2853_length_275_cov_1.158416_g2824_i0	PRJNA682774	2853	275	1.158416	3.185644	Bifidobacterium	1678	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2006561467\|gb\|CP071684.1\|	1679	g2824	i0	100	99.9272727272727	275	0	100	0	1	275	1829280	1829554	Bifidobacterium longum subsp. longum strain JCM 11342 chromosome, complete genome	blastn	27480	508	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
16477555	16477555	PRJNA682774_P_NODE_4693_length_246_cov_0.901734_g4664_i0	PRJNA682774	4693	246	0.901734	2.21826564	Bifidobacterium	1678	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1064281795\|gb\|CP016019.1\|	1679	g4664	i0	100	100	246	0	100	0	1	246	470280	470035	Bifidobacterium longum subsp. longum strain AH1206 chromosome, complete genome	blastn	24600	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
17242566	17242566	PRJNA682774_P_NODE_1974_length_320_cov_1.263158_g1945_i0	PRJNA682774	1974	320	1.263158	4.0421056	Blastococcus montanus	3144973	Bacteria	Bacteria	531	3.16e-146	NTclustered	gi\|2734204614\|gb\|CP155551.1\|	3144973	g1945	i0	96.845	320.49375	317	10	99	0	1	317	164206	164522	Blastococcus montanus strain HT6-4 chromosome, complete genome	blastn	102558	531	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus montanus
17242610	17242610	PRJNA682774_P_NODE_4894_length_245_cov_0.906977_g4865_i0	PRJNA682774	4894	245	0.906977	2.22209365	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2179090907\|gb\|CP090598.1\|	28026	g4865	i0	100	294.910204081633	245	0	100	0	1	245	2162477	2162721	Bifidobacterium pseudocatenulatum strain JCLA3 chromosome, complete genome	blastn	72253	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
17752544	17752544	PRJNA682774_P_NODE_3634_length_252_cov_0.871508_g3605_i0	PRJNA682774	3634	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	466	6.89e-127	NTclustered	gi\|1979349502\|gb\|CP069279.1\|	1681	g3605	i0	100	21	252	0	100	0	1	252	1828219	1828470	Bifidobacterium bifidum strain HN002 chromosome, complete genome	blastn	5292	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium bifidum
17752545	17752545	PRJNA682774_P_NODE_3774_length_251_cov_0.876404_g3745_i0	PRJNA682774	3774	251	0.876404	2.19977404	Bifidobacterium	1678	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1917212770\|gb\|CP062949.1\|	1679	g3745	i0	100	99.4661354581673	251	0	100	0	1	251	634699	634449	Bifidobacterium longum subsp. longum strain JCM 7050 chromosome, complete genome	blastn	24966	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
18516741	18516741	PRJNA682774_P_NODE_3655_length_252_cov_0.871508_g3626_i0	PRJNA682774	3655	252	0.871508	2.19620016	Amycolatopsis rhabdoformis	1448059	Bacteria	Bacteria	169	2.17e-37	NTclustered	gi\|2652389684\|gb\|CP142149.1\|	1448059	g3626	i0	81.818	82.3015873015873	220	22	84	16	13	223	5719613	5719403	Amycolatopsis rhabdoformis strain NCIMB 14900 chromosome, complete genome	blastn	20740	169	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis rhabdoformis
19026436	19026436	PRJNA682774_P_NODE_2615_length_285_cov_1.103774_g2586_i0	PRJNA682774	2615	285	1.103774	3.1457559	Bifidobacterium	1678	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|2006561467\|gb\|CP071684.1\|	1679	g2586	i0	100	99.9929824561404	285	0	100	0	1	285	324426	324710	Bifidobacterium longum subsp. longum strain JCM 11342 chromosome, complete genome	blastn	28498	527	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
19026437	19026437	PRJNA682774_P_NODE_275_length_827_cov_1.541114_g250_i0	PRJNA682774	275	827	1.541114	12.74501278	Blastococcus	38501	Bacteria	Bacteria	1184	0	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g250	i0	94.875	348.883917775091	761	33	99	6	66	822	821	1579	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	288527	1188	0.996632996632997	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
19026439	19026439	PRJNA682774_P_NODE_3395_length_253_cov_1.300000_g3366_i0	PRJNA682774	3395	253	1.3	3.289	Bifidobacterium	1678	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|2006561467\|gb\|CP071684.1\|	1679	g3366	i0	100	97.9486166007905	253	0	100	0	1	253	515537	515789	Bifidobacterium longum subsp. longum strain JCM 11342 chromosome, complete genome	blastn	24781	468	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
21576894	21576894	PRJNA682774_P_NODE_2397_length_294_cov_1.488688_g2368_i0	PRJNA682774	2397	294	1.488688	4.37674272	Microbacterium	33882	Bacteria	Bacteria	544	3.69e-150	NTclustered	gi\|1154509326\|gb\|CP019892.1\|	104336	g2368	i0	100	170	294	0	100	0	1	294	2457906	2457613	Microbacterium foliorum strain 122 chromosome	blastn	49980	544	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium foliorum
24890819	24890819	PRJNA682774_P_NODE_4580_length_247_cov_0.890805_g4551_i0	PRJNA682774	4580	247	0.890805	2.20028835	Microbacterium sp. Y-01	2048898	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1526304102\|gb\|CP024170.1\|	2048898	g4551	i0	100	29.1012145748988	247	0	100	0	1	247	1159238	1159484	Microbacterium sp. Y-01 chromosome, complete genome	blastn	7188	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. Y-01

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